| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPFinancial Conditions |
1 | FICOB_AMT_FCNTR | OBSOLETE DONT USE | 1 | O_APPL | Application | nvarchar | 6 | 0 | | |
2 | FICOB_APPL | Application | 1 | O_APPL | Application | nvarchar | 6 | 0 | | |
3 | FICOB_APPL_COND | Application Assignment - Condition Category | 1 | O_APPL | Application | nvarchar | 6 | 0 | | |
4 | FICOB_APPL_LIST | Application Assignment - Condition Group Category | 1 | O_APPL | Application | nvarchar | 6 | 0 | | |
5 | FICOB_APPL_T | Texts on Application | 2 | O_APPL | Application | nvarchar | 6 | 0 | | |
6 | FICOB_CALCCATG | Calculation Category | 1 | O_APPL | Application | nvarchar | 6 | 0 | | |
7 | FICOB_CALCCATG_T | Texts for Calculation Category | 2 | O_APPL | Application | nvarchar | 6 | 0 | | |
8 | FICOB_COND_FIE | OBSOLETE DONT USE | 1 | O_APPL | Application | nvarchar | 6 | 0 | | |
9 | FICOB_DATE_FCNTR | OBSOLETE DONT USE | 1 | O_APPL | Application | nvarchar | 6 | 0 | | |
10 | FICOB_FCTRL_AMT | Field for Assignment of Amount Category | 1 | O_APPL | Application | nvarchar | 6 | 0 | | |
11 | FICOB_FCTRL_COND | Condition Header Assignment - Field | 1 | O_APPL | Application | nvarchar | 6 | 0 | | |
12 | FICOB_FCTRL_DATE | Date Category Assignment - Field | 1 | O_APPL | Application | nvarchar | 6 | 0 | | |
13 | FICOB_FOREIGN | Data from External Applications | 1 | O_APPL | Application | nvarchar | 6 | 0 | | |
14 | FICOC_BASEREF | Texts of Base References | 2 | O_APPL | Application | nvarchar | 6 | 0 | | |
15 | FICOC_BASEREF_T | Texts of Base References | 3 | O_APPL | Application | nvarchar | 6 | 0 | | |
16 | FICOC_COND | Condition Type | 2 | O_APPL | Application | nvarchar | 6 | 0 | | |
17 | FICOC_COND_AMT | Assignment Condition Type - Amount Category | 2 | O_APPL | Application | nvarchar | 6 | 0 | | |
18 | FICOC_COND_BDT | Define Condition Type - BDT | 2 | O_APPL | Application | nvarchar | 6 | 0 | | |
19 | FICOC_COND_DATE | Assignment Condition Type - Deadline Category | 2 | O_APPL | Application | nvarchar | 6 | 0 | | |
20 | FICOC_COND_DIFF | Assignment Condition Type - Differentiation | 2 | O_APPL | Application | nvarchar | 6 | 0 | | |
21 | FICOC_COND_FMOD | Field Modifications for Condition Types | 2 | O_APPL | Application | nvarchar | 6 | 0 | | |
22 | FICOC_COND_GUID | Condition Type: Assignment of GUID | 2 | O_APPL | Application | nvarchar | 6 | 0 | | |
23 | FICOC_COND_OPRTR | Assignment of Condition Category to Formula Operator | 3 | O_APPL | Application | nvarchar | 6 | 0 | | |
24 | FICOC_COND_T | Texts for Condition Type | 3 | O_APPL | Application | nvarchar | 6 | 0 | | |
25 | FICOC_COND_USER | Condition Type: User Information | 2 | O_APPL | Application | nvarchar | 6 | 0 | | |
26 | FICOC_FOREIGN | Data from External Applications | 2 | O_APPL | Application | nvarchar | 6 | 0 | | |
27 | FICOC_LIST | Condition Group Type (List Type) | 2 | O_APPL | Application | nvarchar | 6 | 0 | | |
28 | FICOC_LIST_COND | Assignment Conditon Group Type (List Type) - Condition Type | 2 | O_APPL | Application | nvarchar | 6 | 0 | | |
29 | FICOC_LIST_T | Texts for Condition Group Type (List Type) | 2 | O_APPL | Application | nvarchar | 6 | 0 | | |
30 | FICOC_PCALCREF | Interest Penalty Calculation Method | 2 | O_APPL | Application | nvarchar | 6 | 0 | | |
31 | FICOC_PCALCREF_T | Text for Interest Penalty Calculation Method | 3 | O_APPL | Application | nvarchar | 6 | 0 | | |
32 | FICOT_CONDI | Conditions (Unbuffered) | 6 | O_APPL | Application | nvarchar | 6 | 0 | | |
33 | FICOT_CONDI_BUFF | Conditions (Buffered) | 6 | O_APPL | Application | nvarchar | 6 | 0 | | |
34 | FICOT_LIST | Condition List | 4 | O_APPL | Application | nvarchar | 6 | 0 | | |