CST_TRANSACTION_TAXES_GT

Global temporary table used in the cost preprocessor. It holds the tax line information that is computed in Receipt Accounting and needs to be processed by the cost preprocessor.

Details

• Schema: FUSION

• Object owner: CST

• Object type: TABLE

• Tablespace: Default

Columns

Name	Datatype	Length	Precision	Not-null	Comments
TRANSACTION_TAX_ID	NUMBER		18	Yes	Surrogate Key to identify a Transaction Tax
TRANSACTION_ID	NUMBER		18	Yes	Foreign key reference from CMR_TRANSACTIONS
CMR_PO_DISTRIBUTION_ID	NUMBER		18	Yes	Single column FK: Identifies the PO distribution whose acquisition cost is being computed.
CMR_RCV_TRANSACTION_ID	NUMBER		18	Yes	Identifies the root receipt transaction whose acquisition cost is being computed
EFFECTIVE_DATE	TIMESTAMP				Effective date of the tax row
TAX_EVENT_DATE	TIMESTAMP				Event Date on the Tax
PO_EVENT_DATE	TIMESTAMP				Event Date on the PO
PER_UNIT_TAX	NUMBER				Per unit tax amount for this tax line
INCLUSIVE_FLAG	VARCHAR2	1			This option indicates that the line amount is inclusive of tax.
SELF_ASSESSED_FLAG	VARCHAR2	1			This option indicates that the tax on this tax line is self assessed.
RECOVERABLE_FLAG	VARCHAR2	1			This option indicates whether it is recoverable or non recoverable tax