Version: 1.0
| Attribute ID | Datatype | Data length | Nullabe ? | Label | Description |
|---|---|---|---|---|---|
| CATALOG_CURRENCY_CODE | VARCHAR2 | 3 | Y | Currency code of catalog | |
| CONTACT_ID | NUMBER | 22 | Y | Contact Id | Contact technical identifier |
| INFORMATION_KIND | VARCHAR2 | 4000 | Y | Translated value of T_INFORMATION_KIND. Possible values are: - Financial information - Authorizations - Criterion - Indicator - Loyalty program - Note |
|
| INFORMATION_NAME | VARCHAR2 | 4000 | Y | Identifies exactly, by means of a name, the information provided by the current record. Possible values depend on the information kind. If KIND = FINANCIAL: - Pending account allowed - Pending account balance - Max outstanding balance - Credit note balance - Prospect - Agreement reference - Agreement signing date If KIND = AUTHORIZATION, translated value of INTERNAL_NAME_IC If KIND = CRITERION, criterion name If KIND = INDICATOR, indicator name If KIND = LOYALTY: - LOYALTY_BALANCE - LOYALTY_CURRENCY - VALUE_BALANCE - VALUE_CURRENCY If KIND = NOTE: - NOTE |
|
| INFORMATION_RANK | NUMBER | 22 | Y | The rank is only computed if the current row matches a contact criterion with a set of predefined values (i.e. criterion elements). The rank is then equal to the rank of the contact criterion element. Otherwise, the rank is set to 1. | |
| INFORMATION_VALUE_1 | VARCHAR2 | 4000 | Y | The value stored depends on the information kind - FINANCIAL -> amount matching the information name - AUTHORIZATION -> indication whether authorization is allowed or not - CRITERION -> code of criterion element (if criterion has criterion elements) or criterion value (if no criterion elements defined) - INDICATOR -> level of indicator - LOVALTY -> amount (or other information) matching the information name - NOTE -> Subject |
|
| INFORMATION_VALUE_2 | VARCHAR2 | 4000 | Y | The value stored depends on the information kind - FINANCIAL -> amount matching the information name - AUTHORIZATION -> indication whether authorization is allowed or not - CRITERION -> internal name of criterion element (if criterion has criterion elements) or criterion value (if no criterion elements defined) - INDICATOR -> value of indicator - LOVALTY -> amount (or other information) matching the information name - NOTE -> Comment |
|
| INSTIT_CODE | VARCHAR2 | 15 | Y | Institution code | |
| LAST_MODIFIED | TIMESTAMP(6) WITH TIME ZONE | 13 | Y | Date time of last modification of the information contained in current record. All the financial information of a current contact for a given organization have always the same modification date. | |
| LAST_UPDATE | TIMESTAMP(6) WITH TIME ZONE | 13 | Y | Date of last update of report data | |
| ORGANIZATION | VARCHAR2 | 240 | Y | Organization | Organization name |
| ORGANIZ_ID | NUMBER | 22 | Y | Technical identifier of guide organization | |
| T_INFORMATION_CODE | NVARCHAR2 | 4000 | Y | Identifies exactly, by means of a code, the information provided by the current record. Possible values depend on the information kind. If KIND = FINANCIAL: - WAITING_ACCOUNT_ALLOWED - WAITING_ACCOUNT_BALANCE - MAX_OUTSTANDING_BALANCE - CRDIT_NOTE_BALANCE - PROSPECT - AGREEMENT_REFERENCE - AGREEMENT_SIGNING_DATE If KIND = AUTHORIZATION, authorization code If KIND = CRITERION, criterion code If KIND = INDICATOR, indicator code If KIND = LOYALTY: - LOYALTY_BALANCE - LOYALTY_CURRENCY - VALUE_BALANCE - VALUE_CURRENCY If (KIND = NOTE) - NOTE |
|
| T_INFORMATION_KIND | NVARCHAR2 | 40 | Y | Kind of information provided by the current record. Possible values are: - FINANCIAL - AUTHORIZATION - CRITERION - INDICATOR - LOYALTY - NOTE |