| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | CLNT | (N'000') | No | T000 | MANDT | Allow NULL? |
| 2 | MOLGA | Country Grouping | nvarchar | 2 | 0 | CHAR | (N' ') | No | T500L | MOLGA | Allow NULL? |
| 3 | LGART | Wage Type | nvarchar | 4 | 0 | CHAR | (N' ') | No | | LGART | Allow NULL? |
| 4 | ENDDA | End Date | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | ENDDA | Allow NULL? |
| 5 | BEGDA | Start Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | BEGDA | Allow NULL? |
| 6 | GVBLA | Valuation basis | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | GVBLA | Allow NULL? |
| 7 | GVALA | Statement wage type | nvarchar | 4 | 0 | CHAR | (N' ') | No | T512W | GVALA | Allow NULL? |
| 8 | GVPRO | Percentage | decimal | 7 | 2 | DEC | ((0)) | No | | GVPRO | |
| 9 | PZBLA | Valuation basis | nvarchar | 2 | 0 | CHAR | (N' ') | No | | GVBLA | Allow NULL? |
| 10 | PZALA | Statement wage type | nvarchar | 4 | 0 | CHAR | (N' ') | No | T512W | GVALA | Allow NULL? |
| 11 | PZPRO | Percentage | decimal | 7 | 2 | DEC | ((0)) | No | | GVPRO | |
| 12 | FZBLA | Valuation basis | nvarchar | 2 | 0 | CHAR | (N' ') | No | | GVBLA | Allow NULL? |
| 13 | FZALA | Statement wage type | nvarchar | 4 | 0 | CHAR | (N' ') | No | T512W | GVALA | Allow NULL? |
| 14 | FZPRO | Percentage | decimal | 7 | 2 | DEC | ((0)) | No | | GVPRO | |
| 15 | VKLAS | Processing classes | nvarchar | 100 | 0 | CHAR | (N' ') | No | | VKLAS | Allow NULL? |
| 16 | KUMUL | Cumulation of gross amounts | varbinary | 12 | 0 | RAW | | Yes | | KUMUL | |
| 17 | D1AUS | RTE/NUM/AMT selection for average basis | varbinary | 1 | 0 | RAW | | Yes | | DSAUS | |
| 18 | D1KUM | Cumulations for average bases | varbinary | 4 | 0 | RAW | | Yes | | DSKUM | |
| 19 | D1PRO | Percentage for average bases | decimal | 7 | 2 | DEC | ((0)) | No | | DSPRO | |
| 20 | D2AUS | RTE/NUM/AMT selection for average basis | varbinary | 1 | 0 | RAW | | Yes | | DSAUS | |
| 21 | D2KUM | Cumulations for average bases | varbinary | 4 | 0 | RAW | | Yes | | DSKUM | |
| 22 | D2PRO | Percentage for average bases | decimal | 7 | 2 | DEC | ((0)) | Yes | | DSPRO | |
| 23 | D3AUS | RTE/NUM/AMT selection for average basis | varbinary | 1 | 0 | RAW | | Yes | | DSAUS | |
| 24 | D3KUM | Cumulations for average bases | varbinary | 4 | 0 | RAW | | Yes | | DSKUM | |
| 25 | D3PRO | Percentage for average bases | decimal | 7 | 2 | DEC | ((0)) | Yes | | DSPRO | |
| 26 | D4AUS | RTE/NUM/AMT selection for average basis | varbinary | 1 | 0 | RAW | | Yes | | DSAUS | |
| 27 | D4KUM | Cumulations for average bases | varbinary | 4 | 0 | RAW | | Yes | | DSKUM | |
| 28 | D4PRO | Percentage for average bases | decimal | 7 | 2 | DEC | ((0)) | Yes | | DSPRO | |
| 29 | D5AUS | RTE/NUM/AMT selection for average basis | varbinary | 1 | 0 | RAW | | Yes | | DSAUS | |
| 30 | D5KUM | Cumulations for average bases | varbinary | 4 | 0 | RAW | | Yes | | DSKUM | |
| 31 | D5PRO | Percentage for average bases | decimal | 7 | 2 | DEC | ((0)) | Yes | | DSPRO | |
| 32 | AKLAS | Evaluation classes | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | ASKLA | Allow NULL? |
