| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| 1 | T77WWW_CLAGAPA | Associate Approvers to their Group | 3 | APGRP | Approver Group | nvarchar | 15 | 0 | | |
| 2 | T77WWW_CLAPRGRP | Approver Group Master Table | 3 | APGRP | Approver Group | nvarchar | 15 | 0 | | |
| 3 | T77WWW_CLAPRGRPT | Text Table for Approver Group | 4 | APGRP | Approver Group | nvarchar | 15 | 0 | | |
| 4 | T77WWW_CLTRANSD | Cluster table for storing transaction data. | 32 | APGRP | Approver Group | nvarchar | 15 | 0 | | |
| 5 | T77WWW_CLTRAN_BU | Backup Table for Storing Transaction Data | 32 | APGRP | Approver Group | nvarchar | 15 | 0 | | |
| 6 | T7AE11 | Home Airport (UAE) | 3 | APGRP | Group | nvarchar | 8 | 0 | | |
| 7 | T7AE18 | Leave Passage Entitlement | 2 | APGRP | Group | nvarchar | 8 | 0 | | |
| 8 | T7KW06 | Home Airport (KW) | 3 | APGRP | Group | nvarchar | 8 | 0 | | |
| 9 | T7KW07 | Leave Passage Entitlement (KW) | 2 | APGRP | Group | nvarchar | 8 | 0 | | |
| 10 | T7KW11 | Home Airport (KW) for Leave Passage by Tickets | 3 | APGRP | Group | nvarchar | 8 | 0 | | |
| 11 | T7KW18 | Leave Passage Entitlement (KW) | 2 | APGRP | Group | nvarchar | 8 | 0 | | |
| 12 | T7OM22 | Leave Passage Entitlement (OM) | 2 | APGRP | Group for Leave Passage | nvarchar | 8 | 0 | | |
| 13 | T7QA11 | Home Airport (QA) | 3 | APGRP | Group | nvarchar | 8 | 0 | | |
| 14 | T7QA18 | Leave Passage Entitlement (QA) | 2 | APGRP | Group | nvarchar | 8 | 0 | | |
| 15 | T7QA50 | Sanction Degree | 2 | APGRP | Group | nvarchar | 8 | 0 | | |
| 16 | T7SA09 | Home Airport | 3 | APGRP | Home Airport Group | nvarchar | 8 | 0 | | |
| 17 | T7SA30 | Leave Passage Entitlement | 2 | APGRP | Home Airport Group | nvarchar | 8 | 0 | | |
| TOPMaintenance History |
| 18 | HIKO | Order master data history | 41 | APGRP | Responsible planner group/department | nvarchar | 3 | 0 | | |
| TOPMaintenance Orders |
| 19 | AFIH | Maintenance order header | 12 | APGRP | Responsible planner group/department | nvarchar | 3 | 0 | | |
| TOPMalaysia |
| 20 | T5LES | ESS Malaysia: TP1 TP2 | 22 | APGRP | Approver Group | nvarchar | 15 | 0 | | |
| TOPRecruitment |
| 21 | T750E | Text for applicant group | 3 | APGRP | Applicant group | nvarchar | 1 | 0 | | |
| 22 | T750K | Applicant group | 2 | APGRP | Applicant group | nvarchar | 1 | 0 | | |
| 23 | T750X | Vacancy | 8 | APGRP | Reserved Field/Unused Field | nvarchar | 1 | 0 | | |
| TOPSimulation |
| 24 | VSAFIH_CN | Version: Order header for plant maintenance | 13 | APGRP | Responsible planner group/department | nvarchar | 3 | 0 | | |
