| 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 | | |