DW_EB_X_EBS_PROC_W_PURCH_RCPT_A
The DW_EB_X_EBS_PROC_W_PURCH_RCPT_A aggregate 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), and aggregated at product types level and month level. The data in this table is stored at the purchase receipt transaction detail level. The data is aggregated over product types level and a configurable time period. The configurable time period is preconfigured with a value of Month.The dimensions that identify the grain of the DW_EB_X_EBS_PROC_W_PURCH_RCPT_A table are: §Supplier§Product Types§Receipt Organization§Transaction Types
Details
Module: Procurement (EBS_PROC)
Business Name: Purchase Receipt Aggregate
Key Columns
Key column information is not documented in the supplied metadata.
Columns
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table |
|---|---|---|---|---|---|---|
| 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 | ||
| 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. | |||
| 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 | The regional business currency of the purchasing organization. Lookup: LKP_LOC_CURRENCY Example: USD, EUR | |||
| OPERATING_UNIT_ORG_WID | NUMBER | 38 | Identifies the operating unit organization. | DW_EB_X_EBS_COMMON_W_INT_ORG_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 | ||
| PERIOD_END_DT_WID | NUMBER | 38 | This column indicates the date to/until, which this row is effective. By default, 1-JAN-3714 is populated if row is inserted for the first time and source system does not provide this value; otherwise source system provided value is used. If source system does not provide date during a change of this row, Siebel Applications calculate this date based upon previous changes to this row, and marks the latest row with the value of 1-JAN-3714. This column helps in tracking type II changes (i.e. historical changes) to the asset. | DW_EB_X_EBS_COMMON_W_DAY_D | ||
| PERIOD_START_DT_WID | NUMBER | 38 | This column indicates the date from, which this row is effective. By default, 1-JAN-1899 is populated if row is inserted for the first time and source system does not provide this value; otherwise source system provided value is used. If source system does not provide date during a change of this row, Siebel Applications calculate this date based upon previous changes to this row. This column helps in tracking type II changes (i.e. historical changes) to the asset. | DW_EB_X_EBS_COMMON_W_DAY_D | ||
| PRODUCT_TYPE_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_TYPE_D | ||
| PURCH_ORG_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_INT_ORG_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 | ||
| 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 | ||
| 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_WID | NUMBER | 38 | This indicates the supplier for whose product the pricing information is maintained in this table. The link to the W_SUPPLIER_D dimension. Lookup: W_SUPPLIER_D Example : Electronic equipment retailers like Circuit City, Good Guys | 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. | |||
| 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. | |||
| 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 | ||
| DOC_RECEIVED_AMT | NUMBER | 38,10 | ||||
| DOC_STD_COST_AMT | NUMBER | 38,10 | ||||
| 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_RECEIVED_AMT | NUMBER | 38,10 | The currency value of the purchase receipt in Global currency (including discounts and surcharges) calculated as Received value = Received quantity X price. | |||
| GLOBAL1_STD_COST_AMT | NUMBER | 38,10 | Standard Cost Amount in Global currency. | |||
| GLOBAL2_RECEIVED_AMT | NUMBER | 38,10 | The currency value of the purchase receipt in Global currency (including discounts and surcharges) calculated as Received value = Received quantity X price. | |||
| GLOBAL2_STD_COST_AMT | NUMBER | 38,10 | Standard Cost Amount in Global currency. | |||
| GLOBAL3_RECEIVED_AMT | NUMBER | 38,10 | The currency value of the purchase receipt in Global currency (including discounts and surcharges) calculated as Received value = Received quantity X price. | |||
| GLOBAL3_STD_COST_AMT | NUMBER | 38,10 | Standard Cost Amount in Global currency. | |||
| LOC_RECEIVED_AMT | NUMBER | 38,10 | The currency value of the purchase receipt in Local currency (including discounts and surcharges) calculated as Received value = Received quantity X price. | |||
| LOC_STD_COST_AMT | NUMBER | 38,10 | Standard Cost Amount in Local currency. | |||
| RCPT_CNT | NUMBER | 15 | Count of Purchase Receipts. | |||
| RECEIVED_QTY | NUMBER | 28,10 | The quantity of the product (in purchase order UOM) that has been received on the purchase receipt line item. | |||
| REQ_BU_WID | NUMBER | 38 | REQ_BU_WID | |||
| ROW_WID | NUMBER | 38 | Surrogate key to uniquely identify a record. | |||
| SOLDTO_BU_WID | NUMBER | 38 | SOLDTO_BU_WID | |||
| W$_INSERT_DT | TIMESTAMP | 6 | ||||
| W$_UPDATE_DT | TIMESTAMP | 6 |