DW_EB_X_EBS_PROC_W_AP_INV_DIST_F
Imported from databaseBug 21293960 2015-06-30JYORAOModify VENDOR_PRODUCT_NUM column length from VARCHAR2(30 CHAR) to VARCHAR2(80 CHAR)
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 | ||||
| INTEGRATION_ID | VARCHAR2 | 80 CHAR | ||||
| AGREEMENT_LEVERAGE_TYPE_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_XACT_TYPE_D | |||
| APPROVAL_STATUS_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_STATUS_D | |||
| AUTO_CUSTOM_CATEGORY1_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_PROD_CAT_DH | |||
| AUTO_CUSTOM_CATEGORY2_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_PROD_CAT_DH | |||
| AUTO_CUSTOM_CATEGORY3_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_PROD_CAT_DH | |||
| AUTO_PURCHASING_CATEGORY_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_PROD_CAT_DH | |||
| AUTO_UNSPSC_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_PROD_CAT_DH | |||
| AUX1_CHANGED_ON_DT | TIMESTAMP | 6 | ||||
| AUX2_CHANGED_ON_DT | TIMESTAMP | 6 | ||||
| AUX3_CHANGED_ON_DT | TIMESTAMP | 6 | ||||
| AUX4_CHANGED_ON_DT | TIMESTAMP | 6 | ||||
| BALANCING_SEGMENT_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_BALANCING_SEGMENT_D | |||
| CHANGED_BY_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_USER_D | |||
| CHANGED_ON_DT | TIMESTAMP | 6 | ||||
| COMPANY_ORG_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_INT_ORG_D | |||
| COST_CENTER_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_COST_CENTER_D | |||
| CREATED_BY_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_USER_D | |||
| CREATED_ON_DT | TIMESTAMP | 6 | ||||
| CUSTOM_CATEGORY1_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_PROD_CAT_DH | |||
| CUSTOM_CATEGORY2_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_PROD_CAT_DH | |||
| CUSTOM_CATEGORY3_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_PROD_CAT_DH | |||
| DELETE_FLG | VARCHAR2 | 1 CHAR | ||||
| DEST_TYPE_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_XACT_TYPE_D | |||
| DOC_CURR_CODE | VARCHAR2 | 30 CHAR | ||||
| ETL_PROC_WID | NUMBER | 38 | ||||
| EXCH_RATE_VARIANCE_AMT | NUMBER | 38,10 | ||||
| EXPENDITURE_ORG_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_INT_ORG_D | |||
| EXPENSE_CATEGORY_WID | NUMBER | 38 | ||||
| FINANCIAL_RESOURCE_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_FINANCIAL_RESOURCE_D | |||
| GLOBAL1_EXCHANGE_RATE | NUMBER | |||||
| GLOBAL2_EXCHANGE_RATE | NUMBER | |||||
| GLOBAL3_EXCHANGE_RATE | NUMBER | |||||
| GL_ACCOUNT_WID | NUMBER | 38 | 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_PROD_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_INVENTORY_PRODUCT_D | |||
| INVOICED_ON_DT | TIMESTAMP | 6 | ||||
| INVOICED_ON_DT_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_DAY_D | |||
| INVOICE_APPROVAL_DT | TIMESTAMP | 6 | ||||
| INVOICE_BASIS_TYPE_WID | NUMBER | 38 | ||||
| INVOICE_DIST_TYPE_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_XACT_TYPE_D | |||
| INVOICE_PRICE_VARIANCE_AMT | NUMBER | 38,10 | ||||
| INVOICE_RECEIVED_DT_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_DAY_D | |||
| INVOICE_REQUESTER_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_EMPLOYEE_D | |||
| INVOICE_TYPE_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_XACT_TYPE_D | |||
| INVOICE_UNIT_PRICE | NUMBER | |||||
| INV_DIST_AMT | NUMBER | 38,10 | ||||
| INV_DIST_LOC_AMT | NUMBER | 38,10 | ||||
| INV_DIST_QTY | NUMBER | 28,10 | ||||
| ITEM_DESCRIPTION | VARCHAR2 | 255 CHAR | ||||
| LEDGER_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_LEDGER_D | |||
| LOC_CURR_CODE | VARCHAR2 | 30 CHAR | ||||
| LOC_EXCHANGE_RATE | NUMBER | |||||
| MCAL_INVOICED_ON_DT_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_MCAL_DAY_D | |||
| MCAL_POSTED_ON_DT_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_MCAL_DAY_D | |||
| OPERATING_UNIT_ORG_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_INT_ORG_D | |||
| OP_VER_LINE_LOB_WID | NUMBER | 38 | W_OP_VERSION_LINE_D | |||
| OP_VER_LINE_PRC_WID | NUMBER | 38 | W_OP_VERSION_LINE_D | |||
| PAYABLES_ORG_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_INT_ORG_D | |||
| PAYMENT_CROSS_RATE | NUMBER | |||||
| PAYMENT_CURR_CODE | VARCHAR2 | 50 CHAR | ||||
| PAYMENT_STATUS_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_STATUS_D | |||
| PAY_TERMS_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_AP_TERMS_D | |||
| PLANT_LOC_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_BUSN_LOCATION_D | |||
| POSTED_ON_DT_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_DAY_D | |||
| POTENTIAL_AGREEMENT_LINE_ID | VARCHAR2 | 80 CHAR | ||||
| POTENTIAL_AGREEMENT_NUM | VARCHAR2 | 50 CHAR | ||||
| POTENTIAL_AGREEMENT_PRICE | NUMBER | 28,10 | ||||
| PO_BUYER_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_EMPLOYEE_D | |||
| PO_DISTRIBUTION_ID | VARCHAR2 | 80 CHAR | ||||
| PO_TRADING_ORG_WID | NUMBER | 38 | ||||
| PO_UNIT_PRICE | NUMBER | 28,10 | ||||
| PREFERRED_SUPPLIER_FLG | VARCHAR2 | 1 CHAR | ||||
| PRIMARY_UOM_CODE | VARCHAR2 | 50 CHAR | ||||
| PRIMARY_UOM_CONV_RATE | NUMBER | |||||
| PROC_PROD_WID | NUMBER | 38 | DW_EB_X_EBS_PROC_W_PROC_PROD_D | |||
| PRODUCT_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_PRODUCT_D | |||
| PROFIT_CENTER_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_PROFIT_CENTER_D | |||
| PROJECT_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_PROJECT_D | |||
| PURCHASE_ORG_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_INT_ORG_D | |||
| PURCH_INVOICE_DIST | NUMBER | 15 | ||||
| PURCH_INVOICE_LINE | VARCHAR2 | 15 CHAR | ||||
| PURCH_INVOICE_NUM | VARCHAR2 | 80 CHAR | ||||
| PURCH_ORDER_DT_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_DAY_D | |||
| PURCH_ORDER_NUM | VARCHAR2 | 30 CHAR | ||||
| RCPT_LOC_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_BUSN_LOCATION_D | |||
| RCV_TRANSACTION_ID | VARCHAR2 | 80 CHAR | ||||
| REQUISITION_BU_WID | NUMBER | 38 | ||||
| SOLDTO_BU_WID | NUMBER | 38 | SOLDTO_BU_WID | |||
| SOURCE_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_XACT_SOURCE_D | |||
| SPEND_CATEGORY_WID | NUMBER | 38 | ||||
| SPEND_TYPE_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_XACT_TYPE_D | |||
| SPLR_ACCT_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_SUPPLIER_ACCOUNT_D | |||
| STANDARD_UOM_CODE | VARCHAR2 | 50 CHAR | ||||
| STANDARD_UOM_CONV_RATE | NUMBER | |||||
| SUPPLIER_PROD_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_SUPPLIER_PRODUCT_D | |||
| SUPPLIER_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_PARTY_D | |||
| TASK_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_TASK_D | |||
| TENANT_ID | VARCHAR2 | 80 CHAR | ||||
| TO_CUST_LOCATION_WID | NUMBER | 38 | ||||
| TO_CUST_WID | NUMBER | 38 | ||||
| UNIT_STD_COST | NUMBER | 38,10 | ||||
| UNSPSC_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_PROD_CAT_DH | |||
| UOM_CODE | VARCHAR2 | 50 CHAR | ||||
| UOM_CONV_FLG | VARCHAR2 | 80 CHAR | ||||
| VENDOR_ITEM | VARCHAR2 | 300 CHAR | ||||
| X_CUSTOM | VARCHAR2 | 10 CHAR | ||||
| W$_INSERT_DT | TIMESTAMP | 6 | ||||
| W$_UPDATE_DT | TIMESTAMP | 6 |