Skip to main content

Gljournalentryfiltercriteria

Represents the filtering criteria used for searching general ledger journal entries.

fieldstringrequired

The fields used to search. These fields can be from the enumerated values or you can specify a custom field using the format [customFieldSetId].[customFieldId].

Possible values: [productType, glAccountKey, userKey, encodedKey, entryId, bookingDate, creationDate, transactionId, glAccountId, glAccountType, source, debit, credit, foreignDebit, foreignCredit, loanAccountId, foreignCurrencyCode, assignedBranchKey]

operatorstringrequired
OperatorAffected valuesAvailable for
EQUALSONE_VALUEBIG_DECIMAL,BOOLEAN,LONG,MONEY,NUMBER,PERCENT,STRING,ENUM,KEY
EQUALS_CASE_SENSITIVEONE_VALUEBIG_DECIMAL,BOOLEAN,LONG,MONEY,NUMBER,PERCENT,STRING,ENUM,KEY
MORE_THANONE_VALUEBIG_DECIMAL,NUMBER,MONEY
LESS_THANONE_VALUEBIG_DECIMAL,NUMBER,MONEY
BETWEENTWO_VALUESBIG_DECIMAL,NUMBER,MONEY,DATE,DATE_TIME
ONONE_VALUEDATE,DATE_TIME
AFTERONE_VALUEDATE,DATE_TIME
BEFOREONE_VALUEDATE,DATE_TIME
BEFORE_INCLUSIVEONE_VALUEDATE,DATE_TIME
STARTS_WITHONE_VALUESTRING
STARTS_WITH_CASE_SENSITIVEONE_VALUESTRING
INLISTENUM,KEY
TODAYNO_VALUEDATE,DATE_TIME
THIS_WEEKNO_VALUEDATE,DATE_TIME
THIS_MONTHNO_VALUEDATE,DATE_TIME
THIS_YEARNO_VALUEDATE,DATE_TIME
LAST_DAYSONE_VALUENUMBER
EMPTYNO_VALUEBIG_DECIMAL,LONG,MONEY,NUMBER,PERCENT,STRING,ENUM,KEY,DATE,DATE_TIME
NOT_EMPTYNO_VALUEBIG_DECIMAL,LONG,MONEY,NUMBER,PERCENT,STRING,ENUM,KEY,DATE,DATE_TIME

Possible values: [EQUALS, EQUALS_CASE_SENSITIVE, DIFFERENT_THAN, MORE_THAN, LESS_THAN, BETWEEN, ON, AFTER, AFTER_INCLUSIVE, BEFORE, BEFORE_INCLUSIVE, STARTS_WITH, STARTS_WITH_CASE_SENSITIVE, IN, TODAY, THIS_WEEK, THIS_MONTH, THIS_YEAR, LAST_DAYS, EMPTY, NOT_EMPTY]

secondValuestring

The second value to match the searching criteria, when the BETWEEN operator is used.

valuestring

The value to match the searching criteria.

valuesstring[]

List of values when the IN operator is used.

Gljournalentryfiltercriteria
{
"field": "productType",
"operator": "EQUALS",
"secondValue": "string",
"value": "string",
"values": [
"string"
]
}