MSC_DEMANDS
This table stores all the demands taken into account for planning. Disposition_id would be a foreign key to MSC_SUPPLIES for dependent demands. For independent demands, disposition_id holds MRP_SCHEDULE_DATES.MPS_TRANSACTION_ID.
Details
-
Schema: FUSION
-
Object owner: MSC
-
Object type: TABLE
-
Tablespace: APPS_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
MSC_DEMANDS_PK |
PLAN_ID, DEMAND_ID, PART_KEY1 |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| ORDER_PRIORITY | NUMBER | This value indicates the order priority of the demand. | |||
| ORDERED_QUANTITY | NUMBER | Quantity of an ordered good or service. | |||
| RESV_PARENT_ID | VARCHAR2 | 392 | Reservation parent identifier of the demand record. | ||
| PO_LINE_LOCATION_ID | VARCHAR2 | 320 | This is a internal column to store po line location id for the dropship so - po record | ||
| CUSTOMER_PO_SCHEDULE_NUMBER | VARCHAR2 | 50 | Contains Customers Purchase Order Shipment Schedule number , if specified while submitting an order. | ||
| PROMISE_ARRIVAL_DATE | DATE | Promise arrival date of the sales order demand. | |||
| OPERATION_EFFECTIVITY_DATE | DATE | This value indicates Effectivity Date. | |||
| WIP_ENTITY_NAME | VARCHAR2 | 240 | This stores the value of WIP job name for an assembly. | ||
| SALESREP_CONTACT | VARCHAR2 | 50 | This value indicates the Sales representative contact info. | ||
| CUSTOMER_PO_NUMBER | VARCHAR2 | 240 | Customer PO number on the Sales Order. PO number reference that represents the commercial document that is used to request a seller to supply a product or service requested by the end customer. | ||
| CUSTOMER_PO_LINE_NUMBER | VARCHAR2 | 50 | An identifier of the customer PO line record. The customer PO line describes an item or service requested by the end customer. | ||
| MIN_REM_SHELF_LIFE_DAYS | NUMBER | Minimum remaining shelf life days demand for the demand. | |||
| INVENTORY_ORGANIZATION_ID | NUMBER | Inventory organization identifier | |||
| ALLOW_SPLITS | NUMBER | Flag indicates whether fulfillment line can be split into multiple demand lines. 1-Yes, 2-No. | |||
| ALLOW_SUBSTITUTION | NUMBER | Flag indicates whether substitution is allowed for item on fulfillment line . 1-Yes, 2-No. | |||
| FULFILLMENT_LINE_NUM | NUMBER | Line number of the fulfillment (demand) | |||
| SOURCE_SCHEDULE_NUMBER | VARCHAR2 | 50 | This value indicates the Source schedule number. | ||
| DEMAND_SOURCE_SYSTEM_ID | NUMBER | Source system from where the demand is originated. | |||
| ORDERED_DATE | DATE | This value indicates the ordered date on the demand. | |||
| ITEM_TYPE_CODE | VARCHAR2 | 30 | Indicates whether this is a model/option class/standard item etc. VALID VALUES : MODEL, OPTION_CLASS ,STANDARD Will be populated only for TOE interfaced to DOO. NULL for TOE NOT interfaced to DOO | ||
| ITEM_SUB_TYPE_CODE | VARCHAR2 | 30 | More specific sub group for ITEM_TYPE_CODE. Model/Service/One-Time Item characteristic detail (like ATO, PTOSMC, PTONONSMC). | ||
| ORDER_MARGIN | NUMBER | This value indicates the order margin of the demand. | |||
| PROMISING_SYSTEM | VARCHAR2 | 50 | Promising system that satisfies the incoming demand. | ||
| DELIVERY_COST | NUMBER | Delivery cost associated with the SO | |||
| DELIVERY_LEAD_TIME | NUMBER | Delivery Lead time associated with the SO | |||
| ORCH_ORDER_NUMBER | VARCHAR2 | 50 | Reference to the number of the originating sales order. | ||
| ORCH_ORDER_LINE_NUMBER | VARCHAR2 | 100 | Reference to the number of the originating sales order line. | ||
| MIN_PERCENTAGE_FOR_SPLIT | NUMBER | Minimum percentage for splitting the demand. | |||
| MIN_QUANTITY_FOR_SPLIT | NUMBER | Minimum quantity value for splitting the demand. | |||
| SOURCE_DOCUMENT_NUMBER | VARCHAR2 | 50 | Source side value of the document, like PO/PR, that is linked to the demand. | ||
| SOURCE_DOCUMENT_LINE_NUMBER | VARCHAR2 | 50 | Source side value of the document line, like PO/PR, that is linked to the demand. | ||
| SUPPLIER_SITE_SOURCE_SYSTEM_ID | NUMBER | Source system identifier associated with the supplier site. | |||
| FORECAST_AVG_INTERARRIVAL_TIME | NUMBER | Forecast average inter-arrival time for the forecast demand. | |||
| FORECAST_INTERMIT_DEMAND_FLAG | NUMBER | Forecast intermittent demand flag for the forecast record. | |||
| FORECAST_MAPE | NUMBER | Forecast MAPE. Used in forecast processing. | |||
| FULFILLMENT_COST | NUMBER | The estimated cost it will take to deliver a fulfillment line to a customer. The figure includes item cost as well as shipping cost. | |||
| DEMAND_SCHEDULE_NAME | VARCHAR2 | 10 | Name of the forecast for this demand | ||
| RECEIVING_ORG_ID | NUMBER | 18 | Receiving org id(incase of ISO) | ||
| COMPLETED_QUANTITY | NUMBER | The value indicates completed quantity of the total wip job quantity. | |||
| SALES_ORDER_HEADER_ID | VARCHAR2 | 50 | Sales order header identifier collected from source system. | ||
| ORCH_ORDER_HEADER_ID | NUMBER | 18 | Reference to the unique identifier for the orchestration order. | ||
| SALES_ORDER_NUMBER | VARCHAR2 | 240 | This value indicates the Sales order number. | ||
| SO_LINE_NUM | VARCHAR2 | 150 | Sales order line number of the sales order demand. | ||
| ORCH_ORDER_LINE_ID | NUMBER | 18 | Reference to the unique identifier for the orchestration order line. | ||
| LATEST_ACCEPTABLE_SHIP_DATE | DATE | latest ship date when ct can accept the supply | |||
| LATEST_ACCEPTABLE_ARRIVAL_DATE | DATE | latest ARRIVAL date when ct can accept the supply | |||
| EARLIEST_ACCEPT_SHIP_DATE | DATE | Earliest ship date when ct can accept the supply | |||
| EARLIEST_ACCEPT_ARRIVAL_DATE | DATE | Earliest arrival date when ct can receive the supply | |||
| CARRIER_ID | NUMBER | 18 | Unique identifier for the carrier | ||
| MODE_OF_TRANSPORT | NUMBER | 18 | Type of transportation used to ship the product, such as truck, air or boat. | ||
| BILL_TO_SITE_ID | NUMBER | 18 | party site id of the bill to customer site. | ||
| ORDERED_UOM | VARCHAR2 | 25 | Uom for all quantities ordered qty and completed qty. | ||
| SUPPLIER_ID | NUMBER | 18 | ship from supplier id in case of drop ship | ||
| SUPPLIER_SITE_ID | NUMBER | 18 | Ship from supplier site id in case of drop ship | ||
| FORECAST_MAD | NUMBER | Forecast MAD. Used in forecast processing. | |||
| DEMAND_ID | NUMBER | 18 | Yes | This column identifies the demand. | |
| SCHEDULE_DESIGNATOR_ID | NUMBER | This value indicates the Schedule designator identifier. | |||
| USING_REQUIREMENT_QUANTITY | NUMBER | Yes | Required quantity (demand quantity) of the demand. | ||
| ASSEMBLY_DEMAND_COMP_DATE | DATE | Using assembly demand completion date | |||
| USING_ASSEMBLY_DEMAND_DATE | DATE | Using assembly demand date (due date) of the demand. | |||
| DEMAND_TYPE | NUMBER | Yes | Demand type. Discrete Demand(1), Rate-based demand(2) | ||
| ORIGINATION_TYPE | NUMBER | Origin of the demand: Planned order, hard reservation, etc... | |||
| DEMAND_PRIORITY | NUMBER | Demand priority. Used by scheduling heuristic | |||
| SALES_ORDER_PRIORITY | NUMBER | This value indicates the Sales order quantity. | |||
| FORECAST_PRIORITY | NUMBER | Forecast priority. Used in forecast processing. | |||
| PLANNING_GROUP | VARCHAR2 | 30 | This value indicates the planning group of the record. | ||
| DAILY_DEMAND_RATE | NUMBER | Repetitive demand rate for the item being manufactured. | |||
| UNIT_NUMBER | VARCHAR2 | 30 | This value indicates the Unit number of the demand. | ||
| DISPOSITION_ID | NUMBER | 18 | Disposition identifier, reference to the supply generating the demand. | ||
| USING_ASSEMBLY_ITEM_ID | NUMBER | Yes | Using assembly item identifier (item generating the demand for dependent demands) | ||
| PLAN_ID | NUMBER | Yes | This value indicates the plan identifier for the record. | ||
| ORGANIZATION_ID | NUMBER | Yes | Reference to the unique identifier for the organization of the source order. | ||
| INVENTORY_ITEM_ID | NUMBER | 18 | Yes | Identifies the inventory item id | |
| PROJECT_ID | NUMBER | 18 | Project identifier to which the demand applies | ||
| TASK_ID | NUMBER | 18 | Task identifier to which the demand applies | ||
| CUSTOMER_ID | NUMBER | 18 | Unique Partner identifier generated by the collection program | ||
| CUSTOMER_SITE_ID | NUMBER | 18 | Customer site unique identifier | ||
| PART_KEY1 | NUMBER | 18 | Yes | Source application instance identifier | |
| SHIP_TO_SITE_ID | NUMBER | 18 | Identifier of the party/partner where the shipment if headed for. | ||
| PROMISE_DATE | DATE | Date promised to the customer for the order availability. | |||
| SELLING_PRICE | NUMBER | Selling price of the demand record. | |||
| DMD_LATENESS_COST | NUMBER | Demand lateness cost for independent demands | |||
| DMD_SATISFIED_DATE | DATE | Date when the demand is satisfied | |||
| OP_SEQ_NUM | NUMBER | Operation sequence number within the routing used by the source supply | |||
| UPDATED | NUMBER | Flag to determine whether add workday modification was applied | |||
| STATUS | NUMBER | Status flag. Used for online replanning. | |||
| APPLIED | NUMBER | Flag used for online replanning | |||
| DEMAND_CLASS | VARCHAR2 | 34 | Class to which the demand is tied. | ||
| FIRM_QUANTITY | NUMBER | Quantity is marked as firm so that it doesn't change during replan. | |||
| FIRM_DATE | DATE | Quantity is marked as firm so that it doesn't change during replan. | |||
| OLD_DEMAND_QUANTITY | NUMBER | Old demand quantity. During reschedule, this indicates the original demand quantity prior to reschedule. | |||
| OLD_DEMAND_DATE | DATE | Old order due date. During reschedule, this indicates the original demand_date. | |||
| SOURCE_ORGANIZATION_ID | NUMBER | This value indicates the Source application identifier. | |||
| RESERVATION_ID | NUMBER | 18 | Reservation identifier of the demand if it is linked to dependent demand/supply. | ||
| PARENT_ID | NUMBER | 18 | Demand identifier of the parent demand transaction | ||
| LENDING_PROJECT_ID | NUMBER | 18 | Lending project identifier for Payback Demand | ||
| LENDING_TASK_ID | NUMBER | 18 | Lending task identifier for Payback Demand | ||
| SUBST_ITEM_FLAG | NUMBER | Flag indicating whether item is a substitute item | |||
| ORDER_NUMBER | VARCHAR2 | 62 | This value indicates the Wip entity name of the demand. | ||
| RESERVED_QUANTITY | NUMBER | This value indicates the Quantity reserved. | |||
| 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. | ||
| ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | ||
| ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| WIP_ENTITY_ID | NUMBER | 18 | This value indicates WIP job identifier for an assembly. | ||
| ISSUED_QUANTITY | NUMBER | Quantity issued so far. Since partial issues are possible. This is mostly kept for runtime calculations. | |||
| REPETITIVE_SCHEDULE_ID | NUMBER | 18 | Repetitive schedule identifier of the demand record. | ||
| REFRESH_NUMBER | NUMBER | Refresh number populated by the collection program | |||
| REQUEST_DATE | DATE | Request date of the demand record. | |||
| WIP_STATUS_CODE | NUMBER | This stores the value of WIP job status code for an assembly. | |||
| WIP_SUPPLY_TYPE | NUMBER | Work in process supply type value for the record. Mainly used for phantom identification. | |||
| SOURCE_ORG_INSTANCE_ID | NUMBER | 18 | This value indicates the source organization instance identifier. | ||
| SALES_ORDER_LINE_ID | VARCHAR2 | 400 | This value indicates the Sales order line identifier. | ||
| CONFIDENCE_PERCENTAGE | NUMBER | Confidence percentage of the Forecast demand. | |||
| BUCKET_TYPE | NUMBER | Value indicates Bucket Type of the record (Day/Week/Month) | |||
| BILL_ID | NUMBER | 18 | Forecast billing address identifier | ||
| PROBABILITY | NUMBER | This value indicates the probability for the demand/designator. | |||
| FORECAST_SET_ID | NUMBER | 18 | ID assigned to the forecast set | ||
| GROUP_ID | NUMBER | 18 | The group identifier to which this record refers to | ||
| SERVICE_LEVEL | NUMBER | 18 | Service level specified in the shipping method. | ||
| QUANTITY_BY_DUE_DATE | NUMBER | This value indicates the Quantity By Due Date. | |||
| TARGET_SAFETY_STOCK | NUMBER | This value indicates the Target safety stock value. | |||
| SCENARIO_SET | NUMBER | This value indicates the Scenario Set. | |||
| DEMAND_SOURCE_TYPE | NUMBER | Forecast billing address identifier | |||
| SUPPLY_ID | NUMBER | 18 | Forecast billing address identifier | ||
| ORIGINAL_SYSTEM_REFERENCE | VARCHAR2 | 50 | Original System Line Reference that links the demand to a supply. | ||
| ORIGINAL_SYSTEM_LINE_REFERENCE | VARCHAR2 | 50 | Original System Line Reference that links the demand to a supply. | ||
| STOLEN_FLAG | VARCHAR2 | 1 | This flag indicates whether the demand is stolen. | ||
| OLD_USING_REQUIREMENT_QUANTITY | NUMBER | Old requirement quantity for ATP Summary Calculation | |||
| OLD_USING_ASSEMBLY_DEMAND_DATE | DATE | Old demand date for ATP Summary Calculation | |||
| OLD_ASSEMBLY_DEMAND_COMP_DATE | DATE | Old demand date for the component of an assembly. | |||
| CUMMULATIVE_PROBABILITY | NUMBER | This value indicates Cumulative Probability. | |||
| ORIGINAL_ITEM_ID | NUMBER | 18 | This value indicates the Original inventory item identifier. | ||
| UNMET_QUANTITY | NUMBER | Unmet Quantity for Independent Demands | |||
| RECORD_SOURCE | NUMBER | For plan order demands generated by ATP this field will have value 2. If this field is 1 or null then the plan order is generated by MBP | |||
| LINK_TO_LINE_ID | NUMBER | 18 | Parent Line Identifier of the sales order. | ||
| ERROR_TYPE | NUMBER | Error types=> 1=MAD, 2=MAPE, Null= Neither | |||
| ATP_SYNCHRONIZATION_FLAG | NUMBER | ATP Synchronization Flag for 24x7 ATP | |||
| COMP_SEQ_ID | NUMBER | 18 | Unique Component Sequence Identifier | ||
| UNBUCKETED_DEMAND_DATE | DATE | Stores the unbucketed demand date | |||
| QUANTITY_PER_ASSEMBLY | NUMBER | This value indicates the Part usage quantity. | |||
| RELEASE_STATUS | NUMBER | This value indicates the release error description. | |||
| RESCHEDULE_FLAG | NUMBER | Flag indicates whether the supply/demand is rescheduled in/out. | |||
| LOAD_TYPE | NUMBER | Load program to execute during release. | |||
| IMPLEMENT_ORG_ID | NUMBER | 18 | Identifies the Implement Org ID | ||
| IMPLEMENT_INSTANCE_ID | NUMBER | 18 | Identifies the Implement Source Instance ID | ||
| IMPLEMENT_DATE | DATE | Identifies the Implement Schedule Ship Date | |||
| RELEASE_ERRORS | VARCHAR2 | 250 | This value indicates the release error description. | ||
| ORG_FIRM_FLAG | NUMBER | Flag indicates whether the organization is firm for the demand. | |||
| ORIGINAL_ORG_ID | NUMBER | 18 | For Sales Orders : Original Organization Id on the Order | ||
| ORIGINAL_INST_ID | NUMBER | 18 | For Sales Orders : Original Instance Id on the Sales Order | ||
| ARRIVAL_SET_ID | NUMBER | 18 | Arrival Set to which the Order Line belongs to | ||
| SHIP_SET_ID | NUMBER | 18 | Ship set identifier of the lines that are part of a ship_set. | ||
| ORDER_DATE_TYPE_CODE | NUMBER | For sales Order if type is Ship or Arrival | |||
| SCHEDULE_ARRIVAL_DATE | DATE | Schedule Arrival Date of Demand | |||
| LATEST_ACCEPTABLE_DATE | DATE | Latest Acceptable Date on Sales Order | |||
| SHIPPING_METHOD_CODE | VARCHAR2 | 30 | Shipping method code used for material movement. | ||
| PLANNED_ARRIVAL_DATE | DATE | Updated after Planning : the planned arrival date | |||
| REQUEST_SHIP_DATE | DATE | Requested ship date of the demand record. | |||
| PROMISE_SHIP_DATE | DATE | Date promised to the customer for the order shipment. | |||
| SCHEDULE_SHIP_DATE | DATE | Schedule ship date on the sales order demand. | |||
| ORIGINAL_DEMAND_ID | NUMBER | 18 | Original Demand Id refers to the Original Demand.This could be a Sales Order or a Forecast.In a Global Forecast Situation a Sales Order can get split into multiple demands satisfied indifferent organizations. When NULL, Original_Demand_Id is the same as Demand_Id. | ||
| ZONE_ID | NUMBER | 18 | This value indicates the zone identifier on the demand record. | ||
| ORIG_SHIPPING_METHOD_CODE | VARCHAR2 | 30 | Original shipping method code on demand | ||
| INTRANSIT_LEAD_TIME | NUMBER | Identifies the Intransit Lead Time. The column is no longer populated as part of bug#25370749 | |||
| ORIG_INTRANSIT_LEAD_TIME | NUMBER | This value stores original intransit lead time of the supply/demand. | |||
| ATP_OVERRIDE_FLAG | NUMBER | Flag to indicate if atp is overridden | |||
| IMPLEMENT_FIRM | NUMBER | Identifies the Implement Firm Flag | |||
| IMPLEMENT_EARLIEST_DATE | DATE | Identifies the Implement Earliest Ship Date | |||
| IMPLEMENT_ARRIVAL_DATE | DATE | Implement Schedule Arrival Date | |||
| ATO_LINE_ID | NUMBER | 18 | Indicates LINE ID of the top ATO model | ||
| SHIPPING_PREFERENCE | VARCHAR2 | 1200 | Shipping preference specified for the demand. | ||
| ROOT_FULFILLMENT_LINE | VARCHAR2 | 400 | Root fulfillment line of the sales order demand for ATO/CTO item. | ||
| PARENT_FULFILLMENT_LINE | VARCHAR2 | 400 | Parent fulfillment line number/identifier of the fulfillment line. | ||
| CONFIGURED_ITEM | VARCHAR2 | 1200 | Unique identifier of the configured item | ||
| INCLUDED_ITEMS_FLAG | NUMBER | Flag indicates whether the demand is for the included PTO item. | |||
| TOP_MODEL_LINE_ID | NUMBER | 18 | This value indicates the Line id Of the Top Model. | ||
| PARENT_MODEL_LINE_ID | NUMBER | 18 | Line identifier of the parent model in ATO/CTO setup. | ||
| STD_MANDATORY_COMP_FLAG | NUMBER | Flag indicating whether the record if standard mandatory component or not. | |||
| OLD_REFRESH_NUMBER | NUMBER | This value indicates Old Refresh Number. | |||
| SHIP_METHOD | VARCHAR2 | 30 | Shipping method used to move the material. | ||
| SHIP_CALENDAR | VARCHAR2 | 15 | Shipping calendar for the organization/supplier. | ||
| RECEIVING_CALENDAR | VARCHAR2 | 15 | This value indicates the Receiving calendar. | ||
| INTRANSIT_CALENDAR | VARCHAR2 | 15 | Calendar to be considered during transit | ||
| SHIP_TO_LOCATION_ID | NUMBER | 18 | Will store the external location id. | ||
| ORIGINAL_QUANTITY | NUMBER | Original Quantity of the demand | |||
| FINAL_USE_PRIORITY | NUMBER | Final use priority. Used in DRP allocation. | |||
| FINAL_USE_DATE | DATE | This value indicates the Final use date. | |||
| ARRIVAL_SET_NAME | VARCHAR2 | 30 | Arrival Set to which the Order Line belongs to | ||
| SHIP_SET_NAME | VARCHAR2 | 50 | Ship set name of the lines that are part of a ship_set. | ||
| SOURCE_PHANTOM_ID | NUMBER | 18 | Top Level Phantom Component Identifier | ||
| PRIMARY_COMPONENT_ID | NUMBER | Component identifier of t he primary component for the current component | |||
| ATP_SESSION_ID | NUMBER | 18 | Unique session Id for the ATP inquiry | ||
| IMPLEMENT_SHIP_DATE | DATE | Ship date entered by user during release. | |||
| PLANNED_SHIP_DATE | DATE | Planned ship date calculated by the engine for the demand. | |||
| PRIOR_ALLOCATION_QTY | NUMBER | Prior allocation quantity for the demand record. | |||
| MANUAL_ALLOCATION_QTY | NUMBER | Manual allocation date for the demand record. | |||
| MANUAL_ALLOCATION_DATE | DATE | Manual allocation date for the demand record. | |||
| FIRM_ALLOCATION_FLAG | NUMBER | Flag indicates whether the allocation is made firm. | |||
| ASSET_SERIAL_NUMBER | VARCHAR2 | 30 | Asset number or rebuild serial number | ||
| ASSET_ITEM_ID | NUMBER | 18 | Fk it item id. Asset group id or rebuild_item_id | ||
| EXPIRATION_DATE | DATE | Expiration date of the demand record. | |||
| SALES_ORDER_LINE_SPLIT | NUMBER | Flag indicates whether fulfill line can be split based on partial availability. | |||
| PLANNED_INBOUND_DUE_DATE | DATE | Due date of the planned order created during the push down phase of DRP. | |||
| FILL_KILL_FLAG | NUMBER | Flag to indicate whether a SO line has been killed. | |||
| DEFINITION_LEVEL_USED | NUMBER | The most specific definition level used for the current demand record | |||
| DEMAND_FULFILLMENT_LEAD_TIME | NUMBER | Lead time associated with the demand. | |||
| COMPONENT_SCALING_TYPE | NUMBER | Whether required component quantity is item-based or lot-based | |||
| COMPONENT_YIELD_FACTOR | NUMBER | Factor used to multiply component quantity with to obtain component quantity | |||
| SPLIT_FROM_DEMAND_ID | NUMBER | 18 | The demand_id of the sales order line from where the split has happened. | ||
| 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. | |
| DAYS_LATE | NUMBER | Number of days the demand is delayed by. | |||
| 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. | |||
| PREV_SUBST_ITEM | NUMBER | Previous substitute item of the demand record. | |||
| REVISED_DMD_DATE | DATE | Revised demand date of the demand record. | |||
| REVISED_DMD_PRIORITY | NUMBER | Revised demand priority of the demand record. | |||
| COLL_ORIGINATION_TYPE | NUMBER | Origination type of the demands being collected over. | |||
| DAYS_PAST_DUE | NUMBER | exception detail for past due sales orders | |||
| QTY_SATISFIED_BY_RDD | NUMBER | exception detail for forecast pull-in sales order pull-in | |||
| 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. | |||
| 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. | |||
| EXPENSE_TRANSFER | NUMBER | EXPENSE TRANSFER and it valid values are 1 (Yes) or 2 (No) | |||
| INTERFACED_TO_DOO | NUMBER | Indicated if the Transfer Order Expense record is interfaced with DOO. | |||
| PARENT_MODEL_ITEM_ID | NUMBER | 18 | id of base model item. -23453 for standard items and models | ||
| BASE_PLAN_ID | NUMBER | base plan identifier for the record | |||
| PRIMARY_COMP_QTY_PER | NUMBER | Existing component's quantity per assembly/product. Populated when it is substituted with another component. | |||
| SUBS_COMPONENT_QTY_PER | NUMBER | Substitute component's quantity per assembly/product. Populated when it is substituted with another component. | |||
| MATERIAL_SEQ_NUMBER | NUMBER | Indicates the sequence of this material line within this operation. | |||
| SUB_INVENTORY_CODE | VARCHAR2 | 10 | This value indicates the Sub inventory code. | ||
| SUBINV_FLAG | NUMBER | 1 | This indicates whether the row is for ITEM+ORG /ITEM+SUBORG | ||
| SOURCE_SUBINVENTORY_CODE | VARCHAR2 | 10 | Source side subinventory code of the demand for intra org transfer and movement request demands. | ||
| SET_HEADER_NAME | VARCHAR2 | 280 | This value indicates the records belongs to a set. Will hold combination of Order Number and Set Name | ||
| INQUIRY_DEMAND | NUMBER | Flag to indicate if the demand is an Inquiry Demand. | |||
| 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. | ||
| GOP_REFERENCE_ID | VARCHAR2 | 300 | Cross reference id of the recommended split fulfillment line created by GOP. | ||
| ASSET_NUMBER | VARCHAR2 | 80 | A user-specified identifier for the asset object that has been associated to a maintenance work order. | ||
| EXECUTION_SEQUENCE | NUMBER | Indicates the execution sequence number of the operation if the work order has the re-sequence operations. | |||
| ORDER_LINE_STATUS | NUMBER | It indicates the status of order line whether it is picked, shipped, awaiting,shipping or at any other custom step. | |||
| 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 demand. 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. | ||
| LOT_NUMBER | VARCHAR2 | 80 | Lot number for on-hand quantities | ||
| OVERRIDE_DEMAND_PRIORITY | NUMBER | Stores the user overridden demand priority. Used only by constrained planning engine. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| MSC_DEMANDS | msc_parameters | ORGANIZATION_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns | Status |
|---|---|---|---|---|
| MSC_DEMANDS_N1 | Non Unique | Default | PLAN_ID, USING_ASSEMBLY_DEMAND_DATE, INVENTORY_ITEM_ID, ORGANIZATION_ID | |
| MSC_DEMANDS_N10 | Non Unique | Default | PLAN_ID, DISPOSITION_ID, OP_SEQ_NUM | |
| MSC_DEMANDS_N2 | Non Unique | Default | PLAN_ID, ORGANIZATION_ID, INVENTORY_ITEM_ID, ORIGINATION_TYPE, PART_KEY1 | |
| MSC_DEMANDS_N3 | Non Unique | FUSION_TS_TX_IDX | PLAN_ID, SCHEDULE_DESIGNATOR_ID, ORGANIZATION_ID | |
| MSC_DEMANDS_N4 | Non Unique | Default | PLAN_ID, INVENTORY_ITEM_ID, ORGANIZATION_ID, ORIGINATION_TYPE, PART_KEY1 | |
| MSC_DEMANDS_N5 | Non Unique | Default | PLAN_ID, ORIGINATION_TYPE, ORGANIZATION_ID, SALES_ORDER_LINE_ID | |
| MSC_DEMANDS_N6 | Non Unique | Default | PLAN_ID, USING_ASSEMBLY_DEMAND_DATE, ORIGINATION_TYPE, INVENTORY_ITEM_ID | |
| MSC_DEMANDS_N7 | Non Unique | Default | PLAN_ID, ORIGINATION_TYPE, PARENT_FULFILLMENT_LINE, SALES_ORDER_NUMBER | Obsolete |
| MSC_DEMANDS_N8 | Non Unique | Default | PLAN_ID, ORIGINATION_TYPE, SET_HEADER_NAME | |
| MSC_DEMANDS_N9 | Non Unique | Default | PLAN_ID, ORIGINATION_TYPE, SALES_ORDER_LINE_ID | |
| MSC_DEMANDS_U1 | Unique | Default | PLAN_ID, DEMAND_ID, PART_KEY1 |