DW_EB_X_EBS_PROC_W_AP_INV_DIST_MONTH_A
No table description is available in the supplied metadata.
Details
Module: Procurement (EBS_PROC)
Business Name: Invoice Lines Month Aggregate
Key Columns
Key column information is not documented in the supplied metadata.
Columns
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table |
|---|---|---|---|---|---|---|
| AGREEMENT_LEVERAGE_TYPE_WID | NUMBER | 38 | AGREEMENT_LEVERAGE_TYPE_WI D | DW_EB_X_EBS_COMMON_W_XACT_TYPE_D | ||
| APPROVAL_STATUS_WID | NUMBER | 38 | APPROVAL_STATUS_WID | DW_EB_X_EBS_COMMON_W_STATUS_D | ||
| AUTO_CUSTOM_CATEGORY1_WID | NUMBER | 38 | AUTO_CUSTOM_CATEGORY1_WID | |||
| AUTO_CUSTOM_CATEGORY2_WID | NUMBER | 38 | AUTO_CUSTOM_CATEGORY2_WID | |||
| AUTO_CUSTOM_CATEGORY3_WID | NUMBER | 38 | AUTO_CUSTOM_CATEGORY3_WID | |||
| AUTO_PURCHASING_CATEGORY_WID | NUMBER | 38 | AUTO_PURCHASING_CATEGORY_ WID | |||
| AUTO_UNSPSC_WID | NUMBER | 38 | AUTO_UNSPSC_WID | |||
| COST_CENTER_WID | NUMBER | 38 | COST_CENTER_WID | DW_EB_X_EBS_COMMON_W_COST_CENTER_D | ||
| DATASOURCE_NUM_ID | NUMBER | 10 | DATASOURCE_NUM_ID | |||
| GL_ACCOUNT_WID | NUMBER | 38 | GL_ACCOUNT_WID | |||
| INVOICE_DIST_TYPE_WID | NUMBER | 38 | INVOICE_DIST_TYPE_WID | |||
| INVOICE_TYPE_WID | NUMBER | 38 | INVOICE_TYPE_WID | DW_EB_X_EBS_COMMON_W_XACT_TYPE_D | ||
| ITEM_DESCRIPTION | VARCHAR2 | 255 CHAR | ITEM_DESCRIPTION | |||
| LEDGER_WID | NUMBER | 38 | LEDGER_WID | |||
| PAYABLES_ORG_WID | NUMBER | 38 | PAYABLES_ORG_WID | DW_EB_X_EBS_COMMON_W_INT_ORG_D | ||
| PAYMENT_STATUS_WID | NUMBER | 38 | PAYMENT_STATUS_WID | DW_EB_X_EBS_COMMON_W_STATUS_D | ||
| PERIOD_START_DT_WID | NUMBER | 38 | PERIOD_START_DT_WID | |||
| PO_BUYER_WID | NUMBER | 38 | PO_BUYER_WID | |||
| PRODUCT_WID | NUMBER | 38 | PRODUCT_WID | DW_EB_X_EBS_COMMON_W_PRODUCT_D | ||
| PURCHASE_ORG_WID | NUMBER | 38 | PURCHASE_ORG_WID | DW_EB_X_EBS_COMMON_W_INT_ORG_D | ||
| SPEND_TYPE_WID | NUMBER | 38 | SPEND_TYPE_WID | DW_EB_X_EBS_COMMON_W_XACT_TYPE_D | ||
| STANDARD_UOM_CODE | VARCHAR2 | 50 CHAR | STANDARD_UOM_CODE | |||
| SUPPLIER_WID | NUMBER | 38 | SUPPLIER_WID | |||
| UNSPSC_WID | NUMBER | 38 | UNSPSC_WID | |||
| ETL_PROC_WID | NUMBER | 38 | ETL_PROC_WID | |||
| GLOBAL1_INVOICE_AMT | NUMBER | 38,10 | GLOBAL1_INVOICE_AMT | |||
| GLOBAL1_IPV_AMT | NUMBER | 38,10 | GLOBAL1_IPV_AMT | |||
| GLOBAL2_INVOICE_AMT | NUMBER | 38,10 | GLOBAL2_INVOICE_AMT | |||
| GLOBAL2_IPV_AMT | NUMBER | 38,10 | GLOBAL2_IPV_AMT | |||
| GLOBAL3_INVOICE_AMT | NUMBER | 38,10 | GLOBAL3_INVOICE_AMT | |||
| GLOBAL3_IPV_AMT | NUMBER | 38,10 | GLOBAL3_IPV_AMT | |||
| INVOICE_DOC_AMT | NUMBER | 38,10 | INVOICE_DOC_AMT | |||
| INVOICE_LOC_AMT | NUMBER | 38,10 | INVOICE_LOC_AMT | |||
| INV_DIST_QTY | NUMBER | 28,10 | INV_DIST_QTY | |||
| IPV_DOC_AMT | NUMBER | 38,10 | IPV_DOC_AMT | |||
| IPV_LOC_AMT | NUMBER | 38,10 | IPV_LOC_AMT | |||
| LOC_CURR_CODE | VARCHAR2 | 30 CHAR | LOC_CURR_CODE | |||
| MAX_INVOICE_UNIT_PRICE | NUMBER | MAX_INVOICE_UNIT_PRICE | ||||
| MIN_INVOICE_UNIT_PRICE | NUMBER | MIN_INVOICE_UNIT_PRICE | ||||
| W$_INSERT_DT | TIMESTAMP | 6 | ||||
| W$_UPDATE_DT | TIMESTAMP | 6 |