MSC_COLL_SO_GT

This is a global temporary table used for Sales order collections.

Details

  • Schema: FUSION

  • Object owner: MSC

  • Object type: TABLE

  • Tablespace: Default

Columns

Name Datatype Comments
SALES_ORDER_LINE_ID NUMBER This value indicates the sales order line id of an SO.
DEMAND_SOURCE_LINE_ID NUMBER This value indicate source system from where the demand is originated.
REFRESH_NUMBER NUMBER This value indicates the refresh_number of the cycle.

Indexes

Index Uniqueness Columns Status
MSC_COLL_SO_GT_N1 Non Unique SALES_ORDER_LINE_ID Obsolete