DW_EB_X_EBS_AP_W_AP_BALANCE_F
This table stores account payable balance information for supplier accounts.Only Posted records are considered for calculating the balances and Balance amts can be use for Financial reporting.
Details
Module: Payables (EBS_AP)
Business Name: Accounts payable balance
Key Columns
Key column information is not documented in the supplied metadata.
Columns
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table |
|---|---|---|---|---|---|---|
| INTEGRATION_ID | VARCHAR2 | 1000 CHAR | True | 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. | ||
| ACCT_CURR_CODE | VARCHAR2 | 28 CHAR | Account Currency Code | |||
| ACTIVITY_ACCT_AMT | NUMBER | 38,10 | Activity amount in account currency | |||
| ACTIVITY_GLOBAL1_AMT | NUMBER | 38,10 | Activity amount in group currency1 | |||
| ACTIVITY_GLOBAL2_AMT | NUMBER | 38,10 | Balance amount in group currency2 | |||
| ACTIVITY_GLOBAL3_AMT | NUMBER | 38,10 | Balance amount in group currency3 | |||
| ACTIVITY_LOC_AMT | NUMBER | 38,10 | Activity amount in local currency | |||
| BALANCE_ACCT_AMT | NUMBER | 38,10 | Balance amount in account currency | |||
| BALANCE_DT_WID | NUMBER | 38 | Balance Date Key | DW_EB_X_EBS_COMMON_W_DAY_D | ||
| BALANCE_GLOBAL1_AMT | NUMBER | 38,10 | Balance amount in group currency1 | |||
| BALANCE_GLOBAL2_AMT | NUMBER | 38,10 | Balance amount in group currency2 | |||
| BALANCE_GLOBAL3_AMT | NUMBER | 38,10 | Balance amount in group currency3 | |||
| BALANCE_LOC_AMT | NUMBER | 38,10 | Balance amount in local currency | |||
| BALANCE_TM_WID | NUMBER | 38 | Balance Time Key | |||
| BALANCING_SEGMENT_WID | NUMBER | 38 | Key to the Profit Center dimension | DW_EB_X_EBS_COMMON_W_BALANCING_SEGMENT_D | ||
| BUSN_AREA_ORG_WID | NUMBER | 38 | Key to the Business Area Organization in business organizations dimension | DW_EB_X_EBS_COMMON_W_INT_ORG_D | ||
| COMPANY_ORG_WID | NUMBER | 38 | Key to the company organization in Business Organizations dimension | DW_EB_X_EBS_COMMON_W_INT_ORG_D | ||
| COST_CENTER_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_COST_CENTER_D | |||
| 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. | |||
| DB_CR_IND | VARCHAR2 | 30 CHAR | Debit/Credit Indicator | |||
| ETL_PROC_WID | NUMBER | 38 | This column is the unique identifier for the specific ETL process used to create or update this data. | |||
| GL_ACCOUNT_WID | NUMBER | 38 | Key to the GL Accounts dimension | DW_EB_X_EBS_COMMON_W_GL_ACCOUNT_D | ||
| LEDGER_WID | NUMBER | 38 | Key to the Ledger dimension | DW_EB_X_EBS_COMMON_W_LEDGER_D | ||
| LOC_CURR_CODE | VARCHAR2 | 28 CHAR | Local Currency Code | |||
| MCAL_CAL_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_MCAL_CAL_D | |||
| NATURAL_ACCOUNT_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_NATURAL_ACCOUNT_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 | |||
| 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 | |||
| SUPPLIER_ACCOUNT_WID | NUMBER | 38 | Key to the Splr Accts dimension | DW_EB_X_EBS_COMMON_W_SUPPLIER_ACCOUNT_D | ||
| SUPPLIER_WID | NUMBER | 38 | Key to the Suppliers dimension | DW_EB_X_EBS_COMMON_W_PARTY_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. | |||
| THIRD_PARTY_WID | NUMBER | 38 | ||||
| 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 |