CST_LCM_CHARGE_AMTS_GT

This table will hold the newly allocated charges which are not yet processed by Costing (ca_processed_flag = 'N'/null). This table will act as source of truth during the entire acquisition cost run and even if this line is inactivated by a newer charge in between an acquisition cost run, the charges will still be processed. The newer charges will take effect in the next run of acquisition cost processing.

Details

• Schema: FUSION

• Object owner: CST

• Object type: TABLE

• Tablespace: Default

Primary Key

Name	Columns
CST_LCM_CHARGE_AMTS_GT_PK	CMR_RCV_TRANSACTION_ID, TRADE_OPERATION_ID, CHARGE_LINE_NUMBER, CHARGE_ID, FISCAL_DOC_HEADER_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
CMR_RCV_TRANSACTION_ID	NUMBER		18	Yes	Identifies the root receive transaction in CMR.
TRADE_OPERATION_ID	NUMBER		18	Yes	Identifies the trade operation that contributes this charge
FISCAL_DOC_HEADER_ID	NUMBER		18	Yes	Single Column FK: Identifies the fiscal document header.
CHARGE_LINE_NUMBER	NUMBER		9	Yes	Identifies the trade operation charge line that contributes this charge.
CHARGE_ID	NUMBER		18	Yes	Identifies the landed cost charge against which the amount is captured
UNIT_AMOUNT	NUMBER				Per unit amount associated to this receipt transaction
UNIT_TAX	NUMBER				Per unit tax associated to this receipt transaction
UOM_UNIT_FACTOR	NUMBER				Primary unit of measure unit factor to Purchase Order unit of measure.
CURRENCY_CODE	VARCHAR2	15			Identifies the currency code in which the amounts are captured. Typically the functional currency of the material receipt.
UOM_CODE	VARCHAR2	3			Primary UOM of the receipt transaction.
RCV_CHARGE_ESTIMATE_ID	NUMBER		18		Identifies the estimate association in Landed Costs.
RCV_CHARGE_ACTUAL_ID	NUMBER		18		Identifies the actual association in Landed Costs.

Indexes

Index	Uniqueness	Columns
CST_LCM_CHARGE_AMTS_GT_PK	Unique	CMR_RCV_TRANSACTION_ID, TRADE_OPERATION_ID, CHARGE_LINE_NUMBER, CHARGE_ID, FISCAL_DOC_HEADER_ID