PayrollComponentSubtotalLinks: Exact Online Salarisstrookcomponent Subtotaalkoppelingen |
Catalogus: ExactOnlineXML
Schema: XML
Label: Salarisstrookcomponent Subtotaalkoppelingen
Documentatie:
Ondersteunde extra where-clause kolommen:
- 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. |
30-05-2024 10:44 Versie 24.1.3-BETA+4689