DOS_SUPPLY_BUY_ORDER_DTLS
Supply buy order detail will store the attributes that are specific to a buy supply request.
Details
-
Schema: FUSION
-
Object owner: DOS
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
DOS_SUPPLY_BUY_ORDER_DTLS_PK |
SUPPLY_BUY_ORD_DTLS_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| SUPPLY_BUY_ORD_DTLS_ID | NUMBER | 18 | Yes | Supply Buy Order Detail Identifier | |
| WORK_ORDER_SUB_TYPE | VARCHAR2 | 30 | Used for OSP Buy flow. For a specific Work Order Type, this attribute represents the specific nature of work being performed such as Standard Production, Prototyping, or Repair. | ||
| SHIP_MODE_OF_TRANSPORT | VARCHAR2 | 30 | SSP/INV. Air shipment, shipping by sea or rail. | ||
| CARRIER_ID | NUMBER | 18 | Freight carrier that will be used for shipment | ||
| FIRM_FLAG | VARCHAR2 | 1 | Firm Flag or Firm Demand Flag. Passed by planning for new or reschedule Buy Order, IR/ISO | ||
| SHIP_CLASS_OF_SERVICE | VARCHAR2 | 30 | Priority of transportation that affects how quickly goods are transported. SSP/INV | ||
| PURCHASE_ORDER_SCHEDULE_NUMBER | VARCHAR2 | 20 | To capture the Purchase Order Schedule Number in a regular Back to Back and the Contract Manufacturing flows | ||
| REQUISITIONING_BU_ID | NUMBER | 18 | Business Unit creating the purchase requisition | ||
| SHIPMENT_PRIORITY_CODE | VARCHAR2 | 30 | Indicates the priority of the fulfillment lines to be shipped. New or Reschedule of IR/ISO and TO. | ||
| AUTHORIZATION_STATUS | VARCHAR2 | 30 | Approval status for the buy request. By default stamped as "Approved" for all request sent by planning. | ||
| EXEC_SYSTEM_DELVR_TO_REQUESTOR | VARCHAR2 | 240 | Deliver to requestor name. This column maps to the HR user name and is populated to be passed to non fusion systems. | ||
| EXEC_SYSTEM_DESTN_LOCTR_CODE | VARCHAR2 | 40 | Destination Locator Code for supply request | ||
| REQUISITION_LINE_NUMBER | VARCHAR2 | 20 | Requisition line created for this buy request line | ||
| REQUISITION_NUMBER | VARCHAR2 | 120 | Requisition created for this buy request | ||
| REQUISITION_ID | VARCHAR2 | 120 | Surrogate key for the Requisition created | ||
| LINE_TYPE_ID | NUMBER | 18 | Value = MRP. Imported requisitions show MRP is the source of the line. EBS specific field for req import | ||
| DISTRIBUTION_ID | NUMBER | 18 | Purchase order distribution identifier fro PO reschedules | ||
| NEED_BY_DATE | TIMESTAMP | Date supply needs to be available | |||
| EXEC_SYSTEM_SUGGESTED_VENDOR | VARCHAR2 | 240 | The suggested vendor for this buy request | ||
| EXEC_SYSTEM_SUGSTD_VENDOR_SITE | VARCHAR2 | 240 | The suggested vendor site for this buy request | ||
| 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. | |
| TRACKING_LINE_ID | NUMBER | 18 | Yes | Supply Tracking Line Identifier | |
| BUYER_ID | NUMBER | 18 | This field is enriched by Decomposition layer. It is populated with the buyer_id associated with the item. This field is used when the groups are created for Supply Set. | ||
| CATEGORY_ID | NUMBER | 18 | This field is enriched by Decomposition layer. It is populated with the category_id associated with the items purchasing category set. This field is used when the groups are created for Supply Set. | ||
| BATCH_ID | NUMBER | 18 | Purchase Request, Identifies the set of rows need to import by setting the interface source code and batch id columns appropriately in the req interface table. | ||
| GROUP_CODE | VARCHAR2 | 120 | PO Requsition - when a value is provided GROUP_CODE column, all lines with the same value in this column are grouped together under a requisition header. WIP Job - it identifies a batch of records for processing; when loading detail records, this column cannot be NULL | ||
| PREPARER_ID | NUMBER | 18 | Passed to Internal Requisition, Transfer Order, Purchase Requisition | ||
| SCHEDULED_SHIP_DATE | TIMESTAMP | Internal Req - Ship Date Sales Order - Scheduled Ship Date for reschedule | |||
| REQUESTED_SHIP_DATE | TIMESTAMP | Requested Ship Date for Purchase Order | |||
| EARLIEST_SHIP_DATE | TIMESTAMP | Sales Order - Earliest Shipment Date | |||
| DELIVERY_LEAD_TIME | NUMBER | 5 | Sales Order - Delivery Lead Time | ||
| EXEC_SYSTEM_DELIVER_TO_SUBINV | VARCHAR2 | 40 | 500 | Subinventory where goods need to be delivered | |
| DELIVER_TO_LOCATION_ID | NUMBER | 18 | Internal Requisition, Purchase Request, Transfer Order - Deliver to Location Id | ||
| EXEC_SYSTEM_DELVR_TO_LOC_NAME | VARCHAR2 | 240 | 960 | Internal Requisition, Purchase Request, Transfer Order - Deliver to Location Name | |
| SUGGESTED_VENDOR_ID | NUMBER | 18 | Purchase Req - Suggested Vendor Id | ||
| SUGGESTED_VENDOR_SITE_ID | NUMBER | 18 | Purchase Req - Suggested Vendor Site Id | ||
| DELIVER_TO_REQUESTOR_ID | NUMBER | 18 | Internal Req, Purchase Req, Transfer Order - Deliver to requestor Id | ||
| REQUISITION_SOURCE_TYPE_CODE | VARCHAR2 | 120 | 50 | Passed to Purchase Req - valid values are INVENTORY or VENDOR | |
| DESTINATION_TYPE_CODE | VARCHAR2 | 30 | 100 | Passed to Purchase Req, Transfer - EXPENSE, INVENTORY etc | |
| DESTINATION_SUBINVENTORY_CODE | VARCHAR2 | 40 | Destination Subinventory where goods are excpected | ||
| SHIPPING_METHOD | VARCHAR2 | 120 | 50 | Shipping Method for the Purchasing request | |
| AUTOSOURCE_FLAG | VARCHAR2 | 1 | 4 | Yes | Required flag by the requisition import interface to signal if the supplier and supplier site should be populated based on purchasing sourcing rules. |
| END_INVENTORY_ITEM_ID | NUMBER | 18 | Passed in case of internal purchase requisition. | ||
| END_ITEM_NAME | VARCHAR2 | 300 | The item number of the end item on the Work Order in an OSP process. | ||
| REQUISITION_LINE_ID | VARCHAR2 | 20 | Unique identifier for the requisition line | ||
| PURCHASE_ORDER_HEADER_ID | VARCHAR2 | 120 | Surrogate key for the Purchase Order | ||
| PURCHASE_ORDER_NUMBER | VARCHAR2 | 120 | 20 | Purchase Order Number for this Supply request | |
| PURCHASE_ORDER_LINE_ID | VARCHAR2 | 20 | Surrogate key for the Purchase Order Line | ||
| PURCHASE_ORDER_LINE_NUMBER | VARCHAR2 | 20 | 200 | Purchase Order Line Number for the Supply request | |
| LINE_LOCATION_ID | NUMBER | 18 | Purchase Order Schedule Identifier | ||
| CHANGE_SUPPLY_OPERATION | VARCHAR2 | 30 | Primary Document Supply Operation to be performed for the demand side change | ||
| PRIMARY_DOC_QUANTITY | NUMBER | Primary Document Quantity used for Change management | |||
| PRIMARY_DOC_QUANTITY_UOM | VARCHAR2 | 3 | Primary Document Quantity Unit of measure | ||
| CONTRACT_MFG_ITEM_REVISION | VARCHAR2 | 72 | To capture the Contract Manufacturing Item Revision on which a Purchase Order needs to placed on a Contract Manufacturer. | ||
| CONTRACT_MFG_ITEM_ID | NUMBER | 18 | Used to identify the Contract manufacturing item | ||
| 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. | ||
| 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_TIMESTAMP1 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP2 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP3 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP4 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP5 | TIMESTAMP | 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_TIMESTAMP6 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP7 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP8 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP9 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP10 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| DOS_SUPPLY_BUY_ORDER_DTLS_FK1 | Non Unique | FUSION_TS_TX_IDX | TRACKING_LINE_ID |
| DOS_SUPPLY_BUY_ORD_DTLS_U1 | Unique | FUSION_TS_TX_IDX | SUPPLY_BUY_ORD_DTLS_ID |