DW_EB_X_EBS_AR_W_AR_XACT_GRPACCT_FSCLPRD_A
This table is an aggregate table of DW_EB_X_EBS_AR_W_AR_XACT_F at fiscal month level and various other dimensions. These dimensions include Company, Customer, Customer Fin Profl, Transaction type, etc.Records from DW_EB_X_EBS_AR_W_AR_XACT_F are aggregated at fiscal month level and various other dimensions. For instance, all invoices generated for Customer 'A' posted in 3rd fiscal month of fiscal year 2006 are aggregated into one record. The aggregation is based on POSTED_ON_DT_WID field of DW_EB_X_EBS_AR_W_AR_XACT_F, which is the document's posting date.The field FSCL_MONTH_WID indicates the fiscal month of this aggregation record.Fields such as XACT_COUNT indicates the transaction count of this particular aggregation record. For instance, the aggregation record for Customer 'A', for the 3rd fiscal month of fiscal year 2006, for the transaction type of 'Invoice', the XACT_COUNT indicates how many invoices for Customer 'A', is posted in the 3rd fiscal month of fiscal year 2006.
Details
Module: Receivables (EBS_AR)
Key Columns
Key column information is not documented in the supplied metadata.
Columns
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table |
|---|---|---|---|---|---|---|
| ACCOUNTING_DT_WID | NUMBER | 38 | ||||
| AGREEMENT_WID | NUMBER | 38 | DW_EB_X_EBS_AR_W_CONTRACT_HDR_D | |||
| AR_GLOBAL1_AMT | NUMBER | 38,10 | Amount in group currency1 | |||
| BALANCING_SEGMENT_WID | NUMBER | 38 | Key to the Profit Centers 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 | ||
| CUSTOMER_ACCNT_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_CUSTOMER_ACCOUNT_D | |||
| CUSTOMER_WID | NUMBER | 38 | Key to the Customers dimension | DW_EB_X_EBS_COMMON_W_PARTY_D | ||
| DB_CR_IND | VARCHAR2 | 30 CHAR | Debit/Credit Indicator | |||
| DOC_STATUS_WID | NUMBER | 38 | Key to Status dimension | DW_EB_X_EBS_COMMON_W_STATUS_D | ||
| DOC_TYPE_WID | NUMBER | 38 | Key to Xact Type dimension | DW_EB_X_EBS_COMMON_W_XACT_TYPE_D | ||
| GL_STATUS_WID | NUMBER | 38 | ||||
| GROUP_ACCT_WID | NUMBER | 38 | Group account key | DW_EB_X_EBS_COMMON_W_GL_GROUP_ACCOUNT_D | ||
| LATE_PAID_FLG | VARCHAR2 | 1 CHAR | Flag indicating whether this transaction was paid late or on time | |||
| LEDGER_WID | NUMBER | 38 | Key to the Ledger dimension | DW_EB_X_EBS_COMMON_W_LEDGER_D | ||
| MCAL_CAL_WID | NUMBER | 38 | Key to the Multi-Calendars dimension | DW_EB_X_EBS_COMMON_W_MCAL_CAL_D | ||
| MCAL_PERIOD_WID | NUMBER | 38 | Key to the Multi-Calendar Period dimension | DW_EB_X_EBS_COMMON_W_MCAL_PERIOD_D | ||
| OPERATING_UNIT_ORG_WID | NUMBER | 38 | Key to the Operating Unit Organization in Business organizations dimension | DW_EB_X_EBS_COMMON_W_INT_ORG_D | ||
| PMT_DAYS_COUNT | NUMBER | 15 | Number of days it took to pay | |||
| PROFIT_CENTER_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_PROFIT_CENTER_D | |||
| RECEIVABLES_ORG_WID | NUMBER | 38 | Key to the Receivables Organization in Business organizations dimension | DW_EB_X_EBS_COMMON_W_INT_ORG_D | ||
| RECEIVABLES_RCPT_ORG_WID | NUMBER | 38 | ||||
| XACTS_COUNT | NUMBER | 15 | Transaction count | |||
| AR_GLOBAL2_AMT | NUMBER | 38,10 | Amount in group currency2 | |||
| AR_GLOBAL3_AMT | NUMBER | 38,10 | Amount in group currency3 | |||
| AR_LOC_AMT | NUMBER | 38,10 | Amount in local currency | |||
| 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. | |||
| EARNED_DISC_GLOBAL1_AMT | NUMBER | 38,10 | ||||
| EARNED_DISC_GLOBAL2_AMT | NUMBER | 38,10 | ||||
| EARNED_DISC_GLOBAL3_AMT | NUMBER | 38,10 | ||||
| EARNED_DISC_LOC_AMT | NUMBER | 38,10 | ||||
| ETL_PROC_WID | NUMBER | 38 | Siebel System Field. This column is the unique identifier for the specific ETL process used to create or update this data | |||
| LOC_CURR_CODE | VARCHAR2 | 30 CHAR | Local currency code | |||
| PMT_DAYS_TIMES_AMT | NUMBER | 38,10 | Number of days it took to pay multiply by the payment amount | |||
| POSTED_FLG | VARCHAR2 | 1 CHAR | Posted flag | |||
| 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 | |||
| UNEARNED_DISC_GLOBAL1_AMT | NUMBER | 38,10 | ||||
| UNEARNED_DISC_GLOBAL2_AMT | NUMBER | 38,10 | ||||
| UNEARNED_DISC_GLOBAL3_AMT | NUMBER | 38,10 | ||||
| UNEARNED_DISC_LOC_AMT | NUMBER | 38,10 | ||||
| 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 |