Consolidated Transaction Report

Create

HTTP Request

POST /api/v1/general-ledger/consolidated-transaction-report

📋 Description: Generates a consolidated transaction report for ledger entries, providing a comprehensive overview of financial records across accounts within the General Ledger domain.

Parameters

Name

In

Type

Required

Description

body

body

ConsolidatedTransactionReportJobDto

true

Request body containing the consolidated transaction report data, including ledger entries, account details, and relevant financial records.

Responses

Status

Meaning

Description

Schema

200

OK

OK

ConsolidatedTransactionReportJobDto

Validate Reference Field IDs

HTTP Request

POST /api/v1/general-ledger/consolidated-transaction-report/reference-field/validate

📋 Description: Validates reference fields for consolidated transaction reports within the General Ledger, ensuring accuracy and compliance of ledger entries, transactions, and financial records associated with specific accounts.

Parameters

Name

In

Type

Required

Description

body

body

object

true

Request body containing the reference field data necessary for validating ledger entries and transactions within the consolidated transaction report.

» transactionReportJobDto

body

ConsolidatedTransactionReportJobDto

false

Data transfer object representing a consolidated transaction report job, encapsulating details related to ledger entries, transactions, accounts, and financial records for streamlined reporting and analysis within the General Ledger domain.

»» id

body

integer(int64)

false

Unique identifier for the resource

»» queueTime

body

string(date-time)

false

Time of the queue

»» startTime

body

string(date-time)

false

Time of the start

»» endTime

body

string(date-time)

false

Time of the end

»» interruptedAt

body

string(date-time)

false

Text value for interruptedAt in ConsolidatedTransactionReportJobDto

»» recoveredAt

body

string(date-time)

false

Text value for recoveredAt in ConsolidatedTransactionReportJobDto

»» status

body

string

false

Status of the resource

»» recover

body

boolean

false

Boolean flag indicating recover status

»» interrupted

body

boolean

false

Boolean flag indicating interrupted status

»» interruptionMessage

body

string

false

Text value for interruptionMessage in ConsolidatedTransactionReportJobDto

»» errorMessage

body

string

false

Text value for errorMessage in ConsolidatedTransactionReportJobDto

»» executor

body

string

false

Text value for executor in ConsolidatedTransactionReportJobDto

»» scheduleJobId

body

integer(int64)

false

Unique identifier for the schedule job

»» batchSize

body

integer(int32)

false

Numeric value representing batchSize

»» totalObjectCount

body

integer(int32)

false

Count of total object

»» readOnly

body

boolean

false

Boolean flag indicating readOnly status

»» profileId

body

integer(int64)

false

Unique identifier for the profile

»» fileStorageId

body

string

false

Unique identifier for the file storage

»» jsonFileStorageId

body

string

false

Unique identifier for the json file storage

»» generatingExportFile

body

boolean

false

Boolean flag indicating generatingExportFile status

»» startedGeneratingExportFileAt

body

string(date-time)

false

Text value for startedGeneratingExportFileAt in ConsolidatedTransactionReportJobDto

»» version

body

integer(int32)

false

Numeric value representing version

»» input

body

ConsolidatedTransactionReportJobInputDto

false

Data transfer object representing the input parameters for generating a consolidated transaction report within the General Ledger, encompassing ledger entries, transactions, accounts, and associated financial records.

»»» ledgerTypeFilterType

body

string

true

Type of the ledger type filter

»»» ledgerTypes

body

[string]

false

List of ledgerTypes items

»»» transactionTypeValueFilterType

body

string

true

Type of the transaction type value filter

»»» transactionTypeValues

body

[string]

false

List of transactionTypeValues items

»»» dateRangeType

body

string

true

Type of the date range

»»» startDate

body

string(date)

false

Start date of the resource

»»» endDate

body

string(date)

false

End date of the resource

»»» journalStateFilterType

body

string

true

Type of the journal state filter

»»» journalStates

body

[string]

false

List of journalStates items

»»» externalPostingStatusFilterType

body

string

true

Type of the external posting status filter

»»» externalPostingStatuses

body

[string]

false

List of externalPostingStatuses items

»»» businessAreaFilterType

body

string

true

none

»»» businessAreas

body

[BusinessAreaLite]

false

List of businessAreas items

»»»» id

body

integer(int64)

false

Unique identifier for the resource

»»»» displayId

body

string

false

Unique identifier for the display

»»»» status

body

string

false

Status of the resource

»»»» name

body

string

false

Name of the resource

»»»» erpSystemId

body

integer(int64)

false

none

»»» functionalAreaFilterType

body

string

true

none

»»» functionalAreas

body

[FunctionalAreaLite]

false

List of functionalAreas items

»»»» id

body

integer(int64)

false

Unique identifier for the resource

»»»» displayId

body

string

false

Unique identifier for the display

»»»» status

body

string

false

Status of the resource

»»»» name

body

string

false

Name of the resource

»»»» erpSystemId

body

integer(int64)

false

none

»»» migratedFilterType

body

string

true

Type of the migrated filter

»»» partnerFilterType

body

string

true

none

»»» partners

body

[PartnerLite]

false

[Data transfer object representing a simplified partner record within the General Ledger, encompassing essential details related to ledger entries, transactions, accounts, and financial records.]

»»»» id

body

integer(int64)

false

Unique identifier for the resource

»»»» displayId

body

string

false

Unique identifier for the display

»»»» status

body

string

false

Status of the resource

»»»» name

body

string

false

Name of the resource

»»»» erpSystemDisplayId

body

string

false

Unique identifier for the erp system display

»»» internalAssetClassFilterType

body

string

true

Type of the internal asset class filter

»»» internalAssetClasses

body

[InternalAssetClassLite]

false

List of internalAssetClasses items

»»»» id

body

integer(int64)

false

Unique identifier for the resource

»»»» displayId

body

string

false

Unique identifier for the display

»»»» status

body

string

false

Status of the resource

»»»» name

body

string

false

Name of the resource

»»»» assetClassType

body

string

false

Type of the asset class

»»»» infiniteUsefulLife

body

boolean

false

Boolean flag indicating infiniteUsefulLife status

»»» accountingStandardType

body

string

true

Type of the accounting standard

»»» leaseClassificationFilterType

body

string

true

Type of the lease classification filter

»»» classifications

body

[string]

false

List of classifications items

»»» referenceFieldType

body

string

false

Type of the reference field

»»» referenceFieldDisplayIds

body

[string]

false

List of referenceFieldDisplayIds items

»» filter

body

ConsolidatedTransactionReportJobFilterDto

false

Data transfer object representing the filters applied to generate a consolidated transaction report in the General Ledger, encompassing ledger entries, transactions, accounts, and financial records.

»»» id

body

integer(int64)

false

Unique identifier for the resource

»»» name

body

string

false

Name of the resource

»»» profileId

body

integer(int64)

false

Unique identifier for the profile

»»» calendarType

body

string

true

Type of the calendar

»»» fiscalVariant

body

FiscalVariantLite

false

Data transfer object representing a simplified fiscal variant used in general ledger entries, encapsulating essential details related to transactions, accounts, and financial records.

»»»» id

body

integer(int64)

false

Unique identifier for the resource

»»»» displayId

body

string

false

Unique identifier for the display

»»»» status

body

string

false

Status of the resource

»»»» isCalendarYear

body

boolean

false

Whether the resource is calendar year

»»»» yearDependent

body

boolean

false

Boolean flag indicating yearDependent status

»»»» erpSystemDisplayId

body

string

false

Unique identifier for the erp system display

»»»» isErpSystemDefault

body

boolean

false

Whether the resource is erp system default

»»» principalPositionType

body

string

true

Type of the principal position

»»» erpSystemFilterType

body

string

true

Type of the erp system filter

»»» erpSystems

body

[ErpSystemLite]

false

List of erpSystems items

»»»» id

body

integer(int64)

false

Unique identifier for the resource

»»»» displayId

body

string

false

Unique identifier for the display

»»»» status

body

string

false

Status of the resource

»»»» name

body

string

false

Name of the resource

»»»» type

body

string

false

Type of the resource

»»»» sapVersion

body

string

false

Text value for sapVersion in ErpSystemLite

»»» leaseAreaFilterType

body

string

true

Type of the lease area filter

»»» leaseAreas

body

[LeaseAreaLite]

false

List of leaseAreas items

»»»» id

body

integer(int64)

false

Unique identifier for the resource

»»»» displayId

body

string

false

Unique identifier for the display

»»»» status

body

string

false

Status of the resource

»»»» name

body

string

false

Name of the resource

»»» businessUnitFilterType

body

string

true

Type of the business unit filter

»»» businessUnits

body

[BusinessUnitLite]

false

List of businessUnits items

»»»» id

body

integer(int64)

false

Unique identifier for the resource

»»»» displayId

body

string

false

Unique identifier for the display

»»»» status

body

string

false

Status of the resource

»»»» name

body

string

false

Name of the resource

»»» companyFilterType

body

string

true

Type of the company filter

»»» companyCodes

body

[CompanyLite]

false

List of companyCodes items

»»»» id

body

integer(int64)

false

Unique identifier for the resource

»»»» displayId

body

string

false

Unique identifier for the display

»»»» status

body

string

false

Status of the resource

»»»» erpSystemId

body

integer(int64)

false

Unique identifier for the erp system

»»»» erpSystemDisplayId

body

string

false

Unique identifier for the erp system display

»»»» countryId

body

integer(int64)

false

Unique identifier for the country

»»»» countryDisplayId

body

string

false

Unique identifier for the country display

»»»» name

body

string

false

none

»»»» postingPeriodVariantId

body

integer(int64)

false

Unique identifier for the posting period variant

»»»» fiscalVariantId

body

integer(int64)

false

Unique identifier for the fiscal variant

»»» departmentFilterType

body

string

true

Type of the department filter

»»» leaseDepartments

body

[DepartmentLite]

false

List of leaseDepartments items

»»»» id

body

integer(int64)

false

Unique identifier for the resource

»»»» displayId

body

string

false

Unique identifier for the display

»»»» status

body

string

false

Status of the resource

»»»» name

body

string

false

Name of the resource

»»» leaseGroupFilterType

body

string

true

Type of the lease group filter

»»» leaseGroups

body

[LeaseGroupLite]

false

List of leaseGroups items

»»»» id

body

integer(int64)

false

Unique identifier for the resource

»»»» displayId

body

string

false

Unique identifier for the display

»»»» status

body

string

false

Status of the resource

»»»» name

body

string

false

Name of the resource

»»» costCenterFilterType

body

string

true

Type of the cost center filter

»»» costCenters

body

[CostCenterLite]

false

List of costCenters items

»»»» id

body

integer(int64)

false

Unique identifier for the resource

»»»» displayId

body

string

false

Unique identifier for the display

»»»» status

body

string

false

Status of the resource

»»»» name

body

string

false

Name of the resource

»»»» erpSystemId

body

integer(int64)

false

none

»»» profitCenterFilterType

body

string

true

Type of the profit center filter

»»» profitCenters

body

[ProfitCenterLite]

false

List of profitCenters items

»»»» id

body

integer(int64)

false

Unique identifier for the resource

»»»» displayId

body

string

false

Unique identifier for the display

»»»» status

body

string

false

Status of the resource

»»»» name

body

string

false

Name of the resource

»»»» validTo

body

string(date)

false

Date until which the resource is valid

»»»» erpSystemId

body

integer(int64)

false

Unique identifier for the erp system

»»»» erpSystemDisplayId

body

string

false

Unique identifier for the erp system display

»»» workBreakdownStructureFilterType

body

string

true

Type of the work breakdown structure filter

»»» workBreakdownStructures

body

[WorkBreakdownStructureLite]

false

List of workBreakdownStructures items

»»»» id

body

integer(int64)

false

Unique identifier for the resource

»»»» displayId

body

string

false

Unique identifier for the display

»»»» status

body

string

false

Status of the resource

»»»» name

body

string

false

Name of the resource

»»»» erpSystemId

body

integer(int64)

false

none

»» docStoreId

body

integer(int64)

false

Unique identifier for the doc store

»» jsonDocStoreIds

body

[integer]

false

List of jsonDocStoreIds items

» pageable

body

Pageable

false

Data transfer object representing a paginated collection of ledger entries, facilitating efficient retrieval and management of financial records, transactions, and account details within the General Ledger domain.

»» page

body

integer(int32)

false

Page number for pagination

»» size

body

integer(int32)

false

Number of items per page

»» sort

body

[string]

false

Sort order specification

Enumerated Values

Attribute

Value

»» executor

MANUAL, SCHEDULER

»» status

CANCELLED, CANCELLING, CREATED, CREATING, DONE, FAILED, INTERRUPTED, INTERRUPTING, KILLING, PENDING, PROCESSING, SCHEDULED

»»» accountingStandardType

GAAP, GASB_87, IFRS, OFF_BALANCE_SHEET

»»» businessAreaFilterType

ALL, LIST

»»» businessUnitFilterType

ALL, LIST

»»» calendarType

FISCAL_VARIANT, REGULAR_CALENDAR, _360

»»» classifications

DIRECT_FINANCING, FINANCE, LOW_VALUE, NON_LEASE, OFF_BALANCE_SHEET, OPERATING, PROVISIONING, SALES_TYPE, SERVICE_CONTRACT, SHORT_TERM

»»» companyFilterType

ALL, LIST

»»» costCenterFilterType

ALL, LIST

»»» dateRangeType

DOCUMENT_DATE, POSTING_DATE, TRANSLATION_DATE, USER_DOCUMENT_DATE

»»» departmentFilterType

ALL, LIST

»»» erpSystemFilterType

ALL, LIST

»»» externalPostingStatusFilterType

ALL, LIST

»»» externalPostingStatuses

, ARCHIVED, DONE, FAILED, OPEN, PROCESSING, SCHEDULED

»»» functionalAreaFilterType

ALL, LIST

»»» internalAssetClassFilterType

ALL, LIST

»»» journalStateFilterType

ALL, LIST

»»» journalStates

POST, REVERSE

»»» leaseAreaFilterType

ALL, LIST

»»» leaseClassificationFilterType

ALL, LIST

»»» leaseGroupFilterType

ALL, LIST

»»» ledgerTypeFilterType

ALL, LIST

»»» ledgerTypes

ACCRUAL, ASSET_CAPITALIZATION, CHARGE, CLEARING, DEPRECIATION, GRV, IDC, IMPAIRMENT, INCENTIVE, LIABILITY, LIABILITY_ADJUSTMENT, LIABILITY_ADJUSTMENT_DECREASE, LIABILITY_ADJUSTMENT_INCREASE, LIABILITY_ADJUSTMENT_INDEXATION_DECREASE, LIABILITY_ADJUSTMENT_INDEXATION_INCREASE, MODIFICATION_CAPITALIZATION, MODIFICATION_CAPITALIZATION_ASSET_DECREASE, MODIFICATION_CAPITALIZATION_ASSET_INCREASE, MODIFICATION_CAPITALIZATION_INDEXATION_ASSET_DECREASE, MODIFICATION_CAPITALIZATION_INDEXATION_ASSET_INCREASE, PAYMENT, PREPAID, PROVISIONING, RECLASSIFICATION_ASSET_TRANSFER, RECLASSIFICATION_NON_ASSET_TRANSFER, TERMINATION_ASSET, TERMINATION_CLOSED_LEDGER, TERMINATION_LIABILITY, TERMINATION_ROUNDING, URV, VOUCHER

»»» migratedFilterType

ALL, MIGRATED, NON_MIGRATED

»»» partnerFilterType

ALL, LIST

»»» principalPositionType

LESSEE, LESSOR

»»» profitCenterFilterType

ALL, LIST

»»» referenceFieldType

ACTIVATION_GROUP, CONTRACT, CONTRACT_EXTERNAL_ID, INVOICE, INVOICE_VENDOR, JOURNAL_ID, LEASE, LEASE_COMPONENT, LOCATION, PREMISE, UNIT

»»» transactionTypeValueFilterType

ALL, LIST

»»» workBreakdownStructureFilterType

ALL, LIST

»»»» assetClassType

EQUIPMENT, PLANT, PROPERTY

»»»» sapVersion

ECC_EHP5, ECC_EHP6, ECC_EHP7, ECC_EHP8, S4_1503, S4_1610, S4_1709, S4_1809, S4_1909

»»»» status

ACTIVE, CREATED, DECOMMISSIONED, DISABLED

»»»» type

NAKISA, SAP

Parameter Constraints

Parameter

Constraints

»» page

Min: 0

»» size

Min: 1

Responses

Status

Meaning

Description

Schema

200

OK

OK

PageString

Cancel

HTTP Request

POST /api/v1/general-ledger/consolidated-transaction-report/cancel/{id}

📋 Description: Cancels a specified consolidated transaction report in the General Ledger, effectively removing the associated ledger entry from financial records and ensuring accurate account management.

Parameters

Name

In

Type

Required

Description

id

path

integer(int64)

true

Unique identifier for the resource

Responses

Status

Meaning

Description

Schema

200

OK

OK

None

Generate Report To Standard Excel

HTTP Request

GET /api/v1/general-ledger/consolidated-transaction-report/generate_standard_report/{id}

📋 Description: Generates a standard consolidated transaction report for a specified ledger entry, providing a comprehensive overview of financial records associated with the given account. This operation allows users to access detailed transaction data for informed financial analysis and reporting.

Parameters

Name

In

Type

Required

Description

id

path

integer(int64)

true

Unique identifier for the resource

Responses

Status

Meaning

Description

Schema

200

OK

OK

None

Generate Report To Excel

HTTP Request

GET /api/v1/general-ledger/consolidated-transaction-report/generate_report/{id}

📋 Description: Generates a consolidated transaction report for a specified ledger entry, providing a comprehensive overview of financial records associated with the given account. This operation facilitates informed decision-making by delivering essential transaction data in a structured format.

Parameters

Name

In

Type

Required

Description

id

path

integer(int64)

true

Unique identifier for the resource

Responses

Status

Meaning

Description

Schema

200

OK

OK

None

Download Report To Excel

HTTP Request

GET /api/v1/general-ledger/consolidated-transaction-report/download_report/{id}

📋 Description: Downloads the consolidated transaction report for a specified ledger entry, providing a comprehensive overview of financial records associated with the given account. This operation facilitates efficient access to critical transaction data for financial analysis and reporting.

Parameters

Name

In

Type

Required

Description

id

path

integer(int64)

true

Unique identifier for the resource

Responses

Status

Meaning

Description

Schema

200

OK

OK

None

Delete By ID

HTTP Request

DELETE /api/v1/general-ledger/consolidated-transaction-report/{id}

📋 Description: Deletes a specified consolidated transaction report from the general ledger, ensuring that the associated financial records and ledger entries are accurately maintained.

Parameters

Name

In

Type

Required

Description

id

path

integer(int64)

true

Unique identifier for the resource

Responses

Status

Meaning

Description

Schema

200

OK

OK

None