JiwaAPI

<back to all web services

CR_MainQuery

Requires Authentication
The following routes are available for this service:
GET/Queries/CR_MainRetrieves a list of creditors.
CR_MainQuery Parameters:
NameParameterData TypeRequiredDescription
CreditorIDquerystringNo
CreditorIDStartsWithquerystringNo
CreditorIDEndsWithquerystringNo
CreditorIDContainsquerystringNo
CreditorIDLikequerystringNo
CreditorIDBetweenquerystring[]No
CreditorIDInquerystring[]No
LastSavedDateTimequeryDateTime?No
LastSavedDateTimeGreaterThanOrEqualToqueryDateTime?No
LastSavedDateTimeGreaterThanqueryDateTime?No
LastSavedDateTimeLessThanqueryDateTime?No
LastSavedDateTimeLessThanOrEqualToqueryDateTime?No
LastSavedDateTimeNotEqualToqueryDateTime?No
LastSavedDateTimeBetweenqueryNullable<DateTime>[]No
LastSavedDateTimeInqueryNullable<DateTime>[]No
AccountNoquerystringNo
AccountNoStartsWithquerystringNo
AccountNoEndsWithquerystringNo
AccountNoContainsquerystringNo
AccountNoLikequerystringNo
AccountNoBetweenquerystring[]No
AccountNoInquerystring[]No
NamequerystringNo
NameStartsWithquerystringNo
NameEndsWithquerystringNo
NameContainsquerystringNo
NameLikequerystringNo
NameBetweenquerystring[]No
NameInquerystring[]No
Address1querystringNo
Address1StartsWithquerystringNo
Address1EndsWithquerystringNo
Address1ContainsquerystringNo
Address1LikequerystringNo
Address1Betweenquerystring[]No
Address1Inquerystring[]No
Address2querystringNo
Address2StartsWithquerystringNo
Address2EndsWithquerystringNo
Address2ContainsquerystringNo
Address2LikequerystringNo
Address2Betweenquerystring[]No
Address2Inquerystring[]No
Address3querystringNo
Address3StartsWithquerystringNo
Address3EndsWithquerystringNo
Address3ContainsquerystringNo
Address3LikequerystringNo
Address3Betweenquerystring[]No
Address3Inquerystring[]No
Address4querystringNo
Address4StartsWithquerystringNo
Address4EndsWithquerystringNo
Address4ContainsquerystringNo
Address4LikequerystringNo
Address4Betweenquerystring[]No
Address4Inquerystring[]No
PostCodequerystringNo
PostCodeStartsWithquerystringNo
PostCodeEndsWithquerystringNo
PostCodeContainsquerystringNo
PostCodeLikequerystringNo
PostCodeBetweenquerystring[]No
PostCodeInquerystring[]No
PhonequerystringNo
PhoneStartsWithquerystringNo
PhoneEndsWithquerystringNo
PhoneContainsquerystringNo
PhoneLikequerystringNo
PhoneBetweenquerystring[]No
PhoneInquerystring[]No
FaxquerystringNo
FaxStartsWithquerystringNo
FaxEndsWithquerystringNo
FaxContainsquerystringNo
FaxLikequerystringNo
FaxBetweenquerystring[]No
FaxInquerystring[]No
BankNamequerystringNo
BankNameStartsWithquerystringNo
BankNameEndsWithquerystringNo
BankNameContainsquerystringNo
BankNameLikequerystringNo
BankNameBetweenquerystring[]No
BankNameInquerystring[]No
BankAccquerystringNo
BankAccStartsWithquerystringNo
BankAccEndsWithquerystringNo
BankAccContainsquerystringNo
BankAccLikequerystringNo
BankAccBetweenquerystring[]No
BankAccInquerystring[]No
BSBNquerystringNo
BSBNStartsWithquerystringNo
BSBNEndsWithquerystringNo
BSBNContainsquerystringNo
BSBNLikequerystringNo
BSBNBetweenquerystring[]No
BSBNInquerystring[]No
AccountNamequerystringNo
AccountNameStartsWithquerystringNo
AccountNameEndsWithquerystringNo
AccountNameContainsquerystringNo
AccountNameLikequerystringNo
AccountNameBetweenquerystring[]No
AccountNameInquerystring[]No
DefaultPaymentTypequerybyte?No
DefaultPaymentTypeGreaterThanOrEqualToquerybyte?No
DefaultPaymentTypeGreaterThanquerybyte?No
DefaultPaymentTypeLessThanquerybyte?No
DefaultPaymentTypeLessThanOrEqualToquerybyte?No
DefaultPaymentTypeNotEqualToquerybyte?No
DefaultPaymentTypeBetweenqueryNullable<Byte>[]No
DefaultPaymentTypeInqueryNullable<Byte>[]No
CreditLimitquerydecimal?No
CreditLimitGreaterThanOrEqualToquerydecimal?No
CreditLimitGreaterThanquerydecimal?No
CreditLimitLessThanquerydecimal?No
CreditLimitLessThanOrEqualToquerydecimal?No
CreditLimitNotEqualToquerydecimal?No
CreditLimitBetweenqueryNullable<Decimal>[]No
CreditLimitInqueryNullable<Decimal>[]No
EarlyPayDisOnRemitDaysqueryshort?No
EarlyPayDisOnRemitDaysGreaterThanOrEqualToqueryshort?No
EarlyPayDisOnRemitDaysGreaterThanqueryshort?No
EarlyPayDisOnRemitDaysLessThanqueryshort?No
EarlyPayDisOnRemitDaysLessThanOrEqualToqueryshort?No
EarlyPayDisOnRemitDaysNotEqualToqueryshort?No
EarlyPayDisOnRemitDaysBetweenqueryNullable<Int16>[]No
EarlyPayDisOnRemitDaysInqueryNullable<Int16>[]No
EarlyPayDisOnRemitAmtquerydecimal?No
EarlyPayDisOnRemitAmtGreaterThanOrEqualToquerydecimal?No
EarlyPayDisOnRemitAmtGreaterThanquerydecimal?No
EarlyPayDisOnRemitAmtLessThanquerydecimal?No
EarlyPayDisOnRemitAmtLessThanOrEqualToquerydecimal?No
EarlyPayDisOnRemitAmtNotEqualToquerydecimal?No
EarlyPayDisOnRemitAmtBetweenquerydecimal[]No
EarlyPayDisOnRemitAmtInquerydecimal[]No
LastSaleDatequeryDateTime?No
LastSaleDateGreaterThanOrEqualToqueryDateTime?No
LastSaleDateGreaterThanqueryDateTime?No
LastSaleDateLessThanqueryDateTime?No
LastSaleDateLessThanOrEqualToqueryDateTime?No
LastSaleDateNotEqualToqueryDateTime?No
LastSaleDateBetweenqueryNullable<DateTime>[]No
LastSaleDateInqueryNullable<DateTime>[]No
LastPaymentDatequeryDateTime?No
LastPaymentDateGreaterThanOrEqualToqueryDateTime?No
LastPaymentDateGreaterThanqueryDateTime?No
LastPaymentDateLessThanqueryDateTime?No
LastPaymentDateLessThanOrEqualToqueryDateTime?No
LastPaymentDateNotEqualToqueryDateTime?No
LastPaymentDateBetweenqueryNullable<DateTime>[]No
LastPaymentDateInqueryNullable<DateTime>[]No
ClassificationIDquerystringNo
ClassificationIDStartsWithquerystringNo
ClassificationIDEndsWithquerystringNo
ClassificationIDContainsquerystringNo
ClassificationIDLikequerystringNo
ClassificationIDBetweenquerystring[]No
ClassificationIDInquerystring[]No
AccountOnHoldquerybool?No
EmailAddressquerystringNo
EmailAddressStartsWithquerystringNo
EmailAddressEndsWithquerystringNo
EmailAddressContainsquerystringNo
EmailAddressLikequerystringNo
EmailAddressBetweenquerystring[]No
EmailAddressInquerystring[]No
CurrentBalancequerydecimal?No
CurrentBalanceGreaterThanOrEqualToquerydecimal?No
CurrentBalanceGreaterThanquerydecimal?No
CurrentBalanceLessThanquerydecimal?No
CurrentBalanceLessThanOrEqualToquerydecimal?No
CurrentBalanceNotEqualToquerydecimal?No
CurrentBalanceBetweenqueryNullable<Decimal>[]No
CurrentBalanceInqueryNullable<Decimal>[]No
Period1querydecimal?No
Period1GreaterThanOrEqualToquerydecimal?No
Period1GreaterThanquerydecimal?No
Period1LessThanquerydecimal?No
Period1LessThanOrEqualToquerydecimal?No
Period1NotEqualToquerydecimal?No
Period1Betweenquerydecimal[]No
Period1Inquerydecimal[]No
Period2querydecimal?No
Period2GreaterThanOrEqualToquerydecimal?No
Period2GreaterThanquerydecimal?No
Period2LessThanquerydecimal?No
Period2LessThanOrEqualToquerydecimal?No
Period2NotEqualToquerydecimal?No
Period2Betweenquerydecimal[]No
Period2Inquerydecimal[]No
Period3querydecimal?No
Period3GreaterThanOrEqualToquerydecimal?No
Period3GreaterThanquerydecimal?No
Period3LessThanquerydecimal?No
Period3LessThanOrEqualToquerydecimal?No
Period3NotEqualToquerydecimal?No
Period3Betweenquerydecimal[]No
Period3Inquerydecimal[]No
Period4querydecimal?No
Period4GreaterThanOrEqualToquerydecimal?No
Period4GreaterThanquerydecimal?No
Period4LessThanquerydecimal?No
Period4LessThanOrEqualToquerydecimal?No
Period4NotEqualToquerydecimal?No
Period4Betweenquerydecimal[]No
Period4Inquerydecimal[]No
AltAccountNoquerystringNo
AltAccountNoStartsWithquerystringNo
AltAccountNoEndsWithquerystringNo
AltAccountNoContainsquerystringNo
AltAccountNoLikequerystringNo
AltAccountNoBetweenquerystring[]No
AltAccountNoInquerystring[]No
CommenceDatequeryDateTime?No
CommenceDateGreaterThanOrEqualToqueryDateTime?No
CommenceDateGreaterThanqueryDateTime?No
CommenceDateLessThanqueryDateTime?No
CommenceDateLessThanOrEqualToqueryDateTime?No
CommenceDateNotEqualToqueryDateTime?No
CommenceDateBetweenqueryNullable<DateTime>[]No
CommenceDateInqueryNullable<DateTime>[]No
TermsDaysqueryshort?No
TermsDaysGreaterThanOrEqualToqueryshort?No
TermsDaysGreaterThanqueryshort?No
TermsDaysLessThanqueryshort?No
TermsDaysLessThanOrEqualToqueryshort?No
TermsDaysNotEqualToqueryshort?No
TermsDaysBetweenqueryNullable<Int16>[]No
TermsDaysInqueryNullable<Int16>[]No
ACNquerystringNo
ACNStartsWithquerystringNo
ACNEndsWithquerystringNo
ACNContainsquerystringNo
ACNLikequerystringNo
ACNBetweenquerystring[]No
ACNInquerystring[]No
CurrencyIDquerystringNo
CurrencyIDStartsWithquerystringNo
CurrencyIDEndsWithquerystringNo
CurrencyIDContainsquerystringNo
CurrencyIDLikequerystringNo
CurrencyIDBetweenquerystring[]No
CurrencyIDInquerystring[]No
UsesFXquerybool?No
ABNquerystringNo
ABNStartsWithquerystringNo
ABNEndsWithquerystringNo
ABNContainsquerystringNo
ABNLikequerystringNo
ABNBetweenquerystring[]No
ABNInquerystring[]No
TermsTypequerybyte?No
TermsTypeGreaterThanOrEqualToquerybyte?No
TermsTypeGreaterThanquerybyte?No
TermsTypeLessThanquerybyte?No
TermsTypeLessThanOrEqualToquerybyte?No
TermsTypeNotEqualToquerybyte?No
TermsTypeBetweenqueryNullable<Byte>[]No
TermsTypeInqueryNullable<Byte>[]No
AustPostDPIDquerystringNo
AustPostDPIDStartsWithquerystringNo
AustPostDPIDEndsWithquerystringNo
AustPostDPIDContainsquerystringNo
AustPostDPIDLikequerystringNo
AustPostDPIDBetweenquerystring[]No
AustPostDPIDInquerystring[]No
AustPostBCSPquerystringNo
AustPostBCSPStartsWithquerystringNo
AustPostBCSPEndsWithquerystringNo
AustPostBCSPContainsquerystringNo
AustPostBCSPLikequerystringNo
AustPostBCSPBetweenquerystring[]No
AustPostBCSPInquerystring[]No
MinPOValuequerydecimal?No
MinPOValueGreaterThanOrEqualToquerydecimal?No
MinPOValueGreaterThanquerydecimal?No
MinPOValueLessThanquerydecimal?No
MinPOValueLessThanOrEqualToquerydecimal?No
MinPOValueNotEqualToquerydecimal?No
MinPOValueBetweenquerydecimal[]No
MinPOValueInquerydecimal[]No
MaxPOValuequerydecimal?No
MaxPOValueGreaterThanOrEqualToquerydecimal?No
MaxPOValueGreaterThanquerydecimal?No
MaxPOValueLessThanquerydecimal?No
MaxPOValueLessThanOrEqualToquerydecimal?No
MaxPOValueNotEqualToquerydecimal?No
MaxPOValueBetweenquerydecimal[]No
MaxPOValueInquerydecimal[]No
PeriodTypequeryshort?No
PeriodTypeGreaterThanOrEqualToqueryshort?No
PeriodTypeGreaterThanqueryshort?No
PeriodTypeLessThanqueryshort?No
PeriodTypeLessThanOrEqualToqueryshort?No
PeriodTypeNotEqualToqueryshort?No
PeriodTypeBetweenqueryNullable<Int16>[]No
PeriodTypeInqueryNullable<Int16>[]No
TradingNamequerystringNo
TradingNameStartsWithquerystringNo
TradingNameEndsWithquerystringNo
TradingNameContainsquerystringNo
TradingNameLikequerystringNo
TradingNameBetweenquerystring[]No
TradingNameInquerystring[]No
CompanyNamequerystringNo
CompanyNameStartsWithquerystringNo
CompanyNameEndsWithquerystringNo
CompanyNameContainsquerystringNo
CompanyNameLikequerystringNo
CompanyNameBetweenquerystring[]No
CompanyNameInquerystring[]No
ProprietorNamequerystringNo
ProprietorNameStartsWithquerystringNo
ProprietorNameEndsWithquerystringNo
ProprietorNameContainsquerystringNo
ProprietorNameLikequerystringNo
ProprietorNameBetweenquerystring[]No
ProprietorNameInquerystring[]No
FXCurrentBalancequerydecimal?No
FXCurrentBalanceGreaterThanOrEqualToquerydecimal?No
FXCurrentBalanceGreaterThanquerydecimal?No
FXCurrentBalanceLessThanquerydecimal?No
FXCurrentBalanceLessThanOrEqualToquerydecimal?No
FXCurrentBalanceNotEqualToquerydecimal?No
FXCurrentBalanceBetweenquerydecimal[]No
FXCurrentBalanceInquerydecimal[]No
FXPeriod1querydecimal?No
FXPeriod1GreaterThanOrEqualToquerydecimal?No
FXPeriod1GreaterThanquerydecimal?No
FXPeriod1LessThanquerydecimal?No
FXPeriod1LessThanOrEqualToquerydecimal?No
FXPeriod1NotEqualToquerydecimal?No
FXPeriod1Betweenquerydecimal[]No
FXPeriod1Inquerydecimal[]No
FXPeriod2querydecimal?No
FXPeriod2GreaterThanOrEqualToquerydecimal?No
FXPeriod2GreaterThanquerydecimal?No
FXPeriod2LessThanquerydecimal?No
FXPeriod2LessThanOrEqualToquerydecimal?No
FXPeriod2NotEqualToquerydecimal?No
FXPeriod2Betweenquerydecimal[]No
FXPeriod2Inquerydecimal[]No
FXPeriod3querydecimal?No
FXPeriod3GreaterThanOrEqualToquerydecimal?No
FXPeriod3GreaterThanquerydecimal?No
FXPeriod3LessThanquerydecimal?No
FXPeriod3LessThanOrEqualToquerydecimal?No
FXPeriod3NotEqualToquerydecimal?No
FXPeriod3Betweenquerydecimal[]No
FXPeriod3Inquerydecimal[]No
FXPeriod4querydecimal?No
FXPeriod4GreaterThanOrEqualToquerydecimal?No
FXPeriod4GreaterThanquerydecimal?No
FXPeriod4LessThanquerydecimal?No
FXPeriod4LessThanOrEqualToquerydecimal?No
FXPeriod4NotEqualToquerydecimal?No
FXPeriod4Betweenquerydecimal[]No
FXPeriod4Inquerydecimal[]No
TradingStatusquerybyte?No
TradingStatusGreaterThanOrEqualToquerybyte?No
TradingStatusGreaterThanquerybyte?No
TradingStatusLessThanquerybyte?No
TradingStatusLessThanOrEqualToquerybyte?No
TradingStatusNotEqualToquerybyte?No
TradingStatusBetweenqueryNullable<Byte>[]No
TradingStatusInqueryNullable<Byte>[]No
LedgerIDCreditorControlquerystringNo
LedgerIDCreditorControlStartsWithquerystringNo
LedgerIDCreditorControlEndsWithquerystringNo
LedgerIDCreditorControlContainsquerystringNo
LedgerIDCreditorControlLikequerystringNo
LedgerIDCreditorControlBetweenquerystring[]No
LedgerIDCreditorControlInquerystring[]No
LedgerIDCreditorPurchasesquerystringNo
LedgerIDCreditorPurchasesStartsWithquerystringNo
LedgerIDCreditorPurchasesEndsWithquerystringNo
LedgerIDCreditorPurchasesContainsquerystringNo
LedgerIDCreditorPurchasesLikequerystringNo
LedgerIDCreditorPurchasesBetweenquerystring[]No
LedgerIDCreditorPurchasesInquerystring[]No
LedgerIDCreditorDiscountsquerystringNo
LedgerIDCreditorDiscountsStartsWithquerystringNo
LedgerIDCreditorDiscountsEndsWithquerystringNo
LedgerIDCreditorDiscountsContainsquerystringNo
LedgerIDCreditorDiscountsLikequerystringNo
LedgerIDCreditorDiscountsBetweenquerystring[]No
LedgerIDCreditorDiscountsInquerystring[]No
LedgerIDCreditorSourcedPaymentsquerystringNo
LedgerIDCreditorSourcedPaymentsStartsWithquerystringNo
LedgerIDCreditorSourcedPaymentsEndsWithquerystringNo
LedgerIDCreditorSourcedPaymentsContainsquerystringNo
LedgerIDCreditorSourcedPaymentsLikequerystringNo
LedgerIDCreditorSourcedPaymentsBetweenquerystring[]No
LedgerIDCreditorSourcedPaymentsInquerystring[]No
LedgerIDCreditorSourcedDebitAdjustmentquerystringNo
LedgerIDCreditorSourcedDebitAdjustmentStartsWithquerystringNo
LedgerIDCreditorSourcedDebitAdjustmentEndsWithquerystringNo
LedgerIDCreditorSourcedDebitAdjustmentContainsquerystringNo
LedgerIDCreditorSourcedDebitAdjustmentLikequerystringNo
LedgerIDCreditorSourcedDebitAdjustmentBetweenquerystring[]No
LedgerIDCreditorSourcedDebitAdjustmentInquerystring[]No
LedgerIDCreditorSourcedPurchasequerystringNo
LedgerIDCreditorSourcedPurchaseStartsWithquerystringNo
LedgerIDCreditorSourcedPurchaseEndsWithquerystringNo
LedgerIDCreditorSourcedPurchaseContainsquerystringNo
LedgerIDCreditorSourcedPurchaseLikequerystringNo
LedgerIDCreditorSourcedPurchaseBetweenquerystring[]No
LedgerIDCreditorSourcedPurchaseInquerystring[]No
LedgerIDCreditorSourcedCreditAdjustmentquerystringNo
LedgerIDCreditorSourcedCreditAdjustmentStartsWithquerystringNo
LedgerIDCreditorSourcedCreditAdjustmentEndsWithquerystringNo
LedgerIDCreditorSourcedCreditAdjustmentContainsquerystringNo
LedgerIDCreditorSourcedCreditAdjustmentLikequerystringNo
LedgerIDCreditorSourcedCreditAdjustmentBetweenquerystring[]No
LedgerIDCreditorSourcedCreditAdjustmentInquerystring[]No
LedgerIDCreditorFreightquerystringNo
LedgerIDCreditorFreightStartsWithquerystringNo
LedgerIDCreditorFreightEndsWithquerystringNo
LedgerIDCreditorFreightContainsquerystringNo
LedgerIDCreditorFreightLikequerystringNo
LedgerIDCreditorFreightBetweenquerystring[]No
LedgerIDCreditorFreightInquerystring[]No
LedgerIDCreditorInsurancequerystringNo
LedgerIDCreditorInsuranceStartsWithquerystringNo
LedgerIDCreditorInsuranceEndsWithquerystringNo
LedgerIDCreditorInsuranceContainsquerystringNo
LedgerIDCreditorInsuranceLikequerystringNo
LedgerIDCreditorInsuranceBetweenquerystring[]No
LedgerIDCreditorInsuranceInquerystring[]No
LedgerIDCreditorDutyquerystringNo
LedgerIDCreditorDutyStartsWithquerystringNo
LedgerIDCreditorDutyEndsWithquerystringNo
LedgerIDCreditorDutyContainsquerystringNo
LedgerIDCreditorDutyLikequerystringNo
LedgerIDCreditorDutyBetweenquerystring[]No
LedgerIDCreditorDutyInquerystring[]No
LedgerIDCreditorRealisedGainLossquerystringNo
LedgerIDCreditorRealisedGainLossStartsWithquerystringNo
LedgerIDCreditorRealisedGainLossEndsWithquerystringNo
LedgerIDCreditorRealisedGainLossContainsquerystringNo
LedgerIDCreditorRealisedGainLossLikequerystringNo
LedgerIDCreditorRealisedGainLossBetweenquerystring[]No
LedgerIDCreditorRealisedGainLossInquerystring[]No
LedgerIDCreditorUnRealisedGainLossquerystringNo
LedgerIDCreditorUnRealisedGainLossStartsWithquerystringNo
LedgerIDCreditorUnRealisedGainLossEndsWithquerystringNo
LedgerIDCreditorUnRealisedGainLossContainsquerystringNo
LedgerIDCreditorUnRealisedGainLossLikequerystringNo
LedgerIDCreditorUnRealisedGainLossBetweenquerystring[]No
LedgerIDCreditorUnRealisedGainLossInquerystring[]No
PO_Workflows_RecIDquerystringNo
PO_Workflows_RecIDStartsWithquerystringNo
PO_Workflows_RecIDEndsWithquerystringNo
PO_Workflows_RecIDContainsquerystringNo
PO_Workflows_RecIDLikequerystringNo
PO_Workflows_RecIDBetweenquerystring[]No
PO_Workflows_RecIDInquerystring[]No
CountryquerystringNo
CountryStartsWithquerystringNo
CountryEndsWithquerystringNo
CountryContainsquerystringNo
CountryLikequerystringNo
CountryBetweenquerystring[]No
CountryInquerystring[]No
QueryBase Parameters:
NameParameterData TypeRequiredDescription
Skipformint?No
Takeformint?No
OrderByformstringNo
OrderByDescformstringNo
IncludeformstringNo
FieldsformstringNo
MetaformDictionary<string, string>No
CR_Main Parameters:
NameParameterData TypeRequiredDescription
CreditorIDformstringNo
LastSavedDateTimeformDateTime?No
AccountNoformstringNo
NameformstringNo
Address1formstringNo
Address2formstringNo
Address3formstringNo
Address4formstringNo
PostCodeformstringNo
PhoneformstringNo
FaxformstringNo
BankNameformstringNo
BankAccformstringNo
BSBNformstringNo
AccountNameformstringNo
DefaultPaymentTypeformbyte?No
CreditLimitformdecimal?No
EarlyPayDisOnRemitDaysformshort?No
EarlyPayDisOnRemitAmtformdecimalNo
LastSaleDateformDateTime?No
LastPaymentDateformDateTime?No
ClassificationIDformstringNo
AccountOnHoldformboolNo
EmailAddressformstringNo
CurrentBalanceformdecimal?No
Period1formdecimalNo
Period2formdecimalNo
Period3formdecimalNo
Period4formdecimalNo
AltAccountNoformstringNo
CommenceDateformDateTime?No
TermsDaysformshort?No
ACNformstringNo
CurrencyIDformstringNo
UsesFXformboolNo
ABNformstringNo
TermsTypeformbyte?No
AustPostDPIDformstringNo
AustPostBCSPformstringNo
MinPOValueformdecimalNo
MaxPOValueformdecimalNo
PeriodTypeformshort?No
TradingNameformstringNo
CompanyNameformstringNo
ProprietorNameformstringNo
FXCurrentBalanceformdecimalNo
FXPeriod1formdecimalNo
FXPeriod2formdecimalNo
FXPeriod3formdecimalNo
FXPeriod4formdecimalNo
TradingStatusformbyte?No
LedgerIDCreditorControlformstringNo
LedgerIDCreditorPurchasesformstringNo
LedgerIDCreditorDiscountsformstringNo
LedgerIDCreditorSourcedPaymentsformstringNo
LedgerIDCreditorSourcedDebitAdjustmentformstringNo
LedgerIDCreditorSourcedPurchaseformstringNo
LedgerIDCreditorSourcedCreditAdjustmentformstringNo
LedgerIDCreditorFreightformstringNo
LedgerIDCreditorInsuranceformstringNo
LedgerIDCreditorDutyformstringNo
LedgerIDCreditorRealisedGainLossformstringNo
LedgerIDCreditorUnRealisedGainLossformstringNo
PO_Workflows_RecIDformstringNo
CountryformstringNo
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 .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/CR_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":[{"CreditorID":"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","DefaultPaymentType":0,"CreditLimit":0,"EarlyPayDisOnRemitDays":0,"LastSaleDate":"0001-01-01T00:00:00.0000000","LastPaymentDate":"0001-01-01T00:00:00.0000000","ClassificationID":"String","EmailAddress":"String","CurrentBalance":0,"AltAccountNo":"String","CommenceDate":"0001-01-01T00:00:00.0000000","TermsDays":0,"ACN":"String","CurrencyID":"String","ABN":"String","TermsType":0,"AustPostDPID":"String","AustPostBCSP":"String","PeriodType":0,"TradingName":"String","CompanyName":"String","ProprietorName":"String","TradingStatus":0,"LedgerIDCreditorControl":"String","LedgerIDCreditorPurchases":"String","LedgerIDCreditorDiscounts":"String","LedgerIDCreditorSourcedPayments":"String","LedgerIDCreditorSourcedDebitAdjustment":"String","LedgerIDCreditorSourcedPurchase":"String","LedgerIDCreditorSourcedCreditAdjustment":"String","LedgerIDCreditorFreight":"String","LedgerIDCreditorInsurance":"String","LedgerIDCreditorDuty":"String","LedgerIDCreditorRealisedGainLoss":"String","LedgerIDCreditorUnRealisedGainLoss":"String","PO_Workflows_RecID":"String","Country":"String"}],"Meta":{"String":"String"},"ResponseStatus":{"ErrorCode":"String","Message":"String","StackTrace":"String","Errors":[{"ErrorCode":"String","FieldName":"String","Message":"String","Meta":{"String":"String"}}],"Meta":{"String":"String"}}}