DW_EB_X_EBS_PROC_W_PURCH_SCHEDULE_LINE_F
DW_EB_X_EBS_PROC_W_PURCH_SCHEDULE_LINE_F fact table is used to capture all the delivery schedules on purchase orders that are raised on suppliers by the purchasing unit of a business organization (purchasing organization). The types of purchase orders can be many and would typically include one-time, regular, blanket, release etc. The data in this table is stored at the purchase order, product line item and delivery schedule level. The purchase order lines in this table are in turn referenced by fact rows in the DW_EB_X_EBS_PROC_W_PURCH_RCPT_F table. The data in this table is expected to be dynamic in nature during the lifecycle of a specific purchase order and its receipt related cycles. Columns like RECEIVED_QTY represent the current status/information related to a purchase order line item. This table can be configured to help capture similar sourcing process business documents like sub-contract orders. The Integration Id column would need to be configured with additional logic to handle such situations.
Details
Module: Procurement (EBS_PROC)
Business Name: Purchase Schedule Lines
Key Columns
Key column information is not documented in the supplied metadata.
Columns
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table |
|---|---|---|---|---|---|---|
| DATASOURCE_NUM_ID | NUMBER | 10 | This column is the unique identifier of the source system from which data was extracted. In order to be able to trace the data back to its source, Siebel recommends that you define separate unique source IDs for each of your different source instances. | |||
| INTEGRATION_ID | VARCHAR2 | 80 CHAR | This column is the unique identifier of a dimension or fact entity in its source system. In case of composite keys, the value in this column can consist of concatenated parts. | |||
| ACCEPTED_AMT | NUMBER | 38,10 | The currency value of the accepted purchase order schedule line in document or transaction currency. | |||
| ACCEPTED_QTY | NUMBER | 28,10 | The quantity of the product (purchase order UOM) that has passed acceptance tests. The accepted quantity could be less than or equal to the received quantity. | |||
| AUX1_CHANGED_ON_DT | TIMESTAMP | 6 | Siebel System field. This column identifies the last modified date and time of the auxiliary table's record which acts as a source for the current table. | |||
| AUX2_CHANGED_ON_DT | TIMESTAMP | 6 | Siebel System field. This column identifies the last modified date and time of the auxiliary table's record which acts as a source for the current table. | |||
| AUX3_CHANGED_ON_DT | TIMESTAMP | 6 | Siebel System field. This column identifies the last modified date and time of the auxiliary table's record which acts as a source for the current table. | |||
| AUX4_CHANGED_ON_DT | TIMESTAMP | 6 | Siebel System field. This column identifies the last modified date and time of the auxiliary table's record which acts as a source for the current table. | |||
| BLANKET_AGREEMENT_NUM | VARCHAR2 | 50 CHAR | Blanket agreement number of a release or the global agreement number the order references. | |||
| BLANKET_HEADER_ID | VARCHAR2 | 80 CHAR | ||||
| BLANKET_LINE_ID | VARCHAR2 | 80 CHAR | ||||
| BUYER_MNGD_TRANS_FLG | VARCHAR2 | 1 CHAR | ||||
| BUYER_WID | NUMBER | 38 | This indicates the buyer who placed the purchase order/helped prepare it. The link to the DW_EB_X_EBS_COMMON_W_EMPLOYEE_D dimension. Lookup: DW_EB_X_EBS_COMMON_W_EMPLOYEE_D WHERE BUSN_CONTCT_TYPE = "BUYER" | DW_EB_X_EBS_COMMON_W_EMPLOYEE_D | ||
| CANCELLED_AMT | NUMBER | 38,10 | The currency value of the cancelled purchase order schedule line in document or transaction currency. | |||
| CANCELLED_QTY | NUMBER | 28,10 | The quantity of the product (in purchase order UOM) that has been cancelled on the purchase order schedule line. | |||
| CANCEL_REASON | VARCHAR2 | 240 CHAR | ||||
| CHANGED_BY_WID | NUMBER | 38 | This is a foreign key to the DW_EB_X_EBS_COMMON_W_USER_D dimension indicating the user who last modified the record in the source system. | DW_EB_X_EBS_COMMON_W_USER_D | ||
| CHANGED_ON_DT | TIMESTAMP | 6 | Identifies the date and time when the record was last modified in the source system. | |||
| CLOSED_REASON | VARCHAR2 | 240 CHAR | ||||
| COMPANY_ORG_WID | NUMBER | 38 | This is the default financial entity (or Company Org) into which the accounting transactions generated through the execution of the purchases order are posted into. This links to the "COMPANY" type rows within DW_EB_X_EBS_COMMON_W_INT_ORG_D dimension table. Lookup: DW_EB_X_EBS_COMMON_W_INT_ORG_D (BUSN_ORG_TYPE = "COMPANY") | DW_EB_X_EBS_COMMON_W_INT_ORG_D | ||
| CONSIGNED_TYPE_WID | NUMBER | 38 | Foreign key to the DW_EB_X_EBS_COMMON_W_XACT_TYPE_D dimension indicating whether it's a regular PO, consigned PO or consumption advice. | DW_EB_X_EBS_COMMON_W_XACT_TYPE_D | ||
| CONTRACT_ID | VARCHAR2 | 80 CHAR | ||||
| CONTRACT_REF_NUM | VARCHAR2 | 50 CHAR | This indicates the contract reference number if the purchase order is based on a contract agreement. | |||
| CREATED_BY_WID | NUMBER | 38 | This is a foreign key to the DW_EB_X_EBS_COMMON_W_USER_D dimension indicating the user who created the record in the source system. | DW_EB_X_EBS_COMMON_W_USER_D | ||
| CREATED_ON_DT | TIMESTAMP | 6 | Identifies the date and time when the record was initially created in the source system. | |||
| CREATED_ON_TM_WID | NUMBER | 38 | This is the time on which the record was created in the source system | W_TIME_OF_DAY_D | ||
| CURRENT_PRICE_GLB1_CURR | NUMBER | 28,10 | CURRENT_PRICE_GLB1_CURR | |||
| DELETE_FLG | VARCHAR2 | 1 CHAR | This flag indicates the deletion status of the record in the source system. A value of "Y" indicates that the record is deleted from the source system and logically deleted from the data warehouse; a value of "N" indicates that the record is active. | |||
| DESCRIPTION | VARCHAR2 | 255 CHAR | Pay item description. | |||
| DEST_TYPE_WID | NUMBER | 38 | ||||
| DOCUMENT_DISP_LINE_NUM | VARCHAR2 | 80 CHAR | DOCUMENT_DISP_LINE_NUM | |||
| DOC_CURR_CODE | VARCHAR2 | 30 CHAR | This code corresponds to the document currency. This typically is the currency in which the transaction occurred. Amounts will be stored in this currency. | |||
| DOC_STYLE_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_XACT_TYPE_D | |||
| DUE_ON_DT_WID | NUMBER | 38 | The date on which the product ordered on the purchase order schedule line is due for receipt at the receipt location specified. Lookup: W_DATE_D | DW_EB_X_EBS_COMMON_W_DAY_D | ||
| DUE_ON_TM_WID | NUMBER | 38 | The time on which the product ordered on the purchase order schedule line is due for receipt at the receipt location specified. Lookup: W_DATE_D | W_TIME_OF_DAY_D | ||
| ETL_PROC_WID | NUMBER | 38 | Siebel System Field. This column is the unique identifier for the specific ETL process used to create or update this data. | |||
| FINANCED_AMT | NUMBER | 38,10 | For advance or financing distributions, the amount which has been pre-paid. | |||
| FINANCED_QTY | NUMBER | 28,10 | For advance or financing distributions, the quantity which has been pre-paid. | |||
| FIRM_SCHEDULE_IND | VARCHAR2 | 1 CHAR | Indicates if this receipt schedule has been confirmed by the supplier. Indicates the category of delivery, whether confirmed or not. | |||
| FULFILLED_ON_DT | TIMESTAMP | 6 | ||||
| GLOBAL1_EXCHANGE_RATE | NUMBER | This is the exchange rate from Document Currency to the first Global Currency. The Global currencies are defined in global currency master table. | ||||
| GLOBAL2_EXCHANGE_RATE | NUMBER | This is the exchange rate from Document Currency to the second Global Currency. The Global currencies are defined in global currency master table. | ||||
| GLOBAL3_EXCHANGE_RATE | NUMBER | This is the exchange rate from Document Currency to the third Global Currency. The Global currencies are defined in global currency master table. | ||||
| GL_MCAL_CAL_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_MCAL_CAL_D | |||
| INVENTORY_ORG_WID | NUMBER | 38 | Identifies the inventory organization. | DW_EB_X_EBS_COMMON_W_INT_ORG_D | ||
| INVENTORY_PROD_WID | NUMBER | 38 | This indicates the business location -- product combination against which the purchase order item will be received. Lookup: DW_EB_X_EBS_COMMON_W_INVENTORY_PRODUCT_D Example:Inventories may be managed by location. This key will identify the product attributes based on the location. | DW_EB_X_EBS_COMMON_W_INVENTORY_PRODUCT_D | ||
| INVOICE_AMT | NUMBER | 38,10 | ||||
| INVOICE_QTY | NUMBER | 28,10 | INVOICE_QTY | |||
| LAST_ACCEPT_SHIP_DT_WID | NUMBER | 38 | ||||
| LINE_AMT | NUMBER | 38,10 | The currency value of the purchase order schedule line in document or transaction currency. | |||
| LINE_TEXT | VARCHAR2 | 255 CHAR | Detailed instructions text or remarks for fulfillment of the purchase requisition line item. | |||
| LINE_TYPE_WID | NUMBER | 38 | This column is used as a generic field for customer extensions. | DW_EB_X_EBS_COMMON_W_XACT_TYPE_D | ||
| LOC_CURR_CODE | VARCHAR2 | 30 CHAR | This code corresponds to the local currency. The local currency typically is the one in which the transaction will be posted to meet legal requirements for Company's Financial reporting. Alternatively, it may be linked to the currency used by local/regional business units for reporting purposes. | |||
| LOC_EXCHANGE_RATE | NUMBER | This is the exchange rate from Document Currency to the Local Currency. | ||||
| MAX_RETAINAGE_AMT | NUMBER | 38,10 | The maximum amount that can be withheld as retainage against a line. | |||
| MCAL_PO_OPENED_DT_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_MCAL_DAY_D | |||
| NEG_BU_WID | NUMBER | 38 | ||||
| NEG_DOCUMENT_NUM | VARCHAR2 | 255 CHAR | NEG_DOCUMENT_NUM | |||
| NEG_GLOBAL1_EXCHANGE_RATE | NUMBER | NEG_GLOBAL1_EXCHANGE_RATE | ||||
| NEG_GLOBAL2_EXCHANGE_RATE | NUMBER | NEG_GLOBAL2_EXCHANGE_RATE | ||||
| NEG_GLOBAL3_EXCHANGE_RATE | NUMBER | NEG_GLOBAL3_EXCHANGE_RATE | ||||
| NEG_HEADER_ID | VARCHAR2 | 80 CHAR | ||||
| NEG_INTEGRATION_ID | VARCHAR2 | 80 CHAR | ||||
| NEG_LINE_NUM | VARCHAR2 | 80 CHAR | ||||
| NEG_TITLE | VARCHAR2 | 80 CHAR | NEG_TITLE | |||
| NEG_TYPE_WID | NUMBER | 38 | NEG_TYPE_WID | |||
| OPERATING_UNIT_ORG_WID | NUMBER | 38 | Identifies the operating unit organization. | DW_EB_X_EBS_COMMON_W_INT_ORG_D | ||
| ORCHESTRATION_AGREEMENT | VARCHAR2 | 100 CHAR | ||||
| ORCHESTRATION_ORDER_FLAG | VARCHAR2 | 1 CHAR | ||||
| ORDERED_ON_DT_WID | NUMBER | 38 | The date on which the purchase order was placed on the supplier. For electronic transmissions of purchase orders to suppliers, this could be the same as the day the supplier receives the purchase order. Lookup: W_DATE_D | DW_EB_X_EBS_COMMON_W_DAY_D | ||
| ORDERED_ON_TM_WID | NUMBER | 38 | The time on which the purchase order was placed on the supplier | W_TIME_OF_DAY_D | ||
| ORDER_LEAD_TIME | NUMBER | 10 | The time specified in days by the supplier to deliver the product to the purchasing organization (time measured from purchase order date to last receipt date). | |||
| ORDER_UOM_CODE | VARCHAR2 | 50 CHAR | The unit of measure of the purchase order schedule line -- this could be different from the inventory unit of measure in which the product is stored at the receipt location. The price on the purchase order schedule line is for a unit of the product in this UOM. Example: Each. | |||
| ORIG_PROMISED_SHIP_DT_WID | NUMBER | 38 | ||||
| PAYMENT_TYPE_WID | NUMBER | 38 | Foreign key to the DW_EB_X_EBS_COMMON_W_XACT_TYPE_D dimension indicating the pay item payment type. | DW_EB_X_EBS_COMMON_W_XACT_TYPE_D | ||
| PLANT_LOC_WID | NUMBER | 38 | This indicates the physical location whose operations use the product ordered on the purchase order schedule line -- this would usually be the same as the receipt location of the item. The link to the "PLANT" type of rows within W_BUSN_LOC_D dimension table. Lookup: W_BUSN_LOC_D. Example : Carolina plant, Nevada facility etc. | DW_EB_X_EBS_COMMON_W_BUSN_LOCATION_D | ||
| PO_ACKNOWLEDGED_DT | TIMESTAMP | 6 | ||||
| PO_APPROVED_ON_DT | TIMESTAMP | 6 | ||||
| PO_CLOSED_DT | TIMESTAMP | 6 | ||||
| PO_COMMUNICATED_DT | TIMESTAMP | 6 | ||||
| PO_CREATION_METHOD_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_XACT_TYPE_D | |||
| PO_OPENED_DT | TIMESTAMP | 6 | ||||
| PO_OPENED_DT_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_DAY_D | |||
| PO_STATUS_WID | NUMBER | 38 | PO_STATUS_WID | |||
| PO_SUBMIT_ON_DT | TIMESTAMP | 6 | ||||
| PO_TRADING_ORG_WID | NUMBER | 38 | ||||
| PRIMARY_UOM_CODE | VARCHAR2 | 50 CHAR | This indicates primary uom code. | |||
| PRIMARY_UOM_CONV_RATE | NUMBER | This indicates primary uom conversion rate. | ||||
| PROC_PROD_WID | NUMBER | 38 | ||||
| PRODUCT_WID | NUMBER | 38 | This indicates the product which is being sourced from the supplier on the purchase order schedule line. Lookup: DW_EB_X_EBS_COMMON_W_PRODUCT_D Example :Spray paint, auto exhaust pump, IBM laptop T-Series 230 | DW_EB_X_EBS_COMMON_W_PRODUCT_D | ||
| PROGRESS_PAYMENT_RATE | NUMBER | Percentage applied to the completed work on a financing pay item to determine the amount eligible for payment. | ||||
| PROMISED_SHIP_DT_WID | NUMBER | 38 | ||||
| PURCH_GROUP_ORG_WID | NUMBER | 38 | The Purchase Group which is responsible for the purchase. | DW_EB_X_EBS_COMMON_W_INT_ORG_D | ||
| PURCH_ORDER_INTG_ID | VARCHAR2 | 80 CHAR | This is the Purchase Order Line Key Id | |||
| PURCH_ORDER_ITEM | NUMBER | 15 | The line item number within the purchase order -- the same product may appear on multiple lines within the purchase order (this corresponds to situations where multiple schedule lines may be mapped as separate lines on the purchase order). | |||
| PURCH_ORDER_NUM | VARCHAR2 | 30 CHAR | The unique purchase order number that helps identify the purchase order. | |||
| PURCH_ORG_WID | NUMBER | 38 | This indicates the purchasing organization that has generated the purchase order -- usually represents the purchasing unit of a large business organization. The link to the "PURCH" type rows within DW_EB_X_EBS_COMMON_W_INT_ORG_D dimension table. Lookup: DW_EB_X_EBS_COMMON_W_INT_ORG_D (BUSN_ORG_TYPE = "PURCH") Example: North Americas Procurement | DW_EB_X_EBS_COMMON_W_INT_ORG_D | ||
| PURCH_RQLNS_INTG_ID | VARCHAR2 | 80 CHAR | This is the Requisition Line Key Id | |||
| PURCH_RQSTN_ITEM | NUMBER | 15 | The number that uniquely identifies an item on a purchase requisition. The purchase requisition line number against which the purchase order line item has been created. If these are multiple, this column would be either left blank or filled with the representative purchase requisition number. | |||
| PURCH_RQSTN_NUM | VARCHAR2 | 30 CHAR | An alphanumeric key that uniquely identifies a purchase requisition number from which the purchase order has been created. If these are multiple, this column would be either left blank or filled with the representative purchase requisition number. | |||
| PURCH_SCHEDULE_NUM | VARCHAR2 | 30 CHAR | The schedule line number that represents the delivery schedule within a purchase order line item. | |||
| QUOTE_SUBMITTED_DT_WID | NUMBER | 38 | The date on which the vendor or supplier submitted the quotation for products to be supplied on this purchase order. Lookup: W_DATE_D | DW_EB_X_EBS_COMMON_W_DAY_D | ||
| RCPT_LOC_WID | NUMBER | 38 | This indicates the physical location whose inventory receives the product on the purchase receipt line item. The link to the "RECIPIENT_LOC" type of rows within W_BUSN_LOC_D dimension table. Lookup: W_BUSN_LOC_D. Example: Sheet Metal Location, Maintenance Parts location. | DW_EB_X_EBS_COMMON_W_BUSN_LOCATION_D | ||
| RECEIVED_AMT | NUMBER | 38,10 | The currency value of the received purchase order schedule line in document or transaction currency. | |||
| RECEIVED_QTY | NUMBER | 28,10 | The quantity of the product (in purchase order UOM) that has been received todate on the purchase order schedule line. | |||
| RECOUPED_AMT | NUMBER | 38,10 | For advance or financing distributions, the amount of the prepayments which has been liquidated. | |||
| RECOUPED_QTY | NUMBER | 28,10 | For advance or financing distributions, the quantity of the prepayments which has been liquidated. | |||
| RECOUPMENT_RATE | NUMBER | Maximum percentage of the invoice amount against which previous prepayments can be applied. | ||||
| REJECTED_AMT | NUMBER | 38,10 | The currency value of the rejected purchase order schedule line in document or transaction currency. | |||
| REJECTED_QTY | NUMBER | 28,10 | The quantity of the product (purchase order UOM) that has NOT passed acceptance tests. The rejected quantity would be <= received quantity. | |||
| RELEASE_NUM | VARCHAR2 | 30 CHAR | This indicates the release number. | |||
| REQUESTED_SHIP_DT_WID | NUMBER | 38 | ||||
| REQUESTOR_WID | NUMBER | 38 | This indicates the requestor who placed the initial purchase request/helped prepare it. The link to the DW_EB_X_EBS_COMMON_W_EMPLOYEE_D dimension. Lookup: DW_EB_X_EBS_COMMON_W_EMPLOYEE_D WHERE BUSN_CONTCT_TYPE = "REQUESTOR" | DW_EB_X_EBS_COMMON_W_EMPLOYEE_D | ||
| REQ_BU_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_INT_ORG_D | |||
| RESPONSE_NUM | VARCHAR2 | 80 CHAR | ||||
| RETAINAGE_RATE | NUMBER | Maximum percentage that can be withheld from an invoice as retainage. | ||||
| RETAINAGE_RELEASED_AMT | NUMBER | 38,10 | Amount of retainage released for this distribution. | |||
| RETAINAGE_WITHHELD_AMT | NUMBER | 38,10 | Total amount withheld as retainage against this distribution. | |||
| SCHEDULED_QTY | NUMBER | 28,10 | The quantity of the product (in purchase order UOM) that has been scheduled to be received on the purchase order schedule line. | |||
| SCHEDULE_FREQ_IND | VARCHAR2 | 1 CHAR | Indicates the frequency of schedule | |||
| SHIPMENT_DUE_DT | TIMESTAMP | 6 | ||||
| SHIPMENT_DUE_DT_WID | NUMBER | 38 | ||||
| SHIPMENT_TYPE_WID | NUMBER | 38 | Foreign key to the DW_EB_X_EBS_COMMON_W_XACT_TYPE_D dimension indicating the shipment type. | DW_EB_X_EBS_COMMON_W_XACT_TYPE_D | ||
| SHIPPED_AMT | NUMBER | 38,10 | ||||
| SHIPPED_QTY | NUMBER | 28,10 | ||||
| SOLDTO_BU_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_INT_ORG_D | |||
| SOLDTO_LE_WID | NUMBER | 38 | ||||
| STANDARD_UOM_CODE | VARCHAR2 | 50 CHAR | This indicates standard uom code. | |||
| STANDARD_UOM_CONV_RATE | NUMBER | This indicates standard uom conversion rate | ||||
| STD_COST_AMT | NUMBER | 38,10 | Cost Amount. | |||
| STORAGE_LOC_WID | NUMBER | 38 | This indicates the expected storage location under the inventory location which will receive the product ordered on the purchase order schedule line. The link to the "STORAGE_LOC" type of rows within W_BUSN_LOC_D dimension table. Lookup: W_BUSN_LOC_D. Example :Example : Sheet Metal Location, Maintenance Parts location. | DW_EB_X_EBS_COMMON_W_BUSN_LOCATION_D | ||
| SUPPLIER_ACCOUNT_WID | NUMBER | 38 | Foreign key to DW_EB_X_EBS_COMMON_W_SUPPLIER_ACCOUNT_D dimension | DW_EB_X_EBS_COMMON_W_SUPPLIER_ACCOUNT_D | ||
| SUPPLIER_PROD_WID | NUMBER | 38 | This indicates the product reference within the catalog of the supplier on whom the purchase order has been placed. The link to the DW_EB_X_EBS_COMMON_W_SUPPLIER_PRODUCT_D dimension. Lookup: DW_EB_X_EBS_COMMON_W_SUPPLIER_PRODUCT_D | DW_EB_X_EBS_COMMON_W_SUPPLIER_PRODUCT_D | ||
| SUPPLIER_WID | NUMBER | 38 | This indicates the supplier on whom the purchase order has been placed. The link to the W_SUPPLIER_D dimension. Lookup: W_SUPPLIER_D Example : Circuit City, Good Guys etc. for any electronic equipment | DW_EB_X_EBS_COMMON_W_PARTY_ORG_D | ||
| TENANT_ID | VARCHAR2 | 80 CHAR | This column is the unique identifier for a Tenant in a multi-tenant environment. This would typically be used in an Application Service Provider (ASP) / Software As a Service (SOAS) model. | |||
| TO_CUST_LOCATION_WID | NUMBER | 38 | ||||
| TO_CUST_WID | NUMBER | 38 | ||||
| UNIT_PRICE | NUMBER | 28,10 | The net price per unit of the product (measured in purchase order UOM) of the purchase order line item -- in document or transactional currency. The price arrived at after taking all vendor surcharges and discounts into account. | |||
| UNIT_STD_COST | NUMBER | 28,10 | Standard price per unit of the product .The actual purchase price per unit of the product could be at variance with the standard price per unit. | |||
| VENDOR_ITEM | VARCHAR2 | 300 CHAR | ||||
| XACT_TYPE_WID | NUMBER | 38 | This indicates the specific type of the purchase order. There could be further sub-classifications to these purchase order types. There could be domain values mapped for each of these transactions into the W_type domain value columns in DW_EB_X_EBS_COMMON_W_XACT_TYPE_D. Lookup: DW_EB_X_EBS_COMMON_W_XACT_TYPE_D WHERE XACT_CODE = "PURCH_ORDERS" Example: "ONE TIME", "REGULAR", "BLANKET" etc. | DW_EB_X_EBS_COMMON_W_XACT_TYPE_D | ||
| X_CUSTOM | VARCHAR2 | 10 CHAR | This column is used as a generic field for customer extensions. | |||
| W$_INSERT_DT | TIMESTAMP | 6 | ||||
| W$_UPDATE_DT | TIMESTAMP | 6 |