invantive documentation
Invantive Support ForumsAanmelden / Inschrijven

PayrollComponents: Exact Online Payroll Components

insert update per partition XML

  • Catalogus: ExactOnlineXML
  • Schema: XML
  • Primaire sleutels: code_attr
  • Label: Payroll Components

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: /

Tabelkolommen

De kolommen van de tabel PayrollComponents 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
AGENCYSUBTYPE number Instantie Deelsoort /eExact/PayrollComponents/PayrollComponent/AgencySubType/
AGENCYTYPE number Instantiesoort /eExact/PayrollComponents/PayrollComponent/AgencyType/
CALCULATE boolean Calculate /eExact/PayrollComponents/PayrollComponent/Calculate/
CALCULATIONMETHOD_CODE_ATTR varchar2 Calculation Method Code /eExact/PayrollComponents/PayrollComponent/CalculationMethod/code
CHANGESANNUALLY boolean Wijzigingen Jaarlijks /eExact/PayrollComponents/PayrollComponent/ChangesAnnually/
CLASSIFICATION1 varchar2 Classificatie 1 /eExact/PayrollComponents/PayrollComponent/Classification1/
CLASSIFICATION2 varchar2 Classificatie 2 /eExact/PayrollComponents/PayrollComponent/Classification2/
CLASSIFICATION3 varchar2 Classificatie 3 /eExact/PayrollComponents/PayrollComponent/Classification3/
CLASSIFICATION4 varchar2 Classificatie 4 /eExact/PayrollComponents/PayrollComponent/Classification4/
CLASSIFICATION5 varchar2 Classificatie 5 /eExact/PayrollComponents/PayrollComponent/Classification5/
CLASSIFICATION6 varchar2 Classificatie 6 /eExact/PayrollComponents/PayrollComponent/Classification6/
CLASSIFICATION7 varchar2 Classificatie 7 /eExact/PayrollComponents/PayrollComponent/Classification7/
CLASSIFICATION8 varchar2 Classificatie 8 /eExact/PayrollComponents/PayrollComponent/Classification8/
CODE_ATTR varchar2 Code /eExact/PayrollComponents/PayrollComponent/code
DESCRIPTION varchar2(255) Description /eExact/PayrollComponents/PayrollComponent/Description/
DESCRIPTION_TERMID_ATTR number Omschrijving Term ID /eExact/PayrollComponents/PayrollComponent/Description/termid
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.
EDITABLEBYEMPLOYEE boolean Bewerkbaar door Werknemer /eExact/PayrollComponents/PayrollComponent/EditableByEmployee/
EDITABLEBYEMPLOYER boolean Bewerkbaar door Werkgever /eExact/PayrollComponents/PayrollComponent/EditableByEmployer/
EDITABLEBYTRANSACTION boolean Bewerkbaar door Transactie /eExact/PayrollComponents/PayrollComponent/EditableByTransaction/
ENABLEPRORATACALCULATION boolean Pro-rata Berekening Inschakelen /eExact/PayrollComponents/PayrollComponent/EnableProRataCalculation/
ENDDATE date Einddatum /eExact/PayrollComponents/PayrollComponent/EndDate/ End date: YYYY-MM-DD
HYPERLINK varchar2 Hyperlink /eExact/PayrollComponents/PayrollComponent/Hyperlink/
INTERFACE_URL varchar2(4000) Interface URL URL gebruikt om deze rij uit te wisselen met Exact Online.
NOTES varchar2 Notes /eExact/PayrollComponents/PayrollComponent/Notes/
PARENTCOMPONENT_CODE_ATTR varchar2 Parent Component Code /eExact/PayrollComponents/PayrollComponent/ParentComponent/code
PAYROLLCOMPONENTCRITERIA varchar2 Salariscomponent Criteria /eExact/PayrollComponents/PayrollComponent/PayrollComponentCriteria/
PAYROLLCOMPONENTGROUP_CODE_ATTR varchar2 Payroll Component Group Code /eExact/PayrollComponents/PayrollComponent/PayrollComponentGroup/code
PAYROLLCOMPONENTINPUTS varchar2 Salaris Component Inputs /eExact/PayrollComponents/PayrollComponent/PayrollComponentInputs/
PAYROLLCOMPONENTOUTPUTS varchar2 Salariscomponent Uitgangen /eExact/PayrollComponents/PayrollComponent/PayrollComponentOutputs/
PAYROLLSUBTOTALLINKS varchar2 itgen_eol_payroll_subtotal_links /eExact/PayrollComponents/PayrollComponent/PayrollSubtotalLinks/
PAYROLLTRANSACTIONTYPE number Salaristransactiesoort /eExact/PayrollComponents/PayrollComponent/PayrollTransactionType/
REASONMODIFIED number Reden Gewijzigd /eExact/PayrollComponents/PayrollComponent/ReasonModified/
ROWNUM int64 Rijnummer Nummer van de regel binnen de resultaten, te beginnen bij 1.
SEARCHCODE varchar2 Zoekcode /eExact/PayrollComponents/PayrollComponent/SearchCode/
STARTDATE date Startdatum /eExact/PayrollComponents/PayrollComponent/StartDate/ Start date: YYYY-MM-DD
STATUS varchar2 Status /eExact/PayrollComponents/PayrollComponent/Status/
TEMPLATE boolean Template /eExact/PayrollComponents/PayrollComponent/Template/
TYPE varchar2 Type /eExact/PayrollComponents/PayrollComponent/Type/
VERSION number Version /eExact/PayrollComponents/PayrollComponent/Version/

Release Notes

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