DW_EB_X_EBS_AR_W_CUSTOMER_FIN_PROFL_F
Customer Financial Profile Fact stores information about the financial profile of customers. This entity has the information of Customers Credit Limits defined in the source systems in various Currencies, Credit Ratings, Primary Collector, Payment Term Code, Bill of Exchange Payment term code etc.
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 |
|---|---|---|---|---|---|---|
| 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. | |||
| INTEGRATION_ID | VARCHAR2 | 80 CHAR | 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. | |||
| AUX1_CHANGED_ON_DT | TIMESTAMP | 6 | Siebel System field. This column identifies the last modified date and time of the auxiliary table's record which acts as a source for the current table. | |||
| AUX2_CHANGED_ON_DT | TIMESTAMP | 6 | Siebel System field. This column identifies the last modified date and time of the auxiliary table's record which acts as a source for the current table. | |||
| AUX3_CHANGED_ON_DT | TIMESTAMP | 6 | Siebel System field. This column identifies the last modified date and time of the auxiliary table's record which acts as a source for the current table. | |||
| AUX4_CHANGED_ON_DT | TIMESTAMP | 6 | Siebel System field. This column identifies the last modified date and time of the auxiliary table's record which acts as a source for the current table. | |||
| BOE_LIMIT_AMT | NUMBER | 38,10 | Bill of Exchange Limit Amount. | |||
| CHANGED_BY_WID | NUMBER | 38 | This is a foreign key to the DW_EB_X_EBS_COMMON_W_USER_D dimension indicating the user who last modified the record in the source system. | DW_EB_X_EBS_COMMON_W_USER_D | ||
| CHANGED_ON_DT | TIMESTAMP | 6 | Identifies the date and time when the record was last modified in the source system. | |||
| CREATED_BY_WID | NUMBER | 38 | This is a foreign key to the DW_EB_X_EBS_COMMON_W_USER_D dimension indicating the user who created the record in the source system. | DW_EB_X_EBS_COMMON_W_USER_D | ||
| CREATED_ON_DT | TIMESTAMP | 6 | Identifies the date and time when the record was initially created in the source system. | |||
| CREDIT_RATING | VARCHAR2 | 50 CHAR | Credit Rating associated with the Customer Profile. | |||
| CRLIMIT_EXCEED_DT_WID | NUMBER | 38 | Credit Limit Exceed Date WID | |||
| CURRENT_FLG | VARCHAR2 | 1 CHAR | This is a flag for marking dimension records as "Y" in order to represent the current state of a dimension entity. This flag is typically critical for Type II slowly-changing dimensions, as records in a Type II situation tend to be numerous. | |||
| CUST_ACCOUNT_WID | NUMBER | 38 | Customer Account WID | DW_EB_X_EBS_COMMON_W_CUSTOMER_ACCOUNT_D | ||
| CUST_CREDIT_LIMIT | NUMBER | 28,10 | Customer Credit Limit Amount. | |||
| DELETE_FLG | VARCHAR2 | 1 CHAR | This flag indicates the deletion status of the record in the source system. A value of "Y" indicates that the record is deleted from the source system and logically deleted from the data warehouse; a value of "N" indicates that the record is active. | |||
| DOC_CURR_CODE | VARCHAR2 | 30 CHAR | Document Currency Code | |||
| 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. | |||
| GLOBAL1_EXCHANGE_RATE | NUMBER | Global1 Exchange Currency Rate. | ||||
| GLOBAL2_EXCHANGE_RATE | NUMBER | Global2 Exchange Currency Rate | ||||
| GLOBAL3_EXCHANGE_RATE | NUMBER | Global3 Exchange Currency Rate | ||||
| LOC_CURR_CODE | VARCHAR2 | 30 CHAR | Local Currency Code | |||
| LOC_EXCHANGE_RATE | NUMBER | Local Exchange Currency Rate | ||||
| PARTY_WID | NUMBER | 38 | Party Wid to uniquely identify a record | DW_EB_X_EBS_COMMON_W_PARTY_D | ||
| PR_COLLECTOR_NAME | VARCHAR2 | 80 CHAR | Collector Name | |||
| RECCRLIMIT_AMT | NUMBER | 38,10 | Recurring Credit Limit Amount | |||
| ROW_WID | NUMBER | 38 | Surrogate key to uniquely identify a record | |||
| SITE_USE_ID | VARCHAR2 | 80 CHAR | Site Use Identifier. | |||
| 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. | |||
| TOTAL_CREDIT_LIMIT | NUMBER | 28,10 | Total Credit Limit of the Customer Profile. | |||
| TRX_CREDIT_LIMIT | NUMBER | 28,10 | Transaction Credit Limit Amount. | |||
| 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 |