Friday, January 9, 2009

Common Methods of Shipment requested by the Retailer


The complex way of transportation, at times, makes delivery processing very cumbersome. Many a times it raises logistical intricacy with transporter or the supplying vendor. The shipment manifest or the shipping consignment should carry proper marking details including dispatch sequence. This process gets even more complicated when the Retailer wants abnormal dispatch sequencing. To cater these requirements, we use particular segment or set of segments to facilitate during EDI transmission. While transmission of such data we have to keep in mind whether the VAN’s EDI support system can handle the complex scenario properly or not. Through our experience we have found that faulty support created transmission bottleneck and improper routing sequence.

The most used shipment methods with x12 data samples are given below :


Basic Shipment

Basic orders when a quantity of product is ordered without specific mention of which store location is to ultimately receive the merchandise. The entire lot is shipped to the distribution facility and will be distributed to the various stores as needed. A Basic Purchase Order can be identified by an occurrence of the header level N1 segment with a “BY” qualifier in N101 to specify the buying party, and the absence of an SDQ segment in the Detail Segment of the Order. The N1 Segment will identity the distribution facility location issued in the Global Location Number format.

ISA*00* *00* *12*9086880888T *12*to be filled up len 15*060525*1248*U*00401*000000166*0*P*>
GS*PO*9086880888T*to be filled up*20060607*1248*1*X*004010
ST*850*10002
BEG*00*SA*DH48130**20050406
REF*IA*6 digit vendor#
CSH*SC
SAC*A*E750****3*5**ZZ*0*30
DTM*001* 20050701
DTM*010* 20050609
N1*BY*SCHAUMBURG*92* 0145
PO1**24*EA*3.78**UP*081492463009
PO1**48*EA*1.2**UP*081492389002
PO1**36*EA*2.79**UP*081492462392
CTT*3
SE*13*10002
GE*1*1
IEA*1*000000166

Spreadsheet Shipment

Spreadsheet Orders are those in which the product is ordered for multiple store location and shipped directly to those store locations. A Spreadsheet Purchase Order can be identified by an occurrence of a header level N1 segment with a “FR” qualifier in N101, and the presence of an SDQ found in the Detail section of the Purchase Order that specifies the various Store Numbers in the Global Location Number format.

ISA*00* *00* *12*9732397773T *12*to be filled up len 15*060525*1248*U*00401*000000170*0*P*>
GS*PO*9732397773T*to be filled up*20060607*1248*1*X*004010
ST*850*10003
BEG*00*SA*DX45902**20050614
REF*IA*6 digit vendor#
DTM*001* 20050722
DTM*010* 20050630
N1*FR*Ferari*92* 0145
PO1**600*EA*6.5**UP*053124549801
SDQ*EA*92*0008*120*0020*180*0023*60*0024*60*0025*90*0026*90
PO1**400*EA*2.6**UP*053124549818
SDQ*EA*92*0008*80*0020*120*0023*40*0024*40*0025*60*0026*60
PO1**250*EA*3.9**UP*053124549788
SDQ*EA*92*0008*50*0020*75*0023*24*0024*25*0025*38*0026*38
CTT*3
SE*14*10003
GE*1*1
IEA*1*000000170

Cross-Dock Shipment

Cross-Dock orders are used when the product ordered is pre-sorted by the vendor by store location, but shipped to a distribution facility rather than to a store location. A Cross-Dock Purchase Order can be identified by having an N1 Segment with ST in N101 and the SDQ Segment listing the store locations in the detail

ISA*00* *00* *01*245588694*01*VENDORDUNS*060525*1248*U*00401*000000001*0*T*>
GS*PO*245588694*VENDORDUNS*20060525*1248*1*X*004010
ST*850*0001
BEG*00*SA*COSTCO001**20060525
REF*VR*VEN01
REF*DP*C001*COSTCO DEPARTMENT
REF*19*C9*COSTCO REGION
REF*ZZ*COSTCOV999*COSTCO BUYER VENDOR NUMBER
FOB**ZZ*LOCATION DESCRIPTION
SAC*A*ZZZZ***990*******02***ALLOWANCE DESCRIPTION
ITD***3*20060601********TERMS OF SALES DESCRIPTION
DTM*175*20060725
DTM*002*20060620
DTM*010*20060613
TD5*****ROUTING INSTRUCTION
N9*H7*SPECIAL INSTRUCTION
MSG*SPECIAL INSTRUCTION TEXT
MSG*SPECIAL INSTRUCTION TEXT
MSG*SPECIAL INSTRUCTION TEXT
N9*H5*LEGAL DISCLAIMER
MSG*LEGAL DISCLAIMER TEXT
MSG*LEGAL DISCLAIMER TEXT
MSG*LEGAL DISCLAIMER TEXT
N1*ST*COSTCO WH CN*9*2455886942222
N3*112 ABC 1# LANE
N4*VANCUVER*VA*9988528
PER*RE**TE*2244558
PO1*01*90*CA*200**UA*12345679124*IN*COSTCO'S ITEM NUMBER
PID*F****VIM DETERGENT
SAC*C*ZZZZ***10*******06***CHARGE DESCRIPTION
SDQ*EA*92*0008*50*0020*10*0023*10*0024*15*0025*05
PO1*02*90*CA*200**UI*12345679125*IN*COSTCO'S ITEM NUMBER
PID*F****ICI SNOWSAME EXTERIOR PAINT
SAC*C*ZZZZ***10*******06***CHARGE DESCRIPTION
SDQ*EA*92*0008*50*0020*20*0023*20
PO1*03*90*CA*200**UP*12345679126*IN*COSTCO'S ITEM NUMBER
PID*F****ICI SNOWSAME EXTERIOR PAINT
SAC*C*ZZZZ***10*******06***CHARGE DESCRIPTION
CTT*3*270
SE*38*0001
GE*1*1
IEA*1*000000001.

There are many more types of dispatch requirement. For further queries, mail me at ambarnath@crossroadtechnologies.in