eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

TABLE: FUN.FUN_TRX_BATCHES

Object Details

Object Name:	FUN_TRX_BATCHES
Object Type:	TABLE
Owner:	FUN
FND Design Data:	FUN.FUN_TRX_BATCHES
Subobject Name:
Status:	VALID

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

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
FUN_TRX_BATCHES_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	BATCH_ID
FUN_TRX_BATCHES_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	FROM_LEDGER_ID BATCH_ID FROM_LE_ID DESCRIPTION
FUN_TRX_BATCHES_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	BATCH_NUMBER
FUN_TRX_BATCHES_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TRX_TYPE_ID
FUN_TRX_BATCHES_N20	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	GL_DATE
FUN_TRX_BATCHES_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	INITIATOR_ID

Columns

Name	Datatype	Length	Mandatory	Comments
BATCH_ID	NUMBER	(15)	Yes	System Generated primary key.
BATCH_NUMBER	VARCHAR2	(20)	Yes	The Batch Number of the batch.
INITIATOR_ID	NUMBER	(15)	Yes	The party identifier of the Intercompany Organization which Initiated the batch. Foreign key to HZ_PARTIES.PARTY_ID.
FROM_LE_ID	NUMBER	(15)	Yes	The party identifier of the Initiators Legal Entity. Foreign key to XLE_ENTITY_PROFILES.LEGAL_ENTITY_ID
FROM_LEDGER_ID	NUMBER	(15)		Primary ledger of the Initiating organization. Foreign key to GL_LEDGERS.LEDGER_ID
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 INIT_AMOUNT_CR in the FUN_TRX_HEADERS table.
RUNNING_TOTAL_DR	NUMBER			Sum of INIT_AMOUNT_DR in the FUN_TRX_HEADERS table.
CURRENCY_CODE	VARCHAR2	(15)	Yes	Currency of the batch, transactions in a batch must be in the same currency.
EXCHANGE_RATE_TYPE	VARCHAR2	(30)		Exchange rate to use if batch is not in the initiators base currency
STATUS	VARCHAR2	(30)	Yes	Batch status
DESCRIPTION	VARCHAR2	(240)		The description is what will be passed to the Initiators General Ledger or Receivables as the journal or invoice description.
NOTE	VARCHAR2	(240)		Initiator entered comments
TRX_TYPE_ID	NUMBER	(15)	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	GL Date of the batch
BATCH_DATE	DATE		Yes	Batch entered date
REJECT_ALLOW_FLAG	VARCHAR2	(1)	Yes	Whether the transactions in this batch can be rejected
ORIGINAL_BATCH_ID	NUMBER	(15)		If this batch is reversing another one, this is the id of the batch it is reversing.
REVERSED_BATCH_ID	NUMBER	(15)		For a reversed batch that has been reversed this is the id of the batch created to reverse it.
FROM_RECURRING_BATCH_ID	NUMBER	(15)		Currently only used for transactions upgraded from GIS
INITIATOR_SOURCE	VARCHAR2	(30)		Identify the initiator instance: Local or Remote. Currently not used.
ATTRIBUTE1	VARCHAR2	(150)		Descriptive flexfield segment.
ATTRIBUTE2	VARCHAR2	(150)		Descriptive flexfield segment.
ATTRIBUTE3	VARCHAR2	(150)		Descriptive flexfield segment.
ATTRIBUTE4	VARCHAR2	(150)		Descriptive flexfield segment.
ATTRIBUTE5	VARCHAR2	(150)		Descriptive flexfield segment.
ATTRIBUTE6	VARCHAR2	(150)		Descriptive flexfield segment.
ATTRIBUTE7	VARCHAR2	(150)		Descriptive flexfield segment.
ATTRIBUTE8	VARCHAR2	(150)		Descriptive flexfield segment.
ATTRIBUTE9	VARCHAR2	(150)		Descriptive flexfield segment.
ATTRIBUTE10	VARCHAR2	(150)		Descriptive flexfield segment.
ATTRIBUTE11	VARCHAR2	(150)		Descriptive flexfield segment.
ATTRIBUTE12	VARCHAR2	(150)		Descriptive flexfield segment.
ATTRIBUTE13	VARCHAR2	(150)		Descriptive flexfield segment.
ATTRIBUTE14	VARCHAR2	(150)		Descriptive flexfield segment.
ATTRIBUTE15	VARCHAR2	(150)		Descriptive flexfield segment.
ATTRIBUTE_CATEGORY	VARCHAR2	(150)		Descriptive flexfield context
CREATED_BY	NUMBER	(15)	Yes	Standard Who column.
CREATION_DATE	DATE		Yes	Standard Who column.
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who column.
LAST_UPDATE_DATE	DATE		Yes	Standard Who column.
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column.
AUTO_PRORATION_FLAG	VARCHAR2	(1)		Automatic proration flag. A value of "Y" indicates that user would like to generate the distributions using proration. A value of "N" indicates the distributions will be entered manually.

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT BATCH_ID
,      BATCH_NUMBER
,      INITIATOR_ID
,      FROM_LE_ID
,      FROM_LEDGER_ID
,      CONTROL_TOTAL
,      RUNNING_TOTAL_CR
,      RUNNING_TOTAL_DR
,      CURRENCY_CODE
,      EXCHANGE_RATE_TYPE
,      STATUS
,      DESCRIPTION
,      NOTE
,      TRX_TYPE_ID
,      TRX_TYPE_CODE
,      GL_DATE
,      BATCH_DATE
,      REJECT_ALLOW_FLAG
,      ORIGINAL_BATCH_ID
,      REVERSED_BATCH_ID
,      FROM_RECURRING_BATCH_ID
,      INITIATOR_SOURCE
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE_CATEGORY
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      AUTO_PRORATION_FLAG
FROM FUN.FUN_TRX_BATCHES;

Dependencies

[top of page]

FUN.FUN_TRX_BATCHES does not reference any database object

FUN.FUN_TRX_BATCHES is referenced by following:

FUN: FUN_TRX_BATCHES#