| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPCross-Application Components |
1 | PDS_OPER | PDS Data for Operations and Dependent Data | 4 | PLANNR | Key for Task List Group | nvarchar | 8 | 0 | | |
TOPMaterial Master |
2 | WSTN_AL_ALLOC | Prepack allocation planning lines | 2 | PLANNR | Prepack allocation plan number | nvarchar | 10 | 0 | | |
3 | WSTN_AL_AULW | Prepack allocation planning delivery phases | 2 | PLANNR | Prepack allocation plan number | nvarchar | 10 | 0 | | |
4 | WSTN_AL_AUVW | Prepack DC put away planning delivery phases | 2 | PLANNR | Prepack allocation plan number | nvarchar | 10 | 0 | | |
5 | WSTN_AL_DFTLW | Prepack allocation planning default delivery phases | 2 | PLANNR | Prepack allocation plan number | nvarchar | 10 | 0 | | |
6 | WSTN_AL_FILGRP | Prepack allocation planning site group assignation | 2 | PLANNR | Prepack allocation plan number | nvarchar | 10 | 0 | | |
7 | WSTN_AL_LINK | Relation between alloc table created and generic article | 12 | PLANNR | Prepack allocation plan number | nvarchar | 10 | 0 | | |
8 | WSTN_AL_MSG | Prepack allocation table posting messages | 2 | PLANNR | Prepack allocation plan number | nvarchar | 10 | 0 | | |
9 | WSTN_AL_POSI | Prepack allocation table item reference | 2 | PLANNR | Prepack allocation plan number | nvarchar | 10 | 0 | | |
10 | WSTN_AL_PTWAY | Prepack DC put away planning lines | 2 | PLANNR | Prepack allocation plan number | nvarchar | 10 | 0 | | |
11 | WSTN_AL_SGROUP | Prepack allocation planning site group definition | 2 | PLANNR | Prepack allocation plan number | nvarchar | 10 | 0 | | |
TOPTravel Planning |
12 | FTPT_CAR | Travel Request Item - Car Rental Service | 4 | PLANNR | Travel Plan Number (Sequential Number) | nvarchar | 2 | 0 | | |
13 | FTPT_CAR_PREF | Rental car service preferences of a travel plan | 4 | PLANNR | Travel Plan Number (Sequential Number) | nvarchar | 2 | 0 | | |
14 | FTPT_FARE_COMP | Rate components | 4 | PLANNR | Travel Plan Number (Sequential Number) | nvarchar | 2 | 0 | | |
15 | FTPT_FARE_NOTE | Rate Rules | 4 | PLANNR | Travel Plan Number (Sequential Number) | nvarchar | 2 | 0 | | |
16 | FTPT_FLIGHT | Travel Request Item - Flight Service | 4 | PLANNR | Travel Plan Number (Sequential Number) | nvarchar | 2 | 0 | | |
17 | FTPT_FLIGHT_FARE | Assignment table: flights <-> rate components | 4 | PLANNR | Travel Plan Number (Sequential Number) | nvarchar | 2 | 0 | | |
18 | FTPT_FLIGHT_FCMP | Assignment table: flights <-> rate components | 4 | PLANNR | Travel Plan Number (Sequential Number) | nvarchar | 2 | 0 | | |
19 | FTPT_FLIGHT_LEG | Leg of flight | 4 | PLANNR | Travel Plan Number (Sequential Number) | nvarchar | 2 | 0 | | |
20 | FTPT_FLIGHT_PREF | Flight service preferences of a travel plan | 4 | PLANNR | Travel Plan Number (Sequential Number) | nvarchar | 2 | 0 | | |
21 | FTPT_FLIGHT_TST | Ticket information | 4 | PLANNR | Travel Plan Number (Sequential Number) | nvarchar | 2 | 0 | | |
22 | FTPT_FLIGHT_TSTK | Ticket Information | 4 | PLANNR | Travel Plan Number (Sequential Number) | nvarchar | 2 | 0 | | |
23 | FTPT_HOTEL | Travel Request Item - Hotel Service | 4 | PLANNR | Travel Plan Number (Sequential Number) | nvarchar | 2 | 0 | | |
24 | FTPT_HOTEL_PREF | Hotel service preferences of a travel plan | 4 | PLANNR | Travel Plan Number (Sequential Number) | nvarchar | 2 | 0 | | |
25 | FTPT_ITEM | Travel Service Request Item | 4 | PLANNR | Travel Plan Number (Sequential Number) | nvarchar | 2 | 0 | | |
26 | FTPT_OTHER | Travel Reservation Request Item - Other Service | 4 | PLANNR | Travel Plan Number (Sequential Number) | nvarchar | 2 | 0 | | |
27 | FTPT_PLAN | General Plan Data | 4 | PLANNR | Travel Plan Number (Sequential Number) | nvarchar | 2 | 0 | | |
28 | FTPT_PLANHISTORY | General Plan Data | 4 | PLANNR | Travel Plan Number (Sequential Number) | nvarchar | 2 | 0 | | |
29 | FTPT_PNR | Elements of passenger name records of travel plan variant | 4 | PLANNR | Travel Plan Number (Sequential Number) | nvarchar | 2 | 0 | | |
30 | FTPT_PNR_ADDRESS | PNR delivery / billing addresses | 4 | PLANNR | Travel Plan Number (Sequential Number) | nvarchar | 2 | 0 | | |
31 | FTPT_PNR_NAME | Name element of PNR | 4 | PLANNR | Travel Plan Number (Sequential Number) | nvarchar | 2 | 0 | | |
32 | FTPT_PNR_OSI | Other PNR service information | 4 | PLANNR | Travel Plan Number (Sequential Number) | nvarchar | 2 | 0 | | |
33 | FTPT_PNR_PHONE | PNR telephone references | 4 | PLANNR | Travel Plan Number (Sequential Number) | nvarchar | 2 | 0 | | |
34 | FTPT_PNR_REMARKS | PNR remarks | 4 | PLANNR | Travel Plan Number (Sequential Number) | nvarchar | 2 | 0 | | |
35 | FTPT_PNR_SSR | Special PNR service requests | 4 | PLANNR | Travel Plan Number (Sequential Number) | nvarchar | 2 | 0 | | |
36 | FTPT_REQUEST | Travel Plan Requests | 4 | PLANNR | Travel Plan Number (Sequential Number) | nvarchar | 2 | 0 | | |
37 | FTPT_SERVICE | General Services | 4 | PLANNR | Travel Plan Number (Sequential Number) | nvarchar | 2 | 0 | | |
38 | FTPT_SYNC_DATA | Data Synchronization: SAP - External System | 4 | PLANNR | Travel Plan Number (Sequential Number) | nvarchar | 2 | 0 | | |
39 | FTPT_TRAIN | Travel Request Item - Train Service | 4 | PLANNR | Travel Plan Number (Sequential Number) | nvarchar | 2 | 0 | | |
40 | FTPT_TRAIN_PREF | Train service preferences of a travel plan | 4 | PLANNR | Travel Plan Number (Sequential Number) | nvarchar | 2 | 0 | | |
41 | FTPT_VARIANT | Table of Travel Plan Variants | 4 | PLANNR | Travel Plan Number (Sequential Number) | nvarchar | 2 | 0 | | |
42 | FTPT_VAR_INFO | Info texts for travel plan variants | 4 | PLANNR | Travel Plan Number (Sequential Number) | nvarchar | 2 | 0 | | |