# DW_GIC_FUN_TRX_BATCHES_CF (Preview)

This table requires activation of Global Intercompany functional area. This tables contains information about the intercompany transaction batches.

## Details

Module:

## Key Columns

BATCH_ID

## Columns

Columns
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column
--- | --- | --- | --- | --- | --- | --- | ---
BATCH_ID | NUMBER | 38 | 0 | True | Unique system generated identifier for the batch. |  |
SOURCE_RECORD_ID | VARCHAR2 | 64 |  |  | This column is for Oracle Internal use only. Source record identifier. |  |
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. |  |
FISCAL_PERIOD_SET_NAME | VARCHAR2 | 16 |  |  | Accounting calendar name. |  |
FISCAL_PERIOD_TYPE | VARCHAR2 | 16 |  |  | 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. |  |

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