| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | MOLGA | Country Grouping | nvarchar | 2 | 0 | | | | Allow NULL? |
| 3 | MODSZ | Modifier for special payment | nvarchar | 4 | 0 | | | | Allow NULL? |
| 4 | LGART | Wage type | nvarchar | 4 | 0 | | | | Allow NULL? |
| 5 | ENDDA | End Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 6 | BEGDA | Start Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 7 | SZVAR | Special payment variant | nvarchar | 2 | 0 | | | | Allow NULL? |
| 8 | VERIV | Type of entitlement period | char | 1 | 0 | | | | Allow NULL? |
| 9 | BEGVR | Begin of entitlement period | nvarchar | 2 | 0 | | | | Allow NULL? |
| 10 | DAUVR | Duration of entitlement period | nvarchar | 2 | 0 | | | | Allow NULL? |
| 11 | AUSZL | Payment I | nvarchar | 2 | 0 | | | | Allow NULL? |
| 12 | WZTAZ | Waiting period in days for payment I | decimal | 4 | 0 | | | | |
| 13 | RESTZ | Payment II | nvarchar | 2 | 0 | | | | Allow NULL? |
| 14 | WZTRZ | Waiting period in days for payment II | decimal | 4 | 0 | | | | |
| 15 | WZTSZ | Waiting period in days for payment | decimal | 3 | 0 | | | | |
| 16 | VORGB | Advance condition | char | 1 | 0 | | | | Allow NULL? |
| 17 | JABGR | Delimitation of annual waiting period for new employees | char | 1 | 0 | | | | Allow NULL? |
| 18 | RUND1 | Calculation basis for entitlement | char | 1 | 0 | | | | Allow NULL? |
| 19 | RUND2 | Rounding provision | char | 1 | 0 | | | | Allow NULL? |
| 20 | SONDE | Special payment provision | char | 1 | 0 | | | | Allow NULL? |
| 21 | B530C | Modifier for exception requirements | nvarchar | 3 | 0 | | | | Allow NULL? |
| 22 | D530C | Modifier for factors related to length of service | nvarchar | 3 | 0 | | | | Allow NULL? |
| 23 | L530C | 3-Byte field | nvarchar | 3 | 0 | | | | Allow NULL? |
| 24 | T530D | NN | char | 1 | 0 | | | | Allow NULL? |
| 25 | DATAR | Date type | nvarchar | 2 | 0 | | | | Allow NULL? |
| 26 | BAAAZ | Amount-Based Adjustment I | char | 1 | 0 | | | | Allow NULL? |
| 27 | BAVRZ | Amount-Based Adjustment II | char | 1 | 0 | | | | Allow NULL? |
| 28 | BAEVP | Amount-based adjustment at end of clearing period | char | 1 | 0 | | | | Allow NULL? |
| 29 | SOLGA | Not More Closely Defined Area, Possibly Used for Patchlevels | nvarchar | 4 | 0 | | | | Allow NULL? |
| 30 | PKSYM | Char 20 | nvarchar | 20 | 0 | | | | Allow NULL? |
| 31 | BWGR1 | Technical standard wage type | nvarchar | 4 | 0 | | | | Allow NULL? |
| 32 | BWGR2 | Not More Closely Defined Area, Possibly Used for Patchlevels | nvarchar | 4 | 0 | | | | Allow NULL? |
| 33 | LGAR2 | NN | nvarchar | 4 | 0 | | | | Allow NULL? |
| 34 | SOLG2 | NN | nvarchar | 4 | 0 | | | | Allow NULL? |
| 35 | T530L | Single-Character Indicator | char | 1 | 0 | | | | Allow NULL? |
| 36 | BWGG1 | Valuation I | nvarchar | 2 | 0 | | | | Allow NULL? |
| 37 | BWGG2 | Valuation II | nvarchar | 2 | 0 | | | | Allow NULL? |