ZEN CONSULTING : traslate EDI gentran format to SAP ERP format

viernes, 18 de abril de 2014

traslate EDI gentran format to SAP ERP format

En la carpeta

/export/home/evikcc/mediaGentran/IBM_GEN_Multiplatform

Hay un zip llamado

CIOJDEN cliente.zip

Este es el cliente.

Una vez que lo bajes lo descompilas y me avisas para poderte ayudar con la configuración.

entrada EDI

Actual PO(850) data from CVS.

ISA*00* *00* *ZZ*CVS *01*055826309 *121001*113

9*U*00400*000003429*0*P*^

GS*PO*CVS*055826309*20121001*1139*1378*X*004010

ST*850*2216

BEG*00*SA*0076423**20121001

REF*VR*12925

PER*BD*MICHELLE MARTINEAU

SAC*A*F050*ZZ*ZZ**1*1*****02***OTHER

ITD*01*15*2**30**31***100

DTM*002*20121022

AMT*BAP*2986

N9*L1*PO COMMENTS

MSG*THIS PO SUBJECT TO THE TERMS AND CONDITIONS FOUND ON CVS SUPPLIERS WEBSITE

N1*ST**54*Y101

N3*ONE CVS DRIVE

N4*WAVERLY*NY*14892

PO1**17*CA*175.62**UI*03288417688*UA*003288416790*PI*855752

PAM*01*2986*ZZ

PO4*6

CTT*1*17

SE*18*2216

ST*850*2217

BEG*00*SA*1265472**20121001

REF*VR*12925

PER*BD*MICHELLE MARTINEAU

SAC*A*F050*ZZ*ZZ**1*1*****02***OTHER

ITD*01*15*2**30**31***100

DTM*002*20121022

AMT*BAP*2459

N9*L1*PO COMMENTS

MSG*THIS PO SUBJECT TO THE TERMS AND CONDITIONS FOUND ON CVS SUPPLIERS WEBSITE

N1*ST**54*W101

N3*400 FOUNDERS DRIVE

N4*WOONSOCKET*RI*02895

PO1**14*CA*175.62**UI*03288417688*UA*003288416790*PI*855752

PAM*01*2459*ZZ

PO4*6

CTT*1*14

SE*18*2217

GE*2*1378

IEA*1*000003429

salida

Application file created using selected map from PO’s received.

ENV|0076423-20121001145006|CVS|0076423||X12|850S|SA00||20121001|1139

HDR|0076423-20121001145006|CVS|0076423||20121001|20121001|20121015|20121022||007

6423|||PP|055826309|||0076423|||||||||||||1|||ZZZ|||||30|31|2|01|02|||||||||||15

HAD|0076423-20121001145006|CVS|0076423|DEL|Y101

HTX|0076423-20121001145006|CVS|0076423|ARRIVAL DATE 2012/10/22

REF|0076423-20121001145006|CVS|0076423|VR|12925

LIN|0076423-20121001145006|CVS|0076423|1|6||UI|03288417688||||102|20121001|20121

015|102|EA|175.62|CA||||||||||||UI|03288417688|UA|003288416790|PI|855752||||||||

20121015

ENV|1265472-20121001145006|CVS|1265472||X12|850S|SA00||20121001|1139

HDR|1265472-20121001145006|CVS|1265472||20121001|20121001|20121015|20121022||126

5472|||PP|055826309|||1265472|||||||||||||1|||ZZZ|||||30|31|2|01|02|||||||||||15

HAD|1265472-20121001145006|CVS|1265472|DEL|W101

HTX|1265472-20121001145006|CVS|1265472|ARRIVAL DATE 2012/10/22

REF|1265472-20121001145006|CVS|1265472|VR|12925

LIN|1265472-20121001145006|CVS|1265472|1|6||UI|03288417688||||84|20121001|201210

15|84|EA|175.62|CA||||||||||||UI|03288417688|UA|003288416790|PI|855752||||||||20

121015

Crontab for AS2 data to schedule transfer of data for each customer both in and out.

# Monitor AS2 for error files

00 * * * * /opt/admin/scripts/monitoras2.ksh

#Process AS2 inbound

00 3,15,22 * * 1-6 /opt/admin/scripts/processexpeditors.ksh > /dev/null

45 9,21 * * 1-6 /opt/admin/scripts/processnyklogistics.ksh > /dev/null

05 2,6,10,14,18,22 * * 1-6 /opt/admin/scripts/processkinray.ksh > /dev/null

07 2,6,10,14,18,22 * * 1-6 /opt/admin/scripts/processmol.ksh > /dev/null

10 2,6,10,14,18,22 * * 1-6 /opt/admin/scripts/processstaterbros.ksh > /dev/null

15 2,6,10,14,18,22 * * 1-6 /opt/admin/scripts/processmeijer.ksh > /dev/null

20 2,6,10,14,18,22 * * 1-6 /opt/admin/scripts/processlowes.ksh > /dev/null

23 2,6,10,14,18,22 * * 1-6 /opt/admin/scripts/processbabyage.ksh > /dev/null

24 2,6,10,14,18,22 * * 1-6 /opt/admin/scripts/processfreshandeasy.ksh > /dev/null

#25 2,6,10,14,18,22 * * 1-6 /opt/admin/scripts/processamazon.ksh > /dev/null

25 2,6,10,14,18,22 * * 1-6 /opt/admin/scripts/processamazonas2.ksh > /dev/null

26 2,6,10,14,18,22 * * 1-6 /opt/admin/scripts/processvcprod.ksh > /dev/null

27 2,6,10,14,18,22 * * 1-6 /opt/admin/scripts/processowens.ksh > /dev/null

28 2,6,10,14,18,22 * * 1-6 /opt/admin/scripts/processcsn.ksh > /dev/null

29 2,6,10,14,18,22 * * 1-6 /opt/admin/scripts/processcardinalmps.ksh > /dev/null

30 2,6,10,14,18,22 * * 1-6 /opt/admin/scripts/processacosta.ksh > /dev/null

31 2,6,10,14,18,22 * * 1-6 /opt/admin/scripts/processetoys.ksh > /dev/null

32 2,6,10,14,18,22 * * 1-6 /opt/admin/scripts/processcommercehub.ksh > /dev/null

33 2,6,10,14,18,22 * * 1-6 /opt/admin/scripts/processwalmart.ksh > /dev/null

34 2,6,10,14,18,22 * * 1-6 /opt/admin/scripts/processbcf.ksh > /dev/null

35 2,6,10,14,18,22 * * 1-6 /opt/admin/scripts/processtoys.ksh > /dev/null

36 2,6,10,14,18,22 * * 1-6 /opt/admin/scripts/processoverstock.ksh > /dev/null

37 2,6,10,14,18,22 * * 1-6 /opt/admin/scripts/processbbb.ksh > /dev/null

#38 2,6,10,14,18,22 * * 1-6 /opt/admin/scripts/processojc.ksh > /dev/null

39 2,6,10,14,18,22 * * 1-6 /opt/admin/scripts/processraleysprod.ksh > /dev/null

40 2,6,10,14,18,22 * * 1-6 /opt/admin/scripts/processsearsca.ksh > /dev/null

45 2,6,10,14,18,22 * * 1-6 /opt/admin/scripts/processsterling.ksh > /dev/null

50 2,6,10,14,18,22 * * 1-6 /opt/admin/scripts/processtarget.ksh > /dev/null

52 2,6,10,14,18,22 * * 1-6 /opt/admin/scripts/processweber.ksh > /dev/null

#Process AS2 outbound

00,30,45 * * * 1-6 /opt/admin/scripts/outboundsterling.ksh > /dev/null

00,30,45 * * * 1-6 /opt/admin/scripts/outboundlowes.ksh > /dev/null

00,30,45 * * * 1-6 /opt/admin/scripts/outboundmeijer.ksh > /dev/null

#00,30,45 * * * 1-6 /opt/admin/scripts/outboundamazon.ksh > /dev/null

00,30,45 * * * 1-6 /opt/admin/scripts/outboundamazonas2.ksh > /dev/null

00,30,45 * * * 1-6 /opt/admin/scripts/outboundowens.ksh > /dev/null

00,30,45 * * * 1-6 /opt/admin/scripts/outboundcardinalmps.ksh > /dev/null

00,30,45 * * * 1-6 /opt/admin/scripts/outboundstaterbros.ksh > /dev/null

00,30,45 * * * 1-6 /opt/admin/scripts/outboundsearsca.ksh > /dev/null

00,30,45 * * * 1-6 /opt/admin/scripts/outboundtoys.ksh > /dev/null

00,30,45 * * * 1-6 /opt/admin/scripts/outboundetoys.ksh > /dev/null

00,30,45 * * * 1-6 /opt/admin/scripts/outboundwalmart.ksh > /dev/null

00,30,45 * * * 1-6 /opt/admin/scripts/outboundtarget.ksh > /dev/null

00,30,45 * * * 1-6 /opt/admin/scripts/outboundkinray.ksh > /dev/null

00,30,45 * * * 1-6 /opt/admin/scripts/outboundraleysprod.ksh > /dev/null

00,30,45 * * * 1-6 /opt/admin/scripts/outboundbabyage.ksh > /dev/null

00,30,45 * * * 1-6 /opt/admin/scripts/outboundvcprod.ksh > /dev/null

00,30,45 * * * 1-6 /opt/admin/scripts/outboundcsn.ksh > /dev/null

00,30,45 * * * 1-6 /opt/admin/scripts/outboundbcf.ksh > /dev/null

00,30,45 * * * 1-6 /opt/admin/scripts/outboundfreshandeasy.ksh > /dev/null

00,30,45 * * * 1-6 /opt/admin/scripts/outboundoverstock.ksh > /dev/null

#00,30,45 * * * 1-6 /opt/admin/scripts/outboundojc.ksh > /dev/null

00,30,45 * * * 1-6 /opt/admin/scripts/outboundbbb.ksh > /dev/null

00,30,45 * * * 1-6 /opt/admin/scripts/outboundacosta.ksh > /dev/null

00,30,45 * * * 1-6 /opt/admin/scripts/outboundcommercehub.ksh > /dev/null

00,30,45 * * * 1-6 /opt/admin/scripts/outboundweber.ksh > /dev/null

05,20,35,50 * * * 1-6 /opt/admin/scripts/outboundexpeditors.ksh > /dev/null

05,20,35,50 * * * 1-6 /opt/admin/scripts/outboundmol.ksh > /dev/null

05,30 * * * 1-6 /opt/admin/scripts/outboundnyklogistics.ksh > /dev/null

Crontab for scheduling translation and backup of AS2 data. Also schedules all other EDI jobs non-baan.

#####

#######

#### crontab for ediprod on ap01

###

######## Transfer US CANADA translated data to Baan

#10 3,7,11,15,19,23 * * 1-6 /edi/gentran/61/usr_bin/xfer2b.cr > /edi/gentran/61/

usr_bin/xfer2b.err 2>&1

###

######## Transfer US translated data to Baan

10 3,7,11,15,19,23 * * 1-6 /edi/gentran/61/usr_bin/xferus.cr > /edi/gentran/61/u

sr_bin/xfer2b.err 2>&1

###

######## Transfer CANADA translated data to Baan

12 3,11,15,19 * * 1-6 /edi/gentran/61/usr_bin/xferca.cr > /edi/gentran/61/usr_bi

n/xfer2b.err 2>&1

###

######## Transfer MX translated data to Baan

11 3,7,11,13,15,18,19,23 * * 1-6 /edi/gentran/61/usr_bin/xfermx.cr > /edi/gentra

n/61/usr_bin/xfer2b.err 2>&1

###

######## Transfer WEBER 945 translated data to Baan

13 3,7,11,15,19,23 * * 1-6 /edi/gentran/61/usr_bin/xfer945W.cr > /edi/gentran/61

/usr_bin/xfer2b.err 2>&1

###

######## Transfer EXPEDITOR 945 translated data to Baan

25 03,15,22 * * 1-6 /edi/gentran/61/usr_bin/xfer945E.cr > /edi/gentran/61/usr_bi

n/xfer2b.err 2>&1

###

######## Transfer NYKL 945 translated data to Baan

55 9,21 * * 1-6 /edi/gentran/61/usr_bin/xfer945N.cr > /edi/gentran/61/usr_bin/xf

er2b.err 2>&1

###

######## EDI housekeeping

###

####### CHECK TRANSLATIONS FOR ZERO QTYS #####

05 3,7,11,15,19,23 * * 1-6 /edi/gentran/61/usr_bin/qtychk0|mailx -s "Translation

QTY Check Report" uomrcps

###

#53 22 * * 0 /edi/gentran/61/usr_bin/qtychk0|mailx -s "Translation QTY Check Rep

ort" uomrcps

####### RUN PRODUCT ACTIVITY DATA (852) TO ORACLE #####

30 14 * * 1-5 /edi/gentran/61/usr_bin/pad2db0.pl -o mail -L 2> /edi/gentran/61/u

sr_bin/pad2db.err

####### RUN PRODUCT ACTIVITY REPORT (852) #####

##46 13 * * 1-5 /edi/gentran/61/usr_bin/padrpt9 > /edi/gentran/61/usr_bin/padrpt

9.err

####### RUN PLANNING SCHEDULE REPORT (830) #####

20 14 * * 1-5 /edi/gentran/61/usr_bin/psrrpt > /edi/gentran/61/usr_bin/psrrpt.er

####### RUN Organizational Relationships (816) #####

01 23 * * 1-5 /edi/gentran/61/usr_bin/816_email > /dev/null 2>&1

###

####### RUN Payment Order / Remittance Advise (820) #####

02 7,11,15 * * 1-5 /edi/gentran/61/usr_bin/820_email > /dev/null 2>&1

###

####### RUN Application Advise (824) #####

03 7,11,15 * * 1-5 /edi/gentran/61/usr_bin/824_email > /dev/null 2>&1

###

####### RUN Purchase Order Change Request (860) #####

04 7,11,15 * * 1-5 /edi/gentran/61/usr_bin/860_email > /dev/null 2>&1

###

####### RUN Text Message (864) #####

05 7,11,15 * * 1-5 /edi/gentran/61/usr_bin/864_email > /dev/null 2>&1

###

####### RUN Order Status Inquiry (869) #####

07 23 * * 1-5 /edi/gentran/61/usr_bin/869_email > /dev/null 2>&1

###

####### RUN CREDIT DEBIT ADJUSTMENT REPORT (812) #####

39 2,6,10,14,18,22 * * 1-6 /edi/gentran/61/usr_bin/cdarpt > /edi/gentran/61/usr_

bin/cdarpt.err

###

06 3,7,11,15,19,23 * * 1-6 /edi/gentran/61/usr_bin/cdarpt > /edi/gentran/61/usr_

bin/cdarpt.err

####### RUN XLLD REJECT UPDATE ################

30 2,6,10,18,22 * * 1-6 /edi/gentran/61/usr_bin/reprocess_xlld.sh > /edi/gentran

/61/usr_bin/reprocess_xlld.err

###

##### Process Kinray #####

10 02,06,10,14,18,22 * * 1-6 /opt/admin/scripts/process_kinray.ksh

##### Process MOL #####

12 02,06,10,14,18,22 * * 1-6 /opt/admin/scripts/process_mol.ksh

##### Process Stater Bros #####

15 02,06,10,14,18,22 * * 1-6 /opt/admin/scripts/process_staterbros.ksh

##### Process Meijer #####

20 02,06,10,14,18,22 * * 1-6 /opt/admin/scripts/process_meijer.ksh

##### Process Lowes #####

25 02,06,10,14,18,22 * * 1-6 /opt/admin/scripts/process_lowes.ksh

##### Process BABYAGE #####

28 02,06,10,14,18,22 * * 1-6 /opt/admin/scripts/process_babyage.ksh

##### Process FREASHANDEASY #####

29 02,06,10,14,18,22 * * 1-6 /opt/admin/scripts/process_freshandeasy.ksh

##### Process Amazon #####

#30 02,06,10,14,18,22 * * 1-6 /opt/admin/scripts/process_amazon.ksh

30 02,06,10,14,18,22 * * 1-6 /opt/admin/scripts/process_amazonas2.ksh

##### Process BJS #####

31 02,06,10,14,18,22 * * 1-6 /opt/admin/scripts/process_vcprod.ksh

##### Process Owens #####

32 02,06,10,14,18,22 * * 1-6 /opt/admin/scripts/process_owens.ksh

##### Process CSN #####

33 02,06,10,14,18,22 * * 1-6 /opt/admin/scripts/process_csn.ksh

##### Process Cardinal #####

34 02,06,10,14,18,22 * * 1-6 /opt/admin/scripts/process_cardinal.ksh

##### Process Acosta #####

35 02,06,10,14,18,22 * * 1-6 /opt/admin/scripts/processacosta.ksh

##### Process etoys #####

36 02,06,10,14,18,22 * * 1-6 /opt/admin/scripts/process_etoys.ksh

##### Process CommerceHub #####

37 02,06,10,14,18,22 * * 1-6 /opt/admin/scripts/processcommercehub.ksh

##### Process AS2 Wal-Mart data #####

38 02,06,10,14,18,22 * * 1-6 /opt/admin/scripts/processas2.ksh

##### Process AS2 Burlington data #####

39 02,06,10,14,18,22 * * 1-6 /opt/admin/scripts/process_bcf.ksh

##### Process AS2 TOYS R US data #####

40 02,06,10,14,18,22 * * 1-6 /opt/admin/scripts/process_tru.ksh

##### Process AS2 OVERSTOCK data #####

41 02,06,10,14,18,22 * * 1-6 /opt/admin/scripts/process_overstock.ksh

##### Process AS2 BBB data #####

42 02,06,10,14,18,22 * * 1-6 /opt/admin/scripts/process_bbb.ksh

##### Process AS2 OJCOMMERCE data #####

#43 02,06,10,14,18,22 * * 1-6 /opt/admin/scripts/process_ojc.ksh

##### Process AS2 RALEYS data #####

44 02,06,10,14,18,22 * * 1-6 /opt/admin/scripts/process_raleys.ksh

##### Process Sears Canada #####

45 02,06,10,14,18,22 * * 1-6 /opt/admin/scripts/process_searsca.ksh

##### Process GARCES EDI DATA ######

46 02,06,10,12,14,17,18,22 * * 1-5 /opt/admin/scripts/processmx3.ksh

##### Process GARCIA EDI DATA ######

47 02,06,10,12,14,17,18,22 * * 1-5 /opt/admin/scripts/processmx2.ksh

##### Process NADRO EDI DATA ######

48 02,06,10,12,14,17,18,22 * * 1-5 /opt/admin/scripts/processmx1.ksh

##### Process COMERSA EDI DATA ######

49 02,06,10,12,14,17,18,22 * * 1-5 /opt/admin/scripts/processmx.ksh

##### Process Sterling AS2 Data #####

50 02,06,10,14,18,22 * * 1-6 /opt/admin/scripts/process_sterling.ksh

##### Process MARZAM EDI DATA ######

51 02,06,10,12,14,17,18,22 * * 1-5 /opt/admin/scripts/processmx4.ksh

##### Process Gigante EDI Data #####

52 02,06,10,12,14,17,18,22 * * 1-6 /opt/admin/scripts/process_gigante.ksh

##### Process network6 EDI Data #####

53 02,06,10,14,18,22 * * 1-6 /opt/admin/scripts/process_network6.ksh

##### Process network3 EDI Data #####

54 02,06,10,14,18,22 * * 1-6 /opt/admin/scripts/process_network3.ksh

##### Process Target #####

55 02,06,10,14,18,22 * * 1-6 /opt/admin/scripts/process_target.ksh

##### Process Weber #####

57 02,06,10,14,18,22 * * 1-6 /opt/admin/scripts/process_weber.ksh

##### Process Walgreen vendor split #####

56 02,06,10,14,18,22 * * 1-6 /opt/admin/scripts/process_walgreensplit.ksh

##### Process network2 EDI Data #####

57 02,06,10,14,18,22 * * 1-6 /opt/admin/scripts/process_network2.ksh

##### Process Expeditors 945 #####

05 03,15,22 * * 1-6 /opt/admin/scripts/process_expeditors.ksh

##### Process NYKL 945 #####

50 09,21 * * 1-6 /opt/admin/scripts/process_nykl.ksh