JiwaAPI

SO_VInvQuery

**SO_VInvQuery** Parameters:
Name	Parameter	Data Type	Required
InvoiceID	query	string	No
InvoiceIDStartsWith	query	string	No
InvoiceIDEndsWith	query	string	No
InvoiceIDContains	query	string	No
InvoiceIDLike	query	string	No
InvoiceIDBetween	query	string[]	No
InvoiceIDIn	query	string[]	No
InvID	query	string	No
InvIDStartsWith	query	string	No
InvIDEndsWith	query	string	No
InvIDContains	query	string	No
InvIDLike	query	string	No
InvIDBetween	query	string[]	No
InvIDIn	query	string[]	No
InvoiceNo	query	string	No
InvoiceNoStartsWith	query	string	No
InvoiceNoEndsWith	query	string	No
InvoiceNoContains	query	string	No
InvoiceNoLike	query	string	No
InvoiceNoBetween	query	string[]	No
InvoiceNoIn	query	string[]	No
IN_LogicalID	query	string	No
IN_LogicalIDStartsWith	query	string	No
IN_LogicalIDEndsWith	query	string	No
IN_LogicalIDContains	query	string	No
IN_LogicalIDLike	query	string	No
IN_LogicalIDBetween	query	string[]	No
IN_LogicalIDIn	query	string[]	No
BillWhenComplete	query	short?	No
BillWhenCompleteGreaterThanOrEqualTo	query	short?	No
BillWhenCompleteGreaterThan	query	short?	No
BillWhenCompleteLessThan	query	short?	No
BillWhenCompleteLessThanOrEqualTo	query	short?	No
BillWhenCompleteNotEqualTo	query	short?	No
BillWhenCompleteBetween	query	short[]	No
BillWhenCompleteIn	query	short[]	No
OrderNo	query	string	No
OrderNoStartsWith	query	string	No
OrderNoEndsWith	query	string	No
OrderNoContains	query	string	No
OrderNoLike	query	string	No
OrderNoBetween	query	string[]	No
OrderNoIn	query	string[]	No
CreditNote	query	bool?	No
WholeSaleInvoice	query	bool?	No
TaxExemptNo	query	string	No
TaxExemptNoStartsWith	query	string	No
TaxExemptNoEndsWith	query	string	No
TaxExemptNoContains	query	string	No
TaxExemptNoLike	query	string	No
TaxExemptNoBetween	query	string[]	No
TaxExemptNoIn	query	string[]	No
Status	query	short?	No
StatusGreaterThanOrEqualTo	query	short?	No
StatusGreaterThan	query	short?	No
StatusLessThan	query	short?	No
StatusLessThanOrEqualTo	query	short?	No
StatusNotEqualTo	query	short?	No
StatusBetween	query	Nullable<Int16>[]	No
StatusIn	query	Nullable<Int16>[]	No
StaffID	query	string	No
StaffIDStartsWith	query	string	No
StaffIDEndsWith	query	string	No
StaffIDContains	query	string	No
StaffIDLike	query	string	No
StaffIDBetween	query	string[]	No
StaffIDIn	query	string[]	No
BranchID	query	string	No
BranchIDStartsWith	query	string	No
BranchIDEndsWith	query	string	No
BranchIDContains	query	string	No
BranchIDLike	query	string	No
BranchIDBetween	query	string[]	No
BranchIDIn	query	string[]	No
CreditIntoStock	query	bool?	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
HistoryTotal	query	decimal?	No
HistoryTotalGreaterThanOrEqualTo	query	decimal?	No
HistoryTotalGreaterThan	query	decimal?	No
HistoryTotalLessThan	query	decimal?	No
HistoryTotalLessThanOrEqualTo	query	decimal?	No
HistoryTotalNotEqualTo	query	decimal?	No
HistoryTotalBetween	query	Nullable<Decimal>[]	No
HistoryTotalIn	query	Nullable<Decimal>[]	No
CartageCharge1	query	decimal?	No
CartageCharge1GreaterThanOrEqualTo	query	decimal?	No
CartageCharge1GreaterThan	query	decimal?	No
CartageCharge1LessThan	query	decimal?	No
CartageCharge1LessThanOrEqualTo	query	decimal?	No
CartageCharge1NotEqualTo	query	decimal?	No
CartageCharge1Between	query	Nullable<Decimal>[]	No
CartageCharge1In	query	Nullable<Decimal>[]	No
CartageCharge2	query	decimal?	No
CartageCharge2GreaterThanOrEqualTo	query	decimal?	No
CartageCharge2GreaterThan	query	decimal?	No
CartageCharge2LessThan	query	decimal?	No
CartageCharge2LessThanOrEqualTo	query	decimal?	No
CartageCharge2NotEqualTo	query	decimal?	No
CartageCharge2Between	query	Nullable<Decimal>[]	No
CartageCharge2In	query	Nullable<Decimal>[]	No
CartageCharge3	query	decimal?	No
CartageCharge3GreaterThanOrEqualTo	query	decimal?	No
CartageCharge3GreaterThan	query	decimal?	No
CartageCharge3LessThan	query	decimal?	No
CartageCharge3LessThanOrEqualTo	query	decimal?	No
CartageCharge3NotEqualTo	query	decimal?	No
CartageCharge3Between	query	Nullable<Decimal>[]	No
CartageCharge3In	query	Nullable<Decimal>[]	No
Frieght	query	decimal?	No
FrieghtGreaterThanOrEqualTo	query	decimal?	No
FrieghtGreaterThan	query	decimal?	No
FrieghtLessThan	query	decimal?	No
FrieghtLessThanOrEqualTo	query	decimal?	No
FrieghtNotEqualTo	query	decimal?	No
FrieghtBetween	query	Nullable<Decimal>[]	No
FrieghtIn	query	Nullable<Decimal>[]	No
Frt	query	decimal?	No
FrtGreaterThanOrEqualTo	query	decimal?	No
FrtGreaterThan	query	decimal?	No
FrtLessThan	query	decimal?	No
FrtLessThanOrEqualTo	query	decimal?	No
FrtNotEqualTo	query	decimal?	No
FrtBetween	query	Nullable<Decimal>[]	No
FrtIn	query	Nullable<Decimal>[]	No
FrtTax	query	decimal?	No
FrtTaxGreaterThanOrEqualTo	query	decimal?	No
FrtTaxGreaterThan	query	decimal?	No
FrtTaxLessThan	query	decimal?	No
FrtTaxLessThanOrEqualTo	query	decimal?	No
FrtTaxNotEqualTo	query	decimal?	No
FrtTaxBetween	query	Nullable<Decimal>[]	No
FrtTaxIn	query	Nullable<Decimal>[]	No
ProHistoryNo	query	short?	No
ProHistoryNoGreaterThanOrEqualTo	query	short?	No
ProHistoryNoGreaterThan	query	short?	No
ProHistoryNoLessThan	query	short?	No
ProHistoryNoLessThanOrEqualTo	query	short?	No
ProHistoryNoNotEqualTo	query	short?	No
ProHistoryNoBetween	query	Nullable<Int16>[]	No
ProHistoryNoIn	query	Nullable<Int16>[]	No
InvHistoryNo	query	short?	No
InvHistoryNoGreaterThanOrEqualTo	query	short?	No
InvHistoryNoGreaterThan	query	short?	No
InvHistoryNoLessThan	query	short?	No
InvHistoryNoLessThanOrEqualTo	query	short?	No
InvHistoryNoNotEqualTo	query	short?	No
InvHistoryNoBetween	query	Nullable<Int16>[]	No
InvHistoryNoIn	query	Nullable<Int16>[]	No
ProRunNo	query	string	No
ProRunNoStartsWith	query	string	No
ProRunNoEndsWith	query	string	No
ProRunNoContains	query	string	No
ProRunNoLike	query	string	No
ProRunNoBetween	query	string[]	No
ProRunNoIn	query	string[]	No
InvRunNo	query	string	No
InvRunNoStartsWith	query	string	No
InvRunNoEndsWith	query	string	No
InvRunNoContains	query	string	No
InvRunNoLike	query	string	No
InvRunNoBetween	query	string[]	No
InvRunNoIn	query	string[]	No
ProDate	query	DateTime?	No
ProDateGreaterThanOrEqualTo	query	DateTime?	No
ProDateGreaterThan	query	DateTime?	No
ProDateLessThan	query	DateTime?	No
ProDateLessThanOrEqualTo	query	DateTime?	No
ProDateNotEqualTo	query	DateTime?	No
ProDateBetween	query	Nullable<DateTime>[]	No
ProDateIn	query	Nullable<DateTime>[]	No
InvDate	query	DateTime?	No
InvDateGreaterThanOrEqualTo	query	DateTime?	No
InvDateGreaterThan	query	DateTime?	No
InvDateLessThan	query	DateTime?	No
InvDateLessThanOrEqualTo	query	DateTime?	No
InvDateNotEqualTo	query	DateTime?	No
InvDateBetween	query	Nullable<DateTime>[]	No
InvDateIn	query	Nullable<DateTime>[]	No
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
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
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
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
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
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
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
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
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
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
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
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
NonStock	query	bool?	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
DebtorID	query	string	No
DebtorIDStartsWith	query	string	No
DebtorIDEndsWith	query	string	No
DebtorIDContains	query	string	No
DebtorIDLike	query	string	No
DebtorIDBetween	query	string[]	No
DebtorIDIn	query	string[]	No
AccountNo	query	string	No
AccountNoStartsWith	query	string	No
AccountNoEndsWith	query	string	No
AccountNoContains	query	string	No
AccountNoLike	query	string	No
AccountNoBetween	query	string[]	No
AccountNoIn	query	string[]	No
Name	query	string	No
NameStartsWith	query	string	No
NameEndsWith	query	string	No
NameContains	query	string	No
NameLike	query	string	No
NameBetween	query	string[]	No
NameIn	query	string[]	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
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

**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_VInv** Parameters:
Name	Parameter	Data Type	Required
InvoiceID	form	string	No
InvID	form	string	No
InvoiceNo	form	string	No
IN_LogicalID	form	string	No
BillWhenComplete	form	short	No
OrderNo	form	string	No
CreditNote	form	bool	No
WholeSaleInvoice	form	bool	No
TaxExemptNo	form	string	No
Status	form	short?	No
StaffID	form	string	No
BranchID	form	string	No
CreditIntoStock	form	bool	No
InvoiceHistoryID	form	string	No
HistoryTotal	form	decimal?	No
CartageCharge1	form	decimal?	No
CartageCharge2	form	decimal?	No
CartageCharge3	form	decimal?	No
Frieght	form	decimal?	No
Frt	form	decimal?	No
FrtTax	form	decimal?	No
ProHistoryNo	form	short?	No
InvHistoryNo	form	short?	No
ProRunNo	form	string	No
InvRunNo	form	string	No
ProDate	form	DateTime?	No
InvDate	form	DateTime?	No
InvoiceLineID	form	string	No
InventoryID	form	string	No
PartNo	form	string	No
Description	form	string	No
JobID	form	string	No
CostIn	form	decimal?	No
QuantityThisDel	form	decimal?	No
CurrentLineTotal	form	decimal?	No
TaxToCharge	form	decimal?	No
TaxPaid	form	decimal?	No
DecimalPlaces	form	short?	No
TaxID	form	string	No
PhysicalItem	form	short?	No
NonStock	form	bool?	No
ClassDescription	form	string	No
DebtorID	form	string	No
AccountNo	form	string	No
Name	form	string	No
LineCost	form	decimal?	No
Cat1Description	form	string	No
Cat2Description	form	string	No
Cat3Description	form	string	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_VInvQuery HTTP/1.1 
Host: localhost 
Accept: text/csv
Content-Type: text/csv
Content-Length: length

{"InvoiceID":"String","InvoiceIDStartsWith":"String","InvoiceIDEndsWith":"String","InvoiceIDContains":"String","InvoiceIDLike":"String","InvoiceIDBetween":["String"],"InvoiceIDIn":["String"],"InvID":"String","InvIDStartsWith":"String","InvIDEndsWith":"String","InvIDContains":"String","InvIDLike":"String","InvIDBetween":["String"],"InvIDIn":["String"],"InvoiceNo":"String","InvoiceNoStartsWith":"String","InvoiceNoEndsWith":"String","InvoiceNoContains":"String","InvoiceNoLike":"String","InvoiceNoBetween":["String"],"InvoiceNoIn":["String"],"IN_LogicalID":"String","IN_LogicalIDStartsWith":"String","IN_LogicalIDEndsWith":"String","IN_LogicalIDContains":"String","IN_LogicalIDLike":"String","IN_LogicalIDBetween":["String"],"IN_LogicalIDIn":["String"],"BillWhenComplete":0,"BillWhenCompleteGreaterThanOrEqualTo":0,"BillWhenCompleteGreaterThan":0,"BillWhenCompleteLessThan":0,"BillWhenCompleteLessThanOrEqualTo":0,"BillWhenCompleteNotEqualTo":0,"BillWhenCompleteBetween":[0],"BillWhenCompleteIn":[0],"OrderNo":"String","OrderNoStartsWith":"String","OrderNoEndsWith":"String","OrderNoContains":"String","OrderNoLike":"String","OrderNoBetween":["String"],"OrderNoIn":["String"],"CreditNote":false,"WholeSaleInvoice":false,"TaxExemptNo":"String","TaxExemptNoStartsWith":"String","TaxExemptNoEndsWith":"String","TaxExemptNoContains":"String","TaxExemptNoLike":"String","TaxExemptNoBetween":["String"],"TaxExemptNoIn":["String"],"Status":0,"StatusGreaterThanOrEqualTo":0,"StatusGreaterThan":0,"StatusLessThan":0,"StatusLessThanOrEqualTo":0,"StatusNotEqualTo":0,"StatusBetween":[0],"StatusIn":[0],"StaffID":"String","StaffIDStartsWith":"String","StaffIDEndsWith":"String","StaffIDContains":"String","StaffIDLike":"String","StaffIDBetween":["String"],"StaffIDIn":["String"],"BranchID":"String","BranchIDStartsWith":"String","BranchIDEndsWith":"String","BranchIDContains":"String","BranchIDLike":"String","BranchIDBetween":["String"],"BranchIDIn":["String"],"CreditIntoStock":false,"InvoiceHistoryID":"String","InvoiceHistoryIDStartsWith":"String","InvoiceHistoryIDEndsWith":"String","InvoiceHistoryIDContains":"String","InvoiceHistoryIDLike":"String","InvoiceHistoryIDBetween":["String"],"InvoiceHistoryIDIn":["String"],"HistoryTotal":0,"HistoryTotalGreaterThanOrEqualTo":0,"HistoryTotalGreaterThan":0,"HistoryTotalLessThan":0,"HistoryTotalLessThanOrEqualTo":0,"HistoryTotalNotEqualTo":0,"HistoryTotalBetween":[0],"HistoryTotalIn":[0],"CartageCharge1":0,"CartageCharge1GreaterThanOrEqualTo":0,"CartageCharge1GreaterThan":0,"CartageCharge1LessThan":0,"CartageCharge1LessThanOrEqualTo":0,"CartageCharge1NotEqualTo":0,"CartageCharge1Between":[0],"CartageCharge1In":[0],"CartageCharge2":0,"CartageCharge2GreaterThanOrEqualTo":0,"CartageCharge2GreaterThan":0,"CartageCharge2LessThan":0,"CartageCharge2LessThanOrEqualTo":0,"CartageCharge2NotEqualTo":0,"CartageCharge2Between":[0],"CartageCharge2In":[0],"CartageCharge3":0,"CartageCharge3GreaterThanOrEqualTo":0,"CartageCharge3GreaterThan":0,"CartageCharge3LessThan":0,"CartageCharge3LessThanOrEqualTo":0,"CartageCharge3NotEqualTo":0,"CartageCharge3Between":[0],"CartageCharge3In":[0],"Frieght":0,"FrieghtGreaterThanOrEqualTo":0,"FrieghtGreaterThan":0,"FrieghtLessThan":0,"FrieghtLessThanOrEqualTo":0,"FrieghtNotEqualTo":0,"FrieghtBetween":[0],"FrieghtIn":[0],"Frt":0,"FrtGreaterThanOrEqualTo":0,"FrtGreaterThan":0,"FrtLessThan":0,"FrtLessThanOrEqualTo":0,"FrtNotEqualTo":0,"FrtBetween":[0],"FrtIn":[0],"FrtTax":0,"FrtTaxGreaterThanOrEqualTo":0,"FrtTaxGreaterThan":0,"FrtTaxLessThan":0,"FrtTaxLessThanOrEqualTo":0,"FrtTaxNotEqualTo":0,"FrtTaxBetween":[0],"FrtTaxIn":[0],"ProHistoryNo":0,"ProHistoryNoGreaterThanOrEqualTo":0,"ProHistoryNoGreaterThan":0,"ProHistoryNoLessThan":0,"ProHistoryNoLessThanOrEqualTo":0,"ProHistoryNoNotEqualTo":0,"ProHistoryNoBetween":[0],"ProHistoryNoIn":[0],"InvHistoryNo":0,"InvHistoryNoGreaterThanOrEqualTo":0,"InvHistoryNoGreaterThan":0,"InvHistoryNoLessThan":0,"InvHistoryNoLessThanOrEqualTo":0,"InvHistoryNoNotEqualTo":0,"InvHistoryNoBetween":[0],"InvHistoryNoIn":[0],"ProRunNo":"String","ProRunNoStartsWith":"String","ProRunNoEndsWith":"String","ProRunNoContains":"String","ProRunNoLike":"String","ProRunNoBetween":["String"],"ProRunNoIn":["String"],"InvRunNo":"String","InvRunNoStartsWith":"String","InvRunNoEndsWith":"String","InvRunNoContains":"String","InvRunNoLike":"String","InvRunNoBetween":["String"],"InvRunNoIn":["String"],"ProDate":"0001-01-01T00:00:00.0000000","ProDateGreaterThanOrEqualTo":"0001-01-01T00:00:00.0000000","ProDateGreaterThan":"0001-01-01T00:00:00.0000000","ProDateLessThan":"0001-01-01T00:00:00.0000000","ProDateLessThanOrEqualTo":"0001-01-01T00:00:00.0000000","ProDateNotEqualTo":"0001-01-01T00:00:00.0000000","ProDateBetween":["0001-01-01T00:00:00.0000000"],"ProDateIn":["0001-01-01T00:00:00.0000000"],"InvDate":"0001-01-01T00:00:00.0000000","InvDateGreaterThanOrEqualTo":"0001-01-01T00:00:00.0000000","InvDateGreaterThan":"0001-01-01T00:00:00.0000000","InvDateLessThan":"0001-01-01T00:00:00.0000000","InvDateLessThanOrEqualTo":"0001-01-01T00:00:00.0000000","InvDateNotEqualTo":"0001-01-01T00:00:00.0000000","InvDateBetween":["0001-01-01T00:00:00.0000000"],"InvDateIn":["0001-01-01T00:00:00.0000000"],"InvoiceLineID":"String","InvoiceLineIDStartsWith":"String","InvoiceLineIDEndsWith":"String","InvoiceLineIDContains":"String","InvoiceLineIDLike":"String","InvoiceLineIDBetween":["String"],"InvoiceLineIDIn":["String"],"InventoryID":"String","InventoryIDStartsWith":"String","InventoryIDEndsWith":"String","InventoryIDContains":"String","InventoryIDLike":"String","InventoryIDBetween":["String"],"InventoryIDIn":["String"],"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"],"JobID":"String","JobIDStartsWith":"String","JobIDEndsWith":"String","JobIDContains":"String","JobIDLike":"String","JobIDBetween":["String"],"JobIDIn":["String"],"CostIn":0,"CostInGreaterThanOrEqualTo":0,"CostInGreaterThan":0,"CostInLessThan":0,"CostInLessThanOrEqualTo":0,"CostInNotEqualTo":0,"CostInBetween":[0],"CostInIn":[0],"QuantityThisDel":0,"QuantityThisDelGreaterThanOrEqualTo":0,"QuantityThisDelGreaterThan":0,"QuantityThisDelLessThan":0,"QuantityThisDelLessThanOrEqualTo":0,"QuantityThisDelNotEqualTo":0,"QuantityThisDelBetween":[0],"QuantityThisDelIn":[0],"CurrentLineTotal":0,"CurrentLineTotalGreaterThanOrEqualTo":0,"CurrentLineTotalGreaterThan":0,"CurrentLineTotalLessThan":0,"CurrentLineTotalLessThanOrEqualTo":0,"CurrentLineTotalNotEqualTo":0,"CurrentLineTotalBetween":[0],"CurrentLineTotalIn":[0],"TaxToCharge":0,"TaxToChargeGreaterThanOrEqualTo":0,"TaxToChargeGreaterThan":0,"TaxToChargeLessThan":0,"TaxToChargeLessThanOrEqualTo":0,"TaxToChargeNotEqualTo":0,"TaxToChargeBetween":[0],"TaxToChargeIn":[0],"TaxPaid":0,"TaxPaidGreaterThanOrEqualTo":0,"TaxPaidGreaterThan":0,"TaxPaidLessThan":0,"TaxPaidLessThanOrEqualTo":0,"TaxPaidNotEqualTo":0,"TaxPaidBetween":[0],"TaxPaidIn":[0],"DecimalPlaces":0,"DecimalPlacesGreaterThanOrEqualTo":0,"DecimalPlacesGreaterThan":0,"DecimalPlacesLessThan":0,"DecimalPlacesLessThanOrEqualTo":0,"DecimalPlacesNotEqualTo":0,"DecimalPlacesBetween":[0],"DecimalPlacesIn":[0],"TaxID":"String","TaxIDStartsWith":"String","TaxIDEndsWith":"String","TaxIDContains":"String","TaxIDLike":"String","TaxIDBetween":["String"],"TaxIDIn":["String"],"PhysicalItem":0,"PhysicalItemGreaterThanOrEqualTo":0,"PhysicalItemGreaterThan":0,"PhysicalItemLessThan":0,"PhysicalItemLessThanOrEqualTo":0,"PhysicalItemNotEqualTo":0,"PhysicalItemBetween":[0],"PhysicalItemIn":[0],"NonStock":false,"ClassDescription":"String","ClassDescriptionStartsWith":"String","ClassDescriptionEndsWith":"String","ClassDescriptionContains":"String","ClassDescriptionLike":"String","ClassDescriptionBetween":["String"],"ClassDescriptionIn":["String"],"DebtorID":"String","DebtorIDStartsWith":"String","DebtorIDEndsWith":"String","DebtorIDContains":"String","DebtorIDLike":"String","DebtorIDBetween":["String"],"DebtorIDIn":["String"],"AccountNo":"String","AccountNoStartsWith":"String","AccountNoEndsWith":"String","AccountNoContains":"String","AccountNoLike":"String","AccountNoBetween":["String"],"AccountNoIn":["String"],"Name":"String","NameStartsWith":"String","NameEndsWith":"String","NameContains":"String","NameLike":"String","NameBetween":["String"],"NameIn":["String"],"LineCost":0,"LineCostGreaterThanOrEqualTo":0,"LineCostGreaterThan":0,"LineCostLessThan":0,"LineCostLessThanOrEqualTo":0,"LineCostNotEqualTo":0,"LineCostBetween":[0],"LineCostIn":[0],"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"],"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":[{"InvoiceID":"String","InvID":"String","InvoiceNo":"String","IN_LogicalID":"String","OrderNo":"String","TaxExemptNo":"String","Status":0,"StaffID":"String","BranchID":"String","InvoiceHistoryID":"String","HistoryTotal":0,"CartageCharge1":0,"CartageCharge2":0,"CartageCharge3":0,"Frieght":0,"Frt":0,"FrtTax":0,"ProHistoryNo":0,"InvHistoryNo":0,"ProRunNo":"String","InvRunNo":"String","ProDate":"0001-01-01T00:00:00.0000000","InvDate":"0001-01-01T00:00:00.0000000","InvoiceLineID":"String","InventoryID":"String","PartNo":"String","Description":"String","JobID":"String","CostIn":0,"QuantityThisDel":0,"CurrentLineTotal":0,"TaxToCharge":0,"TaxPaid":0,"DecimalPlaces":0,"TaxID":"String","PhysicalItem":0,"NonStock":false,"ClassDescription":"String","DebtorID":"String","AccountNo":"String","Name":"String","LineCost":0,"Cat1Description":"String","Cat2Description":"String","Cat3Description":"String"}],"Meta":{"String":"String"},"ResponseStatus":{"ErrorCode":"String","Message":"String","StackTrace":"String","Errors":[{"ErrorCode":"String","FieldName":"String","Message":"String","Meta":{"String":"String"}}],"Meta":{"String":"String"}}}