| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPDistributed Maintenance |
1 | /ISDFPS/CPMUTYP | PM: Distributed Maintenance - UPS Package Types | 3 | UPSTYP | ALE Distribution Packet: Packet Type | nvarchar | 10 | 0 | | |
TOPDistribution Unit Distribution Packet |
2 | TUPS02 | ALE Distribution Unit: Packet Types | 2 | UPSTYP | ALE Distribution Packet: Packet Type | nvarchar | 10 | 0 | | |
3 | TUPS02API | ALE Distribution Unit: Activity Control (Entry) | 2 | UPSTYP | ALE Distribution Packet: Packet Type | nvarchar | 10 | 0 | | |
4 | TUPS02APO | ALE Distribution Unit: Activity Control (Exit) | 2 | UPSTYP | ALE Distribution Packet: Packet Type | nvarchar | 10 | 0 | | |
5 | TUPS02D | ALE Distribution Unit: Object Types per Packet Type | 2 | UPSTYP | ALE Distribution Packet: Packet Type | nvarchar | 10 | 0 | | |
6 | TUPS02R | ALE Distribution Unit: Statuses that Send UPSRCP | 2 | UPSTYP | ALE Distribution Packet: Packet Type | nvarchar | 10 | 0 | | |
7 | TUPS02T | ALE Distribution Unit: Text Table for Packet Types | 2 | UPSTYP | ALE Distribution Packet: Packet Type | nvarchar | 10 | 0 | | |
8 | TUPS02UPS | ALE Distribution Unit: UPS Services | 2 | UPSTYP | ALE Distribution Packet: Packet Type | nvarchar | 10 | 0 | | |
9 | UPSHDR | ALE Distribution Unit: Header Data | 8 | UPSTYP | ALE Distribution Packet: Packet Type | nvarchar | 10 | 0 | | |