| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | CNVTDMS_05_VTTK | Collected Header Document Numbers for TDMS_Time-VTTK | 3 | TKNUM | BELNR for CNVTDMS_05_* | nvarchar | 10 | 0 | | |
2 | S950E | S950 - Info structurelles | 5 | TKNUM | Nº du transport | nvarchar | 10 | 0 | | |
3 | S951E | S951 - Info structurelles | 5 | TKNUM | Nº du transport | nvarchar | 10 | 0 | | |
TOPData Collection |
4 | S950 | TRANSPORTS | 10 | TKNUM | Nº du transport | nvarchar | 10 | 0 | | |
5 | S951 | TRANSPORTS2 | 10 | TKNUM | Nº du transport | nvarchar | 10 | 0 | | |
TOPDownloadUpload |
6 | /DSD/HH_DL_RECOV | DSD: Download Recovery | 2 | TKNUM | Shipment Number | nvarchar | 10 | 0 | | |
7 | /DSD/HH_TRANSBEL | DSD: Documents for Shipment | 2 | TKNUM | Shipment Number | nvarchar | 10 | 0 | | |
TOPGoods Receipt Process |
8 | BORGR_VTTP_NOEX | New inbound deliveries with references | 2 | TKNUM | Shipment Number | nvarchar | 10 | 0 | | |
TOPImplementation of Organizational Flexibility in Logistics |
9 | /ISDFPS/REL_TPN | Relocation Information for Shipment Document | 2 | TKNUM | Shipment Number | nvarchar | 10 | 0 | | |
TOPLocalization |
10 | J_1I_INBDELV | INBOUND DELIVERY DETAILS FROM sus | 3 | TKNUM | Shipment Number | nvarchar | 10 | 0 | | |
TOPMain Process |
11 | /VSO/M_I_BELEG | Input Data: Deliveries (Vehicle Space Optimization) | 2 | TKNUM | Shipment Number (Vehicle Space Optimization) | nvarchar | 10 | 0 | | |
12 | /VSO/M_I_DLY_HDR | Input Data: Delivery Header (Vehicle Space Optimization) | 2 | TKNUM | Shipment Number (Vehicle Space Optimization) | nvarchar | 10 | 0 | | |
13 | /VSO/M_I_DLY_ITM | Input Data: Delivery Items (Vehicle Space Optimization) | 2 | TKNUM | Shipment Number (Vehicle Space Optimization) | nvarchar | 10 | 0 | | |
14 | /VSO/M_I_PAL_DAT | Input Data: Pallets (Vehicle Space Optimization) | 2 | TKNUM | Shipment Number (Vehicle Space Optimization) | nvarchar | 10 | 0 | | |
15 | /VSO/M_I_POS | Input Data: Delivery Items (Vehicle Space Optimization) | 2 | TKNUM | Shipment Number (Vehicle Space Optimization) | nvarchar | 10 | 0 | | |
16 | /VSO/M_I_SHP_HDR | Input Data: Shipment Header (Vehicle Space Optimization) | 2 | TKNUM | Shipment Number (Vehicle Space Optimization) | nvarchar | 10 | 0 | | |
17 | /VSO/M_I_STACK | Input Data: Overstackability (Vehicle Space Optimization) | 2 | TKNUM | Shipment Number (Vehicle Space Optimization) | nvarchar | 10 | 0 | | |
18 | /VSO/M_I_SUBVEH | Input Data: Loading Bays (Vehicle Space Optimization) | 2 | TKNUM | Shipment Number (Vehicle Space Optimization) | nvarchar | 10 | 0 | | |
19 | /VSO/M_I_TRANS | Input Data: Relevant Shipment Fields (VSO) | 2 | TKNUM | Shipment Number (Vehicle Space Optimization) | nvarchar | 10 | 0 | | |
20 | /VSO/M_I_VEH | Input Data: Vehicle Data (Vehicle Space Optimization) | 2 | TKNUM | Shipment Number (Vehicle Space Optimization) | nvarchar | 10 | 0 | | |
21 | /VSO/M_O_SHP_HDR | Result Data: Shipment Header (Vehicle Space Optimization) | 2 | TKNUM | Shipment Number (Vehicle Space Optimization) | nvarchar | 10 | 0 | | |
TOPMaterials Management |
22 | /ISDFPS/VTTKDG | EHS: Supplement Table for Exceptions (DG Data, Transport) | 2 | TKNUM | Shipment Number | nvarchar | 10 | 0 | | |
TOPPicking |
23 | /VSO/P_HU_SYNC | Synchronizing the Deliveries of a Shipment (HU Creation) | 3 | TKNUM | Shipment Number | nvarchar | 10 | 0 | | |
24 | /VSO/P_LOG_ID | Log ID of a Shipment in Vehicle Space Optimization | 2 | TKNUM | Shipment Number | nvarchar | 10 | 0 | | |
25 | /VSO/P_PAL_TO | Assignment VSO Packing Proposal Items to WM TO Items | 2 | TKNUM | Shipment Number | nvarchar | 10 | 0 | | |
26 | /VSO/P_RSLT_PLTH | Result of VSO: Packing Proposal (Header Data) | 2 | TKNUM | Shipment Number | nvarchar | 10 | 0 | | |
27 | /VSO/P_RSLT_PLTI | Result of VSO: Packing Proposal Items | 2 | TKNUM | Shipment Number | nvarchar | 10 | 0 | | |
28 | /VSO/P_RSLT_VHCL | Result of VSO: Vehicle | 2 | TKNUM | Shipment Number | nvarchar | 10 | 0 | | |
TOPRemaining Beverage - Obsolete Objects |
29 | /BEV1/RSCOERF | COCIS: Check-Out Entry | 2 | TKNUM | Shipment Number | nvarchar | 10 | 0 | | |
30 | /BEV1/RSFFRBI | Batch Input Table for Collection Assignment | 3 | TKNUM | Shipment Number | nvarchar | 10 | 0 | | |
31 | /BEV1/RSFFRCH | General Information About Collection | 3 | TKNUM | Shipment Number | nvarchar | 10 | 0 | | |
32 | /BEV1/RSFFRHD | Header Data for Collection Assignment | 2 | TKNUM | Shipment Number | nvarchar | 10 | 0 | | |
33 | /BEV1/RSFFRIN | Table of Invoice Data | 3 | TKNUM | Shipment Number | nvarchar | 10 | 0 | | |
34 | /BEV1/RSFFROR | Order Information for Account Assignment | 3 | TKNUM | Shipment Number | nvarchar | 10 | 0 | | |
35 | /BEV1/RSQUSE | Quick Settlement | 2 | TKNUM | Shipment Number | nvarchar | 10 | 0 | | |
36 | /BEV1/RSVBFT | COCIS Document Flow for Shipment | 2 | TKNUM | Shipment Number | nvarchar | 10 | 0 | | |
37 | /BEV1/TRVTK | Transportation Report - Times Spent at Customers | 2 | TKNUM | Shipment Number | nvarchar | 10 | 0 | | |
38 | /BEV1/TRVTP | Transportation Report - Breaks | 2 | TKNUM | Shipment Number | nvarchar | 10 | 0 | | |
39 | /BEV1/TRVTS | Transportation Report - Rest Periods | 2 | TKNUM | Shipment Number | nvarchar | 10 | 0 | | |
TOPRemote Logistics Management |
40 | OIO_CNTNR_HST | Container history | 6 | TKNUM | Shipment Number | nvarchar | 10 | 0 | | |
41 | OIO_RT_RTDOC_CT | Returns document - container items | 4 | TKNUM | Shipment Number | nvarchar | 10 | 0 | | |
42 | OIO_SP_DFLDA | Default loading areas | 4 | TKNUM | Loading area | nvarchar | 10 | 0 | | |
TOPStructures Workbench |
43 | /ISDFPS/VEKPTRK | Tracking Table for Delivery HU in Shipment | 2 | TKNUM | Shipment Number | nvarchar | 10 | 0 | | |
TOPTraders and Schedulers Workbench |
44 | OIJ03_LOV | TSW: Table for Left on Vehicle Entries | 6 | TKNUM | Shipment Number | nvarchar | 10 | 0 | | |
45 | OIJ03_LOVGLREF | TSW Gain loss/LOV Reference table | 4 | TKNUM | Shipment Number | nvarchar | 10 | 0 | | |
46 | OIJNOMH | Nomination Header | 27 | TKNUM | Shipment Number | nvarchar | 10 | 0 | | |
47 | OIJNOMHVERS | Nomination Header Version Table | 29 | TKNUM | Shipment Number | nvarchar | 10 | 0 | | |
48 | OIJ_SCHED | Planned Schedule Lines | 35 | TKNUM | Shipment Number | nvarchar | 10 | 0 | | |
TOPTransportation |
49 | VTFA | Shipment Document Flow | 2 | TKNUM | Shipment Number | nvarchar | 10 | 0 | | |
50 | VTSP | Stage of Transport / Item Allocation | 2 | TKNUM | Shipment Number | nvarchar | 10 | 0 | | |
51 | VTTK | Shipment Header | 2 | TKNUM | Shipment Number | nvarchar | 10 | 0 | | |
52 | VTTP | Shipment Item | 2 | TKNUM | Shipment Number | nvarchar | 10 | 0 | | |
53 | VTTS | Stage of Shipment | 2 | TKNUM | Shipment Number | nvarchar | 10 | 0 | | |