| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
|---|
| 1 | LAND | Identification of Country or Federal State | nvarchar | 6 | 0 | CHAR | (N' ') | No | | PTRVPS_LAND | Allow NULL? |
| 2 | REGEL_NR | Rule Number in Decision Table for Reduction | nvarchar | 3 | 0 | NUMC | (N'000') | No | | PTRVPS_REGEL_NR | Allow NULL? |
| 3 | BEG_DATE | Start Date | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | BEGDA | Allow NULL? |
| 4 | END_DATE | End Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | ENDDA | Allow NULL? |
| 5 | D_GESKZ_OLD | Old Attribute of Statutory Trip Type (Parameter of Rule) | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | | PTRVPS_D_GES_OLD | Allow NULL? |
| 6 | GESKZ_NEW | New Attribute of Statutory Trip Type if Rule Is Fulfilled | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | | PTRVPS_D_GES_NEW | Allow NULL? |
| 7 | D_ABZUG_FRSTK | Decision Value for Checkbox Breakfast Deduction | char | 1 | 0 | CHAR | (N' ') | Yes | | PTRVPS_D_ABZ_FRK | Allow NULL? |
| 8 | D_ABZUG_MITAG | Decision Value for Checkbox Lunch Deduction | char | 1 | 0 | CHAR | (N' ') | Yes | | PTRVPS_D_ABZ_MIT | Allow NULL? |
| 9 | D_ABZUG_ABEND | Decision Value for Checkbox Dinner Deduction | char | 1 | 0 | CHAR | (N' ') | Yes | | PTRVPS_D_ABZ_ABD | Allow NULL? |
| 10 | D_ABZUG_UEBERN | Decision Value for Checkbox Overnight Stay Deduction | char | 1 | 0 | CHAR | (N' ') | Yes | | PTRVPS_D_ABZ_UEB | Allow NULL? |
| 11 | D_ENTGELT_UEBERN | Chargeable Overnight During Current Absence | char | 1 | 0 | CHAR | (N' ') | Yes | | PTRVPS_D_ENTG_UEB | Allow NULL? |
| 12 | D_ABWH_ART | Decision or Specification for Absences | char | 1 | 0 | CHAR | (N' ') | Yes | | PTRVPS_D_ABWH_ART | Allow NULL? |
| 13 | D_TRG_PARTNER | Decision Value for Separation Allowance of Spouse | char | 1 | 0 | CHAR | (N' ') | Yes | | PTRVPS_D_TRG_PAT | Allow NULL? |
| 14 | D_TR_REISEGELD | Decision Value for Separation Allowance for Travel | char | 1 | 0 | CHAR | (N' ') | Yes | | PTRVPS_D_TR_REISEGELD | Allow NULL? |
| 15 | D_ABWH_GANZTAG | Full-Day Absence | char | 1 | 0 | CHAR | (N' ') | Yes | | PTRVPS_D_ABWH_GANZT | Allow NULL? |
| 16 | D_VERGL_TR_AV | Edit SA Period for Comparison Calculation DR vs. ES | char | 1 | 0 | CHAR | (N' ') | Yes | | PTRVPS_D_VERGL_TR_AV | Allow NULL? |
