DW_EB_X_EBS_AR_W_AR_BALANCE_ENT_F
This table stores the accounts receivable balance supporting enterprise calendar for customer accounts.Only Posted records are considered for calculating the balances and Balance amts can be use for Financial reporting.
Details
Module: Receivables (EBS_AR)
Business Name: Accounts receivable enterprise 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 | INTEGRATION_ID | ||
| ACCT_CURR_CODE | VARCHAR2 | 50 CHAR | ACCT_CURR_CODE | |||
| ACTIVITY_ACCT_AMT | NUMBER | 38,10 | ACTIVITY_ACCT_AMT | |||
| ACTIVITY_GLOBAL1_AMT | NUMBER | 38,10 | ACTIVITY_GLOBAL1_AMT | |||
| ACTIVITY_GLOBAL2_AMT | NUMBER | 38,10 | ACTIVITY_GLOBAL2_AMT | |||
| ACTIVITY_GLOBAL3_AMT | NUMBER | 38,10 | ACTIVITY_GLOBAL3_AMT | |||
| ACTIVITY_LOC_AMT | NUMBER | 38,10 | ACTIVITY_LOC_AMT | |||
| BALANCE_ACCT_AMT | NUMBER | 38,10 | BALANCE_ACCT_AMT | |||
| BALANCE_DT_WID | NUMBER | 38 | BALANCE_DT_WID | DW_EB_X_EBS_COMMON_W_DAY_D | ||
| BALANCE_GLOBAL1_AMT | NUMBER | 38,10 | BALANCE_GLOBAL1_AMT | |||
| BALANCE_GLOBAL2_AMT | NUMBER | 38,10 | BALANCE_GLOBAL2_AMT | |||
| BALANCE_GLOBAL3_AMT | NUMBER | 38,10 | BALANCE_GLOBAL3_AMT | |||
| BALANCE_LOC_AMT | NUMBER | 38,10 | BALANCE_LOC_AMT | |||
| BALANCE_TM_WID | NUMBER | 38 | BALANCE_TM_WID | |||
| BALANCING_SEGMENT_WID | NUMBER | 38 | BALANCING_SEGMENT_WID | DW_EB_X_EBS_COMMON_W_BALANCING_SEGMENT_D | ||
| BUSN_AREA_ORG_WID | NUMBER | 38 | BUSN_AREA_ORG_WID | DW_EB_X_EBS_COMMON_W_INT_ORG_D | ||
| COMPANY_ORG_WID | NUMBER | 38 | COMPANY_ORG_WID | DW_EB_X_EBS_COMMON_W_INT_ORG_D | ||
| COST_CENTER_WID | NUMBER | 38 | COST_CENTER_WID | DW_EB_X_EBS_COMMON_W_COST_CENTER_D | ||
| CUSTOMER_ACCNT_WID | NUMBER | 38 | CUSTOMER_ACCNT_WID | DW_EB_X_EBS_COMMON_W_CUSTOMER_ACCOUNT_D | ||
| CUSTOMER_WID | NUMBER | 38 | CUSTOMER_WID | DW_EB_X_EBS_COMMON_W_PARTY_D | ||
| DATASOURCE_NUM_ID | NUMBER | 10 | DATASOURCE_NUM_ID | |||
| DB_CR_IND | VARCHAR2 | 30 CHAR | DB_CR_IND | |||
| ETL_PROC_WID | NUMBER | 38 | ETL_PROC_WID | |||
| GL_ACCOUNT_WID | NUMBER | 38 | GL_ACCOUNT_WID | DW_EB_X_EBS_COMMON_W_GL_ACCOUNT_D | ||
| LEDGER_WID | NUMBER | 38 | LEDGER_WID | DW_EB_X_EBS_COMMON_W_LEDGER_D | ||
| LOC_CURR_CODE | VARCHAR2 | 30 CHAR | LOC_CURR_CODE | |||
| NATURAL_ACCOUNT_WID | NUMBER | 38 | NATURAL_ACCOUNT_WID | DW_EB_X_EBS_COMMON_W_NATURAL_ACCOUNT_D | ||
| OPERATING_UNIT_ORG_WID | NUMBER | 38 | OPERATING_UNIT_ORG_WID | DW_EB_X_EBS_COMMON_W_INT_ORG_D | ||
| PROFIT_CENTER_WID | NUMBER | 38 | PROFIT_CENTER_WID | DW_EB_X_EBS_COMMON_W_PROFIT_CENTER_D | ||
| RECEIVABLES_ORG_WID | NUMBER | 38 | RECEIVABLES_ORG_WID | DW_EB_X_EBS_COMMON_W_INT_ORG_D | ||
| TENANT_ID | VARCHAR2 | 80 CHAR | TENANT_ID | |||
| X_CUSTOM | VARCHAR2 | 10 CHAR | X_CUSTOM | |||
| W$_INSERT_DT | TIMESTAMP | 6 | ||||
| W$_UPDATE_DT | TIMESTAMP | 6 |