DW_EB_X_EBS_PROC_W_PURCH_RCPT_F
DW_EB_X_EBS_PROC_W_PURCH_RCPT_F fact table is used to capture all the product receipts received from suppliers against purchase orders placed on them by the purchasing unit of a business organization (purchasing organization). The data in this table is stored at the purchase receipt line item level. The purchase receipt lines in this table would have direct references to the fact rows in the W_PURCH_ORDER_F table. The data in this table is expected to be dynamic in nature during the receipt and acceptance related cycles of the product that has been received against the receipt line item. Columns like RECEIVED_QTY, ACCEPTED_QTY and INSPECTED_ON_DT_WID represent the current status/information related to a purchase receipt line item. Each line on this fact table would have a 1 to 1 link with a line in the W_PURCH_ORDER_F fact table.
Details
Module: Procurement (EBS_PROC)
Business Name: Purchase Receipt
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. | |||
| 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. | |||
| 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 | ||
| 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. | |||
| 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_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. | |||
| DAYS_EARLY_RECEIPT_ALLOWED | NUMBER | 15 | This indicates the Maximum acceptable number of days items can be received early | |||
| DAYS_LATE_RECEIPT_ALLOWED | NUMBER | 15 | This indicates Maximum acceptable number of days items can be received late | |||
| 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. | |||
| 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. | |||
| DROP_SHIP_FLG | VARCHAR2 | 1 CHAR | ||||
| DUE_ON_DT | TIMESTAMP | 6 | This indicates due on date. | |||
| DUE_ON_DT_WID | NUMBER | 38 | The date on which the product ordered is due for receipt. | 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. | |||
| 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_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 | ||
| LINE_TEXT | VARCHAR2 | 255 CHAR | LINE_TEXT | |||
| 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. | ||||
| MCAL_RECEIVED_ON_DT_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_MCAL_DAY_D | |||
| MVMNT_TYPE_WID | NUMBER | 38 | This indicates the type of inventory movement that is generated by this purchase receipt. The link to the DW_EB_X_EBS_PROC_W_MVMNT_TYPE_D dimension. Lookup : DW_EB_X_EBS_PROC_W_MVMNT_TYPE_D. Examples :goods receipt, goods issue, physical stock transfer | DW_EB_X_EBS_PROC_W_MVMNT_TYPE_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 related to the purchase receipt line, 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 | ||
| 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 | ||
| PO_TRADING_ORG_WID | NUMBER | 38 | ||||
| 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. | ||||
| 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 | ||
| 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 against which the purchase receipt line item is being processed. | |||
| PURCH_ORDER_NUM | VARCHAR2 | 30 CHAR | The purchase order number against which the purchase receipt has been registered. | |||
| PURCH_ORG_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_INT_ORG_D | |||
| PURCH_RCPT_ITEM | NUMBER | 15 | The line item number within the purchase receipt -- the same product may appear on multiple lines within the purchase receipt (this corresponds to situations where multiple schedule lines may be mapped as separate lines on the referred purchase order). | |||
| PURCH_RCPT_NUM | VARCHAR2 | 30 CHAR | The unique purchase receipt number that helps identify the purchase receipt. | |||
| 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_INTG_ID | VARCHAR2 | 80 CHAR | This is the Purchase Order Schedule Line Key Id | |||
| PURCH_SCHEDULE_NUM | VARCHAR2 | 30 CHAR | The purchase order schedule line number (date based delivery items) against which the purchase receipt line item is being processed. | |||
| 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 "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 | ||
| RCPT_ORG_WID | NUMBER | 38 | This indicates the business organization that is associated to the receipt location on the purchase receipt -- usually represents the inventory unit of a large business organization. The link to the "INV_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 = "INV_ORG") Example: North Americas Warehouse | DW_EB_X_EBS_COMMON_W_INT_ORG_D | ||
| RECEIPT_TEXT | VARCHAR2 | 4000 CHAR | Detailed remarks or observations generated during the product receipt process of the receipt line item. | |||
| RECEIVED_AMT | NUMBER | 38,10 | The currency value of the purchase receipt in document or transaction currency (including discounts and surcharges) calculated as Received value = Received quantity X price. | |||
| RECEIVED_ON_DT | TIMESTAMP | 6 | This indicates received date | |||
| RECEIVED_ON_DT_WID | NUMBER | 38 | The date on which the product mentioned on the purchase receipt is received at the receipt location. Lookup: W_DATE_D | DW_EB_X_EBS_COMMON_W_DAY_D | ||
| RECEIVED_ON_TM_WID | NUMBER | 38 | The time on which the product mentioned on the purchase receipt is received at the receipt location | W_TIME_OF_DAY_D | ||
| RECEIVED_QTY | NUMBER | 28,10 | The quantity of the product (in purchase order UOM) that has been received on the purchase receipt line item. | |||
| RELEASE_NUM | VARCHAR2 | 30 CHAR | This indicates the release number. | |||
| 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 | REQ_BU_WID | |||
| RMA_REFERENCE | VARCHAR2 | 80 CHAR | ||||
| 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 | ||
| SOLDTO_BU_WID | NUMBER | 38 | SOLDTO_BU_WID | |||
| 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 | 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 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 from whom the purchase receipt has been received. 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 from whom the purchased products have been received on the purchase receipt.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. | |||
| 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. | |||
| UOM_CODE | VARCHAR2 | 50 CHAR | The unit of measure of the purchase receipt item -- this would usually be the inventory unit of measure in which the product is stored at the receipt location. This can be different from the unit of measure on the purchase order. Example: Each. | |||
| VENDOR_ITEM | VARCHAR2 | 300 CHAR | VENDOR_ITEM | |||
| XACT_REASON_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_REASON_D | |||
| XACT_SOURCE_WID | NUMBER | 38 | Foreign key to DW_EB_X_EBS_COMMON_W_XACT_TYPE_D dimension | DW_EB_X_EBS_COMMON_W_XACT_SOURCE_D | ||
| XACT_TYPE_WID | NUMBER | 38 | This indicates the specific type of the purchase receipt. There could be further sub-classifications to these purchase receipt types. There could be domain values mapped for each of these transactions into the W_type domain value Type 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="PURR" Example: "PO REGULAR", "PO REPEAT", "SUBCONTRACT REGULAR" 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 |