MSC_ST_SUB_INVENTORIES

The staging table used by the collection program to validate and process data for table MSC_SUB_INVENTORIES.

Details

  • Schema: FUSION

  • Object owner: MSC

  • Object type: TABLE

  • Tablespace: INTERFACE

Columns

Name Datatype Length Precision Not-null Comments
ORGANIZATION_ID NUMBER This column indicates the organization identifier.
CONDITION_TYPE VARCHAR2 240 The value indicates the condition type of the subinventory.
SUB_INVENTORY_CODE VARCHAR2 10 This value indicates the Sub inventory code.
DESCRIPTION VARCHAR2 200 Description of the sub-inventory
DISABLE_DATE DATE Date on which the row is no longer in used
NETTING_TYPE NUMBER Subinventory netting code. Nettable inventory(1), Nonnettable inventory(2).
DEMAND_CLASS VARCHAR2 34 Class to which the demand is tied.
PROJECT_ID NUMBER 18 This column stores the value of Project identifier.
TASK_ID NUMBER 18 This value indicates the Task identifier.
DELETED_FLAG NUMBER Yes/No flag indicates whether corresponding record in ODS will be deleted
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row.
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row.
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row.
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row.
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row.
SR_INSTANCE_ID NUMBER Source application instance identifier
REFRESH_NUMBER NUMBER Refresh identifier populated by the collection progam
INVENTORY_ATP_CODE NUMBER Inventory available to promise code
COMPANY_ID NUMBER Unique id assigned to the company
COMPANY_NAME VARCHAR2 255 Party name with which the company is registered.
ORGANIZATION_CODE VARCHAR2 18 This column indicates the organization code.
SR_INSTANCE_CODE VARCHAR2 30 Source Instance code from which data is being populated.
PROJECT_NUMBER VARCHAR2 25 This column stores the value of Project Number.
TASK_NUMBER VARCHAR2 25 This value indicates the Task number.
MESSAGE_ID NUMBER This is a foreign key reference to ECX_DOCLOGS.INTERNAL_CONTROL_NUMBER for records got via XML
PROCESS_FLAG NUMBER Processing Flag indicating the status of records during pre-processing. 1- New Record, 2- In-Process, 3- Error, 4- Propagated Error, 5- Successfully Processed
DATA_SOURCE_TYPE VARCHAR2 15 Source Type indicating the source of the records
ST_TRANSACTION_ID NUMBER Transaction ID generated during pre-processing to uniquely identify a record in the staging table
BATCH_ID NUMBER Batch identifier generated during pre-processing
ERROR_CODE VARCHAR2 150 Error code for functional validation errors in the record
ERROR_TEXT VARCHAR2 2000 This will describe the reason for the error if any.
SR_RESOURCE_NAME VARCHAR2 240 Source side value of the Resource name of the subinventory.
SR_CUSTOMER_ACCT_ID NUMBER Source side value of the customer account identifier.
RETRY_COUNT NUMBER Number of retries to process failed records.
OPERATION_TYPE VARCHAR2 2 This value indicates Operation Type.
LOAD_REQUEST_ID NUMBER It Stores the Request ID of Job that loaded the data.
LOCATION_CODE VARCHAR2 240 Unique identifier for Location for a given sour ce instance.
LOCATION_ID NUMBER Location id generated on destination side.
PAR_ENABLED NUMBER Indicates whether Sub Inventory is PAR Enabled or not.