CST_ACQ_COST_LCM_CHARGES_GT

This table will be populated with the set of landed cost charges applicable for a root receipt transaction. The process will be then summing up the costs at the component id level and applying them to the transactions.

Details

• Schema: FUSION

• Object owner: CST

• Object type: TABLE

• Tablespace: Default

Columns

Name	Datatype	Length	Precision	Not-null	Comments
CMR_RCV_TRANSACTION_ID	NUMBER		18	Yes	Surrogate ID FK identifying the receipt transaction in Receipt Accounting. Root receive transaction id.
TRADE_OPERATION_ID	NUMBER		18		Surrogate ID FK identifying a trade operation
FISCAL_DOC_HEADER_ID	NUMBER		18		Single Column FK: Identifies the fiscal document header. Default 0.
CHARGE_LINE_NUMBER	NUMBER		9		Identifies the charge line number within a trade operation.
CHARGE_ID	NUMBER		18		Surrogate ID FK identifying a landed cost charge against which the amount is booked
UNIT_AMOUNT	NUMBER				Per unit total amount associated to the receipt transaction
UOM_UNIT_FACTOR	NUMBER				Primary unit of measure unit factor to Purchase Order unit of measure
COST_COMPONENT_ID	NUMBER		18		Identifies the cost component mapped to the landed cost charge
CURRENCY_CODE	VARCHAR2	15			Function currency of the receipt transaction.
UOM_CODE	VARCHAR2	3			Primary UOM of the receipt transaction
RCV_CHARGE_ESTIMATE_ID	NUMBER		18		Identifies the receipt estimate in Landed Costs
RCV_CHARGE_ACTUAL_ID	NUMBER		18		Identifies the receipt actual in Landed Costs.