| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPBasic Functions |
1 | T850 | Company data for Consolidation | 23 | AFTYP | Additional field category | nvarchar | 4 | 0 | | |
2 | T85S1 | FI-LC: Assignment of first add. fld to second add. fld | 2 | AFTYP | Additional field category | nvarchar | 4 | 0 | | |
3 | T85S2 | FI-LC: Assignment of second add. fld to third add. fld | 2 | AFTYP | Additional field category | nvarchar | 4 | 0 | | |
4 | T85Y | Additional Field Category | 2 | AFTYP | Additional field category | nvarchar | 4 | 0 | | |
5 | T85YT | Additional field type: Texts | 3 | AFTYP | Additional field category | nvarchar | 4 | 0 | | |
TOPPayroll General Parts |
6 | T52GK | General gross and net | 3 | AFTYP | Type of affecting the gross/net | nvarchar | 1 | 0 | | |
7 | T52GL | Definitions of types affecting the gross and net | 2 | AFTYP | Type of affecting the gross/net | nvarchar | 1 | 0 | | |
8 | T52GLT | Descriptions of types for affecting the gross and net | 3 | AFTYP | Type of affecting the gross/net | nvarchar | 1 | 0 | | |
9 | T52GM | Adjustments to the gross and net | 4 | AFTYP | Type of affecting the gross/net | nvarchar | 1 | 0 | | |