1. Tables and Views for SCM
  2. CST_CONS_ADVICE_LINES_S_GT

CST_CONS_ADVICE_LINES_S_GT

This table is used to temporarily store a subset of input data from CST_CONSUMPTION_ADVICE_LINES table to support internal processing of cost processing.

Details

  • Schema: FUSION

  • Object owner: CST

  • Object type: TABLE

  • Tablespace: Default

Primary Key

Name Columns

CST_CONS_ADV_LINES_S_GT_PK

EXTERNAL_SYSTEM_REFERENCE, EXTERNAL_SYSTEM_REF_ID, OWNERSHIP_CHANGE_TXN

Columns

Name Datatype Length Precision Not-null Comments
EXTERNAL_SYSTEM_REFERENCE VARCHAR2 60 Yes Reference Information from an External system (external to Cost Management).
EXTERNAL_SYSTEM_REF_ID VARCHAR2 30 Yes Stores a value that uniquely identifies a certain instance of an object within the external system. For consumption advices created in fusion inventory, this represents the consumption advice line identifier.
CONSUMPTION_HEADER_ID NUMBER 18 Identifier of consumption document header.
OWNERSHIP_CHANGE_TXN NUMBER 18 Yes Identifier for the transaction that changes ownership between Supplier and the owner organization.
OWNERSHIP_CHANGE_CIT_ID NUMBER 18 Costing internal identifier for the transaction that changes ownership between Supplier and the owner organization.
OWNERSHIP_CHANGE_TIR_CIT_ID NUMBER 18 Costing internal identifier of the trade event transaction that corresponds to the ownership change transaction.
OWNERSHIP_CHANGE_TIR_ORG_ID NUMBER 18 The inventory organization identifier of the trade event transaction that corresponds to the ownership change transaction.
OWNED_CONS_ADVICE_LINE NUMBER 18 Parent consumption advice line to which a negative transfer to consigned transaction is linked.
PROCESSED_BY_CA_FLAG VARCHAR2 5 Indicates whether consumption advice line is cost processed.
REQUEST_ID NUMBER 18 Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row.
JOB_DEFINITION_NAME VARCHAR2 100 Enterprise Service Scheduler: indicates the name of the job that created or last updated the row.
JOB_DEFINITION_PACKAGE VARCHAR2 900 Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row.
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row.
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row.
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row.
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row.
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row.
CST_CONS_ADVICE_LINES_DIST_ID NUMBER 18 Costing internal surrogate identifier for the consumption advice line mapping to the ownership change inventory transaction.
CMR_PO_DISTRIBUTION_ID NUMBER Internal identifier of the purchase order distribution.
PO_LINE_LOCATION_ID NUMBER Purchase order shipment schedule identifier.
ROW_UPDATED_FLAG VARCHAR2 1 Indicates if this row has been updated during the process.

Indexes

Index Uniqueness Columns
CST_CONS_ADV_LINES_S_GT_U1 Unique EXTERNAL_SYSTEM_REFERENCE, EXTERNAL_SYSTEM_REF_ID, OWNERSHIP_CHANGE_TXN