DW_EB_X_EBS_PROC_W_RQSTN_LINE_COST_F
DW_EB_X_EBS_PROC_W_RQSTN_LINE_COST_F fact table is used to capture all the purchase requisition costs that are distributed to the various departments of a business organization -- these would in turn be acted upon by the purchasing unit of the business organization (purchasing organization). The types of purchase requisitions can be many and would typically include one-time, regular, online etc. The data in this table is stored at the purchase requisition product line item level. Purchase requisitions are usually used to source "INDIRECT" items -- items that do not form part of the Bill of Materials against sold products but are more used to conduct the operations of the business organization (stationery, cleaning supplies etc.).
Details
Module: Procurement (EBS_PROC)
Business Name: Requisition Lines 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_SOURCE_ID | VARCHAR2 | 80 CHAR | ||||
| APPROVAL_STATUS_WID | NUMBER | 38 | This indicates the current approval status of the purchase requisition line item. This could change during the lifecycle of the purchase requisition. The link to the DW_EB_X_EBS_COMMON_W_STATUS_D dimension. Lookup: DW_EB_X_EBS_COMMON_W_STATUS_D WHERE STATUS_TYPE = "PURCH_APPROVE". Example: "Pending Approval","Rejected","Approved", etc. | DW_EB_X_EBS_COMMON_W_STATUS_D | ||
| APPROVED_ON_DT | TIMESTAMP | 6 | ||||
| APPROVED_ON_DT_WID | NUMBER | 38 | The date on which the purchase requisition was authorized for further processing in the fulfillment cycle. This could be the same as the creation date of the purchase requisition in online approval business situations. Lookup: W_DATE_D | DW_EB_X_EBS_COMMON_W_DAY_D | ||
| APPROVED_ON_TM_WID | NUMBER | 38 | The time on which the purchase requisition was authorized for further processing in the fulfillment cycle. This could be the same as the creation date of the purchase requisition in online approval business situations. Lookup: W_TIME_OF_DAY_D | W_TIME_OF_DAY_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 | ||||
| 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_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_EMPLOYEE_D | |||
| 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. | |||
| 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 W_COST_CNTR_D dimension. Lookup: W_COST_CNTR_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. | |||
| CREATED_ON_TM_WID | NUMBER | 38 | This is the time in "24HHMMSS", on which the record was created in the source system. This column also functions as a key to W_TIME_OF_DAY_D. | W_TIME_OF_DAY_D | ||
| CTRL_AREA_ORG_WID | NUMBER | 38 | The 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 | ||
| CYCLE_STATUS_WID | NUMBER | 38 | This indicates the current cycle status of the purchase requisition line item. This could change during the lifecycle of the purchase requisition. The link to the DW_EB_X_EBS_COMMON_W_STATUS_D dimension. Lookup: DW_EB_X_EBS_COMMON_W_STATUS_D WHERE STATUS_TYPE = "PURCH_CYCLE" Example: "Open", "Closed", "Cancelled", etc. | DW_EB_X_EBS_COMMON_W_STATUS_D | ||
| 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. | |||
| DEST_TYPE_WID | NUMBER | 38 | ||||
| DIST_PERCENTAGE | NUMBER | 28,10 | The percentage that was distributed or assigned to this cost center. 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 | 38,10 | The quantity that was distributed or assigned to this cost center. The total quantity distributed for all cost centers equals the total quantity requested. | |||
| 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. | |||
| DUE_ON_DT_WID | NUMBER | 38 | The date on which the product ordered on the purchase requisition 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. | |||
| EXTERNALLY_MANAGED_FLG | VARCHAR2 | 1 CHAR | ||||
| FULFILLED_ON_DT_WID | NUMBER | 38 | The date on which the product requested on the purchase requisition line was received at the receipt location specified. In situations of multiple receipts, his column would be left blank. Lookup: W_DATE_D | DW_EB_X_EBS_COMMON_W_DAY_D | ||
| 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 | DW_EB_X_EBS_COMMON_W_GL_ACCOUNT_D | ||
| GL_MCAL_CAL_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_MCAL_CAL_D | |||
| HEADER_APPROVAL_STATUS_ID | VARCHAR2 | 80 CHAR | ||||
| HEADER_APPROVED_ON_DT | TIMESTAMP | 6 | ||||
| HEADER_SUBMITTED_ON_DT | TIMESTAMP | 6 | ||||
| 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 requisition item will be received. Lookup: DW_EB_X_EBS_COMMON_W_INVENTORY_PRODUCT_D | DW_EB_X_EBS_COMMON_W_INVENTORY_PRODUCT_D | ||
| ITEM_SOURCE_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_XACT_TYPE_D | |||
| JUSTIFICATION | VARCHAR2 | 1000 CHAR | ||||
| LEDGER_WID | NUMBER | 38 | Ledger Foreign Key | DW_EB_X_EBS_COMMON_W_LEDGER_D | ||
| LINE_AMT | NUMBER | 38,10 | The suggested currency value of the purchase requisition line item 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 | 38,10 | This is the exchange rate from Document Currency to the Local Currency. | |||
| MCAL_REQ_APPROVED_ON_DT_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_MCAL_DAY_D | |||
| NEEDED_BY_DT_WID | NUMBER | 38 | The date by which the product requested on the purchase requisition line is required for actual use at the receipt location specified. Lookup: W_DATE_D | DW_EB_X_EBS_COMMON_W_DAY_D | ||
| NEEDED_BY_TM_WID | NUMBER | 38 | The time by which the product requested on the purchase requisition line is required for actual use at the receipt location specified. Lookup: W_TIME_OF_DAY_D | W_TIME_OF_DAY_D | ||
| OPERATING_UNIT_ORG_WID | NUMBER | 38 | Identifies the operating unit organization. | DW_EB_X_EBS_COMMON_W_INT_ORG_D | ||
| ORDERED_ON_DT_WID | NUMBER | 38 | The date on which the purchase order was placed against this purchase requisition line item. In situations of partial fulfillment where the purchase requisition line item may be fulfilled across multiple purchase orders, this column would be left blank. Lookup: W_DATE_D | DW_EB_X_EBS_COMMON_W_DAY_D | ||
| PLANT_LOC_WID | NUMBER | 38 | This indicates the physical location whose operations use the product ordered on the purchase requisition 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 | ||
| PO_ACKNOWLEDGED_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 | |||
| PRC_BU_WID | NUMBER | 38 | ||||
| PREPARER_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_EMPLOYEE_D | |||
| PRIMARY_UOM_CODE | VARCHAR2 | 50 CHAR | This indicates primary Unit of Measure code. | |||
| PRIMARY_UOM_CONV_RATE | NUMBER | This indicates primary Unit of Measure conversion rate. | ||||
| PRODUCT_WID | NUMBER | 38 | This indicates the product which is being requested on the purchase order requisition item. Lookup: DW_EB_X_EBS_COMMON_W_PRODUCT_D Example :Spray paint, auto exhaust pump, IBM laptop T-Series 230, A4 printer paper etc. | DW_EB_X_EBS_COMMON_W_PRODUCT_D | ||
| PROFIT_CENTER_WID | NUMBER | 38 | This indicates the profit center to which the purchase requisition 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 | ||
| 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 | ||
| PURCH_RQDISTR_NUM | VARCHAR2 | 30 CHAR | The number that identifies a cost distribution within a Purchase Requisition | |||
| 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 requisition 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 | 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. | |||
| RCPT_LOC_WID | NUMBER | 38 | This indicates the physical location whose inventory/operations receives the product requested on the purchase requisition line item. In certain situations the item requested may be directly consumed by the requesting department (without any inventory implications). 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 | ||
| REQUESTOR_WID | NUMBER | 38 | This indicates the requestor who raised the purchase requisition. The link to the DW_EB_X_EBS_COMMON_W_USER_D dimension. Lookup: DW_EB_X_EBS_COMMON_W_USER_D | DW_EB_X_EBS_COMMON_W_EMPLOYEE_D | ||
| RESUBMITTED_ON_DT_WID | NUMBER | 38 | The date on which the requesting organization/department sent the updated purchase request with the purchasing organization for the required products (required when certain aspects of the purchase requisition undergo corrections) Lookup: W_DATE_D | DW_EB_X_EBS_COMMON_W_DAY_D | ||
| RESUBMITTED_ON_TM_WID | NUMBER | 38 | The time on which the requesting organization/department sent the updated purchase request with the purchasing organization for the required products (required when certain aspects of the purchase requisition undergo corrections) Lookup: W_TIME_OF_DAY_D | W_TIME_OF_DAY_D | ||
| RQSTN_ORG_WID | NUMBER | 38 | This indicates the requesting organization that has created the purchase requisition -- usually represents any operations 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 Operations | DW_EB_X_EBS_COMMON_W_INT_ORG_D | ||
| STANDARD_UOM_CODE | VARCHAR2 | 50 CHAR | This indicates standard Unit of Measure code. | |||
| STANDARD_UOM_CONV_RATE | NUMBER | This indicates standard Unit of Measure conversion rate | ||||
| STD_COST_AMT | NUMBER | 38,10 | The estimated total cost of all items in a purchase order line. This cost is derived by multiplying the unit standard cost and quantity of all items ordered. This cost is specified in local reporting currency. | |||
| 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 requisition 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 | ||
| SUBMITTED_ON_DT | TIMESTAMP | 6 | ||||
| SUBMITTED_ON_DT_WID | NUMBER | 38 | The date on which the requesting organization/department placed the purchase request with the purchasing organization for the required products Lookup: W_DATE_D | DW_EB_X_EBS_COMMON_W_DAY_D | ||
| SUBMITTED_ON_TM_WID | NUMBER | 38 | The time on which the requesting organization/department placed the purchase request with the purchasing organization for the required products Lookup: W_TIME_OF_DAY_D | W_TIME_OF_DAY_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 suggested supplier in the purchase requisition. 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 suggested supplier on whom the purchase order could be placed -- for sourcing the product mentioned in the purchase requisition line item. 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 suggested price per unit product (measured in purchase order UOM) of the purchase requisition 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 requisition item -- this could be different from the inventory unit of measure in which the product is stored at the receipt location. The suggested price on the purchase requisition line is for a unit of the product in this UOM. Example: Each. | |||
| VENDOR_ITEM | VARCHAR2 | 300 CHAR | ||||
| XACT_TYPE_WID | NUMBER | 38 | This indicates the specific type of the purchase requisition. There could be further sub-classifications to these purchase requisition 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_CAT_CODE="PRQH" Example: "ONE TIME", "EXPRESS", "ONLINE", "NORMAL" 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 |