MSC_ST_SUPPLIES
The staging table used by the collection program to validate and process data for table MSC_SUPPLIES.
Details
-
Schema: FUSION
-
Object owner: MSC
-
Object type: TABLE
-
Tablespace: INTERFACE
Columns
Name | Datatype | Length | Precision | Not-null | Comments |
---|---|---|---|---|---|
PLAN_ID | NUMBER | This value indicates the plan identifier for the record. | |||
TOTAL_OUTPUT_QUANTITY | NUMBER | Represents the quantity produced for the work definition. In process manufacturing, this is the Batch Quantity. | |||
LAST_OP_COMPLETION_DATE | DATE | Last operation's completion date. | |||
WORK_METHOD_CODE | NUMBER | A code that represents the user key to the work method. Valid values are 1=DISCRETE_MANUFACTURING, 2=PROCESS_MANUFACTURING | |||
PROCESS_NAME | VARCHAR2 | 120 | Indicates the unique name for the work definition. In the case of process manufacturing, this represents the process name. | ||
TRANSACTION_ID | NUMBER | Transaction identifier generated and used in the planning system for the supply/demand. | |||
INVENTORY_ITEM_ID | NUMBER | Identifies the inventory item id | |||
ORGANIZATION_ID | NUMBER | This column indicates the organization identifier. | |||
SCHEDULE_DESIGNATOR_ID | NUMBER | This value indicates the Schedule designator identifier. | |||
SOURCE_SCHEDULE_NAME | VARCHAR2 | 10 | This value indicates the Source schedule name. | ||
REVISION | VARCHAR2 | 10 | Inventory item revision code for the BOM component. | ||
UNIT_NUMBER | VARCHAR2 | 30 | This value indicates the Unit number of the supply. | ||
NEW_SCHEDULE_DATE | DATE | End date of the supply (completion date of first unit) | |||
OLD_SCHEDULE_DATE | DATE | This value indicates Old schedule date. | |||
NEW_WIP_START_DATE | DATE | This value indicates the New WIP schedule start date. | |||
OLD_WIP_START_DATE | DATE | This value indicates Old WIP schedule start date. | |||
FIRST_UNIT_COMPLETION_DATE | DATE | First unit completion date for recommended repetitive schedules | |||
LAST_UNIT_COMPLETION_DATE | DATE | Last unit completion date for recommended repetitive schedules | |||
FIRST_UNIT_START_DATE | DATE | First unit start date for repetitive schedule | |||
LAST_UNIT_START_DATE | DATE | Last unit start date for repetitive schedule | |||
DISPOSITION_ID | NUMBER | Identifier which references to source of supply | |||
DISPOSITION_STATUS_TYPE | NUMBER | Identifies the status of supply. Not cancelled(1), Cancelled(2) | |||
ORDER_TYPE | NUMBER | Specifies type of order: planned order, purchase order, etc... | |||
SUPPLIER_ID | NUMBER | This value indicates the Supplier identifier in the planning system. | |||
NEW_ORDER_QUANTITY | NUMBER | Open supply quantity in primary unit of measure. | |||
OLD_ORDER_QUANTITY | NUMBER | This value indicates Old order quantity. | |||
NEW_ORDER_PLACEMENT_DATE | DATE | New order placement date of the supply order. | |||
OLD_ORDER_PLACEMENT_DATE | DATE | This value indicates Old order placement date. | |||
RESCHEDULE_DAYS | NUMBER | Different between old and new schedule dates | |||
RESCHEDULE_FLAG | NUMBER | Flag indicating if this row been rescheduled | |||
SCHEDULE_COMPRESS_DAYS | NUMBER | This value indicates the Schedule compress days. | |||
NEW_PROCESSING_DAYS | NUMBER | Repetitive schedule processing days | |||
PURCH_LINE_NUM | VARCHAR2 | 50 | Purchase order line number (for purchase order) | ||
QUANTITY_IN_PROCESS | NUMBER | Quantity being processed by the WIP/PO interface processes | |||
IMPLEMENTED_QUANTITY | NUMBER | Planned order implemented quantity | |||
FIRM_PLANNED_TYPE | NUMBER | Flag indicating whether the order is firm | |||
FIRM_QUANTITY | NUMBER | Quantity is marked as firm so that it doesn't change during replan. | |||
FIRM_DATE | DATE | Date is marked as firm so that it doesn't change during replan. | |||
IMPLEMENT_DEMAND_CLASS | VARCHAR2 | 34 | Identifies the Implement demand class | ||
IMPLEMENT_DATE | DATE | Identifies the Implement due date | |||
IMPLEMENT_QUANTITY | NUMBER | Planned order implemented quantity | |||
IMPLEMENT_FIRM | NUMBER | Identifies the Implement firm flag | |||
IMPLEMENT_WIP_CLASS_CODE | VARCHAR2 | 10 | Identifies the Implement WIP class code | ||
IMPLEMENT_JOB_NAME | VARCHAR2 | 240 | Identifies the Implement job name | ||
IMPLEMENT_DOCK_DATE | DATE | Identifies the Implement dock date | |||
IMPLEMENT_STATUS_CODE | NUMBER | Identifies the Implement status code | |||
IMPLEMENT_UOM_CODE | VARCHAR2 | 3 | Identifies the Implement unit of measure code | ||
IMPLEMENT_LOCATION_ID | NUMBER | Identifies the Implement location identifier | |||
IMPLEMENT_SOURCE_ORG_ID | NUMBER | Implement source organization identifier | |||
IMPLEMENT_SUPPLIER_ID | NUMBER | Identifies the Implement supplier identifier | |||
IMPLEMENT_SUPPLIER_SITE_ID | NUMBER | Implement supplier site identifier | |||
IMPLEMENT_AS | NUMBER | Implement order type. None(1), Purchase requisition(2), Discrete job(3) | |||
RELEASE_STATUS | NUMBER | This value indicates the release error description. | |||
LOAD_TYPE | NUMBER | Load program to execute during release. | |||
PROCESS_SEQ_ID | NUMBER | Process sequence identifier for the supply record. | |||
SCO_SUPPLY_FLAG | NUMBER | Flag to indicate if supply was suggested by SCO | |||
ALTERNATE_BOM_DESIGNATOR | VARCHAR2 | 80 | Name of the bill for alternate bills (null for the primary bill) . | ||
ALTERNATE_ROUTING_DESIGNATOR | VARCHAR2 | 30 | Name of the alternate routing. Null for primary routing | ||
OPERATION_SEQ_NUM | NUMBER | Operation sequence number of the routing operation. | |||
SOURCE | NUMBER | This value indicates Source of the supply record. | |||
BY_PRODUCT_USING_ASSY_ID | NUMBER | Using assy identifier for by-products | |||
SOURCE_ORGANIZATION_ID | NUMBER | This value indicates the Source organization identifier. | |||
SOURCE_SR_INSTANCE_ID | NUMBER | This value indicates the Source org instance identifier. | |||
SOURCE_SUPPLIER_SITE_ID | NUMBER | Source supplier site identifier | |||
SOURCE_SUPPLIER_ID | NUMBER | This value indicates the Source supplier identifier. | |||
SHIP_METHOD | VARCHAR2 | 30 | Shipping method used to move the material. | ||
CARRIER_ID | NUMBER | Unique identifier for the carrier | |||
CARRIER_NAME | VARCHAR2 | 360 | Carrier Name (Party Name of the Carrier) | ||
SERVICE_LEVEL | VARCHAR2 | 80 | Service level specified in the shipping method. | ||
MODE_OF_TRANSPORT | VARCHAR2 | 80 | Mode of transport of the ship method. | ||
WEIGHT_CAPACITY_USED | NUMBER | This indicates the Weight capacity used for the supply record. | |||
VOLUME_CAPACITY_USED | NUMBER | This value indicates the volume capacity used for the supply record. | |||
SOURCE_SUPPLY_SCHEDULE_NAME | NUMBER | This value indicates the Source supply schedule name. | |||
NEW_SHIP_DATE | DATE | This value indicates the New ship date of the supply. | |||
NEW_DOCK_DATE | DATE | New suggested dock date of the supply order. | |||
LINE_ID | NUMBER | This column indicates the work order line identifier. | |||
PROJECT_ID | NUMBER | 18 | This column stores the value of Project identifier. | ||
TASK_ID | NUMBER | 18 | This value indicates the Task identifier. | ||
PLANNING_GROUP | VARCHAR2 | 30 | This value indicates the planning group of the record. | ||
IMPLEMENT_PROJECT_ID | NUMBER | 18 | Identifies the Implement project identifier | ||
IMPLEMENT_TASK_ID | NUMBER | 18 | Identifies the Implement task identifier | ||
IMPLEMENT_SCHEDULE_GROUP_ID | NUMBER | Implement schedule group identifier | |||
IMPLEMENT_BUILD_SEQUENCE | NUMBER | Implement build sequence for the planned order to be implemented as a discrete job | |||
IMPLEMENT_ALTERNATE_BOM | VARCHAR2 | 10 | Implement alternate BOM designator | ||
IMPLEMENT_ALTERNATE_ROUTING | VARCHAR2 | 10 | Alternate routing designator of the planned order to be implemented | ||
IMPLEMENT_UNIT_NUMBER | VARCHAR2 | 30 | Identifies the Implement unit number | ||
IMPLEMENT_LINE_ID | NUMBER | Identifies the Implement line identifier | |||
RELEASE_ERRORS | VARCHAR2 | 1 | This value indicates the release error description. | ||
NUMBER1 | NUMBER | This is a genetic number column used for supply specific additional information. | |||
SOURCE_ITEM_ID | NUMBER | Source side inventory item identifier of the item. | |||
ORDER_NUMBER | VARCHAR2 | 240 | This value indicates the Order number of the supply record. | ||
SCHEDULE_GROUP_ID | NUMBER | Schedule group identifier of the the wip job supply. | |||
SCHEDULE_GROUP_NAME | VARCHAR2 | 30 | Schedule group name of the the wip job supply. | ||
BUILD_SEQUENCE | NUMBER | Build Sequence for the Planned Order | |||
WIP_ENTITY_ID | NUMBER | This stores the value of WIP job identifier for an assembly. | |||
WIP_ENTITY_NAME | VARCHAR2 | 240 | This stores the value of WIP job name for an assembly. | ||
WO_LATENESS_COST | NUMBER | This value indicates the Work order lateness cost for the wip supply. | |||
IMPLEMENT_PROCESSING_DAYS | NUMBER | Identifies the Implement processing days | |||
DELIVERY_PRICE | NUMBER | Supply unit price for purchasing supply | |||
LATE_SUPPLY_DATE | DATE | Supply date for the shadow part of the split supplies | |||
LATE_SUPPLY_QTY | NUMBER | Shadow supply quantity of the supply record. | |||
SUBINVENTORY_CODE | VARCHAR2 | 10 | This value indicates the supply subinventory name. | ||
DELETED_FLAG | NUMBER | Yes/No flag indicates whether corresponding record in ODS 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 | |||
SCHEDULE_DESIGNATOR | VARCHAR2 | 10 | This value indicates the Schedule designator. | ||
VENDOR_ID | NUMBER | Supplier identifier of the supplier attached to PO/PR. | |||
VENDOR_SITE_ID | NUMBER | Supplier site identifier specified on PO/PR. | |||
SUPPLIER_SITE_ID | NUMBER | This value indicates the Supplier site identifier. | |||
PURCH_ORDER_ID | NUMBER | Purchase order identifier for the PO record collected from source system. | |||
EXPECTED_SCRAP_QTY | NUMBER | This value indicates expected scrap quantity. | |||
QTY_SCRAPPED | NUMBER | Current job scrapped quantity units for the assembly. | |||
QTY_COMPLETED | NUMBER | Current job quantity completed for the assembly. | |||
LOT_NUMBER | VARCHAR2 | 80 | Lot number for on-hand quantities | ||
EXPIRATION_DATE | DATE | Expiration date of the supply record. | |||
WIP_STATUS_CODE | NUMBER | This stores the value of WIP job status code for an assembly. | |||
DAILY_RATE | NUMBER | Daily rate for recommended repetitive schedules | |||
LOCATOR_ID | NUMBER | Locator identifier of the supply order. | |||
SERIAL_NUMBER | VARCHAR2 | 30 | This value indicates the Serial number of the supply record. | ||
REFRESH_NUMBER | NUMBER | Refresh identifier populated by the collection program. | |||
LOCATOR_NAME | VARCHAR2 | 204 | This indicates the locator name of the supply order. | ||
ONHAND_SOURCE_TYPE | NUMBER | This value indicates Onhand source type. | |||
SR_MTL_SUPPLY_ID | NUMBER | Supply identifier from the source | |||
DEMAND_CLASS | VARCHAR2 | 34 | Class to which the demand is tied. | ||
FROM_ORGANIZATION_ID | NUMBER | From organization id for inter-organization transfers | |||
WIP_SUPPLY_TYPE | NUMBER | Work in process supply type value for the record. Mainly used for phantom identification. | |||
PO_LINE_ID | VARCHAR2 | 320 | Purchase order line identifier for the PO collected from source system. | ||
BILL_SEQUENCE_ID | NUMBER | Supply identifier from the source | |||
ROUTING_SEQUENCE_ID | NUMBER | Supply identifier from the source | |||
COPRODUCTS_SUPPLY | NUMBER | Supply identifier from the source | |||
CFM_ROUTING_FLAG | NUMBER | Supply identifier from the source | |||
COMPANY_ID | NUMBER | Unique id assigned to the company | |||
COMPANY_NAME | VARCHAR2 | 255 | Party name with which the company is registered. | ||
ITEM_NAME | VARCHAR2 | 300 | Identifies the inventory item name | ||
ORGANIZATION_CODE | VARCHAR2 | 18 | This column indicates the organization code. | ||
FROM_ORGANIZATION_CODE | VARCHAR2 | 18 | Organization from where this item is going to come | ||
SUPPLIER_NAME | VARCHAR2 | 360 | This value indicates the Supplier name collected from source system. | ||
SOURCE_SR_INSTANCE_CODE | VARCHAR2 | 30 | Source Application Instance Code | ||
SOURCE_SUPPLIER_SITE_CODE | VARCHAR2 | 240 | This value indicates the Source Supplier Site Code. | ||
SOURCE_SUPPLIER_NAME | VARCHAR2 | 80 | This value indicates the Source Supplier Name. | ||
PROJECT_NUMBER | VARCHAR2 | 25 | This column stores the value of Project Number. | ||
TASK_NUMBER | VARCHAR2 | 25 | This value indicates the Task number. | ||
SR_INSTANCE_CODE | VARCHAR2 | 30 | The value indicates the source system code from where the data is collected. | ||
VENDOR_NAME | VARCHAR2 | 360 | Name of the supplier attached to PO/PR. | ||
VENDOR_SITE_CODE | VARCHAR2 | 240 | Name of the supplier site attached to PO/PR. | ||
SUPPLIER_SITE_CODE | VARCHAR2 | 240 | This value indicates the Supplier site code collected from source system. | ||
MESSAGE_ID | NUMBER | 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. | |||
DATA_SOURCE_TYPE | VARCHAR2 | 15 | Source Type indicates the source of records, Batch/XML. | ||
ST_TRANSACTION_ID | NUMBER | Transaction ID generated during pre-processing to uniquely identify a record in the staging table | |||
SCHEDULE_LINE_NUM | VARCHAR2 | 30 | Schedule Line Number. This would be used to uniquely identify a demand record for a schedule during batch loads. | ||
ERROR_TEXT | VARCHAR2 | 2000 | If PROCESS_FLAG is equal to 3 for a record, then this will describe the reason for the error | ||
OPERATION_SEQ_CODE | VARCHAR2 | 10 | This value indicates Operation Sequence Code. | ||
BATCH_ID | NUMBER | Batch identifier generated during pre-processing | |||
BILL_NAME | VARCHAR2 | 250 | Bill of Material or Item structure name. | ||
ROUTING_NAME | VARCHAR2 | 250 | Name of the routing or a work definition. | ||
CURR_OP_SEQ_ID | NUMBER | Current Operation Sequence Identifier | |||
LINE_CODE | VARCHAR2 | 10 | This value indicates the line code defined for a supply record. | ||
EFFECTIVITY_DATE | DATE | Effective date of the supply records. | |||
SHIP_FROM_PARTY_NAME | VARCHAR2 | 80 | Name of the party/partner from where the shipment originates. | ||
SHIP_FROM_SITE_CODE | VARCHAR2 | 240 | Name of the party/partner from where the shipment originates. | ||
END_ORDER_NUMBER | VARCHAR2 | 240 | This value indicates End order Number. | ||
END_ORDER_RELEASE_NUMBER | VARCHAR2 | 20 | This value indicates End order Release Number. | ||
END_ORDER_LINE_NUMBER | VARCHAR2 | 20 | This value indicates End order line Number. | ||
ORDER_RELEASE_NUMBER | VARCHAR2 | 20 | This value indicates the Order Release Number of the supply. | ||
COMMENTS | VARCHAR2 | 1000 | Comments describing purpose of the record being collected. | ||
SHIP_TO_PARTY_NAME | VARCHAR2 | 80 | Name of the party/partner where the shipment if headed for. | ||
SHIP_TO_SITE_CODE | VARCHAR2 | 240 | Name of the party/partner where the shipment if headed for. | ||
PLANNING_PARTNER_SITE_ID | NUMBER | Planning Partner site identifier | |||
PLANNING_TP_TYPE | NUMBER | Planning Partner Type Identifier | |||
OWNING_PARTNER_SITE_ID | NUMBER | Owning partner site identifier of the supply record. | |||
OWNING_TP_TYPE | NUMBER | Owning trading partner type of the supply record. | |||
VMI_FLAG | VARCHAR2 | 1 | VMI flag. Used in vendor managed inventory. | ||
NON_NETTABLE_QTY | NUMBER | This value indicates the Non Nettable Quantity. | |||
ORIGINAL_NEED_BY_DATE | DATE | Need-by Date for the shipment schedule | |||
ORIGINAL_QUANTITY | NUMBER | Quantity ordered or break quantity for blanket purchase orders, RFQs and quotations | |||
PROMISED_DATE | DATE | Supplier promised delivery date | |||
NEED_BY_DATE | DATE | Need-by date for the shipment schedule | |||
ACCEPTANCE_REQUIRED_FLAG | VARCHAR2 | 1 | This flag is available in PO Terms and Conditions. | ||
END_ORDER_SHIPMENT_NUMBER | NUMBER | This column will have value for the Supplier responses records coming in from iSupplier Portal. | |||
POSTPROCESSING_LEAD_TIME | NUMBER | Post processing lead time used in supply network for supply generation. | |||
WIP_START_QUANTITY | NUMBER | This stores the value of WIP start quantity for an assembly. | |||
ORDER_LINE_NUMBER | VARCHAR2 | 25 | Used to store a supplier change request | ||
UOM_CODE | VARCHAR2 | 50 | Unit of measure code of the supply record. | ||
QUANTITY_PER_ASSEMBLY | NUMBER | This value indicates the Part usage quantity. | |||
QUANTITY_ISSUED | NUMBER | This value indicates the Part quantity issued. | |||
ACK_REFERENCE_NUMBER | VARCHAR2 | 200 | Indicates supply acknowledgement reference number. | ||
JOB_OP_SEQ_NUM | NUMBER | Job sequence number of the jumped operation | |||
JUMP_OP_SEQ_NUM | NUMBER | Routing sequence number of the jumped operation | |||
JOB_OP_SEQ_CODE | VARCHAR2 | 10 | Job sequence code of the jumped operation | ||
JUMP_OP_SEQ_CODE | VARCHAR2 | 10 | Routing sequence code of the jumped operation | ||
JUMP_OP_EFFECTIVITY_DATE | DATE | Effectivity date of the jumped operation | |||
SOURCE_ORG_ID | NUMBER | 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 Inventory 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_VENDOR_ID | NUMBER | This is the Vendor ID for the Vendor 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_VENDOR_SITE_ID | NUMBER | This is the Vendor Site ID for the Vendor 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_TASK_ID | NUMBER | 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_PROJECT_ID | NUMBER | 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_FROM_ORGANIZATION_ID | NUMBER | This is the Organization Id for the Sourcing Organization (mentioned in the From Organization Code) 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_SR_MTL_SUPPLY_ID | NUMBER | This is a unique ID to identify this supply 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 supply 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_SEQUENCE_ID | NUMBER | This is the Bill Sequence ID for the Bill 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_ROUTING_SEQUENCE_ID | NUMBER | This is the Routing Sequence ID for the Routing 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_SCHEDULE_GROUP_ID | NUMBER | This is the Schedule Group ID for the Schedule Group 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. | |||
PO_LINE_LOCATION_ID | VARCHAR2 | 320 | Purchase order line location identifier | ||
PO_DISTRIBUTION_ID | NUMBER | Purchase order distribution identifier | |||
REQUESTED_START_DATE | DATE | Requested start date of the work order supply. | |||
REQUESTED_COMPLETION_DATE | DATE | Requested completion/due date of the wo | |||
SCHEDULE_PRIORITY | NUMBER | Highest End Demand Priority of the work order supply. | |||
ASSET_SERIAL_NUMBER | VARCHAR2 | 30 | Asset Number or rebuild serial number | ||
ASSET_ITEM_ID | NUMBER | Fk to item id .Asset group id or rebuild_item_id | |||
ASSET_ITEM_NAME | VARCHAR2 | 240 | Item name associated with asset item id. Used for Legacy | ||
PLANNING_PARTNER_SITE_CODE | VARCHAR2 | 240 | Planning partner site code. Used in legacy collections | ||
OWNING_PARTNER_SITE_CODE | VARCHAR2 | 240 | Owning partner site code. Used in legacy collections | ||
ACTUAL_START_DATE | DATE | Actual Start Date & Time of the WIP Job | |||
ITEM_TYPE_ID | NUMBER | Code for Criterion on which this item is categorised into types | |||
ITEM_TYPE_VALUE | NUMBER | Item type code per classification per the criterion indicated by the item_type_id | |||
RETRY_COUNT | NUMBER | Number of retries to process failed records. | |||
ERROR_CODE | VARCHAR2 | 150 | Error code for functional validation errors in the record | ||
OPERATION_TYPE | VARCHAR2 | 2 | This indicates the operation type of the routing operation. | ||
INTERFACE_STATUS_LOOKUP | VARCHAR2 | 30 | Possible values: Awaiting Interface to DOO, Error, Awaiting Interface to Shipping, Interfaced to DOO, Interfaced to Shipping | ||
SOURCE_SUBINVENTORY_CODE | VARCHAR2 | 10 | Source side subinventory code of the supply. | ||
TO_LINE_ID | VARCHAR2 | 300 | Transfer order line identifier collected from source system. | ||
TO_LINE_NUMBER | VARCHAR2 | 20 | Transfer order line number collected from source system. | ||
LOAD_REQUEST_ID | NUMBER | It Stores the Request ID of Job that loaded the data. | |||
BMT_FLAG | NUMBER | Flag indicates whether transportation is managed by Buyer. 1-Yes, 2-No. | |||
DROP_SHIP_CUST_ID | NUMBER | Customer id of the drop ship PO | |||
DROP_SHIP_CUST_SITE_ID | VARCHAR2 | 20 | Customer site id of the drop ship PO | ||
DROP_SHIP_DEST_TYPE | NUMBER | Destination types=> drop ship and inventory. Requisition Lines and PO Schedules for drop shipments will have 1- DROPSHIP, 2- INVENTORY | |||
PROMISED_SHIP_DATE | DATE | Date promised to the customer for the order shipment. | |||
REQUESTED_SHIP_DATE | DATE | Requested ship date of the supply record. | |||
DROP_SHIP_CUST_NAME | VARCHAR2 | 255 | Customer name of the drop ship PO | ||
DROP_SHIP_CUST_SITE_CODE | VARCHAR2 | 30 | Customer site code of the drop ship PO | ||
FG_ORDER_TYPE | NUMBER | Specifies the Fine grained order type. Ex: For planned orders, defines the type of planned order. 5001 ??? ???MAKE???, 5002 ??? ???BUY???, 5003 ??? ???TRANSFER??? | |||
ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR16 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR17 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR18 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR19 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR20 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_NUMBER1 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_NUMBER2 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_NUMBER3 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_NUMBER4 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_NUMBER5 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_NUMBER6 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_NUMBER7 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_NUMBER8 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_NUMBER9 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_NUMBER10 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_DATE1 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_DATE2 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_DATE3 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_DATE4 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_DATE5 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_DATE6 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_DATE7 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_DATE8 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_DATE9 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_DATE10 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_DATE11 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_DATE12 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_DATE13 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_DATE14 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_DATE15 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_DATE16 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_DATE17 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_DATE18 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_DATE19 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_DATE20 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
WORK_ORDER_SUB_TYPE | NUMBER | This value indicates work order subtype of the work definition. | |||
FULFILL_ORCHESTRATION_REQUIRED | NUMBER | Indicates whether Transfer Order was interfaced to DOO | |||
SHIPMENT_HEADER_NUM | VARCHAR2 | 30 | Shipment header number of a transfer order | ||
SHIPMENT_LINE_NUM | VARCHAR2 | 30 | Shipment line number of a transfer order | ||
RECEIPT_NUM | VARCHAR2 | 30 | Receipt number of a transfer order | ||
EXPENSE_TRANSFER | NUMBER | valid values are 1 (Yes) or 2 (No) | |||
INTERFACED_TO_DOO | NUMBER | Indicated if the Transfer Order Expense record is interfaced with DOO. | |||
ORCH_ORDER_HEADER_ID | NUMBER | Order orchestration header id (Populated only for TOE fulfillment lines) | |||
ORCH_ORDER_LINE_ID | NUMBER | Order orchestration line id (Populated only for TOE fulfillment lines) | |||
ORDER_DATE_TYPE_CODE | NUMBER | denotes whether request_date contain ship date or arrival date For ship- 1 For arrival ??? 2 For TOE not interfaced to DOO, this will have default 2. for TOE interfaced to DOO, same behavior as TO line. | |||
ITEM_TYPE_CODE | VARCHAR2 | 30 | Indicates whether this is a model/option class/standard item etc. VALID VALUES : MODEL, OPTION_CLASS ,STANDARD Will be populated only for TOE interfaced to DOO. NULL for TOE NOT interfaced to DOO | ||
ITEM_SUB_TYPE_CODE | VARCHAR2 | 30 | Indicates the sub-type of the model, option class or standard item. VALID VALUES : ATO , PTO-NONSMC , PTO-SMC , OPTION-CLASS , KIT-SMC , KIT-NONSMC , STANDARD , INCLUDED Will be populated only for TOE interfaced to DOO. NULL for TOE NOT interfaced to DOO | ||
TO_HEADER_ID | VARCHAR2 | 270 | This value indicates the Populated for TOE records. | ||
START_QUANTITY | NUMBER | This is the actual start quantity of the supply | |||
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. | ||
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. | ||
HOLD_DATE | DATE | This column stores the hold date of on-hand inventory lot. Engine will consider lot as available from HOLD_DATE if populated. | |||
ORDER_STATUS | NUMBER | This column indicates the status of transfer/purchase supply and is required for Project Transfer eligibility criteria checks. | |||
UNDER_COMPLETED_FLAG | NUMBER | Indicates whether the undercompletion tolerance is enabled or not. Valid values are : 1(Yes), 2(No) and Null | |||
BASE_ITEM_ID | NUMBER | This column stores the base Item identifier in case supply is for configured item. | |||
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. | ||
MATURITY_DATE | DATE | The column indicates the date on which the on-hand lot matures. |
Indexes
Index | Uniqueness | Tablespace | Columns | Status |
---|---|---|---|---|
MSC_ST_SUPPLIES_N1 | Non Unique | Default | SR_INSTANCE_CODE, PROCESS_FLAG, ORDER_TYPE, REFRESH_NUMBER, FG_ORDER_TYPE | Obsolete |