DW_EB_X_EBS_PROC_W_PURCH_VARIANCE_XACT_F
No table description is available in the supplied metadata.
Details
Module: Procurement (EBS_PROC)
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 | ||||
| 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' | |||
| 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. | |||
| 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 | ||
| 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. | |||
| 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. | |||
| 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. | |||
| 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_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 | |||
| 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 | ||
| 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_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. | ||||
| MCAL_PO_OPENED_DT_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_MCAL_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 purchasing document was created. | 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 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. | |||
| PO_APPROVED_ON_DT | TIMESTAMP | 6 | ||||
| PO_CLOSED_DT | TIMESTAMP | 6 | ||||
| PO_OPENED_DT | TIMESTAMP | 6 | ||||
| PO_OPENED_DT_WID | NUMBER | 38 | ||||
| PO_STATUS_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_STATUS_D | |||
| PPV_AMOUNT | NUMBER | 38,10 | ||||
| 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 | ||
| 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_COST_INTG_ID | VARCHAR2 | 80 CHAR | ||||
| 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_SCHEDULE_INTG_ID | VARCHAR2 | 80 CHAR | ||||
| PURCH_SCHEDULE_NUM | VARCHAR2 | 30 CHAR | This indicates the purchase schedule number. | |||
| 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 | ||
| RELEASE_NUM | VARCHAR2 | 30 CHAR | This indicates the release number. | |||
| REQ_BU_WID | NUMBER | 38 | 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 | ||
| 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 | ||
| SOLD_TO_BU_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_INT_ORG_D | |||
| 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_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. | |||
| 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 | ||
| VENDOR_PRODUCT_NUM | VARCHAR2 | 30 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 |