JiwaAPI

DB_MainQuery

The following routes are available for this service:
GET	/Queries/DB_Main	Retrieves a list of debtors.

**DB_MainQuery** Parameters:
Name	Parameter	Data Type	Required
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
LastSavedDateTime	query	DateTime?	No
LastSavedDateTimeGreaterThanOrEqualTo	query	DateTime?	No
LastSavedDateTimeGreaterThan	query	DateTime?	No
LastSavedDateTimeLessThan	query	DateTime?	No
LastSavedDateTimeLessThanOrEqualTo	query	DateTime?	No
LastSavedDateTimeNotEqualTo	query	DateTime?	No
LastSavedDateTimeBetween	query	Nullable<DateTime>[]	No
LastSavedDateTimeIn	query	Nullable<DateTime>[]	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
Address1	query	string	No
Address1StartsWith	query	string	No
Address1EndsWith	query	string	No
Address1Contains	query	string	No
Address1Like	query	string	No
Address1Between	query	string[]	No
Address1In	query	string[]	No
Address2	query	string	No
Address2StartsWith	query	string	No
Address2EndsWith	query	string	No
Address2Contains	query	string	No
Address2Like	query	string	No
Address2Between	query	string[]	No
Address2In	query	string[]	No
Address3	query	string	No
Address3StartsWith	query	string	No
Address3EndsWith	query	string	No
Address3Contains	query	string	No
Address3Like	query	string	No
Address3Between	query	string[]	No
Address3In	query	string[]	No
Address4	query	string	No
Address4StartsWith	query	string	No
Address4EndsWith	query	string	No
Address4Contains	query	string	No
Address4Like	query	string	No
Address4Between	query	string[]	No
Address4In	query	string[]	No
PostCode	query	string	No
PostCodeStartsWith	query	string	No
PostCodeEndsWith	query	string	No
PostCodeContains	query	string	No
PostCodeLike	query	string	No
PostCodeBetween	query	string[]	No
PostCodeIn	query	string[]	No
Phone	query	string	No
PhoneStartsWith	query	string	No
PhoneEndsWith	query	string	No
PhoneContains	query	string	No
PhoneLike	query	string	No
PhoneBetween	query	string[]	No
PhoneIn	query	string[]	No
Fax	query	string	No
FaxStartsWith	query	string	No
FaxEndsWith	query	string	No
FaxContains	query	string	No
FaxLike	query	string	No
FaxBetween	query	string[]	No
FaxIn	query	string[]	No
BankName	query	string	No
BankNameStartsWith	query	string	No
BankNameEndsWith	query	string	No
BankNameContains	query	string	No
BankNameLike	query	string	No
BankNameBetween	query	string[]	No
BankNameIn	query	string[]	No
BankAcc	query	string	No
BankAccStartsWith	query	string	No
BankAccEndsWith	query	string	No
BankAccContains	query	string	No
BankAccLike	query	string	No
BankAccBetween	query	string[]	No
BankAccIn	query	string[]	No
BSBN	query	string	No
BSBNStartsWith	query	string	No
BSBNEndsWith	query	string	No
BSBNContains	query	string	No
BSBNLike	query	string	No
BSBNBetween	query	string[]	No
BSBNIn	query	string[]	No
AccountName	query	string	No
AccountNameStartsWith	query	string	No
AccountNameEndsWith	query	string	No
AccountNameContains	query	string	No
AccountNameLike	query	string	No
AccountNameBetween	query	string[]	No
AccountNameIn	query	string[]	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
CreditLimit	query	decimal?	No
CreditLimitGreaterThanOrEqualTo	query	decimal?	No
CreditLimitGreaterThan	query	decimal?	No
CreditLimitLessThan	query	decimal?	No
CreditLimitLessThanOrEqualTo	query	decimal?	No
CreditLimitNotEqualTo	query	decimal?	No
CreditLimitBetween	query	Nullable<Decimal>[]	No
CreditLimitIn	query	Nullable<Decimal>[]	No
EarlyPayDisOnStatsDays	query	short?	No
EarlyPayDisOnStatsDaysGreaterThanOrEqualTo	query	short?	No
EarlyPayDisOnStatsDaysGreaterThan	query	short?	No
EarlyPayDisOnStatsDaysLessThan	query	short?	No
EarlyPayDisOnStatsDaysLessThanOrEqualTo	query	short?	No
EarlyPayDisOnStatsDaysNotEqualTo	query	short?	No
EarlyPayDisOnStatsDaysBetween	query	Nullable<Int16>[]	No
EarlyPayDisOnStatsDaysIn	query	Nullable<Int16>[]	No
EarlyPayDisOnStatsAmt	query	decimal?	No
EarlyPayDisOnStatsAmtGreaterThanOrEqualTo	query	decimal?	No
EarlyPayDisOnStatsAmtGreaterThan	query	decimal?	No
EarlyPayDisOnStatsAmtLessThan	query	decimal?	No
EarlyPayDisOnStatsAmtLessThanOrEqualTo	query	decimal?	No
EarlyPayDisOnStatsAmtNotEqualTo	query	decimal?	No
EarlyPayDisOnStatsAmtBetween	query	Nullable<Decimal>[]	No
EarlyPayDisOnStatsAmtIn	query	Nullable<Decimal>[]	No
LastPurchaseDate	query	DateTime?	No
LastPurchaseDateGreaterThanOrEqualTo	query	DateTime?	No
LastPurchaseDateGreaterThan	query	DateTime?	No
LastPurchaseDateLessThan	query	DateTime?	No
LastPurchaseDateLessThanOrEqualTo	query	DateTime?	No
LastPurchaseDateNotEqualTo	query	DateTime?	No
LastPurchaseDateBetween	query	Nullable<DateTime>[]	No
LastPurchaseDateIn	query	Nullable<DateTime>[]	No
LastPaymentDate	query	DateTime?	No
LastPaymentDateGreaterThanOrEqualTo	query	DateTime?	No
LastPaymentDateGreaterThan	query	DateTime?	No
LastPaymentDateLessThan	query	DateTime?	No
LastPaymentDateLessThanOrEqualTo	query	DateTime?	No
LastPaymentDateNotEqualTo	query	DateTime?	No
LastPaymentDateBetween	query	Nullable<DateTime>[]	No
LastPaymentDateIn	query	Nullable<DateTime>[]	No
StandingDisOnInvoices	query	decimal?	No
StandingDisOnInvoicesGreaterThanOrEqualTo	query	decimal?	No
StandingDisOnInvoicesGreaterThan	query	decimal?	No
StandingDisOnInvoicesLessThan	query	decimal?	No
StandingDisOnInvoicesLessThanOrEqualTo	query	decimal?	No
StandingDisOnInvoicesNotEqualTo	query	decimal?	No
StandingDisOnInvoicesBetween	query	Nullable<Decimal>[]	No
StandingDisOnInvoicesIn	query	Nullable<Decimal>[]	No
ClassificationID	query	string	No
ClassificationIDStartsWith	query	string	No
ClassificationIDEndsWith	query	string	No
ClassificationIDContains	query	string	No
ClassificationIDLike	query	string	No
ClassificationIDBetween	query	string[]	No
ClassificationIDIn	query	string[]	No
AccountOnHold	query	bool?	No
EmailAddress	query	string	No
EmailAddressStartsWith	query	string	No
EmailAddressEndsWith	query	string	No
EmailAddressContains	query	string	No
EmailAddressLike	query	string	No
EmailAddressBetween	query	string[]	No
EmailAddressIn	query	string[]	No
CurrentBalance	query	decimal?	No
CurrentBalanceGreaterThanOrEqualTo	query	decimal?	No
CurrentBalanceGreaterThan	query	decimal?	No
CurrentBalanceLessThan	query	decimal?	No
CurrentBalanceLessThanOrEqualTo	query	decimal?	No
CurrentBalanceNotEqualTo	query	decimal?	No
CurrentBalanceBetween	query	Nullable<Decimal>[]	No
CurrentBalanceIn	query	Nullable<Decimal>[]	No
Period1	query	decimal?	No
Period1GreaterThanOrEqualTo	query	decimal?	No
Period1GreaterThan	query	decimal?	No
Period1LessThan	query	decimal?	No
Period1LessThanOrEqualTo	query	decimal?	No
Period1NotEqualTo	query	decimal?	No
Period1Between	query	Nullable<Decimal>[]	No
Period1In	query	Nullable<Decimal>[]	No
Period2	query	decimal?	No
Period2GreaterThanOrEqualTo	query	decimal?	No
Period2GreaterThan	query	decimal?	No
Period2LessThan	query	decimal?	No
Period2LessThanOrEqualTo	query	decimal?	No
Period2NotEqualTo	query	decimal?	No
Period2Between	query	Nullable<Decimal>[]	No
Period2In	query	Nullable<Decimal>[]	No
Period3	query	decimal?	No
Period3GreaterThanOrEqualTo	query	decimal?	No
Period3GreaterThan	query	decimal?	No
Period3LessThan	query	decimal?	No
Period3LessThanOrEqualTo	query	decimal?	No
Period3NotEqualTo	query	decimal?	No
Period3Between	query	Nullable<Decimal>[]	No
Period3In	query	Nullable<Decimal>[]	No
Period4	query	decimal?	No
Period4GreaterThanOrEqualTo	query	decimal?	No
Period4GreaterThan	query	decimal?	No
Period4LessThan	query	decimal?	No
Period4LessThanOrEqualTo	query	decimal?	No
Period4NotEqualTo	query	decimal?	No
Period4Between	query	Nullable<Decimal>[]	No
Period4In	query	Nullable<Decimal>[]	No
AltAccountNo	query	string	No
AltAccountNoStartsWith	query	string	No
AltAccountNoEndsWith	query	string	No
AltAccountNoContains	query	string	No
AltAccountNoLike	query	string	No
AltAccountNoBetween	query	string[]	No
AltAccountNoIn	query	string[]	No
NotifyRequired	query	bool?	No
NotifyAddress	query	string	No
NotifyAddressStartsWith	query	string	No
NotifyAddressEndsWith	query	string	No
NotifyAddressContains	query	string	No
NotifyAddressLike	query	string	No
NotifyAddressBetween	query	string[]	No
NotifyAddressIn	query	string[]	No
CommenceDate	query	DateTime?	No
CommenceDateGreaterThanOrEqualTo	query	DateTime?	No
CommenceDateGreaterThan	query	DateTime?	No
CommenceDateLessThan	query	DateTime?	No
CommenceDateLessThanOrEqualTo	query	DateTime?	No
CommenceDateNotEqualTo	query	DateTime?	No
CommenceDateBetween	query	Nullable<DateTime>[]	No
CommenceDateIn	query	Nullable<DateTime>[]	No
WebAccess	query	bool?	No
ParentDebtorID	query	string	No
ParentDebtorIDStartsWith	query	string	No
ParentDebtorIDEndsWith	query	string	No
ParentDebtorIDContains	query	string	No
ParentDebtorIDLike	query	string	No
ParentDebtorIDBetween	query	string[]	No
ParentDebtorIDIn	query	string[]	No
AllocLastSavedDateTime	query	DateTime?	No
AllocLastSavedDateTimeGreaterThanOrEqualTo	query	DateTime?	No
AllocLastSavedDateTimeGreaterThan	query	DateTime?	No
AllocLastSavedDateTimeLessThan	query	DateTime?	No
AllocLastSavedDateTimeLessThanOrEqualTo	query	DateTime?	No
AllocLastSavedDateTimeNotEqualTo	query	DateTime?	No
AllocLastSavedDateTimeBetween	query	Nullable<DateTime>[]	No
AllocLastSavedDateTimeIn	query	Nullable<DateTime>[]	No
PriceSchemeID	query	string	No
PriceSchemeIDStartsWith	query	string	No
PriceSchemeIDEndsWith	query	string	No
PriceSchemeIDContains	query	string	No
PriceSchemeIDLike	query	string	No
PriceSchemeIDBetween	query	string[]	No
PriceSchemeIDIn	query	string[]	No
AustPostDPID	query	string	No
AustPostDPIDStartsWith	query	string	No
AustPostDPIDEndsWith	query	string	No
AustPostDPIDContains	query	string	No
AustPostDPIDLike	query	string	No
AustPostDPIDBetween	query	string[]	No
AustPostDPIDIn	query	string[]	No
AustPostBCSP	query	string	No
AustPostBCSPStartsWith	query	string	No
AustPostBCSPEndsWith	query	string	No
AustPostBCSPContains	query	string	No
AustPostBCSPLike	query	string	No
AustPostBCSPBetween	query	string[]	No
AustPostBCSPIn	query	string[]	No
TradingName	query	string	No
TradingNameStartsWith	query	string	No
TradingNameEndsWith	query	string	No
TradingNameContains	query	string	No
TradingNameLike	query	string	No
TradingNameBetween	query	string[]	No
TradingNameIn	query	string[]	No
CompanyName	query	string	No
CompanyNameStartsWith	query	string	No
CompanyNameEndsWith	query	string	No
CompanyNameContains	query	string	No
CompanyNameLike	query	string	No
CompanyNameBetween	query	string[]	No
CompanyNameIn	query	string[]	No
ACN	query	string	No
ACNStartsWith	query	string	No
ACNEndsWith	query	string	No
ACNContains	query	string	No
ACNLike	query	string	No
ACNBetween	query	string[]	No
ACNIn	query	string[]	No
ProprietorsName	query	string	No
ProprietorsNameStartsWith	query	string	No
ProprietorsNameEndsWith	query	string	No
ProprietorsNameContains	query	string	No
ProprietorsNameLike	query	string	No
ProprietorsNameBetween	query	string[]	No
ProprietorsNameIn	query	string[]	No
FaxHeader	query	string	No
FaxHeaderStartsWith	query	string	No
FaxHeaderEndsWith	query	string	No
FaxHeaderContains	query	string	No
FaxHeaderLike	query	string	No
FaxHeaderBetween	query	string[]	No
FaxHeaderIn	query	string[]	No
LedgerIDDebtorControl	query	string	No
LedgerIDDebtorControlStartsWith	query	string	No
LedgerIDDebtorControlEndsWith	query	string	No
LedgerIDDebtorControlContains	query	string	No
LedgerIDDebtorControlLike	query	string	No
LedgerIDDebtorControlBetween	query	string[]	No
LedgerIDDebtorControlIn	query	string[]	No
LedgerIDDebtorSales	query	string	No
LedgerIDDebtorSalesStartsWith	query	string	No
LedgerIDDebtorSalesEndsWith	query	string	No
LedgerIDDebtorSalesContains	query	string	No
LedgerIDDebtorSalesLike	query	string	No
LedgerIDDebtorSalesBetween	query	string[]	No
LedgerIDDebtorSalesIn	query	string[]	No
LedgerIDDebtorDiscounts	query	string	No
LedgerIDDebtorDiscountsStartsWith	query	string	No
LedgerIDDebtorDiscountsEndsWith	query	string	No
LedgerIDDebtorDiscountsContains	query	string	No
LedgerIDDebtorDiscountsLike	query	string	No
LedgerIDDebtorDiscountsBetween	query	string[]	No
LedgerIDDebtorDiscountsIn	query	string[]	No
LedgerIDDebtorSourcedInvoices	query	string	No
LedgerIDDebtorSourcedInvoicesStartsWith	query	string	No
LedgerIDDebtorSourcedInvoicesEndsWith	query	string	No
LedgerIDDebtorSourcedInvoicesContains	query	string	No
LedgerIDDebtorSourcedInvoicesLike	query	string	No
LedgerIDDebtorSourcedInvoicesBetween	query	string[]	No
LedgerIDDebtorSourcedInvoicesIn	query	string[]	No
LedgerIDDebtorDebitAdjustment	query	string	No
LedgerIDDebtorDebitAdjustmentStartsWith	query	string	No
LedgerIDDebtorDebitAdjustmentEndsWith	query	string	No
LedgerIDDebtorDebitAdjustmentContains	query	string	No
LedgerIDDebtorDebitAdjustmentLike	query	string	No
LedgerIDDebtorDebitAdjustmentBetween	query	string[]	No
LedgerIDDebtorDebitAdjustmentIn	query	string[]	No
LedgerIDDebtorSourcedReceipts	query	string	No
LedgerIDDebtorSourcedReceiptsStartsWith	query	string	No
LedgerIDDebtorSourcedReceiptsEndsWith	query	string	No
LedgerIDDebtorSourcedReceiptsContains	query	string	No
LedgerIDDebtorSourcedReceiptsLike	query	string	No
LedgerIDDebtorSourcedReceiptsBetween	query	string[]	No
LedgerIDDebtorSourcedReceiptsIn	query	string[]	No
LedgerIDDebtorCreditAdjustment	query	string	No
LedgerIDDebtorCreditAdjustmentStartsWith	query	string	No
LedgerIDDebtorCreditAdjustmentEndsWith	query	string	No
LedgerIDDebtorCreditAdjustmentContains	query	string	No
LedgerIDDebtorCreditAdjustmentLike	query	string	No
LedgerIDDebtorCreditAdjustmentBetween	query	string[]	No
LedgerIDDebtorCreditAdjustmentIn	query	string[]	No
LedgerIDDebtorFreight	query	string	No
LedgerIDDebtorFreightStartsWith	query	string	No
LedgerIDDebtorFreightEndsWith	query	string	No
LedgerIDDebtorFreightContains	query	string	No
LedgerIDDebtorFreightLike	query	string	No
LedgerIDDebtorFreightBetween	query	string[]	No
LedgerIDDebtorFreightIn	query	string[]	No
LedgerIDDebtorInsurance	query	string	No
LedgerIDDebtorInsuranceStartsWith	query	string	No
LedgerIDDebtorInsuranceEndsWith	query	string	No
LedgerIDDebtorInsuranceContains	query	string	No
LedgerIDDebtorInsuranceLike	query	string	No
LedgerIDDebtorInsuranceBetween	query	string[]	No
LedgerIDDebtorInsuranceIn	query	string[]	No
LedgerIDDebtorRealisedGainLoss	query	string	No
LedgerIDDebtorRealisedGainLossStartsWith	query	string	No
LedgerIDDebtorRealisedGainLossEndsWith	query	string	No
LedgerIDDebtorRealisedGainLossContains	query	string	No
LedgerIDDebtorRealisedGainLossLike	query	string	No
LedgerIDDebtorRealisedGainLossBetween	query	string[]	No
LedgerIDDebtorRealisedGainLossIn	query	string[]	No
LedgerIDDebtorUnRealisedGainLoss	query	string	No
LedgerIDDebtorUnRealisedGainLossStartsWith	query	string	No
LedgerIDDebtorUnRealisedGainLossEndsWith	query	string	No
LedgerIDDebtorUnRealisedGainLossContains	query	string	No
LedgerIDDebtorUnRealisedGainLossLike	query	string	No
LedgerIDDebtorUnRealisedGainLossBetween	query	string[]	No
LedgerIDDebtorUnRealisedGainLossIn	query	string[]	No
PeriodType	query	short?	No
PeriodTypeGreaterThanOrEqualTo	query	short?	No
PeriodTypeGreaterThan	query	short?	No
PeriodTypeLessThan	query	short?	No
PeriodTypeLessThanOrEqualTo	query	short?	No
PeriodTypeNotEqualTo	query	short?	No
PeriodTypeBetween	query	Nullable<Int16>[]	No
PeriodTypeIn	query	Nullable<Int16>[]	No
TermsDays	query	short?	No
TermsDaysGreaterThanOrEqualTo	query	short?	No
TermsDaysGreaterThan	query	short?	No
TermsDaysLessThan	query	short?	No
TermsDaysLessThanOrEqualTo	query	short?	No
TermsDaysNotEqualTo	query	short?	No
TermsDaysBetween	query	Nullable<Int16>[]	No
TermsDaysIn	query	Nullable<Int16>[]	No
TermsType	query	short?	No
TermsTypeGreaterThanOrEqualTo	query	short?	No
TermsTypeGreaterThan	query	short?	No
TermsTypeLessThan	query	short?	No
TermsTypeLessThanOrEqualTo	query	short?	No
TermsTypeNotEqualTo	query	short?	No
TermsTypeBetween	query	Nullable<Int16>[]	No
TermsTypeIn	query	Nullable<Int16>[]	No
ABN	query	string	No
ABNStartsWith	query	string	No
ABNEndsWith	query	string	No
ABNContains	query	string	No
ABNLike	query	string	No
ABNBetween	query	string[]	No
ABNIn	query	string[]	No
ExcludeFromAging	query	bool?	No
BPayReference	query	string	No
BPayReferenceStartsWith	query	string	No
BPayReferenceEndsWith	query	string	No
BPayReferenceContains	query	string	No
BPayReferenceLike	query	string	No
BPayReferenceBetween	query	string[]	No
BPayReferenceIn	query	string[]	No
UsesFX	query	bool?	No
FXCurrencyID	query	string	No
FXCurrencyIDStartsWith	query	string	No
FXCurrencyIDEndsWith	query	string	No
FXCurrencyIDContains	query	string	No
FXCurrencyIDLike	query	string	No
FXCurrencyIDBetween	query	string[]	No
FXCurrencyIDIn	query	string[]	No
FXCurrentBalance	query	decimal?	No
FXCurrentBalanceGreaterThanOrEqualTo	query	decimal?	No
FXCurrentBalanceGreaterThan	query	decimal?	No
FXCurrentBalanceLessThan	query	decimal?	No
FXCurrentBalanceLessThanOrEqualTo	query	decimal?	No
FXCurrentBalanceNotEqualTo	query	decimal?	No
FXCurrentBalanceBetween	query	Nullable<Decimal>[]	No
FXCurrentBalanceIn	query	Nullable<Decimal>[]	No
FXPeriod1	query	decimal?	No
FXPeriod1GreaterThanOrEqualTo	query	decimal?	No
FXPeriod1GreaterThan	query	decimal?	No
FXPeriod1LessThan	query	decimal?	No
FXPeriod1LessThanOrEqualTo	query	decimal?	No
FXPeriod1NotEqualTo	query	decimal?	No
FXPeriod1Between	query	Nullable<Decimal>[]	No
FXPeriod1In	query	Nullable<Decimal>[]	No
FXPeriod2	query	decimal?	No
FXPeriod2GreaterThanOrEqualTo	query	decimal?	No
FXPeriod2GreaterThan	query	decimal?	No
FXPeriod2LessThan	query	decimal?	No
FXPeriod2LessThanOrEqualTo	query	decimal?	No
FXPeriod2NotEqualTo	query	decimal?	No
FXPeriod2Between	query	Nullable<Decimal>[]	No
FXPeriod2In	query	Nullable<Decimal>[]	No
FXPeriod3	query	decimal?	No
FXPeriod3GreaterThanOrEqualTo	query	decimal?	No
FXPeriod3GreaterThan	query	decimal?	No
FXPeriod3LessThan	query	decimal?	No
FXPeriod3LessThanOrEqualTo	query	decimal?	No
FXPeriod3NotEqualTo	query	decimal?	No
FXPeriod3Between	query	Nullable<Decimal>[]	No
FXPeriod3In	query	Nullable<Decimal>[]	No
FXPeriod4	query	decimal?	No
FXPeriod4GreaterThanOrEqualTo	query	decimal?	No
FXPeriod4GreaterThan	query	decimal?	No
FXPeriod4LessThan	query	decimal?	No
FXPeriod4LessThanOrEqualTo	query	decimal?	No
FXPeriod4NotEqualTo	query	decimal?	No
FXPeriod4Between	query	Nullable<Decimal>[]	No
FXPeriod4In	query	Nullable<Decimal>[]	No
TradingStatus	query	byte?	No
TradingStatusGreaterThanOrEqualTo	query	byte?	No
TradingStatusGreaterThan	query	byte?	No
TradingStatusLessThan	query	byte?	No
TradingStatusLessThanOrEqualTo	query	byte?	No
TradingStatusNotEqualTo	query	byte?	No
TradingStatusBetween	query	Nullable<Byte>[]	No
TradingStatusIn	query	Nullable<Byte>[]	No
Category1ID	query	string	No
Category1IDStartsWith	query	string	No
Category1IDEndsWith	query	string	No
Category1IDContains	query	string	No
Category1IDLike	query	string	No
Category1IDBetween	query	string[]	No
Category1IDIn	query	string[]	No
Category2ID	query	string	No
Category2IDStartsWith	query	string	No
Category2IDEndsWith	query	string	No
Category2IDContains	query	string	No
Category2IDLike	query	string	No
Category2IDBetween	query	string[]	No
Category2IDIn	query	string[]	No
Category3ID	query	string	No
Category3IDStartsWith	query	string	No
Category3IDEndsWith	query	string	No
Category3IDContains	query	string	No
Category3IDLike	query	string	No
Category3IDBetween	query	string[]	No
Category3IDIn	query	string[]	No
Category4ID	query	string	No
Category4IDStartsWith	query	string	No
Category4IDEndsWith	query	string	No
Category4IDContains	query	string	No
Category4IDLike	query	string	No
Category4IDBetween	query	string[]	No
Category4IDIn	query	string[]	No
Category5ID	query	string	No
Category5IDStartsWith	query	string	No
Category5IDEndsWith	query	string	No
Category5IDContains	query	string	No
Category5IDLike	query	string	No
Category5IDBetween	query	string[]	No
Category5IDIn	query	string[]	No
BO_Priorities_RecID	query	string	No
BO_Priorities_RecIDStartsWith	query	string	No
BO_Priorities_RecIDEndsWith	query	string	No
BO_Priorities_RecIDContains	query	string	No
BO_Priorities_RecIDLike	query	string	No
BO_Priorities_RecIDBetween	query	string[]	No
BO_Priorities_RecIDIn	query	string[]	No
PricingGroupID	query	string	No
PricingGroupIDStartsWith	query	string	No
PricingGroupIDEndsWith	query	string	No
PricingGroupIDContains	query	string	No
PricingGroupIDLike	query	string	No
PricingGroupIDBetween	query	string[]	No
PricingGroupIDIn	query	string[]	No
BudgetedGPPercentage	query	decimal?	No
BudgetedGPPercentageGreaterThanOrEqualTo	query	decimal?	No
BudgetedGPPercentageGreaterThan	query	decimal?	No
BudgetedGPPercentageLessThan	query	decimal?	No
BudgetedGPPercentageLessThanOrEqualTo	query	decimal?	No
BudgetedGPPercentageNotEqualTo	query	decimal?	No
BudgetedGPPercentageBetween	query	Nullable<Decimal>[]	No
BudgetedGPPercentageIn	query	Nullable<Decimal>[]	No
Country	query	string	No
CountryStartsWith	query	string	No
CountryEndsWith	query	string	No
CountryContains	query	string	No
CountryLike	query	string	No
CountryBetween	query	string[]	No
CountryIn	query	string[]	No
FR_Carriers_RecID	query	string	No
FR_Carriers_RecIDStartsWith	query	string	No
FR_Carriers_RecIDEndsWith	query	string	No
FR_Carriers_RecIDContains	query	string	No
FR_Carriers_RecIDLike	query	string	No
FR_Carriers_RecIDBetween	query	string[]	No
FR_Carriers_RecIDIn	query	string[]	No
FR_CarrierServices_RecID	query	string	No
FR_CarrierServices_RecIDStartsWith	query	string	No
FR_CarrierServices_RecIDEndsWith	query	string	No
FR_CarrierServices_RecIDContains	query	string	No
FR_CarrierServices_RecIDLike	query	string	No
FR_CarrierServices_RecIDBetween	query	string[]	No
FR_CarrierServices_RecIDIn	query	string[]	No
CarrierAccountNo	query	string	No
CarrierAccountNoStartsWith	query	string	No
CarrierAccountNoEndsWith	query	string	No
CarrierAccountNoContains	query	string	No
CarrierAccountNoLike	query	string	No
CarrierAccountNoBetween	query	string[]	No
CarrierAccountNoIn	query	string[]	No
ChargeTo	query	byte?	No
ChargeToGreaterThanOrEqualTo	query	byte?	No
ChargeToGreaterThan	query	byte?	No
ChargeToLessThan	query	byte?	No
ChargeToLessThanOrEqualTo	query	byte?	No
ChargeToNotEqualTo	query	byte?	No
ChargeToBetween	query	byte[]	No
ChargeToIn	query	byte[]	No
IsCashOnly	query	bool?	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

**DB_Main** Parameters:
Name	Parameter	Data Type	Required
DebtorID	form	string	No
LastSavedDateTime	form	DateTime?	No
AccountNo	form	string	No
Name	form	string	No
Address1	form	string	No
Address2	form	string	No
Address3	form	string	No
Address4	form	string	No
PostCode	form	string	No
Phone	form	string	No
Fax	form	string	No
BankName	form	string	No
BankAcc	form	string	No
BSBN	form	string	No
AccountName	form	string	No
TaxExemptNo	form	string	No
CreditLimit	form	decimal?	No
EarlyPayDisOnStatsDays	form	short?	No
EarlyPayDisOnStatsAmt	form	decimal?	No
LastPurchaseDate	form	DateTime?	No
LastPaymentDate	form	DateTime?	No
StandingDisOnInvoices	form	decimal?	No
ClassificationID	form	string	No
AccountOnHold	form	bool?	No
EmailAddress	form	string	No
CurrentBalance	form	decimal?	No
Period1	form	decimal?	No
Period2	form	decimal?	No
Period3	form	decimal?	No
Period4	form	decimal?	No
AltAccountNo	form	string	No
NotifyRequired	form	bool	No
NotifyAddress	form	string	No
CommenceDate	form	DateTime?	No
WebAccess	form	bool	No
ParentDebtorID	form	string	No
AllocLastSavedDateTime	form	DateTime?	No
PriceSchemeID	form	string	No
AustPostDPID	form	string	No
AustPostBCSP	form	string	No
TradingName	form	string	No
CompanyName	form	string	No
ACN	form	string	No
ProprietorsName	form	string	No
FaxHeader	form	string	No
LedgerIDDebtorControl	form	string	No
LedgerIDDebtorSales	form	string	No
LedgerIDDebtorDiscounts	form	string	No
LedgerIDDebtorSourcedInvoices	form	string	No
LedgerIDDebtorDebitAdjustment	form	string	No
LedgerIDDebtorSourcedReceipts	form	string	No
LedgerIDDebtorCreditAdjustment	form	string	No
LedgerIDDebtorFreight	form	string	No
LedgerIDDebtorInsurance	form	string	No
LedgerIDDebtorRealisedGainLoss	form	string	No
LedgerIDDebtorUnRealisedGainLoss	form	string	No
PeriodType	form	short?	No
TermsDays	form	short?	No
TermsType	form	short?	No
ABN	form	string	No
ExcludeFromAging	form	bool	No
BPayReference	form	string	No
UsesFX	form	bool	No
FXCurrencyID	form	string	No
FXCurrentBalance	form	decimal?	No
FXPeriod1	form	decimal?	No
FXPeriod2	form	decimal?	No
FXPeriod3	form	decimal?	No
FXPeriod4	form	decimal?	No
TradingStatus	form	byte?	No
Category1ID	form	string	No
Category2ID	form	string	No
Category3ID	form	string	No
Category4ID	form	string	No
Category5ID	form	string	No
BO_Priorities_RecID	form	string	No
PricingGroupID	form	string	No
BudgetedGPPercentage	form	decimal?	No
Country	form	string	No
FR_Carriers_RecID	form	string	No
FR_CarrierServices_RecID	form	string	No
CarrierAccountNo	form	string	No
ChargeTo	form	byte	No
IsCashOnly	form	bool	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 .json suffix or ?format=json

To embed the response in a jsonp callback, append ?callback=myCallback

HTTP + JSON

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

GET /Queries/DB_Main HTTP/1.1 
Host: api.jiwa.com.au 
Accept: application/json

HTTP/1.1 200 OK
Content-Type: application/json
Content-Length: length

{"Results":[{"DebtorID":"String","LastSavedDateTime":"0001-01-01T00:00:00.0000000","AccountNo":"String","Name":"String","Address1":"String","Address2":"String","Address3":"String","Address4":"String","PostCode":"String","Phone":"String","Fax":"String","BankName":"String","BankAcc":"String","BSBN":"String","AccountName":"String","TaxExemptNo":"String","CreditLimit":0,"EarlyPayDisOnStatsDays":0,"EarlyPayDisOnStatsAmt":0,"LastPurchaseDate":"0001-01-01T00:00:00.0000000","LastPaymentDate":"0001-01-01T00:00:00.0000000","StandingDisOnInvoices":0,"ClassificationID":"String","AccountOnHold":false,"EmailAddress":"String","CurrentBalance":0,"Period1":0,"Period2":0,"Period3":0,"Period4":0,"AltAccountNo":"String","NotifyAddress":"String","CommenceDate":"0001-01-01T00:00:00.0000000","ParentDebtorID":"String","AllocLastSavedDateTime":"0001-01-01T00:00:00.0000000","PriceSchemeID":"String","AustPostDPID":"String","AustPostBCSP":"String","TradingName":"String","CompanyName":"String","ACN":"String","ProprietorsName":"String","FaxHeader":"String","LedgerIDDebtorControl":"String","LedgerIDDebtorSales":"String","LedgerIDDebtorDiscounts":"String","LedgerIDDebtorSourcedInvoices":"String","LedgerIDDebtorDebitAdjustment":"String","LedgerIDDebtorSourcedReceipts":"String","LedgerIDDebtorCreditAdjustment":"String","LedgerIDDebtorFreight":"String","LedgerIDDebtorInsurance":"String","LedgerIDDebtorRealisedGainLoss":"String","LedgerIDDebtorUnRealisedGainLoss":"String","PeriodType":0,"TermsDays":0,"TermsType":0,"ABN":"String","BPayReference":"String","FXCurrencyID":"String","FXCurrentBalance":0,"FXPeriod1":0,"FXPeriod2":0,"FXPeriod3":0,"FXPeriod4":0,"TradingStatus":0,"Category1ID":"String","Category2ID":"String","Category3ID":"String","Category4ID":"String","Category5ID":"String","BO_Priorities_RecID":"String","PricingGroupID":"String","BudgetedGPPercentage":0,"Country":"String","FR_Carriers_RecID":"String","FR_CarrierServices_RecID":"String","CarrierAccountNo":"String"}],"Meta":{"String":"String"},"ResponseStatus":{"ErrorCode":"String","Message":"String","StackTrace":"String","Errors":[{"ErrorCode":"String","FieldName":"String","Message":"String","Meta":{"String":"String"}}],"Meta":{"String":"String"}}}