| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | A501 | ServcAgent/Incoterms | 4 | TDLNR | Number of forwarding agent in the shipment stage | nvarchar | 10 | 0 | | |
2 | A514 | ServcAgent/Ship.type | 4 | TDLNR | Number of forwarding agent in the shipment stage | nvarchar | 10 | 0 | | |
3 | A519 | ServcAgent/Suppl. 3 | 4 | TDLNR | Number of forwarding agent in the shipment stage | nvarchar | 10 | 0 | | |
4 | A615 | Condition Table for Pricing A615 | 4 | TDLNR | Number of forwarding agent in the shipment stage | nvarchar | 10 | 0 | | |
5 | S950E | S950 - Info structurelles | 4 | TDLNR | N° du transporteur | nvarchar | 10 | 0 | | |
6 | S951E | S951 - Info structurelles | 4 | TDLNR | N° du transporteur | nvarchar | 10 | 0 | | |
7 | TROLZI | Routes: Determination in Inbound Deliveries | 3 | TDLNR | Number of forwarding agent | nvarchar | 10 | 0 | | |
TOPConditions |
8 | A112 | Service agent | 4 | TDLNR | Number of forwarding agent in the shipment stage | nvarchar | 10 | 0 | | |
9 | A113 | Service agent/Dep.cntry/Dep.post.code/Dest.cntry/Dest.PC | 4 | TDLNR | Number of forwarding agent in the shipment stage | nvarchar | 10 | 0 | | |
10 | A115 | Ser.agnt/Dep.ctry/Dep.PC /Ship-to party | 4 | TDLNR | Number of forwarding agent in the shipment stage | nvarchar | 10 | 0 | | |
11 | A119 | Service agent/Dep.ctry/Dep.post.code /Dest. country | 4 | TDLNR | Number of forwarding agent in the shipment stage | nvarchar | 10 | 0 | | |
12 | A124 | Service agent/Dep.cntry/Dep. PostCode/Tariff zone Dest. loc. | 4 | TDLNR | Number of forwarding agent in the shipment stage | nvarchar | 10 | 0 | | |
13 | A125 | Service agent/Tariff zone dep./Tariff zone target | 4 | TDLNR | Number of forwarding agent in the shipment stage | nvarchar | 10 | 0 | | |
14 | A126 | Service Agent/TariffZoneDep/TariffZoneDest/Freight Class | 4 | TDLNR | Number of forwarding agent in the shipment stage | nvarchar | 10 | 0 | | |
15 | A127 | Service Agent/TariffZoneDep/TariffZoneDest/Incoterms | 4 | TDLNR | Number of forwarding agent in the shipment stage | nvarchar | 10 | 0 | | |
16 | A128 | Service Agent/TariffZoneDep/TariffZoneDest/ShippingMatType | 4 | TDLNR | Number of forwarding agent in the shipment stage | nvarchar | 10 | 0 | | |
17 | A129 | Service Agent/TariffZDep/TariffZDest/ShipMatType/VSEGR 1 | 4 | TDLNR | Number of forwarding agent in the shipment stage | nvarchar | 10 | 0 | | |
18 | A135 | Transp. service agent/shipping type/bulk group | 4 | TDLNR | Number of forwarding agent in the shipment stage | nvarchar | 10 | 0 | | |
19 | A507 | External agent/Shipping point | 4 | TDLNR | Number of forwarding agent in the shipment stage | nvarchar | 10 | 0 | | |
20 | A508 | ServcAgent/Ship.type | 4 | TDLNR | Number of forwarding agent in the shipment stage | nvarchar | 10 | 0 | | |
21 | A510 | Condition Table for Pricing A510 | 4 | TDLNR | Number of forwarding agent in the shipment stage | nvarchar | 10 | 0 | | |
22 | A511 | Condition Table for Pricing A511 | 4 | TDLNR | Number of forwarding agent in the shipment stage | nvarchar | 10 | 0 | | |
23 | A796 | ServcAgent/DepPostCde/RecipCntry | 4 | TDLNR | Number of forwarding agent in the shipment stage | nvarchar | 10 | 0 | | |
24 | A797 | ServcAgent/DestCtry/DepPostCde | 4 | TDLNR | Number of forwarding agent in the shipment stage | nvarchar | 10 | 0 | | |
25 | A799 | ServcAgent/DepPostCde/DestCtry/DestRegion | 4 | TDLNR | Number of forwarding agent in the shipment stage | nvarchar | 10 | 0 | | |
26 | A805 | ShipmntTyp/ServcAgent/TfZn P.Dep/Tf zn.dest | 5 | TDLNR | Number of forwarding agent in the shipment stage | nvarchar | 10 | 0 | | |
27 | A810 | ShipmntTyp/ServcAgent/TfZn P.Dep/Tf zn.dest/FreightCl. | 5 | TDLNR | Number of forwarding agent in the shipment stage | nvarchar | 10 | 0 | | |
28 | A815 | ShipmntTyp/ServcAgent/TfZn P.Dep/FreightCl. | 5 | TDLNR | Number of forwarding agent in the shipment stage | nvarchar | 10 | 0 | | |
29 | A816 | ShipmntTyp/ServcAgent/TargPostCd | 5 | TDLNR | Number of forwarding agent in the shipment stage | nvarchar | 10 | 0 | | |
30 | A817 | ShipmntTyp/ServcAgent/TargPostCd/FreightCl. | 5 | TDLNR | Number of forwarding agent in the shipment stage | nvarchar | 10 | 0 | | |
31 | A818 | ShipmntTyp/ServcAgent/DepPostCde | 5 | TDLNR | Number of forwarding agent in the shipment stage | nvarchar | 10 | 0 | | |
32 | A819 | ShipmntTyp/ServcAgent/DepPostCde/FreightCl. | 5 | TDLNR | Number of forwarding agent in the shipment stage | nvarchar | 10 | 0 | | |
33 | A991 | ServcAgent/Dlv.Prior./TfZn P.Dep/Tf zn.dest | 4 | TDLNR | Number of forwarding agent in the shipment stage | nvarchar | 10 | 0 | | |
34 | B023 | TrspPlPoint, TrspProcessingType and Service Agent | 6 | TDLNR | Number of forwarding agent | nvarchar | 10 | 0 | | |
TOPData Collection |
35 | S050 | Shipment | 10 | TDLNR | Number of forwarding agent | nvarchar | 10 | 0 | | |
36 | S050E | S050 - Structural Information | 5 | TDLNR | Number of forwarding agent | nvarchar | 10 | 0 | | |
37 | S051 | Shipment routes | 12 | TDLNR | Number of forwarding agent | nvarchar | 10 | 0 | | |
38 | S051E | S051 - Structural Information | 7 | TDLNR | Number of forwarding agent | nvarchar | 10 | 0 | | |
39 | S054 | Stages of shipment | 10 | TDLNR | Number of forwarding agent in the shipment stage | nvarchar | 10 | 0 | | |
40 | S054E | S054 - Structural Information | 5 | TDLNR | Number of forwarding agent in the shipment stage | nvarchar | 10 | 0 | | |
41 | S055 | Shipment: materials | 10 | TDLNR | Number of forwarding agent | nvarchar | 10 | 0 | | |
42 | S055E | S055 - Structural Information | 5 | TDLNR | Number of forwarding agent | nvarchar | 10 | 0 | | |
43 | S950 | TRANSPORTS | 9 | TDLNR | N° du transporteur | nvarchar | 10 | 0 | | |
44 | S951 | TRANSPORTS2 | 9 | TDLNR | N° du transporteur | nvarchar | 10 | 0 | | |
TOPFreight Processing |
45 | A130 | Service agent/tariff zone dep./tariff zone targ/shipping mat | 4 | TDLNR | Number of forwarding agent in the shipment stage | nvarchar | 10 | 0 | | |
46 | A131 | Service Agent/TariffZnDp/TariffZnDest/Packaging Matl/VSEGR1 | 4 | TDLNR | Number of forwarding agent in the shipment stage | nvarchar | 10 | 0 | | |
47 | TVFPTZ | Tariff Zone Assignment for Postal Code Area | 3 | TDLNR | Number of forwarding agent | nvarchar | 10 | 0 | | |
48 | TVFPTZH | Tariff Zone Assignment for Postal Code Area Header Data | 3 | TDLNR | Number of forwarding agent | nvarchar | 10 | 0 | | |
49 | VFKP | Shipment Costs: Item Data | 25 | TDLNR | Number of service agent | nvarchar | 10 | 0 | | |
TOPInterfaces |
50 | VLBLTD | Express Delivery Company's Carrier Assignment | 2 | TDLNR | Number of forwarding agent | nvarchar | 10 | 0 | | |
TOPRemaining Beverage - Obsolete Objects |
51 | /DSD/LD_DFTVAL | DSD - LD: Load Delivery Standard Value | 4 | TDLNR | Number of forwarding agent | nvarchar | 10 | 0 | | |
TOPTraders and Schedulers Workbench |
52 | OIJ_STAGES | TSW (&TD) Shipment Stages | 33 | TDLNR | Number of forwarding agent in the shipment stage | nvarchar | 10 | 0 | | |
TOPTransportation |
53 | B045 | Shipment Type/Transportation Service Agent | 5 | TDLNR | Number of forwarding agent | nvarchar | 10 | 0 | | |
54 | TVRAB | Route Stages | 13 | TDLNR | Number of forwarding agent | nvarchar | 10 | 0 | | |
55 | TVRO | Routes | 18 | TDLNR | Number of forwarding agent | nvarchar | 10 | 0 | | |
56 | TVT_CA_SDELI | Selection Variants of Forwarding Agent for Deliveries | 2 | TDLNR | Number of forwarding agent | nvarchar | 10 | 0 | | |
57 | TVT_CA_SDELI_R | Restriction of Fwdg Agent Selection Variants for Deliveries | 2 | TDLNR | Number of forwarding agent | nvarchar | 10 | 0 | | |
58 | TVT_CA_SSHIP | Selection Variants of Forwarding Agent for Shipments | 2 | TDLNR | Number of forwarding agent | nvarchar | 10 | 0 | | |
59 | TVT_CA_TRA | Transportation Basis Data for Forwarding Agent | 2 | TDLNR | Number of forwarding agent | nvarchar | 10 | 0 | | |
60 | TVT_CA_USR | Assignment Between Forwarding Agent and SAP System User | 2 | TDLNR | Number of forwarding agent | nvarchar | 10 | 0 | | |
61 | VTDSTC | Condition of Deliveries for Freight Planning by Fwdng Agent | 3 | TDLNR | Number of forwarding agent | nvarchar | 10 | 0 | | |
62 | VTSPLS | Assignment Forwarding Agent - Log. System for Freight Plng | 2 | TDLNR | Number of forwarding agent | nvarchar | 10 | 0 | | |
63 | VTTK | Shipment Header | 60 | TDLNR | Number of forwarding agent | nvarchar | 10 | 0 | | |
64 | VTTS | Stage of Shipment | 43 | TDLNR | Number of forwarding agent in the shipment stage | nvarchar | 10 | 0 | | |
TOPTransportation and Distribution |
65 | A408 | Carrier | 4 | TDLNR | Number of forwarding agent in the shipment stage | nvarchar | 10 | 0 | | |
66 | A409 | Carrier, Bulk Shipment Type, Depart. Point, Dest. Point | 4 | TDLNR | Number of forwarding agent in the shipment stage | nvarchar | 10 | 0 | | |
67 | A413 | Carrier, vehicle type | 4 | TDLNR | Number of forwarding agent in the shipment stage | nvarchar | 10 | 0 | | |
68 | A414 | Carrier, Bulk Shipment Type | 4 | TDLNR | Number of forwarding agent in the shipment stage | nvarchar | 10 | 0 | | |
69 | A415 | Carrier, Bulk Shipment Type, Destination Tariff Zone | 4 | TDLNR | Number of forwarding agent in the shipment stage | nvarchar | 10 | 0 | | |
70 | OIGSS | TD Shipment Stages | 33 | TDLNR | Number of forwarding agent in the shipment stage | nvarchar | 10 | 0 | | |