invantive documentation
Invantive Support ForumsLog In / Sign Up

PayrollComponentSubtotalLinks: Exact Online Payroll Component Sub Total Links

insert update per partition XML

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

The data in this table is partitioned per value of the Division column.

Can retrieve data and change data using insert and update.

Summary

Additional where-clause columns supported:

  • division

API Source

  • XML service: PayrollComponents
  • XML topic: PayrollComponents
  • XML path: /PayrollSubtotalLinks/PayrollSubtotalLink

Table Columns

The columns of the table PayrollComponentSubtotalLinks are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.

Name Data Type Label Required Marks Documentation
DIVISION_CODE varchar2 Administration ID Internal unique number of the Exact Online administration.
DIVISION_HID int64 Administration Number of the Exact Online administration. Not guaranteed to be unique.
DIVISION_NAME varchar2(240) Administration Name Name of the Exact Online administration. Not guaranteed to be unique.
INTERFACE_URL varchar2(4000) Interface URL URL used to interface this row with 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 Row Number Number of the row within the results, starting at 1.

Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver: