| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | A615 | Condition Table for Pricing A615 | 6 | TRFZNZ | Tariff zone of point of destination | nvarchar | 10 | 0 | | |
TOPConditions |
2 | A124 | Service agent/Dep.cntry/Dep. PostCode/Tariff zone Dest. loc. | 7 | TRFZNZ | Tariff zone of point of destination | nvarchar | 10 | 0 | | |
3 | A125 | Service agent/Tariff zone dep./Tariff zone target | 6 | TRFZNZ | Tariff zone of point of destination | nvarchar | 10 | 0 | | |
4 | A126 | Service Agent/TariffZoneDep/TariffZoneDest/Freight Class | 6 | TRFZNZ | Tariff zone of point of destination | nvarchar | 10 | 0 | | |
5 | A127 | Service Agent/TariffZoneDep/TariffZoneDest/Incoterms | 6 | TRFZNZ | Tariff zone of point of destination | nvarchar | 10 | 0 | | |
6 | A128 | Service Agent/TariffZoneDep/TariffZoneDest/ShippingMatType | 6 | TRFZNZ | Tariff zone of point of destination | nvarchar | 10 | 0 | | |
7 | A129 | Service Agent/TariffZDep/TariffZDest/ShipMatType/VSEGR 1 | 6 | TRFZNZ | Tariff zone of point of destination | nvarchar | 10 | 0 | | |
8 | A805 | ShipmntTyp/ServcAgent/TfZn P.Dep/Tf zn.dest | 7 | TRFZNZ | Tariff zone of point of destination | nvarchar | 10 | 0 | | |
9 | A810 | ShipmntTyp/ServcAgent/TfZn P.Dep/Tf zn.dest/FreightCl. | 7 | TRFZNZ | Tariff zone of point of destination | nvarchar | 10 | 0 | | |
10 | A991 | ServcAgent/Dlv.Prior./TfZn P.Dep/Tf zn.dest | 7 | TRFZNZ | Tariff zone of point of destination | nvarchar | 10 | 0 | | |
TOPFreight Processing |
11 | A130 | Service agent/tariff zone dep./tariff zone targ/shipping mat | 6 | TRFZNZ | Tariff zone of point of destination | nvarchar | 10 | 0 | | |
12 | A131 | Service Agent/TariffZnDp/TariffZnDest/Packaging Matl/VSEGR1 | 6 | TRFZNZ | Tariff zone of point of destination | nvarchar | 10 | 0 | | |
13 | VFKP | Shipment Costs: Item Data | 53 | TRFZNZ | Tariff zone of point of destination | nvarchar | 10 | 0 | | |
TOPTransportation and Distribution |
14 | A415 | Carrier, Bulk Shipment Type, Destination Tariff Zone | 6 | TRFZNZ | Tariff zone of point of destination | nvarchar | 10 | 0 | | |