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. |
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_U1 | Unique | Default | PLAN_ID, DEMAND_ID, PART_KEY1 |