#0 1 2 3 4
#*Customer Name *Reference Number Incoterms Incoterms Location Product Category
AUUNILEV73HQ INTTRATEST001 DAP Australia Detergent
# Classification: Internal
5 6 7 8 9 10
TO ID *CLP Status Customer Desc *Place of Receipt Origin Desc Origin Address descriptor
ITS TO PHTUGABE
# Classification: Internal
11 12 13 14 15 16 17
Origin Address 1 Origin Address 2 Origin Address 3 Origin Address 4 Origin Address 5 Origin City Origin County
# Classification: Internal
18 19 20 21 22 23
Origin State Origin Country Origin Zip *Place of Delivery Destination Desc Ship To Address descriptor
AUSYDARF
# Classification: Internal
24 25 26 27 28
Destination Address 1 Destination Address 2 Destination Address 3 Destination Address 4 Destination Address 5
# Classification: Internal
29 30 31 32 33 34
Destination City Destination County Destination State Destination Country Destination Zip Requested Carrier ID
# Classification: Internal
35 36 37 38 39 40
Port of Loading ETD *Port of Loading *Port of DischargePort of Discharge ETA
*Service Type *Move Type
PHMNL AUMEL CY port_to_port
# Classification: Internal
41 42 43 44
*TO Target Ship Date *TO Target Delivery Date *Shipper ID Shipper Desc
12/01/2023 00:00:00 16/01/2023 00:00:00 PHUNILEV05HQ
# Classification: Internal
45 46 47 48 49
Shipper Address_line_1 Shipper Country of origin Shipper City of origin Booker ID Booked Desc
807441
# Classification: Internal
50 51 52 53 54
Customs Export ID Customs Export Email Consignee ID Consignee Desc Consignee Party Name
# Classification: Internal
55 56 57 58 59
Consignee address_line_1 Consignee country code 4PL Planner ID 4PL Planner Desc Customs Import ID
# Classification: Internal
60 61 62 63 64
Customs Import Email 3PL Origin 3PL Destination Planned Chargeable WeightCarrier Chargeable Weight
PH3PLROMAGFS
# Classification: Internal
65 66 67 68 69
*Container Seq# *Transportation Mode *Equipment Type Master Container ID *SB Seq#
1 OCEAN 40 Reefer (42R1) 1
# Classification: Internal
70 71 72 73 74
Ship Request Consignee Ship Request Shipper Shipper Reference No. Shipper Booking ID Incoterms
# Classification: Internal
75 76 77 78 79 80
Incoterms Location Product Category Shipper Booking Line ID Ex-factory Date Planned Delivery Date Model
# Classification: Internal
81 82 83 84 85 86
OrderModelSubType Order Customer Order Supplier ID PO Number Po Line ID *Customer Item
ITEM1
# Classification: Internal
87 88 89 90 91 92 93 94
Dangerous Goods Currency Value *SB Qty Packaging ID SB Length SB Width SB Height
10
# Classification: Internal
95 96 97 98 99
*SB Measurement (CBM) *SB Weight (KGS) *SB No. of Packages *Unit Of Measure *HS Code
100 100000 100 PCS 808012
# Classification: Internal
100 101 102 103 104 105
Temperature State Temperature Temperature UOM Temperature Range Temperature Variance Humidity (%)
Yes -10 C 1
# Classification: Internal
106 107 108 109 110
Genset Required Super Freezer Service In Transit Cold Sterilization Vent Setting Reefer Handling Instructions
Yes Open
# Classification: Internal
111 112 113 114 115 116
Gas Type Air exchange per hour (cbm) No of USDA probes No of Reefer probes DG State IMO Classs Code
N2(1.0) 1 No
# Classification: Internal
117 118 119 120 121 122
CAS/UN/NA-Number Packing Group Technical Name Shipping Name Flash Point Flash Point UOM
# Classification: Internal
123 124 125 126
Marine Polutant Status SI EMS No Emergency Contact(Hazmat Material Contact) Comments
TEST COMMENT
# Classification: Internal
127 128 129 130
DG Handling Instructions Inhalt Hazard Indicator Aggregation State Limited quantity indicator
TEST COMMENT
# Classification: Internal
131 132 133 134
Placard information Contact name and Phone Container Measurement (CBM) Container Weight (KGS)
# Classification: Internal
135 136 137 138 139 140
*Packaging Type Planned Legs Leg No Ship From Ship From Desc Ship From Descriptor
Packages
# Classification: Internal
141 142 143 144 145
Ship From Address 1 Ship From Address 2 Ship From Address 3 Ship From Address 4 Ship From Address 5
# Classification: Internal
146 147 148 149 150 151 152
Ship From City Ship From County Ship From State Ship From Country Ship From Zip Ship To Ship To Desc
# Classification: Internal
153 154 155 156 157 158
Ship To Descriptor Ship To Address 1 Ship To Address 2 Ship To Address 3 Ship To Address 4 Ship To Address 5
# Classification: Internal
159 160 161 162 163 164 165 166
Ship To City Ship To County Ship To State Ship To Country Ship To Zip Master Leg Mode
Freight
Terms
# Classification: Internal
167 168 169 170 171 172
Shipment Terms ETD ETA Commodity Description Service Level Carrier Service Level
# Classification: Internal
173
Stuffed Chargeable Weight
# Classification: Internal
No Field Description Mandatory Data Type
0 *Customer Name Yes VARCHAR(64)
1 *Reference Number Yes VARCHAR(64)
2 Incoterms No VARCHAR(64)
3 Incoterms Location No VARCHAR(64)
4 Product Category No VARCHAR(64)
5 TO ID No VARCHAR(64)
6 *CLP Status Yes VARCHAR(20)
7 Customer Desc No VARCHAR(32)
8 *Place of Receipt Yes VARCHAR(20)
9 Origin Desc No VARCHAR(32)
10 Origin Address descriptor No VARCHAR(1024)
11 Origin Address 1 No VARCHAR(255)
12 Origin Address 2 No VARCHAR(255)
13 Origin Address 3 No VARCHAR(255)
14 Origin Address 4 No VARCHAR(255)
15 Origin Address 5 No VARCHAR(255)
16 Origin City No VARCHAR(255)
17 Origin County No VARCHAR(255)
18 Origin State No VARCHAR(255)
19 Origin Country No VARCHAR(255)
20 Origin Zip No VARCHAR(255)
21 *Place of Delivery Yes VARCHAR(20)
22 Destination Desc No VARCHAR(32)
23 Ship To Address descriptor No VARCHAR(1024)
24 Destination Address 1 No VARCHAR(255)
25 Destination Address 2 No VARCHAR(255)
26 Destination Address 3 No VARCHAR(255)
27 Destination Address 4 No VARCHAR(255)
28 Destination Address 5 No VARCHAR(255)
29 Destination City No VARCHAR(255)
30 Destination County No VARCHAR(255)
31 Destination State No VARCHAR(255)
32 Destination Country No VARCHAR(255)
33 Destination Zip No VARCHAR(255)
34 Requested Carrier ID No VARCHAR(13)
35 Port of Loading ETD No DATE
36 *Port of Loading Yes VARCHAR(64)
# Classification: Internal
37 *Port of Discharge Yes VARCHAR(64)
38 Port of Discharge ETA No DATE
39 *Service Type Yes VARCHAR(64)
40 *Move Type Yes VARCHAR(64)
41 *TO Target Ship Date Yes DATE
42 *TO Target Delivery Date Yes DATE
43 *Shipper ID Yes VARCHAR(255)
44 Shipper Desc No VARCHAR(255)
45 Shipper Address_line_1 No VARCHAR(255)
46 Shipper Country of origin No VARCHAR(255)
47 Shipper City of origin No VARCHAR(255)
48 Booker ID No VARCHAR(64)
49 Booker Desc No VARCHAR(64)
50 Customs Export ID No VARCHAR(255)
51 Customs Export Email No VARCHAR(255)
52 Consignee ID No VARCHAR(13)
53 Consignee Desc No VARCHAR(128)
54 Consignee Party Name No VARCHAR(255)
55 Consignee address_line_1 No VARCHAR(255)
56 Consignee country code No VARCHAR(255)
57 4PL Planner ID No VARCHAR(13)
58 4PL Planner Desc No VARCHAR(128)
59 Customs Import ID No VARCHAR(13)
60 Customs Import Email No VARCHAR(64)
61 3PL Origin No VARCHAR(64)
62 3PL Destination No VARCHAR(255)
63 Planned Chargeable Weight No FLOAT
64 Carrier Chargeable Weight No FLOAT
65 *Container Seq# Yes NUMBER(10)
66 *Transportation Mode Yes VARCHAR(64)
67 *Equipment Type Yes VARCHAR(64)
68 Master Container ID No VARCHAR(64)
69 *SB Seq# Yes NUMBER(10)
70 Ship Request Consignee No VARCHAR(64)
71 Ship Request Shipper No VARCHAR(64)
72 SB Reference No. No VARCHAR(64)
73 Shipper Booking ID No VARCHAR(64)
74 Incoterms No VARCHAR(64)
75 Incoterms Location No VARCHAR(64)
76 Product Category No VARCHAR(64)
77 Shipper Booking Line ID No VARCHAR(64)
78 Ex-factory Date No DATE
79 Planned Delivery Date No DATE
80 Model No VARCHAR(64)
81 OrderModelSubType No VARCHAR(64)
# Classification: Internal
82 Order Customer No VARCHAR(64)
83 Order Supplier ID No VARCHAR(64)
84 PO Number No VARCHAR(64)
85 Po Line ID No NUMBER(10)
86 *Customer Item Yes VARCHAR(64)
87 Dangerous Goods No VARCHAR(64)
88 Currency No VARCHAR(64)
89 Value No FLOAT
90 *SB Qty Yes FLOAT
91 Packaging ID No VARCHAR(128)
92 SB Length No FLOAT
93 SB Width No FLOAT
94 SB Height No FLOAT
95 *SB Measurement (CBM) Yes FLOAT
96 *SB Weight (KGS) Yes FLOAT
97 *SB No. of Packages Yes NUMBER(10)
98 *Unit Of Measure Yes VARCHAR(64)
99 *HS Code Yes VARCHAR(1024)
100 Temperature State No VARCHAR(10)
101 Temperature No FLOAT
102 Temperature UOM No VARCHAR(15)
103 Temperature Range No VARCHAR(64)
104 Temperature Variance No VARCHAR(64)
105 Humidity (%) No FLOAT
106 Genset Required No VARCHAR(3)
107 Super Freezer Service No VARCHAR(3)
108 In Transit Cold Sterilization No VARCHAR(3)
109 Vent Setting No VARCHAR(10)
110 Reefer Handling Instructions No VARCHAR(450)
111 Gas Type No VARCHAR(1024)
112 Air exchange per hour (cbm) No FLOAT
113 No of USDA probes No NUMBER(5)
114 No of Reefer probes No NUMBER(5)
115 DG State No VARCHAR(64)
116 IMO Classs Code No VARCHAR(64)
117 CAS/UN/NA-Number No VARCHAR(64)
118 Packing Group No VARCHAR(64)
119 Technical Name No VARCHAR(64)
120 Shipping Name No VARCHAR(64)
121 Flash Point No VARCHAR(64)
122 Flash Point UOM No VARCHAR(64)
123 Marine Polutant Status No VARCHAR(64)
124 SI EMS No No VARCHAR(64)
125 Emergency Contact(Hazmat Material Contact) No VARCHAR(128)
126 Comments No VARCHAR(255)
# Classification: Internal
127 DG Handling Instructions No VARCHAR(255)
128 Inhalt Hazard Indicator No VARCHAR(64)
129 Aggregation State No VARCHAR(64)
130 Limited quantity indicator No VARCHAR(64)
131 Placard information No VARCHAR(64)
132 Contact name and Phone No VARCHAR(128)
133 Container Measurement (CBM) No FLOAT
134 Container Weight (KGS) No FLOAT
135 *Packaging Type Yes VARCHAR(255)
136 Planned Legs No NUMBER(10)
137 Leg No No NUMBER(10)
138 Ship From No VARCHAR(20)
139 Ship From Desc No VARCHAR(32)
140 Ship From Descriptor No VARCHAR(1024)
141 Ship From Address 1 No VARCHAR(255)
142 Ship From Address 2 No VARCHAR(255)
143 Ship From Address 3 No VARCHAR(255)
144 Ship From Address 4 No VARCHAR(255)
145 Ship From Address 5 No VARCHAR(255)
146 Ship From City No VARCHAR(255)
147 Ship From County No VARCHAR(255)
148 Ship From State No VARCHAR(255)
149 Ship From Country No VARCHAR(255)
150 Ship From Zip No VARCHAR(255)
151 Ship To No VARCHAR(20)
152 Ship To Desc No VARCHAR(32)
153 Ship To Descriptor No VARCHAR(1024)
154 Ship To Address 1 No VARCHAR(255)
155 Ship To Address 2 No VARCHAR(255)
156 Ship To Address 3 No VARCHAR(255)
157 Ship To Address 4 No VARCHAR(255)
158 Ship To Address 5 No VARCHAR(255)
159 Ship To City No VARCHAR(255)
160 Ship To County No VARCHAR(255)
161 Ship To State No VARCHAR(255)
162 Ship To Country No VARCHAR(255)
163 Ship To Zip No VARCHAR(255)
164 Master Leg No VARCHAR(64)
165 Mode No VARCHAR(64)
166 Freight Terms No VARCHAR(64)
167 Shipment Terms No VARCHAR(64)
168 ETD No DATE
169 ETA No DATE
170 Commodity Description No VARCHAR(64)
171 Service Level No VARCHAR(255)
# Classification: Internal
172 Carrier Service Level No VARCHAR(64)
173 Stuffed Chargeable Weight No FLOAT
# Classification: Internal
Validation/Remarks Notes
Incoterms Available in TO Header
Incoterms Location Available in TO Header
Product Category Available in TO Header
ITS TO means Shipper
Booking, TO, TO Line. No
legs. Leg data will be
ignored if entered.
ITS TO | ITS Full | ITS Cancel | ITS Full Replace | ITS TO Replace
ITS Full means Shipper
Booking, TO, TO Line,
Container, Legs. No booking
details.
Location code maintained in Master data
Required if Place Of Receipt is not present in Master data
Required if Place Of Receipt is not present in Master data
Required if Place Of Receipt is not present in Master data
Required if Place Of Receipt is not present in Master data
Required if Place Of Receipt is not present in Master data
Required if Place Of Receipt is not present in Master data
Required if Place Of Receipt is not present in Master data
Location code maintained in Master data
Required if Place Of Delivery is not present in Master data
Required if Place Of Delivery is not present in Master data
Required if Place Of Delivery is not present in Master data
Required if Place Of Delivery is not present in Master data
Required if Place Of Delivery is not present in Master data
Required if Place Of Delivery is not present in Master data
Required if Place Of Delivery is not present in Master data
Carrier SCAC
TO Header Vessel ETD in UI
Not mandatory for PARCEL
# Classification: Internal
Not mandatory for PARCEL
TO Header Vessel ETA in UI
CY|CFS|PARCEL
port_to_port|door_to_door|port_to_door|door_to_port
Will be SB's supplier ID aswell
For future reference and added as part of TMS(If in scope)
For future reference and added as part of TMS(If in scope)
For future reference and added as part of TMS(If in scope)
For future reference and added as part of TMS(If in scope)
For future reference and added as part of TMS(If in scope)
For future reference and added as part of TMS(If in scope)
Party ID maintained in Master data Not Required for ITS
Party ID maintained in Master data
OCEAN|AIR|ROAD|PARCEL|RAIL|LCL
Incoterms Available in TO line
Incoterms Location Available in TO line
Product Category Available in TO line
# Classification: Internal
Non Mandatory if DN/SB reference no. is populated
Non Mandatory if DN/SB reference no. is populated
Mandatory for PARCEL
Mandatory for PARCEL
Mandatory for PARCEL
Mandatory for PARCEL
Non Mandatory if DN/SB reference no. is populated
Non Mandatory if DN/SB reference no. is populated
Non Mandatory if DN/SB reference no. is populated
Non Mandatory if DN/SB reference no. is populated
Non Mandatory if DN/SB reference no. is populated
Yes|No
Yes|No
# Classification: Internal
Non Mandatory if DN/SB reference no. is populated
Only required for ITS Full Only needed for ITS Full
Only required for ITS Full
Only required for ITS Full | Location code maintained in Master data Only needed for ITS Full
Only required for ITS Full |Required if Ship From is not present in Master data Only needed for ITS Full
Only required for ITS Full |Required if Ship From is not present in Master data Only needed for ITS Full
Only required for ITS Full |Required if Ship From is not present in Master data Only needed for ITS Full
Only required for ITS Full |Required if Ship From is not present in Master data Only needed for ITS Full
Only needed for ITS Full
Only needed for ITS Full
Only needed for ITS Full
Only required for ITS Full |Required if Ship From is not present in Master data Only needed for ITS Full
Only needed for ITS Full
Only needed for ITS Full
Only required for ITS Full |Required if Ship From is not present in Master data Only needed for ITS Full
Only required for ITS Full |Required if Ship From is not present in Master data Only needed for ITS Full
Only required for ITS Full | Location code maintained in Master data Only needed for ITS Full
Only required for ITS Full |Required if Ship To is not present in Master data Only needed for ITS Full
Only required for ITS Full |Required if Ship To is not present in Master data Only needed for ITS Full
Only required for ITS Full |Required if Ship To is not present in Master data Only needed for ITS Full
Only required for ITS Full |Required if Ship To is not present in Master data Only needed for ITS Full
Only required for ITS Full |Required if Ship To is not present in Master data Only needed for ITS Full
Only required for ITS Full |Required if Ship To is not present in Master data Only needed for ITS Full
Only required for ITS Full |Required if Ship To is not present in Master data Only needed for ITS Full
Only required for ITS Full |Yes|No Only needed for ITS Full
Only required for ITS Full |OCEAN|AIR|RAIL|ROAD|PARCEL|LCL Only needed for ITS Full
Only required for ITS Full Only needed for ITS Full
Only required for ITS Full Only needed for ITS Full
Only required for ITS Full Only needed for ITS Full
# Classification: Internal
