| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | V_LGART | Interval wage type DK | nvarchar | 4 | 0 | | | | Allow NULL? |
| 3 | B_LGART | Wage type to interval DK | nvarchar | 4 | 0 | | | | Allow NULL? |
| 4 | R_LGART | Import 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 | ACCUM | Indicator: Wage type cumulation (DK) | char | 1 | 0 | | | | Allow NULL? |
| 8 | ISPLT | Indicator: Import Relevant for Split | char | 1 | 0 | | | | Allow NULL? |
| 9 | DEF | Definition of wage type +/- sign in PBS DK | char | 1 | 0 | | | | Allow NULL? |
| 10 | FORM2 | Indicator: Send FORM2 for Wage Type Definition DK | char | 1 | 0 | | | | Allow NULL? |
| 11 | FMCOD | Key for PBS Forms (DK) | nvarchar | 2 | 0 | | | | Allow NULL? |
| 12 | FORMX | Indicator: FORM X - Special Payout Days DK | char | 1 | 0 | | | | Allow NULL? |
| 13 | S_LGART | Balance wage type | nvarchar | 4 | 0 | | | | Allow NULL? |
| 14 | D_LGART | Deduction wage type DK | nvarchar | 4 | 0 | | | | Allow NULL? |
| 15 | ANTAL | Indicator: Entry in FORM 22A, field: Antal (DK) | char | 1 | 0 | | | | Allow NULL? |
| 16 | TIMER | Indicator: Entry for 'Timer' field FORM 22A (DK) | char | 1 | 0 | | | | Allow NULL? |
| 17 | P09_PBSBET | PBS wage type definition: Transfer amount/rate/number values | nvarchar | 3 | 0 | | | | Allow NULL? |
| 18 | P09_PBSREG | PBS wage type must be activated | char | 1 | 0 | | | | Allow NULL? |
| 19 | VTNUM | Value transfer type for SAP field number | char | 1 | 0 | | | | Allow NULL? |
| 20 | VTRTE | Value transfer type for SAP rate field | char | 1 | 0 | | | | Allow NULL? |
| 21 | VTAMT | Value transfer type for SAP field amount | char | 1 | 0 | | | | Allow NULL? |
| 22 | WONCE | Indicator: Wage type is only sent once per payroll period | char | 1 | 0 | | | | Allow NULL? |
| 23 | CUSTO | Wage Type Can Be Modified to Customer Needs at PBS | char | 1 | 0 | | | | Allow NULL? |
| 24 | FAILT | FA Statistics: IL Type of Wage Type in PBS | nvarchar | 4 | 0 | | | | Allow NULL? |
| 25 | DAILT | DA Statistics: IL Type in PBS | nvarchar | 4 | 0 | | | | Allow NULL? |
| 26 | FAAPT | FA Statistics: Key for Bonus Type | nvarchar | 2 | 0 | | | | Allow NULL? |
| 27 | LGREG | Wage Type Applied in Original Payroll Period | nvarchar | 4 | 0 | | | | Allow NULL? |
| 28 | LGSPC | Wage Type Applied in Retroactive Periods | nvarchar | 4 | 0 | | | | Allow NULL? |
| 29 | CTTAX | Wage Type Contributes to Tax Basis | char | 1 | 0 | | | | Allow NULL? |
| 30 | CTAMB | Wage Type Contributes to LMC Basis | char | 1 | 0 | | | | Allow NULL? |
| 31 | CTLON | Wage Type Contributes to Basis for Total Wages Deduction | char | 1 | 0 | | | | Allow NULL? |
| 32 | CTVC1 | Wage Type Contributes to Leave Savings (Accumulator 37) | char | 1 | 0 | | | | Allow NULL? |
| 33 | CTVC2 | Wage Type Contributes to Leave Saving 2 (accumulator 38) | char | 1 | 0 | | | | Allow NULL? |
| 34 | CTVC3 | Wage Type Contributes to Leave Saving 3 (Accumulator 36) | char | 1 | 0 | | | | Allow NULL? |
| 35 | CTBTX | Wage Type Contributes to B Tax Basis | char | 1 | 0 | | | | Allow NULL? |
| 36 | CTATP | Wage Type Contributes to ATP Basis/is Used as ATP Hour | char | 1 | 0 | | | | Allow NULL? |
| 37 | TAXFD | Field for Tax Return | nvarchar | 2 | 0 | | | | Allow NULL? |
