CyberStore Documentation
SORQRYOUT

The following is a sample of the typical XML output from a successful e.net Business Object call using SORQRY (Sales Order Query).

<?xml version="1.0" encoding="Windows-1252"?>
<!-- Copyright 1994-2014 SYSPRO Ltd.-->
<!-- 
     This is an example XMLOut instance to demonstrate
     use of the Sales  Query Business Object
-->
<SorDetail xmlns:xsd="http://www.w3.org/2001/XMLSchema-instance" xsd:noNamespaceSchemaLocation="SORQRYout.XSD">
    <SystemInformation>
        <CssStyle/>
        <Language>EN</Language>
        <DecFormat>1</DecFormat>
        <DateFormat>01</DateFormat>
        <Role>01</Role>
        <Version>7.0.034</Version>
        <CompanyId>2</CompanyId>
        <CompanyName>Demo for Mohammed</CompanyName>
        <OperatorCode>MM</OperatorCode>
        <OperatorName>MEspresso</OperatorName>
        <OperatorGroup>ADMIN</OperatorGroup>
        <OperatorEmailAddress/>
        <OperatorLocation/>
        <LocalCurrency>$</LocalCurrency>
        <LocalCurrencyDesc>Local Currency</LocalCurrencyDesc>
        <GlPrdPerYear>12</GlPrdPerYear>
        <ReportDate>19/06/2014 12:05</ReportDate>
        <UseSeparatorOnReports>N</UseSeparatorOnReports>
        <SeparatorToUse>,</SeparatorToUse>
        <OperatorPrimaryRole/>
    </SystemInformation>
    <SalesOrder>000812</SalesOrder>
    <DocumentType>B</DocumentType>
    <DocumentTypeDesc>Billing</DocumentTypeDesc>
    <InterWhSale/>
    <SourceWarehouse/>
    <TargetWarehouse/>
    <GtrReference/>
    <Customer>0000011</Customer>
    <CustomerName>Maniac Sports - South</CustomerName>
    <TaxStatus>Exempt from tax</TaxStatus>
    <EUFlag>N</EUFlag>
    <EUFlagDesc>EU</EUFlagDesc>
    <SoldToName>Maniac Sports - South</SoldToName>
    <SoldAddr1>P O Box 666</SoldAddr1>
    <SoldAddr2>Southville</SoldAddr2>
    <SoldAddr3>Montgomery</SoldAddr3>
    <SoldAddr3Locality/>
    <SoldAddr4>AL</SoldAddr4>
    <SoldAddr5>USA</SoldAddr5>
    <SoldPostalCode>36101</SoldPostalCode>
    <SoldGpsLat>0.000000</SoldGpsLat>
    <SoldGpsLong>0.000000</SoldGpsLong>
    <DiscPct1>0.00</DiscPct1>
    <DiscPct2>0.00</DiscPct2>
    <DiscPct3>0.00</DiscPct3>
    <Salesperson>201</Salesperson>
    <ScheduledOrdFlag/>
    <Commissions>
        <Salesperson>201</Salesperson>
        <CommissionSales1>0.00</CommissionSales1>
        <Salesperson2/>
        <CommissionSales2>0.00</CommissionSales2>
        <Salesperson3/>
        <CommissionSales3>0.00</CommissionSales3>
        <Salesperson4/>
        <CommissionSales4>0.00</CommissionSales4>
    </Commissions>
    <SALSLS_Name>Victor Patterson</SALSLS_Name>
    <OrderStatus>9</OrderStatus>
    <OrderStatusDesc>Complete</OrderStatusDesc>
    <CustomerPoNumber>South 241</CustomerPoNumber>
    <OrderDate>17/03/2008</OrderDate>
    <GITReference/>
    <ReqShipDate>17/03/2008</ReqShipDate>
    <ShippingInstrs>Louise.Bright@maniacsports.com</ShippingInstrs>
    <SpecialInstrs/>
    <InvTermsOverride>1</InvTermsOverride>
    <DeliveryNote/>
    <LastDelNote/>
    <TimeDelPrtedHh>00</TimeDelPrtedHh>
    <TimeDelPrtedMm>00</TimeDelPrtedMm>
    <LastInvoice>100482</LastInvoice>
    <DateLastInvPrt>17/03/2008</DateLastInvPrt>
    <TimeInvPrtedHh>16</TimeInvPrtedHh>
    <TimeInvPrtedMm>56</TimeInvPrtedMm>
    <TBLART_Description>30 Days - 2.5%</TBLART_Description>
    <Branch>20</Branch>
    <SALBRN_Description>Receivables - South</SALBRN_Description>
    <EntInvoice>000000</EntInvoice>
    <OrderType>T</OrderType>
    <Area>S</Area>
    <SALARE_Description>Southen Region</SALARE_Description>
    <TaxExemptNumber/>
    <GstExemptNum/>
    <Currency>$</Currency>
    <TBLCUR_Description>Local Currency</TBLCUR_Description>
    <ShipAddress1>85a Third Street</ShipAddress1>
    <ShipAddress2>Southville</ShipAddress2>
    <ShipAddress3>Montgomery</ShipAddress3>
    <ShipAddress3Locality/>
    <ShipAddress4>AL</ShipAddress4>
    <ShipAddress5>USA</ShipAddress5>
    <ShipPostalCode>36104</ShipPostalCode>
    <ShipGpsLat>0.000000</ShipGpsLat>
    <ShipGpsLong>0.000000</ShipGpsLong>
    <ShipComplete>N</ShipComplete>
    <Email/>
    <FixExchangeRate>N</FixExchangeRate>
    <ExchangeRate>1.000000</ExchangeRate>
    <MulDiv>M</MulDiv>
    <ConsolidatedOrder/>
    <GstDeduction>I</GstDeduction>
    <CreditedInvDate/>
    <Job/>
    <SerialisedFlag>Y</SerialisedFlag>
    <CounterSalesFlag/>
    <Nationality/>
    <DeliveryTerms/>
    <TransactionNature>000</TransactionNature>
    <TransportMode>00</TransportMode>
    <ProcessFlag>0</ProcessFlag>
    <JobsExistFlag/>
    <AlternateKey/>
    <HierarchyFlag/>
    <DepositFlag/>
    <EdiSource/>
    <DeliveryNote/>
    <MultShipCode/>
    <AlternateKey/>
    <CompanyTaxNo/>
    <LastOperator>DEMO</LastOperator>
    <Operator/>
    <State/>
    <CountyZip/>
    <ExtendedTaxCode/>
    <WebCreated/>
    <Quote/>
    <DispatchesMade/>
    <LiveDispExist/>
    <NumDispatches>0</NumDispatches>
    <HeaderText/>
    <CustomForm/>
    <SalesOrderLine>
        <Merchandise>
            <SalesOrderLine>1</SalesOrderLine>
            <SalesOrderInitLine>0001</SalesOrderInitLine>
            <MStockCode>A100</MStockCode>
            <MStockDes>15 Speed Mountain Bike Boys</MStockDes>
            <LongDesc>Distribution</LongDesc>
            <MProductClass>MB</MProductClass>
            <Description>Mountain Bicycles</Description>
            <MWarehouse>S</MWarehouse>
            <MWarehouseDesc/>
            <MBin/>
            <MCusSupStkCode/>
            <MOrderQty>100.000</MOrderQty>
            <MOrderQtyInStockingUm>100.000</MOrderQtyInStockingUm>
            <MShipQty>0.000</MShipQty>
            <MStockQtyToShp>0.000</MStockQtyToShp>
            <QtyReserved>0.000</QtyReserved>
            <QtyReservedShip>0.000</QtyReservedShip>
            <MBackOrderQty>0.000</MBackOrderQty>
            <MBackOrderQtyInStockingUm>0.000</MBackOrderQtyInStockingUm>
            <MQtyDispatched>0.000</MQtyDispatched>
            <MMulDivQtyFct>M</MMulDivQtyFct>
            <MConvFactAlloc>1.000000</MConvFactAlloc>
            <MOrderUom>EA</MOrderUom>
            <MStockingUom>EA</MStockingUom>
            <MStockUnitMass>1.000000</MStockUnitMass>
            <MStockUnitVol>0.000000</MStockUnitVol>
            <MPrice>560.00000</MPrice>
            <MUnitCost>0.00000</MUnitCost>
            <MPriceUom>EA</MPriceUom>
            <MMulDivPrcFct>M</MMulDivPrcFct>
            <MConvFactOrdUm>1.000000</MConvFactOrdUm>
            <MPriceCode>A</MPriceCode>
            <MContract/>
            <MBuyingGroup/>
            <MTaxCode>A</MTaxCode>
            <CreditReason/>
            <MDiscValFlag/>
            <MDiscPct1>0.00</MDiscPct1>
            <MDiscPct2>0.00</MDiscPct2>
            <MDiscPct3>0.00</MDiscPct3>
            <OrderLineValue>56000.00</OrderLineValue>
            <MLineShipDate>17/03/2008</MLineShipDate>
            <MCustRequestDat>17/03/2008</MCustRequestDat>
            <MBomType/>
            <MParentKitType>N</MParentKitType>
            <MQtyPer>0.000000</MQtyPer>
            <MScrapPercentage>0.00</MScrapPercentage>
            <MQtyChangesFlag/>
            <MUserDef/>
            <MTariff/>
            <Decimals>3</Decimals>
            <TpmUsageFlag/>
            <TpmParentLine>0</TpmParentLine>
            <PromotionCode/>
            <TpmSequence>0</TpmSequence>
            <StockAndAltUm>N</StockAndAltUm>
        </Merchandise>
    </SalesOrderLine>
    <SalesOrderLine>
        <Merchandise>
            <SalesOrderLine>2</SalesOrderLine>
            <SalesOrderInitLine>0002</SalesOrderInitLine>
            <MStockCode>A101</MStockCode>
            <MStockDes>15 Speed Mountain Bike Girls</MStockDes>
            <LongDesc>Distribution/Foreign Price Eur</LongDesc>
            <MProductClass>MB</MProductClass>
            <Description>Mountain Bicycles</Description>
            <MWarehouse>S</MWarehouse>
            <MWarehouseDesc/>
            <MBin/>
            <MCusSupStkCode/>
            <MOrderQty>100.000</MOrderQty>
            <MOrderQtyInStockingUm>100.000</MOrderQtyInStockingUm>
            <MShipQty>0.000</MShipQty>
            <MStockQtyToShp>0.000</MStockQtyToShp>
            <QtyReserved>0.000</QtyReserved>
            <QtyReservedShip>0.000</QtyReservedShip>
            <MBackOrderQty>0.000</MBackOrderQty>
            <MBackOrderQtyInStockingUm>0.000</MBackOrderQtyInStockingUm>
            <MQtyDispatched>0.000</MQtyDispatched>
            <MMulDivQtyFct>M</MMulDivQtyFct>
            <MConvFactAlloc>1.000000</MConvFactAlloc>
            <MOrderUom>EA</MOrderUom>
            <MStockingUom>EA</MStockingUom>
            <MStockUnitMass>1.000000</MStockUnitMass>
            <MStockUnitVol>0.000000</MStockUnitVol>
            <MPrice>560.00000</MPrice>
            <MUnitCost>0.00000</MUnitCost>
            <MPriceUom>EA</MPriceUom>
            <MMulDivPrcFct>M</MMulDivPrcFct>
            <MConvFactOrdUm>1.000000</MConvFactOrdUm>
            <MPriceCode>A</MPriceCode>
            <MContract/>
            <MBuyingGroup/>
            <MTaxCode>A</MTaxCode>
            <CreditReason/>
            <MDiscValFlag/>
            <MDiscPct1>0.00</MDiscPct1>
            <MDiscPct2>0.00</MDiscPct2>
            <MDiscPct3>0.00</MDiscPct3>
            <OrderLineValue>56000.00</OrderLineValue>
            <MLineShipDate>17/03/2008</MLineShipDate>
            <MCustRequestDat>17/03/2008</MCustRequestDat>
            <MBomType/>
            <MParentKitType>N</MParentKitType>
            <MQtyPer>0.000000</MQtyPer>
            <MScrapPercentage>0.00</MScrapPercentage>
            <MQtyChangesFlag/>
            <MUserDef/>
            <MTariff/>
            <Decimals>3</Decimals>
            <TpmUsageFlag/>
            <TpmParentLine>0</TpmParentLine>
            <PromotionCode/>
            <TpmSequence>0</TpmSequence>
            <StockAndAltUm>N</StockAndAltUm>
        </Merchandise>
    </SalesOrderLine>
    <SalesOrderLine>
        <Merchandise>
            <SalesOrderLine>3</SalesOrderLine>
            <SalesOrderInitLine>0003</SalesOrderInitLine>
            <MStockCode>A200</MStockCode>
            <MStockDes>Bicycle Pump</MStockDes>
            <LongDesc>Distrib./Alt. Unit Meas/Alt Su</LongDesc>
            <MProductClass>BA</MProductClass>
            <Description>Bicycle Accessories</Description>
            <MWarehouse>S</MWarehouse>
            <MWarehouseDesc/>
            <MBin/>
            <MCusSupStkCode/>
            <MOrderQty>200.000</MOrderQty>
            <MOrderQtyInStockingUm>200.000</MOrderQtyInStockingUm>
            <MShipQty>0.000</MShipQty>
            <MStockQtyToShp>0.000</MStockQtyToShp>
            <QtyReserved>0.000</QtyReserved>
            <QtyReservedShip>0.000</QtyReservedShip>
            <MBackOrderQty>0.000</MBackOrderQty>
            <MBackOrderQtyInStockingUm>0.000</MBackOrderQtyInStockingUm>
            <MQtyDispatched>0.000</MQtyDispatched>
            <MMulDivQtyFct>M</MMulDivQtyFct>
            <MConvFactAlloc>1.000000</MConvFactAlloc>
            <MOrderUom>EA</MOrderUom>
            <MStockingUom>EA</MStockingUom>
            <MStockUnitMass>1.000000</MStockUnitMass>
            <MStockUnitVol>0.000000</MStockUnitVol>
            <MPrice>24.80000</MPrice>
            <MUnitCost>0.00000</MUnitCost>
            <MPriceUom>EA</MPriceUom>
            <MMulDivPrcFct>M</MMulDivPrcFct>
            <MConvFactOrdUm>1.000000</MConvFactOrdUm>
            <MPriceCode>A</MPriceCode>
            <MContract/>
            <MBuyingGroup/>
            <MTaxCode>A</MTaxCode>
            <CreditReason/>
            <MDiscValFlag/>
            <MDiscPct1>0.00</MDiscPct1>
            <MDiscPct2>0.00</MDiscPct2>
            <MDiscPct3>0.00</MDiscPct3>
            <OrderLineValue>4960.00</OrderLineValue>
            <MLineShipDate>17/03/2008</MLineShipDate>
            <MCustRequestDat>17/03/2008</MCustRequestDat>
            <MBomType/>
            <MParentKitType>N</MParentKitType>
            <MQtyPer>0.000000</MQtyPer>
            <MScrapPercentage>0.00</MScrapPercentage>
            <MQtyChangesFlag/>
            <MUserDef/>
            <MTariff/>
            <Decimals>3</Decimals>
            <TpmUsageFlag/>
            <TpmParentLine>0</TpmParentLine>
            <PromotionCode/>
            <TpmSequence>0</TpmSequence>
            <StockAndAltUm>N</StockAndAltUm>
        </Merchandise>
    </SalesOrderLine>
    <SalesOrderLine>
        <Merchandise>
            <SalesOrderLine>4</SalesOrderLine>
            <SalesOrderInitLine>0004</SalesOrderInitLine>
            <MStockCode>SER310</MStockCode>
            <MStockDes>Bicycle Helmet Medium - Green</MStockDes>
            <LongDesc>Serialized - Batch</LongDesc>
            <MProductClass>BH</MProductClass>
            <Description>Bicycle Helmets</Description>
            <MWarehouse>S</MWarehouse>
            <MWarehouseDesc/>
            <MBin/>
            <MCusSupStkCode/>
            <MOrderQty>10.000</MOrderQty>
            <MOrderQtyInStockingUm>10.000</MOrderQtyInStockingUm>
            <MShipQty>0.000</MShipQty>
            <MStockQtyToShp>0.000</MStockQtyToShp>
            <QtyReserved>0.000</QtyReserved>
            <QtyReservedShip>0.000</QtyReservedShip>
            <MBackOrderQty>0.000</MBackOrderQty>
            <MBackOrderQtyInStockingUm>0.000</MBackOrderQtyInStockingUm>
            <MQtyDispatched>0.000</MQtyDispatched>
            <MMulDivQtyFct>M</MMulDivQtyFct>
            <MConvFactAlloc>1.000000</MConvFactAlloc>
            <MOrderUom>EA</MOrderUom>
            <MStockingUom>EA</MStockingUom>
            <MStockUnitMass>1.000000</MStockUnitMass>
            <MStockUnitVol>0.000000</MStockUnitVol>
            <MPrice>56.00000</MPrice>
            <MUnitCost>0.00000</MUnitCost>
            <MPriceUom>EA</MPriceUom>
            <MMulDivPrcFct>M</MMulDivPrcFct>
            <MConvFactOrdUm>1.000000</MConvFactOrdUm>
            <MPriceCode>A</MPriceCode>
            <MContract/>
            <MBuyingGroup/>
            <MTaxCode>A</MTaxCode>
            <CreditReason/>
            <MDiscValFlag/>
            <MDiscPct1>0.00</MDiscPct1>
            <MDiscPct2>0.00</MDiscPct2>
            <MDiscPct3>0.00</MDiscPct3>
            <OrderLineValue>560.00</OrderLineValue>
            <MLineShipDate>17/03/2008</MLineShipDate>
            <MCustRequestDat>17/03/2008</MCustRequestDat>
            <MBomType/>
            <MParentKitType>N</MParentKitType>
            <MQtyPer>0.000000</MQtyPer>
            <MScrapPercentage>0.00</MScrapPercentage>
            <MQtyChangesFlag/>
            <MUserDef/>
            <MTariff/>
            <Decimals>3</Decimals>
            <TpmUsageFlag/>
            <TpmParentLine>0</TpmParentLine>
            <PromotionCode/>
            <TpmSequence>0</TpmSequence>
            <StockAndAltUm>N</StockAndAltUm>
        </Merchandise>
    </SalesOrderLine>
    <SalesOrderLine>
        <CommentLine>
            <SalesOrderLine>5</SalesOrderLine>
            <NComment>Please remember to send serial certificates</NComment>
            <NCommentFromLin>4</NCommentFromLin>
        </CommentLine>
    </SalesOrderLine>
    <SalesOrderLine>
        <CommentLine>
            <SalesOrderLine>6</SalesOrderLine>
            <NComment>with the goods.</NComment>
            <NCommentFromLin>4</NCommentFromLin>
        </CommentLine>
    </SalesOrderLine>
</SorDetail>