PayrollRunBalanceSheetByPayrollRunId__embeddedJournalAllocationAsJson: Loket.nl REST itgen_loketnl_payrollrunbalancesheetbypayrollrunid__embeddedjournalallocationasjson_plural
read only REST
- Catalog:
LoketNlRest - Schema:
PayrollRunDownloads - Label: itgen_loketnl_payrollrunbalancesheetbypayrollrunid__embeddedjournalallocationasjson_plural
Get payroll run balance sheet Activity name : GetPayrollRunBalanceSheetByPayrollRunId
This endpoint returns per payroll components, marked as relevant for the general ledge (balance sheet), the sum of the values.
If for the given payroll period of the payroll run a "journal profile" is configured the endpoint also returns the ledger account and costcenter/costunit linked to the given payroll component in the "journal profile"
Can only retrieve data.
API Source
- Endpoint:
/providers/employers/payrolladministrations/payrollruns/{payrollrunId}/BalanceSheet - Operation:
get /providers/employers/payrolladministrations/payrollruns/{payrollrunId}/BalanceSheet
Parameters
| Name | Data Type | Required | Default | Documentation |
|---|---|---|---|---|
payrollrun |
`` | The unique identifier of the payroll run |
Table Columns
The columns of the table PayrollRunBalanceSheetByPayrollRunId__embeddedJournalAllocationAsJson are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.
| Name | Data Type | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
cost |
varchar2 |
Cost Centre Code | The code of the cost center | ||
cost |
int32 |
Cost Centre Key | The key of the cost center | ||
cost |
varchar2 |
itgen_loketnl_costcenter_value | The description of the cost center | ||
cost |
varchar2 |
Cost Unit Code | The code of the cost unit | ||
cost |
int32 |
Cost Unit Key | The key of the cost unit | ||
cost |
varchar2 |
itgen_loketnl_costunit_value | The description of the cost unit | ||
general |
varchar2 |
itgen_loketnl_generalledgeraccount_generalledgeraccountnumber | The account number for the general ledger account | ||
general |
int32 |
General Ledger Account Key | The key of the general ledger account | ||
general |
varchar2 |
itgen_loketnl_generalledgeraccount_value | The description of the general ledger account | ||
payroll |
int32 |
itgen_loketnl_payrollcomponent_balancesheetside_key | Indicates on what side (debit or credit) the value should go | ||
payroll |
varchar2 |
itgen_loketnl_payrollcomponent_balancesheetside_value | The description of the side of the balance sheet | ||
payroll |
varchar2 |
Payroll Component Description | The description of the payroll component | ||
payroll |
int32 |
Payroll Component Key | The number for the payroll component. This number has meaning to payroll professionals using Loket.nl who often know many of them by heart. | ||
value |
decimal |
Value | The sum of all the values for the payrollcomponent in the specific payroll run. Payroll period, employment and normal/tarif payslip are not taken into account and simply summed up. |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: