| 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 | SEQNO | Sequential number for trip totals | nvarchar | 2 | 0 | NUMC | (N'00') | No | | PTRV_SHDRSEQNO | Allow NULL? |
| 6 | ADDIT_AMNT | Additional Amount of a Trip (Taxable for Employee) | decimal | 13 | 2 | CURR | ((0)) | Yes | | PTRV_ADDIT_AMNT | |
| 7 | SUM_REIMBU | Reimbursement amount for a trip | decimal | 13 | 2 | CURR | ((0)) | Yes | | PTRV_SUM_REIMBU | |
| 8 | SUM_ADVANC | Total Advances for a Trip | decimal | 13 | 2 | CURR | ((0)) | Yes | | PTRV_SUM_ADVANC | |
| 9 | SUM_PAYOUT | Payment Amount | decimal | 13 | 2 | CURR | ((0)) | Yes | | PTRV_SUM_PAYOUT | |
| 10 | SUM_PAIDCO | Travel Expenses Paid by Company | decimal | 13 | 2 | CURR | ((0)) | Yes | | PTRV_SUM_PAIDCO | |
| 11 | TRIP_TOTAL | Total Cost of Trip | decimal | 13 | 2 | CURR | ((0)) | Yes | | PTRV_TRIP_TOTAL | |
| 12 | PD_FOOD | Reimbursement Amount (Total) for Meals per Diems | decimal | 13 | 2 | CURR | ((0)) | Yes | | PTRV_PD_FOOD | |
| 13 | PD_HOUSING | Reimbursement Amount (Total) for Accommodations per Diems | decimal | 13 | 2 | CURR | ((0)) | Yes | | PTRV_PD_HOUSING | |
| 14 | PD_MILEAGE | Reimbursement Amount (Total) for Travel Flat Rates | decimal | 13 | 2 | CURR | ((0)) | Yes | | PTRV_PD_MILEAGE | |
| 15 | CURRENCY | Currency Key | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | TRVWAERS | Allow NULL? |
| 16 | M_TOTAL | Total Miles/Kilometers | decimal | 5 | 0 | DEC | ((0)) | Yes | | KMGES | |
| 17 | TRIPDUR | Trip Duration in Days | decimal | 4 | 0 | DEC | ((0)) | Yes | | PTRV_TRIPDUR | |
| 18 | CHNGDATE | Changed On | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | AEDAT | Allow NULL? |
| 19 | CHNGTIME | Time of Last Change | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | AEUHR | Allow NULL? |
| 20 | TXF_FOOD | Total of Tax-Exempt Paid Meals per Diems | decimal | 13 | 2 | CURR | ((0)) | Yes | | PTRV_TXF_FOOD | |
| 21 | PD_POCKET_MON | Total Reimbursement Amount for Pocket Money | decimal | 13 | 2 | CURR | ((0)) | Yes | | GLO_PTRV_PD_POCKET_MONEY | |
| 22 | PD_PUB_TRANS | Total Reimbursement Amount for Public Transport | decimal | 13 | 2 | CURR | ((0)) | Yes | | GLO_PTRV_PD_PUBLIC_TRANS | |
| 23 | PD_LOC_TRANS | Total Reimbursement Amount for Local Transport | decimal | 13 | 2 | CURR | ((0)) | Yes | | GLO_PTRV_PD_LOCAL_TRANS | |
| 24 | PTRV_TAX_COMP | Total Amount Taxation by Employer | decimal | 23 | 4 | DEC | ((0)) | Yes | | TAXCOMP | |
