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

Copyright © 2019, 2026, Oracle and/or its affiliates.