PayrollComponentSubtotalLinks: Exact Online Salarisstrookcomponent Subtotaalkoppelingen | 
		
Catalogus: ExactOnlineXML
Schema: XML
Label: Salarisstrookcomponent Subtotaalkoppelingen
Documentatie:
Additional where-clause columns supported:
- division
De gegevens in deze tabel zijn gepartitioneerd per waarde van de kolom Division.
Ophalen: true
Invoegen: true
Bijwerken: true
Verwijderen: false
Filters op API-server: division
View Kolommen
De kolommen van de view PayrollComponentSubtotalLinks worden hieronder weergegeven. Elke kolom heeft een SQL-gegevenstype. Voor elke vereiste kolom moet bij het invoegen en bijwerken steeds een nieuwe, niet-lege waarde worden opgegeven.
Naam  | 
Datatype  | 
Label  | 
Verplicht  | 
Documentatie  | 
|---|---|---|---|---|
DIVISION_CODE  | 
string  | 
Administratie ID  | 
☑  | 
Intern uniek nummer van de Exact Online administratie.  | 
DIVISION_HID  | 
int64  | 
Administratie  | 
☑  | 
Nummer van de Exact Online administratie. Niet gegarandeerd uniek.  | 
DIVISION_NAME  | 
string(240)  | 
Administratie Naam  | 
☑  | 
Naam van de Exact Online administratie. Niet gegarandeerd uniek.  | 
INTERFACE_URL  | 
string(4000)  | 
Interface URL  | 
☑  | 
URL gebruikt om deze rij uit te wisselen met Exact Online.  | 
PAYROLLSUBTOTAL_CODE_ATTR  | 
string  | 
Loonstrook Subtotaal Code  | 
  | 
  | 
PAYROLLSUBTOTAL_ID_ATTR  | 
string  | 
Loonstrook Subtotaal ID  | 
  | 
  | 
PAYROLLSUBTOTAL_PAYROLLCOMPONENTGROUP_CODE_ATTR  | 
string  | 
Salaris Subtotaal Componentgroep Code  | 
  | 
  | 
PAYROLLSUBTOTAL_STARTDATE  | 
datetime  | 
Loonstrook Subtotaal Startdatum  | 
  | 
Start date: YYYY-MM-DD  | 
PAYROLLSUBTOTALLINKS_PAYROLLCOMPONENT_AGENCYSUBTYPE  | 
int64  | 
  | 
  | 
  | 
PAYROLLSUBTOTALLINKS_PAYROLLCOMPONENT_AGENCYTYPE  | 
int64  | 
  | 
  | 
  | 
PAYROLLSUBTOTALLINKS_PAYROLLCOMPONENT_CALCULATE  | 
boolean  | 
  | 
  | 
  | 
PAYROLLSUBTOTALLINKS_PAYROLLCOMPONENT_CALCULATIONMETHOD_CODE_ATTR  | 
string  | 
  | 
  | 
  | 
PAYROLLSUBTOTALLINKS_PAYROLLCOMPONENT_CHANGESANNUALLY  | 
boolean  | 
  | 
  | 
  | 
PAYROLLSUBTOTALLINKS_PAYROLLCOMPONENT_CLASSIFICATION1  | 
string  | 
  | 
  | 
  | 
PAYROLLSUBTOTALLINKS_PAYROLLCOMPONENT_CLASSIFICATION2  | 
string  | 
  | 
  | 
  | 
PAYROLLSUBTOTALLINKS_PAYROLLCOMPONENT_CLASSIFICATION3  | 
string  | 
  | 
  | 
  | 
PAYROLLSUBTOTALLINKS_PAYROLLCOMPONENT_CLASSIFICATION4  | 
string  | 
  | 
  | 
  | 
PAYROLLSUBTOTALLINKS_PAYROLLCOMPONENT_CLASSIFICATION5  | 
string  | 
  | 
  | 
  | 
PAYROLLSUBTOTALLINKS_PAYROLLCOMPONENT_CLASSIFICATION6  | 
string  | 
  | 
  | 
  | 
PAYROLLSUBTOTALLINKS_PAYROLLCOMPONENT_CLASSIFICATION7  | 
string  | 
  | 
  | 
  | 
PAYROLLSUBTOTALLINKS_PAYROLLCOMPONENT_CLASSIFICATION8  | 
string  | 
  | 
  | 
  | 
PAYROLLSUBTOTALLINKS_PAYROLLCOMPONENT_CODE_ATTR  | 
string  | 
  | 
  | 
  | 
PAYROLLSUBTOTALLINKS_PAYROLLCOMPONENT_DESCRIPTION_TERMID_ATTR  | 
int64  | 
  | 
  | 
  | 
PAYROLLSUBTOTALLINKS_PAYROLLCOMPONENT_DESCRIPTION  | 
string(255)  | 
  | 
  | 
  | 
PAYROLLSUBTOTALLINKS_PAYROLLCOMPONENT_EDITABLEBYEMPLOYEE  | 
boolean  | 
  | 
  | 
  | 
PAYROLLSUBTOTALLINKS_PAYROLLCOMPONENT_EDITABLEBYEMPLOYER  | 
boolean  | 
  | 
  | 
  | 
PAYROLLSUBTOTALLINKS_PAYROLLCOMPONENT_EDITABLEBYTRANSACTION  | 
boolean  | 
  | 
  | 
  | 
PAYROLLSUBTOTALLINKS_PAYROLLCOMPONENT_ENABLEPRORATACALCULATION  | 
boolean  | 
  | 
  | 
  | 
PAYROLLSUBTOTALLINKS_PAYROLLCOMPONENT_ENDDATE  | 
datetime  | 
  | 
  | 
End date: YYYY-MM-DD  | 
PAYROLLSUBTOTALLINKS_PAYROLLCOMPONENT_HYPERLINK  | 
string  | 
  | 
  | 
  | 
PAYROLLSUBTOTALLINKS_PAYROLLCOMPONENT_NOTES  | 
string  | 
  | 
  | 
  | 
PAYROLLSUBTOTALLINKS_PAYROLLCOMPONENT_PARENTCOMPONENT_CODE_ATTR  | 
string  | 
  | 
  | 
  | 
PAYROLLSUBTOTALLINKS_PAYROLLCOMPONENT_PAYROLLCOMPONENTCRITERIA  | 
string  | 
  | 
  | 
  | 
PAYROLLSUBTOTALLINKS_PAYROLLCOMPONENT_PAYROLLCOMPONENTGROUP_CODE_ATTR  | 
string  | 
  | 
  | 
  | 
PAYROLLSUBTOTALLINKS_PAYROLLCOMPONENT_PAYROLLCOMPONENTINPUTS  | 
string  | 
  | 
  | 
  | 
PAYROLLSUBTOTALLINKS_PAYROLLCOMPONENT_PAYROLLCOMPONENTOUTPUTS  | 
string  | 
  | 
  | 
  | 
PAYROLLSUBTOTALLINKS_PAYROLLCOMPONENT_PAYROLLTRANSACTIONTYPE  | 
int64  | 
  | 
  | 
  | 
PAYROLLSUBTOTALLINKS_PAYROLLCOMPONENT_REASONMODIFIED  | 
int64  | 
  | 
  | 
  | 
PAYROLLSUBTOTALLINKS_PAYROLLCOMPONENT_SEARCHCODE  | 
string  | 
  | 
  | 
  | 
PAYROLLSUBTOTALLINKS_PAYROLLCOMPONENT_STARTDATE  | 
datetime  | 
  | 
  | 
Start date: YYYY-MM-DD  | 
PAYROLLSUBTOTALLINKS_PAYROLLCOMPONENT_STATUS  | 
string  | 
  | 
  | 
  | 
PAYROLLSUBTOTALLINKS_PAYROLLCOMPONENT_TEMPLATE  | 
boolean  | 
  | 
  | 
  | 
PAYROLLSUBTOTALLINKS_PAYROLLCOMPONENT_TYPE  | 
string  | 
  | 
  | 
  | 
PAYROLLSUBTOTALLINKS_PAYROLLCOMPONENT_VERSION  | 
int64  | 
  | 
  | 
  | 
ROWNUM  | 
int64  | 
Rijnummer  | 
☑  | 
Nummer van de regel binnen de resultaten, te beginnen bij 1.  | 
24-06-2025 18:54 Versie 24.1.116-BETA+5455
Exact Online API Data Model