Template

Download as xlsx, pdf, or txt
Download as xlsx, pdf, or txt
You are on page 1of 46

storerkey type externorderkey externalorderkey2 buyerpo

OWNER TYPE SO NO1 SO NO2 PO


FRT 04 SD1
FRT 04 SD2
FRT 04 SD3
FRT 04 SD4
FRT 04 SD5
FRT 04 SD6
FRT 04 SD7
FRT 04 SD8
FRT 04 SD9
FRT 04 SD10
FRT 04 SD11
FRT 04 SD12
FRT 04 SD13
FRT 04 SD14
FRT 04 SD15
FRT 04 SD16
FRT 04 SD17
FRT 04 SD18
FRT 04 SD19
FRT 04 SD20
FRT 04 SD21
FRT 04 SD22
FRT 04 SD23
FRT 04 SD24
FRT 04 SD25
FRT 04 SD26
FRT 04 SD27
FRT 04 SD28
FRT 04 SD29
FRT 04 SD30
FRT 04 SD31
FRT 04 SD32
FRT 04 SD33
FRT 04 SD34
FRT 04 SD35
FRT 04 SD36
FRT 04 SD37
FRT 04 SD38
FRT 04 SD39
FRT 04 SD40
FRT 04 SD41
FRT 04 SD42
FRT 04 SD43
FRT 04 SD44
FRT 04 SD45
FRT 04 SD46
FRT 04 SD47
FRT 04 SD48
FRT 04 SD49
FRT 04 SD50
FRT 04 SD51
FRT 04 SD52
FRT 04 SD53
FRT 04 SD54
FRT 04 SD55
FRT 04 SD56
FRT 04 SD57
FRT 04 SD58
FRT 04 SD59
FRT 04 SD60
FRT 04 SD61
FRT 04 SD62
FRT 04 SD63
FRT 04 SD64
FRT 04 SD65
FRT 04 SD66
FRT 04 SD67
FRT 04 SD68
FRT 04 SD69
FRT 04 SD70
FRT 04 SD71
FRT 04 SD72
FRT 04 SD73
FRT 04 SD74
FRT 04 SD75
FRT 04 SD76
FRT 04 SD77
FRT 04 SD78
FRT 04 SD79
FRT 04 SD80
FRT 04 SD81
FRT 04 SD82
FRT 04 SD83
FRT 04 SD84
FRT 04 SD85
FRT 04 SD86
FRT 04 SD87
FRT 04 SD88
FRT 04 SD89
FRT 04 SD90
FRT 04 SD91
FRT 04 SD92
FRT 04 SD93
FRT 04 SD94
FRT 04 SD95
FRT 04 SD96
FRT 04 SD97
FRT 04 SD98
FRT 04 SD99
FRT 04 SD100
FRT 04 SD101
FRT 04 SD102
FRT 04 SD103
FRT 04 SD104
FRT 04 SD105
FRT 04 SD106
FRT 04 SD107
FRT 04 SD108
FRT 04 SD109
FRT 04 SD110
FRT 04 SD111
FRT 04 SD112
FRT 04 SD113
FRT 04 SD114
FRT 04 SD115
FRT 04 SD116
FRT 04 SD117
FRT 04 SD118
FRT 04 SD119
FRT 04 SD120
FRT 04 SD121
FRT 04 SD122
FRT 04 SD123
FRT 04 SD124
FRT 04 SD125
FRT 04 SD126
FRT 04 SD127
FRT 04 SD128
FRT 04 SD129
FRT 04 SD130
FRT 04 SD131
FRT 04 SD132
FRT 04 SD133
FRT 04 SD134
FRT 04 SD135
FRT 04 SD136
FRT 04 SD137
FRT 04 SD138
FRT 04 SD139
FRT 04 SD140
FRT 04 SD141
FRT 04 SD142
FRT 04 SD143
FRT 04 SD144
FRT 04 SD145
FRT 04 SD146
FRT 04 SD147
FRT 04 SD148
FRT 04 SD149
FRT 04 SD150
FRT 04 SD151
FRT 04 SD152
FRT 04 SD153
FRT 04 SD154
FRT 04 SD155
FRT 04 SD156
FRT 04 SD157
FRT 04 SD158
FRT 04 SD159
FRT 04 SD160
FRT 04 SD161
FRT 04 SD162
FRT 04 SD163
FRT 04 SD164
FRT 04 SD165
FRT 04 SD166
FRT 04 SD167
FRT 04 SD168
FRT 04 SD169
FRT 04 SD170
FRT 04 SD171
FRT 04 SD172
FRT 04 SD173
FRT 04 SD174
FRT 04 SD175
FRT 04 SD176
FRT 04 SD177
FRT 04 SD178
FRT 04 SD179
FRT 04 SD180
FRT 04 SD181
FRT 04 SD182
FRT 04 SD183
FRT 04 SD184
FRT 04 SD185
FRT 04 SD186
FRT 04 SD187
FRT 04 SD188
FRT 04 SD189
FRT 04 SD190
FRT 04 SD191
FRT 04 SD192
FRT 04 SD193
FRT 04 SD194
FRT 04 SD195
FRT 04 SD196
FRT 04 SD197
FRT 04 SD198
FRT 04 SD199
FRT 04 SD200
FRT 04 SD201
orderdate requestedshipdate actualshipdate deliverydate deliverydate2
ORDER DATE REQUESTED SHIP DATE ACTUAL SHIP DATE DELIVERY DATE1 DELIVERY DATE2
provisiondate vesselcode voyagecode begintime endtime
PROVISION DATE VESSEL CODE VOYAGE CODE BEGIN TIME END TIME
allocateonreceived notes masterpick priority tareweight
ALLOCATE ON RECEIVED REMARK MASTER PICK PRIORITY TAREWEIGHT
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
maxweight droplist1 droplist2 droplist3
MAXWEIGHT DROPLIST 1 DROPLIST 2 DROPLIST 3
droplist4 droplist5 droplist6 droplist7
DROPLIST 4 DROPLIST 5 DROPLIST 6 DROPLIST 7
droplist8 droplist9 droplist10 businessunitorder
DROPLIST 8 DROPLIST 9 DROPLIST 10 BUSINESS UNIT ORDER
businessunitorder invorg invorg urgent
BUSINESS UNIT ORDER INVORG INVORG URGENT
trackingcode consigneekey shipcode carriercode trailernumber
TRACKING CODE CUSTOMER SHIP TO CARRIER CODE TRAILER NUMBER
0000038
0000039
0000040
0000041
0000042
0000043
0000044
0000045
0000046
0000047
0000048
0000049
0000050
0000051
0000052
0000053
0000054
0000055
0000056
0000057
132614
30257
30256
30255
30258
30254
30991
31435
30918
31409
30909
30933
31464
31416
31242
31470
31209
30841
30892
31241
10136
10137
148
162
342
10151
10152
00525574
195
0000023
00525694
10138
10140
10139
10141
14567703
1713069987
12401897
6881830
143
12319462
1714567700
12251087
1713450811
12733376
271
00524221
112
14567715
311
132600
277
1714438467
132595
00524228
15487041
1710589557
14401758
1710464451
00304222
16614133
7199546
00525711
275
6538693
0000025
15127374
1717320810
1713024362
12284449
00524216
10145
12148711
1714120017
279
240
10143
12319455
10129
132612
132613
132601
132587
348
132575
145
00525593
132573
347
116
00525657
15146367
283
1531085
14567751
1711212751
197
16416487
1713997986
0000016
123
14188988
00524686
00012703-HCM
10458288
16124853
1531073
12024497
0000002
12251110
1714219846
17045201
114311
127
00002712
1714988331
16907616
135
00525547
7625415
217
1712251086
00000893
15419467
281
00525601
0000028
16948345
1712671964
12322425
1714120026
15121904
1712319468
00005678-KGG
1710644173
14567764
1712289499
00000914
1714567676
15713705
0000006
00525624
1711239281
12205866
1713843529
11331018
1714253498
00001024
399
1711002274
160
1712742575
00525622
692076
15163666
1710664534
00524199
452294
00000983
486530
12671960
209
1712319449
00525672
13666864
8800603
00001687
9736995
00525727
12089698
1710706906
12319487
8476840
12242098
1712251043
12251080
1712286585
299
1712776041
00525548
523479
drivername containertype door transportationmodetransportationservice
DRIVER NAME CONTAINER TYPE DOCK TRANSPORTATION MODE
TRANSPORTATION SERVICE
externalloadid countrydestination countryoforigin dischargeplace deliveryplace
EXTERNALLOAD ID COUNTRY DESTINATIONCOUNTRY OF ORIGIN DISCHARGE PLACE DELIVERY PLACE
vehicletype containerkey vehiclenumber vehicledate seal
VEHICLE TYPE CONTAINER NO VEHICLE NUMBER VEHICLE DATE SEAL
sealcustom sealcab susr1 susr2 susr3
SEAL CUSTOME SEAL CAB USER DEFINE1 USER DEFINE2 USER DEFINE3
susr4 tripid sku uom originalqty
USER DEFINE4 TRIPID ITEM CODE UOM QTY ORDER
THUTEST CAI 1
THUTEST CAI 1
THUTEST CAI 1
THUTEST CAI 1
THUTEST CAI 1
THUTEST CAI 1
THUTEST CAI 1
THUTEST CAI 1
THUTEST CAI 1
THUTEST CAI 1
THUTEST CAI 1
THUTEST CAI 1
THUTEST CAI 1
THUTEST CAI 1
THUTEST CAI 1
THUTEST CAI 1
THUTEST CAI 1
THUTEST CAI 1
THUTEST CAI 1
THUTEST CAI 1
THUTEST CAI 1
THUTEST CAI 1
THUTEST CAI 1
THUTEST CAI 1
THUTEST CAI 1
THUTEST CAI 1
THUTEST CAI 1
THUTEST CAI 1
THUTEST CAI 1
THUTEST CAI 1
THUTEST CAI 1
THUTEST CAI 1
THUTEST CAI 1
THUTEST CAI 1
THUTEST CAI 1
THUTEST CAI 1
THUTEST CAI 1
THUTEST CAI 1
THUTEST CAI 1
THUTEST CAI 1
THUTEST CAI 1
THUTEST CAI 1
THUTEST CAI 1
THUTEST CAI 1
THUTEST CAI 1
THUTEST CAI 1
THUTEST CAI 1
THUTEST CAI 1
THUTEST CAI 1
THUTEST CAI 1
THUTEST CAI 1
THUTEST CAI 1
THUTEST CAI 1
THUTEST CAI 1
THUTEST CAI 1
THUTEST CAI 1
THUTEST CAI 1
THUTEST CAI 1
THUTEST CAI 1
THUTEST CAI 1
THUTEST CAI 1
THUTEST CAI 1
THUTEST CAI 1
THUTEST CAI 1
THUTEST CAI 1
THUTEST CAI 1
THUTEST CAI 1
THUTEST CAI 1
THUTEST CAI 1
THUTEST CAI 1
THUTEST CAI 1
THUTEST CAI 1
THUTEST CAI 1
THUTEST CAI 1
THUTEST CAI 1
THUTEST CAI 1
THUTEST CAI 1
THUTEST CAI 1
THUTEST CAI 1
THUTEST CAI 1
THUTEST CAI 1
THUTEST CAI 1
THUTEST CAI 1
THUTEST CAI 1
THUTEST CAI 1
THUTEST CAI 1
THUTEST CAI 1
THUTEST CAI 1
THUTEST CAI 1
THUTEST CAI 1
THUTEST CAI 1
THUTEST CAI 1
THUTEST CAI 1
THUTEST CAI 1
THUTEST CAI 1
THUTEST CAI 1
THUTEST CAI 1
THUTEST CAI 1
THUTEST CAI 1
THUTEST CAI 1
THUTEST CAI 1
THUTEST CAI 1
THUTEST CAI 1
THUTEST CAI 1
THUTEST CAI 1
THUTEST CAI 1
THUTEST CAI 1
THUTEST CAI 1
THUTEST CAI 1
THUTEST CAI 1
THUTEST CAI 1
THUTEST CAI 1
THUTEST CAI 1
THUTEST CAI 1
THUTEST CAI 1
THUTEST CAI 1
THUTEST CAI 1
THUTEST CAI 1
THUTEST CAI 1
THUTEST CAI 1
THUTEST CAI 1
THUTEST CAI 1
THUTEST CAI 1
THUTEST CAI 1
THUTEST CAI 1
THUTEST CAI 1
THUTEST CAI 1
THUTEST CAI 1
THUTEST CAI 1
THUTEST CAI 1
THUTEST CAI 1
THUTEST CAI 1
THUTEST CAI 1
THUTEST CAI 1
THUTEST CAI 1
THUTEST CAI 1
THUTEST CAI 1
THUTEST CAI 1
THUTEST CAI 1
THUTEST CAI 1
THUTEST CAI 1
THUTEST CAI 1
THUTEST CAI 1
THUTEST CAI 1
THUTEST CAI 1
THUTEST CAI 1
THUTEST CAI 1
THUTEST CAI 1
THUTEST CAI 1
THUTEST CAI 1
THUTEST CAI 1
THUTEST CAI 1
THUTEST CAI 1
THUTEST CAI 1
THUTEST CAI 1
THUTEST CAI 1
THUTEST CAI 1
THUTEST CAI 1
THUTEST CAI 1
THUTEST CAI 1
THUTEST CAI 1
THUTEST CAI 1
THUTEST CAI 1
THUTEST CAI 1
THUTEST CAI 1
THUTEST CAI 1
THUTEST CAI 1
THUTEST CAI 1
THUTEST CAI 1
THUTEST CAI 1
THUTEST CAI 1
THUTEST CAI 1
THUTEST CAI 1
THUTEST CAI 1
THUTEST CAI 1
THUTEST CAI 1
THUTEST CAI 1
THUTEST CAI 1
THUTEST CAI 1
THUTEST CAI 1
THUTEST CAI 1
THUTEST CAI 1
THUTEST CAI 1
THUTEST CAI 1
THUTEST CAI 1
THUTEST CAI 1
THUTEST CAI 1
THUTEST CAI 1
THUTEST CAI 1
THUTEST CAI 1
THUTEST CAI 1
THUTEST CAI 1
THUTEST CAI 1
THUTEST CAI 1
THUTEST CAI 1
THUTEST CAI 1
THUTEST CAI 1
THUTEST CAI 1
THUTEST CAI 1
THUTEST CAI 1
THUTEST CAI 1
unitprice lottable01 lottable02 lottable03 lottable04
UNIT PRICE LOTTABLE01 LOTTABLE02 LOTTABLE03 LOTTABLE04
lottable05 lottable06 lottable07 lottable08 lottable09
LOTTABLE05 LOTTABLE06 LOTTABLE07 LOTTABLE08 LOTTABLE09
lottable10 lottable11 lottable12 discount vat
LOTTABLE10 LOTTABLE11 LOTTABLE12 DISCOUNT VAT
unitid cartonid palletid cube grosswgt
UNITID CARTONID PALLETID CBM KG
netwgt loc notesdetail shelflife saleorderkey
NETWGT LOCATION REMARKDETAIL SHELFLIFE SALEORDERKEY
originplace transitplace shippinglines checkcontainertime requestedshipdate_mp
ORIGIN PLACE TRANSIT PLACE SHIPPINGLINES CHECK CONTAINER TIME REQUESTED SHIP DATE MP
susr1_detail susr2_detail susr3_detail susr4_detail susr5_detail
USER DEFINE 1 DETAIL
USER DEFINE 2 DETAIL
USER DEFINE 3 DETAIL USER DEFINE 4 DETAIL USER DEFINE 5 DETAIL
transactiontype conditioncode towhseid notes2
TRANSACTION TYPE CONDITIONCODE TO WHSEID REMARK 2
transportcharges dayoff susr6 susr7
TRANSPORT CHARGES DAY OFF USER DEFINE 6 USER DEFINE 7
susr8 susr9 susr10 susr11
USER DEFINE 8 USER DEFINE 9 USER DEFINE 10 USER DEFINE 11
susr12 susr13 susr14 susr15
USER DEFINE 12 USER DEFINE 13 USER DEFINE 14 USER DEFINE 15
susr16 susr17 susr18 susr19
USER DEFINE 16 USER DEFINE 17 USER DEFINE 18 USER DEFINE 19
susr20 externlineno ecomlevel freegoods amountTotal
USER DEFINE 20 EXTERNLINENO ECOM LEVEL FREE GOODS AMOUNT TOTAL
droplocation susr6_detail susr7_detail susr8_detail
DROP LOCATION USER DEFINE 6 DETAIL USER DEFINE 7 DETAIL USER DEFINE 8 DETAIL
susr9_detail susr10_detail c_address2 c_address3
USER DEFINE 9 DETAIL USER DEFINE 10 DETAIL CUSTOMER ADDRESS 2 CUSTOMER ADDRESS 3
c_address4 swapsku
CUSTOMER ADDRESS 4 SWAP SKU

You might also like