MSC_BM_DEMANDS
This table stores the data for Backlog Management for Sales Orders within Planning horizon.
Details
-
Schema: FUSION
-
Object owner: MSC
-
Object type: TABLE
-
Tablespace: APPS_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
MSC_BM_DEMANDS_PK |
PLAN_ID, DEMAND_ID, PART_KEY1 |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| DEMAND_ID | NUMBER | 18 | Yes | Field indicates unique identifier for a demand. | |
| BASE_DEMAND_ID | NUMBER | 18 | Value indicates demand id of the original sales order. | ||
| PLAN_ID | NUMBER | Yes | Field indicates unique identifier for a Backlog Management Run. | ||
| DEMAND_LEAD_TIME_DATE | DATE | Field indicates the lead time date value calculated using ordered date and demand lead time. | |||
| USR_DEF_DMD_LEAD_TIME_DATE | DATE | Field to indicate user-defined demand lead time date, which should always be respected in BM. | |||
| DEMAND_FULFILLMENT_LEAD_TIME | NUMBER | Field indicates Fulfillment Lead Time of Backlog Management run demand. | |||
| REASON_CODE | NUMBER | Field indicates Reason Code for Backlog Management run demand. | |||
| DEMAND_PRIORITY | NUMBER | Field indicates priority of the demand. | |||
| NEW_PROMISED_DATE | DATE | Field indicates new promised date of Backlog Management demand. | |||
| OLD_PROMISED_DATE | DATE | Field indicates old promised date of the Backlog Management demand. | |||
| SOURCE_ORGANIZATION_ID | NUMBER | Field indicates identifier for the source organization. | |||
| FIRM_SALES_ORDER | NUMBER | Field contains flag whether to firm sales order. | |||
| FIRM_SHIP_FROM_ORG | NUMBER | 18 | Field contains value of firm ship from org. | ||
| FIRM_SHIP_SET_NAME | VARCHAR2 | 50 | Name of ship set that used to group firm orders for same shipping. | ||
| FIRM_ARRIVAL_SET_NAME | VARCHAR2 | 50 | Name of arrival set that used to group firm orders for same arriving. | ||
| EARLIEST_PROMISED_DATE | DATE | This column contains value of EARLIEST_PROMISED_DATE. | |||
| EXPECTED_SHIP_DATE | DATE | This column contains value of expected ship date. | |||
| EXPECTED_ARRIVAL_DATE | DATE | This column contains value of expected arrival date. | |||
| ECC_FLAG | NUMBER | This column contains value of enforce capacity constraints flag. | |||
| PULL_IN_FLAG | NUMBER | Field indicates flag whether pullin enabled. | |||
| MANUAL_OVERRIDE_FLAG | NUMBER | Field indicates status manual override flag. | |||
| EXPECTED_SHIP_METHOD | VARCHAR2 | 30 | Field indicates value of expected ship method. | ||
| EXPECTED_CARRIER_ID | NUMBER | Field indicates identifier for expected carrier. | |||
| EXPECTED_SERVICE_LEVEL_ID | NUMBER | Field indicates value of expected service level. | |||
| EXPECTED_MODE_OF_TRANSPORT_ID | NUMBER | Field indicates value of expected mode of transport for the Backlog Management run demand. | |||
| EXPECTED_SUPPLIER_ID | NUMBER | Field indicates identifier of expected supplier for Backlog Management run demand. | |||
| EXPECTED_SUPPLIER_SITE_ID | NUMBER | Field indicates identifier for expected supplier site. | |||
| CUSTOMER_ID | NUMBER | 18 | Field indicates identifier of the customer. | ||
| CUSTOMER_SITE_ID | NUMBER | Field indicates identifier of the customer site. | |||
| DEMAND_CLASS | VARCHAR2 | 34 | Field indicates identifier of the demand class. | ||
| SELLING_PRICE | NUMBER | Field indicates value of the selling price. | |||
| ORCH_ORDER_HEADER_ID | NUMBER | 18 | Reference to the unique identifier for the orchestration order. | ||
| ORCH_ORDER_LINE_ID | NUMBER | 18 | Reference to the unique identifier for the orchestration order line. | ||
| CARRIER_ID | NUMBER | Field indicates identifier for carrier. | |||
| MODE_OF_TRANSPORT | NUMBER | Field indicates identifier for mode of transport. | |||
| SERVICE_LEVEL | NUMBER | Field indicates identifier for service level. | |||
| RESERVATION_ID | NUMBER | 18 | Field indicates identifier for reservation. | ||
| RESERVED_QUANTITY | NUMBER | Field indicates value of reserved quantity. | |||
| ORGANIZATION_ID | NUMBER | Field indicates identifier of organization. | |||
| SCHEDULED_SHIP_FROM_ORG_ID | NUMBER | Field indicates identifier of scheduled ship from org. | |||
| ORIGINAL_ITEM_ID | NUMBER | 18 | Field indicates identifier of original item. | ||
| RECEIVING_ORG_ID | NUMBER | 18 | Field indicates identifier of receiving organization. | ||
| CONFIGURATION_ITEM | VARCHAR2 | 1200 | Unique identifier of the configured item. | ||
| SUPPLIER_ID | NUMBER | Field indicates identifier of supplier. | |||
| SUPPLIER_SITE_ID | NUMBER | Field indicates identifier of supplier site. | |||
| USING_REQUIREMENT_QUANTITY | NUMBER | Field indicates value of using requirement quantity. | |||
| LATEST_ACCEPTABLE_SHIP_DATE | DATE | Field indicates value of latest acceptable ship date. | |||
| LATEST_ACCEPTABLE_ARRIVAL_DATE | DATE | Field indicates value of latest acceptable arrival date. | |||
| EARLIEST_ACCEPT_SHIP_DATE | DATE | Field indicates value of earliest acceptable ship date. | |||
| EARLIEST_ACCEPT_ARRIVAL_DATE | DATE | Field indicates value of earliest acceptable arrival date. | |||
| ORDER_DATE_TYPE_CODE | NUMBER | Field indicates the code of order date type for Backlog Management run demand. | |||
| SHIP_METHOD | VARCHAR2 | 30 | Field indicates value of ship method. | ||
| SCHEDULE_ARRIVAL_DATE | DATE | Field indicates value of schedule arrival date. | |||
| USING_ASSEMBLY_DEMAND_DATE | DATE | Field indicates value of using assembly demand date. | |||
| ZONE_ID | NUMBER | 18 | Field indicates identifier of zone. | ||
| ROOT_FULFILLMENT_LINE | VARCHAR2 | 400 | Field indicates value of root fulfillment line. | ||
| SHIP_SET_ID | NUMBER | Field indicates identifier of ship set. | |||
| SHIP_SET_NAME | VARCHAR2 | 50 | Field indicates name of ship set. | ||
| ORIGINAL_SHIP_SET_ID | NUMBER | Field indicates identifier of original ship set. | |||
| ORIGINAL_SHIP_SET_NAME | VARCHAR2 | 50 | Field indicates value of original ship set. | ||
| SET_TYPE | NUMBER | Field indicates identifier of set type. | |||
| ORIGINAL_PRIORITY | NUMBER | Field indicates value of original priority. | |||
| SALES_ORDER_LINE_SPLIT | NUMBER | Flag indicates whether fulfill line can be split based on partial availability. | |||
| FULFILLMENT_COST | NUMBER | Field indicates value of fulfillment cost. | |||
| SHIPPING_PREFERENCE | VARCHAR2 | 1200 | Field indicates value of shipping preference. | ||
| ORDERED_UOM | VARCHAR2 | 25 | Field indicates value of Ordered UOM. | ||
| UOM_RATE | NUMBER | Field indicates value of UOM rate. | |||
| SALES_ORDER_NUMBER | VARCHAR2 | 240 | Field indicates unique identifier for a sales order. | ||
| SO_LINE_NUM | VARCHAR2 | 150 | Sales order line number of the sales order demand. | ||
| ORDER_NUMBER | VARCHAR2 | 400 | This value indicates the Sales order number. | ||
| LATEST_ACCEPTABLE_DATE | DATE | Latest Acceptable Date on sales order. | |||
| BOM_ITEM_TYPE | NUMBER | Field indicates identifier of Item Structure Type. | |||
| BOM_ITEM_TYPE_CODE | VARCHAR2 | 80 | This value indicates Item Structure Type. | ||
| ITEM_SUB_TYPE_CODE | NUMBER | More specific sub group for ITEM_TYPE_CODE. Model/Service/One-Time Item characteristic detail (like ATO, PTOSMC, PTONONSMC). | |||
| ORDER_TYPE_CODE | NUMBER | For sales Order if type is Ship or Arrival. | |||
| SCHEDULE_SHIP_DATE | DATE | Schedule ship date on the sales order demand. | |||
| SALES_ORDER_LINE_ID | VARCHAR2 | 400 | This value indicates the Sales order line identifier. | ||
| RESERVATION_STATUS | NUMBER | Flag indicates value of reservation status. Valid values 1-Yes, 2-No. | |||
| ORDER_MARGIN | NUMBER | This value indicates the order margin of the demand. | |||
| EARLIEST_ACCEPTABLE_DATE | DATE | Field indicates Earliest Acceptable Date of Backlog Management run demand. | |||
| PROMISED_ARRIVAL_DATE | DATE | This column contains value of Promised Arrival Date. | |||
| PROMISED_SHIP_DATE | DATE | This column contains value of Promised Ship Date. | |||
| ORDER_LINE_NUMBER | VARCHAR2 | 450 | Field to indicate sales order number and line number which helps in identifying split lines. | ||
| ORDER_TYPE | VARCHAR2 | 80 | Field indicates type of the Order Promising Demand. | ||
| REQUEST_DATE | DATE | Request date of the demand record. | |||
| SCHEDULE_DATE | DATE | Schedule date of the demand record. | |||
| DAYS_LATE | NUMBER | 38 | Number of days the demand is delayed by. | ||
| ORDER_REVENUE | NUMBER | Field contains value of revenue for the Backlog Management demand. | |||
| ORIGINAL_ORG_ID | NUMBER | 18 | For Sales Orders : Original Organization Id on the Order. | ||
| DEMAND_TYPE | NUMBER | Demand type. Discrete Demand(1), Rate-based demand(2). | |||
| USING_ASSEMBLY_ITEM_ID | NUMBER | Using assembly item identifier (item generating the demand for dependent demands). | |||
| ORIGINAL_QUANTITY | NUMBER | Original Quantity of the demand. | |||
| SOURCE_ORG_INSTANCE_ID | NUMBER | 18 | This value indicates the source organization instance identifier. | ||
| DEMAND_SOURCE_INSTANCE | VARCHAR2 | 360 | Field indicates the Demand Source Instance. | ||
| 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). | |||
| MIN_PERCENTAGE_FOR_SPLIT | NUMBER | Minimum percentage for splitting the demand. | |||
| MIN_QUANTITY_FOR_SPLIT | NUMBER | Minimum quantity value for splitting the demand. | |||
| ORCH_ORDER_LINE_NUMBER | VARCHAR2 | 100 | Reference to the number of the originating sales order line. | ||
| ORCH_ORDER_NUMBER | VARCHAR2 | 50 | Reference to the number of the originating sales order. | ||
| PROMISE_DATE | DATE | Date promised to the customer for the order availability. | |||
| PROMISING_SYSTEM | VARCHAR2 | 50 | Promising system that satisfies the incoming demand. | ||
| COMPLETED_QUANTITY | NUMBER | The value indicates completed quantity of the total wip job quantity. | |||
| DEMAND_SOURCE_TYPE | NUMBER | Forecast billing address identifier. | |||
| SOURCE_DOCUMENT_LINE_NUMBER | VARCHAR2 | 150 | Source side value of the document line, like PO/PR, that is linked to the demand. | ||
| SOURCE_DOCUMENT_NUMBER | VARCHAR2 | 240 | Source side value of the document, like PO/PR, that is linked to the demand. | ||
| PART_KEY1 | NUMBER | Yes | Source system from where the demand is originated. | ||
| INVENTORY_ITEM_ID | NUMBER | 18 | Yes | Identifies the inventory item id. | |
| PARENT_FULFILLMENT_LINE | VARCHAR2 | 400 | Parent fulfillment line number/identifier of the fulfillment line. | ||
| SET_PARENT_FULFILLMENT_LINE | VARCHAR2 | 400 | Field indicates the Parent fulfillment line of the set. | ||
| REQUESTED_QUANTITY | NUMBER | Field to indicate requested quantity to split the order. | |||
| SCHEDULED_QUANTITY | NUMBER | Field indicates the Scheduled Quantity of the sales order. | |||
| FULFILLMENT_MODE | VARCHAR2 | 80 | Field indicates the value of Fulfillment Mode. | ||
| SCHEDULED_DAYS_OF_DELAYS | NUMBER | 38 | Field indicates the Schedule days of delay for the sales order. | ||
| RELEASE_STATUS | NUMBER | This value indicates the release error description. | |||
| RELEASE_STATUS_ORIG | NUMBER | Field indicates the Original Release Status. | |||
| SUPPLIER_SITE_SOURCE_SYSTEM_ID | NUMBER | Source system identifier associated with the supplier site. | |||
| INTERNAL_ORDER_TYPE | VARCHAR2 | 4 | Field indicates the Internal Order Type. | ||
| SET_HEADER_NAME | VARCHAR2 | 280 | This value indicates the records belongs to a set. Will hold combination of Order Number and Set Name. | ||
| OVERRIDE_PRIORITY | VARCHAR2 | 40 | Field indicates overridden priority value for Backlog Management run demand. | ||
| ORDERED_DATE | DATE | This value indicates the ordered date on the demand. | |||
| INQUIRY_DEMAND | NUMBER | Flag to indicate if the demand is an Inquiry Demand. | |||
| EXPENSE_TRANSFER | NUMBER | Flag to indicate EXPENSE TRANSFER and it valid values are 1 (Yes) or 2 (No). | |||
| SOURCE_DOC_ORDER_TYPE | VARCHAR2 | 80 | This value indicates Order types used for demands. | ||
| REMOVED_FROM_SET | NUMBER | Field to indicate if an order has been removed from set. | |||
| ORDER_LINE_STATUS | NUMBER | It indicates the status of order line whether it is picked, shipped, awaiting,shipping or at any other custom step. | |||
| CONSTRAINT_RANK | NUMBER | Field to indicate the order rank of Constraint in Backlog Planning. | |||
| DAYS_POTENTIALLY_IMPROVE | NUMBER | Field to indicate number of days potentially improved when using date from ShipSet or ArrivalSet. | |||
| PLANNED_DATE_WITHOUT_ITEM | DATE | Field to indicate the date from ShipSet or ArrivalSet. It gives the expected plan output date of the set without this item or sales order line being planned. | |||
| SOURCE_DOC_ORDER_TYPE_STR | VARCHAR2 | 100 | Field indicates the Source Document Order Type. | ||
| 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. | |
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| MARKED_FOR_RELEASE | NUMBER | Field indicates flag whether Backlog Management demand marked for release. | |||
| RELEASE_ID | NUMBER | Column to group set of demands so that they can be released together. | |||
| SPLIT_INDICATOR | NUMBER | Column to indicate whether a sales order line is split. Valid values are: 1 or Null (Original demand line, no split), 2 (Original Original demand line that is split), 3 (New demand line created after splitting). | |||
| ORIG_PARENT_FUL_LINE | VARCHAR2 | 400 | Column to indicate the original parent fulfillment line value of the sales order. | ||
| 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. | |||
| 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_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. | ||
| 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. | |||
| SUPPLY_PICK_DATE | DATE | Column to indicate the date when supply is picked from shipping organization. | |||
| USER_DEFINED_PRIORITY | VARCHAR2 | 100 | Field indicates user defined priority of the demand. | ||
| 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. | ||
| SCHEDULED_CARRIER_ID | NUMBER | 18 | Field indicates identifier of scheduled carrier. | ||
| SCHEDULED_MODE_OF_TRANSPORT | NUMBER | 18 | Field indicates identifier of scheduled mode of transport. | ||
| SCHEDULED_SERVICE_LEVEL | NUMBER | 18 | Field indicates identifier of scheduled service level. | ||
| SCHEDULED_SHIP_METHOD | VARCHAR2 | 30 | Field indicates value of scheduled ship method. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| MSC_BM_DEMANDS_N1 | Non Unique | Default | ORGANIZATION_ID, INVENTORY_ITEM_ID, USING_ASSEMBLY_DEMAND_DATE, REQUEST_DATE, PLAN_ID, PART_KEY1 |
| MSC_BM_DEMANDS_N2 | Non Unique | Default | INVENTORY_ITEM_ID, ORGANIZATION_ID, USING_ASSEMBLY_DEMAND_DATE, REQUEST_DATE, PLAN_ID, PART_KEY1 |
| MSC_BM_DEMANDS_N3 | Non Unique | Default | SET_HEADER_NAME, PLAN_ID, PART_KEY1 |
| MSC_BM_DEMANDS_N4 | Non Unique | Default | CUSTOMER_ID, USING_ASSEMBLY_DEMAND_DATE, REQUEST_DATE, PLAN_ID, PART_KEY1 |
| MSC_BM_DEMANDS_N5 | Non Unique | Default | PARENT_FULFILLMENT_LINE, ROOT_FULFILLMENT_LINE, PLAN_ID, PART_KEY1 |
| MSC_BM_DEMANDS_N6 | Non Unique | Default | SALES_ORDER_LINE_ID, ROOT_FULFILLMENT_LINE, PLAN_ID, PART_KEY1 |
| MSC_BM_DEMANDS_N7 | Non Unique | Default | ORDER_NUMBER, ORDER_LINE_NUMBER, CONSTRAINT_RANK, PLAN_ID, PART_KEY1 |
| MSC_BM_DEMANDS_U1 | Unique | Default | PLAN_ID, DEMAND_ID, PART_KEY1 |