DW_EB_X_EBS_AP_W_AP_HOLDS_F
No table description is available in the supplied metadata.
Details
Module: Payables (EBS_AP)
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 | 320 CHAR | ||||
| ACTIVE_HOLD_STATUS_FLAG | VARCHAR2 | 1 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 | ||||
| BUSN_AREA_ORG_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_INT_ORG_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 | |||
| CREATED_BY_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_USER_D | |||
| CREATED_ON_DT | TIMESTAMP | 6 | ||||
| DELETE_FLG | VARCHAR2 | 1 CHAR | ||||
| DOC_CURR_CODE | VARCHAR2 | 30 CHAR | ||||
| DOC_INVOICE_AMT | NUMBER | 38,10 | ||||
| ETL_PROC_WID | NUMBER | 38 | ||||
| GLOBAL1_EXCHANGE_RATE | NUMBER | |||||
| GLOBAL2_EXCHANGE_RATE | NUMBER | |||||
| GLOBAL3_EXCHANGE_RATE | NUMBER | |||||
| HELD_BY_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_USER_D | |||
| HOLD_DATE_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_DAY_D | |||
| HOLD_REASON_WID | NUMBER | 38 | DW_EB_X_EBS_AP_W_AP_HOLD_RELEASE_REASON_D | |||
| INVOICED_ON_DT_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_DAY_D | |||
| INVOICE_ID | VARCHAR2 | 80 CHAR | ||||
| INVOICE_NUM | VARCHAR2 | 80 CHAR | ||||
| LEDGER_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_LEDGER_D | |||
| LINE_NUMBER | NUMBER | 15 | ||||
| LOC_CURR_CODE | VARCHAR2 | 30 CHAR | ||||
| LOC_EXCHANGE_RATE | NUMBER | |||||
| LOC_INVOICE_AMT | NUMBER | 38,10 | ||||
| MCAL_CAL_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_MCAL_CAL_D | |||
| OPERATING_UNIT_ORG_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_INT_ORG_D | |||
| PAYABLES_ORG_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_INT_ORG_D | |||
| PAY_METHOD_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_PAYMENT_METHOD_D | |||
| PAY_TERMS_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_AP_TERMS_D | |||
| PRODUCT_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_PRODUCT_D | |||
| PURCHASE_ORG_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_INT_ORG_D | |||
| REF_DOC_NUM | VARCHAR2 | 80 CHAR | ||||
| RELEASED_BY_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_USER_D | |||
| RELEASED_DATE_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_DAY_D | |||
| RELEASE_REASON_WID | NUMBER | 38 | DW_EB_X_EBS_AP_W_AP_HOLD_RELEASE_REASON_D | |||
| SALES_ORG_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_INT_ORG_D | |||
| SOURCE_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_XACT_SOURCE_D | |||
| SPLR_ACCT_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_SUPPLIER_ACCOUNT_D | |||
| SUPPLIER_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_PARTY_D | |||
| TENANT_ID | VARCHAR2 | 320 CHAR | ||||
| THIRD_PARTY_WID | NUMBER | 38 | ||||
| X_CUSTOM | VARCHAR2 | 40 CHAR | ||||
| W$_INSERT_DT | TIMESTAMP | 6 | ||||
| W$_UPDATE_DT | TIMESTAMP | 6 |