Azerty Inc., Buffalo, NY.
PROJECT REPORT ON THE HARBINGER INBOUND PURCHASE ORDER MAP(850) FOR AZERTY Inc., Buffalo, NY.
By: Madhukar Srinivasaiah
Harbinger and SAP Consultant
For the time period between June 01, 1999 to June 15, 1999, the following tasks were completed:
1. The EDI Representative, the Trading Partner (Target), the Inbound Application and the Inbound Event were set up in the Harbinger Operations Center Client.
2. Set up was also done for the outbound Functional Acknowledgement(997).
3. An Inbound Event(AZ850IN) was created in the Mapping Workbench and the mapping table files sent by Harbinger were imported into the workbench.
4. The Event Alias name in the trading partner-inbound event properties of Ops Center was specified as AZ850IN.
5. The following segments which were found missing in the original map were included: FOB, CSH, SAC, CTP, PID, P04, SAC, SE.
6. The Delimiter property in the Inbound application of Ops Center was set as "$" for the field separator.
7. The mapping logic to obtain the Internal Vendor Number in the Header Record of the Application in the workbench was changed to read REF02 when the REF01 qualifier was "IA". The logic pertaining to the remaining qualifiers of REF01 were deleted.
8. The Azerty Customer Number in the Header record was hard-coded to be "006344".
9. An Internal Cross Reference was built in the Inbound Application of Ops Center to cross reference the Ship to Number using the Distribution Center Number contained as the last four numbers in the Purchase order number of BEG03 element. The corresponding logic was added in the workbench to populate the ShipToNumber field of the Header record.
10. In the Address record, the N101 element qualifier was changed to read for "BY" qualifier (Bill To or Buyer), as against the original "BT" qualifier.
11. The logic for populating Description field in the Detail record was deleted. The new logic consisted of mapping PID05 to the Description field, with the look ahead-on feature.
12. Translation and Testing was done to check data integrity and the Application file(output) was found to be satisfactory.
13. Events for Outbound 810 and 856 were also created and the table files from Harbinger were imported into the Workbench.
Note: The input test file from GEIS(Target), the translated Application file, Azerty's application flat-file layout and the mapping command instructions have been appended with this report.
Test Input File for AZ850IN
ISA*00* *00* *ZZ*MK81964 *01*175769512 *001103*1542*U*00401*000000201*0*T*>
GS*PO*MK81964*175769512*20001103*1542*11111*X*004010
ST*850*0097
BEG*00*SA*0123-TEST567-0551**20001103
REF*IA*1234567*VENDOR NAME1
REF*DP*123
REF*PD*2345BTS
FOB*DF*OR*COLUMBUS OH
CSH*N
SAC*N**VI*OHPR
ITD*01*2*0**30
DTM*037*20001108
DTM*038*20001115
DTM*015*20001116
TD5*B*2*HYMF*M
N9*ZZ*SPH
MSG*SPECIAL HANDLING REQUIRED
N1*BY**92*2902
N3*1930 ENERGY PARK D
N4*ST PAUL*MN*55108*US
PO1*1*100*EA*100**CB*023783090*VA*87640BLU*UP*024389600932
CTP*RS*RES*123.9
PID*F*08***MERCHANDISE DESCRIPTION
PO4*25*************4
SAC*N**VI*TC990101*********CT1234
SAC*N**VI*HA
CTT*1
SE*26*0097
ST*850*0098
BEG*00*BK*0024-TEST123-0552**20001103
REF*IA*2345678*VENDOR NAME2
REF*DP*024
REF*PD*0912873465
FOB*DF*OR*SYRACUS NY
CSH*Y
SAC*N**VI*OHKO
ITD*02*3*0**30
DTM*063*20001106
DTM*064*20001108
TD5*B*92*SEE ROUTING GUIDE*C
N1*BY**92*2090
PO1*1*50*EA*54.49**CB*020003449*VA*VC9823*UP*092387900065
CTP*RS*RES*75
PID*F*08***MERCHANDISE DESCRIPTION
PO4*50*************1
SAC*N**VI*TC990101*********CT1234
CTT*1
SE*20*0098
ST*850*0099
BEG*00*SA*0067-TEST987-0553**20001103
REF*IA*3456789*VENDOR NAME3
REF*DP*067
FOB*DF*DE*CHICAGO IL
CSH*N
ITD*04*4*0**30
DTM*063*19981107
DTM*064*20001110
TD5*B*92*PRE PAID ROADWAY*M
N1*BY**92*3001
N1*ST*SHIP VIA VCD*92*3902
N3*4111 GEORGE ST
N4*CHICAGO*IL*60641*US
PO1*1*500*EA*123.9**CB*234896781*VA*PP987*UP*087602376202
CTP*RS*RES*150
PID*F*08***MERCHANDISE DESCRIPTION
PO4*1*************1
SAC*N**VI*TC990101*********CT1234
PO1*2*500*EA*133.9**CB*234896782*VA*PP988*UP*087602376303
CTP*RS*RES*160
PID*F*08***MERCHANDISE DESCRIPTION
PO4*1*************1
SAC*N**VI*TC990101*********CT1266
CTT*2
SE*26*0099
ST*850*0100
BEG*06*SA*0067-TEST567-0554**20001103
REF*IA*0234567*VENDOR NAME4
REF*DP*067
FOB*DF*DE*CHICAGO IL
CSH*N
ITD*05*2*0**30
DTM*063*20001107
DTM*064*19981110
TD5*B*2*HYMF*M
N1*BY**92*3004
N1*ST*JOHN SMITH
N3*1000 MICHIGAN AVE
N4*CHICAGO*IL*60641*US
PO1*1*1*EA*100**CB*298534981*VA*SCR12*UP*073251074003
CTP*RS*RES*123.9
PID*F*08***MERCHANDISE DESCRIPTION
PO4*1
SAC*N**VI*TC990101*********CT1234
CTT*1
SE*21*0100
GE*4*11111
IEA*1*000000201
Test Output File for AZ850IN
H$0123-TEST567-0551$110300$1234567$006344 $SPECIAL HANDLING REQUIRED$UGC$NO$YES$0005$
A$billto$$1930 ENERGY PARK D$$ST PAUL$MN$55108$US
L$1$100$EA$100$023783090$$024389600932
S$1
H$0024-TEST123-0552$110300$2345678$006344 $$UGC$NO$YES$0006$
A$billto$$$$$$$
L$1$50$EA$54.49$020003449$$092387900065
S$1
H$0067-TEST987-0553$110300$3456789$006344 $$UGC$NO$YES$0004$
A$billto$$$$$$$
A$shipto$SHIP VIA VCD$4111 GEORGE ST$$CHICAGO$IL$60641$US
L$1$500$EA$123.9$234896781$$087602376202
S$1
H$0067-TEST567-0554$110300$0234567$006344 $$UGC$NO$YES$0001$
A$billto$$$$$$$
A$shipto$JOHN SMITH$1000 MICHIGAN AVE$$CHICAGO$IL$60641$US
L$1$1$EA$100$298534981$$073251074003
S$1
.
.
.
.