| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
|---|
| TOP09E: Expense Reimbursment |
| 1 | F20112 | Expense Report Detail | 26 | ED | TICKSTA | Airline Ticket Status | String | UDC | 3 | 0 |
User Defined Codes are, by design, customisable and thus will differ from system to system depending on the business requirements.
TOPUDC 09E / TS (Airline Ticket Status) stock values
| Value | Description | Special Handling Code | Hard Coded |
|---|
| 1 | | . | | N |
| 2 | ADV | Advanced Purchase | | N |
| 3 | CRE | Airline Credit | | N |
| 4 | CXL | Cancelled | | N |
| 5 | FUL | Fully Used | | N |
| 6 | IS | Issued | | N |
| 7 | PAR | Partially Used | | N |
| 8 | RES | Reservation Booked | | N |
| 9 | VCH | Airline Voucher | | N |
