| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | PERNR | Personnel Number | nvarchar | 8 | 0 | | | | Allow NULL? |
| 3 | REINR | Trip Number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 4 | PLANNR | Travel Plan Number (Sequential Number) | nvarchar | 2 | 0 | | | | Allow NULL? |
| 5 | VARIANT | Plan variant number (sequential number) | nvarchar | 2 | 0 | | | | Allow NULL? |
| 6 | VARIANTVRS | Version of travel plan | nvarchar | 2 | 0 | | | | Allow NULL? |
| 7 | ITEM | Travel Request Item Number (Sequential Number) | nvarchar | 3 | 0 | | | | Allow NULL? |
| 8 | SERVICE | Travel service item number of flight | nvarchar | 3 | 0 | | | | Allow NULL? |
| 9 | MEAL_CODE | Preferred Meal on Flight | nvarchar | 4 | 0 | | | | Allow NULL? |
| 10 | FREQ_CODE | Provider to which the SSR refers | nvarchar | 3 | 0 | | | | Allow NULL? |
| 11 | HDCAP_CODE | Seating Request: Suitable for Challenged Person | char | 1 | 0 | | | | Allow NULL? |
| 12 | MEDIC_CODE | Seating Request: Medical Care | char | 1 | 0 | | | | Allow NULL? |
| 13 | MINOR_CODE | Seating requisition: unaccompanied minor | char | 1 | 0 | | | | Allow NULL? |
| 14 | INFANT_CODE | Seating requisition: child's seat | char | 1 | 0 | | | | Allow NULL? |
| 15 | AIRLINE_CODE | Airline | nvarchar | 3 | 0 | | | | Allow NULL? |
| 16 | STATUS_CODE | SSR status | nvarchar | 2 | 0 | | | | Allow NULL? |
| 17 | TEXT_INFO | Text description for an SSR element | nvarchar | 132 | 0 | | | | Allow NULL? |
| 18 | LINENUMBER | Line number of SSR in the itinerary | smallint | 5 | 0 | | | | |
| 19 | FREQ_CARD_CODE | SSR Frequent Flyer Affiliated Airline Code | nvarchar | 3 | 0 | | | | Allow NULL? |
| 20 | FREQ_CARD_USAGE | Type of Usage for Frequent Flyer Card | char | 1 | 0 | | | | Allow NULL? |
| 21 | FREQ_CARD_NUMBER | Frequent Flyer Card Number | nvarchar | 21 | 0 | | | | Allow NULL? |
| 22 | HDCAP_DESCR | Description of challenge | nvarchar | 120 | 0 | | | | Allow NULL? |
| 23 | MEDIC_DESCR | Description of medical care | nvarchar | 120 | 0 | | | | Allow NULL? |
| 24 | BLIND | Challenge: Blindness (for OSI information) | char | 1 | 0 | | | | Allow NULL? |
| 25 | DEAF | Challenge: Deafness (for OSI information) | char | 1 | 0 | | | | Allow NULL? |
