| 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 | PERNR | Personnel Number | nvarchar | 8 | 0 | NUMC | (N'00000000') | No | | PERNR_D | Allow NULL? |
| 3 | REINR | Trip Number | nvarchar | 10 | 0 | NUMC | (N'0000000000') | No | | REINR | Allow NULL? |
| 4 | PERIO | Trip Period Number | nvarchar | 3 | 0 | NUMC | (N'000') | No | | PTRV_PEROD | Allow NULL? |
| 5 | PDVRS | Sequential Number of Period | nvarchar | 2 | 0 | NUMC | (N'00') | No | | PTRV_PDVRS | Allow NULL? |
| 6 | COMP_TYP | Comparison Calculation Type | nvarchar | 3 | 0 | CHAR | (N' ') | No | | PTRV_COMPKEY | Allow NULL? |
| 7 | COST_BAHN | Unreal trav. costs pub. transp. (PS) | decimal | 10 | 2 | CURR | ((0)) | Yes | | PTRV_TRANS | |
| 8 | COST_ZUSCHLAG | Unreal trav. costs pub. transp. (PS) | decimal | 10 | 2 | CURR | ((0)) | Yes | | PTRV_TRANS | |
| 9 | COST_NAHV | Unreal trav. costs pub. transp. (PS) | decimal | 10 | 2 | CURR | ((0)) | Yes | | PTRV_TRANS | |
| 10 | COST_SONSTV | Unreal trav. costs pub. transp. (PS) | decimal | 10 | 2 | CURR | ((0)) | Yes | | PTRV_TRANS | |
| 11 | NOTWEND_KM | Required Kilometers Traveled (Comparison Calculation) | decimal | 5 | 0 | DEC | ((0)) | Yes | | PTRV_NOTKM | |
| 12 | ERST_KM_FA | Reimbursement per KM (Comparison Calculation) | decimal | 10 | 2 | CURR | ((0)) | Yes | | PTRV_ERSTKM | |
| 13 | COST_WEG | Trip Segment Reimbursement Amount (Comparison Calculation) | decimal | 10 | 2 | CURR | ((0)) | Yes | | PTRV_WEGENTSCH | |
| 14 | COST_TAGEGELD | Total fictitious Per Diems (Comparison Calculation) | decimal | 10 | 2 | CURR | ((0)) | Yes | | PTRV_TAGEGELD | |
| 15 | COST_UNTERKUNFT | Fictitious Amount for Accommodation (Comparision Calc.) | decimal | 10 | 2 | CURR | ((0)) | Yes | | PTRV_UNTERKUNFT | |
| 16 | COST_GESAMT | Fictitious Total Amount (Comparison Calculation) | decimal | 10 | 2 | CURR | ((0)) | Yes | | PTRV_GESAMT | |
| 17 | COST_DIFF | Difference Between Fictious And Actual Total Amount | decimal | 10 | 2 | CURR | ((0)) | Yes | | PTRV_VGL_FA_DIFF | |
| 18 | WAERS | Currency Key | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | WAERS | Allow NULL? |
| 19 | DATV1 | Fictitious Start of Trip (Comparison Calculation | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | PTRV_REBED | Allow NULL? |
| 20 | DATB1 | Fictitious End of Trip (Comparision Calculation) | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | PTRV_REEND | Allow NULL? |
| 21 | UHRV1 | Fictitious Start Time (Comparison Calculation) | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | PTRV_REBEU | Allow NULL? |
| 22 | UHRB1 | Fictitious End Time (Comparison Calculation) | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | PTRV_REENU | Allow NULL? |
| 23 | PAUSCHALEN | Comparison Calculation: Include Per Diems/Accomm. Per Diems | char | 1 | 0 | CHAR | (N' ') | Yes | | PTRVPS_LUMPSUM | Allow NULL? |
| 24 | COST_WEG_REAL | Trip Segment Reimbursement Amount for Actual Trip | decimal | 10 | 2 | CURR | ((0)) | Yes | | PTRV_WEGENTSCH_REAL | |
| 25 | COST_FAHRT_REAL | Total Amount from Travel Cost Receipts (Public Transport) | decimal | 10 | 2 | CURR | ((0)) | Yes | | PTRV_TRANS_REAL | |
| 26 | COST_TAG_REAL | Total Per Diems for Actual Trip | decimal | 10 | 2 | CURR | ((0)) | Yes | | PTRV_TAGEGELD_REAL | |
| 27 | COST_UNTERK_REAL | Total Accommodations Per Diems (including Accomm. Receipts) | decimal | 10 | 2 | CURR | ((0)) | Yes | | PTRV_UNTERKUNFT_REAL | |
| 28 | COST_GESAMT_REAL | Actual Total Amount (Comparison Calculation) | decimal | 10 | 2 | CURR | ((0)) | Yes | | PTRV_GESAMT_REAL | |
| 29 | COMP_BELNR | Document Number for Capping Documents (Trips Home Only) | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | PTRV_COMP_BELNR | Allow NULL? |
| 30 | FIK_KM_DA | Number of Miles/Kilometers of Fictitious Trip to Start Work | decimal | 5 | 0 | DEC | ((0)) | Yes | | FIK_KM_DA | |
| 31 | ERST_KM_DA | Trip Segment Reimbursement of Fictitious Trip to Start Work | decimal | 10 | 2 | CURR | ((0)) | Yes | | ERST_KM_DA | |
| 32 | FIK_KM_DR | Number of Miles/Km of Fictitious Business Trip Return | decimal | 5 | 0 | DEC | ((0)) | Yes | | FIK_KM_DR | |
| 33 | ERST_KM_DR | Trip Segment Reimbursement of Fictitious Business Trip Retur | decimal | 10 | 2 | CURR | ((0)) | Yes | | ERST_KM_DR | |
| 34 | ERST_TRG_UEGELD | Amount of Accommodations Per Diem of Fictitious SAT | decimal | 10 | 2 | CURR | ((0)) | Yes | | ERST_TRG_UEGELD | |
| 35 | ERST_TTG_UEGELD | Amount of Accommodations Per Diem of Fictitious SAPD | decimal | 10 | 2 | CURR | ((0)) | Yes | | ERST_TTG_UEGELD | |
| 36 | ERST_DA_TG | Reimbursement Amount MPD of Fictitious Trip to Start Work | decimal | 10 | 2 | CURR | ((0)) | Yes | | ERST_DA_TG | |
| 37 | ERST_DA_UEGELD | Reimbursement Amount APD of Fictitious Trip to Start Work | decimal | 10 | 2 | CURR | ((0)) | Yes | | ERST_DA_UEGELD | |
| 38 | ERST_DR_TG | Reimbursement Amount MPD of Fictitious Business Trip Return | decimal | 10 | 2 | CURR | ((0)) | Yes | | ERST_DR_TG | |
