| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPFinancial Conditions |
1 | FICOC_COND | Condition Type | 3 | O_CONDTYPE | Condition Type | nvarchar | 6 | 0 | | |
2 | FICOC_COND_AMT | Assignment Condition Type - Amount Category | 3 | O_CONDTYPE | Condition Type | nvarchar | 6 | 0 | | |
3 | FICOC_COND_BDT | Define Condition Type - BDT | 3 | O_CONDTYPE | Condition Type | nvarchar | 6 | 0 | | |
4 | FICOC_COND_DATE | Assignment Condition Type - Deadline Category | 3 | O_CONDTYPE | Condition Type | nvarchar | 6 | 0 | | |
5 | FICOC_COND_DIFF | Assignment Condition Type - Differentiation | 3 | O_CONDTYPE | Condition Type | nvarchar | 6 | 0 | | |
6 | FICOC_COND_FMOD | Field Modifications for Condition Types | 3 | O_CONDTYPE | Condition Type | nvarchar | 6 | 0 | | |
7 | FICOC_COND_GUID | Condition Type: Assignment of GUID | 3 | O_CONDTYPE | Condition Type | nvarchar | 6 | 0 | | |
8 | FICOC_COND_OPRTR | Assignment of Condition Category to Formula Operator | 4 | O_CONDTYPE | Condition Type | nvarchar | 6 | 0 | | |
9 | FICOC_COND_T | Texts for Condition Type | 4 | O_CONDTYPE | Condition Type | nvarchar | 6 | 0 | | |
10 | FICOC_COND_USER | Condition Type: User Information | 3 | O_CONDTYPE | Condition Type | nvarchar | 6 | 0 | | |
11 | FICOC_LIST_COND | Assignment Conditon Group Type (List Type) - Condition Type | 4 | O_CONDTYPE | Condition Type | nvarchar | 6 | 0 | | |
12 | FICOT_COND | Conditions (Obsolete; Not used for persistency) | 3 | O_CONDTYPE | Condition Type | nvarchar | 6 | 0 | | |
13 | FICOT_CONDI | Conditions (Unbuffered) | 7 | O_CONDTYPE | Condition Type | nvarchar | 6 | 0 | | |
14 | FICOT_CONDI_BUFF | Conditions (Buffered) | 7 | O_CONDTYPE | Condition Type | nvarchar | 6 | 0 | | |
15 | FICOT_CTRL_MAINT | Condition Set of Rules | 5 | O_CONDTYPE | Condition Type | nvarchar | 6 | 0 | | |