stevegray
4Penny.net
Points: 55409

11/3/2012 12:35:58 PM

eConnect - Retrieve a Sales Document

* This article, and all our great eConnect documentation, Is available on the eConnect menu

This actually took me quite a while to figure out, there are no good examples on how to retrieve 'multi key' documents and no good help on figuring out what the keys are.

The example will document using eConnectOut to retrieve a Sales_Transaction document using the SOPNUMBE and SOPTYPE. We show how to use 'INDEX1FROM' and 'INDEX1TO', as well as how to use the WHERECLAUSE.

When retrieved, the sales document looks like this:

 

<root>
    <eConnect ACTION="0" Requester_DOCTYPE="Sales_Transaction" DBNAME="TWO" TABLENAME="SOP10100" DATE1="1900-01-01T00:00:00" SOPNUMBE="TEST01" SOPTYPE="3">
        <SO_Trans>
            <SOPNUMBE>TEST01</SOPNUMBE>
            <SOPTYPE>3</SOPTYPE>
            <ORIGTYPE>0</ORIGTYPE>
            <ORIGNUMB></ORIGNUMB>
            <DOCID>STDINV</DOCID>
            <DOCDATE>2017-04-12T00:00:00</DOCDATE>
            <GLPOSTDT>1900-01-01T00:00:00</GLPOSTDT>
            <QUOTEDAT>1900-01-01T00:00:00</QUOTEDAT>
            <QUOEXPDA>1900-01-01T00:00:00</QUOEXPDA>
            <ORDRDATE>1900-01-01T00:00:00</ORDRDATE>
            <INVODATE>2017-04-12T00:00:00</INVODATE>
            <BACKDATE>1900-01-01T00:00:00</BACKDATE>
            <RETUDATE>1900-01-01T00:00:00</RETUDATE>
            <ReqShipDate>2017-04-12T00:00:00</ReqShipDate>
            <FUFILDAT>2017-04-12T00:00:00</FUFILDAT>
            <ACTLSHIP>2017-04-12T00:00:00</ACTLSHIP>
            <DISCDATE>2017-04-12T00:00:00</DISCDATE>
            <DUEDATE>2017-05-12T00:00:00</DUEDATE>
            <REPTING>0</REPTING>
            <TRXFREQU>0</TRXFREQU>
            <TIMEREPD>0</TIMEREPD>
            <TIMETREP>0</TIMETREP>
            <DYSTINCR>0</DYSTINCR>
            <DTLSTREP>1900-01-01T00:00:00</DTLSTREP>
            <DSTBTCH1></DSTBTCH1>
            <DSTBTCH2></DSTBTCH2>
            <USDOCID1>BKORD</USDOCID1>
            <USDOCID2></USDOCID2>
            <DISCFRGT>0.00000</DISCFRGT>
            <ORDAVFRT>0.00000</ORDAVFRT>
            <DISCMISC>0.00000</DISCMISC>
            <ORDAVMSC>0.00000</ORDAVMSC>
            <DISAVAMT>0.00000</DISAVAMT>
            <ORDAVAMT>0.00000</ORDAVAMT>
            <DISCRTND>0.00000</DISCRTND>
            <ORDISRTD>0.00000</ORDISRTD>
            <DISTKNAM>0.00000</DISTKNAM>
            <ORDISTKN>0.00000</ORDISTKN>
            <DSCPCTAM>0</DSCPCTAM>
            <DSCDLRAM>0.00000</DSCDLRAM>
            <ORDDLRAT>0.00000</ORDDLRAT>
            <DISAVTKN>0.00000</DISAVTKN>
            <ORDATKN>0.00000</ORDATKN>
            <PYMTRMID>Net 30</PYMTRMID>
            <PRCLEVEL>SPECIAL</PRCLEVEL>
            <LOCNCODE>WAREHOUSE</LOCNCODE>
            <BCHSOURC>Sales Entry</BCHSOURC>
            <BACHNUMB>STEVE</BACHNUMB>
            <CUSTNMBR>AARONFIT0001</CUSTNMBR>
            <CUSTNAME>Aaron Fitz Electrical</CUSTNAME>
            <CSTPONBR></CSTPONBR>
            <PROSPECT>0</PROSPECT>
            <MSTRNUMB>452</MSTRNUMB>
            <PCKSLPNO></PCKSLPNO>
            <PICTICNU></PICTICNU>
            <MRKDNAMT>0.00000</MRKDNAMT>
            <ORMRKDAM>0.00000</ORMRKDAM>
            <PRBTADCD>PRIMARY</PRBTADCD>
            <PRSTADCD>WAREHOUSE</PRSTADCD>
            <CNTCPRSN>Bob Fitz</CNTCPRSN>
            <ShipToName>Aaron Fitz Electrical</ShipToName>
            <ADDRESS1>11403 45 St. South</ADDRESS1>
            <ADDRESS2></ADDRESS2>
            <ADDRESS3></ADDRESS3>
            <CITY>Chicago</CITY>
            <STATE>IL</STATE>
            <ZIPCODE>60603-0776</ZIPCODE>
            <COUNTRY>USA</COUNTRY>
            <PHNUMBR1>31255501020000</PHNUMBR1>
            <PHNUMBR2>31255501020000</PHNUMBR2>
            <PHONE3></PHONE3>
            <FAXNUMBR>31255501020000</FAXNUMBR>
            <COMAPPTO>0</COMAPPTO>
            <COMMAMNT>0.00000</COMMAMNT>
            <OCOMMAMT>0.00000</OCOMMAMT>
            <CMMSLAMT>0.00000</CMMSLAMT>
            <ORCOSAMT>0.00000</ORCOSAMT>
            <NCOMAMNT>0.00000</NCOMAMNT>
            <ORNCMAMT>0.00000</ORNCMAMT>
            <SHIPMTHD>LOCAL DELIVERY</SHIPMTHD>
            <TRDISAMT>0.00000</TRDISAMT>
            <ORTDISAM>0.00000</ORTDISAM>
            <TRDISPCT>0</TRDISPCT>
            <SUBTOTAL>32000.00000</SUBTOTAL>
            <ORSUBTOT>32000.00000</ORSUBTOT>
            <REMSUBTO>32000.00000</REMSUBTO>
            <OREMSUBT>32000.00000</OREMSUBT>
            <EXTDCOST>0.00000</EXTDCOST>
            <OREXTCST>0.00000</OREXTCST>
            <FRTAMNT>0.00000</FRTAMNT>
            <ORFRTAMT>0.00000</ORFRTAMT>
            <MISCAMNT>0.00000</MISCAMNT>
            <ORMISCAMT>0.00000</ORMISCAMT>
            <TXENGCLD>1</TXENGCLD>
            <TAXEXMT1></TAXEXMT1>
            <TAXEXMT2></TAXEXMT2>
            <TXRGNNUM></TXRGNNUM>
            <TAXSCHID>USASTCITY-6*</TAXSCHID>
            <TXSCHSRC>2</TXSCHSRC>
            <BSIVCTTL>0</BSIVCTTL>
            <FRTSCHID></FRTSCHID>
            <FRTTXAMT>0.00000</FRTTXAMT>
            <ORFRTTAX>0.00000</ORFRTTAX>
            <FRGTTXBL>3</FRGTTXBL>
            <MSCSCHID></MSCSCHID>
            <MSCTXAMT>0.00000</MSCTXAMT>
            <ORMSCTAX>0.00000</ORMSCTAX>
            <MISCTXBL>3</MISCTXBL>
            <BKTFRTAM>0.00000</BKTFRTAM>
            <ORBKTFRT>0.00000</ORBKTFRT>
            <BKTMSCAM>0.00000</BKTMSCAM>
            <ORBKTMSC>0.00000</ORBKTMSC>
            <BCKTXAMT>0.00000</BCKTXAMT>
            <OBTAXAMT>0.00000</OBTAXAMT>
            <TXBTXAMT>0.00000</TXBTXAMT>
            <OTAXTAMT>0.00000</OTAXTAMT>
            <TAXAMNT>0.00000</TAXAMNT>
            <ORTAXAMT>0.00000</ORTAXAMT>
            <ECTRX>0</ECTRX>
            <DOCAMNT>32000.00000</DOCAMNT>
            <ORDOCAMT>32000.00000</ORDOCAMT>
            <PYMTRCVD>0.00000</PYMTRCVD>
            <ORPMTRVD>0.00000</ORPMTRVD>
            <DEPRECVD>0.00000</DEPRECVD>
            <ORDEPRVD>0.00000</ORDEPRVD>
            <CODAMNT>0.00000</CODAMNT>
            <ORCODAMT>0.00000</ORCODAMT>
            <ACCTAMNT>32000.00000</ACCTAMNT>
            <ORACTAMT>32000.00000</ORACTAMT>
            <SALSTERR></SALSTERR>
            <SLPRSNID></SLPRSNID>
            <UPSZONE></UPSZONE>
            <TIMESPRT>0</TIMESPRT>
            <PSTGSTUS>0</PSTGSTUS>
            <VOIDSTTS>0</VOIDSTTS>
            <ALLOCABY>1</ALLOCABY>
            <NOTEINDX>575.00000</NOTEINDX>
            <CURNCYID>Z-US$</CURNCYID>
            <CURRNIDX>1007</CURRNIDX>
            <RATETPID></RATETPID>
            <EXGTBLID></EXGTBLID>
            <XCHGRATE>0.0000000</XCHGRATE>
            <DENXRATE>0.0000000</DENXRATE>
            <EXCHDATE>1900-01-01T00:00:00</EXCHDATE>
            <TIME1>1900-01-01T00:00:00</TIME1>
            <RTCLCMTD>0</RTCLCMTD>
            <MCTRXSTT>0</MCTRXSTT>
            <TRXSORCE></TRXSORCE>
            <COMMNTID></COMMNTID>
            <REFRENCE></REFRENCE>
            <POSTEDDT>1900-01-01T00:00:00</POSTEDDT>
            <PTDUSRID></PTDUSRID>
            <USER2ENT>sa</USER2ENT>
            <CREATDDT>2012-11-03T00:00:00</CREATDDT>
            <MODIFDT>2012-11-03T00:00:00</MODIFDT>
            <Tax_Date>2017-04-12T00:00:00</Tax_Date>
            <APLYWITH>0</APLYWITH>
            <WITHHAMT>0.00000</WITHHAMT>
            <SHPPGDOC>0</SHPPGDOC>
            <CORRCTN>0</CORRCTN>
            <SIMPLIFD>0</SIMPLIFD>
            <CORRNXST>0</CORRNXST>
            <DOCNCORR></DOCNCORR>
            <SEQNCORR>0</SEQNCORR>
            <SALEDATE>1900-01-01T00:00:00</SALEDATE>
            <EXCEPTIONALDEMAND>0</EXCEPTIONALDEMAND>
            <Flags>0</Flags>
            <BackoutTradeDisc>0.00000</BackoutTradeDisc>
            <OrigBackoutTradeDisc>0.00000</OrigBackoutTradeDisc>
            <GPSFOINTEGRATIONID></GPSFOINTEGRATIONID>
            <INTEGRATIONSOURCE>0</INTEGRATIONSOURCE>
            <INTEGRATIONID></INTEGRATIONID>
            <Commissions/>
            <Distribution>
                <SOPTYPE>3</SOPTYPE>
                <SOPNUMBE>TEST01</SOPNUMBE>
                <SEQNUMBR>16384</SEQNUMBR>
                <DISTTYPE>2</DISTTYPE>
                <DistRef></DistRef>
                <ACTINDX>6</ACTINDX>
                <DEBITAMT>32000.00000</DEBITAMT>
                <ORDBTAMT>32000.00000</ORDBTAMT>
                <CRDTAMNT>0.00000</CRDTAMNT>
                <ORCRDAMT>0.00000</ORCRDAMT>
                <CURRNIDX>1007</CURRNIDX>
                <TRXSORCE></TRXSORCE>
                <POSTED>0</POSTED>
            </Distribution>
            <Distribution>
                <SOPTYPE>3</SOPTYPE>
                <SOPNUMBE>TEST01</SOPNUMBE>
                <SEQNUMBR>32768</SEQNUMBR>
                <DISTTYPE>1</DISTTYPE>
                <DistRef></DistRef>
                <ACTINDX>113</ACTINDX>
                <DEBITAMT>0.00000</DEBITAMT>
                <ORDBTAMT>0.00000</ORDBTAMT>
                <CRDTAMNT>32000.00000</CRDTAMNT>
                <ORCRDAMT>32000.00000</ORCRDAMT>
                <CURRNIDX>1007</CURRNIDX>
                <TRXSORCE></TRXSORCE>
                <POSTED>0</POSTED>
            </Distribution>
            <Payments/>
            <Holds/>
            <UserDefined/>
            <Deposit/>
            <Notes/>
            <Line>
                <SOPNUMBE>TEST01</SOPNUMBE>
                <SOPTYPE>3</SOPTYPE>
                <CMPNTSEQ>0</CMPNTSEQ>
                <LNITMSEQ>16384</LNITMSEQ>
                <ITEMNMBR>1-A3261A</ITEMNMBR>
                <ITEMDESC>Multi-Core Processor</ITEMDESC>
                <NONINVEN>0</NONINVEN>
                <DROPSHIP>0</DROPSHIP>
                <UOFM>Each</UOFM>
                <LOCNCODE>WAREHOUSE</LOCNCODE>
                <UNITCOST>16000.00000</UNITCOST>
                <ORUNTCST>16000.00000</ORUNTCST>
                <UNITPRCE>32000.00000</UNITPRCE>
                <ORUNTPRC>32000.00000</ORUNTPRC>
                <XTNDPRCE>32000.00000</XTNDPRCE>
                <OXTNDPRC>32000.00000</OXTNDPRC>
                <REMPRICE>32000.00000</REMPRICE>
                <OREPRICE>32000.00000</OREPRICE>
                <EXTDCOST>16000.00000</EXTDCOST>
                <OREXTCST>16000.00000</OREXTCST>
                <MRKDNAMT>0.00000</MRKDNAMT>
                <ORMRKDAM>0.00000</ORMRKDAM>
                <MRKDNPCT>0</MRKDNPCT>
                <MRKDNTYP>0</MRKDNTYP>
                <INVINDX>18</INVINDX>
                <CSLSINDX>137</CSLSINDX>
                <SLSINDX>113</SLSINDX>
                <MKDNINDX>128</MKDNINDX>
                <RTNSINDX>449</RTNSINDX>
                <INUSINDX>27</INUSINDX>
                <INSRINDX>18</INSRINDX>
                <DMGDINDX>141</DMGDINDX>
                <ITMTSHID></ITMTSHID>
                <IVITMTXB>2</IVITMTXB>
                <BKTSLSAM>0.00000</BKTSLSAM>
                <ORBKTSLS>0.00000</ORBKTSLS>
                <TAXAMNT>0.00000</TAXAMNT>
                <ORTAXAMT>0.00000</ORTAXAMT>
                <TXBTXAMT>0.00000</TXBTXAMT>
                <OTAXTAMT>0.00000</OTAXTAMT>
                <BSIVCTTL>0</BSIVCTTL>
                <TRDISAMT>0.00000</TRDISAMT>
                <ORTDISAM>0.00000</ORTDISAM>
                <DISCSALE>0.00000</DISCSALE>
                <ORDAVSLS>0.00000</ORDAVSLS>
                <QUANTITY>1.00000</QUANTITY>
                <ATYALLOC>1.00000</ATYALLOC>
                <QTYINSVC>0.00000</QTYINSVC>
                <QTYINUSE>0.00000</QTYINUSE>
                <QTYDMGED>0.00000</QTYDMGED>
                <QTYRTRND>0.00000</QTYRTRND>
                <QTYONHND>0.00000</QTYONHND>
                <QTYCANCE>0.00000</QTYCANCE>
                <QTYCANOT>0.00000</QTYCANOT>
                <QTYONPO>0.00000</QTYONPO>
                <QTYORDER>1.00000</QTYORDER>
                <QTYPRBAC>0.00000</QTYPRBAC>
                <QTYPRBOO>0.00000</QTYPRBOO>
                <QTYPRINV>0.00000</QTYPRINV>
                <QTYPRORD>0.00000</QTYPRORD>
                <QTYPRVRECVD>0.00000</QTYPRVRECVD>
                <QTYRECVD>0.00000</QTYRECVD>
                <QTYREMAI>1.00000</QTYREMAI>
                <QTYREMBO>0.00000</QTYREMBO>
                <QTYTBAOR>0.00000</QTYTBAOR>
                <QTYTOINV>1.00000</QTYTOINV>
                <QTYTORDR>0.00000</QTYTORDR>
                <QTYFULFI>1.00000</QTYFULFI>
                <QTYSLCTD>1.00000</QTYSLCTD>
                <QTYBSUOM>1.00000</QTYBSUOM>
                <EXTQTYAL>0.00000</EXTQTYAL>
                <EXTQTYSEL>0.00000</EXTQTYSEL>
                <ReqShipDate>2017-04-12T00:00:00</ReqShipDate>
                <FUFILDAT>2017-04-12T00:00:00</FUFILDAT>
                <ACTLSHIP>2017-04-12T00:00:00</ACTLSHIP>
                <SHIPMTHD>LOCAL DELIVERY</SHIPMTHD>
                <SALSTERR></SALSTERR>
                <SLPRSNID></SLPRSNID>
                <PRCLEVEL>RETAIL</PRCLEVEL>
                <COMMNTID></COMMNTID>
                <BRKFLD1>0</BRKFLD1>
                <BRKFLD2>0</BRKFLD2>
                <BRKFLD3>0</BRKFLD3>
                <CURRNIDX>1007</CURRNIDX>
                <TRXSORCE></TRXSORCE>
                <ORGSEQNM>0</ORGSEQNM>
                <ITEMCODE></ITEMCODE>
                <PURCHSTAT>1</PURCHSTAT>
                <DECPLQTY>1</DECPLQTY>
                <DECPLCUR>3</DECPLCUR>
                <ODECPLCU>3</ODECPLCU>
                <QTYTOSHP>0.00000</QTYTOSHP>
                <XFRSHDOC>0</XFRSHDOC>
                <EXCEPTIONALDEMAND>0</EXCEPTIONALDEMAND>
                <TAXSCHID>USASTCITY-6*</TAXSCHID>
                <TXSCHSRC>2</TXSCHSRC>
                <PRSTADCD>WAREHOUSE</PRSTADCD>
                <ShipToName>Aaron Fitz Electrical</ShipToName>
                <CNTCPRSN>Bob Fitz</CNTCPRSN>
                <ADDRESS1>11403 45 St. South</ADDRESS1>
                <ADDRESS2></ADDRESS2>
                <ADDRESS3></ADDRESS3>
                <CITY>Chicago</CITY>
                <STATE>IL</STATE>
                <ZIPCODE>60603-0776</ZIPCODE>
                <COUNTRY>USA</COUNTRY>
                <PHONE1>31255501020000</PHONE1>
                <PHONE2>31255501020000</PHONE2>
                <PHONE3></PHONE3>
                <FAXNUMBR>31255501020000</FAXNUMBR>
                <Flags>0</Flags>
                <BackoutTradeDisc>0.00000</BackoutTradeDisc>
                <OrigBackoutTradeDisc>0.00000</OrigBackoutTradeDisc>
                <GPSFOINTEGRATIONID></GPSFOINTEGRATIONID>
                <INTEGRATIONSOURCE>0</INTEGRATIONSOURCE>
                <INTEGRATIONID></INTEGRATIONID>
                <CONTNBR></CONTNBR>
                <CONTLNSEQNBR>0.00000</CONTLNSEQNBR>
                <CONTSTARTDTE>1900-01-01T00:00:00</CONTSTARTDTE>
                <CONTENDDTE>1900-01-01T00:00:00</CONTENDDTE>
                <CONTITEMNBR></CONTITEMNBR>
                <CONTSERIALNBR></CONTSERIALNBR>
                <LineTax/>
            </Line>
        </SO_Trans>
    </eConnect>
</root>

 

 

4Penny.net
Version: GP 2010
Section: eConnect
Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables
3