Schema: FUSION Object owner: MSC Object type: TABLE Tablespace: TRANSACTION_TABLES Primary Key Name Columns MSC_HVGOP_SUPPLIER_ITEM_PK SUPPLIER_ID, SUPPLIER_SITE_ID, ITEM_ID Columns NameDatatypeLengthPrecisionNot-nullCommentsStatus SUPPLIER_ID NUMBER 18 Yes Field is used to indicate the su...
Schema: FUSION Object owner: MSC Object type: TABLE Tablespace: INTERFACE Columns NameDatatypeLengthPrecisionNot-nullCommentsStatus SUPPLIER_ID NUMBER This value indicates the Supplier identifier in the planning system. SUPPLIER_SITE_ID NUMBER This value indicates the Supplier site identifier. ORGAN...
Each row stores the tolerance percentage a supplier allows for a certain number of days in advance for an item. This table stores the time-phased capacity tolerance information for item-supplier/site used for flex fence support. Details Schema: FUSION Object owner: MSC Object type: TABLE ...
Schema: FUSION Object owner: MSC Object type: TABLE Tablespace: TRANSACTION_TABLES Primary Key Name Columns MSC_SUPPLIER_CAPACITIES_PK PLAN_ID, ASL_ID, FROM_DATE, NEW_PLAN_ID, SIMULATION_SET_ID, SUPPLY_COMMIT_FLAG Columns NameDatatypeLengthPrecisionNot-nullCommentsStatus TRANSACTION_ID NUMB...
Schema: FUSION Object owner: MSC Object type: TABLE Tablespace: TRANSACTION_TABLES Primary Key Name Columns MSC_SUPPLIER_CAPACITIES_PK PLAN_ID, ASL_ID, FROM_DATE, NEW_PLAN_ID, SIMULATION_SET_ID, SUPPLY_COMMIT_FLAG Columns NameDatatypeLengthPrecisionNot-nullCommentsStatus TRANSACTION_ID NUMBER...