DW_GIC_FUN_TRX_HEADERS_CF (Preview)

This table requires activation of Global Intercompany functional area. This tables contains the transactions that make up an intercompany transaction batch.

Details

Module:

Key Columns

TRX_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
TRX_ID NUMBER 38 0 True Transaction identifier of the intercompany transaction.
SOURCE_RECORD_ID VARCHAR2 64 This column is for Oracle Internal use only. Source record identifier.
BATCH_ID NUMBER 38 0 Unique system generated identifier for the batch.
BATCH_DATE DATE The date used for processing the intercompany batch. DW_FISCAL_DAY_D FISCAL_DAY_DATE
BATCH_NUMBER VARCHAR2 32 Number assigned to the intercompany batch.
CURRENCY_CODE VARCHAR2 16 Currency of the batch. Transactions in a batch must be in the same currency.
BATCH_DESCRIPTION VARCHAR2 256 Transaction type of this batch. All transactions in a batch must be of the same type.
EXCHANGE_RATE_TYPE VARCHAR2 32 Conversion rate to use if batch is not in the provider's base currency
FROM_LEDGER_ID NUMBER 38 0 Unique system generated identifier for the provider ledger. DW_LEDGER_D LEDGER_ID
LEDGER_CURRENCY_CODE VARCHAR2 16 Functional currency of the ledger.
FROM_LE_ID NUMBER 38 0 Unique system generated identifier for the provider legal entity. DW_LEGAL_ENTITY_D LEGAL_ENTITY_ID
GL_DATE DATE Accounting date of the intercompany batch. DW_FISCAL_DAY_D FISCAL_DAY_DATE
INITIATOR_ID NUMBER 38 0 Unique system generated identifier for the provider organization. DW_GIC_FUN_INTERCO_ORG_D INTERCO_ORG_ID
NOTE VARCHAR2 256 Comments entered by the provider intercompany organization.
BATCH_STATUS VARCHAR2 32 Status of the intercompany batch DW_GIC_FUN_BATCH_STATUS_LKP_TL FUN_BATCH_STATUS_CODE
TRX_TYPE_ID NUMBER 38 0 Transaction type of this batch. All transactions in a batch must be of the same type. DW_GIC_FUN_TRX_TYPES_D TRX_TYPE_ID
BATCH_CREATION_DATE TIMESTAMP Who column: indicates the date and time of the creation of the row. DW_FISCAL_DAY_D FISCAL_DAY_DATE
BATCH_CREATED_BY VARCHAR2 128 Who column: indicates the user who created the row.
BATCH_LAST_UPDATE_DATE TIMESTAMP Who column: indicates the date and time of the last update of the row. DW_FISCAL_DAY_D FISCAL_DAY_DATE
BATCH_LAST_UPDATED_BY VARCHAR2 128 Who column: indicates the user who last updated the row.
APPROVAL_DATE DATE Approval date of the intercompany transaction. DW_FISCAL_DAY_D FISCAL_DAY_DATE
APPROVER_ID VARCHAR2 128 The latest principal username of the user DW_USER_D USERNAME
AR_INVOICE_NUMBER VARCHAR2 64 Receivables invoice number for the intercompany transaction.
AR_INV_CM_TRX_TYPE_ID NUMBER 38 0 Receivables transaction type or credit memo type identifier. DW_AR_TRANSACTION_TYPES_D CUST_TRX_TYPE_SEQ_ID
HEADER_DESCRIPTION VARCHAR2 256 Intercompany header description
ERROR_REASON VARCHAR2 999 Intercompany transaction error reason.
RECIPIENT_ID NUMBER 38 0 Receiver identifier of the intercompany transaction. DW_GIC_FUN_INTERCO_ORG_D INTERCO_ORG_ID
REJECT_REASON VARCHAR2 256 Rejection reason for the intercompany transaction.
TRX_STATUS VARCHAR2 32 Import status code of the intercompany interface distribution. DW_GIC_FUN_TRX_STATUS_LKP_TL FUN_TRX_STATUS_CODE
TO_LEDGER_ID NUMBER 38 0 Intercompany receiver ledger identifier. DW_LEDGER_D LEDGER_ID
TO_LE_ID NUMBER 38 0 Receiver legal entity identifier. DW_LEGAL_ENTITY_D LEGAL_ENTITY_ID
TRX_NUMBER NUMBER Transaction number of the intercompany transaction.
AP_INVOICE_NUMBER VARCHAR2 64 Unique number for supplier invoice.
TRX_CREATION_DATE TIMESTAMP Who column: indicates the date and time of the creation of the row. DW_FISCAL_DAY_D FISCAL_DAY_DATE
TRX_CREATION_DATE_1 DATE Who column: indicates the date of the creation of the row. DW_FISCAL_DAY_D FISCAL_DAY_DATE
TRX_CREATED_BY VARCHAR2 128 Who column: indicates the user who created the row.
TRX_LAST_UPDATE_DATE TIMESTAMP Who column: indicates the date and time of the last update of the row. DW_FISCAL_DAY_D FISCAL_DAY_DATE
TRX_LAST_UPDATED_BY VARCHAR2 128 Who column: indicates the user who last updated the row.
INVOICE_FLAG VARCHAR2 16 Invoice flag for the intercompany transaction. DW_YN_LKP_TL YN_LKP_CODE
RECEIVER_JE_HEADER_ID NUMBER 38 0 Journal entry header identifier of the receiver.
RECEIVER_JE_HEADER_STATUS VARCHAR2 16 Receiver - Journal entry header status lookup code. DW_GL_JOURNAL_STATUS_LKP_TL GL_JOURNAL_STATUS_LKP_CODE
RECEIVER_JE_HEADER_NAME VARCHAR2 128 Receiver - User entered journal header name.
RECEIVER_JE_BATCHES_DESCRIPTION VARCHAR2 256 Receiver - Journal entry batch description.
RECEIVER_JE_BATCHES_NAME VARCHAR2 128 Receiver - User entered journal batch name.
RECEIVER_JE_POSTED_DATE DATE Receiver - Date journal entry header was posted. DW_FISCAL_DAY_D FISCAL_DAY_DATE
PROVIDER_JE_HEADER_ID NUMBER 38 0 Journal entry header identifier of the provider.
PROVIDER_JE_HEADER_STATUS VARCHAR2 16 Provider - Journal entry header status lookup code. DW_GL_JOURNAL_STATUS_LKP_TL GL_JOURNAL_STATUS_LKP_CODE
PROVIDER_JE_HEADER_NAME VARCHAR2 128 Provider - User entered journal header name.
PROVIDER_JE_BATCHES_DESCRIPTION VARCHAR2 256 Provider - Journal entry batch description.
PROVIDER_JE_BATCHES_NAME VARCHAR2 128 Provider - User entered journal batch name.
PROVIDER_JE_POSTED_DATE DATE Provider - Date journal entry header was posted. DW_FISCAL_DAY_D FISCAL_DAY_DATE
AR_CUSTOMER_TRX_ID NUMBER 38 0 Transaction identifier.
AR_TRX_NUMBER VARCHAR2 32 Transaction number.
AR_TRX_BU_ORG_ID NUMBER 38 0 Indicates the identifier of the business unit associated to the row. DW_INTERNAL_ORG_D ORGANIZATION_ID
AR_TRX_ACCOUNTING_STATUS_FLAG VARCHAR2 16 Deriving based on GL_POSTED_DATE column
AR_TRX_DATE DATE Transaction date. DW_FISCAL_DAY_D FISCAL_DAY_DATE
AR_GL_DATE DATE Accounting date. DW_FISCAL_DAY_D FISCAL_DAY_DATE
AR_LEDGER_ID NUMBER 38 0 AR - Identifies the ledger associated with the distribution line. DW_LEDGER_D LEDGER_ID
AR_FISCAL_PERIOD_SET_NAME VARCHAR2 16 AR - Accounting calendar name.
AR_FISCAL_PERIOD_TYPE VARCHAR2 16 AR - Accounting period type.
AP_INVOICE_ID NUMBER 38 0 Invoice identifier.
AP_INVOICE_TYPE_LOOKUP_CODE VARCHAR2 32 Invoice type. Possible values are STANDARD, CREDIT, DEBIT, PAYMENT REQUEST, PREPAYMENT, INTEREST, INVOICE REQUEST, AWT, CREDIT MEMO REQUEST, EXPENSE REPORT, MIXED, and so on. DW_AP_INVOICE_TYPE_LKP_TL CODE_TYPE,AP_INVOICE_TYPE_LKP_CODE,LANGUAGE
AP_INV_BU_ORG_ID NUMBER 38 0 Business Unit Identifier DW_INTERNAL_ORG_D ORGANIZATION_ID
AP_INV_ACCOUNTING_STATUS_CODE VARCHAR2 32 DW_AP_ACCOUNTING_STATUS_LKP_TL CODE_TYPE,AP_ACCOUNTING_STATUS_LKP_CODE,LANGUAGE
AP_INVOICE_DATE DATE Date when an event will occur or occurred. DW_FISCAL_DAY_D FISCAL_DAY_DATE
AP_GL_DATE DATE Accounting date to default to invoice distributions DW_FISCAL_DAY_D FISCAL_DAY_DATE
AP_LEDGER_ID NUMBER 38 0 AP - Ledger identifier of the invoice. DW_LEDGER_D LEDGER_ID
AP_FISCAL_PERIOD_SET_NAME VARCHAR2 16 AP - Accounting calendar name.
AP_FISCAL_PERIOD_TYPE VARCHAR2 16 AP - Accounting period type.
BATCH_RUNNING_TOTAL_DR BIGDECIMAL 10 Sum of the debit amount for all transactions in the batch.
BATCH_RUNNING_TOTAL_CR BIGDECIMAL 10 Sum of the credit amount for all transactions in the batch.
BATCH_AMOUNT BIGDECIMAL 10 debit amount minus credit for all transactions in the batch.
BATCH_CONTROL_TOTAL BIGDECIMAL 10 Entered by the user as a placeholder to indicate the amount they would like the batch to add up to. It is not the total of all the transaction amounts in the batch.
TRX_INIT_AMOUNT_CR BIGDECIMAL 10 Intercompany provider credit amount.
TRX_INIT_AMOUNT_DR BIGDECIMAL 10 Intercompany provider debit amount.
TRX_NET_AMOUNT BIGDECIMAL 10 debit amount minus credit amount for transaction.
TRX_DUE_TO_FROM_AMOUNT BIGDECIMAL 10 Transaction amount in due to or due from currency. This is the amount received by the receiver organization.