CyberStore Ecommerce 2023 Documentation
SORQIDOUT

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&amp;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>