CST_ACQ_COST_CONS_ADV_LINE_GT

Temporary table to hold acquisition cost computed for the consumption advice lines in CST_QTY_CONS_ADVICE_LINE_GT.

Details

  • Schema: FUSION

  • Object owner: CST

  • Object type: TABLE

  • Tablespace: TEMP3

Columns

Name Datatype Length Precision Comments
EXTERNAL_SYSTEM_REFERENCE VARCHAR2 60 Identifies the external source system. Necessary in joins to consumption advice line.
CONSUMPTION_ADVICE_LINE_ID NUMBER 18 Identifies the consumption advice line.
ACQUISITION_COST NUMBER Unit acquisition cost.
COST_COMPONENT_ID NUMBER 18 Cost component identifier