DOS_SUPPLY_LINES_INT
Interface table to capture all Supply Order Line, Buy, Make, Transfer details and batch processing interface attributes
Details
-
Schema: FUSION
-
Object owner: DOS
-
Object type: TABLE
-
Tablespace: INTERFACE
Primary Key
Name | Columns |
---|---|
DOS_SUPPLY_LINES_ITF_PK |
LINE_INTERFACE_ID |
Columns
Name | Datatype | Length | Precision | Not-null | Comments |
---|---|---|---|---|---|
LINE_INTERFACE_ID | NUMBER | 18 | Yes | Unique Identifier System Generated value (Required) | |
LOAD_REQUEST_ID | NUMBER | 18 | Unique Identifier associated with the ESS SQL Loader Request; Generated using DOS_SUPPLY_LINES_INT_S sequence. could be null if the data is loaded using direct service invocation. | ||
HEADER_NUMBER | VARCHAR2 | 18 | 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_ORDER_ID | VARCHAR2 | 120 | Surrogate key of the Work Order | ||
WORK_ORDER_NUMBER | VARCHAR2 | 120 | Work Order Number. The uniqueness of which will be controlled by user at the work method level or at the plant level. Work Order Number. The uniqueness of which will be controlled by user at the work method level or at the plant level. | ||
ALLOW_EXPLOSION_FLAG | VARCHAR2 | 1 | This flag controls the behavior whether the Work Definition should be used in the creation of work order operations, operation resources and operation material. | ||
WORK_ORDER_STATUS_ID | NUMBER | 18 | Work Order Status Identifier based on lookup | ||
WORK_DEFINITION_NAME | VARCHAR2 | 80 | This is the name of the work definition. This denotes an alternate way of making a product. | ||
WORK_DEFINITION_AS_OF_DATE | TIMESTAMP | The as of date to automatically figure out the work definition when user does not know the exact work definition | |||
WORK_ORDER_SUB_TYPE | VARCHAR2 | 30 | For a specific Work Order Type, this attribute represents the specific nature of work being performed such as Standard Production, Prototyping, or Repair. | ||
WORK_DEFINITION_ID | VARCHAR2 | 18 | The foreign key reference to the work definition. | ||
WORK_METHOD_CODE | VARCHAR2 | 30 | The work method code for the Work order | ||
WORK_ORDER_TYPE | VARCHAR2 | 30 | Based on the Work Method, this attribute further classifies the Work Order to indicate whether it is meant for either Standard or Non Standard Production. | ||
SOURCE_SYSTEM_ID | VARCHAR2 | 120 | The application id value is stored here if the source_system_type is INTERNAL. If External, then the Source system as it is defined in TCA source systems table. FND_APPLICATION_ID.APPLICATION_ID HZ_ORIG_SYSTEMS_VL.ORIG_SYSTEM_ID | ||
SCHEDULING_METHOD | VARCHAR2 | 30 | Whether the work order is scheduled based on the Work Definition data or Manual. This lookup for which will be seeded in | ||
SOURCE_SYSTEM_TYPE | VARCHAR2 | 30 | Type of source system. Valid values are INTERNAL or EXTERNAL. Lookup = WIE_SOURCE_SYSTEM_TYPE | ||
INTERFACE_SOURCE_CODE | VARCHAR2 | 120 | The source of this record in the interface DOO, YPS | ||
PARENT_ITEM_ID | NUMBER | 18 | Parent Item ID for Source System Item ID | ||
PARENT_LINE_NUMBER | NUMBER | 18 | Parent Line number for this supply interface line | ||
LINE_NUMBER | NUMBER | 18 | Line number for this supply interface line | ||
GOP_SPLIT_REFERENCE_ID | VARCHAR2 | 300 | Reference identifier for the GOP split | ||
SUPPLY_ORDER_SOURCE | VARCHAR2 | 30 | The source of this supply Request DOO, YPS | ||
CUSTOMER_ORDER_SOURCE_SYSTEM | VARCHAR2 | 30 | Reference to the order capture system that the source order came from | ||
SPLIT_LINE_REFERENCE_ID | VARCHAR2 | 300 | Reference line identifier for the GOP split | ||
CUSTOMER_CONTACT_ID | NUMBER | 18 | Customer Contact ID for the DOO fline | ||
CUSTOMER_SHIP_TO_ID | NUMBER | 18 | Customer Ship To ID for the DOO fline | ||
CUSTOMER_ID | NUMBER | 18 | Customer Id for the DOO fulfillment line | ||
CUSTOMER_ORDER_SCHEDULE_NUMBER | VARCHAR2 | 50 | Customer order schedule ID for the DOO fline | ||
CUSTOMER_ORDER_LINE_NUMBER | VARCHAR2 | 50 | Customer order line Id for the DOO fline | ||
CUSTOMER_ORDER_NUMBER | VARCHAR2 | 50 | Customer Order ID for the DOO fline | ||
BACK_TO_BACK_FLAG | VARCHAR2 | 1 | Back To Back Item Indicator Flag | ||
HEADER_INTERFACE_ID | NUMBER | 18 | Yes | Foreign key to the DOS_SUPPLY_HEADERS_INT | |
INTERFACE_BATCH_NUMBER | VARCHAR2 | 50 | Yes | Batch Number for planning, GOP and inventory. Same as SUPPLY_ORDER_REFERENCE_NUMBER. | |
PROCESS_STATUS | VARCHAR2 | 30 | Yes | Interface header status, (FND Lookup) NEW- Interface record is created. COMPLETED- Processing is completed sucssesfully. ERROR- Loading / Processing failed. | |
ON_HOLD_REASON_CODE | VARCHAR2 | 30 | Reason for record being put on hold. | ||
SUPPLY_TYPE | VARCHAR2 | 30 | Yes | Type of supply being created. Defaulted from the calling application or derived from the payload attributes. E.g. Make, Buy or Transfer. This reflects the supply type passed by the requesting system. Non update able field, any changes to supply type will be reflected for tracking line supply type. | |
NEED_BY_DATE | TIMESTAMP | Date supply needs to be available | |||
INVENTORY_ITEM_ID | NUMBER | 18 | Yes | Source System Item ID (EGP_SYSTEMS_ITEMS_B) | |
QUANTITY | NUMBER | Yes | Requested Quantity. From Payload. Must be >= 0. | ||
UOM_CODE | VARCHAR2 | 3 | Yes | Unit of Measure. This is the UOM code. (INV_UNITS_OF_MEASURE_B) | |
SUPPLY_SOURCE_SYSTEM | VARCHAR2 | 120 | Source system code where the supply request is getting executed. From Payload. (HZ_ORIG_SYSTEMS_VL) | ||
SUPPLY_ORDER_REF_LINE_NUMBER | VARCHAR2 | 20 | Identifier of the source system that generated the interface record. Document Line reference number from the requesting system. | ||
SUPPLY_ORDER_REFERENCE_LINE_ID | NUMBER | 18 | Identifier of the source system that generated the interface record. | ||
SUPPLY_OPERATION | VARCHAR2 | 30 | Operation to be performed for the supply creation. Validate with lookup (FND_LOOKUPS) | ||
ITEM_DESCRIPTION | VARCHAR2 | 240 | Description for the item from item master | ||
ITEM_TYPE | VARCHAR2 | 30 | Item Type from item master during request | ||
ITEM_REVISION | VARCHAR2 | 72 | Revision of the Item being requested | ||
EXEC_SYSTEM_ITEM_NUMBER | VARCHAR2 | 300 | Item Name or Number. From payload, if not available then derived from PIM based on inventory item id. | ||
SECONDARY_QUANTITY | NUMBER | Quantity requested in secondary unit of measure | |||
SECONDARY_UOM_CODE | VARCHAR2 | 3 | Secondary Quantity Unit of Measure | ||
DESTINATION_BU_ID | NUMBER | 18 | Operating unit in the source system for the destination organization | ||
DESTINATION_ORGANIZATION_ID | NUMBER | 18 | Destination organization ID (for purchase request and internal req request) | ||
DESTINATION_ORGANIZATION_CODE | VARCHAR2 | 18 | Destination Organization Code (for internal req) | ||
PARENT_LINE_ID | NUMBER | 18 | Parent Line Identifier. For ATO component supply creation scenarios for referring to parent items. | ||
EXEC_SYSTEM_PROJECT_ID | NUMBER | 18 | Project identifier under which this supply request is executed | ||
EXEC_SYSTEM_PROJECT_NAME | VARCHAR2 | 240 | Project under which this supply request is executed | ||
EXEC_SYSTEM_TASK_ID | NUMBER | 18 | Task identifier under which the supply request falls | ||
EXEC_SYSTEM_TASK_NAME | VARCHAR2 | 255 | Task name / Tracking Line Attributes - End | ||
CANCEL_REASON_CODE | VARCHAR2 | 30 | Reason for cancellation of supply request | ||
CANCEL_COMMENTS | VARCHAR2 | 1000 | Free form text to capture additional comments | ||
AUTOSOURCE_FLAG | VARCHAR2 | 1 | Auto Source Flag indicates to determine source automatically | ||
AUTHORIZATION_STATUS | VARCHAR2 | 40 | Approval status for the buy request. By default stamped as "Approved" for all requests sent by planning. | ||
GROUP_CODE | VARCHAR2 | 120 | Import Group Code for this line in a group | ||
BATCH_ID | NUMBER | 18 | Import Batch ID / Buy Order Detail - Start | ||
PREPARER_ID | NUMBER | 18 | User Id of the preparer of this supply request | ||
REQUISITIONING_BU_ID | NUMBER | 18 | Business Unit creating the purchase requisition | ||
END_INVENTORY_ITEM_ID | NUMBER | 18 | Passed in case of internal purchase req | ||
REQUISITION_LINE_ID | VARCHAR2 | 20 | Unique identifier for the requisition line | ||
LINE_LOCATION_ID | NUMBER | 18 | Purchase Order Schedule Identifier | ||
LINE_TYPE_ID | NUMBER | 18 | Value = MRP. Imported requisitions show MRP is the source of the line.EBS specific field for req import | ||
BUYER_ID | NUMBER | 18 | Buyer who will be used for purchase request | ||
CATEGORY_ID | NUMBER | 18 | Category Identifier for supply request | ||
DISTRIBUTION_ID | NUMBER | 18 | Purchase order distribution identifier fro PO reschedules. / Buy Order Details - End | ||
DELIVER_TO_LOCATION_ID | NUMBER | 18 | Deliver to Location ID. New or Reschedule IR/ISO/TO | ||
DELIVER_TO_REQUESTOR_ID | NUMBER | 18 | Deliver to requestor id, Employee's HR User-Id. Transfer Order | ||
PURCHASE_ORDER_HEADER_ID | VARCHAR2 | 120 | Purchase Header Identifier for Update/Cancel requests | ||
PURCHASE_ORDER_LINE_ID | VARCHAR2 | 20 | Purchase Order Line Identifier for Update/Cancel requests | ||
PURCHASE_ORDER_SCHEDULE_NUMBER | VARCHAR2 | 20 | To capture the Purchase Order Schedule Number in a regular Back to Back and the Contract Manufacturing flows | ||
SUGGESTED_VENDOR_ID | NUMBER | 18 | Suggested Vendor ID for puchase request | ||
SUGGESTED_VENDOR_SITE_ID | NUMBER | 18 | Suggested Vendor Site ID for puchase request | ||
SCHEDULED_SHIP_DATE | TIMESTAMP | Ship Date scheduled for this supply request | |||
REQUESTED_SHIP_DATE | TIMESTAMP | Requested Ship Date for this supply request | |||
EARLIEST_SHIP_DATE | TIMESTAMP | Earliest Possible Ship Date for this supply request | |||
DELIVERY_LEAD_TIME | NUMBER | 5 | Transit lead time for this supply request | ||
SHIPPING_METHOD | VARCHAR2 | 120 | Shipping Method for this supply request | ||
DESTINATION_TYPE_CODE | VARCHAR2 | 30 | Destination Type for this supply request | ||
DESTINATION_SUBINVENTORY_CODE | VARCHAR2 | 40 | Destination Subinventory where goods are excpected | ||
REQUISITION_NUMBER | VARCHAR2 | 120 | Purchase requisition number for UPDATE/CANCEL requests | ||
REQUISITION_LINE_NUMBER | VARCHAR2 | 20 | Purchase requisition line number for UPDATE/CANCEL requests | ||
REQUISITION_SOURCE_TYPE_CODE | VARCHAR2 | 120 | Requisition Source Type for this supply request | ||
PURCHASE_ORDER_NUMBER | VARCHAR2 | 120 | Purchase Order Number for UPDATE/CANCEL requests | ||
PURCHASE_ORDER_LINE_NUMBER | VARCHAR2 | 20 | Purchase Order Line Number for UPDATE/CANCEL requests | ||
EXEC_SYSTEM_DELIVER_TO_SUBINV | VARCHAR2 | 40 | Subinventory where goods need to be delivered | ||
EXEC_SYSTEM_DELVR_TO_LOC_NAME | VARCHAR2 | 240 | Location where goods need to be delivered | ||
EXEC_SYSTEM_DELVR_TO_REQUESTOR | VARCHAR2 | 240 | Deliver to requester name. This column maps to the HR user name and is populated to be passed to non fusion systems. | ||
EXEC_SYSTEM_SUGGESTED_VENDOR | VARCHAR2 | 240 | Suggested Vendor Name for purchase request | ||
EXEC_SYSTEM_SUGSTD_VENDOR_SITE | VARCHAR2 | 240 | Suggested Vendor Site Name for purchase request | ||
GROUP_ID | NUMBER | 18 | Group Identifier for this interface line | ||
LOAD_TYPE | VARCHAR2 | 30 | Load Type / Make Order Details - Start | ||
DELIVER_TO_SUBINVENTORY | VARCHAR2 | 40 | Completion sub-inventory for WIIP jobs | ||
NET_QUANTITY | NUMBER | Job Net Quantity of the Work Order | |||
NET_QUANTITY_UOM_CODE | VARCHAR2 | 3 | Net Quantity Unit of Measure Code | ||
SCHEDULE_GRP_ID | NUMBER | 18 | Schedule Group ID for the Work order | ||
CHARGE_ACCT_ID | NUMBER | 18 | Charge account identifier for the request | ||
BUILD_SEQUENCE | NUMBER | 18 | Build Sequence of the Work order | ||
ACCOUNTING_CLASS_CODE | VARCHAR2 | 120 | Accounting class associated with job | ||
BOM_REVISION_DATE | TIMESTAMP | BOM revision date for the Work order | |||
ROUTING_REVISION_DATE | TIMESTAMP | Routing revision date for the Work order | |||
FIRM_PLANNED_FLAG | VARCHAR2 | 1 | Firm flag control for planning rescheduling. | ||
DEMAND_CLASS | VARCHAR2 | 30 | Demand class code for the Work order | ||
ALT_BOM_DESIGNATOR | VARCHAR2 | 30 | Alternate BOM Designator for the Work order | ||
ALT_ROUTING_DESIGNATOR | VARCHAR2 | 30 | Alternate Routing Designator for the Work order | ||
TRANSFER_ORDER_HEADER_ID | VARCHAR2 | 120 | Transfer Order Header Id. For reschedule of Transfer Order. A user request for material transfer is processed through a transfer order. | ||
TRANSFER_ORDER_LINE_ID | VARCHAR2 | 20 | Transfer Order Line Id. For reschedule of Transfer Order. | ||
TRANSFER_ORDER_HEADER_NUMBER | VARCHAR2 | 120 | Transfer Order Header Number. For reschedule of Transfer Order. | ||
TRANSFER_ORDER_LINE_NUMBER | VARCHAR2 | 20 | Transfer Order Line Number. For reschedule of Transfer Order. | ||
END_ITEM_NAME | VARCHAR2 | 300 | End Item Name for the Work order | ||
SOURCE_BU_ID | NUMBER | 18 | Source Operating Unit for the Purchase request Operating unit in the source system for the source organization (Internal Req) | ||
SOURCE_ORGANIZATION_ID | NUMBER | 18 | Organization ID in the supply source system. | ||
SALES_ORDER_HEADER_ID | NUMBER | 18 | Sales Order Header Id in the source system. For reschedule of IR/ISO. A user request for material transfer is processed through a purchase order. | ||
SALES_ORDER_LINE_ID | NUMBER | 18 | Sales Order Line Id in the source system. For reschedule of IR/ISO. | ||
SALES_ORDER_HEADER_NUMBER | VARCHAR2 | 120 | Sales Order Header Number in the source system. For reschedule of IR/ISO. | ||
SALES_ORDER_LINE_NUMBER | VARCHAR2 | 20 | Sales Order Line Number in the source system. For reschedule of IR/ISO. | ||
SOURCE_SUBINVENTORY_CODE | VARCHAR2 | 40 | Source Subinventory for goods requested | ||
SOURCE_LOCATION_ID | NUMBER | 18 | Source Location Identifier for goods | ||
DESTINATION_LOCATION_ID | NUMBER | 18 | Destination Location Identifier for request | ||
AGREEMENT_ID | NUMBER | 18 | Agreement used for transfer price calculation. Derived by invoking SFO service FOS Primary Trade Relationship ID returned by the service | ||
CARRIER_ID | NUMBER | 18 | Reference to unique identification for carrier used on the line. | ||
SHIP_TO_PARTY_ID | NUMBER | 18 | Ship to party for the transfer request. This value is passed to DOO, when the transfer shipment is routed through DOO. | ||
SHIP_TO_PARTY_SITE_ID | NUMBER | 18 | Ship to party site for the transfer request. This value is passed to DOO, when the transfer shipment is routed through DOO. | ||
SHIP_CLASS_OF_SERVICE | VARCHAR2 | 30 | Priority of transportation that affects how quickly goods are transported. SSP/INV | ||
SHIP_MODE_OF_TRANSPORT | VARCHAR2 | 30 | SSP/INV. Air shipment, shipping by sea or rail. | ||
SHIPMENT_PRIORITY_CODE | VARCHAR2 | 30 | Indicates the priority of the fulfillment lines to be shipped. | ||
DOO_SHIPMENT_FLAG | VARCHAR2 | 1 | This column identifies if the transfer shipment needs to be routed through DOO. | ||
FIRM_DEMAND_FLAG | VARCHAR2 | 1 | Indicates demand is firm or can be changed | ||
FUNDS_STATUS | VARCHAR2 | 30 | Fund Status for a distribution, used for budgetary calculation. There are two types of internal material transfers. Type 1 - is the transfer of inventory items between inventory locations. Type 2 - is the transfer of inventory items to an expense destination. It is not common outside of Federal Government to budgetary control type 1 Internal Material Transfers. Type 2 Internal Material Transfers are typically budgetary controlled as they impact the expense budgets. In both types of Internal Material Transfer, it is expected that the request (requisition) is a commitment, the in process transfer transaction is an obligation, and the completed transfer transaction is an expenditure. This may require the adoption of specialized Funds Reservation Categories to manage the amounts. | ||
BUDGET_DATE | TIMESTAMP | Budget Date for the supply request | |||
EXEC_SYSTEM_SOURCE_ORG_CODE | VARCHAR2 | 18 | Organization Code in the source system (WIP Job) Source Organization Code for Internal Req | ||
EXEC_SYSTEM_SOURCE_LOCTR_CODE | VARCHAR2 | 40 | Source Locator in source system | ||
REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | ||
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. | ||
WORK_ORDER_COMPLETION_DATE | TIMESTAMP | Scheduled ship date from GOP payload Planning to provide start or completion date of the job. This could be different from need by date | |||
WORK_ORDER_START_DATE | TIMESTAMP | Work Order Planned Start Date sent from requestor | |||
WORK_ORDER_DESCRIPTION | VARCHAR2 | 950 | WIP Job description. Populated by planning for WIP job requests. | ||
RESUBMIT_COUNT | NUMBER | 6 | Number of retries performed on the line interface record to recover it from error. | ||
SUPPLY_ORDER_HEADER_ID | NUMBER | 18 | Stores the Header Id of the Supply Order of which the line interface record becomes a part, upon order creation. | ||
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. | ||
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. | |
ITEM_NUMBER | VARCHAR2 | 300 | Inventory item for the supply request | ||
SOURCE_ORGANIZATION_CODE | VARCHAR2 | 18 | Source Organization Code for goods | ||
REFERENCE_TRACKING_LINE_ID | NUMBER | 18 | This field is used to store original tracking line id for IMT update transfer request, populated by PL/SQL procedure for update transfer order. | ||
OUTSIDE_PROCESSING_FLAG | VARCHAR2 | 1 | Flag to indicate whether this order is for Outside Processing supply | ||
SHIPMENT_FLAG | VARCHAR2 | 1 | Flag to indicate if the interface record is for shipment line. | ||
BUDGET_CONTROL_ENABLED_FLAG | VARCHAR2 | 1 | Flag to indicate that line is under budgetary control. | ||
TRANSFER_PRICE_CURRENCY_CODE | VARCHAR2 | 15 | Currency Code for Transfer Price. | ||
TRANSFER_PRICE | NUMBER | Transfer price per unit sent by supply requesting application. Applicable for transfer requests from SSP | |||
REPRICE_FLAG | VARCHAR2 | 1 | Flag to indicate if transfer supply request can be repriced by calling Supply Chain Financial Orchestration. | ||
MOVEMENT_REQUEST_FLAG | VARCHAR2 | 1 | Flag to indicate if this is for a movement request | ||
COMMENTS | VARCHAR2 | 240 | User comments such as reason for "RETURN" type of transfer order | ||
NOTE_TO_RECEIVER | VARCHAR2 | 1000 | This column will store the note to receiver | ||
NOTE_TO_SUPPLIER | VARCHAR2 | 1000 | This column will store the note to supplier | ||
XFER_ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | ||
XFER_ATTRIBUTE_CHAR1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
XFER_ATTRIBUTE_CHAR2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
XFER_ATTRIBUTE_CHAR3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
XFER_ATTRIBUTE_CHAR4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
XFER_ATTRIBUTE_CHAR5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
XFER_ATTRIBUTE_CHAR6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
XFER_ATTRIBUTE_CHAR7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
XFER_ATTRIBUTE_CHAR8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
XFER_ATTRIBUTE_CHAR9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
XFER_ATTRIBUTE_CHAR10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
XFER_ATTRIBUTE_CHAR11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
XFER_ATTRIBUTE_CHAR12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
XFER_ATTRIBUTE_CHAR13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
XFER_ATTRIBUTE_CHAR14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
XFER_ATTRIBUTE_CHAR15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
XFER_ATTRIBUTE_CHAR16 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
XFER_ATTRIBUTE_CHAR17 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
XFER_ATTRIBUTE_CHAR18 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
XFER_ATTRIBUTE_CHAR19 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
XFER_ATTRIBUTE_CHAR20 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
XFER_ATTRIBUTE_NUMBER1 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
XFER_ATTRIBUTE_NUMBER2 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
XFER_ATTRIBUTE_NUMBER3 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
XFER_ATTRIBUTE_NUMBER4 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
XFER_ATTRIBUTE_NUMBER5 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
XFER_ATTRIBUTE_NUMBER6 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
XFER_ATTRIBUTE_NUMBER7 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
XFER_ATTRIBUTE_NUMBER8 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
XFER_ATTRIBUTE_NUMBER9 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
XFER_ATTRIBUTE_NUMBER10 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
XFER_ATTRIBUTE_DATE1 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
XFER_ATTRIBUTE_DATE2 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
XFER_ATTRIBUTE_DATE3 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
XFER_ATTRIBUTE_DATE4 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
XFER_ATTRIBUTE_DATE5 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
XFER_ATTRIBUTE_TIMESTAMP1 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
XFER_ATTRIBUTE_TIMESTAMP2 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
XFER_ATTRIBUTE_TIMESTAMP3 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
XFER_ATTRIBUTE_TIMESTAMP4 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
XFER_ATTRIBUTE_TIMESTAMP5 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
WORK_PROCESS_NAME | VARCHAR2 | 120 | This column will store the Work process name. | ||
WORK_ORDER_PRIORITY | NUMBER | Used to set the priority of the work order depending on the demand that needed to be prioritized | |||
MAKE_ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Descriptive Flexfield:Structure definition of the user descriptive flexfield | ||
MAKE_ATTRIBUTE_CHAR1 | VARCHAR2 | 150 | Descriptive Flexfield:segment of the user descriptive flexfield | ||
MAKE_ATTRIBUTE_CHAR2 | VARCHAR2 | 150 | Descriptive Flexfield:Segment of the user descriptive flexfield | ||
MAKE_ATTRIBUTE_CHAR3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield | ||
MAKE_ATTRIBUTE_CHAR4 | VARCHAR2 | 150 | Descriptive flexfield:segment of the user descriptive flexfield | ||
MAKE_ATTRIBUTE_CHAR5 | VARCHAR2 | 150 | Descriptive flexfield:segment of the user descriptive flexfield | ||
MAKE_ATTRIBUTE_CHAR6 | VARCHAR2 | 150 | Descriptive flexfield: segment of the user descriptive flexfield | ||
MAKE_ATTRIBUTE_CHAR7 | VARCHAR2 | 150 | Descriptive flexfield: segment of the user descriptive flexfield | ||
MAKE_ATTRIBUTE_CHAR8 | VARCHAR2 | 150 | Descriptive flexfield: segment of the user descriptive flexfield | ||
MAKE_ATTRIBUTE_CHAR9 | VARCHAR2 | 150 | Descriptive flexfield: segment of the user descriptive flexfield | ||
MAKE_ATTRIBUTE_CHAR10 | VARCHAR2 | 150 | Descriptive flexfield: segment of the user descriptive flexfield | ||
MAKE_ATTRIBUTE_CHAR11 | VARCHAR2 | 150 | Descriptive flexfield: segment of the user descriptive flexfield | ||
MAKE_ATTRIBUTE_CHAR12 | VARCHAR2 | 150 | Descriptive flexfield: segment of the user descriptive flexfield | ||
MAKE_ATTRIBUTE_CHAR13 | VARCHAR2 | 150 | Descriptive flexfield: segment of the user descriptive flexfield | ||
MAKE_ATTRIBUTE_CHAR14 | VARCHAR2 | 150 | Descriptive flexfield: segment of the user descriptive flexfield | ||
MAKE_ATTRIBUTE_CHAR15 | VARCHAR2 | 150 | Descriptive flexfield: segment of the user descriptive flexfield | ||
MAKE_ATTRIBUTE_CHAR16 | VARCHAR2 | 150 | Descriptive flexfield: segment of the user descriptive flexfield | ||
MAKE_ATTRIBUTE_CHAR17 | VARCHAR2 | 150 | Descriptive flexfield: segment of the user descriptive flexfield | ||
MAKE_ATTRIBUTE_CHAR18 | VARCHAR2 | 150 | Descriptive flexfield: segment of the user descriptive flexfield | ||
MAKE_ATTRIBUTE_CHAR19 | VARCHAR2 | 150 | Descriptive flexfield: segment of the user descriptive flexfield | ||
MAKE_ATTRIBUTE_CHAR20 | VARCHAR2 | 150 | Descriptive flexfield: segment of the user descriptive flexfield | ||
MAKE_ATTRIBUTE_NUMBER1 | NUMBER | Descriptive flexfield:segment of the user descriptive flexfield | |||
MAKE_ATTRIBUTE_NUMBER2 | NUMBER | Descriptive flexfield:segment of the user descriptive flexfield | |||
MAKE_ATTRIBUTE_NUMBER3 | NUMBER | Descriptive flexfield:segment of the user descriptive flexfield | |||
MAKE_ATTRIBUTE_NUMBER4 | NUMBER | Descriptive flexfield:segment of the user descriptive flexfield | |||
MAKE_ATTRIBUTE_NUMBER5 | NUMBER | Descriptive flexfield:segment of the user descriptive flexfield | |||
MAKE_ATTRIBUTE_NUMBER6 | NUMBER | Descriptive flexfield:segment of the user descriptive flexfield | |||
MAKE_ATTRIBUTE_NUMBER7 | NUMBER | Descriptive flexfield:segment of the user descriptive flexfield | |||
MAKE_ATTRIBUTE_NUMBER8 | NUMBER | Descriptive flexfield:segment of the user descriptive flexfield | |||
MAKE_ATTRIBUTE_NUMBER9 | NUMBER | Descriptive flexfield:segment of the user descriptive flexfield | |||
MAKE_ATTRIBUTE_NUMBER10 | NUMBER | Descriptive flexfield:segment of the user descriptive flexfield | |||
MAKE_ATTRIBUTE_DATE1 | DATE | Descriptive flexfield:segment of the user descriptive flexfield | |||
MAKE_ATTRIBUTE_DATE2 | DATE | Descriptive flexfield:segment of the user descriptive flexfield | |||
MAKE_ATTRIBUTE_DATE3 | DATE | Descriptive flexfield:segment of the user descriptive flexfield | |||
MAKE_ATTRIBUTE_DATE4 | DATE | Descriptive flexfield:segment of the user descriptive flexfield | |||
MAKE_ATTRIBUTE_DATE5 | DATE | Descriptive flexfield:segment of the user descriptive flexfield | |||
MAKE_ATTRIBUTE_TIMESTAMP1 | TIMESTAMP | Descriptive flexfield:segment of the user descriptive flexfield | |||
MAKE_ATTRIBUTE_TIMESTAMP2 | TIMESTAMP | Descriptive flexfield:segment of the user descriptive flexfield | |||
MAKE_ATTRIBUTE_TIMESTAMP3 | TIMESTAMP | Descriptive flexfield:segment of the user descriptive flexfield | |||
MAKE_ATTRIBUTE_TIMESTAMP4 | TIMESTAMP | Descriptive flexfield:segment of the user descriptive flexfield | |||
MAKE_ATTRIBUTE_TIMESTAMP5 | TIMESTAMP | Descriptive flexfield:segment of the user descriptive flexfield | |||
BUY_ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Descriptive flexfield:Structure definition of the user descriptive flexfield | ||
BUY_ATTRIBUTE_CHAR1 | VARCHAR2 | 150 | Descriptive flexfield:segment of the user descriptive flexfield | ||
BUY_ATTRIBUTE_CHAR2 | VARCHAR2 | 150 | Descriptive flexfield:segment of the user descriptive flexfield | ||
BUY_ATTRIBUTE_CHAR3 | VARCHAR2 | 150 | Descriptive flexfield:segment of the user descriptive flexfield | ||
BUY_ATTRIBUTE_CHAR4 | VARCHAR2 | 150 | Descriptive flexfield:segment of the user descriptive flexfield | ||
BUY_ATTRIBUTE_CHAR5 | VARCHAR2 | 150 | Descriptive flexfield:segment of the user descriptive flexfield | ||
BUY_ATTRIBUTE_CHAR6 | VARCHAR2 | 150 | Descriptive flexfield:segment of the user descriptive flexfield | ||
BUY_ATTRIBUTE_CHAR7 | VARCHAR2 | 150 | Descriptive flexfield:segment of the user descriptive flexfield | ||
BUY_ATTRIBUTE_CHAR8 | VARCHAR2 | 150 | Descriptive flexfield:segment of the user descriptive flexfield | ||
BUY_ATTRIBUTE_CHAR9 | VARCHAR2 | 150 | Descriptive flexfield:segment of the user descriptive flexfield | ||
BUY_ATTRIBUTE_CHAR10 | VARCHAR2 | 150 | Descriptive flexfield:segment of the user descriptive flexfield | ||
BUY_ATTRIBUTE_CHAR11 | VARCHAR2 | 150 | Descriptive flexfield:segment of the user descriptive flexfield | ||
BUY_ATTRIBUTE_CHAR12 | VARCHAR2 | 150 | Descriptive flexfield:segment of the user descriptive flexfield | ||
BUY_ATTRIBUTE_CHAR13 | VARCHAR2 | 150 | Descriptive flexfield:segment of the user descriptive flexfield | ||
BUY_ATTRIBUTE_CHAR14 | VARCHAR2 | 150 | Descriptive flexfield:segment of the user descriptive flexfield | ||
BUY_ATTRIBUTE_CHAR15 | VARCHAR2 | 150 | Descriptive flexfield:segment of the user descriptive flexfield | ||
BUY_ATTRIBUTE_CHAR16 | VARCHAR2 | 150 | Descriptive flexfield:segment of the user descriptive flexfield | ||
BUY_ATTRIBUTE_CHAR17 | VARCHAR2 | 150 | Descriptive flexfield:segment of the user descriptive flexfield | ||
BUY_ATTRIBUTE_CHAR18 | VARCHAR2 | 150 | Descriptive flexfield:segment of the user descriptive flexfield | ||
BUY_ATTRIBUTE_CHAR19 | VARCHAR2 | 150 | Descriptive flexfield:segment of the user descriptive flexfield | ||
BUY_ATTRIBUTE_CHAR20 | VARCHAR2 | 150 | Descriptive flexfield:segment of the user descriptive flexfield | ||
BUY_ATTRIBUTE_NUMBER1 | NUMBER | Descriptive flexfield:segment of the user descriptive flexfield | |||
BUY_ATTRIBUTE_NUMBER2 | NUMBER | Descriptive flexfield:segment of the user descriptive flexfield | |||
BUY_ATTRIBUTE_NUMBER3 | NUMBER | Descriptive flexfield:segment of the user descriptive flexfield | |||
BUY_ATTRIBUTE_NUMBER4 | NUMBER | Descriptive flexfield:segment of the user descriptive flexfield | |||
BUY_ATTRIBUTE_NUMBER5 | NUMBER | Descriptive flexfield:segment of the user descriptive flexfield | |||
BUY_ATTRIBUTE_NUMBER6 | NUMBER | Descriptive flexfield:segment of the user descriptive flexfield | |||
BUY_ATTRIBUTE_NUMBER7 | NUMBER | Descriptive flexfield:segment of the user descriptive flexfield | |||
BUY_ATTRIBUTE_NUMBER8 | NUMBER | Descriptive flexfield:segment of the user descriptive flexfield | |||
BUY_ATTRIBUTE_NUMBER9 | NUMBER | Descriptive flexfield:segment of the user descriptive flexfield | |||
BUY_ATTRIBUTE_NUMBER10 | NUMBER | Descriptive flexfield:segment of the user descriptive flexfield | |||
BUY_ATTRIBUTE_DATE1 | DATE | Descriptive flexfield:segment of the user descriptive flexfield | |||
BUY_ATTRIBUTE_DATE2 | DATE | Descriptive flexfield:segment of the user descriptive flexfield | |||
BUY_ATTRIBUTE_DATE3 | DATE | Descriptive flexfield:segment of the user descriptive flexfield | |||
BUY_ATTRIBUTE_DATE4 | DATE | Descriptive flexfield:segment of the user descriptive flexfield | |||
BUY_ATTRIBUTE_DATE5 | DATE | Descriptive flexfield:segment of the user descriptive flexfield | |||
BUY_ATTRIBUTE_TIMESTAMP1 | TIMESTAMP | Descriptive flexfield:segment of the user descriptive flexfield | |||
BUY_ATTRIBUTE_TIMESTAMP2 | TIMESTAMP | Descriptive flexfield:segment of the user descriptive flexfield | |||
BUY_ATTRIBUTE_TIMESTAMP3 | TIMESTAMP | Descriptive flexfield:segment of the user descriptive flexfield | |||
BUY_ATTRIBUTE_TIMESTAMP4 | TIMESTAMP | Descriptive flexfield:segment of the user descriptive flexfield | |||
BUY_ATTRIBUTE_TIMESTAMP5 | TIMESTAMP | Descriptive flexfield:segment of the user descriptive flexfield | |||
BUY_ATTRIBUTE_DATE6 | DATE | Descriptive flexfield:segment of the user descriptive flexfield | |||
BUY_ATTRIBUTE_DATE7 | DATE | Descriptive flexfield:segment of the user descriptive flexfield | |||
BUY_ATTRIBUTE_DATE8 | DATE | Descriptive flexfield:segment of the user descriptive flexfield | |||
BUY_ATTRIBUTE_DATE9 | DATE | Descriptive flexfield:segment of the user descriptive flexfield | |||
BUY_ATTRIBUTE_DATE10 | DATE | Descriptive flexfield:segment of the user descriptive flexfield | |||
BUY_ATTRIBUTE_TIMESTAMP6 | TIMESTAMP | Descriptive flexfield:segment of the user descriptive flexfield | |||
BUY_ATTRIBUTE_TIMESTAMP7 | TIMESTAMP | Descriptive flexfield:segment of the user descriptive flexfield | |||
BUY_ATTRIBUTE_TIMESTAMP8 | TIMESTAMP | Descriptive flexfield:segment of the user descriptive flexfield | |||
BUY_ATTRIBUTE_TIMESTAMP9 | TIMESTAMP | Descriptive flexfield:segment of the user descriptive flexfield | |||
BUY_ATTRIBUTE_TIMESTAMP10 | TIMESTAMP | Descriptive flexfield:segment of the user descriptive flexfield |
Indexes
Index | Uniqueness | Tablespace | Columns |
---|---|---|---|
DOS_SUPPLY_LINES_INT_FK1 | Non Unique | FUSION_TS_TX_IDX | HEADER_INTERFACE_ID |
DOS_SUPPLY_LINES_INT_N1 | Non Unique | FUSION_TS_TX_IDX | SUPPLY_ORDER_REFERENCE_LINE_ID |
DOS_SUPPLY_LINES_INT_N2 | Non Unique | FUSION_TS_TX_IDX | INTERFACE_BATCH_NUMBER |
DOS_SUPPLY_LINES_INT_N3 | Non Unique | FUSION_TS_TX_IDX | PROCESS_STATUS |
DOS_SUPPLY_LINES_INT_N4 | Non Unique | Default | SUPPLY_ORDER_HEADER_ID |
DOS_SUPPLY_LINES_INT_U1 | Unique | FUSION_TS_TX_IDX | LINE_INTERFACE_ID |