CST_TRANSACTION_TAXES_S_GT

This table is used to temporarily store a subset of data from CST_TRANSACTION_TAXES_GT table to support internal processing within the Cost Processor.

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				Date when the row is created and used by cost accounting process.
TAX_EVENT_DATE	TIMESTAMP				Tax event date is event Date on the Tax.
PO_EVENT_DATE	TIMESTAMP				Event Date on the purchase order.
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.
PROCESSED_BY_CA_FLAG	VARCHAR2	1			Indicates whether the distribution was picked up by the cost accounting processor.
PO_LINE_LOCATION_ID	VARCHAR2	18			Purchase order shipment schedule identifier.
ACTIVE_FLAG	VARCHAR2	1			Indicates whether there is more recent information for this distribution. Only the most recent record will have this flag set to Y.
FISCAL_DOC_HEADER_ID	NUMBER		18		Fiscal document header unique identifier.
TRX_ID	NUMBER		18		The Transaction line for which the tax is created.
TAXABLE_AMT	NUMBER				The calculated taxable basis amount.
REC_NREC_TAX_AMT	NUMBER				The calculated tax amount of the tax line.
PER_UNIT_TAX_AMT	NUMBER				Per unit tax amount for this tax line.