DW_EB_X_EBS_PROJECTS_W_PROJ_INVOICE_DIST_F
Imported from database
Details
Module: Projects (EBS_PROJECTS)
Key Columns
Key column information is not documented in the supplied metadata.
Columns
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table |
|---|---|---|---|---|---|---|
| ROW_WID | NUMBER | 38 | True | |||
| APPROVED_BY_EMP_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_EMPLOYEE_D | |||
| APPROVED_DT_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_DAY_D | |||
| AR_INVOICE_NUMBER | VARCHAR2 | 30 CHAR | ||||
| AUX1_CHANGED_ON_DT | TIMESTAMP | 6 | ||||
| AUX2_CHANGED_ON_DT | TIMESTAMP | 6 | ||||
| AUX3_CHANGED_ON_DT | TIMESTAMP | 6 | ||||
| AUX4_CHANGED_ON_DT | TIMESTAMP | 6 | ||||
| BILL_TO_CUSTOMER_ACCOUNT_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_CUSTOMER_ACCOUNT_D | |||
| BILL_TO_CUSTOMER_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_PARTY_D | |||
| CANCELLED_FLG | VARCHAR2 | 1 CHAR | ||||
| CHANGED_BY_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_USER_D | |||
| CHANGED_ON_DT | TIMESTAMP | 6 | ||||
| CONTRACT_BILL_AMT | NUMBER | 38,10 | ||||
| CONTRACT_BU_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_INT_ORG_D | |||
| CONTRACT_CURR_CODE | VARCHAR2 | 30 CHAR | ||||
| CONTRACT_EXCHANGE_RATE | NUMBER | |||||
| CONTRACT_HDR_WID | NUMBER | 38 | DW_EB_X_EBS_AR_W_CONTRACT_HDR_D | |||
| CONTRACT_LINE_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_CONTRACT_LINE_D | |||
| CONTRACT_ORGANIZATION_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_INT_ORG_D | |||
| CONTRACT_TASK_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_TASK_D | |||
| CREATED_BY_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_USER_D | |||
| CREATED_ON_DT | TIMESTAMP | 6 | ||||
| CREDIT_INVOICE_NUM | VARCHAR2 | 30 CHAR | ||||
| CROSS_CHARGE_TYPE_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_XACT_TYPE_D | |||
| DATASOURCE_NUM_ID | NUMBER | 10 | ||||
| DELETE_FLG | VARCHAR2 | 1 CHAR | ||||
| DOC_BILL_AMT | NUMBER | 38,10 | ||||
| DOC_CURR_CODE | VARCHAR2 | 30 CHAR | ||||
| ENTERPRISE_GL_DT_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_DAY_D | |||
| ETL_PROC_WID | NUMBER | 38 | ||||
| EVENT_WID | NUMBER | 38 | DW_EB_X_EBS_PROJECTS_W_EVENT_D | |||
| EXPENDITURE_BU_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_INT_ORG_D | |||
| EXPENDITURE_CLASS_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_XACT_TYPE_D | |||
| EXPENDITURE_DT_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_DAY_D | |||
| EXPENDITURE_ITEM_ID | VARCHAR2 | 80 CHAR | ||||
| EXPENDITURE_ORGANIZATION_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_INT_ORG_D | |||
| EXTERNAL_CONTRACT_FLG | VARCHAR2 | 1 CHAR | ||||
| 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 | |||||
| INCURRED_BY_EMP_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_EMPLOYEE_D | |||
| INTEGRATION_ID | VARCHAR2 | 80 CHAR | ||||
| INTER_COMPANY_CONTRACT_FLG | VARCHAR2 | 1 CHAR | ||||
| INTER_PROJECT_CONTRACT_FLG | VARCHAR2 | 1 CHAR | ||||
| INVOICE_DIST_ID | VARCHAR2 | 80 CHAR | ||||
| INVOICE_DT_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_DAY_D | |||
| INVOICE_HDR_TYPE_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_XACT_TYPE_D | |||
| INVOICE_ID | VARCHAR2 | 80 CHAR | ||||
| INVOICE_LINE_ID | VARCHAR2 | 80 CHAR | ||||
| INVOICE_LINE_NUM | VARCHAR2 | 80 CHAR | ||||
| INVOICE_LINE_TYPE_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_XACT_TYPE_D | |||
| INVOICE_NUM | VARCHAR2 | 80 CHAR | ||||
| INVOICE_TRANSFER_STATUS_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_STATUS_D | |||
| INV_LINE_DIST_NUM | VARCHAR2 | 80 CHAR | ||||
| JOB_WID | NUMBER | 38 | DW_EB_X_EBS_PROJECTS_W_JOB_D | |||
| LEDGER_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_LEDGER_D | |||
| LOC_BILL_AMT | NUMBER | 38,10 | ||||
| LOC_CURR_CODE | VARCHAR2 | 30 CHAR | ||||
| LOC_EXCHANGE_RATE | NUMBER | |||||
| PROJECT_BILLING_TYPE_CODE | VARCHAR2 | 50 CHAR | ||||
| PROJECT_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_PROJECT_D | |||
| PROJ_BILL_AMT | NUMBER | 38,10 | ||||
| PROJ_BU_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_INT_ORG_D | |||
| PROJ_CURR_CODE | VARCHAR2 | 30 CHAR | ||||
| PROJ_EXCHANGE_RATE | NUMBER | |||||
| PROJ_MANAGER_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_EMPLOYEE_D | |||
| PROJ_ORGANIZATION_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_INT_ORG_D | |||
| PROJ_PR_CUSTOMER_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_PARTY_D | |||
| PROJ_STATUS_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_STATUS_D | |||
| PROJ_UNIT_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_INT_ORG_D | |||
| PRVDR_GL_ACCOUNTING_DT_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_MCAL_DAY_D | |||
| PRVDR_GL_MCAL_CAL_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_MCAL_CAL_D | |||
| PRVDR_PROJ_ACCOUNTING_DT_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_MCAL_DAY_D | |||
| PRVDR_PROJ_MCAL_CAL_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_MCAL_CAL_D | |||
| RCVR_GL_ACCOUNTING_DT_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_MCAL_DAY_D | |||
| RCVR_GL_MCAL_CAL_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_MCAL_CAL_D | |||
| RCVR_LOC_BILL_AMT | NUMBER | 38,10 | ||||
| RCVR_LOC_CURR_CODE | VARCHAR2 | 30 CHAR | ||||
| RCVR_PROJ_ACCOUNTING_DT_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_MCAL_DAY_D | |||
| RCVR_PROJ_MCAL_CAL_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_MCAL_CAL_D | |||
| RELEASED_BY_EMP_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_EMPLOYEE_D | |||
| RELEASED_DT_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_DAY_D | |||
| SERVICE_TYPE_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_XACT_TYPE_D | |||
| TASK_ORGANIZATION_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_INT_ORG_D | |||
| TASK_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_TASK_D | |||
| TENANT_ID | VARCHAR2 | 80 CHAR | ||||
| WORK_TYPE_WID | NUMBER | 38 | DW_EB_X_EBS_PROJECTS_W_WORK_TYPE_D | |||
| WRITE_OFF_FLG | VARCHAR2 | 1 CHAR | ||||
| W_PROJECT_BILLING_TYPE_CODE | VARCHAR2 | 50 CHAR | ||||
| X_CUSTOM | VARCHAR2 | 10 CHAR | ||||
| W$_INSERT_DT | TIMESTAMP | 6 | ||||
| W$_UPDATE_DT | TIMESTAMP | 6 |