invantive documentation
Invantive SupportforenAnmelden / Eintragen

PayrollComponentOutputs: Exact Online Payroll Component Outputs

insert update per partition XML

  • Katalog: ExactOnlineXML
  • Schema: XML
  • Label: Payroll Component Outputs

Die Daten in dieser Tabelle sind nach dem Wert der Spalte Division aufgeteilt.

Mit insert und update können Daten abgerufen und geändert werden.

Zusammenfassung

Additional where-clause columns supported:

  • division

API-Quelle

  • XML-Dienst: PayrollComponents
  • XML-Thema: PayrollComponents
  • XML-Pfad: /PayrollComponentOutputs/PayrollComponentOutput

Tabellenspalten

Die Spalten der Tabelle PayrollComponentOutputs sind unten aufgeführt. Jede Spalte hat einen SQL-Datentyp. Beim Einfügen und Aktualisieren muss für jede erforderliche Spalte jederzeit ein neuer Wert angegeben werden der nicht Null ist.

Name Datentyp Label Required Marks Documentation
CALCULATIONSTEP_CALCULATIONMETHOD_CODE_ATTR varchar2 Calculation Step Calculation Method Code /eExact/PayrollComponents/PayrollComponent/PayrollComponentOutputs/PayrollComponentOutput/CalculationStep/CalculationMethod/code
CALCULATIONSTEP_CODE_ATTR varchar2 Calculation Step Code /eExact/PayrollComponents/PayrollComponent/PayrollComponentOutputs/PayrollComponentOutput/CalculationStep/code
DIVISION_CODE varchar2 Verwaltung ID Interne einzigartige Nummer der Exact Online-Verwaltung.
DIVISION_HID int64 Administration Number of the Exact Online administration.Not guaranteed to be unique.
DIVISION_NAME varchar2(240) Verwaltung Name Name of the Exact Online administration.Not guaranteed to be unique.
FIELDDEFINITION_CODE_ATTR varchar2 Field Definition Code /eExact/PayrollComponents/PayrollComponent/PayrollComponentOutputs/PayrollComponentOutput/FieldDefinition/code
INTERFACE_URL varchar2(4000) Schnittstelle URL URL, die zum Verbinden dieser Reihe mit Exact Online verwendet wird.
NOTES varchar2 Notes /eExact/PayrollComponents/PayrollComponent/PayrollComponentOutputs/PayrollComponentOutput/Notes/
PAYROLLCOMPONENTOUTPUTS_PAYROLLCOMPONENT_AGENCYSUBTYPE number itgen_eol_payroll_components_payroll_component Agency Sub-type /eExact/PayrollComponents/PayrollComponent/AgencySubType/
PAYROLLCOMPONENTOUTPUTS_PAYROLLCOMPONENT_AGENCYTYPE number itgen_eol_payroll_components_payroll_component Agency Type /eExact/PayrollComponents/PayrollComponent/AgencyType/
PAYROLLCOMPONENTOUTPUTS_PAYROLLCOMPONENT_CALCULATE boolean itgen_eol_payroll_components_payroll_component Calculate /eExact/PayrollComponents/PayrollComponent/Calculate/
PAYROLLCOMPONENTOUTPUTS_PAYROLLCOMPONENT_CALCULATIONMETHOD_CODE_ATTR varchar2 itgen_eol_payroll_components_payroll_component_calculation_method Code /eExact/PayrollComponents/PayrollComponent/CalculationMethod/code
PAYROLLCOMPONENTOUTPUTS_PAYROLLCOMPONENT_CHANGESANNUALLY boolean itgen_eol_payroll_components_payroll_component Changes Annually /eExact/PayrollComponents/PayrollComponent/ChangesAnnually/
PAYROLLCOMPONENTOUTPUTS_PAYROLLCOMPONENT_CLASSIFICATION1 varchar2 itgen_eol_payroll_components_payroll_component Classification 1 /eExact/PayrollComponents/PayrollComponent/Classification1/
PAYROLLCOMPONENTOUTPUTS_PAYROLLCOMPONENT_CLASSIFICATION2 varchar2 itgen_eol_payroll_components_payroll_component Classification 2 /eExact/PayrollComponents/PayrollComponent/Classification2/
PAYROLLCOMPONENTOUTPUTS_PAYROLLCOMPONENT_CLASSIFICATION3 varchar2 itgen_eol_payroll_components_payroll_component Classification 3 /eExact/PayrollComponents/PayrollComponent/Classification3/
PAYROLLCOMPONENTOUTPUTS_PAYROLLCOMPONENT_CLASSIFICATION4 varchar2 itgen_eol_payroll_components_payroll_component Classification 4 /eExact/PayrollComponents/PayrollComponent/Classification4/
PAYROLLCOMPONENTOUTPUTS_PAYROLLCOMPONENT_CLASSIFICATION5 varchar2 itgen_eol_payroll_components_payroll_component Classification 5 /eExact/PayrollComponents/PayrollComponent/Classification5/
PAYROLLCOMPONENTOUTPUTS_PAYROLLCOMPONENT_CLASSIFICATION6 varchar2 itgen_eol_payroll_components_payroll_component Classification 6 /eExact/PayrollComponents/PayrollComponent/Classification6/
PAYROLLCOMPONENTOUTPUTS_PAYROLLCOMPONENT_CLASSIFICATION7 varchar2 itgen_eol_payroll_components_payroll_component Classification 7 /eExact/PayrollComponents/PayrollComponent/Classification7/
PAYROLLCOMPONENTOUTPUTS_PAYROLLCOMPONENT_CLASSIFICATION8 varchar2 itgen_eol_payroll_components_payroll_component Classification 8 /eExact/PayrollComponents/PayrollComponent/Classification8/
PAYROLLCOMPONENTOUTPUTS_PAYROLLCOMPONENT_CODE_ATTR varchar2 itgen_eol_payroll_components_payroll_component Code /eExact/PayrollComponents/PayrollComponent/code
PAYROLLCOMPONENTOUTPUTS_PAYROLLCOMPONENT_DESCRIPTION varchar2(255) itgen_eol_payroll_components_payroll_component Description /eExact/PayrollComponents/PayrollComponent/Description/
PAYROLLCOMPONENTOUTPUTS_PAYROLLCOMPONENT_DESCRIPTION_TERMID_ATTR number itgen_eol_payroll_components_payroll_component_description Term ID /eExact/PayrollComponents/PayrollComponent/Description/termid
PAYROLLCOMPONENTOUTPUTS_PAYROLLCOMPONENT_EDITABLEBYEMPLOYEE boolean itgen_eol_payroll_components_payroll_component Editable by Employee /eExact/PayrollComponents/PayrollComponent/EditableByEmployee/
PAYROLLCOMPONENTOUTPUTS_PAYROLLCOMPONENT_EDITABLEBYEMPLOYER boolean itgen_eol_payroll_components_payroll_component Editable by Employer /eExact/PayrollComponents/PayrollComponent/EditableByEmployer/
PAYROLLCOMPONENTOUTPUTS_PAYROLLCOMPONENT_EDITABLEBYTRANSACTION boolean itgen_eol_payroll_components_payroll_component Editable by Transaction /eExact/PayrollComponents/PayrollComponent/EditableByTransaction/
PAYROLLCOMPONENTOUTPUTS_PAYROLLCOMPONENT_ENABLEPRORATACALCULATION boolean itgen_eol_payroll_components_payroll_component Enable Pro-rata Calculation /eExact/PayrollComponents/PayrollComponent/EnableProRataCalculation/
PAYROLLCOMPONENTOUTPUTS_PAYROLLCOMPONENT_ENDDATE date itgen_eol_payroll_components_payroll_component End Date /eExact/PayrollComponents/PayrollComponent/EndDate/ End date: YYYY-MM-DD
PAYROLLCOMPONENTOUTPUTS_PAYROLLCOMPONENT_HYPERLINK varchar2 itgen_eol_payroll_components_payroll_component Hyperlink /eExact/PayrollComponents/PayrollComponent/Hyperlink/
PAYROLLCOMPONENTOUTPUTS_PAYROLLCOMPONENT_NOTES varchar2 itgen_eol_payroll_components_payroll_component Notes /eExact/PayrollComponents/PayrollComponent/Notes/
PAYROLLCOMPONENTOUTPUTS_PAYROLLCOMPONENT_PARENTCOMPONENT_CODE_ATTR varchar2 itgen_eol_payroll_components_payroll_component_parent_component Code /eExact/PayrollComponents/PayrollComponent/ParentComponent/code
PAYROLLCOMPONENTOUTPUTS_PAYROLLCOMPONENT_PAYROLLCOMPONENTCRITERIA varchar2 itgen_eol_payroll_components_payroll_component Payroll Component Criteria /eExact/PayrollComponents/PayrollComponent/PayrollComponentCriteria/
PAYROLLCOMPONENTOUTPUTS_PAYROLLCOMPONENT_PAYROLLCOMPONENTGROUP_CODE_ATTR varchar2 itgen_eol_payroll_components_payroll_component_payroll_component_group Code /eExact/PayrollComponents/PayrollComponent/PayrollComponentGroup/code
PAYROLLCOMPONENTOUTPUTS_PAYROLLCOMPONENT_PAYROLLCOMPONENTINPUTS varchar2 itgen_eol_payroll_components_payroll_component Payroll Component Inputs /eExact/PayrollComponents/PayrollComponent/PayrollComponentInputs/
PAYROLLCOMPONENTOUTPUTS_PAYROLLCOMPONENT_PAYROLLSUBTOTALLINKS varchar2 itgen_eol_payroll_components_payroll_component itgen_eol_payroll_subtotal_links /eExact/PayrollComponents/PayrollComponent/PayrollSubtotalLinks/
PAYROLLCOMPONENTOUTPUTS_PAYROLLCOMPONENT_PAYROLLTRANSACTIONTYPE number itgen_eol_payroll_components_payroll_component Payroll Transaction Type /eExact/PayrollComponents/PayrollComponent/PayrollTransactionType/
PAYROLLCOMPONENTOUTPUTS_PAYROLLCOMPONENT_REASONMODIFIED number itgen_eol_payroll_components_payroll_component Reason Modified /eExact/PayrollComponents/PayrollComponent/ReasonModified/
PAYROLLCOMPONENTOUTPUTS_PAYROLLCOMPONENT_SEARCHCODE varchar2 itgen_eol_payroll_components_payroll_component Search Code /eExact/PayrollComponents/PayrollComponent/SearchCode/
PAYROLLCOMPONENTOUTPUTS_PAYROLLCOMPONENT_STARTDATE date itgen_eol_payroll_components_payroll_component Start Date /eExact/PayrollComponents/PayrollComponent/StartDate/ Start date: YYYY-MM-DD
PAYROLLCOMPONENTOUTPUTS_PAYROLLCOMPONENT_STATUS varchar2 itgen_eol_payroll_components_payroll_component Status /eExact/PayrollComponents/PayrollComponent/Status/
PAYROLLCOMPONENTOUTPUTS_PAYROLLCOMPONENT_TEMPLATE boolean itgen_eol_payroll_components_payroll_component Template /eExact/PayrollComponents/PayrollComponent/Template/
PAYROLLCOMPONENTOUTPUTS_PAYROLLCOMPONENT_TYPE varchar2 itgen_eol_payroll_components_payroll_component Type /eExact/PayrollComponents/PayrollComponent/Type/
PAYROLLCOMPONENTOUTPUTS_PAYROLLCOMPONENT_VERSION number itgen_eol_payroll_components_payroll_component Version /eExact/PayrollComponents/PayrollComponent/Version/
ROWNUM int64 Zeilennummer Nummer der Reihe innerhalb der Ergebnisse, startend bei 1.

Anmerkungen zu dieser Version

Was hat sich in den Tabellen, Spalten, Attributen und Funktionen des Treibers mit jeder neuen Version geändert: