invantive documentation
Invantive Support ForumsLog In / Sign Up

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
payrollrunId `` 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
costCenter_code varchar2(20) Cost Centre Code The code of the cost center
costCenter_key int32 Cost Centre Key The key of the cost center
costCenter_value varchar2(50) itgen_loketnl_costcenter_value The description of the cost center
costUnit_code varchar2(20) Cost Unit Code The code of the cost unit
costUnit_key int32 Cost Unit Key The key of the cost unit
costUnit_value varchar2(50) itgen_loketnl_costunit_value The description of the cost unit
generalLedgerAccount_generalLedgerAccountnumber varchar2(20) itgen_loketnl_generalledgeraccount_generalledgeraccountnumber The account number for the general ledger account
generalLedgerAccount_key int32 General Ledger Account Key The key of the general ledger account
generalLedgerAccount_value varchar2(50) itgen_loketnl_generalledgeraccount_value The description of the general ledger account
payrollComponent_balanceSheetSide_key int32 itgen_loketnl_payrollcomponent_balancesheetside_key Indicates on what side (debit or credit) the value should go
payrollComponent_balanceSheetSide_value varchar2(50) itgen_loketnl_payrollcomponent_balancesheetside_value The description of the side of the balance sheet
payrollComponent_description varchar2(14) Payroll Component Description The description of the payroll component
payrollComponent_key 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: