| 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 | * | MANDT | Allow NULL? |
| 2 | GRPVP | Vacation pay employee grouping | nvarchar | 2 | 0 | CHAR | (N' ') | No | | PCA_GRPVP | Allow NULL? |
| 3 | ENDDA | End Date | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | ENDDA | Allow NULL? |
| 4 | BEGDA | Start Date | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | BEGDA | Allow NULL? |
| 5 | PCNTC | Percentage of vacationable earnings defined by comp. policy | decimal | 5 | 3 | DEC | ((0)) | Yes | | PCA_PCNTC | |
| 6 | PCNTP | Percentage of vacationable earnings to be paid every period | decimal | 5 | 3 | DEC | ((0)) | Yes | | PCA_PCNTP | |
| 7 | LVTYP | Quota/Leave type | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | PCA_LVTVP | Allow NULL? |
| 8 | LVTP1 | Quota/Leave type | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | PCA_LVTVP | Allow NULL? |
| 9 | LVTP2 | Quota/Leave type | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | PCA_LVTVP | Allow NULL? |
| 10 | LVTP3 | Quota/Leave type | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | PCA_LVTVP | Allow NULL? |
| 11 | LVTP4 | Quota/Leave type | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | PCA_LVTVP | Allow NULL? |
| 12 | LVTP5 | Quota/Leave type | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | PCA_LVTVP | Allow NULL? |
| 13 | LVTPA | Leave type for carry over from preceding vacation year | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | PCA_LVTCO | Allow NULL? |
| 14 | LVTPB | Leave type for carry over from preceding vacation year | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | PCA_LVTCO | Allow NULL? |
| 15 | LVTPC | Leave type for carry over from preceding vacation year | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | PCA_LVTCO | Allow NULL? |
| 16 | PAYIV | Accrual/Payout of vacation pay upon end of vacation year | char | 1 | 0 | CHAR | (N' ') | Yes | | PCA_PAYIV | Allow NULL? |
| 17 | PAYIT | Payout of vacation pay upon employee termination | char | 1 | 0 | CHAR | (N' ') | Yes | | PCA_PAYIT | Allow NULL? |
| 18 | GRPWT | Vacation pay wage type grouping | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | T5KV2 | PCA_GWTVP | Allow NULL? |
| 19 | GRPAY | Vacation pay accrual year grouping | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | T5KV3 | PCA_GAYVP | Allow NULL? |
| 20 | CMPAI | Vacation pay accrual formula | char | 1 | 0 | CHAR | (N' ') | Yes | | PCA_CMPAI | Allow NULL? |
| 21 | VALBS | Quota/Leave valuation base | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | PCA_LVVBS | Allow NULL? |
| 22 | ABSTY | Vacation pay indicator: Quota or Leave | char | 1 | 0 | CHAR | (N' ') | Yes | | PCA_ABSTY | Allow NULL? |
