| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | T77PAYKZN1 | Reference Text table of wage codes | 3 | WCODE | Wage Type Code | nvarchar | 8 | 0 | | |
2 | T77PAYKZN2 | Assigment Wage Type to Wage Code | 2 | WCODE | Wage Type Code | nvarchar | 8 | 0 | | |
3 | T77PAYKZN8 | Wage Code Assignment to Report | 3 | WCODE | Wage Type Code | nvarchar | 8 | 0 | | |
4 | T77PAYKZNC | Reference table of wage codes | 2 | WCODE | Wage Type Code | nvarchar | 8 | 0 | | |
5 | T77PAYKZ_99FF | Kazakh addition to DAQ Field definition | 7 | WCODE | Wage Type Code | nvarchar | 8 | 0 | | |
6 | T77PAYKZ_99FFC | Kazakh addition to DAQ Field definition (Customer's) | 7 | WCODE | Wage Type Code | nvarchar | 8 | 0 | | |
7 | T7RUN1 | Reference table of wage codes | 3 | WCODE | Wage Type Code | nvarchar | 8 | 0 | | |
8 | T7RUN2 | Assigment wage type to wage code (obsolete) | 3 | WCODE | Wage Type Code | nvarchar | 8 | 0 | | |
9 | T7RUN2EXT | Assigment wage type to wage code(extension) | 4 | WCODE | Wage Type Code | nvarchar | 8 | 0 | | |
10 | T7RUN4 | Cumulation wage codes | 4 | WCODE | Wage Type Code | nvarchar | 8 | 0 | | |
11 | T7RUN6 | Grouping of wage codes | 2 | WCODE | Wage Type Code | nvarchar | 8 | 0 | | |
12 | T7RUN7 | Tax Privileges | 5 | WCODE | Wage Type Code | nvarchar | 8 | 0 | | |
13 | T7RUN8 | Assignment wage's groups & codes to reports | 3 | WCODE | Wage Type Code | nvarchar | 8 | 0 | | |
14 | T7RUNC | Reference table of wage codes | 2 | WCODE | Wage Type Code | nvarchar | 8 | 0 | | |
15 | T7RUNP | Wage Code Postprocessing | 3 | WCODE | Wage Type Code | nvarchar | 8 | 0 | | |
TOPPayroll |
16 | T7UAF231 | Form 23 rows | 5 | WCODE | Wage Type Code | nvarchar | 8 | 0 | | |
17 | T7UAN1 | Reference table of wage codes | 3 | WCODE | Wage Type Code | nvarchar | 8 | 0 | | |
18 | T7UAN1T | Reference table of wage codes | 4 | WCODE | Wage Type Code | nvarchar | 8 | 0 | | |
19 | T7UAN1_WTR | Define fields to display at Wage Type Reporter(HUACFP49) | 3 | WCODE | Wage Type Code | nvarchar | 8 | 0 | | |
20 | T7UAN2 | Assigment wage type to wage code | 3 | WCODE | Wage Type Code | nvarchar | 8 | 0 | | |
21 | T7UAN6 | Grouping of wage codes | 3 | WCODE | Wage Type Code | nvarchar | 8 | 0 | | |
22 | T7UAN8 | Assignment wage's groups & codes to Application | 5 | WCODE | Wage Type Code | nvarchar | 8 | 0 | | |
23 | T7UAQ1 | Quarterly Reports Cumulations | 4 | WCODE | Wage Type Code | nvarchar | 8 | 0 | | |
24 | T7UA_99FF | Ukranian addition to DAQ Field definition | 7 | WCODE | Wage Type Code | nvarchar | 8 | 0 | | |
25 | T7UA_99FFC | Ukranian addition to DAQ Field definition (Customer's) | 7 | WCODE | Wage Type Code | nvarchar | 8 | 0 | | |
TOPRussia |
26 | T7RU_99FF | Russian addition to DAQ Field definition | 7 | WCODE | Wage Type Code | nvarchar | 8 | 0 | | |
27 | T7RU_99FFC | Russian addition to DAQ Field definition (Customer's) | 7 | WCODE | Wage Type Code | nvarchar | 8 | 0 | | |