MSC_SUPPLIES
This table lists all the supplies for this plan. The supplies created by the planning process are added to this table.
Details
-
Schema: FUSION
-
Object owner: MSC
-
Object type: TABLE
-
Tablespace: APPS_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
MSC_SUPPLIES_PK |
PLAN_ID, TRANSACTION_ID, PART_KEY1 |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments | Status |
|---|---|---|---|---|---|---|
| PLAN_ID | NUMBER | Yes | This value indicates the plan identifier for the record. | |||
| SUBST_ITEM_ID | NUMBER | 18 | This value indicates the Substitute inventory item identifier. | |||
| MATERIAL_AVAIL_DATE | DATE | The date on which all of the upstream material required to process this supply becomes available | ||||
| LATEST_START_DATE | DATE | The Latest Start Date for a Supply is (Need by Date - Lead Time of the supply). This date can also go into the past and the past date should be shown to users. | ||||
| RESV_PARENT_ID | VARCHAR2 | 320 | Reservation parent identifier of the supply record. | |||
| SCHEDULE_DESIGNATOR | VARCHAR2 | 10 | This value indicates the SCHEDULE_DESIGNATOR. | |||
| SCHEDULE_LINE_NUM | VARCHAR2 | 30 | Schedule line number of the purchase order supply. | |||
| SHIPMENT_HEADER_NUM | VARCHAR2 | 30 | Shipment header number of a transfer order | |||
| SHIPMENT_LINE_NUM | VARCHAR2 | 30 | Shipment line number of a transfer order | |||
| RECEIPT_NUM | VARCHAR2 | 30 | Receipt number of a transfer order | |||
| SERVICE_LEVEL | NUMBER | 18 | Service level specified in the shipping method. | |||
| TRANSACTION_ID | NUMBER | 18 | Yes | Transaction identifier generated and used in the planning system for the supply/demand. | ||
| ORGANIZATION_ID | NUMBER | Yes | This column indicates the organization identifier. | |||
| PART_KEY1 | NUMBER | 18 | Yes | Source application instance identifier of the item org | ||
| INVENTORY_ITEM_ID | NUMBER | 18 | Yes | Identifies the inventory item id | ||
| SCHEDULE_DESIGNATOR_ID | NUMBER | This value indicates the Schedule designator. | ||||
| REVISION | VARCHAR2 | 10 | Inventory item revision code for the BOM component. | |||
| UNIT_NUMBER | VARCHAR2 | 30 | This value indicates the Unit number of the supply. | |||
| CONSUMPTION_START_DATE | DATE | The date on which this supply is first consumed by a downstream supply | ||||
| CONTRIBUTES_OVERLOAD | NUMBER | For buy items, the supply will have this attribute set to Yes, if it belongs to a time bucket in which the supplier capacity is overloaded For make items, the supply will have this attribute set to Yes, if one or more resource requirements of this supply belong to a time bucket in which resource capacity is overloaded | ||||
| CONTRIBUTES_DMD_LATENESS | NUMBER | This attribute value is Yes, if (Need by Date - Earliest Start Date) < lead time of the supply | ||||
| SHARED_SUPPLY | NUMBER | This attribute value is Yes, if the supply is consumed by multiple demands (dependent or independent or a combination of the two) | ||||
| USES_ORDER_MODIFIER | NUMBER | This attribute value is Yes if the supply quantity has been determined by an application of an item level order modifier such as FOQ, FLM, Min OQ, Max OQ or FDS. | ||||
| PEGGED_TO_FIRM | NUMBER | This attribute value is Yes, if the supply is pegged to a downstream firm supply | ||||
| NEW_SCHEDULE_DATE | DATE | Yes | End date of the supply (completion date of first unit) | |||
| OLD_SCHEDULE_DATE | DATE | This value indicates Old schedule date. | ||||
| NEW_WIP_START_DATE | DATE | This value indicates the New WIP schedule start date. | ||||
| OLD_WIP_START_DATE | DATE | This value indicates Old WIP schedule start date. | ||||
| FIRST_UNIT_COMPLETION_DATE | DATE | First unit completion date for recommended repetitive schedules | ||||
| LAST_UNIT_COMPLETION_DATE | DATE | Last unit completion date for recommended repetitive schedule | ||||
| FIRST_UNIT_START_DATE | DATE | First unit start date for recommended repetitive schedule | ||||
| LAST_UNIT_START_DATE | DATE | Last unit start date for recommended repetitive schedule | ||||
| DISPOSITION_ID | NUMBER | 18 | Identifier which references to source of supply | |||
| DISPOSITION_STATUS_TYPE | NUMBER | Identifies the status of supply. Not cancelled(1), Cancelled(2) | ||||
| ORDER_TYPE | NUMBER | Yes | Specifies type of order: planned order, purchase order, etc... | |||
| SUPPLIER_ID | NUMBER | 18 | This value indicates the Supplier identifier in the planning system. | |||
| SUPPLIER_SITE_ID | NUMBER | 18 | This value indicates the Supplier site identifier. | |||
| NEW_ORDER_QUANTITY | NUMBER | This indicates the supply quantity in primary unit of measure. | ||||
| OLD_ORDER_QUANTITY | NUMBER | This value indicates Old supply quantity. | ||||
| NEW_ORDER_PLACEMENT_DATE | DATE | This indicates the start date of the supply. | ||||
| OLD_ORDER_PLACEMENT_DATE | DATE | This value indicates Old start date of the supply. | ||||
| RESCHEDULE_DAYS | NUMBER | Different between old and new schedule dates | ||||
| RESCHEDULE_FLAG | NUMBER | Flag indicating if this row been rescheduled using th Planner Workbench form | ||||
| SCHEDULE_COMPRESS_DAYS | NUMBER | This value indicates the Old schedule compress days. | ||||
| NEW_PROCESSING_DAYS | NUMBER | Repetitive schedule processing days | ||||
| PURCH_LINE_NUM | VARCHAR2 | 50 | Purchase order line number (for purchase order) | |||
| QUANTITY_IN_PROCESS | NUMBER | Quantity being processed by the WIP/PO interface processes. Not yet in execution system | ||||
| IMPLEMENTED_QUANTITY | NUMBER | Planned order implemented quantity | ||||
| FIRM_PLANNED_TYPE | NUMBER | Yes | Flag indicating whether the order is firm | |||
| FIRM_QUANTITY | NUMBER | Quantity is marked as firm so that it doesn't change during replan. | ||||
| FIRM_DATE | DATE | Date is marked as firm so that it doesn't change during replan. | ||||
| IMPLEMENT_DEMAND_CLASS | VARCHAR2 | 30 | Identifies the Implement demand class | |||
| IMPLEMENT_DATE | DATE | Identifies the Implement due date | ||||
| IMPLEMENT_QUANTITY | NUMBER | Identifies the Implement quantity | ||||
| IMPLEMENT_FIRM | NUMBER | Identifies the Implement firm type | ||||
| IMPLEMENT_WIP_CLASS_CODE | VARCHAR2 | 10 | Identifies the Implement WIP class code | |||
| IMPLEMENT_JOB_NAME | VARCHAR2 | 240 | Identifies the Implement job name | |||
| IMPLEMENT_DOCK_DATE | DATE | Identifies the Implement dock date | ||||
| IMPLEMENT_STATUS_CODE | NUMBER | Identifies the Implement job status code | ||||
| IMPLEMENT_EMPLOYEE_ID | NUMBER | Identifies the Implement employee identifier | ||||
| IMPLEMENT_UOM_CODE | VARCHAR2 | 3 | Identifies the Implement UOM code | |||
| IMPLEMENT_LOCATION_ID | NUMBER | Identifies the Implement location identifier | ||||
| IMPLEMENT_SOURCE_ORG_ID | NUMBER | 18 | Implement source organization identifier | |||
| IMPLEMENT_SR_INSTANCE_ID | NUMBER | 18 | Source application instance identifier associated with implement source organization identifier | Obsolete | ||
| IMPLEMENT_SUPPLIER_ID | NUMBER | 18 | Identifies the Implement supplier identifier | |||
| IMPLEMENT_SUPPLIER_SITE_ID | NUMBER | 18 | Implement supplier site identifier | |||
| IMPLEMENT_AS | NUMBER | Implement order type. None(1), Purchase requisition(2), Discrete job(3) | ||||
| RELEASE_STATUS | NUMBER | This value indicates the release error description. | ||||
| LOAD_TYPE | NUMBER | Load program to execute during release. | ||||
| PROCESS_SEQ_ID | NUMBER | 18 | Process sequence identifier for the supply record. | |||
| SCO_SUPPLY_FLAG | NUMBER | Flag to indicate if supply was suggested by SCO | ||||
| ALTERNATE_BOM_DESIGNATOR | VARCHAR2 | 80 | Name of the bill for alternate bills (null for the primary bill) . | |||
| ALTERNATE_ROUTING_DESIGNATOR | VARCHAR2 | 30 | Name of the alternate routing. Null for primary routing | |||
| OPERATION_SEQ_NUM | NUMBER | 18 | Operation sequence within the routing where this supply is produced | |||
| BY_PRODUCT_USING_ASSY_ID | NUMBER | 18 | Product using assembly identifier | |||
| SOURCE_ORGANIZATION_ID | NUMBER | 18 | Source organization identifier for inter organization transfers | |||
| SOURCE_SR_INSTANCE_ID | NUMBER | 18 | Source application instance identifier associated with source organization identifier | Obsolete | ||
| SOURCE_SUPPLIER_SITE_ID | NUMBER | 18 | Source supplier site identifier | |||
| SOURCE_SUPPLIER_ID | NUMBER | 18 | This value indicates the Source supplier identifier. | |||
| SHIP_METHOD | VARCHAR2 | 30 | Shipping method used to move the material. | |||
| WEIGHT_CAPACITY_USED | NUMBER | Weight capacity used in transportation | ||||
| VOLUME_CAPACITY_USED | NUMBER | Volume capacity used in transportation | ||||
| NEW_SHIP_DATE | DATE | This value indicates the New ship date of the supply. | ||||
| NEW_DOCK_DATE | DATE | Suggested dock date of the supply order. | ||||
| OLD_DOCK_DATE | DATE | Old suggested dock date of the supply order. | ||||
| LINE_ID | NUMBER | 18 | This column indicates the work order line identifier. | |||
| PROJECT_ID | NUMBER | 18 | This column stores the value of Project identifier. | |||
| TASK_ID | NUMBER | 18 | This value indicates the Task identifier. | |||
| PLANNING_GROUP | VARCHAR2 | 30 | This value indicates the planning group of the record. | |||
| IMPLEMENT_PROJECT_ID | NUMBER | 18 | Identifies the Implement project identifier | |||
| IMPLEMENT_TASK_ID | NUMBER | 18 | Identifies the Implement task identifier | |||
| IMPLEMENT_SCHEDULE_GROUP_ID | NUMBER | 18 | Implement schedule group identifier | |||
| IMPLEMENT_BUILD_SEQUENCE | NUMBER | Build Sequence for the Planned Order to be implemented as a discrete job | ||||
| IMPLEMENT_ALTERNATE_BOM | VARCHAR2 | 80 | Alternate bom designator of the planned order to be implemented | |||
| IMPLEMENT_ALTERNATE_ROUTING | VARCHAR2 | 30 | Alternate routing designator of the planned order to be implemented | |||
| IMPLEMENT_UNIT_NUMBER | VARCHAR2 | 30 | End item unit number of the planned order to be implemented | |||
| IMPLEMENT_LINE_ID | NUMBER | 18 | Implement Repetitive Line Identifier | |||
| RELEASE_ERRORS | VARCHAR2 | 250 | This value indicates the release error description. | |||
| NUMBER1 | NUMBER | This column is populated by OPM coll. | ||||
| SOURCE_ITEM_ID | NUMBER | 18 | Source side inventory item identifier of the item. | |||
| ORDER_NUMBER | VARCHAR2 | 240 | Order number (purchase order number) | |||
| PO_HEADER_NUMBER | VARCHAR2 | 240 | Purchase order header number collected from source system. | |||
| SCHEDULE_GROUP_ID | NUMBER | 18 | Schedule group identifier of the the wip job supply. | |||
| BUILD_SEQUENCE | NUMBER | Build Sequence for the Planned Order | ||||
| WIP_ENTITY_NAME | VARCHAR2 | 240 | This stores the value of WIP job name for an assembly. | |||
| IMPLEMENT_PROCESSING_DAYS | NUMBER | Identifies the Implement processing days | ||||
| DELIVERY_PRICE | NUMBER | Supply unit price for purchasing supply | ||||
| LATE_SUPPLY_DATE | DATE | Supply date for the shadow part of the split supplies | ||||
| LATE_SUPPLY_QTY | NUMBER | Shadow supply quantity of the supply record. | ||||
| LOT_NUMBER | VARCHAR2 | 80 | Lot number for on-hand quantities | |||
| SUBINVENTORY_CODE | VARCHAR2 | 10 | Subinventory for on-hand quantity | |||
| QTY_SCRAPPED | NUMBER | Current job scrapped quantity units for the assembly. | ||||
| EXPECTED_SCRAP_QTY | NUMBER | This value indicates expected scrap quantity. | ||||
| QTY_COMPLETED | NUMBER | Current job quantity completed for the assembly. | ||||
| DAILY_RATE | NUMBER | Daily rate for recommended repetitive schedules | ||||
| SCHEDULE_GROUP_NAME | VARCHAR2 | 30 | Schedule group name of the the wip job supply. | |||
| UPDATED | NUMBER | Flag to determine whether add workday modification was applied | ||||
| SUBST_ITEM_FLAG | NUMBER | Flag indicating whether item is a substitute item | ||||
| STATUS | NUMBER | Attribute used for online replanning | ||||
| APPLIED | NUMBER | Attribute used for online replanning | ||||
| EXPIRATION_QUANTITY | NUMBER | Expiration quantity of the supply record. | ||||
| EXPIRATION_DATE | DATE | Expiration date of the supply record. | ||||
| NON_NETTABLE_QTY | NUMBER | This value indicates the Non-nettable onhand quantity. | ||||
| IMPLEMENT_WIP_START_DATE | DATE | Identifies the Implement start date | ||||
| REFRESH_NUMBER | NUMBER | Refresh number assigned by the collection program | ||||
| 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. | |||
| IMPLEMENT_DAILY_RATE | NUMBER | Identifies the Implement daily rate | ||||
| NEED_BY_DATE | DATE | This date indicates need by date of the supply order. | ||||
| SOURCE_SUPPLY_ID | NUMBER | 18 | This value indicates the Source supply identifier. | |||
| SR_MTL_SUPPLY_ID | NUMBER | 18 | Source side value of the supply identifier. | |||
| WIP_STATUS_CODE | NUMBER | This stores the value of WIP job status code for an assembly. | ||||
| DEMAND_CLASS | VARCHAR2 | 34 | Class to which the demand is tied. | |||
| FROM_ORGANIZATION_ID | NUMBER | From organization id for inter-organization transfers | ||||
| WIP_SUPPLY_TYPE | NUMBER | Work in process supply type value for the record. Mainly used for phantom identification. | ||||
| PO_LINE_ID | VARCHAR2 | 320 | Purchase order line identifier for the PO collected from source system. | |||
| LOAD_FACTOR_RATE | NUMBER | Load factor rate for suggested repetitive schedules | ||||
| ROUTING_SEQUENCE_ID | NUMBER | 18 | Supply identifier from the source | |||
| IMPLEMENT_ROUTING_SEQUENCE_ID | NUMBER | 18 | Supply identifier from the source to be implemented | |||
| BILL_SEQUENCE_ID | NUMBER | 18 | Supply identifier from the source | |||
| IMPLEMENT_BILL_SEQUENCE_ID | NUMBER | 18 | Supply identifier from the source to be implemented | |||
| COPRODUCTS_SUPPLY | NUMBER | Supply identifier from the source | ||||
| CFM_ROUTING_FLAG | NUMBER | Supply identifier from the source | ||||
| CUSTOMER_ID | NUMBER | 18 | Unique Partner identifier generated by the collection program | |||
| SHIP_TO_SITE_ID | NUMBER | 18 | Identifier of the party/partner where the shipment if headed for. | |||
| OLD_NEED_BY_DATE | DATE | Old Need By Date for ATP Summary Calculation. | ||||
| OLD_DAILY_RATE | NUMBER | This is used for ATP Summary Calculation | ||||
| OLD_FIRST_UNIT_START_DATE | DATE | This is for ATP Summary Calculation. | ||||
| OLD_LAST_UNIT_COMPLETION_DATE | DATE | This is for ATP Summary Calculation. | ||||
| OLD_NEW_SCHEDULE_DATE | DATE | This is for ATP Summary Calculation. | ||||
| CARRIER_ID | NUMBER | 18 | Unique identifier for the carrier | |||
| MODE_OF_TRANSPORT | NUMBER | 18 | Mode of transport for ship method. | |||
| OLD_QTY_COMPLETED | NUMBER | The old quantity completed value. Used for ATP summary calculation. | ||||
| OLD_NEW_ORDER_QUANTITY | NUMBER | This is for ATP Summary Calculation. | ||||
| OLD_FIRM_QUANTITY | NUMBER | This is for ATP Summary Calculation | ||||
| OLD_FIRM_DATE | DATE | This is for ATP Summary Calculation. | ||||
| PLANNING_PARTNER_SITE_ID | NUMBER | 18 | Planning Partner Site Identifier | |||
| PLANNING_TP_TYPE | NUMBER | Planning Partner Type Identifier | ||||
| OWNING_PARTNER_SITE_ID | NUMBER | 18 | Owning partner site identifier of the supply record. | |||
| OWNING_TP_TYPE | NUMBER | Owning trading partner type of the supply record. | ||||
| VMI_FLAG | NUMBER | VMI flag. Used in vendor managed inventory. | ||||
| EARLIEST_START_DATE | DATE | Earliest start date. For Improved exceptions. | ||||
| EARLIEST_COMPLETION_DATE | DATE | Earliest completion date. For Improved exceptions. | ||||
| MIN_START_DATE | DATE | Minimum star date value. For Improved Exceptions. | ||||
| SCHEDULED_DEMAND_ID | NUMBER | Schedule demand identifier. For Improved exceptions. | ||||
| EXPLOSION_DATE | DATE | SCO supply date (Updated need by date) | ||||
| SCO_SUPPLY_DATE | DATE | Supply chain orchestration supply date value. | ||||
| RECORD_SOURCE | NUMBER | For plan orders generated by ATP this field will have value 2. If this field is 1 or null then the plan order is generated by MBP | ||||
| SUPPLY_IS_SHARED | NUMBER | 1 if supply is shared, 2 if the supply is not shared, populated by HLS | ||||
| ULPSD | DATE | Unconstrained Latest Possible Start Date/Time | ||||
| ULPCD | DATE | Unconstrained Latest Possible Completion Date/Time | ||||
| UEPSD | DATE | Unconstrained Earliest Possible Start Date/Time | ||||
| UEPCD | DATE | Unconstrained Earliest Possible Completion Date/Time | ||||
| EACD | DATE | Earliest Allowable Completion Date/Time | ||||
| ORIGINAL_NEED_BY_DATE | DATE | Need-by Date for the shipment schedule | ||||
| ORIGINAL_QUANTITY | NUMBER | Quantity ordered or break quantity for blanket purchase orders, RFQs and quotations | ||||
| ACCEPTANCE_REQUIRED_FLAG | VARCHAR2 | 1 | Indicates whether acceptance from the supplier is required or not | |||
| PROMISED_DATE | DATE | Supplier promised delivery date | ||||
| WIP_START_QUANTITY | NUMBER | This column stores the start quantity of the lot based job. This quantity will be released back as the start quantity of the job | ||||
| END_ORDER_NUMBER | VARCHAR2 | 240 | Used to store a supplier change request | |||
| END_ORDER_LINE_NUMBER | VARCHAR2 | 25 | This value indicates End order line Number. | |||
| ORDER_LINE_NUMBER | VARCHAR2 | 25 | Order line number of the supply record. | |||
| UNBUCKETED_DEMAND_DATE | DATE | Stores the unbucketed demand date | ||||
| DAYS_LATE | NUMBER | Tell how many days the planned order from source plan will get delayed | ||||
| IMPLEMENT_DEST_INST_ID | NUMBER | Implement Destination Sr Instance ID | ||||
| IMPLEMENT_DEST_ORG_ID | NUMBER | Implement Destination Organization ID | ||||
| IMPLEMENT_SHIP_DATE | DATE | Identifies the Implement ship date | ||||
| INTRANSIT_CALENDAR | VARCHAR2 | 15 | Calendar to be considered during transit | |||
| INTRANSIT_LEAD_TIME | NUMBER | Identifies the Intransit Lead Time | ||||
| JOB_OP_SEQ_NUM | NUMBER | Job sequence number of the current operation. Populated only for lot-based jobs. | ||||
| JUMP_OP_SEQ_NUM | NUMBER | Routing sequence number of the jumped operation. If the operation is outside the network then a value of 50000 is populated. Populated only for lot-based jobs. | ||||
| OLD_SHIP_DATE | VARCHAR2 | 240 | This value indicates Old Ship Date. | |||
| ORIG_INTRANSIT_LEAD_TIME | NUMBER | This value stores original intransit lead time of the supply/demand. | ||||
| ORIG_SHIP_METHOD | VARCHAR2 | 30 | Default shipping method specified for the supply record. | |||
| PARENT_ID | NUMBER | 18 | This value indicates the parent identifier of the supply record. | |||
| PO_DISTRIBUTION_ID | NUMBER | 18 | Purchase order distribution identifier | |||
| PO_LINE_LOCATION_ID | VARCHAR2 | 320 | For Legacy, Concatenated value of ORDER_NUMBER, PURCH_LINE_NUM and SHIPMENT_NUM. For fusion source data, Purchase order line location identifier from source side tables. | |||
| QUANTITY_ISSUED | NUMBER | This value indicates the Part quantity issued. | ||||
| QUANTITY_PER_ASSEMBLY | NUMBER | This value indicates the Part usage quantity. | ||||
| RECEIVING_CALENDAR | VARCHAR2 | 15 | This value indicates the Receiving Calendar. | |||
| SCHEDULE_PRIORITY | NUMBER | Highest End Demand Priority of the work order supply. | ||||
| SHIPMENT_ID | NUMBER | 18 | Shipment identifier for the Distribution planning. | |||
| SHIP_CALENDAR | VARCHAR2 | 15 | Shipping calendar for the organization/supplier. | |||
| WSM_FAULTY_NETWORK | NUMBER | Flag to represent whether the OSFM job involves a faulty network | ||||
| REQUESTED_START_DATE | DATE | Requested start date of the wo. | ||||
| REQUESTED_COMPLETION_DATE | DATE | Requested completion/Due date of the wo | ||||
| ASSET_SERIAL_NUMBER | VARCHAR2 | 30 | Asset number or rebuild serial number | |||
| ASSET_ITEM_ID | NUMBER | 18 | Fk to item id. Asset group id or rebuild_item_id | |||
| TOP_TRANSACTION_ID | NUMBER | 18 | supply for top work order for eam work order hierarchy | |||
| UNBUCKETED_NEW_SCHED_DATE | DATE | Unbucketed New Schedule Date of the supply record. | ||||
| IMPLEMENT_SHIP_METHOD | VARCHAR2 | 30 | Identifies the Implement SHIP METHOD | |||
| ACTUAL_START_DATE | DATE | Actual start date & time for the WIP job | ||||
| FIRM_SHIP_DATE | DATE | The ship date is marked to be firm. | ||||
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | ||
| CTB_COMP_AVAIL_PERCENT | NUMBER | The value indicates CTB comp avail percentage. | ||||
| CTB_EXPECTED_DATE | DATE | The value indicates CTB expected date. | ||||
| CTB_FLAG | VARCHAR2 | 1 | Yes/No flag indicating CTB calculation to be considered for the item. | |||
| CTB_PRIOIRTY | NUMBER | The value indicates CTB priority used for the supply derivation/calculation. | ||||
| FIRM_START_DATE | DATE | The start date is marked to be firm. | ||||
| ITEM_TYPE_ID | NUMBER | Unique identifier of an item type. | ||||
| ITEM_TYPE_VALUE | NUMBER | Item type code per classification per the criterion indicated by the item_type_id | ||||
| ORIG_FIRM_DATE | DATE | This value stores original firm date of the supply/demand. | ||||
| ORIG_FIRM_QUANTITY | NUMBER | This value stores original firm quantity of the supply/demand. | ||||
| RTB_ORDER_QTY_PERCENT | NUMBER | RTB order quantity percentage of the supply record. | ||||
| ZONE_ID | NUMBER | This value indicates the zone identifier on the supply record. | ||||
| COLL_ORDER_TYPE | NUMBER | Order type of the supplies being collected over. | ||||
| ALLOW_PUBLISH | NUMBER | 1 ??? PUBLISHED BY CURRENT PLAN : 0 ??? PUBLISHED BY OLD PLAN | ||||
| VERSION_NUMBER | NUMBER | Running Seq Number. Used While Merging Records To Week Agg Table | ||||
| TO_LINE_ID | VARCHAR2 | 300 | This value indicates the Transfer Order Line Identifier. | |||
| TO_LINE_NUMBER | VARCHAR2 | 20 | Transfer order line number collected from source system. | |||
| INTERFACE_STATUS_LOOKUP | VARCHAR2 | 30 | Possible values: Awaiting Interface to DOO, Error, Awaiting Interface to Shipping, Interfaced to DOO, Interfaced to Shipping | |||
| SOURCE_SUBINVENTORY_CODE | VARCHAR2 | 10 | Source side subinventory code of the supply. | |||
| BMT_FLAG | NUMBER | Flag indicates whether transportation is managed by Buyer. 1-Yes, 2-No. | ||||
| DROP_SHIP_CUST_ID | NUMBER | 18 | Customer id of the drop ship PO | |||
| DROP_SHIP_CUST_SITE_ID | NUMBER | 18 | Customer site id of the drop ship PO | |||
| PROMISED_SHIP_DATE | DATE | Date promised to the customer for the order shipment. | ||||
| REQUESTED_SHIP_DATE | DATE | Requested ship date of the supply record. | ||||
| RESERVED_QUANTITY | NUMBER | This value indicates the Quantity reserved. | ||||
| FG_ORDER_TYPE | NUMBER | Specifies the Fine grained order type. Ex: For planned orders, defines the type of planned order. 5001 ??? ???MAKE???, 5002 ??? ???BUY???, 5003 ??? ???TRANSFER??? | ||||
| IMPLEMENT_MODE_OF_TRANSPORT_ID | NUMBER | 18 | Mode of transport for the order being released to source system. | |||
| IMPLEMENT_SERVICE_LEVEL_ID | NUMBER | 18 | Service level for the order being released to source system. | |||
| IMPLEMENT_CARRIER_ID | NUMBER | 18 | Destination side carrier id for the order being released to source system. | |||
| DROP_SHIP_DEST_TYPE | NUMBER | Destination types ??? drop ship and inventory. Requisition Lines and PO Schedules for drop shipments will have 1- ???DROPSHIP??? 2- ???INVENTORY??? | ||||
| FULFILL_ORCHESTRATION_REQUIRED | NUMBER | Indicates whether Transfer Order was interfaced to DOO | ||||
| FIRM_START_QUANTITY | NUMBER | Firm quantity of start quantity when item shrinkage is considered in the supply planning | ||||
| ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | |||
| ATTRIBUTE_CHAR1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_CHAR2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_CHAR3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_CHAR4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_CHAR5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_CHAR6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_CHAR7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_CHAR8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_CHAR9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_CHAR10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_CHAR11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_CHAR12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_CHAR13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_CHAR14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_CHAR15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_CHAR16 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_CHAR17 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_CHAR18 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_CHAR19 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_CHAR20 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER1 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_NUMBER2 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_NUMBER3 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_NUMBER4 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_NUMBER5 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_NUMBER6 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_NUMBER7 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_NUMBER8 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_NUMBER9 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_NUMBER10 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_DATE1 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_DATE2 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_DATE3 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_DATE4 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_DATE5 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_DATE6 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_DATE7 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_DATE8 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_DATE9 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_DATE10 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_DATE11 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_DATE12 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_DATE13 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_DATE14 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_DATE15 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_DATE16 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_DATE17 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_DATE18 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_DATE19 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_DATE20 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| WORK_ORDER_SUB_TYPE | NUMBER | This value indicates work order subtype of the work definition. | ||||
| NET_SUPPLY_QTY_OVERRIDE | NUMBER | Net supply quantity overridden by user. | ||||
| DAYS_PAST_DUE | NUMBER | exception detail for past due orders | ||||
| GLOBAL_ATTRIBUTE_CHAR1 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_CHAR2 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_CHAR3 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_CHAR4 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_CHAR5 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_CHAR6 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_CHAR7 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_CHAR8 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_CHAR9 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_CHAR10 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_CHAR11 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_CHAR12 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_CHAR13 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_CHAR14 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_CHAR15 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_CHAR16 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_CHAR17 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_CHAR18 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_CHAR19 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_CHAR20 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_NUMBER1 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
| GLOBAL_ATTRIBUTE_NUMBER2 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
| GLOBAL_ATTRIBUTE_NUMBER3 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
| GLOBAL_ATTRIBUTE_NUMBER4 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
| GLOBAL_ATTRIBUTE_NUMBER5 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
| GLOBAL_ATTRIBUTE_NUMBER6 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
| GLOBAL_ATTRIBUTE_NUMBER7 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
| GLOBAL_ATTRIBUTE_NUMBER8 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
| GLOBAL_ATTRIBUTE_NUMBER9 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
| GLOBAL_ATTRIBUTE_NUMBER10 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
| GLOBAL_ATTRIBUTE_DATE1 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
| GLOBAL_ATTRIBUTE_DATE2 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
| GLOBAL_ATTRIBUTE_DATE3 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
| GLOBAL_ATTRIBUTE_DATE4 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
| GLOBAL_ATTRIBUTE_DATE5 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
| GLOBAL_ATTRIBUTE_DATE6 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
| GLOBAL_ATTRIBUTE_DATE7 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
| GLOBAL_ATTRIBUTE_DATE8 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
| GLOBAL_ATTRIBUTE_DATE9 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
| GLOBAL_ATTRIBUTE_DATE10 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
| GLOBAL_ATTRIBUTE_DATE11 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
| GLOBAL_ATTRIBUTE_DATE12 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
| GLOBAL_ATTRIBUTE_DATE13 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
| GLOBAL_ATTRIBUTE_DATE14 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
| GLOBAL_ATTRIBUTE_DATE15 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
| GLOBAL_ATTRIBUTE_DATE16 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
| GLOBAL_ATTRIBUTE_DATE17 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
| GLOBAL_ATTRIBUTE_DATE18 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
| GLOBAL_ATTRIBUTE_DATE19 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
| GLOBAL_ATTRIBUTE_DATE20 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
| START_QUANTITY | NUMBER | START_QUANTITY is the actual quantity of the supply | ||||
| BASE_PLAN_ID | NUMBER | base plan identifier for the record | ||||
| ALT_FACILITY_USED | NUMBER | 1-yes 2-no, used to generate Order Sourced from Alternate Facility exception | ||||
| ALT_SUPPLIER_USED | NUMBER | 1-yes 2-no,used to generate Order Sourced from Alternate Supplier exception | ||||
| ALT_WORK_DEFINITION_USED | NUMBER | 1-yes 2-no, used to generate Planned Order Uses Alternate Work Definition | ||||
| ALT_RESOURCE_USED | NUMBER | 1-yes 2-no, used to generate Planned Order used Alternate Resource exception | ||||
| SUBSTITUTE_COMPONENT_USED | NUMBER | 1-yes 2-no, used to generate Planned Order uses Substitute Component exception | ||||
| SUBINV_FLAG | NUMBER | 1 | This indicates whether the row is for ITEM+ORG /ITEM+SUBORG | |||
| TOTAL_OUTPUT_QUANTITY | NUMBER | Represents the quantity produced for the work definition. In process manufacturing, this is the Batch Quantity. Total output quantity or batch quantity is mapped to PLANNED_START_QUANTITY in MFG which we currently collect as WIP_START_QUANTITY for DISCRETE jobs. | ||||
| LAST_OP_COMPLETION_DATE | DATE | Last operation's completion date. This date can be different from the supply date of the Primary output product if primary product completes at the operation earlier than last operation in the work order. This date is required to be sent during RELEASE. | ||||
| WORK_METHOD_CODE | NUMBER | A code that represents the user key to the work method. Valid values are 1=DISCRETE_MANUFACTURING, 2=PROCESS_MANUFACTURING. | ||||
| PROCESS_NAME | VARCHAR2 | 120 | Indicates the unique name for the work definition. In the case of process manufacturing, this represents the process name. | |||
| UOM_CODE | VARCHAR2 | 3 | Represents the unit of measure code of the supply quantity as specified in source module. For process work orders, this represents the BATCH_UOM. | |||
| CREATE_MOVEMENT_REQUEST | NUMBER | This column identifies whether to create a movement request or Transfer order between sub inventories of the same org. null = for other plan types and org level sourcing in repl plan, 1 = create movement request order type between sub inventories, 2 = do not create movement request order type between sub inventories. | ||||
| GLOBAL_ATTRIBUTE_NUMBER11 | NUMBER | 18 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_NUMBER12 | NUMBER | 18 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_NUMBER13 | NUMBER | 18 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_NUMBER14 | NUMBER | 18 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_NUMBER15 | NUMBER | 18 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_NUMBER16 | NUMBER | 18 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_NUMBER17 | NUMBER | 18 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_NUMBER18 | NUMBER | 18 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_NUMBER19 | NUMBER | 18 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_NUMBER20 | NUMBER | 18 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_NUMBER21 | NUMBER | 18 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_NUMBER22 | NUMBER | 18 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_NUMBER23 | NUMBER | 18 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_NUMBER24 | NUMBER | 18 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_NUMBER25 | NUMBER | 18 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_NUMBER26 | NUMBER | 18 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_NUMBER27 | NUMBER | 18 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_NUMBER28 | NUMBER | 18 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_NUMBER29 | NUMBER | 18 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_NUMBER30 | NUMBER | 18 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_NUMBER31 | NUMBER | 18 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_NUMBER32 | NUMBER | 18 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_NUMBER33 | NUMBER | 18 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_NUMBER34 | NUMBER | 18 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_NUMBER35 | NUMBER | 18 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_NUMBER36 | NUMBER | 18 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_NUMBER37 | NUMBER | 18 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_NUMBER38 | NUMBER | 18 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_NUMBER39 | NUMBER | 18 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_NUMBER40 | NUMBER | 18 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| ASSET_NUMBER | VARCHAR2 | 80 | A user-specified identifier for the asset object that has been associated to a maintenance work order. | |||
| CLUSTER_ID | NUMBER | 18 | cluster_id is the foreign key to the msc_cluster table. | |||
| REPL_INV_REBALANCE_FLAG | NUMBER | 1 | Replenishment plan type flag for if inventory rebalancing feature is used, 1 = Yes, 2 = No. | |||
| INIT_EXCESS_AT_SOURCE | NUMBER | Initial excess quantity available for inventory rebalancing. | ||||
| INIT_SHORTAGE_AT_DEST | NUMBER | Initial shortage quantity for inventory rebalancing. | ||||
| HOLD_DATE | DATE | This column stores the hold date of on-hand inventory lot. Engine will consider lot as available from HOLD_DATE if populated. | ||||
| ORDER_STATUS | NUMBER | This column indicates the status of the supply(Transfer Order/Purchase Order). This column is required for Project Transfer eligibility check. | ||||
| UNDER_COMPLETED_FLAG | NUMBER | Indicates whether the undercompletion tolerance is enabled or not. valid values. 1(Yes), 2(No) and Null | ||||
| BASE_ITEM_ID | NUMBER | This column stores the base Item identifier in case supply is for configured item. | ||||
| ORIGINAL_SUBINVENTORY_CODE | VARCHAR2 | 10 | The original sub-inventory of the supply in the child organization which is now recast to modeled sub-inventory on the parent or central organization | |||
| CHILD_ORGANIZATION_ID | NUMBER | 18 | The organization or satellite warehouse which is modeled as child organization with a modeled sub-inventory in Manage Planning Source System | |||
| GLOBAL_ATTRIBUTE_CHAR21 | VARCHAR2 | 100 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_CHAR22 | VARCHAR2 | 100 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_CHAR23 | VARCHAR2 | 100 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| ATTRIBUTE_ROW_ID | NUMBER | 18 | This identifies additional display attributes for the supply. The details can be obtained from msc_order_addtl_attrib, for the matching ATTRIBUTE_ROW_ID. This column can be populated only for plan output. It will be NULL for collected data. | |||
| ORIGINAL_ITEM_ID | NUMBER | 18 | This value indicates the Original inventory item identifier. | |||
| CONSOLIDATION_TRANSACTION_ID | NUMBER | 18 | Transaction identifier generated and used in buyer planning for consolidated orders. | |||
| RELEASE_GROUP_CODE | VARCHAR2 | 30 | Grouping option created and used in buyer planning for purchase orders. | |||
| MATURITY_DATE | DATE | The column indicates the date on which the on-hand lot matures. | ||||
| PRICE_SAVINGS | NUMBER | Identifies the price savings realized by actions in buyer planning. | ||||
| CONSTRAINED_START_DATE | DATE | Earliest date capacity is available to start the supply while respecting lead time constraint. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| MSC_SUPPLIES | msc_parameters | ORGANIZATION_ID |
| msc_resource_requirements | msc_supplies | PLAN_ID, TRANSACTION_ID, PART_KEY1 |
Indexes
| Index | Uniqueness | Tablespace | Columns | Status |
|---|---|---|---|---|
| MSC_SUPPLIES_N1 | Non Unique | Default | PLAN_ID, NEW_SCHEDULE_DATE, INVENTORY_ITEM_ID, ORGANIZATION_ID | |
| MSC_SUPPLIES_N10 | Non Unique | Default | PLAN_ID, ORGANIZATION_ID, FG_ORDER_TYPE, ORDER_NUMBER, TO_LINE_NUMBER, SHIPMENT_HEADER_NUM, SHIPMENT_LINE_NUM, RECEIPT_NUM, PART_KEY1 | |
| MSC_SUPPLIES_N11 | Non Unique | Default | PLAN_ID, SUPPLIER_ID, SUPPLIER_SITE_ID, INVENTORY_ITEM_ID | |
| MSC_SUPPLIES_N12 | Non Unique | Default | PLAN_ID, SUPPLIER_ID, SUPPLIER_SITE_ID, BASE_ITEM_ID | |
| MSC_SUPPLIES_N2 | Non Unique | Default | PLAN_ID, ORDER_TYPE, ORGANIZATION_ID, PO_HEADER_NUMBER, PURCH_LINE_NUM, SCHEDULE_LINE_NUM | |
| MSC_SUPPLIES_N3 | Non Unique | Default | PLAN_ID, NEW_SCHEDULE_DATE, ORDER_TYPE, INVENTORY_ITEM_ID | |
| MSC_SUPPLIES_N4 | Non Unique | Default | PLAN_ID, SCHEDULE_DESIGNATOR_ID, ORGANIZATION_ID | |
| MSC_SUPPLIES_N5 | Non Unique | Default | PLAN_ID, INVENTORY_ITEM_ID, ORGANIZATION_ID, ORDER_TYPE, NEW_SCHEDULE_DATE | |
| MSC_SUPPLIES_N6 | Non Unique | Default | PLAN_ID, ORGANIZATION_ID, INVENTORY_ITEM_ID, ORDER_TYPE | |
| MSC_SUPPLIES_N7 | Non Unique | Default | PLAN_ID, VERSION_NUMBER, NEW_SCHEDULE_DATE, NEW_DOCK_DATE | Obsolete |
| MSC_SUPPLIES_N8 | Non Unique | Default | PLAN_ID, INVENTORY_ITEM_ID, SUPPLIER_ID, SUPPLIER_SITE_ID | Obsolete |
| MSC_SUPPLIES_N9 | Non Unique | Default | PLAN_ID, RELEASE_STATUS | |
| MSC_SUPPLIES_U1 | Unique | Default | PLAN_ID, TRANSACTION_ID, PART_KEY1 |