DW_EB_X_EBS_PROC_W_PURCH_COST_F
The DW_EB_X_EBS_PROC_W_PURCH_COST_F fact table is used to capture all the purchase costs related information that are distributed on the basis of amount or value by the purchasing unit of a business organization (purchasing organization). There could be many types of purchase orders and would typically include one-time, regular, blanket, release, and so on. The data in this table is stored at the purchase order distribution level. Purchase orders, or the shipments, are distributed among different receivers, accounts, or cost centers.Bug 21293960 2015-06-30JYORAOModify VENDOR_PRODUCT_NUM column length from VARCHAR2(30 CHAR) to VARCHAR2(80 CHAR)
Details
Module: Procurement (EBS_PROC)
Business Name: Purchase Cost
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. | |||
| AGREEMENT_LEVERAGE_TYPE_WID | NUMBER | 38 | Foreign key to DW_EB_X_EBS_COMMON_W_XACT_TYPE_D dimension indicating agreement leverage type. | DW_EB_X_EBS_COMMON_W_XACT_TYPE_D | ||
| AUTO_CUSTOM_CATEGORY1_WID | NUMBER | 38 | Auto Classified Custom Category 1 | DW_EB_X_EBS_COMMON_W_PROD_CAT_DH | ||
| AUTO_CUSTOM_CATEGORY2_WID | NUMBER | 38 | Auto Classified Custom Category 2 | DW_EB_X_EBS_COMMON_W_PROD_CAT_DH | ||
| AUTO_CUSTOM_CATEGORY3_WID | NUMBER | 38 | Auto Classified Custom Category 3 | DW_EB_X_EBS_COMMON_W_PROD_CAT_DH | ||
| AUTO_PURCHASING_CATEGORY_WID | NUMBER | 38 | Auto Classified Purchasing Category | DW_EB_X_EBS_COMMON_W_PROD_CAT_DH | ||
| AUTO_UNSPSC_WID | NUMBER | 38 | Auto Classified UNSPSC | DW_EB_X_EBS_COMMON_W_PROD_CAT_DH | ||
| 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. | |||
| BALANCING_SEGMENT_WID | NUMBER | 38 | ||||
| BLANKET_AGREEMENT_NUM | VARCHAR2 | 50 CHAR | Blanket agreement number of a release or the global agreement number the order references. | |||
| BUSN_AREA_ORG_WID | NUMBER | 38 | This indicates the organizational entity based on line-of-business for which accounting profit or loss is reported externally. The link to the BUSN_AREA 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 = 'BUSN_AREA') Example: North Americas Procurement | DW_EB_X_EBS_COMMON_W_INT_ORG_D | ||
| 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' | |||
| 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 Organization) 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 DW_EB_X_EBS_COMMON_W_XACT_TYPE_D dimension indicating whether it is a regular PO, consigned PO, or consumption advice. | DW_EB_X_EBS_COMMON_W_XACT_TYPE_D | ||
| CONTRACT_REF_NUM | VARCHAR2 | 50 CHAR | This indicates the contract reference number if the purchase order is based on a contract agreement. | |||
| COST_CENTER_WID | NUMBER | 38 | This indicates the cost center to which the expenses incurred in sourcing would be distributed to. The link to the DW_EB_X_EBS_COMMON_W_COST_CENTER_D dimension. Lookup: DW_EB_X_EBS_COMMON_W_COST_CENTER_D Example: Generator 1 shop, Generator 2 shop etc. | DW_EB_X_EBS_COMMON_W_COST_CENTER_D | ||
| 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. | |||
| CTRL_AREA_ORG_WID | NUMBER | 38 | This indicates the organizational entity for internal management and reporting purposes. The link to the .CTRL_AREA_ORG. 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 = 'CTRL_AREA_ORG') Example: North Americas Procurement | DW_EB_X_EBS_COMMON_W_INT_ORG_D | ||
| CUSTOM_CATEGORY1_WID | NUMBER | 38 | Custom Category 1 | DW_EB_X_EBS_COMMON_W_PROD_CAT_DH | ||
| CUSTOM_CATEGORY2_WID | NUMBER | 38 | Custom Category 2 | DW_EB_X_EBS_COMMON_W_PROD_CAT_DH | ||
| CUSTOM_CATEGORY3_WID | NUMBER | 38 | Custom Category 3 | DW_EB_X_EBS_COMMON_W_PROD_CAT_DH | ||
| 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 | ||||
| DIST_PERCENTAGE | NUMBER | 28,10 | The percentage that was distributed or assigned to this cost center on the basis of amount or value. The total of percentages allocated to all cost centers must equal 100. A manufacturing company, for example, can set up a distribution percentage for each of its cost centers. | |||
| DIST_QTY | NUMBER | 28,10 | The quantity that was distributed or assigned to this cost center. The total quantity distributed for all cost centers equals the total quantity ordered in the schedule line | |||
| 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 | ||
| 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. | |||
| 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_ACCOUNT_WID | NUMBER | 38 | This is the General Ledger account number into which the payables entries generated as part of the purchase order execution would be posted into. This may be uniquely associated to the supplier on the purchase order. Lookup: DW_EB_X_EBS_COMMON_W_GL_ACCOUNT_D | |||
| 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 receipt location -- product combination against which the purchase order item has been received. Lookup: DW_EB_X_EBS_COMMON_W_INVENTORY_PRODUCT_D | DW_EB_X_EBS_COMMON_W_INVENTORY_PRODUCT_D | ||
| INVOICE_AMT | NUMBER | 38,10 | ||||
| INVOICE_QTY | NUMBER | 28,10 | ||||
| LAST_ACCEPT_SHIP_DT_WID | NUMBER | 38 | ||||
| LEDGER_WID | NUMBER | 38 | Foreign key to DW_EB_X_EBS_COMMON_W_LEDGER_D dimension | DW_EB_X_EBS_COMMON_W_LEDGER_D | ||
| LINE_AMT | NUMBER | 38,10 | The currency value of the purchase order cost distribution in document or transaction currency | |||
| LINE_NUM_DISPLAY | VARCHAR2 | 240 CHAR | ||||
| LINE_TEXT | VARCHAR2 | 255 CHAR | Detailed instructions text or remarks for execution of the purchase order 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 | 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_HEADER_ID | VARCHAR2 | 80 CHAR | ||||
| NEG_LINE_NUM | VARCHAR2 | 80 CHAR | ||||
| 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 purchasing document was created. | DW_EB_X_EBS_COMMON_W_DAY_D | ||
| 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 line 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 | ||
| POTENTIAL_AGREEMENT_LINE_ID | VARCHAR2 | 80 CHAR | If the order could have leveraged some agreement, this is the Line ID of the potential agreement which has the lowest price | |||
| POTENTIAL_AGREEMENT_NUM | VARCHAR2 | 50 CHAR | If the order could have leveraged some agreement, this is the potential agreement which has the lowest price. | |||
| POTENTIAL_AGREEMENT_PRICE | NUMBER | 28,10 | The lowest price of the potential agreement. | |||
| 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 | ||||
| PO_STATUS_WID | NUMBER | 38 | ||||
| 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 receipt line item. 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 | ||
| PROFIT_CENTER_WID | NUMBER | 38 | This indicates the profit center to which the purchase cost that is distributed is booked into . This helps accumulate revenues against profit centers as part of inventory transactions. Lookup: W_PROFIT_CNTR_D | DW_EB_X_EBS_COMMON_W_PROFIT_CENTER_D | ||
| PROGRESS_PAYMENT_RATE | NUMBER | Percentage applied to the completed work on a financing pay item to determine the amount eligible for payment. | ||||
| PROJECT_WID | NUMBER | 38 | Foreign key to W_PROJECT _D indicating the project identifier for oracle projects. | DW_EB_X_EBS_COMMON_W_PROJECT_D | ||
| PROMISED_SHIP_DT_WID | NUMBER | 38 | ||||
| PURCH_DISTR_NUM | VARCHAR2 | 30 CHAR | The number that identifies a cost distribution within a Purchase Order Schedule line. | |||
| PURCH_ORDER_ITEM | NUMBER | 15 | The number that uniquely identifies an item within a purchasing document such as Purchase Order, Request for Quotation, Scheduling Agreements etc. The same product may appear on multiple lines in the document. | |||
| PURCH_ORDER_NUM | VARCHAR2 | 300 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_RQSTN_ITEM | VARCHAR2 | 30 CHAR | The purchase requisition line number against which the purchase cost distribution 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 | The purchase requisition number against which the purchase cost distribution has been created. If these are multiple, this column would be either left blank or filled with the representative purchase requisition number. | |||
| PURCH_SCHEDULE_INTG_ID | VARCHAR2 | 80 CHAR | This is the Purchase Order Schedule Line Key Id | |||
| PURCH_SCHEDULE_NUM | VARCHAR2 | 30 CHAR | This indicates the purchase schedule number. | |||
| 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 ordered on the purchase order line item. The link to the STORAGE_LOC type of rows within W_BUSN_LOC_D dimension table. Lookup: W_BUSN_LOC_D | DW_EB_X_EBS_COMMON_W_BUSN_LOCATION_D | ||
| RECEIVED_AMT | NUMBER | 38,10 | ||||
| RECEIVED_QTY | NUMBER | 28,10 | ||||
| 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. | ||||
| 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 | |||
| REQ_BU_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_INT_ORG_D | |||
| REQ_DISTR_INTG_ID | VARCHAR2 | 80 CHAR | This is the Purchase Requisition Distribution Key Id | |||
| 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 | |||
| 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 | ||
| SHIP_TO_OPERATING_UNIT_WID | NUMBER | 38 | Foreign key to DW_EB_X_EBS_COMMON_W_INT_ORG_D indicating operating unit. | DW_EB_X_EBS_COMMON_W_INT_ORG_D | ||
| SHIP_TO_ORGANIZATION_WID | NUMBER | 38 | Foreign key to DW_EB_X_EBS_COMMON_W_INT_ORG_D indicating ship to organization unique identifier. | DW_EB_X_EBS_COMMON_W_INT_ORG_D | ||
| SOLDTO_LE_WID | NUMBER | 38 | ||||
| SOLD_TO_BU_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_INT_ORG_D | |||
| 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 | Number of the storage location at which the material is stored or received. A plant may contain one or more storage locations. This indicates the physical location whose inventory receives the product ordered on the purchase order line item. The link to the STORAGE_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 | ||
| SUPPLIER_ACCOUNT_WID | NUMBER | 38 | Foreign key to DW_EB_X_EBS_COMMON_W_SUPPLIER_ACCOUNT_D indicating supplier site unique identifier. | 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 | ||
| TASK_WID | NUMBER | 38 | Foreign key to W_TASK _D indicating the task identifier for oracle projects. | DW_EB_X_EBS_COMMON_W_TASK_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 price per unit product (measured in purchase order UOM) of the purchase order line item -- in document or transactional currency. | |||
| UNIT_STD_COST | NUMBER | 38,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. | |||
| UNSPSC_WID | NUMBER | 38 | Foreign Key to the UNSPSC (United Nations Standard Products and Services Code) Category. | DW_EB_X_EBS_COMMON_W_PROD_CAT_DH | ||
| UOM_CODE | VARCHAR2 | 50 CHAR | The unit of measure of the purchase order distribution . 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 line is for a unit of the product in this UOM. Example: Each. | |||
| VENDOR_PRODUCT_NUM | VARCHAR2 | 300 CHAR | Ledger Foreign Key | |||
| 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 |