The following is a sample of the typical XML output from a successful e.net Business Object call using SORQID (Sales Order Invoice Query).
<?xml version="1.0" encoding="utf-16"?> <SorSalesOrderInvoiceDocuments Language="05" Language2="EN" CssStyle="" DecFormat="1" DateFormat="01" Role="01" Version="7.0.041" OperatorPrimaryRole=" " Duration="553ms"> <SalesOrderInvoiceDocument> <DocumentNumber>000000000100507</DocumentNumber> <DocumentType>I</DocumentType> <Reprint>Y</Reprint> <Header> <DocumentNumber>000000000100507</DocumentNumber> <DocumentDate>2010-04-08</DocumentDate> <CompanyName>The OUTDOORS Company</CompanyName> <CompanyAddress1 /> <CompanyAddress2>P O Box 777</CompanyAddress2> <CompanyAddress3>Great Outdoors</CompanyAddress3> <CompanyAddress3Loc /> <CompanyAddress4 /> <CompanyAddress5 /> <CompanyPostalcode /> <CompanyGpsLat> 0.000000</CompanyGpsLat> <CompanyGpsLong> 0.000000</CompanyGpsLong> <CompanyTaxNumber /> <CompanyRegNumber>1978/035534/04</CompanyRegNumber> <Customer>000000000000008</Customer> <CustomerName>Garden and Sports</CustomerName> <SoldToAddr1>P O Box 3847</SoldToAddr1> <SoldToAddr2>NorthWay</SoldToAddr2> <SoldToAddr3>Northern Region</SoldToAddr3> <SoldToAddr3Loc /> <SoldToAddr4>Vancouver</SoldToAddr4> <SoldToAddr5>Canada</SoldToAddr5> <SoldPostalcode>V7L 4J4</SoldPostalcode> <SoldGpsLat> 0.000000</SoldGpsLat> <SoldGpsLong> 0.000000</SoldGpsLong> <StateCode /> <ShipCustomerName>Garden and Sports</ShipCustomerName> <ShipAddress1>No 9 Gallagher Lane</ShipAddress1> <ShipAddress2>Northern Regions</ShipAddress2> <ShipAddress3 /> <ShipAddress3Loc /> <ShipAddress4 /> <ShipAddress5 /> <ShipPostalcode /> <ShipGpsLat> 0.000000</ShipGpsLat> <ShipGpsLong> 0.000000</ShipGpsLong> <MultiShipCode /> <MasterAccount /> <StoreNumber /> <Salesperson>102</Salesperson> <SalespersonName>Diane Ferry</SalespersonName> <CustomerPoNumber>457</CustomerPoNumber> <CompanyTaxNo /> <OrderDate>2010-03-05</OrderDate> <ReqShipDate>2010-03-05</ReqShipDate> <EntInvoiceDate>2010-04-08</EntInvoiceDate> <SystemDate>2022-04-18</SystemDate> <SystemTime>10:09:53.180</SystemTime> <ShippingInstrs>Road</ShippingInstrs> <ShippingInstrsCode /> <SpecialInstrs /> <InvoiceCredited /> <SalesOrder>809</SalesOrder> <DelNoteSuffix>00</DelNoteSuffix> <OrderType>T</OrderType> <TypeDescription>Order placed by telephone</TypeDescription> <CreditAuthority /> <Area>N</Area> <AreaDescription>Northern Region</AreaDescription> <Branch>10</Branch> <BranchDescription>Receivables - North</BranchDescription> <BranchAddrBuilding /> <BranchAddr1>6 Valeview Rd</BranchAddr1> <BranchAddr2>Wilton</BranchAddr2> <BranchAddr2Loc /> <BranchAddr3>CT</BranchAddr3> <BranchAddr4>US</BranchAddr4> <BranchPostalcode>06897</BranchPostalcode> <BranchGpsLat> 0.000000</BranchGpsLat> <BranchGpsLon> 0.000000</BranchGpsLon> <InvTermsOverride>1</InvTermsOverride> <InvoiceTermsDescription>30 Days - 2.5%</InvoiceTermsDescription> <LastOperator>DEMO</LastOperator> <LastOperatorName /> <CustomerComment /> <AlternateKey /> <DeliveryNote /> <TaxExemptNumber /> <GstExemptNum /> <Currency>$</Currency> <CurrencyDescription>Local Currency</CurrencyDescription> <ExchangeRate> 1.000000</ExchangeRate> <MulDiv>M</MulDiv> <Contact>Cathrine Davids</Contact> <Telephone>604-555-1523</Telephone> <TelephoneExtn>101</TelephoneExtn> <Fax>604-555-1000</Fax> <Telex /> <Email>Cathrined@Garden&Sports.com</Email> <DocFax /> <DocFaxContact /> <DocumentEmail /> <OrderStatus>8</OrderStatus> <EdiSendReceive>789532</EdiSendReceive> <EdiSenderCode /> <Quotation /> <RmaNumber /> <SalesPerson2 /> <SalespersonName2 /> <SalesPerson3 /> <SalespersonName3 /> <SalesPerson4 /> <SalespersonName4 /> </Header> <Merchandise> <DocumentNumber>000000000100507</DocumentNumber> <LineNumber>0001</LineNumber> <SalesOrderLine> 1</SalesOrderLine> <MOrderQty> 50.000000</MOrderQty> <MShipQty> 50.000000</MShipQty> <MBackOrderQty> 0.000000</MBackOrderQty> <QtyReserved> 0.000000</QtyReserved> <MStockQtyToShp> 50.000000</MStockQtyToShp> <PricingQtyShip> 50.000000</PricingQtyShip> <MOrderUom>EA</MOrderUom> <MStockingUom>EA</MStockingUom> <MStockCode>LOT100</MStockCode> <MStockDes>Racing Bicycle</MStockDes> <MWarehouse>FG</MWarehouse> <MBin /> <JobNumber /> <MLineShipDate>2010-04-02</MLineShipDate> <MCustRequestDat>2010-04-02</MCustRequestDat> <MContract /> <MBuyingGroup /> <MCusSupStkCode /> <MCusRetailPrice> 0.00000</MCusRetailPrice> <CusGrossProfitPerc> 0</CusGrossProfitPerc> <DetCustTotalRetail> 0.00</DetCustTotalRetail> <ManPartNumber /> <LongDesc>Parent - Lot Traceable</LongDesc> <OtherUm>EA</OtherUm> <UserField1 /> <UserField2> 0.00000</UserField2> <UserField3 /> <UserField4 /> <UserField5 /> <AlternateKey1 /> <AlternateKey2 /> <DrawOfficeNum /> <MUserDef /> <MStockUnitVol> 0.000000</MStockUnitVol> <LineVolume> 0.000000</LineVolume> <CreditReason /> <ReasonDescription /> <MerchLineCount> 1</MerchLineCount> <MStockUnitMass> 1.000000</MStockUnitMass> <LineMass> 50.000000</LineMass> <LineMassRounded> 50</LineMassRounded> <LineVolRounded> 0</LineVolRounded> <MPriceCode>A</MPriceCode> <MPrice> 4905.00000</MPrice> <NetUnitPrice> 4905.00000</NetUnitPrice> <UnitPriceInclTax> 4905.00000</UnitPriceInclTax> <UnitDiscount> 0.00000</UnitDiscount> <UnitPriceInOrderUm> 4905.00000</UnitPriceInOrderUm> <MTariffcode /> <MSupplementaryUn>N</MSupplementaryUn> <MPriceUom>EA</MPriceUom> <MDiscValFlg /> <MDiscValue /> <MDiscPct1> 0.00</MDiscPct1> <MDiscPct2> 0.00</MDiscPct2> <MDiscPct3> 0.00</MDiscPct3> <LineDiscValue> 0.00</LineDiscValue> <LineSalesTax> 0.00</LineSalesTax> <LineGrossAmount> 245250.00</LineGrossAmount> <LineNetAfterDisc> 245250.00</LineNetAfterDisc> <MTaxCode>A</MTaxCode> <LineTaxPerc /> <TaxInclusive /> <LineNetInclTax> 245250.00</LineNetInclTax> <MConvFactOrdUm> 1.000000</MConvFactOrdUm> <MMulDivPrcFct>M</MMulDivPrcFct> <MProductClass>FGC</MProductClass> <PalletQty> 0.000000</PalletQty> <WarehouseToUse>FG</WarehouseToUse> <MVersion /> <MRelease /> <CountryOfOrigin /> <CountryOfOriginName /> <MCommissionCode>0</MCommissionCode> <TpmUsageFlag /> <TpmParentLine>0000</TpmParentLine> <PromotionCode /> <TpmSequence>000000</TpmSequence> <UnitCost> 2969.29000</UnitCost> <SerialMethod>N</SerialMethod> <TraceableType>T</TraceableType> <Decimals>3</Decimals> <SalesOrderInitLine> 0</SalesOrderInitLine> <Lots> <DocumentNumber>000000000100507</DocumentNumber> <LineNumber>0001</LineNumber> <Lot>0000000146</Lot> <Version /> <Release /> <Certificate>14589</Certificate> <StockQtyToShip> 50.000000</StockQtyToShip> <LotExpiryDate /> </Lots> </Merchandise> <Totals> <DocumentNumber>000000000100507</DocumentNumber> <SalesTax> <SalesTaxDetails> <DocumentNumber>000000000100507</DocumentNumber> <SalesTaxCode>A</SalesTaxCode> <AmountTaxable> 0.00</AmountTaxable> <SalesTaxPercentage> 10.00</SalesTaxPercentage> <SalesTaxAmount> 0.00</SalesTaxAmount> <SalesTaxInHomeCurrency> 0.00</SalesTaxInHomeCurrency> </SalesTaxDetails> </SalesTax> <HashQuantity> 50.000000</HashQuantity> <HashQuantityOrd> 50.000000</HashQuantityOrd> <HashQuantityShip> 50.000000</HashQuantityShip> <HashQuantityUnits> 0.000000</HashQuantityUnits> <HashQuantityPieces> 0.000000</HashQuantityPieces> <TotalMass> 50.000000</TotalMass> <TotalVolume> 0.000000</TotalVolume> <TotalMassRounded> 50</TotalMassRounded> <TotalVolumeRounded> 0</TotalVolumeRounded> <TotalGrossAmount> 245250.00</TotalGrossAmount> <TotalNetAmount> 245250.00</TotalNetAmount> <TotalLineDiscount> 0.00</TotalLineDiscount> <TotalInvDiscountAmt> 0.00</TotalInvDiscountAmt> <DiscPct1> 0.00</DiscPct1> <DiscPct2> 0.00</DiscPct2> <DiscPct3> 0.00</DiscPct3> <TotalNetAmtInclTax> 245250.00</TotalNetAmtInclTax> <TotalSalesTax> 0.00</TotalSalesTax> <TotalSalesTaxInHomeCurrency> 0.00</TotalSalesTaxInHomeCurrency> <TotalMerchTaxInHomeCurrency> 0.00</TotalMerchTaxInHomeCurrency> <TotalInvoiceAmount> 245250.00</TotalInvoiceAmount> <TotalInvAmtExclTax> 245250.00</TotalInvAmtExclTax> <TotalFreightAmount> 0.00</TotalFreightAmount> <TotalMiscChargesAmt> 0.00</TotalMiscChargesAmt> <TotalFreightTax> 0.00</TotalFreightTax> <TotalMiscChgTax> 0.00</TotalMiscChgTax> <TotalFrghtAmtIncTax> 0.00</TotalFrghtAmtIncTax> <TotalMiscChgIncTax> 0.00</TotalMiscChgIncTax> <TotalTaxBeforeRounding> 0.00</TotalTaxBeforeRounding> <TotalInvBeforeRounding> 245250.00</TotalInvBeforeRounding> <TaxRoundingValue> 0.00</TaxRoundingValue> <InvoiceRoundingValue> 0.00</InvoiceRoundingValue> <TotalRoundingValue> 0.00</TotalRoundingValue> <CommentText1 /> <CommentText2 /> <CommentText3 /> <CommentText4 /> <TotalCashDiscount> 6131.25</TotalCashDiscount> <TotalInvLessDisc> 239118.75</TotalInvLessDisc> <TotalCustRetail> 0.00</TotalCustRetail> <CashDiscExpDate>2010-05-08</CashDiscExpDate> <InvoiceDueDate>2010-05-08</InvoiceDueDate> </Totals> </SalesOrderInvoiceDocument> </SorSalesOrderInvoiceDocuments>
This document is copyrighted by Dovetail Internet Technologies, LLC., the developers of CyberStore (www.CyberStoreForSYSPRO.com).
The name SYSPRO and other information contained in this document and the application are used with the permission of SYSPRO Impact Software, Inc. (www.syspro.com) Published Wednesday, April 24, 2024