DOS_SUPPLY_TRANSFER_ORDER_DTLS
A supply order tracking line holds different types supply requests. There are some attributes that are specific to the type of supply that is being created by the line. These additional supply specific attributes are stored in their respective child entities for clarity and maintenance. These entities will store the additional supply specific attribute values in relation to the supply tracking line. Supply transfer order detail will store the attributes that are specific to a TRANSFER supply request
Details
-
Schema: FUSION
-
Object owner: DOS
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
DOS_SUPPLY_XFER_ORDER_DTL_PK |
SUPPLY_TRANSFER_DETAILS_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| SUPPLY_TRANSFER_DETAILS_ID | NUMBER | 18 | Yes | Supply Transfer Order Detail Identifier | |
| 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_DESTN_LOCTR_CODE | VARCHAR2 | 40 | Destination Locator Code where goods are to be delivered | ||
| 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. | ||
| DOO_SHIPMENT_FLAG | VARCHAR2 | 1 | This column identifies if the transfer shipment needs to be 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. | ||
| TRACKING_LINE_ID | NUMBER | 18 | Yes | Supply Tracking Line Identifier | |
| PREPARER_ID | NUMBER | 18 | A transfer from an inventory location to expense destination is a self service user (Procurement Requester) placing a request for paper or other item that would be delivered to their desk or other non-inventory destination. Preparer User Id. Passed to Internal Requisition, Transfer Order and Purchase Requisition. Request Creator. Requestor User Identification | ||
| END_INVENTORY_ITEM_ID | NUMBER | 18 | End Item Id. Passed in case of Internal Purchase Requisition | ||
| END_ITEM_NAME | VARCHAR2 | 300 | End Inventory Item Name for item being transferred | ||
| GROUP_CODE | VARCHAR2 | 120 | Stores the column name which will participate in grouping. Required for Grouping. | ||
| DELIVER_TO_REQUESTOR_ID | NUMBER | 18 | Deliver to requestor id, Employee's HR User-Id. Transfer Order | ||
| EXEC_SYSTEM_DELVR_TO_LOC_NAME | VARCHAR2 | 240 | Deliver to Location Name. New or Reschedule IR/ISO/TO | ||
| EXEC_SYSTEM_DELIVER_TO_SUBINV | VARCHAR2 | 40 | Destination sub-inventory. Only for INV | ||
| DESTINATION_TYPE_CODE | VARCHAR2 | 30 | Destination Type. Expense or inventory or Dropship | ||
| 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_HEADER_NUMBER | VARCHAR2 | 120 | Sales Order Header Number in the source system. For reschedule of IR/ISO. | ||
| SALES_ORDER_LINE_ID | NUMBER | 18 | Sales Order Line Id 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. | ||
| 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_HEADER_NUMBER | VARCHAR2 | 120 | Transfer Order Header Number. For reschedule of Transfer Order. | ||
| TRANSFER_ORDER_LINE_ID | VARCHAR2 | 20 | Transfer Order Line Id. For reschedule of Transfer Order. | ||
| TRANSFER_ORDER_LINE_NUMBER | VARCHAR2 | 20 | Transfer Order Line Number. For reschedule of Transfer Order. | ||
| SCHEDULED_SHIP_DATE | TIMESTAMP | The current date the shipment is planned to ship on. | |||
| REQUESTED_SHIP_DATE | TIMESTAMP | Requested Ship Date for Transfer Order | |||
| SHIPPING_METHOD | VARCHAR2 | 120 | Shipping Method, passed to purchase requisition document. : Even though internal material transfers occur internally, organization might outsource the shipping activities. These outsourcing activities may involve carriers, shipping terms, freight terms and temporary ownership transfer, to name a few. o Shipment Method o Carrier o Freight Terms(Needs to be on transfer document and not on requisition) | ||
| 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. | ||
| CARRIER_ID | NUMBER | 18 | Reference to unique identification for carrier used on the line. | ||
| AGREEMENT_ID | NUMBER | 18 | Agreement used for transfer price calculation. Derived by invoking SFO service FOS Primary Trade Relationship ID returned by the service | ||
| UNIT_PRICE | NUMBER | Unit Transfer Price. It is the transfer price from the perspective of destination (receiving) organization. | |||
| UNIT_PRICE_CURRENCY_CODE | VARCHAR2 | 15 | Unit Price Currency Code for the Transfer | ||
| TRANSFER_PRICE | NUMBER | Transfer Price. Derived by invoking SFO service Unit Price returned by the service is the transfer price. Transfer Price is defaulted from the transfer price list, can be taken from costing, or is a calculated transfer price that might include other charges (such as freight) in the price. Is this Transfer price per unit OR Total Transfer Amount. | |||
| TRANSFER_PRICE_CURRENCY_CODE | VARCHAR2 | 15 | Currency Code for Transfer Price. FDD Open issue. | ||
| FIRM_DEMAND_FLAG | VARCHAR2 | 1 | Firm Transfer Flag or Firm Demand Flag. Passed by planning for new or reschedule Transfer Order, IR/ISO. | ||
| 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 under which this Transfer is recorded | |||
| LOAD_TYPE | VARCHAR2 | 30 | Indicates whether current interface record is planned order or job update recommendation. Must assign one of these values or error occurs. 1 Create standard Discrete job 3 Update standard or non-standard Discrete job 4 Create non-standard Discrete Job | ||
| SOURCE_SUBINVENTORY_CODE | VARCHAR2 | 40 | Source Subinventory from where item needs to be transferred | ||
| DESTINATION_SUBINVENTORY_CODE | VARCHAR2 | 40 | Reference to Destination Sub Inventory Code | ||
| EXEC_SYSTEM_SOURCE_LOCTR_CODE | VARCHAR2 | 40 | Source Locator from where item needs to be transferred | ||
| SOURCE_ORGANIZATION_ID | NUMBER | 18 | Execution System Source Organization Identifier | ||
| EXEC_SYSTEM_SOURCE_ORG_CODE | VARCHAR2 | 72 | Execution System Source Organization Code | ||
| SOURCE_BU_ID | NUMBER | 18 | Execution System Source Business Unit Identifier | ||
| SOURCE_LOCATION_ID | NUMBER | 18 | Source Location Identifier from where item needs to be transferred | ||
| DESTINATION_LOCATION_ID | NUMBER | 18 | Destination Location Identifier where item needs to be transferred | ||
| PRIMARY_DOC_QUANTITY | NUMBER | Primary Document Quantity used during Change Management | |||
| PRIMARY_DOC_QUANTITY_UOM | VARCHAR2 | 3 | Primary Doc Quantity UOM used during Change Management | ||
| CHANGE_SUPPLY_OPERATION | VARCHAR2 | 30 | Primary Document Supply Operation to be performed for the demand side change. | ||
| NEED_BY_DATE | TIMESTAMP | Date when item is expected at destination location | |||
| BUDGET_CONTROL_ENABLED_FLAG | VARCHAR2 | 1 | Flag to indicate that line is under budgetary control. | ||
| REPRICE_FLAG | VARCHAR2 | 1 | Flag to indicate if transfer supply request can be repriced by calling Supply Chain Financial Orchestration | ||
| ALLOW_ITEM_SUBSTITUTION_FLAG | VARCHAR2 | 1 | Indicates whether shipping substitute items is allowed. | ||
| 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. | |
| 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 | ||
| 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. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| DOS_SUPPLY_TNSFR_ORDER_DTLS_U1 | Unique | FUSION_TS_TX_IDX | SUPPLY_TRANSFER_DETAILS_ID |
| DOS_SUPPLY_TNSFR_ORD_DTLS_FK1 | Non Unique | FUSION_TS_TX_IDX | TRACKING_LINE_ID |