FUN_TRX_BATCHES

This table contains information about the intercompany transaction batches. The BATCH_NUMBER and INITIATOR_ID together form a unique key. An intercompany transaction batch can contain many transactions for multiple recipients.

Details

  • Schema: FUSION

  • Object owner: FUN

  • Object type: TABLE

  • Tablespace: APPS_TS_TX_DATA

Primary Key

Name Columns

FUN_TRX_BATCHES_PK

BATCH_ID

Columns

Name Datatype Length Precision Not-null Comments Flexfield-mapping
BATCH_ID NUMBER 18 Yes Unique system generated identifier for the batch.
BATCH_NUMBER VARCHAR2 20 Yes Number assigned to the intercompany batch.
INITIATOR_ID NUMBER 18 Yes Unique system generated identifier for the provider organization.
FROM_LE_ID NUMBER 18 Yes Unique system generated identifier for the provider legal entity.
FROM_LEDGER_ID NUMBER 18 Unique system generated identifier for the provider ledger.
CONTROL_TOTAL NUMBER 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.
RUNNING_TOTAL_CR NUMBER Sum of the credit amount for all transactions in the batch.
RUNNING_TOTAL_DR NUMBER Sum of the debit amount for all transactions in the batch.
CURRENCY_CODE VARCHAR2 15 Yes Currency of the batch. Transactions in a batch must be in the same currency.
EXCHANGE_RATE_TYPE VARCHAR2 30 Conversion rate to use if batch is not in the provider's base currency
STATUS VARCHAR2 30 Yes Status of the intercompany batch
DESCRIPTION VARCHAR2 240 Transaction type of this batch. All transactions in a batch must be of the same type.
NOTE VARCHAR2 240 Comments entered by the provider intercompany organization.
TRX_TYPE_ID NUMBER 18 Yes Transaction type of this batch. All transactions in a batch must be of the same type.
TRX_TYPE_CODE VARCHAR2 15 Transaction type code of this batch, all transactions in a batch must be of the same type.
GL_DATE DATE Yes Accounting date of the intercompany batch.
BATCH_DATE DATE Yes The date used for processing the intercompany batch.
REJECT_ALLOW_FLAG VARCHAR2 1 Yes Whether the transactions in this batch can be rejected.
ORIGINAL_BATCH_ID NUMBER 18 If this batch is reversing another one, this is the unique identifier of the batch it is reversing.
REVERSED_BATCH_ID NUMBER 18 For a reversed batch that has been reversed this is the unique identifier of the batch created to reverse it.
FROM_RECURRING_BATCH_ID NUMBER 18 Identify the initiator instance: Local or Remote. Currently not used.
INITIATOR_SOURCE VARCHAR2 30 Identify the initiator instance: Local or Remote. Currently not used.
ATTRIBUTE1 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Intercompany Transaction Batches (FUN_TRX_BATCHES)
ATTRIBUTE2 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Intercompany Transaction Batches (FUN_TRX_BATCHES)
ATTRIBUTE3 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Intercompany Transaction Batches (FUN_TRX_BATCHES)
ATTRIBUTE4 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Intercompany Transaction Batches (FUN_TRX_BATCHES)
ATTRIBUTE5 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Intercompany Transaction Batches (FUN_TRX_BATCHES)
ATTRIBUTE6 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Intercompany Transaction Batches (FUN_TRX_BATCHES)
ATTRIBUTE7 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Intercompany Transaction Batches (FUN_TRX_BATCHES)
ATTRIBUTE8 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Intercompany Transaction Batches (FUN_TRX_BATCHES)
ATTRIBUTE9 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Intercompany Transaction Batches (FUN_TRX_BATCHES)
ATTRIBUTE10 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Intercompany Transaction Batches (FUN_TRX_BATCHES)
ATTRIBUTE11 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Intercompany Transaction Batches (FUN_TRX_BATCHES)
ATTRIBUTE12 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Intercompany Transaction Batches (FUN_TRX_BATCHES)
ATTRIBUTE13 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Intercompany Transaction Batches (FUN_TRX_BATCHES)
ATTRIBUTE14 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Intercompany Transaction Batches (FUN_TRX_BATCHES)
ATTRIBUTE15 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Intercompany Transaction Batches (FUN_TRX_BATCHES)
ATTRIBUTE_CATEGORY VARCHAR2 30 Descriptive Flexfield: structure definition of the user descriptive flexfield. Intercompany Transaction Batches (FUN_TRX_BATCHES)
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row.
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row.
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row.
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row.
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row.
AUTO_PRORATION_FLAG VARCHAR2 1 Automatic proration flag. Currently not used.
OBJECT_VERSION_NUMBER NUMBER 9 Yes Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.
ATTRIBUTE_NUMBER1 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER2 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER3 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER4 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER5 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE1 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE2 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE3 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE4 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE5 DATE Descriptive Flexfield: segment of the user descriptive flexfield.

Foreign Keys

Table Foreign Table Foreign Key Column
FUN_TRX_BATCHES fun_interco_organizations INITIATOR_ID
FUN_TRX_BATCHES gl_ledgers FROM_LEDGER_ID
FUN_TRX_BATCHES fun_trx_types_b TRX_TYPE_ID
FUN_TRX_BATCHES xle_entity_profiles FROM_LE_ID
fun_trx_headers fun_trx_batches BATCH_ID
fun_batch_dists fun_trx_batches BATCH_ID

Indexes

Index Uniqueness Tablespace Columns Status
FUN_TRX_BATCHES_N2 Non Unique Default TRX_TYPE_ID Obsolete
FUN_TRX_BATCHES_N3 Non Unique Default INITIATOR_ID
FUN_TRX_BATCHES_U1 Unique Default BATCH_ID
FUN_TRX_BATCHES_U2 Unique Default BATCH_NUMBER, INITIATOR_ID