| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPClassification System New |
1 | CME_ST_VALUE | CME Data Type: Values | 25 | INTERV | Key Interval Limits | nvarchar | 1 | 0 | | |
2 | CME_ST_VALUEH | CME Data Type: Values | 25 | INTERV | Key Interval Limits | nvarchar | 1 | 0 | | |
TOPExpenditure Certification |
3 | FMEUFFNS | Financing Source | 5 | INTERV | Intervention | nvarchar | 6 | 0 | | |
4 | FMEUFINT | Intervention in Expenditure Certification | 2 | INTERV | Intervention | nvarchar | 6 | 0 | | |
5 | FMEUFINTA | OBSOLETE: Intervention - Assign External to Internal | 3 | INTERV | Intervention | nvarchar | 6 | 0 | | |
6 | FMEUFINTT | Intervention - Text Table | 2 | INTERV | Intervention | nvarchar | 6 | 0 | | |
TOPHoliday Calendar, Factory Calendar, Appointment Calendar |
7 | TFACD | Factory calendar definition | 18 | INTERV | Calendar: Termination flag | nvarchar | 1 | 0 | | |
TOPMaxDB |
8 | DBAN | Buffer for dban_state | 9 | INTERV | Text (20 Characters) | nvarchar | 20 | 0 | | |
TOPSouth Africa |
9 | T5W4B | Leave entitlement (IT0005) parameter table - Southern Africa | 17 | INTERV | Interval Length for Leave Entitlement | nvarchar | 2 | 0 | | |