MSC_ST_DEMANDS
The staging table used by the collection program to validate and process data for table MSC_DEMANDS.
Details
-
Schema: FUSION
-
Object owner: MSC
-
Object type: TABLE
-
Tablespace: INTERFACE
Columns
Name | Datatype | Length | Precision | Not-null | Comments | Status |
---|---|---|---|---|---|---|
ORDER_PRIORITY | NUMBER | This value indicates the order priority of the demand. | ||||
SELLING_PRICE_CURR_CODE | VARCHAR2 | 15 | Transactional currency code captured at the order header level. | |||
PO_LINE_LOCATION_ID | VARCHAR2 | 320 | used for dropship so - po reservations | |||
DROPSHIP_PO_NUMBER | VARCHAR2 | 240 | Purchase order number of the drop ship PO | |||
DROPSHIP_PO_LINE_NUM | VARCHAR2 | 150 | Line number of the drop ship PO | |||
DROPSHIP_PO_SCHEDULE_LINE_NUM | VARCHAR2 | 150 | Schedule line number of the drop ship PO | |||
PROMISE_ARRIVAL_DATE | DATE | Promise arrival date of the sales order demand. | ||||
SALESREP_CONTACT | VARCHAR2 | 50 | This value indicates the Sales representative contact info. | |||
CUSTOMER_PO_NUMBER | VARCHAR2 | 50 | 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. | |||
INTRANSIT_LEAD_TIME | NUMBER | Identifies the Intransit Lead Time | ||||
MIN_REM_SHELF_LIFE_DAYS | NUMBER | Minimum remaining shelf life days demand for the demand. | ||||
INVENTORY_ORGANIZATION_CODE | VARCHAR2 | 18 | Code of the inventory organization that the product belongs to. | |||
DEMAND_SOURCE_SYSTEM | VARCHAR2 | 30 | Source system from where the demand is originated. | |||
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. | ||||
SOURCE_SCHEDULE_NUMBER | VARCHAR2 | 50 | This value indicates the Source schedule number. | |||
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 | |||
DISABLE_DATE | DATE | used to logically delete forecast demands. | ||||
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 | ||||
MIN_PERCENTAGE_FOR_SPLIT | NUMBER | Minimum percentage for splitting the demand. | ||||
MIN_QUANTITY_FOR_SPLIT | NUMBER | Minimum quantity value for splitting the demand. | ||||
SUPPLIER_SITE_SOURCE_SYSTEM | VARCHAR2 | 30 | Source system associated with the supplier site. | |||
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. | |||
CONFIGURED_ITEM_NAME | VARCHAR2 | 1200 | Name given to the configured item | |||
INVENTORY_ORGANIZATION_ID | NUMBER | Inventory organization identifier | ||||
DEMAND_SOURCE_SYSTEM_ID | NUMBER | Source system from where the demand is originated. | ||||
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. | |||
SUPPLIER_SITE_SOURCE_SYSTEM_ID | NUMBER | Source system identifier associated with the supplier site. | Obsolete | |||
FULFILLMENT_LINE_NUM | NUMBER | Line number of the fulfillment (demand) | ||||
FORECAST_INTERMIT_DEMAND_FLAG | NUMBER | Forecast intermittent demand flag for the forecast record. | ||||
FORECAST_AVG_INTERARRIVAL_TIME | NUMBER | Forecast average inter-arrival time for the forecast demand. | ||||
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. | ||||
FORECAST_SET_NAME | VARCHAR2 | 10 | Name assigned to the forecast set | |||
SHIP_TO_SITE_CODE | VARCHAR2 | 255 | Name of the party/partner where the shipment if headed for. | |||
BILL_TO_SITE_CODE | VARCHAR2 | 255 | Bill to site code for the customer bill to site. | |||
BILL_TO_SITE_ID | NUMBER | party site id of the bill to customer site. | ||||
CARRIER_NAME | VARCHAR2 | 360 | Carrier Name (Party Name of the Carrier) | |||
MODE_OF_TRANSPORT | VARCHAR2 | 80 | Type of transportation used to ship the product, such as truck, air or boat. | |||
SHIP_SET_ID | NUMBER | Ship set identifier of the lines that are part of a ship_set. | ||||
SHIP_SET_NAME | VARCHAR2 | 50 | Ship set name of the lines that are part of a ship_set. | |||
ARRIVAL_SET_ID | NUMBER | Arrival Set to which the Order Line belongs to | ||||
ARRIVAL_SET_NAME | VARCHAR2 | 50 | Arrival Set to which the Order Line belongs to | |||
DEMAND_PRIORITY | VARCHAR2 | 30 | Demand priority. Used by scheduling heuristic | |||
ORDERED_UOM | VARCHAR2 | 50 | This value indicates the ordered unit of measure on the demand. | |||
SUPPLIER_NAME | VARCHAR2 | 360 | This value indicates the Supplier name collected from source system. | |||
SUPPLIER_ID | NUMBER | This value indicates the Supplier identifier in the planning system. | ||||
SUPPLIER_SITE_CODE | VARCHAR2 | 240 | This value indicates the Supplier site code collected from source system. | |||
SUPPLIER_SITE_ID | NUMBER | This value indicates the Supplier site identifier. | ||||
SHIPPING_PREFERENCE | VARCHAR2 | 150 | Shipping preference specified for the demand. | |||
PARENT_FULFILLMENT_LINE | VARCHAR2 | 150 | 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. | ||||
ROOT_FULFILLMENT_LINE | VARCHAR2 | 150 | Root fulfillment line of the sales order demand for ATO/CTO item. | |||
DEMAND_ID | NUMBER | This column identifies the demand. | ||||
INVENTORY_ITEM_ID | NUMBER | Identifies the inventory item id | ||||
ORGANIZATION_ID | NUMBER | Reference to the unique identifier for the organization of the source order. | ||||
USING_ASSEMBLY_ITEM_ID | NUMBER | Using assembly item identifier (item generates demand for dependent demands) | ||||
USING_ASSEMBLY_DEMAND_DATE | DATE | Using assembly demand date (due date) of the demand. | ||||
USING_REQUIREMENT_QUANTITY | NUMBER | Required quantity (demand quantity) of the demand. | ||||
ASSEMBLY_DEMAND_COMP_DATE | DATE | Using assembly demand completion date | ||||
DEMAND_TYPE | NUMBER | Discrete Demand(1), Rate-based demand(2) | ||||
DAILY_DEMAND_RATE | NUMBER | Repetitive demand rate for the item being manufactured. | ||||
ORIGINATION_TYPE | NUMBER | Origin of the demand: Planned order, hard reservation, etc... | ||||
SOURCE_ORGANIZATION_ID | NUMBER | This value indicates the Source organization identifier. | ||||
DISPOSITION_ID | NUMBER | Identifier reference to the supply generating the demand | ||||
RESERVATION_ID | NUMBER | Reservation identifier of the demand if it is linked to dependent demand/supply. | ||||
DEMAND_SCHEDULE_NAME | VARCHAR2 | 10 | Name of the forecast for this demand | |||
PROJECT_ID | NUMBER | 18 | Project identifier to which the demand applies | |||
TASK_ID | NUMBER | 18 | Task identifier to which the demand applies | |||
PLANNING_GROUP | VARCHAR2 | 30 | This value indicates the planning group of the record. | |||
END_ITEM_UNIT_NUMBER | VARCHAR2 | 30 | This value indicates End item unit number. | |||
SCHEDULE_DATE | DATE | This value indicates the Schedule date. | ||||
OPERATION_SEQ_NUM | NUMBER | This is the Operation Sequence Number for the Operation Sequence. This is needed to relate the data in planning server to the legacy system and is for reference purpose only. | ||||
QUANTITY_ISSUED | NUMBER | This value indicates the Quantity issued. | ||||
DEMAND_CLASS | VARCHAR2 | 80 | Class to which the demand is tied. | |||
SALES_ORDER_NUMBER | VARCHAR2 | 240 | This value indicates the Sales order number. | |||
SALES_ORDER_PRIORITY | NUMBER | This value indicates the Sales order priority. | ||||
FORECAST_PRIORITY | NUMBER | Forecast priority. Used in forecast processing. | ||||
MPS_DATE_REQUIRED | DATE | This value indicates the MPS date required. | ||||
PO_NUMBER | VARCHAR2 | 62 | Purchase order header number collected from source system. | |||
WIP_ENTITY_NAME | VARCHAR2 | 240 | This stores the value of WIP job name for an assembly. | |||
DELETED_FLAG | NUMBER | Yes/No flag indicating whether the row will be deleted | ||||
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. | |||
SR_INSTANCE_ID | NUMBER | Source application instance identifier | ||||
REFRESH_NUMBER | NUMBER | Refresh identifier populated by the collection program | ||||
RETRY_COUNT | NUMBER | Number of retries to process failed records. | ||||
REPETITIVE_SCHEDULE_ID | NUMBER | Repetitive schedule identifier of the demand record. | ||||
WIP_ENTITY_ID | NUMBER | This value indicates WIP job identifier for an assembly. | ||||
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 | ||||
DMD_SPLIT_FLAG | NUMBER | Flag indicating whether the demand is split | ||||
REQUEST_DATE | DATE | Request date of the demand record. | ||||
ORDER_NUMBER | VARCHAR2 | 240 | This value indicates the Wip entity name of the demand. | |||
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. | ||||
SALES_ORDER_LINE_ID | VARCHAR2 | 240 | 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 | Forecast billing address identifier | ||||
CUSTOMER_ID | NUMBER | Unique Partner identifier generated by the collection program | ||||
PROBABILITY | NUMBER | This value indicates the probability for the demand/designator. | ||||
SERVICE_LEVEL | VARCHAR2 | 80 | Service level specified in the shipping method. | |||
FORECAST_MAD | NUMBER | Forecast MAD. Used in forecast processing. | ||||
FORECAST_DESIGNATOR | VARCHAR2 | 10 | Unique Name assigned to the forecast | |||
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. | |||
DEMAND_SOURCE_TYPE | NUMBER | This value indicates the Demand source type. | ||||
SHIP_TO_SITE_ID | NUMBER | Identifier of the party/partner where the shipment if headed for. | ||||
COMPANY_ID | NUMBER | Unique id assigned to the company | ||||
COMPANY_NAME | VARCHAR2 | 255 | Party name with which the company is registered. | |||
CUSTOMER_NAME | VARCHAR2 | 360 | Party name assigned to the customer | |||
CUSTOMER_SITE_ID | NUMBER | Customer site unique identifier | ||||
CUSTOMER_SITE_CODE | VARCHAR2 | 30 | Unique code associated to the customer site | |||
BILL_CODE | VARCHAR2 | 30 | Bill to site code for the customer bill to site. | |||
ITEM_NAME | VARCHAR2 | 300 | Identifies the inventory item name | |||
ROUTING_NAME | VARCHAR2 | 250 | Name of the routing or a work definition. | |||
ALTERNATE_ROUTING_DESIGNATOR | VARCHAR2 | 10 | Name of the alternate routing. Null for primary routing | |||
OPERATION_EFFECTIVITY_DATE | DATE | This value indicates Effectivity Date. | ||||
USING_ASSEMBLY_ITEM_NAME | VARCHAR2 | 300 | Assembly Item name for which job is created in WIP | |||
PROJECT_NUMBER | VARCHAR2 | 25 | This column stores the value of Project Number. | |||
TASK_NUMBER | VARCHAR2 | 25 | This value indicates the Task number. | |||
SCHEDULE_LINE_NUM | VARCHAR2 | 10 | Schedule Line Number. This would be used to uniquely identify a demand record for a schedule during batch loads. | |||
OPERATION_SEQ_CODE | VARCHAR2 | 10 | This value indicates Operation Sequence Code. | |||
ORGANIZATION_CODE | VARCHAR2 | 18 | Reference to the organization code of the source order. | |||
SR_INSTANCE_CODE | VARCHAR2 | 30 | The value indicates the source system code from where the data is collected. | |||
MESSAGE_ID | NUMBER | 18 | This is a foreign key reference to ECX_DOCLOGS.INTERNAL_CONTROL_NUMBER for records got via XML | |||
PROCESS_FLAG | NUMBER | Processing Flag indicating the status of records during pre-processing. 1- Complete Record, 2- Error Record, 3- Warning Record, 4- Retry Record, 5- New Record. | ||||
BATCH_ID | NUMBER | 18 | Batch identifier generated during pre-processing | |||
DATA_SOURCE_TYPE | VARCHAR2 | 15 | Source Type indicating the source of data | |||
ST_TRANSACTION_ID | NUMBER | 18 | Transaction ID generated during pre-processing to uniquely identify a record in the staging table | |||
ERROR_TEXT | VARCHAR2 | 2000 | If PROCESS_FLAG is equal to 3 for a record, then this will describe the reason for the error | |||
ERROR_CODE | VARCHAR2 | 150 | Error code while processing the records | |||
COMMENTS | VARCHAR2 | 1000 | Comments describing purpose of the record being collected. | |||
PROMISE_DATE | DATE | Date promised to the customer for the order availability. | ||||
LINK_TO_LINE_ID | NUMBER | 18 | Parent Line Identifier of the sales order. | |||
QUANTITY_PER_ASSEMBLY | NUMBER | This value indicates the Part usage quantity. | ||||
ORDER_DATE_TYPE_CODE | NUMBER | 1 - 'SHIP' 2 - 'ARRIVE' NULL - 'SHIP' | ||||
LATEST_ACCEPTABLE_DATE | DATE | The latest date that the customer is willing to receive a product. | ||||
SHIPPING_METHOD_CODE | VARCHAR2 | 400 | Shipping method code used for material movement. | |||
SCHEDULE_SHIP_DATE | DATE | Schedule ship date on the sales order demand. | ||||
SCHEDULE_ARRIVAL_DATE | DATE | This value indicates the Schedule 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. | ||||
ORIGINAL_ITEM_NAME | VARCHAR2 | 300 | This value indicates the Original inventory item name. | |||
RECEIVING_ORG_CODE | VARCHAR2 | 18 | This value indicates the Receiving organization code. | |||
ORIGINAL_ITEM_ID | NUMBER | This value indicates the Original inventory item identifier. | ||||
RECEIVING_ORG_ID | NUMBER | This value indicates the Receiving organization identifier. | ||||
COMPLETED_QUANTITY | NUMBER | The value indicates completed quantity of the total wip job quantity. | ||||
SO_LINE_NUM | VARCHAR2 | 150 | Sales order line number of the sales order demand. | |||
SALES_ORDER_HEADER_ID | VARCHAR2 | 50 | Sales order header identifier collected from source system. | |||
ORCH_ORDER_HEADER_ID | NUMBER | Reference to the unique identifier for the orchestration order | ||||
ORCH_ORDER_LINE_ID | NUMBER | Reference to the unique identifier for the orchestration order line | ||||
LATEST_ACCEPTABLE_SHIP_DATE | DATE | The latest date that the customer is willing to have a warehouse ship a product. | ||||
LATEST_ACCEPTABLE_ARRIVAL_DATE | DATE | The latest date that the customer is willing to receive a product. | ||||
EARLIEST_ACCEPT_SHIP_DATE | DATE | Earliest ship date when customer can accept the supply | ||||
EARLIEST_ACCEPT_ARRIVAL_DATE | DATE | Earliest arrival date when customer can receive the supply | ||||
CARRIER_ID | NUMBER | Unique identifier for the carrier | ||||
SOURCE_ORG_ID | NUMBER | 18 | This is the Organization ID for the Organization in the legacy(source) system.This is needed to relate the data in planning server to the legacy system and is for reference purpose only. | |||
SOURCE_INVENTORY_ITEM_ID | NUMBER | This is the Inventory Item ID for the Item in the legacy(source) system.This is needed to relate the data in planning server to the legacy system and is for reference purpose only. | ||||
SOURCE_USING_ASSEMBLY_ITEM_ID | NUMBER | This is the Using Assembly Item ID for the Assembly Item in the legacy(source) system.This is needed to relate the data in planning server to the legacy system and is for reference purpose only. | ||||
SOURCE_SALES_ORDER_LINE_ID | NUMBER | This is the Sales Order Line ID for the Sales Order Line in the legacy (source) system. This is needed to relate the data in planning server to the legacy system and is for reference purpose only. | ||||
SOURCE_PROJECT_ID | NUMBER | 18 | This is the Project ID for the Project in the legacy (source) system. This is needed to relate the data in planning server to the legacy system and is for reference purpose only. | |||
SOURCE_TASK_ID | NUMBER | 18 | This is the Task ID for the Task in the legacy (source) system. This is needed to relate the data in planning server to the legacy system and is for reference purpose only. | |||
SOURCE_CUSTOMER_SITE_ID | NUMBER | This is the Customer Site ID for the Customer Site in the legacy (source) system. This is needed to relate the data in planning server to the legacy system and is for reference purpose only. | ||||
SOURCE_BILL_ID | NUMBER | 18 | This is the Bill ID for the Bill in the legacy (source) system. This is needed to relate the data in planning server to the legacy system and is for reference purpose only. | |||
SOURCE_DISPOSITION_ID | NUMBER | This is a unique ID to identify this Demand in the legacy (source) system. This is needed to relate the data in planning server to the legacy system and is for reference purpose only. | ||||
SOURCE_CUSTOMER_ID | NUMBER | This is the Customer ID for the Customer in the legacy (source) system. This is needed to relate the data in planning server to the legacy system and is for reference purpose only. | ||||
SOURCE_OPERATION_SEQ_NUM | NUMBER | This is the Operation Sequence Number for the Operation Sequence in the legacy (source) system. This is needed to relate the data in planning server to the legacy system and is for reference purpose only. | ||||
SOURCE_WIP_ENTITY_ID | NUMBER | This is the WIP Entity ID for the WIP Entity in the legacy (source) system. This is needed to relate the data in planning server to the legacy system and is for reference purpose only. | ||||
ROUTING_SEQUENCE_ID | NUMBER | Routing sequence identifier for the routing/work definition. | ||||
ASSET_SERIAL_NUMBER | VARCHAR2 | 30 | Asset Number or rebuild serial number | |||
ASSET_ITEM_ID | NUMBER | 18 | FK to item id .Asset group id or rebuild_item_id | |||
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 | ||||
LOAD_REQUEST_ID | NUMBER | It Stores the Request ID of Job that loaded the data. | ||||
PO_DELETED_FLAG | NUMBER | PO_DELETED_FLAG for SO-PO deletion from MSC_RESERVATIONS | ||||
CUSTOMER_PO_SCHEDULE_NUMBER | VARCHAR2 | 50 | Contains Customers Purchase Order Shipment Schedule number , if specified while submitting an 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. | ||||
SUB_INVENTORY_CODE | VARCHAR2 | 10 | This value indicates the Sub inventory code. | |||
INQUIRY_DEMAND | NUMBER | Flag to indicate if the demand is Inquiry Demand. | ||||
GLOBAL_ATTRIBUTE_NUMBER1 | VARCHAR2 | 100 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
GLOBAL_ATTRIBUTE_NUMBER2 | VARCHAR2 | 100 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
GLOBAL_ATTRIBUTE_NUMBER3 | VARCHAR2 | 100 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
GLOBAL_ATTRIBUTE_NUMBER4 | VARCHAR2 | 100 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
GLOBAL_ATTRIBUTE_NUMBER5 | VARCHAR2 | 100 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
GLOBAL_ATTRIBUTE_NUMBER6 | VARCHAR2 | 100 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
GLOBAL_ATTRIBUTE_NUMBER7 | VARCHAR2 | 100 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
GLOBAL_ATTRIBUTE_NUMBER8 | VARCHAR2 | 100 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
GLOBAL_ATTRIBUTE_NUMBER9 | VARCHAR2 | 100 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
GLOBAL_ATTRIBUTE_NUMBER10 | VARCHAR2 | 100 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
GLOBAL_ATTRIBUTE_NUMBER11 | VARCHAR2 | 2000 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
GLOBAL_ATTRIBUTE_NUMBER12 | VARCHAR2 | 2000 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
GLOBAL_ATTRIBUTE_NUMBER13 | VARCHAR2 | 2000 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
GLOBAL_ATTRIBUTE_NUMBER14 | VARCHAR2 | 2000 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
GLOBAL_ATTRIBUTE_NUMBER15 | VARCHAR2 | 2000 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
GLOBAL_ATTRIBUTE_NUMBER16 | VARCHAR2 | 2000 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
GLOBAL_ATTRIBUTE_NUMBER17 | VARCHAR2 | 2000 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
GLOBAL_ATTRIBUTE_NUMBER18 | VARCHAR2 | 2000 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
GLOBAL_ATTRIBUTE_NUMBER19 | VARCHAR2 | 2000 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
GLOBAL_ATTRIBUTE_NUMBER20 | VARCHAR2 | 2000 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
GLOBAL_ATTRIBUTE_NUMBER21 | VARCHAR2 | 2000 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
GLOBAL_ATTRIBUTE_NUMBER22 | VARCHAR2 | 2000 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
GLOBAL_ATTRIBUTE_NUMBER23 | VARCHAR2 | 2000 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
GLOBAL_ATTRIBUTE_NUMBER24 | VARCHAR2 | 2000 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
GLOBAL_ATTRIBUTE_NUMBER25 | VARCHAR2 | 2000 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
GLOBAL_ATTRIBUTE_NUMBER26 | VARCHAR2 | 100 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
GLOBAL_ATTRIBUTE_NUMBER27 | VARCHAR2 | 100 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
GLOBAL_ATTRIBUTE_NUMBER28 | VARCHAR2 | 100 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
GLOBAL_ATTRIBUTE_NUMBER29 | VARCHAR2 | 100 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
GLOBAL_ATTRIBUTE_NUMBER30 | VARCHAR2 | 100 | 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. | |||
VCS_DATA_REQUEST_ID | NUMBER | This column is populated by SCC-SCP integration flow. It holds request_id of the SCC ESS Job that invokes the SCP CSV Upload ESS Job. | ||||
ASSET_NUMBER | VARCHAR2 | 80 | A user-specified identifier for the asset object that has been associated to a maintenance work order. | |||
SECONDARY_UOM | VARCHAR2 | 3 | Secondary UOM code if tracking uom is primary and secondary. | |||
PRICE_USING_SEC_UOM_FLAG | VARCHAR2 | 1 | Contains true or false. If true, OOM uses secondary quantity and secondary uom to price the order line. | |||
EXECUTION_SEQUENCE | NUMBER | Indicates the execution sequence number of the operation if the work order has the re-sequence operations. | ||||
ORDER_LINE_STATUS | NUMBER | Indicates the status of order line whether it i s picked, shipped, awaiting,shipping or at any other custom step . | ||||
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. |