| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPTravel Planning |
| 1 | FTPT_IMR_CAR | IMR - Car Rental | 24 | CONF_NUMBER | Confirmation Code returned after Hotel reservation | nvarchar | 20 | 0 | | |
| 2 | FTPT_IMR_HTL | IMR - Hotel | 24 | CONF_NUMBER | Confirmation Code returned after Hotel reservation | nvarchar | 20 | 0 | | |
| 3 | FTPT_IMR_HTL_DIR | IMR - Hotel (Direct Access) | 21 | CONF_NUMBER | Confirmation Code returned after Hotel reservation | nvarchar | 20 | 0 | | |
| 4 | FTPT_OTHER | Travel Reservation Request Item - Other Service | 20 | CONF_NUMBER | Confirmation Code of Other Service | nvarchar | 16 | 0 | | |
| 5 | TA23OS | Field Control for Travel Res. Request Item: Other Services | 14 | CONF_NUMBER | Field Control Confirmation Code | nvarchar | 1 | 0 | | |
