| 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 | NO_BRFT | Number of Breakfasts | decimal | 2 | 0 | DEC | ((0)) | Yes | | FRANZ | |
| 7 | COUNTRY | Trip Country / Trip Country Group | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | * | LNDGR | Allow NULL? |
| 8 | REGION | Trip Country/Trip Country Group/Trip Region | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | * | RGION | Allow NULL? |
| 9 | TT_COMSP | Trip Type: Enterprise-Specific | char | 1 | 0 | CHAR | (N' ') | Yes | * | BEREI | Allow NULL? |
| 10 | FROM_DATE | From Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | FRDAT | Allow NULL? |
| 11 | TO_DATE | To Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | TODAT | Allow NULL? |
| 12 | MULTIPLI | Number | decimal | 3 | 0 | DEC | ((0)) | Yes | | ERANZ | |
| 13 | DESCRIPT | Description | nvarchar | 50 | 0 | CHAR | (N' ') | Yes | | ERDES | Allow NULL? |
| 14 | LOCATION | Location | nvarchar | 50 | 0 | CHAR | (N' ') | Yes | | ERPLC | Allow NULL? |
| 15 | BUS_PURPO | Business Purpose | nvarchar | 50 | 0 | CHAR | (N' ') | Yes | | BUSPU | Allow NULL? |
| 16 | BUS_REASON | Business Partners | nvarchar | 50 | 0 | CHAR | (N' ') | Yes | | BUSRE | Allow NULL? |
| 17 | CCOMP | Code of Payment Card Company | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | CCOMP | Allow NULL? |
| 18 | C_DOC | Document Number of Credit Card Receipt | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | C_DOC | Allow NULL? |
| 19 | C_TXT | Delivered Description of a Credit Card Transaction | nvarchar | 50 | 0 | CHAR | (N' ') | Yes | | C_TXT | Allow NULL? |
| 20 | P_CTG | Provider Category | char | 1 | 0 | CHAR | (N' ') | Yes | | PROVIDER_CATEGORY | Allow NULL? |
| 21 | P_PRV | Provider Code | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | * | PROVIDER_CODE | Allow NULL? |
| 22 | P_DOC | Document Number of a (Paper) Document | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | P_DOC | Allow NULL? |
| 23 | N_STF | Number of Employees | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | CH_NO_STAFF | Allow NULL? |
| 24 | N_PTN | Number of Employees of Business Partners | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | CH_NO_PARTNERS | Allow NULL? |
| 25 | N_GST | Number of Additional Guests | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | CH_NO_GUESTS | Allow NULL? |
| 26 | ANZLU_DEC | Number of Lunches on Hotel Receipt | decimal | 3 | 0 | DEC | ((0)) | Yes | | PTRV_ANZLU_DEC | |
| 27 | ANZDI_DEC | Number of Dinners on Hotel Receipt | decimal | 3 | 0 | DEC | ((0)) | Yes | | PTRV_ANZDI_DEC | |
| 28 | BOOKED_PRICE | Booked Price from Travel Planning | decimal | 10 | 2 | CURR | ((0)) | Yes | | BOOKED_PRICE | |
| 29 | DIFF_AMOUNT | Difference Amount | decimal | 10 | 2 | CURR | ((0)) | Yes | | DIFF_AMOUNT | |
| 30 | DIFF_CURR | Currency of Difference Amount | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | DIFF_CURR | Allow NULL? |
| 31 | REASON | Reason for Difference | nvarchar | 50 | 0 | CHAR | (N' ') | Yes | | PTRV_REASON | Allow NULL? |
| 32 | AIR_DEPARTURE | IATA - Airport Location | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | * | AIR_LOCATION | Allow NULL? |
| 33 | AIR_ARRIVAL | IATA - Airport Location | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | * | AIR_LOCATION | Allow NULL? |
| 34 | AIRLINE | Airline | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | * | AIRLINE | Allow NULL? |
| 35 | AIR_CABIN_CLASS | Cabin Class | char | 1 | 0 | CHAR | (N' ') | Yes | | AIR_CABIN_CLASS | Allow NULL? |
| 36 | AIR_TIC_NUM | Ticket Number | nvarchar | 15 | 0 | CHAR | (N' ') | Yes | | PTRV_TICKET_NUMBER | Allow NULL? |
| 37 | CAR_ODO_READ | Odometer Mileage | nvarchar | 8 | 0 | NUMC | (N'00000000') | Yes | | CAR_ODOMETER_READING | Allow NULL? |
| 38 | SE_NAME | Name 1 | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | AD_NAME1 | Allow NULL? |
| 39 | SE_STREET | Street | nvarchar | 60 | 0 | CHAR | (N' ') | Yes | | AD_STREET | Allow NULL? |
| 40 | SE_CITY | City | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | AD_CITY1 | Allow NULL? |
| 41 | SE_STA_PROV | District (US: County) | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | SE_STATE_PROVINCE | Allow NULL? |
| 42 | SE_COUNTRY | Country of Vendor | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | * | SE_COUNTRY | Allow NULL? |
| 43 | SE_POSTAL_CODE | City postal code | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | AD_PSTCD1 | Allow NULL? |
| 44 | SE_CUST_SER_PH | Customer Service Telephone No. of Vendor | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | SE_CUSTOMER_SERVICE_PHONE | Allow NULL? |
