MSC_RELEASE_LINES_INT
Interface table for storing data that are to be released during release process.
Details
-
Schema: FUSION
-
Object owner: MSC
-
Object type: TABLE
-
Tablespace: INTERFACE
Columns
| Name | Datatype | Length | Precision | Not-null | Comments | Status |
|---|---|---|---|---|---|---|
| ITEM_ID | NUMBER | 18 | Yes | Source side inventory item identifier. If release program cannot derive source value then this may contain Planning side inventory item identifier that can be used for error logging. | ||
| WORK_METHOD_CODE_VAL | VARCHAR2 | 30 | This value indicates Method code of the work definition. | |||
| PROCESS_NAME | VARCHAR2 | 120 | Indicates the unique name for the work definition. In the case of process manufacturing, this represents the process name. | |||
| ITEM_NAME | VARCHAR2 | 300 | Name of the inventory item being released to source system. | |||
| UOM_CODE | VARCHAR2 | 3 | Yes | Unit of measure code of the record being released. | ||
| QUANTITY | NUMBER | Yes | Quantity of the supply/demand record being released to source system. | |||
| PLAN_ID | NUMBER | 18 | This value indicates the plan identifier for the record. | |||
| DUE_DATE | DATE | Arrival date of the item on the destination from source organization. | ||||
| SHIP_DATE | DATE | Date on which the item to be shipped from source organization | ||||
| INTERFACE_SOURCE_CODE | VARCHAR2 | 25 | Batch identifier of the records being released. For a given release cycle, this value will be same for all the records. | Obsolete | ||
| DELIVER_TO_LOCATION_ID | NUMBER | 18 | Location identifier for the particular place on which the item need to be delivered. | |||
| DELIVER_TO_LOC_CODE | VARCHAR2 | 120 | Location name for the particular place on which the item need to be delivered. | Obsolete | ||
| DELIVER_TO_REQUESTOR_ID | NUMBER | 18 | Deliver to requestor identifier, Employee's HR User-identifier. | Obsolete | ||
| DELIVER_TO_REQUESTOR_CODE | VARCHAR2 | 256 | Deliver to requestor name, Employee's HR User-name. | Obsolete | ||
| DESTINATION_TYPE_CODE | VARCHAR2 | 25 | Indicates the destination is inventory or supplier. | |||
| PREPARER_ID | NUMBER | 18 | User identifier of the preparer of the Purchase Order/Transfer Order. | |||
| PREPARER_NAME | VARCHAR2 | 256 | User name of the preparer of the Purchase Order/Transfer Order. | |||
| SOURCE_TYPE_CODE | VARCHAR2 | 25 | Source type of the sourcing. Make, Buy, Transfer. | Obsolete | ||
| AUTHORIZATION_STATUS | VARCHAR2 | 25 | Approval status for the buy request. By default stamped as "Approved" for all requests sent by planning. | Obsolete | ||
| BATCH_ID | NUMBER | 18 | Batch identifier of the records being released. For a given release cycle, this value will be same for all the records. | |||
| GROUP_CODE | VARCHAR2 | 30 | Grouping option for purchase and transfer orders | |||
| ITEM_REVISION | VARCHAR2 | 3 | Item revision number of the item being released. | Obsolete | ||
| DESTINATION_ORGANIZATION_ID | NUMBER | 18 | Organization id of the destination side to which item is delivered. | |||
| DESTINATION_ORG_CODE | VARCHAR2 | 72 | Organization code of the destination side to which item is delivered | |||
| AUTOSOURCE_FLAG | VARCHAR2 | 1 | Populated with constant value of 'Y'. | Obsolete | ||
| OPERATING_UNIT_ID | NUMBER | 18 | This value indicates Operating Unit Identifier.. | |||
| OPERATING_UNIT_NAME | VARCHAR2 | 120 | This value indicates Operating Unit Name. | |||
| SOURCE_ORGANIZATION_ID | NUMBER | 18 | Organization id of the source side from which item is generated. | |||
| SOURCE_ORG_CODE | VARCHAR2 | 120 | Organization code of the source side from which item is generated. | |||
| SUGGESTED_VENDOR_ID | NUMBER | 18 | Identifier of the supplier who supplies the item. | |||
| VENDOR_NAME | VARCHAR2 | 360 | Name of the supplier who supplies the item. | |||
| SUGGESTED_VENDOR_SITE_ID | NUMBER | 18 | Identifier of the supplier site from where the items are imported. | |||
| VENDOR_SITE_CODE | VARCHAR2 | 240 | Name of the supplier site from where the items are imported. | |||
| TRANSACTION_ID | NUMBER | 18 | Transaction id of the type of supplies that mark the record as unique identifier along with plan id | |||
| DOCUMENT_LINE_ID | NUMBER | 18 | Order line identifier of the supply/demand being released. | Obsolete | ||
| PURCHASE_ORDER_ID | VARCHAR2 | 62 | Identifier of the purchase order created released from supplies. | |||
| PO_NUMBER | VARCHAR2 | 240 | Order number of the purchase order released from supplies. | Obsolete | ||
| SUPPLY_TYPE | VARCHAR2 | 120 | Yes | Type of supply being released. E.g. Make, Buy or Transfer. | Obsolete | |
| SUPPLY_SOURCE_SYSTEM | VARCHAR2 | 120 | Source system code where the supply request gets executed | Obsolete | ||
| SUPPLY_OPERATION | VARCHAR2 | 30 | Operation to be performed based on the supply creation. | |||
| RELEASE_TO_SCO | VARCHAR2 | 1 | Flag determining the record to be released to sco or not. | |||
| WIP_ENTITY_ID | NUMBER | 18 | Identifier of the work order created released from supplies. | Obsolete | ||
| JOB_NAME | VARCHAR2 | 240 | Name of the work order created released from supplies. | Obsolete | ||
| BILL_RTG_EXPLOSION_FLAG | VARCHAR2 | 1 | Routing explosion flag determining the routing exists or not for the item released. | Obsolete | ||
| FIRM_PLANNED_FLAG | NUMBER | 1 | Firm flag control for planning rescheduling. | |||
| WORK_ORDER_STATUS | NUMBER | 18 | This value indicates status identifier of the work definition. | Obsolete | ||
| ALTERNATE_ROUTING_DESIGNATOR | VARCHAR2 | 120 | Alternate routing designator determinign the alternate router exists or not for the item released. | Obsolete | ||
| ALTERNATE_BOM_DESIGNATOR | VARCHAR2 | 120 | Alternate BOM designator determining the alternate router exists or not for the item released. | |||
| START_QUANTITY | NUMBER | This value indicates the start quantity of the wip job to be released. | Obsolete | |||
| ROUTING_REVISION_DATE | DATE | Revision date for the routing item | Obsolete | |||
| ROUTING_REFERENCE_ID | NUMBER | 18 | Reference id of the routing item. | Obsolete | ||
| CLASS_CODE | VARCHAR2 | 120 | Demand class code on the current sales order demand record. | Obsolete | ||
| CARRIER_ID | NUMBER | 18 | Source side identifier of the Carrier being used to ship the material. If release program cannot derive source value then this may contain Planning side carrier identifier that can be used for error logging. | |||
| FULFILLMENT_LINE_ID | NUMBER | Fulfillment line Identifier of DOO system. | Obsolete | |||
| GOP_PARENT_LINE_ID | NUMBER | Parent Line Identifier. For ATO component supply creation scenarios for referring to parent items. | Obsolete | |||
| JOB_DEFINITION_NAME | VARCHAR2 | 100 | Enterprise Service Scheduler: indicates the name of the job that created or last updated the row. | |||
| JOB_DEFINITION_PACKAGE | VARCHAR2 | 900 | Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row. | |||
| MODE_OF_TRANSPORT_ID | NUMBER | Source side identifier of the mode of transport being used to ship the material. If release program cannot derive source value then this may contain Planning side carrier identifier that can be used for error logging. | Obsolete | |||
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | |||
| RESERVED_ORDER_IDENTIFIER | VARCHAR2 | 20 | Order ID of the reserved record. | |||
| RESERVED_ORDER_TYPE | VARCHAR2 | 10 | This value indicates the Source side identifier of the supply. | |||
| SCHEDULING_METHOD | VARCHAR2 | 120 | Method scheduled for the supply. | Obsolete | ||
| SERVICE_LEVEL_ID | NUMBER | Source side identifier of the service level being used to ship the material. If release program cannot derive source value then this may contain Planning side carrier identifier that can be used for error logging. | Obsolete | |||
| SOURCE_SYSTEM_TYPE | NUMBER | 1 | Type of source for which release takes place. | |||
| SPLIT_LINE_ID | VARCHAR2 | 300 | Split line identifier of the supply. | |||
| SUGGESTED_VENDOR_SITE | VARCHAR2 | 120 | Supplier site code associated with the supply/demand being released. | Obsolete | ||
| WIP_STATUS | NUMBER | This stores the value of WIP job status type for an assembly. | Obsolete | |||
| TRANSIT_TIME | NUMBER | Transit time required to ship the material. | ||||
| WORK_METHOD_CODE | VARCHAR2 | 120 | This value indicates Method code of the work definition. | Obsolete | ||
| WORK_ORDER_TYPE | VARCHAR2 | 120 | This value indicates work order type of the work definition. | Obsolete | ||
| ERROR_TEXT | VARCHAR2 | 90 | The error text for the failure of release code. | |||
| LOAD_TYPE | NUMBER | 2 | Determines the type of supply along with type of supply operation. | |||
| 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. | |||
| 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. | ||
| HEADER_NUMBER | VARCHAR2 | 72 | WORK_ORDER_NUMBER + ORGANIZATION_CODE makes a unique work order. However, when the work order name is auto generated, the user may not have the work order name to pass via the open interface. So using this attribute, he/she will be uniquely maintain a unique work order and use this attribute value to connect the details in the WIE_WORK_ORDER_DETAILS_INT. The value of this column is user managed. This is not carried forward to the production tables | Obsolete | ||
| BILL_TO_SITE_CODE | VARCHAR2 | 120 | Bill to site code for the customer bill to site. | Obsolete | ||
| CARRIER_NAME | VARCHAR2 | 360 | Source side Name of the Carrier being used to ship the material. If release program cannot derive source value then this may contain Planning side Carrier Name that can be used for error logging. | |||
| ORIGINAL_QUANTITY | NUMBER | Original quantity of the item before release. | ||||
| CONFIGURED_ITEM_NAME | VARCHAR2 | 1200 | Configured name of the item to be released. | |||
| CUSTOMER_NAME | VARCHAR2 | 360 | Name of the customer buying the item to be released. | |||
| DEMAND_CLASS | VARCHAR2 | 34 | Demand class code on the current sales order demand record. | |||
| FULFILLMENT_COST | NUMBER | Cost of the item associated with the fulfillment line id. | ||||
| ORDER_MARGIN | NUMBER | Order margin of the released order. | ||||
| PARENT_FULFILLMENT_LINE | NUMBER | Parent Fulfillment Line Identifier of the order. | Obsolete | |||
| ROOT_FULFILLMENT_LINE | NUMBER | Root fulfillment line Identifier of the order released. | Obsolete | |||
| SALES_ORDER_NUMBER | VARCHAR2 | 50 | Sales Order Number of the item released | Obsolete | ||
| SHIP_SET_NAME | VARCHAR2 | 30 | Ship set name of the lines that are part of a ship_set. | |||
| SHIP_TO_SITE_CODE | VARCHAR2 | 120 | Site code of the place where the release items to be delivered. | Obsolete | ||
| SO_LINE_NUM | VARCHAR2 | 50 | Sales Order Line number of the order released. | Obsolete | ||
| SR_INSTANCE_CODE | VARCHAR2 | 8 | Source Instance code form which the item is released. | Obsolete | ||
| MODE_OF_TRANSPORT | VARCHAR2 | 80 | Mode of Transport identifier which indicates the transport used for items to be delivered. | |||
| SERVICE_LEVEL | VARCHAR2 | 80 | Service level which indicates the transport used for items to be delivered. | |||
| SUPPLIER_SITE_SOURCE_SYSTEM | VARCHAR2 | 30 | Source system code where the supply request gets executed | Obsolete | ||
| ALLOW_EXPLOSION_FLAG | VARCHAR2 | 1 | This flag determines whether item structure need to be exploded to retrieve the component details while creating a work order in the Fusion manufacturing. | |||
| WORK_ORDER_SUB_TYPE | VARCHAR2 | 20 | This value indicates work order subtype of the work definition. | |||
| ORDER_LINE_ID | VARCHAR2 | 320 | Order line identifier of the record being released to source system. | |||
| PARENT_LINE_ID | NUMBER | 18 | Parent Line Identifier. For ATO component supply creation scenarios for referring to parent items. | |||
| ORDER_NUMBER | VARCHAR2 | 240 | WORK_ORDER_NUMBER + ORGANIZATION_CODE makes a unique work order. However, when the work order name is auto generated, the user may not have the work order name to pass via the open interface. So using this attribute, he/she will be uniquely maintain a unique work order and use this attribute value to connect the details in the WIE_WORK_ORDER_DETAILS_INT. The value of this column is user managed. This is not carried forward to the production tables | |||
| WORK_DEFINITION_CODE | VARCHAR2 | 240 | This value indicates code of the work definition. | |||
| WORK_DEFINITION_ID | NUMBER | 18 | This value indicates identifier of the work definition. | |||
| WORK_DEFINITION_AS_OF_DATE | DATE | Work definition of the order as of date. | ||||
| ORDER_TYPE | NUMBER | 4 | This value indicates the type of the order to be released. | |||
| WORK_ORDER_STATUS_ID | NUMBER | 18 | Status Identifier of the work order related to the item. | |||
| ORDER_LINE_NUMBER | VARCHAR2 | 150 | Order line number of the order released. | |||
| ORDER_ID | VARCHAR2 | 62 | Order Identifier of the items released. | |||
| SHIP_METHOD | VARCHAR2 | 30 | Order line number of the order released. | |||
| LINE_LOCATION_ID | VARCHAR2 | 320 | Line location identifier of the order. | |||
| SUPPLIER_SITE_SRC_SYSTEM_ID | NUMBER | 18 | Supplier site source system Identifier of the item released | |||
| SUPPLIER_SITE_SRC_SYSTEM | VARCHAR2 | 30 | Supplier site source system code of the order released. | |||
| ROOT_LINE_ID | NUMBER | 18 | Root line identifier of the order released | |||
| ROOT_LINE_NUMBER | VARCHAR2 | 400 | Root Line Number of the order released | |||
| PARENT_LINE_NUMBER | VARCHAR2 | 400 | Parent line Number of the order released. | |||
| DEMAND_CLASS_ID | NUMBER | 18 | Demand class code on the current sales order demand record. | |||
| CUSTOMER_ID | NUMBER | 18 | Customer Identifier that purchases the item associated with the released order. | |||
| CUSTOMER_SITE_ID | NUMBER | 18 | Site Identifier of the customer purchasing item. | |||
| CUSTOMER_SITE_CODE | VARCHAR2 | 30 | Site code of the customer purchasing item. | |||
| SERVICE_LEVEL_CODE | VARCHAR2 | 80 | SERVICE_LEVEL_CODE the one that we need to send back. | |||
| MODE_OF_TRANSPORT_CODE | VARCHAR2 | 80 | MODE_OF_TRANSPORT_CODE that we need to send back . | |||
| BACK_TO_BACK_FLAG | VARCHAR2 | 1 | This column value determines if the item is back to back enabled. 1-Yes, 2-No. | |||
| SOURCE_SYSTEM_ID | NUMBER | 18 | Source system identifier form where the supply request comes. | |||
| ERROR_FLAG | NUMBER | 1 | This column determines status of the record during release process. If the ERROR_TEXT is not null for the record then this should be set to 1. For good records, this should be set to 2. | |||
| Q_TEXT | CLOB | This column holds the relevant text for the respective job mentioned in job_definition_name column | ||||
| 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 | 100 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_NUMBER12 | VARCHAR2 | 100 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_NUMBER13 | VARCHAR2 | 100 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_NUMBER14 | VARCHAR2 | 100 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_NUMBER15 | VARCHAR2 | 100 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_NUMBER16 | VARCHAR2 | 100 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_NUMBER17 | VARCHAR2 | 100 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_NUMBER18 | VARCHAR2 | 100 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_NUMBER19 | VARCHAR2 | 100 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_NUMBER20 | VARCHAR2 | 100 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_NUMBER21 | VARCHAR2 | 100 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_NUMBER22 | VARCHAR2 | 100 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_NUMBER23 | VARCHAR2 | 100 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_NUMBER24 | VARCHAR2 | 100 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_NUMBER25 | VARCHAR2 | 100 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| DESTINATION_SUBINVENTORY_CODE | VARCHAR2 | 10 | This column stores the value of Destination Subinventory code. | |||
| SOURCE_SUBINVENTORY_CODE | VARCHAR2 | 10 | This column stores the value of Source Subinventory code. | |||
| CREATE_MOVEMENT_REQUEST | NUMBER | This column identifies whether to create a movement request or Transfer order between sub inventories of the same org. null = for other plan types and org level sourcing in repl plan, 1 = create movement request order type between sub inventories, 2 = do not create movement request order type between sub inventories. | ||||
| LINE_INTERFACE_ID | NUMBER | This column specifies Unique Identifier of the supply line. | ||||
| DISTRIBUTION_INTERFACE_ID | NUMBER | This column specifies Unique Identifier of the supply line details. | ||||
| ATTRIBUTE_TRANSFER_ELIGIBLE | NUMBER | This column stores the eligibility of the record for Project Transfer release. 1 implies Eligible. 2 or Null implies Not Eligible. | ||||
| PROJECT_REFERENCE_ENABLED | NUMBER | This flag indicates whether the project reference is enabled. 1-Yes, 2-No. | ||||
| DELIVER_TO_LOCATION_CODE | VARCHAR2 | 150 | Location code for the particular place on which the item need to be delivered. | |||
| PARTIAL_RELEASE | NUMBER | Indicates if a record is marked for partial release. 1 implies partial release. 2 implies other release status. | ||||
| 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_RELEASE_LINES_INT_N1 | Non Unique | Default | BATCH_ID, LOAD_TYPE, ERROR_FLAG |