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_HEADERS

Object Details

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

FUN_TRX_HEADERS stores the transactions that make up an Intercompany transaction batch. The INITIATOR_ID, RECIPIENT_ID, BATCH_ID together form a unique key. Each transaction is meant for 1 recipient however a batch can contain multiple transactions where each transaction is a for a different recipient.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
FUN_TRX_HEADERS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	TRX_ID
FUN_TRX_HEADERS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	BATCH_ID
FUN_TRX_HEADERS_N20	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	STATUS INVOICE_FLAG
FUN_TRX_HEADERS_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	AR_INVOICE_NUMBER

Columns

Name	Datatype	Length	Mandatory	Comments
TRX_ID	NUMBER	(15)	Yes	System Generated primary key
TRX_NUMBER	VARCHAR2	(15)		Transaction Number
INITIATOR_ID	NUMBER	(15)	Yes	The party identifier of the Intercompany Organization which Initiated the transaction. Foreign key to HZ_PARTIES.PARTY_ID
RECIPIENT_ID	NUMBER	(15)	Yes	The party identifier of the Intercompany Organization which is the recipient of this transaction. Foreign key to HZ_PARTIES.PARTY_ID
TO_LE_ID	NUMBER	(15)	Yes	The party identifier of the Recipients Legal Entity. Foreign key to XLE_ENTITY_PROFILES.LEGAL_ENTITY_ID
TO_LEDGER_ID	NUMBER	(15)		The Recipients primary ledger ID. Foreign key to GL_LEDGERS.LEDGER_ID
BATCH_ID	NUMBER	(15)	Yes	Batch identifier.
STATUS	VARCHAR2	(30)	Yes	Transaction status.
INIT_AMOUNT_CR	NUMBER			Credit amount for initiator.
INIT_AMOUNT_DR	NUMBER			Debit amount for initiator.
RECI_AMOUNT_CR	NUMBER			Credit amount for recipient.
RECI_AMOUNT_DR	NUMBER			Debit amount for recipient.
AR_INVOICE_NUMBER	VARCHAR2	(50)		Number of the invoice generated in AR and also passed to AP when invoicing is required.
INVOICE_FLAG	VARCHAR2	(1)	Yes	"Y" if an Invoice is required for this transaction. "N" if it should be sent straight to GL.
APPROVER_ID	NUMBER	(15)		Id of the recipient user who approved this transaction. If a transaction does not require approval then this column remains blank.
APPROVAL_DATE	DATE			Date on which the transaction was approved
ORIGINAL_TRX_ID	NUMBER	(15)		If this transaction is reversing another one, this is the id of the transaction it is reversing
REVERSED_TRX_ID	NUMBER	(15)		For a reversed transaction that has been reversed this is the id of the transaction created to reverse it.
FROM_RECURRING_TRX_ID	NUMBER	(15)		Currently only used
INITIATOR_INSTANCE_FLAG	VARCHAR2	(1)		Check if initiator is in this instance. Currently not used
RECIPIENT_INSTANCE_FLAG	VARCHAR2	(1)		Check if recipient is in this instance. Currently not used
REJECT_REASON	VARCHAR2	(240)		Rejection reason entered by the approver
DESCRIPTION	VARCHAR2	(240)		The description is what will be passed to the recipients general ledger or payables as the journal or invoice description.
INIT_WF_KEY	VARCHAR2	(240)		Workflow key for initiator
RECI_WF_KEY	VARCHAR2	(240)		Workflow key for recipient
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.

Query Text

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


SELECT TRX_ID
,      TRX_NUMBER
,      INITIATOR_ID
,      RECIPIENT_ID
,      TO_LE_ID
,      TO_LEDGER_ID
,      BATCH_ID
,      STATUS
,      INIT_AMOUNT_CR
,      INIT_AMOUNT_DR
,      RECI_AMOUNT_CR
,      RECI_AMOUNT_DR
,      AR_INVOICE_NUMBER
,      INVOICE_FLAG
,      APPROVER_ID
,      APPROVAL_DATE
,      ORIGINAL_TRX_ID
,      REVERSED_TRX_ID
,      FROM_RECURRING_TRX_ID
,      INITIATOR_INSTANCE_FLAG
,      RECIPIENT_INSTANCE_FLAG
,      REJECT_REASON
,      DESCRIPTION
,      INIT_WF_KEY
,      RECI_WF_KEY
,      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
FROM FUN.FUN_TRX_HEADERS;

Dependencies

[top of page]

FUN.FUN_TRX_HEADERS does not reference any database object

FUN.FUN_TRX_HEADERS is referenced by following:

FUN: FUN_TRX_HEADERS#