| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | MSPT_OIGS | TD Shipment Header to store deleted records | 60 | CARRIER | Number of forwarding agent | nvarchar | 10 | 0 | | |
TOPCross-Application Components |
2 | SDEPMENT | Departments: Starting Situation | 2 | CARRIER | Airline Code | nvarchar | 3 | 0 | | |
3 | SDEPMENTT | Texts for the Departments: Starting Situation | 2 | CARRIER | Airline Code | nvarchar | 3 | 0 | | |
4 | SDEPMENT_CH | Departments: Enhance with Dept. Head and Time in Incl. (2) | 2 | CARRIER | Airline Code | nvarchar | 3 | 0 | | |
5 | SDEPMENT_CSH | Departments: Collective Search Help | 2 | CARRIER | Airline Code | nvarchar | 3 | 0 | | |
6 | SDEPMENT_SEARCH | Departments: Search Help | 2 | CARRIER | Airline Code | nvarchar | 3 | 0 | | |
7 | SEMPLOYES | Employee Table: Starting Version | 2 | CARRIER | Airline Code | nvarchar | 3 | 0 | | |
8 | SEMPLOYES_APP | Employees: Enhancement by Append (4) | 2 | CARRIER | Airline Code | nvarchar | 3 | 0 | | |
9 | SEMPLOYES_RB | Employees: Enhancement by No. of Agency (2) | 2 | CARRIER | Airline Code | nvarchar | 3 | 0 | | |
10 | SEMPLOYES_TI | Employees: Enhancement by Time Field in Include (3) | 2 | CARRIER | Airline Code | nvarchar | 3 | 0 | | |
11 | SEMPLOY_CSH | Employee table: Collective Search Help | 2 | CARRIER | Airline Code | nvarchar | 3 | 0 | | |
12 | SEMPLOY_SEARCH | Employee Table: Search Help Attachment to Table | 2 | CARRIER | Airline Code | nvarchar | 3 | 0 | | |
13 | SFUNCTEXT | Text Table for SFUNCTION (Exercise Template BC430) | 2 | CARRIER | Airline Code | nvarchar | 3 | 0 | | |
14 | SFUNCTION | Employee functions (Exercise template BC430) | 2 | CARRIER | Airline Code | nvarchar | 3 | 0 | | |
15 | SSALARY | Salaries for Salary Levels (Exercise Template for BC430) | 2 | CARRIER | Airline Code | nvarchar | 3 | 0 | | |
16 | SSALLEVEL | Salary Levels for Airline Carriers (Exercise Template BC430) | 2 | CARRIER | Airline Code | nvarchar | 3 | 0 | | |
17 | SSALLEVELT | Salary Level Texts (Exercise Templates BC430) | 2 | CARRIER | Airline Code | nvarchar | 3 | 0 | | |
TOPDownloadUpload |
18 | /DSD/HH_RAHD | DSD Route Settlement: Tour Header Data | 9 | CARRIER | Carrier Who Accepted the Shipment | nvarchar | 10 | 0 | | |
TOPDSD Connector |
19 | /DSD/ME_TOUR_HD | DSD CN: Tour Header Data | 7 | CARRIER | DSD Connector: Carrier ID | nvarchar | 10 | 0 | | |
TOPInterface to Terminal Automation System |
20 | TOIKTRVS | LID TAS relevance determination Shipment | 6 | CARRIER | TD carrier (vendor account number) | nvarchar | 10 | 0 | | |
TOPLogistics - General |
21 | OIJTS | Transport system (IS-Oil TSW standard/core object ) | 13 | CARRIER | Transport system Carrier | nvarchar | 10 | 0 | | |
TOPRoute Settlement |
22 | /DSD/SL_SLD_HEAD | Settlement Document Header | 4 | CARRIER | Number of forwarding agent | nvarchar | 10 | 0 | | |
TOPTraders and Schedulers Workbench |
23 | OIGSV | TD Vehicles in Transport/Shipment | 8 | CARRIER | TD carrier (vendor account number) | nvarchar | 10 | 0 | | |
24 | OIGV | TD Vehicle Header | 6 | CARRIER | TD carrier (vendor account number) | nvarchar | 10 | 0 | | |
25 | OIJHCT01 | OIL-TSW: Ticket Holding Table (Draft version 1) - OBSOLETE | 16 | CARRIER | Transport system Carrier | nvarchar | 10 | 0 | | |
26 | OIJNOMH | Nomination Header | 64 | CARRIER | Transport system Carrier | nvarchar | 10 | 0 | | |
27 | OIJNOMHVERS | Nomination Header Version Table | 57 | CARRIER | Transport system Carrier | nvarchar | 10 | 0 | | |
28 | OIJ_EL_TICKET_H | Universal ticket table | 19 | CARRIER | Transport system Carrier | nvarchar | 10 | 0 | | |
TOPTransportation and Distribution |
29 | OIGD | TD Driver | 6 | CARRIER | TD carrier (vendor account number) | nvarchar | 10 | 0 | | |
30 | OIGS | TD Shipment Header | 60 | CARRIER | Number of forwarding agent | nvarchar | 10 | 0 | | |