ConsolidatedTransactionReportScheduleJobDtoFilter

Example Json Object

 1{
 2  "idIn": [
 3    0
 4  ],
 5  "idEqual": 0,
 6  "idLike": "string",
 7  "createdAtGreaterThanOrEqual": "2019-08-24T14:15:22Z",
 8  "createdAtLessThanOrEqual": "2019-08-24T14:15:22Z",
 9  "createdByLike": "string",
10  "createdByEqual": "string",
11  "modifiedAtGreaterThanOrEqual": "2019-08-24T14:15:22Z",
12  "modifiedAtLessThanOrEqual": "2019-08-24T14:15:22Z",
13  "modifiedByLike": "string",
14  "modifiedByEqual": "string",
15  "activeEqual": true,
16  "nameLike": "string",
17  "profileIdEqual": 0,
18  "uiSelector": "string",
19  "dateRangeTypeEqual": "DOCUMENT_DATE",
20  "ledgerTypesIn": [
21    "LIABILITY"
22  ],
23  "transactionTypeValuesIn": [
24    "string"
25  ],
26  "startDateEqual": "2019-08-24",
27  "endDateEqual": "2019-08-24",
28  "externalPostingStatusesIn": [
29    "NA"
30  ],
31  "businessAreasIn": [
32    {
33      "id": 0,
34      "displayId": "string",
35      "status": "CREATED",
36      "name": "string",
37      "erpSystemId": 0
38    }
39  ],
40  "functionalAreasIn": [
41    {
42      "id": 0,
43      "displayId": "string",
44      "status": "CREATED",
45      "name": "string",
46      "erpSystemId": 0
47    }
48  ]
49}

📄 Description: Data transfer object representing the filter criteria for scheduling consolidated transaction reports within the General Ledger, facilitating the management of ledger entries, transactions, accounts, and financial records.

Properties

Name

Type

Required

Restrictions

Description

idIn

[integer]

false

none

Filter by multiple values of id

idEqual

integer(int64)

false

none

Filter by exact match of id

idLike

string

false

none

Filter by partial match of id

createdAtGreaterThanOrEqual

string(date-time)

false

none

Filter where created at is greater than or equal to specified value

createdAtLessThanOrEqual

string(date-time)

false

none

Filter where created at is less than or equal to specified value

createdByLike

string

false

none

Filter by partial match of created by

createdByEqual

string

false

none

Filter by exact match of created by

modifiedAtGreaterThanOrEqual

string(date-time)

false

none

Filter where modified at is greater than or equal to specified value

modifiedAtLessThanOrEqual

string(date-time)

false

none

Filter where modified at is less than or equal to specified value

modifiedByLike

string

false

none

Filter by partial match of modified by

modifiedByEqual

string

false

none

Filter by exact match of modified by

activeEqual

boolean

false

none

Filter by exact match of active

nameLike

string

false

none

Filter by partial match of name

profileIdEqual

integer(int64)

false

none

Filter by exact match of profile id

uiSelector

string

false

none

Text value for uiSelector in ConsolidatedTransactionReportScheduleJobDtoFilter

dateRangeTypeEqual

string

false

none

Filter by exact match of date range type

ledgerTypesIn

[string]

false

none

Filter by multiple values of ledger types

transactionTypeValuesIn

[string]

false

none

Filter by multiple values of transaction type values

startDateEqual

string(date)

false

none

Filter by exact match of start date

endDateEqual

string(date)

false

none

Filter by exact match of end date

externalPostingStatusesIn

[string]

false

none

Filter by multiple values of external posting statuses

businessAreasIn

[BusinessAreaLite]

false

none

[Data transfer object representing a simplified view of a business area within the General Ledger, encompassing key attributes related to ledger entries, transactions, accounts, and financial records.]

functionalAreasIn

[FunctionalAreaLite]

false

none

[Data transfer object representing a simplified view of a functional area within the General Ledger, encompassing key attributes related to ledger entries, transactions, accounts, and financial records.]

Enumerated Values

Attribute

Value

dateRangeTypeEqual

DOCUMENT_DATE, POSTING_DATE, TRANSLATION_DATE, USER_DOCUMENT_DATE