This table stores the distributions for the Intercompany transactions
Module:
DIST_ID
| 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. | |||
| CUST_TRX_TYPE_SEQ_ID | NUMBER | 38 | 0 | Receivables transaction type sequence 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 |
Copyright © 2019, 2026, Oracle and/or its affiliates.