1. Tables and Views for Financials
  2. JG_EXG_RATE_DIF

JG_EXG_RATE_DIF

JG_EXG_RATE_DIF contains records that are eligible to create invoice or journal and they will be populated by the Process Exchange Rate differences process.

Details

  • Schema: FUSION

  • Object owner: JG

  • Object type: TABLE

  • Tablespace: FUSION_TS_TX_DATA

Primary Key

Name Columns

JG_EXG_RATE_DIF_PK

ER_DIF_ID

Columns

Name Datatype Length Precision Not-null Comments
ER_DIF_ID NUMBER 18 Yes Unique identifier for each record in table.
AE_HEADER_ID NUMBER 18 Yes Identifier of accounting entry.
PARTY_ID NUMBER 18 Yes Party identifier.
PARTY_NAME VARCHAR2 360 Yes Name of this party.
PARTY_SITE_ID NUMBER 18 Yes Party site identifier.
PARTY_SITE_NAME VARCHAR2 240 Yes Customer or supplier site name.
TRX_TYPE VARCHAR2 30 Yes Unique abbreviated name assigned to an event type and used for reporting or in reference to an option.
ACCT_CLASS_CODE VARCHAR2 30 Yes Account type of transaction for which distribution is posted.
SOURCE_ID NUMBER 18 Yes Invoice or transaction identifier.
SOURCE_NUM VARCHAR2 50 Yes Invoice or transaction number.
TOTAL_ERD_AMT NUMBER Total exchange rate difference amount.
TOTAL_TAX_AMT NUMBER Total exchange rate difference tax amount.
SOURCE_REC_ID NUMBER 18 Yes Payment or receipt identifier.
SOURCE_REC_NUM VARCHAR2 30 Yes Payment or receipt number.
APPLICATION_ID NUMBER 18 Yes Application identifier.
PERIOD_NAME VARCHAR2 15 Yes Accounting period name.
LEDGER_ID NUMBER 18 Yes Set of books identifier.
LEGAL_ENTITY_ID NUMBER 18 Yes Legal entity identifier.
ORG_ID NUMBER 18 Yes Indicates the identifier of the business unit associated to the row.
SOURCE_DATE DATE Yes Invoice or transaction date.
JOURNAL_CATEGORY VARCHAR2 25 Journal category name unique identifier.
TERMS_ID NUMBER 18 A unique identifier for the payment term.
EVENT_ID NUMBER 18 Yes Identifier of the categorization of accounting events that is unique within an application and event class.
CREATION_OPTION_CODE VARCHAR2 30 Yes Create option of record. Possible values are INV or JOUR.
CREATE_FLAG VARCHAR2 1 Yes Creation status of record. Possible values are Y or N.
REFERENCE_NUMBER VARCHAR2 360 Unique reference number generated by the program.
SOURCE_REC_DATE DATE Date on which payment or receipt made and mentioned on payment or receipt document.
EVENT_TYPE_CODE VARCHAR2 30 Yes Unique abbreviated name assigned to an event type and used for reporting or in reference to an option.
REVERSAL_INV_PMT_ID NUMBER 18 Identifier for invoice payment reversed through current invoice payment.
AE_LINES_CCID NUMBER 18 Accounting code combination identifier.
PARTY_CUST_SITE_ID NUMBER 18 Customer site identifier.
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row.
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row.
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row.
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row.
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row.
REQUEST_ID NUMBER 18 Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row.
OBJECT_VERSION_NUMBER NUMBER 9 Yes Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.

Indexes

Index Uniqueness Tablespace Columns
JG_EXG_RATE_DIF_N1 Non Unique Default PERIOD_NAME, APPLICATION_ID
JG_EXG_RATE_DIF_U1 Unique Default ER_DIF_ID