DW_GIC_FUN_TRX_DISTRIBUTIONS_CF (Preview)

This table requires activation of Global Intercompany functional area. This table stores the distributions for the Intercompany transactions

Details

Module:

Key Columns

DIST_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
DIST_ID NUMBER 38 0 True Intercompany distribution identifier.
SOURCE_RECORD_ID VARCHAR2 64 This column is for Oracle Internal use only. Source record identifier.
TRX_ID NUMBER 38 0 Transaction identifier of the intercompany transaction.
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.
CODE_COMBINATION_ID NUMBER 38 0 Intercompany distribution account code combination. DW_GL_CODE_COMBINATION_D CODE_COMBINATION_ID
GL_BALANCING_SEGMENT VARCHAR2 32 Balancing segment for the ledger. DW_COST_CENTER_D COST_CENTER_SEGMENT
GL_BLNC_SGMNT_VALUESET_CODE VARCHAR2 64 Balancing segment value set code. DW_COST_CENTER_D COST_CENTER_VALUESET_CODE
COST_CENTER_SEGMENT VARCHAR2 32 Cost center segment. DW_BALANCING_SEGMENT_D GL_BALANCING_SEGMENT
COST_CENTER_VALUESET_CODE VARCHAR2 64 Cost center value set code. DW_BALANCING_SEGMENT_D GL_BLNC_SGMNT_VALUESET_CODE
NATURAL_ACCOUNT_SEGMENT VARCHAR2 32 Natural account segment. DW_NATURAL_ACCOUNT_D NATURAL_ACCOUNT_SEGMENT
NTRL_ACNT_SGMNT_VALUESET_CODE VARCHAR2 64 Natural account value set code. DW_NATURAL_ACCOUNT_D NTRL_ACNT_SGMNT_VALUESET_CODE
GL_SEGMENT1 VARCHAR2 32 Accounting segment 1. DW_GL_SEGMENT1_D GL_SEGMENT_CODE
GL_SEGMENT1_VALUESET_CODE VARCHAR2 64 Accounting segment 1 value set code. DW_GL_SEGMENT1_D GL_SEGMENT_VALUESET_CODE
GL_SEGMENT2 VARCHAR2 32 Accounting segment 2. DW_GL_SEGMENT2_D GL_SEGMENT_CODE
GL_SEGMENT2_VALUESET_CODE VARCHAR2 64 Accounting segment 2 value set code. DW_GL_SEGMENT2_D GL_SEGMENT_VALUESET_CODE
GL_SEGMENT3 VARCHAR2 32 Accounting segment 3. DW_GL_SEGMENT3_D GL_SEGMENT_CODE
GL_SEGMENT3_VALUESET_CODE VARCHAR2 64 Accounting segment 3 value set code. DW_GL_SEGMENT3_D GL_SEGMENT_VALUESET_CODE
GL_SEGMENT4 VARCHAR2 32 Accounting segment 4. DW_GL_SEGMENT4_D GL_SEGMENT_CODE
GL_SEGMENT4_VALUESET_CODE VARCHAR2 64 Accounting segment 4 value set code. DW_GL_SEGMENT4_D GL_SEGMENT_VALUESET_CODE
GL_SEGMENT5 VARCHAR2 32 Accounting segment 5. DW_GL_SEGMENT5_D GL_SEGMENT_CODE
GL_SEGMENT5_VALUESET_CODE VARCHAR2 64 Accounting segment 5 value set code. DW_GL_SEGMENT5_D GL_SEGMENT_VALUESET_CODE
GL_SEGMENT6 VARCHAR2 32 Accounting segment 6. DW_GL_SEGMENT6_D GL_SEGMENT_CODE
GL_SEGMENT6_VALUESET_CODE VARCHAR2 64 Accounting segment 6 value set code. DW_GL_SEGMENT6_D GL_SEGMENT_VALUESET_CODE
GL_SEGMENT7 VARCHAR2 32 Accounting segment 7. DW_GL_SEGMENT7_D GL_SEGMENT_CODE
GL_SEGMENT7_VALUESET_CODE VARCHAR2 64 Accounting segment 7 value set code. DW_GL_SEGMENT7_D GL_SEGMENT_VALUESET_CODE
GL_SEGMENT8 VARCHAR2 32 Accounting segment 8. DW_GL_SEGMENT8_D GL_SEGMENT_CODE
GL_SEGMENT8_VALUESET_CODE VARCHAR2 64 Accounting segment 8 value set code. DW_GL_SEGMENT8_D GL_SEGMENT_VALUESET_CODE
GL_SEGMENT9 VARCHAR2 32 Accounting segment 9. DW_GL_SEGMENT9_D GL_SEGMENT_CODE
GL_SEGMENT9_VALUESET_CODE VARCHAR2 64 Accounting segment 9 value set code. DW_GL_SEGMENT9_D GL_SEGMENT_VALUESET_CODE
GL_SEGMENT10 VARCHAR2 32 Accounting segment 10. DW_GL_SEGMENT10_D GL_SEGMENT_CODE
GL_SEGMENT10_VALUESET_CODE VARCHAR2 64 Accounting segment 10 value set code. DW_GL_SEGMENT10_D GL_SEGMENT_VALUESET_CODE
DIST_NUMBER NUMBER Intercompany distribution number.
DIST_DESCRIPTION VARCHAR2 256 Intercompany distribution line description.
PARTY_TYPE_FLAG VARCHAR2 16 Valid values for Party_type_flag are I for Provider and R for Receiver. DW_GIC_FUN_PARTY_TYPE_FLAG_LKP_TL FUN_PARTY_TYPE_FLAG_CODE
DIST_CREATION_DATE TIMESTAMP Who column: indicates the date and time of the creation of the row.
DIST_CREATED_BY VARCHAR2 128 Who column: indicates the user who created the row.
DIST_LAST_UPDATE_DATE TIMESTAMP Who column: indicates the date and time of the last update of the row.
DIST_LAST_UPDATED_BY VARCHAR2 128 Who column: indicates the user who last updated the row.
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.
DIST_AMOUNT_CR BIGDECIMAL 10 Intercompany credit distribution amount.
DIST_AMOUNT_DR BIGDECIMAL 10 Intercompany debit distribution amount.
DIST_NET_AMOUNT BIGDECIMAL 10 Distribution Net Amount - debit amount minus credit amount