JiwaAPI

SO_LinesQuery

**SO_LinesQuery** Parameters:
Name	Parameter	Data Type	Required
InvoiceLineID	query	string	No
InvoiceLineIDStartsWith	query	string	No
InvoiceLineIDEndsWith	query	string	No
InvoiceLineIDContains	query	string	No
InvoiceLineIDLike	query	string	No
InvoiceLineIDBetween	query	string[]	No
InvoiceLineIDIn	query	string[]	No
InvoiceHistoryID	query	string	No
InvoiceHistoryIDStartsWith	query	string	No
InvoiceHistoryIDEndsWith	query	string	No
InvoiceHistoryIDContains	query	string	No
InvoiceHistoryIDLike	query	string	No
InvoiceHistoryIDBetween	query	string[]	No
InvoiceHistoryIDIn	query	string[]	No
GroupNo	query	short?	No
GroupNoGreaterThanOrEqualTo	query	short?	No
GroupNoGreaterThan	query	short?	No
GroupNoLessThan	query	short?	No
GroupNoLessThanOrEqualTo	query	short?	No
GroupNoNotEqualTo	query	short?	No
GroupNoBetween	query	Nullable<Int16>[]	No
GroupNoIn	query	Nullable<Int16>[]	No
LineNum	query	short?	No
LineNumGreaterThanOrEqualTo	query	short?	No
LineNumGreaterThan	query	short?	No
LineNumLessThan	query	short?	No
LineNumLessThanOrEqualTo	query	short?	No
LineNumNotEqualTo	query	short?	No
LineNumBetween	query	Nullable<Int16>[]	No
LineNumIn	query	Nullable<Int16>[]	No
CommentLine	query	bool?	No
PartNo	query	string	No
PartNoStartsWith	query	string	No
PartNoEndsWith	query	string	No
PartNoContains	query	string	No
PartNoLike	query	string	No
PartNoBetween	query	string[]	No
PartNoIn	query	string[]	No
Description	query	string	No
DescriptionStartsWith	query	string	No
DescriptionEndsWith	query	string	No
DescriptionContains	query	string	No
DescriptionLike	query	string	No
DescriptionBetween	query	string[]	No
DescriptionIn	query	string[]	No
PhysicalItem	query	short?	No
PhysicalItemGreaterThanOrEqualTo	query	short?	No
PhysicalItemGreaterThan	query	short?	No
PhysicalItemLessThan	query	short?	No
PhysicalItemLessThanOrEqualTo	query	short?	No
PhysicalItemNotEqualTo	query	short?	No
PhysicalItemBetween	query	Nullable<Int16>[]	No
PhysicalItemIn	query	Nullable<Int16>[]	No
ItemWeight	query	decimal?	No
ItemWeightGreaterThanOrEqualTo	query	decimal?	No
ItemWeightGreaterThan	query	decimal?	No
ItemWeightLessThan	query	decimal?	No
ItemWeightLessThanOrEqualTo	query	decimal?	No
ItemWeightNotEqualTo	query	decimal?	No
ItemWeightBetween	query	Nullable<Decimal>[]	No
ItemWeightIn	query	Nullable<Decimal>[]	No
ItemCubic	query	decimal?	No
ItemCubicGreaterThanOrEqualTo	query	decimal?	No
ItemCubicGreaterThan	query	decimal?	No
ItemCubicLessThan	query	decimal?	No
ItemCubicLessThanOrEqualTo	query	decimal?	No
ItemCubicNotEqualTo	query	decimal?	No
ItemCubicBetween	query	Nullable<Decimal>[]	No
ItemCubicIn	query	Nullable<Decimal>[]	No
TaxID	query	string	No
TaxIDStartsWith	query	string	No
TaxIDEndsWith	query	string	No
TaxIDContains	query	string	No
TaxIDLike	query	string	No
TaxIDBetween	query	string[]	No
TaxIDIn	query	string[]	No
ClassDescription	query	string	No
ClassDescriptionStartsWith	query	string	No
ClassDescriptionEndsWith	query	string	No
ClassDescriptionContains	query	string	No
ClassDescriptionLike	query	string	No
ClassDescriptionBetween	query	string[]	No
ClassDescriptionIn	query	string[]	No
Cat1Description	query	string	No
Cat1DescriptionStartsWith	query	string	No
Cat1DescriptionEndsWith	query	string	No
Cat1DescriptionContains	query	string	No
Cat1DescriptionLike	query	string	No
Cat1DescriptionBetween	query	string[]	No
Cat1DescriptionIn	query	string[]	No
Cat2Description	query	string	No
Cat2DescriptionStartsWith	query	string	No
Cat2DescriptionEndsWith	query	string	No
Cat2DescriptionContains	query	string	No
Cat2DescriptionLike	query	string	No
Cat2DescriptionBetween	query	string[]	No
Cat2DescriptionIn	query	string[]	No
Cat3Description	query	string	No
Cat3DescriptionStartsWith	query	string	No
Cat3DescriptionEndsWith	query	string	No
Cat3DescriptionContains	query	string	No
Cat3DescriptionLike	query	string	No
Cat3DescriptionBetween	query	string[]	No
Cat3DescriptionIn	query	string[]	No
Units	query	string	No
UnitsStartsWith	query	string	No
UnitsEndsWith	query	string	No
UnitsContains	query	string	No
UnitsLike	query	string	No
UnitsBetween	query	string[]	No
UnitsIn	query	string[]	No
CostIn	query	decimal?	No
CostInGreaterThanOrEqualTo	query	decimal?	No
CostInGreaterThan	query	decimal?	No
CostInLessThan	query	decimal?	No
CostInLessThanOrEqualTo	query	decimal?	No
CostInNotEqualTo	query	decimal?	No
CostInBetween	query	Nullable<Decimal>[]	No
CostInIn	query	Nullable<Decimal>[]	No
DefaultPrice	query	decimal?	No
DefaultPriceGreaterThanOrEqualTo	query	decimal?	No
DefaultPriceGreaterThan	query	decimal?	No
DefaultPriceLessThan	query	decimal?	No
DefaultPriceLessThanOrEqualTo	query	decimal?	No
DefaultPriceNotEqualTo	query	decimal?	No
DefaultPriceBetween	query	Nullable<Decimal>[]	No
DefaultPriceIn	query	Nullable<Decimal>[]	No
ItemPrice	query	decimal?	No
ItemPriceGreaterThanOrEqualTo	query	decimal?	No
ItemPriceGreaterThan	query	decimal?	No
ItemPriceLessThan	query	decimal?	No
ItemPriceLessThanOrEqualTo	query	decimal?	No
ItemPriceNotEqualTo	query	decimal?	No
ItemPriceBetween	query	Nullable<Decimal>[]	No
ItemPriceIn	query	Nullable<Decimal>[]	No
Discount	query	decimal?	No
DiscountGreaterThanOrEqualTo	query	decimal?	No
DiscountGreaterThan	query	decimal?	No
DiscountLessThan	query	decimal?	No
DiscountLessThanOrEqualTo	query	decimal?	No
DiscountNotEqualTo	query	decimal?	No
DiscountBetween	query	Nullable<Decimal>[]	No
DiscountIn	query	Nullable<Decimal>[]	No
InvoicePrice	query	decimal?	No
InvoicePriceGreaterThanOrEqualTo	query	decimal?	No
InvoicePriceGreaterThan	query	decimal?	No
InvoicePriceLessThan	query	decimal?	No
InvoicePriceLessThanOrEqualTo	query	decimal?	No
InvoicePriceNotEqualTo	query	decimal?	No
InvoicePriceBetween	query	Nullable<Decimal>[]	No
InvoicePriceIn	query	Nullable<Decimal>[]	No
RRPPrice	query	decimal?	No
RRPPriceGreaterThanOrEqualTo	query	decimal?	No
RRPPriceGreaterThan	query	decimal?	No
RRPPriceLessThan	query	decimal?	No
RRPPriceLessThanOrEqualTo	query	decimal?	No
RRPPriceNotEqualTo	query	decimal?	No
RRPPriceBetween	query	Nullable<Decimal>[]	No
RRPPriceIn	query	Nullable<Decimal>[]	No
TaxToCharge	query	decimal?	No
TaxToChargeGreaterThanOrEqualTo	query	decimal?	No
TaxToChargeGreaterThan	query	decimal?	No
TaxToChargeLessThan	query	decimal?	No
TaxToChargeLessThanOrEqualTo	query	decimal?	No
TaxToChargeNotEqualTo	query	decimal?	No
TaxToChargeBetween	query	Nullable<Decimal>[]	No
TaxToChargeIn	query	Nullable<Decimal>[]	No
TaxToPay	query	decimal?	No
TaxToPayGreaterThanOrEqualTo	query	decimal?	No
TaxToPayGreaterThan	query	decimal?	No
TaxToPayLessThan	query	decimal?	No
TaxToPayLessThanOrEqualTo	query	decimal?	No
TaxToPayNotEqualTo	query	decimal?	No
TaxToPayBetween	query	Nullable<Decimal>[]	No
TaxToPayIn	query	Nullable<Decimal>[]	No
CurrentLineTotal	query	decimal?	No
CurrentLineTotalGreaterThanOrEqualTo	query	decimal?	No
CurrentLineTotalGreaterThan	query	decimal?	No
CurrentLineTotalLessThan	query	decimal?	No
CurrentLineTotalLessThanOrEqualTo	query	decimal?	No
CurrentLineTotalNotEqualTo	query	decimal?	No
CurrentLineTotalBetween	query	Nullable<Decimal>[]	No
CurrentLineTotalIn	query	Nullable<Decimal>[]	No
QuantityOrdered	query	decimal?	No
QuantityOrderedGreaterThanOrEqualTo	query	decimal?	No
QuantityOrderedGreaterThan	query	decimal?	No
QuantityOrderedLessThan	query	decimal?	No
QuantityOrderedLessThanOrEqualTo	query	decimal?	No
QuantityOrderedNotEqualTo	query	decimal?	No
QuantityOrderedBetween	query	Nullable<Decimal>[]	No
QuantityOrderedIn	query	Nullable<Decimal>[]	No
QuantityPrevDel	query	decimal?	No
QuantityPrevDelGreaterThanOrEqualTo	query	decimal?	No
QuantityPrevDelGreaterThan	query	decimal?	No
QuantityPrevDelLessThan	query	decimal?	No
QuantityPrevDelLessThanOrEqualTo	query	decimal?	No
QuantityPrevDelNotEqualTo	query	decimal?	No
QuantityPrevDelBetween	query	Nullable<Decimal>[]	No
QuantityPrevDelIn	query	Nullable<Decimal>[]	No
QuantityThisDel	query	decimal?	No
QuantityThisDelGreaterThanOrEqualTo	query	decimal?	No
QuantityThisDelGreaterThan	query	decimal?	No
QuantityThisDelLessThan	query	decimal?	No
QuantityThisDelLessThanOrEqualTo	query	decimal?	No
QuantityThisDelNotEqualTo	query	decimal?	No
QuantityThisDelBetween	query	Nullable<Decimal>[]	No
QuantityThisDelIn	query	Nullable<Decimal>[]	No
QuantityBackOrd	query	decimal?	No
QuantityBackOrdGreaterThanOrEqualTo	query	decimal?	No
QuantityBackOrdGreaterThan	query	decimal?	No
QuantityBackOrdLessThan	query	decimal?	No
QuantityBackOrdLessThanOrEqualTo	query	decimal?	No
QuantityBackOrdNotEqualTo	query	decimal?	No
QuantityBackOrdBetween	query	Nullable<Decimal>[]	No
QuantityBackOrdIn	query	Nullable<Decimal>[]	No
HistoryText_Comment	query	string	No
HistoryText_CommentStartsWith	query	string	No
HistoryText_CommentEndsWith	query	string	No
HistoryText_CommentContains	query	string	No
HistoryText_CommentLike	query	string	No
HistoryText_CommentBetween	query	string[]	No
HistoryText_CommentIn	query	string[]	No
Discountable	query	bool?	No
TaxInc	query	bool?	No
DirectTax	query	decimal?	No
DirectTaxGreaterThanOrEqualTo	query	decimal?	No
DirectTaxGreaterThan	query	decimal?	No
DirectTaxLessThan	query	decimal?	No
DirectTaxLessThanOrEqualTo	query	decimal?	No
DirectTaxNotEqualTo	query	decimal?	No
DirectTaxBetween	query	Nullable<Decimal>[]	No
DirectTaxIn	query	Nullable<Decimal>[]	No
DecimalPlaces	query	short?	No
DecimalPlacesGreaterThanOrEqualTo	query	short?	No
DecimalPlacesGreaterThan	query	short?	No
DecimalPlacesLessThan	query	short?	No
DecimalPlacesLessThanOrEqualTo	query	short?	No
DecimalPlacesNotEqualTo	query	short?	No
DecimalPlacesBetween	query	Nullable<Int16>[]	No
DecimalPlacesIn	query	Nullable<Int16>[]	No
MinimumGP	query	decimal?	No
MinimumGPGreaterThanOrEqualTo	query	decimal?	No
MinimumGPGreaterThan	query	decimal?	No
MinimumGPLessThan	query	decimal?	No
MinimumGPLessThanOrEqualTo	query	decimal?	No
MinimumGPNotEqualTo	query	decimal?	No
MinimumGPBetween	query	Nullable<Decimal>[]	No
MinimumGPIn	query	Nullable<Decimal>[]	No
DebitLedger	query	string	No
DebitLedgerStartsWith	query	string	No
DebitLedgerEndsWith	query	string	No
DebitLedgerContains	query	string	No
DebitLedgerLike	query	string	No
DebitLedgerBetween	query	string[]	No
DebitLedgerIn	query	string[]	No
CreditLedger	query	string	No
CreditLedgerStartsWith	query	string	No
CreditLedgerEndsWith	query	string	No
CreditLedgerContains	query	string	No
CreditLedgerLike	query	string	No
CreditLedgerBetween	query	string[]	No
CreditLedgerIn	query	string[]	No
NonStock	query	bool?	No
InventoryID	query	string	No
InventoryIDStartsWith	query	string	No
InventoryIDEndsWith	query	string	No
InventoryIDContains	query	string	No
InventoryIDLike	query	string	No
InventoryIDBetween	query	string[]	No
InventoryIDIn	query	string[]	No
UseSerialNo	query	bool?	No
Backorderable	query	bool?	No
Picked	query	bool?	No
TaxPaid	query	decimal?	No
TaxPaidGreaterThanOrEqualTo	query	decimal?	No
TaxPaidGreaterThan	query	decimal?	No
TaxPaidLessThan	query	decimal?	No
TaxPaidLessThanOrEqualTo	query	decimal?	No
TaxPaidNotEqualTo	query	decimal?	No
TaxPaidBetween	query	Nullable<Decimal>[]	No
TaxPaidIn	query	Nullable<Decimal>[]	No
TaxRate	query	decimal?	No
TaxRateGreaterThanOrEqualTo	query	decimal?	No
TaxRateGreaterThan	query	decimal?	No
TaxRateLessThan	query	decimal?	No
TaxRateLessThanOrEqualTo	query	decimal?	No
TaxRateNotEqualTo	query	decimal?	No
TaxRateBetween	query	Nullable<Decimal>[]	No
TaxRateIn	query	Nullable<Decimal>[]	No
UsingSpecialPrice	query	bool?	No
EstBOValue	query	decimal?	No
EstBOValueGreaterThanOrEqualTo	query	decimal?	No
EstBOValueGreaterThan	query	decimal?	No
EstBOValueLessThan	query	decimal?	No
EstBOValueLessThanOrEqualTo	query	decimal?	No
EstBOValueNotEqualTo	query	decimal?	No
EstBOValueBetween	query	Nullable<Decimal>[]	No
EstBOValueIn	query	Nullable<Decimal>[]	No
ItemTaxToCharge	query	decimal?	No
ItemTaxToChargeGreaterThanOrEqualTo	query	decimal?	No
ItemTaxToChargeGreaterThan	query	decimal?	No
ItemTaxToChargeLessThan	query	decimal?	No
ItemTaxToChargeLessThanOrEqualTo	query	decimal?	No
ItemTaxToChargeNotEqualTo	query	decimal?	No
ItemTaxToChargeBetween	query	Nullable<Decimal>[]	No
ItemTaxToChargeIn	query	Nullable<Decimal>[]	No
ItemTaxToPay	query	decimal?	No
ItemTaxToPayGreaterThanOrEqualTo	query	decimal?	No
ItemTaxToPayGreaterThan	query	decimal?	No
ItemTaxToPayLessThan	query	decimal?	No
ItemTaxToPayLessThanOrEqualTo	query	decimal?	No
ItemTaxToPayNotEqualTo	query	decimal?	No
ItemTaxToPayBetween	query	Nullable<Decimal>[]	No
ItemTaxToPayIn	query	Nullable<Decimal>[]	No
LineLinkID	query	string	No
LineLinkIDStartsWith	query	string	No
LineLinkIDEndsWith	query	string	No
LineLinkIDContains	query	string	No
LineLinkIDLike	query	string	No
LineLinkIDBetween	query	string[]	No
LineLinkIDIn	query	string[]	No
KittingStatus	query	short?	No
KittingStatusGreaterThanOrEqualTo	query	short?	No
KittingStatusGreaterThan	query	short?	No
KittingStatusLessThan	query	short?	No
KittingStatusLessThanOrEqualTo	query	short?	No
KittingStatusNotEqualTo	query	short?	No
KittingStatusBetween	query	short[]	No
KittingStatusIn	query	short[]	No
KittingUnits	query	decimal?	No
KittingUnitsGreaterThanOrEqualTo	query	decimal?	No
KittingUnitsGreaterThan	query	decimal?	No
KittingUnitsLessThan	query	decimal?	No
KittingUnitsLessThanOrEqualTo	query	decimal?	No
KittingUnitsNotEqualTo	query	decimal?	No
KittingUnitsBetween	query	Nullable<Decimal>[]	No
KittingUnitsIn	query	Nullable<Decimal>[]	No
JobConnectorID	query	string	No
JobConnectorIDStartsWith	query	string	No
JobConnectorIDEndsWith	query	string	No
JobConnectorIDContains	query	string	No
JobConnectorIDLike	query	string	No
JobConnectorIDBetween	query	string[]	No
JobConnectorIDIn	query	string[]	No
KitStyle	query	short?	No
KitStyleGreaterThanOrEqualTo	query	short?	No
KitStyleGreaterThan	query	short?	No
KitStyleLessThan	query	short?	No
KitStyleLessThanOrEqualTo	query	short?	No
KitStyleNotEqualTo	query	short?	No
KitStyleBetween	query	Nullable<Int16>[]	No
KitStyleIn	query	Nullable<Int16>[]	No
DiscountPercentage	query	decimal?	No
DiscountPercentageGreaterThanOrEqualTo	query	decimal?	No
DiscountPercentageGreaterThan	query	decimal?	No
DiscountPercentageLessThan	query	decimal?	No
DiscountPercentageLessThanOrEqualTo	query	decimal?	No
DiscountPercentageNotEqualTo	query	decimal?	No
DiscountPercentageBetween	query	Nullable<Decimal>[]	No
DiscountPercentageIn	query	Nullable<Decimal>[]	No
SalesmanCost	query	decimal?	No
SalesmanCostGreaterThanOrEqualTo	query	decimal?	No
SalesmanCostGreaterThan	query	decimal?	No
SalesmanCostLessThan	query	decimal?	No
SalesmanCostLessThanOrEqualTo	query	decimal?	No
SalesmanCostNotEqualTo	query	decimal?	No
SalesmanCostBetween	query	Nullable<Decimal>[]	No
SalesmanCostIn	query	Nullable<Decimal>[]	No
LineCost	query	decimal?	No
LineCostGreaterThanOrEqualTo	query	decimal?	No
LineCostGreaterThan	query	decimal?	No
LineCostLessThan	query	decimal?	No
LineCostLessThanOrEqualTo	query	decimal?	No
LineCostNotEqualTo	query	decimal?	No
LineCostBetween	query	Nullable<Decimal>[]	No
LineCostIn	query	Nullable<Decimal>[]	No
OrigInvoiceNo	query	string	No
OrigInvoiceNoStartsWith	query	string	No
OrigInvoiceNoEndsWith	query	string	No
OrigInvoiceNoContains	query	string	No
OrigInvoiceNoLike	query	string	No
OrigInvoiceNoBetween	query	string[]	No
OrigInvoiceNoIn	query	string[]	No
ItemPriceIncGST	query	decimal?	No
ItemPriceIncGSTGreaterThanOrEqualTo	query	decimal?	No
ItemPriceIncGSTGreaterThan	query	decimal?	No
ItemPriceIncGSTLessThan	query	decimal?	No
ItemPriceIncGSTLessThanOrEqualTo	query	decimal?	No
ItemPriceIncGSTNotEqualTo	query	decimal?	No
ItemPriceIncGSTBetween	query	Nullable<Decimal>[]	No
ItemPriceIncGSTIn	query	Nullable<Decimal>[]	No
ItemPriceUnDiscounted	query	decimal?	No
ItemPriceUnDiscountedGreaterThanOrEqualTo	query	decimal?	No
ItemPriceUnDiscountedGreaterThan	query	decimal?	No
ItemPriceUnDiscountedLessThan	query	decimal?	No
ItemPriceUnDiscountedLessThanOrEqualTo	query	decimal?	No
ItemPriceUnDiscountedNotEqualTo	query	decimal?	No
ItemPriceUnDiscountedBetween	query	Nullable<Decimal>[]	No
ItemPriceUnDiscountedIn	query	Nullable<Decimal>[]	No
DemandQuantity	query	decimal?	No
DemandQuantityGreaterThanOrEqualTo	query	decimal?	No
DemandQuantityGreaterThan	query	decimal?	No
DemandQuantityLessThan	query	decimal?	No
DemandQuantityLessThanOrEqualTo	query	decimal?	No
DemandQuantityNotEqualTo	query	decimal?	No
DemandQuantityBetween	query	Nullable<Decimal>[]	No
DemandQuantityIn	query	Nullable<Decimal>[]	No
NonStockLedgerSalesAccID	query	string	No
NonStockLedgerSalesAccIDStartsWith	query	string	No
NonStockLedgerSalesAccIDEndsWith	query	string	No
NonStockLedgerSalesAccIDContains	query	string	No
NonStockLedgerSalesAccIDLike	query	string	No
NonStockLedgerSalesAccIDBetween	query	string[]	No
NonStockLedgerSalesAccIDIn	query	string[]	No
KitLineID	query	string	No
KitLineIDStartsWith	query	string	No
KitLineIDEndsWith	query	string	No
KitLineIDContains	query	string	No
KitLineIDLike	query	string	No
KitLineIDBetween	query	string[]	No
KitLineIDIn	query	string[]	No
JobCostNo	query	string	No
JobCostNoStartsWith	query	string	No
JobCostNoEndsWith	query	string	No
JobCostNoContains	query	string	No
JobCostNoLike	query	string	No
JobCostNoBetween	query	string[]	No
JobCostNoIn	query	string[]	No
SellPriceIncTax	query	bool?	No
JobInvoiceItem	query	short?	No
JobInvoiceItemGreaterThanOrEqualTo	query	short?	No
JobInvoiceItemGreaterThan	query	short?	No
JobInvoiceItemLessThan	query	short?	No
JobInvoiceItemLessThanOrEqualTo	query	short?	No
JobInvoiceItemNotEqualTo	query	short?	No
JobInvoiceItemBetween	query	Nullable<Int16>[]	No
JobInvoiceItemIn	query	Nullable<Int16>[]	No
QuantityPrevDemand	query	decimal?	No
QuantityPrevDemandGreaterThanOrEqualTo	query	decimal?	No
QuantityPrevDemandGreaterThan	query	decimal?	No
QuantityPrevDemandLessThan	query	decimal?	No
QuantityPrevDemandLessThanOrEqualTo	query	decimal?	No
QuantityPrevDemandNotEqualTo	query	decimal?	No
QuantityPrevDemandBetween	query	Nullable<Decimal>[]	No
QuantityPrevDemandIn	query	Nullable<Decimal>[]	No
JobID	query	string	No
JobIDStartsWith	query	string	No
JobIDEndsWith	query	string	No
JobIDContains	query	string	No
JobIDLike	query	string	No
JobIDBetween	query	string[]	No
JobIDIn	query	string[]	No
CostCentreID	query	string	No
CostCentreIDStartsWith	query	string	No
CostCentreIDEndsWith	query	string	No
CostCentreIDContains	query	string	No
CostCentreIDLike	query	string	No
CostCentreIDBetween	query	string[]	No
CostCentreIDIn	query	string[]	No
StageID	query	string	No
StageIDStartsWith	query	string	No
StageIDEndsWith	query	string	No
StageIDContains	query	string	No
StageIDLike	query	string	No
StageIDBetween	query	string[]	No
StageIDIn	query	string[]	No
UserDefinedFloat1	query	decimal?	No
UserDefinedFloat1GreaterThanOrEqualTo	query	decimal?	No
UserDefinedFloat1GreaterThan	query	decimal?	No
UserDefinedFloat1LessThan	query	decimal?	No
UserDefinedFloat1LessThanOrEqualTo	query	decimal?	No
UserDefinedFloat1NotEqualTo	query	decimal?	No
UserDefinedFloat1Between	query	Nullable<Decimal>[]	No
UserDefinedFloat1In	query	Nullable<Decimal>[]	No
UserDefinedFloat2	query	decimal?	No
UserDefinedFloat2GreaterThanOrEqualTo	query	decimal?	No
UserDefinedFloat2GreaterThan	query	decimal?	No
UserDefinedFloat2LessThan	query	decimal?	No
UserDefinedFloat2LessThanOrEqualTo	query	decimal?	No
UserDefinedFloat2NotEqualTo	query	decimal?	No
UserDefinedFloat2Between	query	Nullable<Decimal>[]	No
UserDefinedFloat2In	query	Nullable<Decimal>[]	No
UserDefinedFloat3	query	decimal?	No
UserDefinedFloat3GreaterThanOrEqualTo	query	decimal?	No
UserDefinedFloat3GreaterThan	query	decimal?	No
UserDefinedFloat3LessThan	query	decimal?	No
UserDefinedFloat3LessThanOrEqualTo	query	decimal?	No
UserDefinedFloat3NotEqualTo	query	decimal?	No
UserDefinedFloat3Between	query	Nullable<Decimal>[]	No
UserDefinedFloat3In	query	Nullable<Decimal>[]	No
ForwardOrderDate	query	DateTime?	No
ForwardOrderDateGreaterThanOrEqualTo	query	DateTime?	No
ForwardOrderDateGreaterThan	query	DateTime?	No
ForwardOrderDateLessThan	query	DateTime?	No
ForwardOrderDateLessThanOrEqualTo	query	DateTime?	No
ForwardOrderDateNotEqualTo	query	DateTime?	No
ForwardOrderDateBetween	query	Nullable<DateTime>[]	No
ForwardOrderDateIn	query	Nullable<DateTime>[]	No
ScheduledDate	query	DateTime?	No
ScheduledDateGreaterThanOrEqualTo	query	DateTime?	No
ScheduledDateGreaterThan	query	DateTime?	No
ScheduledDateLessThan	query	DateTime?	No
ScheduledDateLessThanOrEqualTo	query	DateTime?	No
ScheduledDateNotEqualTo	query	DateTime?	No
ScheduledDateBetween	query	Nullable<DateTime>[]	No
ScheduledDateIn	query	Nullable<DateTime>[]	No
DeliverStock	query	bool?	No
FixSellPrice	query	bool?	No
TypeKitRounding	query	bool?	No
EDIStoreLocationCode	query	string	No
EDIStoreLocationCodeStartsWith	query	string	No
EDIStoreLocationCodeEndsWith	query	string	No
EDIStoreLocationCodeContains	query	string	No
EDIStoreLocationCodeLike	query	string	No
EDIStoreLocationCodeBetween	query	string[]	No
EDIStoreLocationCodeIn	query	string[]	No
EDIDCLocationCode	query	string	No
EDIDCLocationCodeStartsWith	query	string	No
EDIDCLocationCodeEndsWith	query	string	No
EDIDCLocationCodeContains	query	string	No
EDIDCLocationCodeLike	query	string	No
EDIDCLocationCodeBetween	query	string[]	No
EDIDCLocationCodeIn	query	string[]	No
SM_Parts_RecID	query	string	No
SM_Parts_RecIDStartsWith	query	string	No
SM_Parts_RecIDEndsWith	query	string	No
SM_Parts_RecIDContains	query	string	No
SM_Parts_RecIDLike	query	string	No
SM_Parts_RecIDBetween	query	string[]	No
SM_Parts_RecIDIn	query	string[]	No
SM_Labour_RecID	query	string	No
SM_Labour_RecIDStartsWith	query	string	No
SM_Labour_RecIDEndsWith	query	string	No
SM_Labour_RecIDContains	query	string	No
SM_Labour_RecIDLike	query	string	No
SM_Labour_RecIDBetween	query	string[]	No
SM_Labour_RecIDIn	query	string[]	No
IN_UnitOfMeasure_RecID	query	Guid?	No
IN_UnitOfMeasure_RecIDIn	query	Nullable<Guid>[]	No

**QueryBase** Parameters:
Name	Parameter	Data Type	Required
Skip	form	int?	No
Take	form	int?	No
OrderBy	form	string	No
OrderByDesc	form	string	No
Include	form	string	No
Fields	form	string	No
Meta	form	Dictionary<string, string>	No

**SO_Lines** Parameters:
Name	Parameter	Data Type	Required
InvoiceLineID	form	string	No
InvoiceHistoryID	form	string	No
GroupNo	form	short?	No
LineNum	form	short?	No
CommentLine	form	bool?	No
PartNo	form	string	No
Description	form	string	No
PhysicalItem	form	short?	No
ItemWeight	form	decimal?	No
ItemCubic	form	decimal?	No
TaxID	form	string	No
ClassDescription	form	string	No
Cat1Description	form	string	No
Cat2Description	form	string	No
Cat3Description	form	string	No
Units	form	string	No
CostIn	form	decimal?	No
DefaultPrice	form	decimal?	No
ItemPrice	form	decimal?	No
Discount	form	decimal?	No
InvoicePrice	form	decimal?	No
RRPPrice	form	decimal?	No
TaxToCharge	form	decimal?	No
TaxToPay	form	decimal?	No
CurrentLineTotal	form	decimal?	No
QuantityOrdered	form	decimal?	No
QuantityPrevDel	form	decimal?	No
QuantityThisDel	form	decimal?	No
QuantityBackOrd	form	decimal?	No
HistoryText_Comment	form	string	No
Discountable	form	bool?	No
TaxInc	form	bool?	No
DirectTax	form	decimal?	No
DecimalPlaces	form	short?	No
MinimumGP	form	decimal?	No
DebitLedger	form	string	No
CreditLedger	form	string	No
NonStock	form	bool?	No
InventoryID	form	string	No
UseSerialNo	form	bool?	No
Backorderable	form	bool?	No
Picked	form	bool?	No
TaxPaid	form	decimal?	No
TaxRate	form	decimal?	No
UsingSpecialPrice	form	bool?	No
EstBOValue	form	decimal?	No
ItemTaxToCharge	form	decimal?	No
ItemTaxToPay	form	decimal?	No
LineLinkID	form	string	No
KittingStatus	form	short	No
KittingUnits	form	decimal?	No
JobConnectorID	form	string	No
KitStyle	form	short?	No
DiscountPercentage	form	decimal?	No
SalesmanCost	form	decimal?	No
LineCost	form	decimal?	No
OrigInvoiceNo	form	string	No
ItemPriceIncGST	form	decimal?	No
ItemPriceUnDiscounted	form	decimal?	No
DemandQuantity	form	decimal?	No
NonStockLedgerSalesAccID	form	string	No
KitLineID	form	string	No
JobCostNo	form	string	No
SellPriceIncTax	form	bool	No
JobInvoiceItem	form	short?	No
QuantityPrevDemand	form	decimal?	No
JobID	form	string	No
CostCentreID	form	string	No
StageID	form	string	No
UserDefinedFloat1	form	decimal?	No
UserDefinedFloat2	form	decimal?	No
UserDefinedFloat3	form	decimal?	No
ForwardOrderDate	form	DateTime?	No
ScheduledDate	form	DateTime?	No
DeliverStock	form	bool	No
FixSellPrice	form	bool	No
TypeKitRounding	form	bool?	No
EDIStoreLocationCode	form	string	No
EDIDCLocationCode	form	string	No
SM_Parts_RecID	form	string	No
SM_Labour_RecID	form	string	No
IN_UnitOfMeasure_RecID	form	Guid?	No

**QueryResponse<T>** Parameters:
Name	Parameter	Data Type	Required
Offset	form	int	No
Total	form	int	No
Results	form	List<T>	No
Meta	form	Dictionary<string, string>	No
ResponseStatus	form	ResponseStatus	No

To override the Content-type in your clients, use the HTTP Accept Header, append the .csv suffix or ?format=csv

HTTP + CSV

The following are sample HTTP requests and responses. The placeholders shown need to be replaced with actual values.

POST /csv/reply/SO_LinesQuery HTTP/1.1 
Host: api.jiwa.com.au 
Accept: text/csv
Content-Type: text/csv
Content-Length: length

{"InvoiceLineID":"String","InvoiceLineIDStartsWith":"String","InvoiceLineIDEndsWith":"String","InvoiceLineIDContains":"String","InvoiceLineIDLike":"String","InvoiceLineIDBetween":["String"],"InvoiceLineIDIn":["String"],"InvoiceHistoryID":"String","InvoiceHistoryIDStartsWith":"String","InvoiceHistoryIDEndsWith":"String","InvoiceHistoryIDContains":"String","InvoiceHistoryIDLike":"String","InvoiceHistoryIDBetween":["String"],"InvoiceHistoryIDIn":["String"],"GroupNo":0,"GroupNoGreaterThanOrEqualTo":0,"GroupNoGreaterThan":0,"GroupNoLessThan":0,"GroupNoLessThanOrEqualTo":0,"GroupNoNotEqualTo":0,"GroupNoBetween":[0],"GroupNoIn":[0],"LineNum":0,"LineNumGreaterThanOrEqualTo":0,"LineNumGreaterThan":0,"LineNumLessThan":0,"LineNumLessThanOrEqualTo":0,"LineNumNotEqualTo":0,"LineNumBetween":[0],"LineNumIn":[0],"CommentLine":false,"PartNo":"String","PartNoStartsWith":"String","PartNoEndsWith":"String","PartNoContains":"String","PartNoLike":"String","PartNoBetween":["String"],"PartNoIn":["String"],"Description":"String","DescriptionStartsWith":"String","DescriptionEndsWith":"String","DescriptionContains":"String","DescriptionLike":"String","DescriptionBetween":["String"],"DescriptionIn":["String"],"PhysicalItem":0,"PhysicalItemGreaterThanOrEqualTo":0,"PhysicalItemGreaterThan":0,"PhysicalItemLessThan":0,"PhysicalItemLessThanOrEqualTo":0,"PhysicalItemNotEqualTo":0,"PhysicalItemBetween":[0],"PhysicalItemIn":[0],"ItemWeight":0,"ItemWeightGreaterThanOrEqualTo":0,"ItemWeightGreaterThan":0,"ItemWeightLessThan":0,"ItemWeightLessThanOrEqualTo":0,"ItemWeightNotEqualTo":0,"ItemWeightBetween":[0],"ItemWeightIn":[0],"ItemCubic":0,"ItemCubicGreaterThanOrEqualTo":0,"ItemCubicGreaterThan":0,"ItemCubicLessThan":0,"ItemCubicLessThanOrEqualTo":0,"ItemCubicNotEqualTo":0,"ItemCubicBetween":[0],"ItemCubicIn":[0],"TaxID":"String","TaxIDStartsWith":"String","TaxIDEndsWith":"String","TaxIDContains":"String","TaxIDLike":"String","TaxIDBetween":["String"],"TaxIDIn":["String"],"ClassDescription":"String","ClassDescriptionStartsWith":"String","ClassDescriptionEndsWith":"String","ClassDescriptionContains":"String","ClassDescriptionLike":"String","ClassDescriptionBetween":["String"],"ClassDescriptionIn":["String"],"Cat1Description":"String","Cat1DescriptionStartsWith":"String","Cat1DescriptionEndsWith":"String","Cat1DescriptionContains":"String","Cat1DescriptionLike":"String","Cat1DescriptionBetween":["String"],"Cat1DescriptionIn":["String"],"Cat2Description":"String","Cat2DescriptionStartsWith":"String","Cat2DescriptionEndsWith":"String","Cat2DescriptionContains":"String","Cat2DescriptionLike":"String","Cat2DescriptionBetween":["String"],"Cat2DescriptionIn":["String"],"Cat3Description":"String","Cat3DescriptionStartsWith":"String","Cat3DescriptionEndsWith":"String","Cat3DescriptionContains":"String","Cat3DescriptionLike":"String","Cat3DescriptionBetween":["String"],"Cat3DescriptionIn":["String"],"Units":"String","UnitsStartsWith":"String","UnitsEndsWith":"String","UnitsContains":"String","UnitsLike":"String","UnitsBetween":["String"],"UnitsIn":["String"],"CostIn":0,"CostInGreaterThanOrEqualTo":0,"CostInGreaterThan":0,"CostInLessThan":0,"CostInLessThanOrEqualTo":0,"CostInNotEqualTo":0,"CostInBetween":[0],"CostInIn":[0],"DefaultPrice":0,"DefaultPriceGreaterThanOrEqualTo":0,"DefaultPriceGreaterThan":0,"DefaultPriceLessThan":0,"DefaultPriceLessThanOrEqualTo":0,"DefaultPriceNotEqualTo":0,"DefaultPriceBetween":[0],"DefaultPriceIn":[0],"ItemPrice":0,"ItemPriceGreaterThanOrEqualTo":0,"ItemPriceGreaterThan":0,"ItemPriceLessThan":0,"ItemPriceLessThanOrEqualTo":0,"ItemPriceNotEqualTo":0,"ItemPriceBetween":[0],"ItemPriceIn":[0],"Discount":0,"DiscountGreaterThanOrEqualTo":0,"DiscountGreaterThan":0,"DiscountLessThan":0,"DiscountLessThanOrEqualTo":0,"DiscountNotEqualTo":0,"DiscountBetween":[0],"DiscountIn":[0],"InvoicePrice":0,"InvoicePriceGreaterThanOrEqualTo":0,"InvoicePriceGreaterThan":0,"InvoicePriceLessThan":0,"InvoicePriceLessThanOrEqualTo":0,"InvoicePriceNotEqualTo":0,"InvoicePriceBetween":[0],"InvoicePriceIn":[0],"RRPPrice":0,"RRPPriceGreaterThanOrEqualTo":0,"RRPPriceGreaterThan":0,"RRPPriceLessThan":0,"RRPPriceLessThanOrEqualTo":0,"RRPPriceNotEqualTo":0,"RRPPriceBetween":[0],"RRPPriceIn":[0],"TaxToCharge":0,"TaxToChargeGreaterThanOrEqualTo":0,"TaxToChargeGreaterThan":0,"TaxToChargeLessThan":0,"TaxToChargeLessThanOrEqualTo":0,"TaxToChargeNotEqualTo":0,"TaxToChargeBetween":[0],"TaxToChargeIn":[0],"TaxToPay":0,"TaxToPayGreaterThanOrEqualTo":0,"TaxToPayGreaterThan":0,"TaxToPayLessThan":0,"TaxToPayLessThanOrEqualTo":0,"TaxToPayNotEqualTo":0,"TaxToPayBetween":[0],"TaxToPayIn":[0],"CurrentLineTotal":0,"CurrentLineTotalGreaterThanOrEqualTo":0,"CurrentLineTotalGreaterThan":0,"CurrentLineTotalLessThan":0,"CurrentLineTotalLessThanOrEqualTo":0,"CurrentLineTotalNotEqualTo":0,"CurrentLineTotalBetween":[0],"CurrentLineTotalIn":[0],"QuantityOrdered":0,"QuantityOrderedGreaterThanOrEqualTo":0,"QuantityOrderedGreaterThan":0,"QuantityOrderedLessThan":0,"QuantityOrderedLessThanOrEqualTo":0,"QuantityOrderedNotEqualTo":0,"QuantityOrderedBetween":[0],"QuantityOrderedIn":[0],"QuantityPrevDel":0,"QuantityPrevDelGreaterThanOrEqualTo":0,"QuantityPrevDelGreaterThan":0,"QuantityPrevDelLessThan":0,"QuantityPrevDelLessThanOrEqualTo":0,"QuantityPrevDelNotEqualTo":0,"QuantityPrevDelBetween":[0],"QuantityPrevDelIn":[0],"QuantityThisDel":0,"QuantityThisDelGreaterThanOrEqualTo":0,"QuantityThisDelGreaterThan":0,"QuantityThisDelLessThan":0,"QuantityThisDelLessThanOrEqualTo":0,"QuantityThisDelNotEqualTo":0,"QuantityThisDelBetween":[0],"QuantityThisDelIn":[0],"QuantityBackOrd":0,"QuantityBackOrdGreaterThanOrEqualTo":0,"QuantityBackOrdGreaterThan":0,"QuantityBackOrdLessThan":0,"QuantityBackOrdLessThanOrEqualTo":0,"QuantityBackOrdNotEqualTo":0,"QuantityBackOrdBetween":[0],"QuantityBackOrdIn":[0],"HistoryText_Comment":"String","HistoryText_CommentStartsWith":"String","HistoryText_CommentEndsWith":"String","HistoryText_CommentContains":"String","HistoryText_CommentLike":"String","HistoryText_CommentBetween":["String"],"HistoryText_CommentIn":["String"],"Discountable":false,"TaxInc":false,"DirectTax":0,"DirectTaxGreaterThanOrEqualTo":0,"DirectTaxGreaterThan":0,"DirectTaxLessThan":0,"DirectTaxLessThanOrEqualTo":0,"DirectTaxNotEqualTo":0,"DirectTaxBetween":[0],"DirectTaxIn":[0],"DecimalPlaces":0,"DecimalPlacesGreaterThanOrEqualTo":0,"DecimalPlacesGreaterThan":0,"DecimalPlacesLessThan":0,"DecimalPlacesLessThanOrEqualTo":0,"DecimalPlacesNotEqualTo":0,"DecimalPlacesBetween":[0],"DecimalPlacesIn":[0],"MinimumGP":0,"MinimumGPGreaterThanOrEqualTo":0,"MinimumGPGreaterThan":0,"MinimumGPLessThan":0,"MinimumGPLessThanOrEqualTo":0,"MinimumGPNotEqualTo":0,"MinimumGPBetween":[0],"MinimumGPIn":[0],"DebitLedger":"String","DebitLedgerStartsWith":"String","DebitLedgerEndsWith":"String","DebitLedgerContains":"String","DebitLedgerLike":"String","DebitLedgerBetween":["String"],"DebitLedgerIn":["String"],"CreditLedger":"String","CreditLedgerStartsWith":"String","CreditLedgerEndsWith":"String","CreditLedgerContains":"String","CreditLedgerLike":"String","CreditLedgerBetween":["String"],"CreditLedgerIn":["String"],"NonStock":false,"InventoryID":"String","InventoryIDStartsWith":"String","InventoryIDEndsWith":"String","InventoryIDContains":"String","InventoryIDLike":"String","InventoryIDBetween":["String"],"InventoryIDIn":["String"],"UseSerialNo":false,"Backorderable":false,"Picked":false,"TaxPaid":0,"TaxPaidGreaterThanOrEqualTo":0,"TaxPaidGreaterThan":0,"TaxPaidLessThan":0,"TaxPaidLessThanOrEqualTo":0,"TaxPaidNotEqualTo":0,"TaxPaidBetween":[0],"TaxPaidIn":[0],"TaxRate":0,"TaxRateGreaterThanOrEqualTo":0,"TaxRateGreaterThan":0,"TaxRateLessThan":0,"TaxRateLessThanOrEqualTo":0,"TaxRateNotEqualTo":0,"TaxRateBetween":[0],"TaxRateIn":[0],"UsingSpecialPrice":false,"EstBOValue":0,"EstBOValueGreaterThanOrEqualTo":0,"EstBOValueGreaterThan":0,"EstBOValueLessThan":0,"EstBOValueLessThanOrEqualTo":0,"EstBOValueNotEqualTo":0,"EstBOValueBetween":[0],"EstBOValueIn":[0],"ItemTaxToCharge":0,"ItemTaxToChargeGreaterThanOrEqualTo":0,"ItemTaxToChargeGreaterThan":0,"ItemTaxToChargeLessThan":0,"ItemTaxToChargeLessThanOrEqualTo":0,"ItemTaxToChargeNotEqualTo":0,"ItemTaxToChargeBetween":[0],"ItemTaxToChargeIn":[0],"ItemTaxToPay":0,"ItemTaxToPayGreaterThanOrEqualTo":0,"ItemTaxToPayGreaterThan":0,"ItemTaxToPayLessThan":0,"ItemTaxToPayLessThanOrEqualTo":0,"ItemTaxToPayNotEqualTo":0,"ItemTaxToPayBetween":[0],"ItemTaxToPayIn":[0],"LineLinkID":"String","LineLinkIDStartsWith":"String","LineLinkIDEndsWith":"String","LineLinkIDContains":"String","LineLinkIDLike":"String","LineLinkIDBetween":["String"],"LineLinkIDIn":["String"],"KittingStatus":0,"KittingStatusGreaterThanOrEqualTo":0,"KittingStatusGreaterThan":0,"KittingStatusLessThan":0,"KittingStatusLessThanOrEqualTo":0,"KittingStatusNotEqualTo":0,"KittingStatusBetween":[0],"KittingStatusIn":[0],"KittingUnits":0,"KittingUnitsGreaterThanOrEqualTo":0,"KittingUnitsGreaterThan":0,"KittingUnitsLessThan":0,"KittingUnitsLessThanOrEqualTo":0,"KittingUnitsNotEqualTo":0,"KittingUnitsBetween":[0],"KittingUnitsIn":[0],"JobConnectorID":"String","JobConnectorIDStartsWith":"String","JobConnectorIDEndsWith":"String","JobConnectorIDContains":"String","JobConnectorIDLike":"String","JobConnectorIDBetween":["String"],"JobConnectorIDIn":["String"],"KitStyle":0,"KitStyleGreaterThanOrEqualTo":0,"KitStyleGreaterThan":0,"KitStyleLessThan":0,"KitStyleLessThanOrEqualTo":0,"KitStyleNotEqualTo":0,"KitStyleBetween":[0],"KitStyleIn":[0],"DiscountPercentage":0,"DiscountPercentageGreaterThanOrEqualTo":0,"DiscountPercentageGreaterThan":0,"DiscountPercentageLessThan":0,"DiscountPercentageLessThanOrEqualTo":0,"DiscountPercentageNotEqualTo":0,"DiscountPercentageBetween":[0],"DiscountPercentageIn":[0],"SalesmanCost":0,"SalesmanCostGreaterThanOrEqualTo":0,"SalesmanCostGreaterThan":0,"SalesmanCostLessThan":0,"SalesmanCostLessThanOrEqualTo":0,"SalesmanCostNotEqualTo":0,"SalesmanCostBetween":[0],"SalesmanCostIn":[0],"LineCost":0,"LineCostGreaterThanOrEqualTo":0,"LineCostGreaterThan":0,"LineCostLessThan":0,"LineCostLessThanOrEqualTo":0,"LineCostNotEqualTo":0,"LineCostBetween":[0],"LineCostIn":[0],"OrigInvoiceNo":"String","OrigInvoiceNoStartsWith":"String","OrigInvoiceNoEndsWith":"String","OrigInvoiceNoContains":"String","OrigInvoiceNoLike":"String","OrigInvoiceNoBetween":["String"],"OrigInvoiceNoIn":["String"],"ItemPriceIncGST":0,"ItemPriceIncGSTGreaterThanOrEqualTo":0,"ItemPriceIncGSTGreaterThan":0,"ItemPriceIncGSTLessThan":0,"ItemPriceIncGSTLessThanOrEqualTo":0,"ItemPriceIncGSTNotEqualTo":0,"ItemPriceIncGSTBetween":[0],"ItemPriceIncGSTIn":[0],"ItemPriceUnDiscounted":0,"ItemPriceUnDiscountedGreaterThanOrEqualTo":0,"ItemPriceUnDiscountedGreaterThan":0,"ItemPriceUnDiscountedLessThan":0,"ItemPriceUnDiscountedLessThanOrEqualTo":0,"ItemPriceUnDiscountedNotEqualTo":0,"ItemPriceUnDiscountedBetween":[0],"ItemPriceUnDiscountedIn":[0],"DemandQuantity":0,"DemandQuantityGreaterThanOrEqualTo":0,"DemandQuantityGreaterThan":0,"DemandQuantityLessThan":0,"DemandQuantityLessThanOrEqualTo":0,"DemandQuantityNotEqualTo":0,"DemandQuantityBetween":[0],"DemandQuantityIn":[0],"NonStockLedgerSalesAccID":"String","NonStockLedgerSalesAccIDStartsWith":"String","NonStockLedgerSalesAccIDEndsWith":"String","NonStockLedgerSalesAccIDContains":"String","NonStockLedgerSalesAccIDLike":"String","NonStockLedgerSalesAccIDBetween":["String"],"NonStockLedgerSalesAccIDIn":["String"],"KitLineID":"String","KitLineIDStartsWith":"String","KitLineIDEndsWith":"String","KitLineIDContains":"String","KitLineIDLike":"String","KitLineIDBetween":["String"],"KitLineIDIn":["String"],"JobCostNo":"String","JobCostNoStartsWith":"String","JobCostNoEndsWith":"String","JobCostNoContains":"String","JobCostNoLike":"String","JobCostNoBetween":["String"],"JobCostNoIn":["String"],"SellPriceIncTax":false,"JobInvoiceItem":0,"JobInvoiceItemGreaterThanOrEqualTo":0,"JobInvoiceItemGreaterThan":0,"JobInvoiceItemLessThan":0,"JobInvoiceItemLessThanOrEqualTo":0,"JobInvoiceItemNotEqualTo":0,"JobInvoiceItemBetween":[0],"JobInvoiceItemIn":[0],"QuantityPrevDemand":0,"QuantityPrevDemandGreaterThanOrEqualTo":0,"QuantityPrevDemandGreaterThan":0,"QuantityPrevDemandLessThan":0,"QuantityPrevDemandLessThanOrEqualTo":0,"QuantityPrevDemandNotEqualTo":0,"QuantityPrevDemandBetween":[0],"QuantityPrevDemandIn":[0],"JobID":"String","JobIDStartsWith":"String","JobIDEndsWith":"String","JobIDContains":"String","JobIDLike":"String","JobIDBetween":["String"],"JobIDIn":["String"],"CostCentreID":"String","CostCentreIDStartsWith":"String","CostCentreIDEndsWith":"String","CostCentreIDContains":"String","CostCentreIDLike":"String","CostCentreIDBetween":["String"],"CostCentreIDIn":["String"],"StageID":"String","StageIDStartsWith":"String","StageIDEndsWith":"String","StageIDContains":"String","StageIDLike":"String","StageIDBetween":["String"],"StageIDIn":["String"],"UserDefinedFloat1":0,"UserDefinedFloat1GreaterThanOrEqualTo":0,"UserDefinedFloat1GreaterThan":0,"UserDefinedFloat1LessThan":0,"UserDefinedFloat1LessThanOrEqualTo":0,"UserDefinedFloat1NotEqualTo":0,"UserDefinedFloat1Between":[0],"UserDefinedFloat1In":[0],"UserDefinedFloat2":0,"UserDefinedFloat2GreaterThanOrEqualTo":0,"UserDefinedFloat2GreaterThan":0,"UserDefinedFloat2LessThan":0,"UserDefinedFloat2LessThanOrEqualTo":0,"UserDefinedFloat2NotEqualTo":0,"UserDefinedFloat2Between":[0],"UserDefinedFloat2In":[0],"UserDefinedFloat3":0,"UserDefinedFloat3GreaterThanOrEqualTo":0,"UserDefinedFloat3GreaterThan":0,"UserDefinedFloat3LessThan":0,"UserDefinedFloat3LessThanOrEqualTo":0,"UserDefinedFloat3NotEqualTo":0,"UserDefinedFloat3Between":[0],"UserDefinedFloat3In":[0],"ForwardOrderDate":"0001-01-01T00:00:00.0000000","ForwardOrderDateGreaterThanOrEqualTo":"0001-01-01T00:00:00.0000000","ForwardOrderDateGreaterThan":"0001-01-01T00:00:00.0000000","ForwardOrderDateLessThan":"0001-01-01T00:00:00.0000000","ForwardOrderDateLessThanOrEqualTo":"0001-01-01T00:00:00.0000000","ForwardOrderDateNotEqualTo":"0001-01-01T00:00:00.0000000","ForwardOrderDateBetween":["0001-01-01T00:00:00.0000000"],"ForwardOrderDateIn":["0001-01-01T00:00:00.0000000"],"ScheduledDate":"0001-01-01T00:00:00.0000000","ScheduledDateGreaterThanOrEqualTo":"0001-01-01T00:00:00.0000000","ScheduledDateGreaterThan":"0001-01-01T00:00:00.0000000","ScheduledDateLessThan":"0001-01-01T00:00:00.0000000","ScheduledDateLessThanOrEqualTo":"0001-01-01T00:00:00.0000000","ScheduledDateNotEqualTo":"0001-01-01T00:00:00.0000000","ScheduledDateBetween":["0001-01-01T00:00:00.0000000"],"ScheduledDateIn":["0001-01-01T00:00:00.0000000"],"DeliverStock":false,"FixSellPrice":false,"TypeKitRounding":false,"EDIStoreLocationCode":"String","EDIStoreLocationCodeStartsWith":"String","EDIStoreLocationCodeEndsWith":"String","EDIStoreLocationCodeContains":"String","EDIStoreLocationCodeLike":"String","EDIStoreLocationCodeBetween":["String"],"EDIStoreLocationCodeIn":["String"],"EDIDCLocationCode":"String","EDIDCLocationCodeStartsWith":"String","EDIDCLocationCodeEndsWith":"String","EDIDCLocationCodeContains":"String","EDIDCLocationCodeLike":"String","EDIDCLocationCodeBetween":["String"],"EDIDCLocationCodeIn":["String"],"SM_Parts_RecID":"String","SM_Parts_RecIDStartsWith":"String","SM_Parts_RecIDEndsWith":"String","SM_Parts_RecIDContains":"String","SM_Parts_RecIDLike":"String","SM_Parts_RecIDBetween":["String"],"SM_Parts_RecIDIn":["String"],"SM_Labour_RecID":"String","SM_Labour_RecIDStartsWith":"String","SM_Labour_RecIDEndsWith":"String","SM_Labour_RecIDContains":"String","SM_Labour_RecIDLike":"String","SM_Labour_RecIDBetween":["String"],"SM_Labour_RecIDIn":["String"],"IN_UnitOfMeasure_RecID":"00000000000000000000000000000000","IN_UnitOfMeasure_RecIDIn":["00000000000000000000000000000000"],"Skip":0,"Take":0,"OrderBy":"String","OrderByDesc":"String","Include":"String","Fields":"String","Meta":{"String":"String"}}

HTTP/1.1 200 OK
Content-Type: text/csv
Content-Length: length

{"Results":[{"InvoiceLineID":"String","InvoiceHistoryID":"String","GroupNo":0,"LineNum":0,"CommentLine":false,"PartNo":"String","Description":"String","PhysicalItem":0,"ItemWeight":0,"ItemCubic":0,"TaxID":"String","ClassDescription":"String","Cat1Description":"String","Cat2Description":"String","Cat3Description":"String","Units":"String","CostIn":0,"DefaultPrice":0,"ItemPrice":0,"Discount":0,"InvoicePrice":0,"RRPPrice":0,"TaxToCharge":0,"TaxToPay":0,"CurrentLineTotal":0,"QuantityOrdered":0,"QuantityPrevDel":0,"QuantityThisDel":0,"QuantityBackOrd":0,"HistoryText_Comment":"String","Discountable":false,"TaxInc":false,"DirectTax":0,"DecimalPlaces":0,"MinimumGP":0,"DebitLedger":"String","CreditLedger":"String","NonStock":false,"InventoryID":"String","UseSerialNo":false,"Backorderable":false,"Picked":false,"TaxPaid":0,"TaxRate":0,"UsingSpecialPrice":false,"EstBOValue":0,"ItemTaxToCharge":0,"ItemTaxToPay":0,"LineLinkID":"String","KittingUnits":0,"JobConnectorID":"String","KitStyle":0,"DiscountPercentage":0,"SalesmanCost":0,"LineCost":0,"OrigInvoiceNo":"String","ItemPriceIncGST":0,"ItemPriceUnDiscounted":0,"DemandQuantity":0,"NonStockLedgerSalesAccID":"String","KitLineID":"String","JobCostNo":"String","JobInvoiceItem":0,"QuantityPrevDemand":0,"JobID":"String","CostCentreID":"String","StageID":"String","UserDefinedFloat1":0,"UserDefinedFloat2":0,"UserDefinedFloat3":0,"ForwardOrderDate":"0001-01-01T00:00:00.0000000","ScheduledDate":"0001-01-01T00:00:00.0000000","TypeKitRounding":false,"EDIStoreLocationCode":"String","EDIDCLocationCode":"String","SM_Parts_RecID":"String","SM_Labour_RecID":"String","IN_UnitOfMeasure_RecID":"00000000000000000000000000000000"}],"Meta":{"String":"String"},"ResponseStatus":{"ErrorCode":"String","Message":"String","StackTrace":"String","Errors":[{"ErrorCode":"String","FieldName":"String","Message":"String","Meta":{"String":"String"}}],"Meta":{"String":"String"}}}