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>
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