CST_ABAL_RPT_DIST_LINES

Details

Schema: FUSION
Object owner: CST
Object type: TABLE
Tablespace: Default

Columns

Name	Datatype	Length	Precision	Comments
AE_HEADER_ID	NUMBER		18	Subledger journal entry identifier.
AE_LINE_NUM	NUMBER		38	Subledger journal entry line number.
VAL_UNIT_CODE	VARCHAR2	1000		Abbreviated name for the valuation unit.
COST_ELEMENT_ID	NUMBER		18	Cost element corresponding to the cost of the transaction.
COST_ELEMENT_CODE	VARCHAR2	80		Abbreviated name for the cost element.
DISTRIBUTION_ID	NUMBER		18	Single column FK: Identifies the cost distribution header record.
DISTRIBUTION_LINE_ID	NUMBER		18	Surrogate ID identifying the Costing distribution line.
TRANSACTION_ID	NUMBER		18	Reference to the transaction for which the distribution is created.
COST_DATE	TIMESTAMP			Date to be used for transaction sequencing.
ACCOUNTING_DATE	DATE			Date referenced from Oracle Fusion General Ledger, used to determine the accounting period for transactions.
EXPENSE_TRANSACTION_FLAG	VARCHAR2	1		Identifies whether a transaction is an asset or expense transaction.
ACCOUNTING_LINE_TYPE	VARCHAR2	80		Accounting line type of the distribution line.
SUBINVENTORY_CODE	VARCHAR2	240		The subinventory code where the item is stored.
COST_TRANSACTION_TYPE	VARCHAR2	10		Costing transaction type ISSUE or RECEIPT.
REFERENCE_TYPE	VARCHAR2	240		Transaction's Source Documents Reference Document Type.
REFERENCE_NUMBER	VARCHAR2	240		Transaction's Source Documents Reference Document Number.
TRANSACTION_TYPE	VARCHAR2	80		Transaction type name translated to the language.
TRANSACTION_NUMBER	VARCHAR2	240		Transaction source doc type and txn_source_doc_number separated with '-'.
TRANSACTION_DATE	TIMESTAMP			The date when this transaction happened.