JiwaAPI

CR_MainQuery

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

**CR_MainQuery** Parameters:
Name	Parameter	Data Type	Required
CreditorID	query	string	No
CreditorIDStartsWith	query	string	No
CreditorIDEndsWith	query	string	No
CreditorIDContains	query	string	No
CreditorIDLike	query	string	No
CreditorIDBetween	query	string[]	No
CreditorIDIn	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
DefaultPaymentType	query	byte?	No
DefaultPaymentTypeGreaterThanOrEqualTo	query	byte?	No
DefaultPaymentTypeGreaterThan	query	byte?	No
DefaultPaymentTypeLessThan	query	byte?	No
DefaultPaymentTypeLessThanOrEqualTo	query	byte?	No
DefaultPaymentTypeNotEqualTo	query	byte?	No
DefaultPaymentTypeBetween	query	Nullable<Byte>[]	No
DefaultPaymentTypeIn	query	Nullable<Byte>[]	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
EarlyPayDisOnRemitDays	query	short?	No
EarlyPayDisOnRemitDaysGreaterThanOrEqualTo	query	short?	No
EarlyPayDisOnRemitDaysGreaterThan	query	short?	No
EarlyPayDisOnRemitDaysLessThan	query	short?	No
EarlyPayDisOnRemitDaysLessThanOrEqualTo	query	short?	No
EarlyPayDisOnRemitDaysNotEqualTo	query	short?	No
EarlyPayDisOnRemitDaysBetween	query	Nullable<Int16>[]	No
EarlyPayDisOnRemitDaysIn	query	Nullable<Int16>[]	No
EarlyPayDisOnRemitAmt	query	decimal?	No
EarlyPayDisOnRemitAmtGreaterThanOrEqualTo	query	decimal?	No
EarlyPayDisOnRemitAmtGreaterThan	query	decimal?	No
EarlyPayDisOnRemitAmtLessThan	query	decimal?	No
EarlyPayDisOnRemitAmtLessThanOrEqualTo	query	decimal?	No
EarlyPayDisOnRemitAmtNotEqualTo	query	decimal?	No
EarlyPayDisOnRemitAmtBetween	query	decimal[]	No
EarlyPayDisOnRemitAmtIn	query	decimal[]	No
LastSaleDate	query	DateTime?	No
LastSaleDateGreaterThanOrEqualTo	query	DateTime?	No
LastSaleDateGreaterThan	query	DateTime?	No
LastSaleDateLessThan	query	DateTime?	No
LastSaleDateLessThanOrEqualTo	query	DateTime?	No
LastSaleDateNotEqualTo	query	DateTime?	No
LastSaleDateBetween	query	Nullable<DateTime>[]	No
LastSaleDateIn	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
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	decimal[]	No
Period1In	query	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	decimal[]	No
Period2In	query	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	decimal[]	No
Period3In	query	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	decimal[]	No
Period4In	query	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
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
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
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
CurrencyID	query	string	No
CurrencyIDStartsWith	query	string	No
CurrencyIDEndsWith	query	string	No
CurrencyIDContains	query	string	No
CurrencyIDLike	query	string	No
CurrencyIDBetween	query	string[]	No
CurrencyIDIn	query	string[]	No
UsesFX	query	bool?	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
TermsType	query	byte?	No
TermsTypeGreaterThanOrEqualTo	query	byte?	No
TermsTypeGreaterThan	query	byte?	No
TermsTypeLessThan	query	byte?	No
TermsTypeLessThanOrEqualTo	query	byte?	No
TermsTypeNotEqualTo	query	byte?	No
TermsTypeBetween	query	Nullable<Byte>[]	No
TermsTypeIn	query	Nullable<Byte>[]	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
MinPOValue	query	decimal?	No
MinPOValueGreaterThanOrEqualTo	query	decimal?	No
MinPOValueGreaterThan	query	decimal?	No
MinPOValueLessThan	query	decimal?	No
MinPOValueLessThanOrEqualTo	query	decimal?	No
MinPOValueNotEqualTo	query	decimal?	No
MinPOValueBetween	query	decimal[]	No
MinPOValueIn	query	decimal[]	No
MaxPOValue	query	decimal?	No
MaxPOValueGreaterThanOrEqualTo	query	decimal?	No
MaxPOValueGreaterThan	query	decimal?	No
MaxPOValueLessThan	query	decimal?	No
MaxPOValueLessThanOrEqualTo	query	decimal?	No
MaxPOValueNotEqualTo	query	decimal?	No
MaxPOValueBetween	query	decimal[]	No
MaxPOValueIn	query	decimal[]	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
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
ProprietorName	query	string	No
ProprietorNameStartsWith	query	string	No
ProprietorNameEndsWith	query	string	No
ProprietorNameContains	query	string	No
ProprietorNameLike	query	string	No
ProprietorNameBetween	query	string[]	No
ProprietorNameIn	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	decimal[]	No
FXCurrentBalanceIn	query	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	decimal[]	No
FXPeriod1In	query	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	decimal[]	No
FXPeriod2In	query	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	decimal[]	No
FXPeriod3In	query	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	decimal[]	No
FXPeriod4In	query	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
LedgerIDCreditorControl	query	string	No
LedgerIDCreditorControlStartsWith	query	string	No
LedgerIDCreditorControlEndsWith	query	string	No
LedgerIDCreditorControlContains	query	string	No
LedgerIDCreditorControlLike	query	string	No
LedgerIDCreditorControlBetween	query	string[]	No
LedgerIDCreditorControlIn	query	string[]	No
LedgerIDCreditorPurchases	query	string	No
LedgerIDCreditorPurchasesStartsWith	query	string	No
LedgerIDCreditorPurchasesEndsWith	query	string	No
LedgerIDCreditorPurchasesContains	query	string	No
LedgerIDCreditorPurchasesLike	query	string	No
LedgerIDCreditorPurchasesBetween	query	string[]	No
LedgerIDCreditorPurchasesIn	query	string[]	No
LedgerIDCreditorDiscounts	query	string	No
LedgerIDCreditorDiscountsStartsWith	query	string	No
LedgerIDCreditorDiscountsEndsWith	query	string	No
LedgerIDCreditorDiscountsContains	query	string	No
LedgerIDCreditorDiscountsLike	query	string	No
LedgerIDCreditorDiscountsBetween	query	string[]	No
LedgerIDCreditorDiscountsIn	query	string[]	No
LedgerIDCreditorSourcedPayments	query	string	No
LedgerIDCreditorSourcedPaymentsStartsWith	query	string	No
LedgerIDCreditorSourcedPaymentsEndsWith	query	string	No
LedgerIDCreditorSourcedPaymentsContains	query	string	No
LedgerIDCreditorSourcedPaymentsLike	query	string	No
LedgerIDCreditorSourcedPaymentsBetween	query	string[]	No
LedgerIDCreditorSourcedPaymentsIn	query	string[]	No
LedgerIDCreditorSourcedDebitAdjustment	query	string	No
LedgerIDCreditorSourcedDebitAdjustmentStartsWith	query	string	No
LedgerIDCreditorSourcedDebitAdjustmentEndsWith	query	string	No
LedgerIDCreditorSourcedDebitAdjustmentContains	query	string	No
LedgerIDCreditorSourcedDebitAdjustmentLike	query	string	No
LedgerIDCreditorSourcedDebitAdjustmentBetween	query	string[]	No
LedgerIDCreditorSourcedDebitAdjustmentIn	query	string[]	No
LedgerIDCreditorSourcedPurchase	query	string	No
LedgerIDCreditorSourcedPurchaseStartsWith	query	string	No
LedgerIDCreditorSourcedPurchaseEndsWith	query	string	No
LedgerIDCreditorSourcedPurchaseContains	query	string	No
LedgerIDCreditorSourcedPurchaseLike	query	string	No
LedgerIDCreditorSourcedPurchaseBetween	query	string[]	No
LedgerIDCreditorSourcedPurchaseIn	query	string[]	No
LedgerIDCreditorSourcedCreditAdjustment	query	string	No
LedgerIDCreditorSourcedCreditAdjustmentStartsWith	query	string	No
LedgerIDCreditorSourcedCreditAdjustmentEndsWith	query	string	No
LedgerIDCreditorSourcedCreditAdjustmentContains	query	string	No
LedgerIDCreditorSourcedCreditAdjustmentLike	query	string	No
LedgerIDCreditorSourcedCreditAdjustmentBetween	query	string[]	No
LedgerIDCreditorSourcedCreditAdjustmentIn	query	string[]	No
LedgerIDCreditorFreight	query	string	No
LedgerIDCreditorFreightStartsWith	query	string	No
LedgerIDCreditorFreightEndsWith	query	string	No
LedgerIDCreditorFreightContains	query	string	No
LedgerIDCreditorFreightLike	query	string	No
LedgerIDCreditorFreightBetween	query	string[]	No
LedgerIDCreditorFreightIn	query	string[]	No
LedgerIDCreditorInsurance	query	string	No
LedgerIDCreditorInsuranceStartsWith	query	string	No
LedgerIDCreditorInsuranceEndsWith	query	string	No
LedgerIDCreditorInsuranceContains	query	string	No
LedgerIDCreditorInsuranceLike	query	string	No
LedgerIDCreditorInsuranceBetween	query	string[]	No
LedgerIDCreditorInsuranceIn	query	string[]	No
LedgerIDCreditorDuty	query	string	No
LedgerIDCreditorDutyStartsWith	query	string	No
LedgerIDCreditorDutyEndsWith	query	string	No
LedgerIDCreditorDutyContains	query	string	No
LedgerIDCreditorDutyLike	query	string	No
LedgerIDCreditorDutyBetween	query	string[]	No
LedgerIDCreditorDutyIn	query	string[]	No
LedgerIDCreditorRealisedGainLoss	query	string	No
LedgerIDCreditorRealisedGainLossStartsWith	query	string	No
LedgerIDCreditorRealisedGainLossEndsWith	query	string	No
LedgerIDCreditorRealisedGainLossContains	query	string	No
LedgerIDCreditorRealisedGainLossLike	query	string	No
LedgerIDCreditorRealisedGainLossBetween	query	string[]	No
LedgerIDCreditorRealisedGainLossIn	query	string[]	No
LedgerIDCreditorUnRealisedGainLoss	query	string	No
LedgerIDCreditorUnRealisedGainLossStartsWith	query	string	No
LedgerIDCreditorUnRealisedGainLossEndsWith	query	string	No
LedgerIDCreditorUnRealisedGainLossContains	query	string	No
LedgerIDCreditorUnRealisedGainLossLike	query	string	No
LedgerIDCreditorUnRealisedGainLossBetween	query	string[]	No
LedgerIDCreditorUnRealisedGainLossIn	query	string[]	No
PO_Workflows_RecID	query	string	No
PO_Workflows_RecIDStartsWith	query	string	No
PO_Workflows_RecIDEndsWith	query	string	No
PO_Workflows_RecIDContains	query	string	No
PO_Workflows_RecIDLike	query	string	No
PO_Workflows_RecIDBetween	query	string[]	No
PO_Workflows_RecIDIn	query	string[]	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

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

**CR_Main** Parameters:
Name	Parameter	Data Type	Required
CreditorID	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
DefaultPaymentType	form	byte?	No
CreditLimit	form	decimal?	No
EarlyPayDisOnRemitDays	form	short?	No
EarlyPayDisOnRemitAmt	form	decimal	No
LastSaleDate	form	DateTime?	No
LastPaymentDate	form	DateTime?	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
CommenceDate	form	DateTime?	No
TermsDays	form	short?	No
ACN	form	string	No
CurrencyID	form	string	No
UsesFX	form	bool	No
ABN	form	string	No
TermsType	form	byte?	No
AustPostDPID	form	string	No
AustPostBCSP	form	string	No
MinPOValue	form	decimal	No
MaxPOValue	form	decimal	No
PeriodType	form	short?	No
TradingName	form	string	No
CompanyName	form	string	No
ProprietorName	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
LedgerIDCreditorControl	form	string	No
LedgerIDCreditorPurchases	form	string	No
LedgerIDCreditorDiscounts	form	string	No
LedgerIDCreditorSourcedPayments	form	string	No
LedgerIDCreditorSourcedDebitAdjustment	form	string	No
LedgerIDCreditorSourcedPurchase	form	string	No
LedgerIDCreditorSourcedCreditAdjustment	form	string	No
LedgerIDCreditorFreight	form	string	No
LedgerIDCreditorInsurance	form	string	No
LedgerIDCreditorDuty	form	string	No
LedgerIDCreditorRealisedGainLoss	form	string	No
LedgerIDCreditorUnRealisedGainLoss	form	string	No
PO_Workflows_RecID	form	string	No
Country	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 .xml suffix or ?format=xml

HTTP + XML

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

GET /Queries/CR_Main HTTP/1.1 
Host: localhost 
Accept: application/xml

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

<QueryResponseOfCR_Main7kRqkrSv xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.servicestack.net/types">
  <Offset>0</Offset>
  <Total>0</Total>
  <Results xmlns:d2p1="http://schemas.datacontract.org/2004/07/JiwaFinancials.Jiwa.JiwaServiceModel.Tables">
    <d2p1:CR_Main>
      <d2p1:_x003C_ABN_x003E_k__BackingField>String</d2p1:_x003C_ABN_x003E_k__BackingField>
      <d2p1:_x003C_ACN_x003E_k__BackingField>String</d2p1:_x003C_ACN_x003E_k__BackingField>
      <d2p1:_x003C_AccountName_x003E_k__BackingField>String</d2p1:_x003C_AccountName_x003E_k__BackingField>
      <d2p1:_x003C_AccountNo_x003E_k__BackingField>String</d2p1:_x003C_AccountNo_x003E_k__BackingField>
      <d2p1:_x003C_AccountOnHold_x003E_k__BackingField>false</d2p1:_x003C_AccountOnHold_x003E_k__BackingField>
      <d2p1:_x003C_Address1_x003E_k__BackingField>String</d2p1:_x003C_Address1_x003E_k__BackingField>
      <d2p1:_x003C_Address2_x003E_k__BackingField>String</d2p1:_x003C_Address2_x003E_k__BackingField>
      <d2p1:_x003C_Address3_x003E_k__BackingField>String</d2p1:_x003C_Address3_x003E_k__BackingField>
      <d2p1:_x003C_Address4_x003E_k__BackingField>String</d2p1:_x003C_Address4_x003E_k__BackingField>
      <d2p1:_x003C_AltAccountNo_x003E_k__BackingField>String</d2p1:_x003C_AltAccountNo_x003E_k__BackingField>
      <d2p1:_x003C_AustPostBCSP_x003E_k__BackingField>String</d2p1:_x003C_AustPostBCSP_x003E_k__BackingField>
      <d2p1:_x003C_AustPostDPID_x003E_k__BackingField>String</d2p1:_x003C_AustPostDPID_x003E_k__BackingField>
      <d2p1:_x003C_BSBN_x003E_k__BackingField>String</d2p1:_x003C_BSBN_x003E_k__BackingField>
      <d2p1:_x003C_BankAcc_x003E_k__BackingField>String</d2p1:_x003C_BankAcc_x003E_k__BackingField>
      <d2p1:_x003C_BankName_x003E_k__BackingField>String</d2p1:_x003C_BankName_x003E_k__BackingField>
      <d2p1:_x003C_ClassificationID_x003E_k__BackingField>String</d2p1:_x003C_ClassificationID_x003E_k__BackingField>
      <d2p1:_x003C_CommenceDate_x003E_k__BackingField>0001-01-01T00:00:00</d2p1:_x003C_CommenceDate_x003E_k__BackingField>
      <d2p1:_x003C_CompanyName_x003E_k__BackingField>String</d2p1:_x003C_CompanyName_x003E_k__BackingField>
      <d2p1:_x003C_Country_x003E_k__BackingField>String</d2p1:_x003C_Country_x003E_k__BackingField>
      <d2p1:_x003C_CreditLimit_x003E_k__BackingField>0</d2p1:_x003C_CreditLimit_x003E_k__BackingField>
      <d2p1:_x003C_CreditorID_x003E_k__BackingField>String</d2p1:_x003C_CreditorID_x003E_k__BackingField>
      <d2p1:_x003C_CurrencyID_x003E_k__BackingField>String</d2p1:_x003C_CurrencyID_x003E_k__BackingField>
      <d2p1:_x003C_CurrentBalance_x003E_k__BackingField>0</d2p1:_x003C_CurrentBalance_x003E_k__BackingField>
      <d2p1:_x003C_DefaultPaymentType_x003E_k__BackingField>0</d2p1:_x003C_DefaultPaymentType_x003E_k__BackingField>
      <d2p1:_x003C_EarlyPayDisOnRemitAmt_x003E_k__BackingField>0</d2p1:_x003C_EarlyPayDisOnRemitAmt_x003E_k__BackingField>
      <d2p1:_x003C_EarlyPayDisOnRemitDays_x003E_k__BackingField>0</d2p1:_x003C_EarlyPayDisOnRemitDays_x003E_k__BackingField>
      <d2p1:_x003C_EmailAddress_x003E_k__BackingField>String</d2p1:_x003C_EmailAddress_x003E_k__BackingField>
      <d2p1:_x003C_FXCurrentBalance_x003E_k__BackingField>0</d2p1:_x003C_FXCurrentBalance_x003E_k__BackingField>
      <d2p1:_x003C_FXPeriod1_x003E_k__BackingField>0</d2p1:_x003C_FXPeriod1_x003E_k__BackingField>
      <d2p1:_x003C_FXPeriod2_x003E_k__BackingField>0</d2p1:_x003C_FXPeriod2_x003E_k__BackingField>
      <d2p1:_x003C_FXPeriod3_x003E_k__BackingField>0</d2p1:_x003C_FXPeriod3_x003E_k__BackingField>
      <d2p1:_x003C_FXPeriod4_x003E_k__BackingField>0</d2p1:_x003C_FXPeriod4_x003E_k__BackingField>
      <d2p1:_x003C_Fax_x003E_k__BackingField>String</d2p1:_x003C_Fax_x003E_k__BackingField>
      <d2p1:_x003C_LastPaymentDate_x003E_k__BackingField>0001-01-01T00:00:00</d2p1:_x003C_LastPaymentDate_x003E_k__BackingField>
      <d2p1:_x003C_LastSaleDate_x003E_k__BackingField>0001-01-01T00:00:00</d2p1:_x003C_LastSaleDate_x003E_k__BackingField>
      <d2p1:_x003C_LastSavedDateTime_x003E_k__BackingField>0001-01-01T00:00:00</d2p1:_x003C_LastSavedDateTime_x003E_k__BackingField>
      <d2p1:_x003C_LedgerIDCreditorControl_x003E_k__BackingField>String</d2p1:_x003C_LedgerIDCreditorControl_x003E_k__BackingField>
      <d2p1:_x003C_LedgerIDCreditorDiscounts_x003E_k__BackingField>String</d2p1:_x003C_LedgerIDCreditorDiscounts_x003E_k__BackingField>
      <d2p1:_x003C_LedgerIDCreditorDuty_x003E_k__BackingField>String</d2p1:_x003C_LedgerIDCreditorDuty_x003E_k__BackingField>
      <d2p1:_x003C_LedgerIDCreditorFreight_x003E_k__BackingField>String</d2p1:_x003C_LedgerIDCreditorFreight_x003E_k__BackingField>
      <d2p1:_x003C_LedgerIDCreditorInsurance_x003E_k__BackingField>String</d2p1:_x003C_LedgerIDCreditorInsurance_x003E_k__BackingField>
      <d2p1:_x003C_LedgerIDCreditorPurchases_x003E_k__BackingField>String</d2p1:_x003C_LedgerIDCreditorPurchases_x003E_k__BackingField>
      <d2p1:_x003C_LedgerIDCreditorRealisedGainLoss_x003E_k__BackingField>String</d2p1:_x003C_LedgerIDCreditorRealisedGainLoss_x003E_k__BackingField>
      <d2p1:_x003C_LedgerIDCreditorSourcedCreditAdjustment_x003E_k__BackingField>String</d2p1:_x003C_LedgerIDCreditorSourcedCreditAdjustment_x003E_k__BackingField>
      <d2p1:_x003C_LedgerIDCreditorSourcedDebitAdjustment_x003E_k__BackingField>String</d2p1:_x003C_LedgerIDCreditorSourcedDebitAdjustment_x003E_k__BackingField>
      <d2p1:_x003C_LedgerIDCreditorSourcedPayments_x003E_k__BackingField>String</d2p1:_x003C_LedgerIDCreditorSourcedPayments_x003E_k__BackingField>
      <d2p1:_x003C_LedgerIDCreditorSourcedPurchase_x003E_k__BackingField>String</d2p1:_x003C_LedgerIDCreditorSourcedPurchase_x003E_k__BackingField>
      <d2p1:_x003C_LedgerIDCreditorUnRealisedGainLoss_x003E_k__BackingField>String</d2p1:_x003C_LedgerIDCreditorUnRealisedGainLoss_x003E_k__BackingField>
      <d2p1:_x003C_MaxPOValue_x003E_k__BackingField>0</d2p1:_x003C_MaxPOValue_x003E_k__BackingField>
      <d2p1:_x003C_MinPOValue_x003E_k__BackingField>0</d2p1:_x003C_MinPOValue_x003E_k__BackingField>
      <d2p1:_x003C_Name_x003E_k__BackingField>String</d2p1:_x003C_Name_x003E_k__BackingField>
      <d2p1:_x003C_PO_Workflows_RecID_x003E_k__BackingField>String</d2p1:_x003C_PO_Workflows_RecID_x003E_k__BackingField>
      <d2p1:_x003C_Period1_x003E_k__BackingField>0</d2p1:_x003C_Period1_x003E_k__BackingField>
      <d2p1:_x003C_Period2_x003E_k__BackingField>0</d2p1:_x003C_Period2_x003E_k__BackingField>
      <d2p1:_x003C_Period3_x003E_k__BackingField>0</d2p1:_x003C_Period3_x003E_k__BackingField>
      <d2p1:_x003C_Period4_x003E_k__BackingField>0</d2p1:_x003C_Period4_x003E_k__BackingField>
      <d2p1:_x003C_PeriodType_x003E_k__BackingField>0</d2p1:_x003C_PeriodType_x003E_k__BackingField>
      <d2p1:_x003C_Phone_x003E_k__BackingField>String</d2p1:_x003C_Phone_x003E_k__BackingField>
      <d2p1:_x003C_PostCode_x003E_k__BackingField>String</d2p1:_x003C_PostCode_x003E_k__BackingField>
      <d2p1:_x003C_ProprietorName_x003E_k__BackingField>String</d2p1:_x003C_ProprietorName_x003E_k__BackingField>
      <d2p1:_x003C_TermsDays_x003E_k__BackingField>0</d2p1:_x003C_TermsDays_x003E_k__BackingField>
      <d2p1:_x003C_TermsType_x003E_k__BackingField>0</d2p1:_x003C_TermsType_x003E_k__BackingField>
      <d2p1:_x003C_TradingName_x003E_k__BackingField>String</d2p1:_x003C_TradingName_x003E_k__BackingField>
      <d2p1:_x003C_TradingStatus_x003E_k__BackingField>0</d2p1:_x003C_TradingStatus_x003E_k__BackingField>
      <d2p1:_x003C_UsesFX_x003E_k__BackingField>false</d2p1:_x003C_UsesFX_x003E_k__BackingField>
    </d2p1:CR_Main>
  </Results>
  <Meta xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:KeyValueOfstringstring>
      <d2p1:Key>String</d2p1:Key>
      <d2p1:Value>String</d2p1:Value>
    </d2p1:KeyValueOfstringstring>
  </Meta>
  <ResponseStatus>
    <ErrorCode>String</ErrorCode>
    <Message>String</Message>
    <StackTrace>String</StackTrace>
    <Errors>
      <ResponseError>
        <ErrorCode>String</ErrorCode>
        <FieldName>String</FieldName>
        <Message>String</Message>
        <Meta xmlns:d5p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
          <d5p1:KeyValueOfstringstring>
            <d5p1:Key>String</d5p1:Key>
            <d5p1:Value>String</d5p1:Value>
          </d5p1:KeyValueOfstringstring>
        </Meta>
      </ResponseError>
    </Errors>
    <Meta xmlns:d3p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
      <d3p1:KeyValueOfstringstring>
        <d3p1:Key>String</d3p1:Key>
        <d3p1:Value>String</d3p1:Value>
      </d3p1:KeyValueOfstringstring>
    </Meta>
  </ResponseStatus>
</QueryResponseOfCR_Main7kRqkrSv>