| 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 | RECEIPTNO | Document Number | nvarchar | 3 | 0 | CHAR | (N' ') | No | | NRBEL | Allow NULL? |
| 6 | SEQNO | Sequential number for receipts | nvarchar | 2 | 0 | NUMC | (N'00') | No | | PTRV_RECSEQNO | Allow NULL? |
| 7 | DED_FLAG | Deduction Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | BELAZ | Allow NULL? |
| 8 | PAID_COM | Paid by Company | char | 1 | 0 | CHAR | (N' ') | Yes | | BEZFA | Allow NULL? |
| 9 | EXP_TYPE | Travel Expense Type | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | SPKZL | Allow NULL? |
| 10 | REC_AMOUNT | Amount on Individual Receipt | decimal | 13 | 2 | CURR | ((0)) | Yes | | PTRV_REC_AMOUNT | |
| 11 | REC_CURR | Currency Key | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | WAERS | Allow NULL? |
| 12 | REC_RATE | Exchange rate | decimal | 9 | 5 | DEC | ((0)) | Yes | | REC_RATE | |
| 13 | LOC_AMOUNT | Receipt amount in local currency | decimal | 13 | 2 | CURR | ((0)) | Yes | | PTRV_LOC_AMOUNT | |
| 14 | LOC_CURR | Currency Key | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | WAERS | Allow NULL? |
| 15 | TAX_CODE | Tax on sales/purchases code | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | MWSKZ | Allow NULL? |
| 16 | REC_DATE | Receipt Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | BELDT | Allow NULL? |
| 17 | SHORTTXT | Short Receipt Information | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | TXBEL | Allow NULL? |
| 18 | ABOVE_LIMIT | Customizing Limit for Travel Expense Type Exceeded | char | 1 | 0 | CHAR | (N' ') | Yes | | PTRV_ABOVE_LIMIT | Allow NULL? |
| 19 | PAPER_RECEIPT | Paper Receipt Exists | char | 1 | 0 | CHAR | (N' ') | Yes | | PAPER_RECEIPT | Allow NULL? |
| 20 | RECEIPT_OK | Expense Receipt Checked | char | 1 | 0 | CHAR | (N' ') | Yes | | RECEIPT_VALIDATED | Allow NULL? |
| 21 | PAYOT | Service Provider | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | PAYOT | Allow NULL? |
| 22 | PAPER_MISSING | Required Paper Receipt Is Missing | char | 1 | 0 | CHAR | (N' ') | Yes | | PAPER_MISSING | Allow NULL? |
| 23 | RECEIPT_NO | Invoice Number of Original Receipt | nvarchar | 16 | 0 | CHAR | (N' ') | Yes | | PTRV_RECEIPT_NO | Allow NULL? |
| 24 | RECEIPT_ITEM | Number of Invoice Item | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | PTRV_RECEIPT_ITEM | Allow NULL? |
| 25 | REC_FWSTE | Tax amount in document currency | decimal | 13 | 2 | CURR | ((0)) | Yes | | WMWST | |
| 26 | LOC_FWSTE | Tax amount in document currency | decimal | 13 | 2 | CURR | ((0)) | Yes | | WMWST | |
| 27 | VAT_POSTING_TYPE | Reporting and Posting of VAT Amount | char | 1 | 0 | CHAR | (N' ') | Yes | | PTRV_VAT_POSTING_TYPE | Allow NULL? |
| 28 | VAT_SERVICE_CODE | VAT Refund Code | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | * | PTRV_VAT_SERVICE_CODE | Allow NULL? |
| 29 | VAT_SERVICE_DESC | Description of Goods and Services | nvarchar | 100 | 0 | CHAR | (N' ') | Yes | | PTRV_VAT_SERVICE_DESC | Allow NULL? |
| 30 | VAT_STATUS | Status of Data for VAT Refund | char | 1 | 0 | CHAR | (N' ') | Yes | | PTRV_VAT_STATUS | Allow NULL? |
| 31 | VAT_CHANGED_MAN | VAT Amount Changed Manually | char | 1 | 0 | CHAR | (N' ') | Yes | | PTRV_VAT_CHANGED_MAN | Allow NULL? |
| 32 | DIFF_VIOLATION | Maximum Difference Exceeded | char | 1 | 0 | CHAR | (N' ') | Yes | | DIFF_VIOLATION | Allow NULL? |
