JiwaAPI

<back to all web services

SO_LinesQuery

Requires Authentication
SO_LinesQuery Parameters:
NameParameterData TypeRequiredDescription
InvoiceLineIDquerystringNo
InvoiceLineIDStartsWithquerystringNo
InvoiceLineIDEndsWithquerystringNo
InvoiceLineIDContainsquerystringNo
InvoiceLineIDLikequerystringNo
InvoiceLineIDBetweenquerystring[]No
InvoiceLineIDInquerystring[]No
InvoiceHistoryIDquerystringNo
InvoiceHistoryIDStartsWithquerystringNo
InvoiceHistoryIDEndsWithquerystringNo
InvoiceHistoryIDContainsquerystringNo
InvoiceHistoryIDLikequerystringNo
InvoiceHistoryIDBetweenquerystring[]No
InvoiceHistoryIDInquerystring[]No
GroupNoqueryshort?No
GroupNoGreaterThanOrEqualToqueryshort?No
GroupNoGreaterThanqueryshort?No
GroupNoLessThanqueryshort?No
GroupNoLessThanOrEqualToqueryshort?No
GroupNoNotEqualToqueryshort?No
GroupNoBetweenqueryNullable<Int16>[]No
GroupNoInqueryNullable<Int16>[]No
LineNumqueryshort?No
LineNumGreaterThanOrEqualToqueryshort?No
LineNumGreaterThanqueryshort?No
LineNumLessThanqueryshort?No
LineNumLessThanOrEqualToqueryshort?No
LineNumNotEqualToqueryshort?No
LineNumBetweenqueryNullable<Int16>[]No
LineNumInqueryNullable<Int16>[]No
CommentLinequerybool?No
PartNoquerystringNo
PartNoStartsWithquerystringNo
PartNoEndsWithquerystringNo
PartNoContainsquerystringNo
PartNoLikequerystringNo
PartNoBetweenquerystring[]No
PartNoInquerystring[]No
DescriptionquerystringNo
DescriptionStartsWithquerystringNo
DescriptionEndsWithquerystringNo
DescriptionContainsquerystringNo
DescriptionLikequerystringNo
DescriptionBetweenquerystring[]No
DescriptionInquerystring[]No
PhysicalItemqueryshort?No
PhysicalItemGreaterThanOrEqualToqueryshort?No
PhysicalItemGreaterThanqueryshort?No
PhysicalItemLessThanqueryshort?No
PhysicalItemLessThanOrEqualToqueryshort?No
PhysicalItemNotEqualToqueryshort?No
PhysicalItemBetweenqueryNullable<Int16>[]No
PhysicalItemInqueryNullable<Int16>[]No
ItemWeightquerydecimal?No
ItemWeightGreaterThanOrEqualToquerydecimal?No
ItemWeightGreaterThanquerydecimal?No
ItemWeightLessThanquerydecimal?No
ItemWeightLessThanOrEqualToquerydecimal?No
ItemWeightNotEqualToquerydecimal?No
ItemWeightBetweenqueryNullable<Decimal>[]No
ItemWeightInqueryNullable<Decimal>[]No
ItemCubicquerydecimal?No
ItemCubicGreaterThanOrEqualToquerydecimal?No
ItemCubicGreaterThanquerydecimal?No
ItemCubicLessThanquerydecimal?No
ItemCubicLessThanOrEqualToquerydecimal?No
ItemCubicNotEqualToquerydecimal?No
ItemCubicBetweenqueryNullable<Decimal>[]No
ItemCubicInqueryNullable<Decimal>[]No
TaxIDquerystringNo
TaxIDStartsWithquerystringNo
TaxIDEndsWithquerystringNo
TaxIDContainsquerystringNo
TaxIDLikequerystringNo
TaxIDBetweenquerystring[]No
TaxIDInquerystring[]No
ClassDescriptionquerystringNo
ClassDescriptionStartsWithquerystringNo
ClassDescriptionEndsWithquerystringNo
ClassDescriptionContainsquerystringNo
ClassDescriptionLikequerystringNo
ClassDescriptionBetweenquerystring[]No
ClassDescriptionInquerystring[]No
Cat1DescriptionquerystringNo
Cat1DescriptionStartsWithquerystringNo
Cat1DescriptionEndsWithquerystringNo
Cat1DescriptionContainsquerystringNo
Cat1DescriptionLikequerystringNo
Cat1DescriptionBetweenquerystring[]No
Cat1DescriptionInquerystring[]No
Cat2DescriptionquerystringNo
Cat2DescriptionStartsWithquerystringNo
Cat2DescriptionEndsWithquerystringNo
Cat2DescriptionContainsquerystringNo
Cat2DescriptionLikequerystringNo
Cat2DescriptionBetweenquerystring[]No
Cat2DescriptionInquerystring[]No
Cat3DescriptionquerystringNo
Cat3DescriptionStartsWithquerystringNo
Cat3DescriptionEndsWithquerystringNo
Cat3DescriptionContainsquerystringNo
Cat3DescriptionLikequerystringNo
Cat3DescriptionBetweenquerystring[]No
Cat3DescriptionInquerystring[]No
UnitsquerystringNo
UnitsStartsWithquerystringNo
UnitsEndsWithquerystringNo
UnitsContainsquerystringNo
UnitsLikequerystringNo
UnitsBetweenquerystring[]No
UnitsInquerystring[]No
CostInquerydecimal?No
CostInGreaterThanOrEqualToquerydecimal?No
CostInGreaterThanquerydecimal?No
CostInLessThanquerydecimal?No
CostInLessThanOrEqualToquerydecimal?No
CostInNotEqualToquerydecimal?No
CostInBetweenqueryNullable<Decimal>[]No
CostInInqueryNullable<Decimal>[]No
DefaultPricequerydecimal?No
DefaultPriceGreaterThanOrEqualToquerydecimal?No
DefaultPriceGreaterThanquerydecimal?No
DefaultPriceLessThanquerydecimal?No
DefaultPriceLessThanOrEqualToquerydecimal?No
DefaultPriceNotEqualToquerydecimal?No
DefaultPriceBetweenqueryNullable<Decimal>[]No
DefaultPriceInqueryNullable<Decimal>[]No
ItemPricequerydecimal?No
ItemPriceGreaterThanOrEqualToquerydecimal?No
ItemPriceGreaterThanquerydecimal?No
ItemPriceLessThanquerydecimal?No
ItemPriceLessThanOrEqualToquerydecimal?No
ItemPriceNotEqualToquerydecimal?No
ItemPriceBetweenqueryNullable<Decimal>[]No
ItemPriceInqueryNullable<Decimal>[]No
Discountquerydecimal?No
DiscountGreaterThanOrEqualToquerydecimal?No
DiscountGreaterThanquerydecimal?No
DiscountLessThanquerydecimal?No
DiscountLessThanOrEqualToquerydecimal?No
DiscountNotEqualToquerydecimal?No
DiscountBetweenqueryNullable<Decimal>[]No
DiscountInqueryNullable<Decimal>[]No
InvoicePricequerydecimal?No
InvoicePriceGreaterThanOrEqualToquerydecimal?No
InvoicePriceGreaterThanquerydecimal?No
InvoicePriceLessThanquerydecimal?No
InvoicePriceLessThanOrEqualToquerydecimal?No
InvoicePriceNotEqualToquerydecimal?No
InvoicePriceBetweenqueryNullable<Decimal>[]No
InvoicePriceInqueryNullable<Decimal>[]No
RRPPricequerydecimal?No
RRPPriceGreaterThanOrEqualToquerydecimal?No
RRPPriceGreaterThanquerydecimal?No
RRPPriceLessThanquerydecimal?No
RRPPriceLessThanOrEqualToquerydecimal?No
RRPPriceNotEqualToquerydecimal?No
RRPPriceBetweenqueryNullable<Decimal>[]No
RRPPriceInqueryNullable<Decimal>[]No
TaxToChargequerydecimal?No
TaxToChargeGreaterThanOrEqualToquerydecimal?No
TaxToChargeGreaterThanquerydecimal?No
TaxToChargeLessThanquerydecimal?No
TaxToChargeLessThanOrEqualToquerydecimal?No
TaxToChargeNotEqualToquerydecimal?No
TaxToChargeBetweenqueryNullable<Decimal>[]No
TaxToChargeInqueryNullable<Decimal>[]No
TaxToPayquerydecimal?No
TaxToPayGreaterThanOrEqualToquerydecimal?No
TaxToPayGreaterThanquerydecimal?No
TaxToPayLessThanquerydecimal?No
TaxToPayLessThanOrEqualToquerydecimal?No
TaxToPayNotEqualToquerydecimal?No
TaxToPayBetweenqueryNullable<Decimal>[]No
TaxToPayInqueryNullable<Decimal>[]No
CurrentLineTotalquerydecimal?No
CurrentLineTotalGreaterThanOrEqualToquerydecimal?No
CurrentLineTotalGreaterThanquerydecimal?No
CurrentLineTotalLessThanquerydecimal?No
CurrentLineTotalLessThanOrEqualToquerydecimal?No
CurrentLineTotalNotEqualToquerydecimal?No
CurrentLineTotalBetweenqueryNullable<Decimal>[]No
CurrentLineTotalInqueryNullable<Decimal>[]No
QuantityOrderedquerydecimal?No
QuantityOrderedGreaterThanOrEqualToquerydecimal?No
QuantityOrderedGreaterThanquerydecimal?No
QuantityOrderedLessThanquerydecimal?No
QuantityOrderedLessThanOrEqualToquerydecimal?No
QuantityOrderedNotEqualToquerydecimal?No
QuantityOrderedBetweenqueryNullable<Decimal>[]No
QuantityOrderedInqueryNullable<Decimal>[]No
QuantityPrevDelquerydecimal?No
QuantityPrevDelGreaterThanOrEqualToquerydecimal?No
QuantityPrevDelGreaterThanquerydecimal?No
QuantityPrevDelLessThanquerydecimal?No
QuantityPrevDelLessThanOrEqualToquerydecimal?No
QuantityPrevDelNotEqualToquerydecimal?No
QuantityPrevDelBetweenqueryNullable<Decimal>[]No
QuantityPrevDelInqueryNullable<Decimal>[]No
QuantityThisDelquerydecimal?No
QuantityThisDelGreaterThanOrEqualToquerydecimal?No
QuantityThisDelGreaterThanquerydecimal?No
QuantityThisDelLessThanquerydecimal?No
QuantityThisDelLessThanOrEqualToquerydecimal?No
QuantityThisDelNotEqualToquerydecimal?No
QuantityThisDelBetweenqueryNullable<Decimal>[]No
QuantityThisDelInqueryNullable<Decimal>[]No
QuantityBackOrdquerydecimal?No
QuantityBackOrdGreaterThanOrEqualToquerydecimal?No
QuantityBackOrdGreaterThanquerydecimal?No
QuantityBackOrdLessThanquerydecimal?No
QuantityBackOrdLessThanOrEqualToquerydecimal?No
QuantityBackOrdNotEqualToquerydecimal?No
QuantityBackOrdBetweenqueryNullable<Decimal>[]No
QuantityBackOrdInqueryNullable<Decimal>[]No
HistoryText_CommentquerystringNo
HistoryText_CommentStartsWithquerystringNo
HistoryText_CommentEndsWithquerystringNo
HistoryText_CommentContainsquerystringNo
HistoryText_CommentLikequerystringNo
HistoryText_CommentBetweenquerystring[]No
HistoryText_CommentInquerystring[]No
Discountablequerybool?No
TaxIncquerybool?No
DirectTaxquerydecimal?No
DirectTaxGreaterThanOrEqualToquerydecimal?No
DirectTaxGreaterThanquerydecimal?No
DirectTaxLessThanquerydecimal?No
DirectTaxLessThanOrEqualToquerydecimal?No
DirectTaxNotEqualToquerydecimal?No
DirectTaxBetweenqueryNullable<Decimal>[]No
DirectTaxInqueryNullable<Decimal>[]No
DecimalPlacesqueryshort?No
DecimalPlacesGreaterThanOrEqualToqueryshort?No
DecimalPlacesGreaterThanqueryshort?No
DecimalPlacesLessThanqueryshort?No
DecimalPlacesLessThanOrEqualToqueryshort?No
DecimalPlacesNotEqualToqueryshort?No
DecimalPlacesBetweenqueryNullable<Int16>[]No
DecimalPlacesInqueryNullable<Int16>[]No
MinimumGPquerydecimal?No
MinimumGPGreaterThanOrEqualToquerydecimal?No
MinimumGPGreaterThanquerydecimal?No
MinimumGPLessThanquerydecimal?No
MinimumGPLessThanOrEqualToquerydecimal?No
MinimumGPNotEqualToquerydecimal?No
MinimumGPBetweenqueryNullable<Decimal>[]No
MinimumGPInqueryNullable<Decimal>[]No
DebitLedgerquerystringNo
DebitLedgerStartsWithquerystringNo
DebitLedgerEndsWithquerystringNo
DebitLedgerContainsquerystringNo
DebitLedgerLikequerystringNo
DebitLedgerBetweenquerystring[]No
DebitLedgerInquerystring[]No
CreditLedgerquerystringNo
CreditLedgerStartsWithquerystringNo
CreditLedgerEndsWithquerystringNo
CreditLedgerContainsquerystringNo
CreditLedgerLikequerystringNo
CreditLedgerBetweenquerystring[]No
CreditLedgerInquerystring[]No
NonStockquerybool?No
InventoryIDquerystringNo
InventoryIDStartsWithquerystringNo
InventoryIDEndsWithquerystringNo
InventoryIDContainsquerystringNo
InventoryIDLikequerystringNo
InventoryIDBetweenquerystring[]No
InventoryIDInquerystring[]No
UseSerialNoquerybool?No
Backorderablequerybool?No
Pickedquerybool?No
TaxPaidquerydecimal?No
TaxPaidGreaterThanOrEqualToquerydecimal?No
TaxPaidGreaterThanquerydecimal?No
TaxPaidLessThanquerydecimal?No
TaxPaidLessThanOrEqualToquerydecimal?No
TaxPaidNotEqualToquerydecimal?No
TaxPaidBetweenqueryNullable<Decimal>[]No
TaxPaidInqueryNullable<Decimal>[]No
TaxRatequerydecimal?No
TaxRateGreaterThanOrEqualToquerydecimal?No
TaxRateGreaterThanquerydecimal?No
TaxRateLessThanquerydecimal?No
TaxRateLessThanOrEqualToquerydecimal?No
TaxRateNotEqualToquerydecimal?No
TaxRateBetweenqueryNullable<Decimal>[]No
TaxRateInqueryNullable<Decimal>[]No
UsingSpecialPricequerybool?No
EstBOValuequerydecimal?No
EstBOValueGreaterThanOrEqualToquerydecimal?No
EstBOValueGreaterThanquerydecimal?No
EstBOValueLessThanquerydecimal?No
EstBOValueLessThanOrEqualToquerydecimal?No
EstBOValueNotEqualToquerydecimal?No
EstBOValueBetweenqueryNullable<Decimal>[]No
EstBOValueInqueryNullable<Decimal>[]No
ItemTaxToChargequerydecimal?No
ItemTaxToChargeGreaterThanOrEqualToquerydecimal?No
ItemTaxToChargeGreaterThanquerydecimal?No
ItemTaxToChargeLessThanquerydecimal?No
ItemTaxToChargeLessThanOrEqualToquerydecimal?No
ItemTaxToChargeNotEqualToquerydecimal?No
ItemTaxToChargeBetweenqueryNullable<Decimal>[]No
ItemTaxToChargeInqueryNullable<Decimal>[]No
ItemTaxToPayquerydecimal?No
ItemTaxToPayGreaterThanOrEqualToquerydecimal?No
ItemTaxToPayGreaterThanquerydecimal?No
ItemTaxToPayLessThanquerydecimal?No
ItemTaxToPayLessThanOrEqualToquerydecimal?No
ItemTaxToPayNotEqualToquerydecimal?No
ItemTaxToPayBetweenqueryNullable<Decimal>[]No
ItemTaxToPayInqueryNullable<Decimal>[]No
LineLinkIDquerystringNo
LineLinkIDStartsWithquerystringNo
LineLinkIDEndsWithquerystringNo
LineLinkIDContainsquerystringNo
LineLinkIDLikequerystringNo
LineLinkIDBetweenquerystring[]No
LineLinkIDInquerystring[]No
KittingStatusqueryshort?No
KittingStatusGreaterThanOrEqualToqueryshort?No
KittingStatusGreaterThanqueryshort?No
KittingStatusLessThanqueryshort?No
KittingStatusLessThanOrEqualToqueryshort?No
KittingStatusNotEqualToqueryshort?No
KittingStatusBetweenqueryshort[]No
KittingStatusInqueryshort[]No
KittingUnitsquerydecimal?No
KittingUnitsGreaterThanOrEqualToquerydecimal?No
KittingUnitsGreaterThanquerydecimal?No
KittingUnitsLessThanquerydecimal?No
KittingUnitsLessThanOrEqualToquerydecimal?No
KittingUnitsNotEqualToquerydecimal?No
KittingUnitsBetweenqueryNullable<Decimal>[]No
KittingUnitsInqueryNullable<Decimal>[]No
JobConnectorIDquerystringNo
JobConnectorIDStartsWithquerystringNo
JobConnectorIDEndsWithquerystringNo
JobConnectorIDContainsquerystringNo
JobConnectorIDLikequerystringNo
JobConnectorIDBetweenquerystring[]No
JobConnectorIDInquerystring[]No
KitStylequeryshort?No
KitStyleGreaterThanOrEqualToqueryshort?No
KitStyleGreaterThanqueryshort?No
KitStyleLessThanqueryshort?No
KitStyleLessThanOrEqualToqueryshort?No
KitStyleNotEqualToqueryshort?No
KitStyleBetweenqueryNullable<Int16>[]No
KitStyleInqueryNullable<Int16>[]No
DiscountPercentagequerydecimal?No
DiscountPercentageGreaterThanOrEqualToquerydecimal?No
DiscountPercentageGreaterThanquerydecimal?No
DiscountPercentageLessThanquerydecimal?No
DiscountPercentageLessThanOrEqualToquerydecimal?No
DiscountPercentageNotEqualToquerydecimal?No
DiscountPercentageBetweenqueryNullable<Decimal>[]No
DiscountPercentageInqueryNullable<Decimal>[]No
SalesmanCostquerydecimal?No
SalesmanCostGreaterThanOrEqualToquerydecimal?No
SalesmanCostGreaterThanquerydecimal?No
SalesmanCostLessThanquerydecimal?No
SalesmanCostLessThanOrEqualToquerydecimal?No
SalesmanCostNotEqualToquerydecimal?No
SalesmanCostBetweenqueryNullable<Decimal>[]No
SalesmanCostInqueryNullable<Decimal>[]No
LineCostquerydecimal?No
LineCostGreaterThanOrEqualToquerydecimal?No
LineCostGreaterThanquerydecimal?No
LineCostLessThanquerydecimal?No
LineCostLessThanOrEqualToquerydecimal?No
LineCostNotEqualToquerydecimal?No
LineCostBetweenqueryNullable<Decimal>[]No
LineCostInqueryNullable<Decimal>[]No
OrigInvoiceNoquerystringNo
OrigInvoiceNoStartsWithquerystringNo
OrigInvoiceNoEndsWithquerystringNo
OrigInvoiceNoContainsquerystringNo
OrigInvoiceNoLikequerystringNo
OrigInvoiceNoBetweenquerystring[]No
OrigInvoiceNoInquerystring[]No
ItemPriceIncGSTquerydecimal?No
ItemPriceIncGSTGreaterThanOrEqualToquerydecimal?No
ItemPriceIncGSTGreaterThanquerydecimal?No
ItemPriceIncGSTLessThanquerydecimal?No
ItemPriceIncGSTLessThanOrEqualToquerydecimal?No
ItemPriceIncGSTNotEqualToquerydecimal?No
ItemPriceIncGSTBetweenqueryNullable<Decimal>[]No
ItemPriceIncGSTInqueryNullable<Decimal>[]No
ItemPriceUnDiscountedquerydecimal?No
ItemPriceUnDiscountedGreaterThanOrEqualToquerydecimal?No
ItemPriceUnDiscountedGreaterThanquerydecimal?No
ItemPriceUnDiscountedLessThanquerydecimal?No
ItemPriceUnDiscountedLessThanOrEqualToquerydecimal?No
ItemPriceUnDiscountedNotEqualToquerydecimal?No
ItemPriceUnDiscountedBetweenqueryNullable<Decimal>[]No
ItemPriceUnDiscountedInqueryNullable<Decimal>[]No
DemandQuantityquerydecimal?No
DemandQuantityGreaterThanOrEqualToquerydecimal?No
DemandQuantityGreaterThanquerydecimal?No
DemandQuantityLessThanquerydecimal?No
DemandQuantityLessThanOrEqualToquerydecimal?No
DemandQuantityNotEqualToquerydecimal?No
DemandQuantityBetweenqueryNullable<Decimal>[]No
DemandQuantityInqueryNullable<Decimal>[]No
NonStockLedgerSalesAccIDquerystringNo
NonStockLedgerSalesAccIDStartsWithquerystringNo
NonStockLedgerSalesAccIDEndsWithquerystringNo
NonStockLedgerSalesAccIDContainsquerystringNo
NonStockLedgerSalesAccIDLikequerystringNo
NonStockLedgerSalesAccIDBetweenquerystring[]No
NonStockLedgerSalesAccIDInquerystring[]No
KitLineIDquerystringNo
KitLineIDStartsWithquerystringNo
KitLineIDEndsWithquerystringNo
KitLineIDContainsquerystringNo
KitLineIDLikequerystringNo
KitLineIDBetweenquerystring[]No
KitLineIDInquerystring[]No
JobCostNoquerystringNo
JobCostNoStartsWithquerystringNo
JobCostNoEndsWithquerystringNo
JobCostNoContainsquerystringNo
JobCostNoLikequerystringNo
JobCostNoBetweenquerystring[]No
JobCostNoInquerystring[]No
SellPriceIncTaxquerybool?No
JobInvoiceItemqueryshort?No
JobInvoiceItemGreaterThanOrEqualToqueryshort?No
JobInvoiceItemGreaterThanqueryshort?No
JobInvoiceItemLessThanqueryshort?No
JobInvoiceItemLessThanOrEqualToqueryshort?No
JobInvoiceItemNotEqualToqueryshort?No
JobInvoiceItemBetweenqueryNullable<Int16>[]No
JobInvoiceItemInqueryNullable<Int16>[]No
QuantityPrevDemandquerydecimal?No
QuantityPrevDemandGreaterThanOrEqualToquerydecimal?No
QuantityPrevDemandGreaterThanquerydecimal?No
QuantityPrevDemandLessThanquerydecimal?No
QuantityPrevDemandLessThanOrEqualToquerydecimal?No
QuantityPrevDemandNotEqualToquerydecimal?No
QuantityPrevDemandBetweenqueryNullable<Decimal>[]No
QuantityPrevDemandInqueryNullable<Decimal>[]No
JobIDquerystringNo
JobIDStartsWithquerystringNo
JobIDEndsWithquerystringNo
JobIDContainsquerystringNo
JobIDLikequerystringNo
JobIDBetweenquerystring[]No
JobIDInquerystring[]No
CostCentreIDquerystringNo
CostCentreIDStartsWithquerystringNo
CostCentreIDEndsWithquerystringNo
CostCentreIDContainsquerystringNo
CostCentreIDLikequerystringNo
CostCentreIDBetweenquerystring[]No
CostCentreIDInquerystring[]No
StageIDquerystringNo
StageIDStartsWithquerystringNo
StageIDEndsWithquerystringNo
StageIDContainsquerystringNo
StageIDLikequerystringNo
StageIDBetweenquerystring[]No
StageIDInquerystring[]No
UserDefinedFloat1querydecimal?No
UserDefinedFloat1GreaterThanOrEqualToquerydecimal?No
UserDefinedFloat1GreaterThanquerydecimal?No
UserDefinedFloat1LessThanquerydecimal?No
UserDefinedFloat1LessThanOrEqualToquerydecimal?No
UserDefinedFloat1NotEqualToquerydecimal?No
UserDefinedFloat1BetweenqueryNullable<Decimal>[]No
UserDefinedFloat1InqueryNullable<Decimal>[]No
UserDefinedFloat2querydecimal?No
UserDefinedFloat2GreaterThanOrEqualToquerydecimal?No
UserDefinedFloat2GreaterThanquerydecimal?No
UserDefinedFloat2LessThanquerydecimal?No
UserDefinedFloat2LessThanOrEqualToquerydecimal?No
UserDefinedFloat2NotEqualToquerydecimal?No
UserDefinedFloat2BetweenqueryNullable<Decimal>[]No
UserDefinedFloat2InqueryNullable<Decimal>[]No
UserDefinedFloat3querydecimal?No
UserDefinedFloat3GreaterThanOrEqualToquerydecimal?No
UserDefinedFloat3GreaterThanquerydecimal?No
UserDefinedFloat3LessThanquerydecimal?No
UserDefinedFloat3LessThanOrEqualToquerydecimal?No
UserDefinedFloat3NotEqualToquerydecimal?No
UserDefinedFloat3BetweenqueryNullable<Decimal>[]No
UserDefinedFloat3InqueryNullable<Decimal>[]No
ForwardOrderDatequeryDateTime?No
ForwardOrderDateGreaterThanOrEqualToqueryDateTime?No
ForwardOrderDateGreaterThanqueryDateTime?No
ForwardOrderDateLessThanqueryDateTime?No
ForwardOrderDateLessThanOrEqualToqueryDateTime?No
ForwardOrderDateNotEqualToqueryDateTime?No
ForwardOrderDateBetweenqueryNullable<DateTime>[]No
ForwardOrderDateInqueryNullable<DateTime>[]No
ScheduledDatequeryDateTime?No
ScheduledDateGreaterThanOrEqualToqueryDateTime?No
ScheduledDateGreaterThanqueryDateTime?No
ScheduledDateLessThanqueryDateTime?No
ScheduledDateLessThanOrEqualToqueryDateTime?No
ScheduledDateNotEqualToqueryDateTime?No
ScheduledDateBetweenqueryNullable<DateTime>[]No
ScheduledDateInqueryNullable<DateTime>[]No
DeliverStockquerybool?No
FixSellPricequerybool?No
TypeKitRoundingquerybool?No
EDIStoreLocationCodequerystringNo
EDIStoreLocationCodeStartsWithquerystringNo
EDIStoreLocationCodeEndsWithquerystringNo
EDIStoreLocationCodeContainsquerystringNo
EDIStoreLocationCodeLikequerystringNo
EDIStoreLocationCodeBetweenquerystring[]No
EDIStoreLocationCodeInquerystring[]No
EDIDCLocationCodequerystringNo
EDIDCLocationCodeStartsWithquerystringNo
EDIDCLocationCodeEndsWithquerystringNo
EDIDCLocationCodeContainsquerystringNo
EDIDCLocationCodeLikequerystringNo
EDIDCLocationCodeBetweenquerystring[]No
EDIDCLocationCodeInquerystring[]No
SM_Parts_RecIDquerystringNo
SM_Parts_RecIDStartsWithquerystringNo
SM_Parts_RecIDEndsWithquerystringNo
SM_Parts_RecIDContainsquerystringNo
SM_Parts_RecIDLikequerystringNo
SM_Parts_RecIDBetweenquerystring[]No
SM_Parts_RecIDInquerystring[]No
SM_Labour_RecIDquerystringNo
SM_Labour_RecIDStartsWithquerystringNo
SM_Labour_RecIDEndsWithquerystringNo
SM_Labour_RecIDContainsquerystringNo
SM_Labour_RecIDLikequerystringNo
SM_Labour_RecIDBetweenquerystring[]No
SM_Labour_RecIDInquerystring[]No
IN_UnitOfMeasure_RecIDqueryGuid?No
IN_UnitOfMeasure_RecIDInqueryNullable<Guid>[]No
QueryBase Parameters:
NameParameterData TypeRequiredDescription
Skipformint?No
Takeformint?No
OrderByformstringNo
OrderByDescformstringNo
IncludeformstringNo
FieldsformstringNo
MetaformDictionary<string, string>No
SO_Lines Parameters:
NameParameterData TypeRequiredDescription
InvoiceLineIDformstringNo
InvoiceHistoryIDformstringNo
GroupNoformshort?No
LineNumformshort?No
CommentLineformbool?No
PartNoformstringNo
DescriptionformstringNo
PhysicalItemformshort?No
ItemWeightformdecimal?No
ItemCubicformdecimal?No
TaxIDformstringNo
ClassDescriptionformstringNo
Cat1DescriptionformstringNo
Cat2DescriptionformstringNo
Cat3DescriptionformstringNo
UnitsformstringNo
CostInformdecimal?No
DefaultPriceformdecimal?No
ItemPriceformdecimal?No
Discountformdecimal?No
InvoicePriceformdecimal?No
RRPPriceformdecimal?No
TaxToChargeformdecimal?No
TaxToPayformdecimal?No
CurrentLineTotalformdecimal?No
QuantityOrderedformdecimal?No
QuantityPrevDelformdecimal?No
QuantityThisDelformdecimal?No
QuantityBackOrdformdecimal?No
HistoryText_CommentformstringNo
Discountableformbool?No
TaxIncformbool?No
DirectTaxformdecimal?No
DecimalPlacesformshort?No
MinimumGPformdecimal?No
DebitLedgerformstringNo
CreditLedgerformstringNo
NonStockformbool?No
InventoryIDformstringNo
UseSerialNoformbool?No
Backorderableformbool?No
Pickedformbool?No
TaxPaidformdecimal?No
TaxRateformdecimal?No
UsingSpecialPriceformbool?No
EstBOValueformdecimal?No
ItemTaxToChargeformdecimal?No
ItemTaxToPayformdecimal?No
LineLinkIDformstringNo
KittingStatusformshortNo
KittingUnitsformdecimal?No
JobConnectorIDformstringNo
KitStyleformshort?No
DiscountPercentageformdecimal?No
SalesmanCostformdecimal?No
LineCostformdecimal?No
OrigInvoiceNoformstringNo
ItemPriceIncGSTformdecimal?No
ItemPriceUnDiscountedformdecimal?No
DemandQuantityformdecimal?No
NonStockLedgerSalesAccIDformstringNo
KitLineIDformstringNo
JobCostNoformstringNo
SellPriceIncTaxformboolNo
JobInvoiceItemformshort?No
QuantityPrevDemandformdecimal?No
JobIDformstringNo
CostCentreIDformstringNo
StageIDformstringNo
UserDefinedFloat1formdecimal?No
UserDefinedFloat2formdecimal?No
UserDefinedFloat3formdecimal?No
ForwardOrderDateformDateTime?No
ScheduledDateformDateTime?No
DeliverStockformboolNo
FixSellPriceformboolNo
TypeKitRoundingformbool?No
EDIStoreLocationCodeformstringNo
EDIDCLocationCodeformstringNo
SM_Parts_RecIDformstringNo
SM_Labour_RecIDformstringNo
IN_UnitOfMeasure_RecIDformGuid?No
QueryResponse<T> Parameters:
NameParameterData TypeRequiredDescription
OffsetformintNo
TotalformintNo
ResultsformList<T>No
MetaformDictionary<string, string>No
ResponseStatusformResponseStatusNo

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