# DW_GIC_FUN_TRX_DISTRIBUTIONS_CF

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. |  |
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.