invantive documentation
Invantive Support ForumsAanmelden / Inschrijven

PayrollComponentSubtotalLinks: Exact Online Payroll Component Sub Total Links

insert update per partition XML

  • Catalogus: ExactOnlineXML
  • Schema: XML
  • Label: Payroll Component Sub Total Links

De gegevens in deze tabel zijn gepartitioneerd per waarde van de kolom Division.

Je kunt gegevens ophalen en wijzigen met insert en update.

Samenvatting

Additional where-clause columns supported:

  • division

API-bron

  • XML-service: PayrollComponents
  • XML-onderwerp: PayrollComponents
  • XML-pad: /PayrollSubtotalLinks/PayrollSubtotalLink

Tabelkolommen

De kolommen van de tabel 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.

Name Datatype Label Required Marks Documentation
DIVISION_CODE varchar2 Administratie ID Intern uniek nummer van de Exact Online administratie.
DIVISION_HID int64 Administration Number of the Exact Online administration.Not guaranteed to be unique.
DIVISION_NAME varchar2(240) Administratie Naam Name of the Exact Online administration.Not guaranteed to be unique.
INTERFACE_URL varchar2(4000) Interface URL URL gebruikt om deze rij uit te wisselen met Exact Online.
PAYROLLSUBTOTALLINKS_PAYROLLCOMPONENT_AGENCYSUBTYPE number itgen_eol_payroll_components_payroll_component Agency Sub-type /eExact/PayrollComponents/PayrollComponent/AgencySubType/
PAYROLLSUBTOTALLINKS_PAYROLLCOMPONENT_AGENCYTYPE number itgen_eol_payroll_components_payroll_component Agency Type /eExact/PayrollComponents/PayrollComponent/AgencyType/
PAYROLLSUBTOTALLINKS_PAYROLLCOMPONENT_CALCULATE boolean itgen_eol_payroll_components_payroll_component Calculate /eExact/PayrollComponents/PayrollComponent/Calculate/
PAYROLLSUBTOTALLINKS_PAYROLLCOMPONENT_CALCULATIONMETHOD_CODE_ATTR varchar2 itgen_eol_payroll_components_payroll_component_calculation_method Code /eExact/PayrollComponents/PayrollComponent/CalculationMethod/code
PAYROLLSUBTOTALLINKS_PAYROLLCOMPONENT_CHANGESANNUALLY boolean itgen_eol_payroll_components_payroll_component Changes Annually /eExact/PayrollComponents/PayrollComponent/ChangesAnnually/
PAYROLLSUBTOTALLINKS_PAYROLLCOMPONENT_CLASSIFICATION1 varchar2 itgen_eol_payroll_components_payroll_component Classification 1 /eExact/PayrollComponents/PayrollComponent/Classification1/
PAYROLLSUBTOTALLINKS_PAYROLLCOMPONENT_CLASSIFICATION2 varchar2 itgen_eol_payroll_components_payroll_component Classification 2 /eExact/PayrollComponents/PayrollComponent/Classification2/
PAYROLLSUBTOTALLINKS_PAYROLLCOMPONENT_CLASSIFICATION3 varchar2 itgen_eol_payroll_components_payroll_component Classification 3 /eExact/PayrollComponents/PayrollComponent/Classification3/
PAYROLLSUBTOTALLINKS_PAYROLLCOMPONENT_CLASSIFICATION4 varchar2 itgen_eol_payroll_components_payroll_component Classification 4 /eExact/PayrollComponents/PayrollComponent/Classification4/
PAYROLLSUBTOTALLINKS_PAYROLLCOMPONENT_CLASSIFICATION5 varchar2 itgen_eol_payroll_components_payroll_component Classification 5 /eExact/PayrollComponents/PayrollComponent/Classification5/
PAYROLLSUBTOTALLINKS_PAYROLLCOMPONENT_CLASSIFICATION6 varchar2 itgen_eol_payroll_components_payroll_component Classification 6 /eExact/PayrollComponents/PayrollComponent/Classification6/
PAYROLLSUBTOTALLINKS_PAYROLLCOMPONENT_CLASSIFICATION7 varchar2 itgen_eol_payroll_components_payroll_component Classification 7 /eExact/PayrollComponents/PayrollComponent/Classification7/
PAYROLLSUBTOTALLINKS_PAYROLLCOMPONENT_CLASSIFICATION8 varchar2 itgen_eol_payroll_components_payroll_component Classification 8 /eExact/PayrollComponents/PayrollComponent/Classification8/
PAYROLLSUBTOTALLINKS_PAYROLLCOMPONENT_CODE_ATTR varchar2 itgen_eol_payroll_components_payroll_component Code /eExact/PayrollComponents/PayrollComponent/code
PAYROLLSUBTOTALLINKS_PAYROLLCOMPONENT_DESCRIPTION varchar2(255) itgen_eol_payroll_components_payroll_component Description /eExact/PayrollComponents/PayrollComponent/Description/
PAYROLLSUBTOTALLINKS_PAYROLLCOMPONENT_DESCRIPTION_TERMID_ATTR number itgen_eol_payroll_components_payroll_component_description Term ID /eExact/PayrollComponents/PayrollComponent/Description/termid
PAYROLLSUBTOTALLINKS_PAYROLLCOMPONENT_EDITABLEBYEMPLOYEE boolean itgen_eol_payroll_components_payroll_component Editable by Employee /eExact/PayrollComponents/PayrollComponent/EditableByEmployee/
PAYROLLSUBTOTALLINKS_PAYROLLCOMPONENT_EDITABLEBYEMPLOYER boolean itgen_eol_payroll_components_payroll_component Editable by Employer /eExact/PayrollComponents/PayrollComponent/EditableByEmployer/
PAYROLLSUBTOTALLINKS_PAYROLLCOMPONENT_EDITABLEBYTRANSACTION boolean itgen_eol_payroll_components_payroll_component Editable by Transaction /eExact/PayrollComponents/PayrollComponent/EditableByTransaction/
PAYROLLSUBTOTALLINKS_PAYROLLCOMPONENT_ENABLEPRORATACALCULATION boolean itgen_eol_payroll_components_payroll_component Enable Pro-rata Calculation /eExact/PayrollComponents/PayrollComponent/EnableProRataCalculation/
PAYROLLSUBTOTALLINKS_PAYROLLCOMPONENT_ENDDATE date itgen_eol_payroll_components_payroll_component End Date /eExact/PayrollComponents/PayrollComponent/EndDate/ End date: YYYY-MM-DD
PAYROLLSUBTOTALLINKS_PAYROLLCOMPONENT_HYPERLINK varchar2 itgen_eol_payroll_components_payroll_component Hyperlink /eExact/PayrollComponents/PayrollComponent/Hyperlink/
PAYROLLSUBTOTALLINKS_PAYROLLCOMPONENT_NOTES varchar2 itgen_eol_payroll_components_payroll_component Notes /eExact/PayrollComponents/PayrollComponent/Notes/
PAYROLLSUBTOTALLINKS_PAYROLLCOMPONENT_PARENTCOMPONENT_CODE_ATTR varchar2 itgen_eol_payroll_components_payroll_component_parent_component Code /eExact/PayrollComponents/PayrollComponent/ParentComponent/code
PAYROLLSUBTOTALLINKS_PAYROLLCOMPONENT_PAYROLLCOMPONENTCRITERIA varchar2 itgen_eol_payroll_components_payroll_component Payroll Component Criteria /eExact/PayrollComponents/PayrollComponent/PayrollComponentCriteria/
PAYROLLSUBTOTALLINKS_PAYROLLCOMPONENT_PAYROLLCOMPONENTGROUP_CODE_ATTR varchar2 itgen_eol_payroll_components_payroll_component_payroll_component_group Code /eExact/PayrollComponents/PayrollComponent/PayrollComponentGroup/code
PAYROLLSUBTOTALLINKS_PAYROLLCOMPONENT_PAYROLLCOMPONENTINPUTS varchar2 itgen_eol_payroll_components_payroll_component Payroll Component Inputs /eExact/PayrollComponents/PayrollComponent/PayrollComponentInputs/
PAYROLLSUBTOTALLINKS_PAYROLLCOMPONENT_PAYROLLCOMPONENTOUTPUTS varchar2 itgen_eol_payroll_components_payroll_component Payroll Component Outputs /eExact/PayrollComponents/PayrollComponent/PayrollComponentOutputs/
PAYROLLSUBTOTALLINKS_PAYROLLCOMPONENT_PAYROLLTRANSACTIONTYPE number itgen_eol_payroll_components_payroll_component Payroll Transaction Type /eExact/PayrollComponents/PayrollComponent/PayrollTransactionType/
PAYROLLSUBTOTALLINKS_PAYROLLCOMPONENT_REASONMODIFIED number itgen_eol_payroll_components_payroll_component Reason Modified /eExact/PayrollComponents/PayrollComponent/ReasonModified/
PAYROLLSUBTOTALLINKS_PAYROLLCOMPONENT_SEARCHCODE varchar2 itgen_eol_payroll_components_payroll_component Search Code /eExact/PayrollComponents/PayrollComponent/SearchCode/
PAYROLLSUBTOTALLINKS_PAYROLLCOMPONENT_STARTDATE date itgen_eol_payroll_components_payroll_component Start Date /eExact/PayrollComponents/PayrollComponent/StartDate/ Start date: YYYY-MM-DD
PAYROLLSUBTOTALLINKS_PAYROLLCOMPONENT_STATUS varchar2 itgen_eol_payroll_components_payroll_component Status /eExact/PayrollComponents/PayrollComponent/Status/
PAYROLLSUBTOTALLINKS_PAYROLLCOMPONENT_TEMPLATE boolean itgen_eol_payroll_components_payroll_component Template /eExact/PayrollComponents/PayrollComponent/Template/
PAYROLLSUBTOTALLINKS_PAYROLLCOMPONENT_TYPE varchar2 itgen_eol_payroll_components_payroll_component Type /eExact/PayrollComponents/PayrollComponent/Type/
PAYROLLSUBTOTALLINKS_PAYROLLCOMPONENT_VERSION number itgen_eol_payroll_components_payroll_component Version /eExact/PayrollComponents/PayrollComponent/Version/
PAYROLLSUBTOTAL_CODE_ATTR varchar2 Payroll Subtotal Code /eExact/PayrollComponents/PayrollComponent/PayrollSubtotalLinks/PayrollSubtotalLink/PayrollSubtotal/code
PAYROLLSUBTOTAL_ID_ATTR varchar2 Payroll Subtotal ID /eExact/PayrollComponents/PayrollComponent/PayrollSubtotalLinks/PayrollSubtotalLink/PayrollSubtotal/ID
PAYROLLSUBTOTAL_PAYROLLCOMPONENTGROUP_CODE_ATTR varchar2 Payroll Subtotal Component Group Code /eExact/PayrollComponents/PayrollComponent/PayrollSubtotalLinks/PayrollSubtotalLink/PayrollSubtotal/PayrollComponentGroup/code
PAYROLLSUBTOTAL_STARTDATE date Payroll Subtotal Start Date /eExact/PayrollComponents/PayrollComponent/PayrollSubtotalLinks/PayrollSubtotalLink/PayrollSubtotal/StartDate/ Start date: YYYY-MM-DD
ROWNUM int64 Rijnummer Nummer van de regel binnen de resultaten, te beginnen bij 1.

Release Notes

Wat is er per release veranderd in de tabellen, kolommen, attributen en mogelijkheden van de driver: