--- title: "Filter payment terms" method: POST path: "/payment-terms/filter" tags: ["Payment Terms"] --- # Filter payment terms `POST /payment-terms/filter` Filter payment terms using comprehensive query criteria with AND/OR logic and multiple operators. Supports complex filtering similar to GraphQL capabilities. Note: Soft-deleted payment terms are excluded by default (deletedAt defaults to { isNull: true }). ## Request body - PaymentTermFilterRequest — Request body for filtering payment terms - `filter` PaymentTermFilter — Filter criteria for payment terms with AND/OR logic support - `and` PaymentTermFilter[] — All conditions must match (recursive) - `or` PaymentTermFilter[] — At least one condition must match (recursive) - `not` PaymentTermFilter — recursive - `id` IDFilter — Filter options for ID fields (limited operations - exact match only) - `equalTo` string, uuid — Exact match - `in` string[] — Matches any UUID in the array - `name` StringFilter — Filter options for string fields - `equalTo` string — Exact match - `notEqualTo` string — Not equal to - `in` string[] — Matches any value in the array - `notIn` string[] — Does not match any value in the array - `includes` string — Contains substring (case-insensitive) - `notIncludes` string — Does not contain substring (case-insensitive) - `startsWith` string — Starts with prefix (case-insensitive) - `notStartsWith` string — Does not start with prefix (case-insensitive) - `endsWith` string — Ends with suffix (case-insensitive) - `notEndsWith` string — Does not end with suffix (case-insensitive) - `isNull` boolean — Field is null (true) or not null (false) - `description` StringFilter — Filter options for string fields - `equalTo` string — Exact match - `notEqualTo` string — Not equal to - `in` string[] — Matches any value in the array - `notIn` string[] — Does not match any value in the array - `includes` string — Contains substring (case-insensitive) - `notIncludes` string — Does not contain substring (case-insensitive) - `startsWith` string — Starts with prefix (case-insensitive) - `notStartsWith` string — Does not start with prefix (case-insensitive) - `endsWith` string — Ends with suffix (case-insensitive) - `notEndsWith` string — Does not end with suffix (case-insensitive) - `isNull` boolean — Field is null (true) or not null (false) - `days` IntFilter — Filter options for integer fields - `equalTo` integer — Exact match - `notEqualTo` integer — Not equal to - `lessThan` integer — Less than - `lessThanOrEqualTo` integer — Less than or equal to - `greaterThan` integer — Greater than - `greaterThanOrEqualTo` integer — Greater than or equal to - `in` integer[] — Matches any value in the array - `notIn` integer[] — Does not match any value in the array - `isNull` boolean — Field is null (true) or not null (false) - `quickPayFee` FloatFilter — Filter options for float/number fields - `equalTo` number, float — Exact match - `notEqualTo` number, float — Not equal to - `lessThan` number, float — Less than - `lessThanOrEqualTo` number, float — Less than or equal to - `greaterThan` number, float — Greater than - `greaterThanOrEqualTo` number, float — Greater than or equal to - `isNull` boolean — Field is null (true) or not null (false) - `apOnly` BooleanFilter — Filter options for boolean fields - `equalTo` boolean — Exact match - `notEqualTo` boolean — Not equal to - `isNull` boolean — Field is null (true) or not null (false) - `doNotUse` BooleanFilter — Filter options for boolean fields - `equalTo` boolean — Exact match - `notEqualTo` boolean — Not equal to - `isNull` boolean — Field is null (true) or not null (false) - `key` ClientKeyFilter — Filter options for client key fields (limited operations - exact match only) - `equalTo` string — Exact match - `in` string[] — Matches any value in the array - `isNull` boolean — Field is null (true) or not null (false) - `createdAt` DatetimeFilter — Filter options for datetime fields - `equalTo` string, date-time — Exact match - `notEqualTo` string, date-time — Not equal to - `lessThan` string, date-time — Before this datetime - `lessThanOrEqualTo` string, date-time — On or before this datetime - `greaterThan` string, date-time — After this datetime - `greaterThanOrEqualTo` string, date-time — On or after this datetime - `isNull` boolean — Field is null (true) or not null (false) - `updatedAt` DatetimeFilter — Filter options for datetime fields - `equalTo` string, date-time — Exact match - `notEqualTo` string, date-time — Not equal to - `lessThan` string, date-time — Before this datetime - `lessThanOrEqualTo` string, date-time — On or before this datetime - `greaterThan` string, date-time — After this datetime - `greaterThanOrEqualTo` string, date-time — On or after this datetime - `isNull` boolean — Field is null (true) or not null (false) - `deletedAt` DatetimeFilter — Filter options for datetime fields - `equalTo` string, date-time — Exact match - `notEqualTo` string, date-time — Not equal to - `lessThan` string, date-time — Before this datetime - `lessThanOrEqualTo` string, date-time — On or before this datetime - `greaterThan` string, date-time — After this datetime - `greaterThanOrEqualTo` string, date-time — On or after this datetime - `isNull` boolean — Field is null (true) or not null (false) - `pageSize` integer — Number of results per page - `cursor` string — Pagination cursor for next page ## Response `200` Successful response - object - `data` PaymentTerm[] - `id` string, uuid, required — Unique payment term identifier - `name` string, required — Payment term name - `description` string, nullable — Payment term description or notes - `days` integer, nullable — Number of days until payment is due - `quickPayFee` number, float, nullable — Quick pay fee percentage (e.g., 0.05 for 5%) - `apOnly` boolean, nullable — Whether this payment term is for accounts payable only - `doNotUse` boolean, nullable — Flag to prevent using this payment term for new transactions - `key` string, nullable — Client-defined reference identifier - `createdAt` string, date-time, required — When the payment term was created - `updatedAt` string, date-time, required — When the payment term was last updated - `deletedAt` string, date-time, nullable — When the payment term was soft deleted (null if active) - `pagination` PaginationInfo - `pageSize` integer, required — Number of items per page - `hasNextPage` boolean, required — Whether there are more pages - `hasPreviousPage` boolean — Whether there are previous pages - `endCursor` string, nullable — Cursor for the next page (null if no next page) ## Other responses - `400` — Bad request - invalid input - `401` — Unauthorized - invalid or missing access token - `422` — Validation error - invalid field values - `429` — Rate limit exceeded --- [API](https://skmtc.dev/mvmnt/apis/mvmnt-api.md) · [All operations](https://skmtc.dev/mvmnt/apis/mvmnt-api/llms.txt) · [OpenAPI document](https://skmtc-service-production.skmtc.workers.dev/v1/apis/mvmnt/mvmnt-api/revisions/7af4e91459ca/schema)