invantive documentation
Forum di supporto InvantiveAccedi / Registrati

PayrollComponentSubtotalLinks: Exact Online Payroll Component Sub Total Links

insert update per partition XML

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

I dati in questa tabella sono partizionati per valore della colonna Division.

È possibile recuperare e modificare i dati utilizzando insert e update.

Additional where-clause columns supported:

  • division

Codice sorgente dell'API

  • Servizio XML: PayrollComponents
  • Argomento XML: PayrollComponents
  • Percorso XML: /PayrollSubtotalLinks/PayrollSubtotalLink

Colonne della tabella

Di seguito sono riportate le colonne della tabella PayrollComponentSubtotalLinks. Ogni colonna ha un tipo di dati SQL. Un nuovo valore non nullo deve essere fornito per ogni colonna richiesta in ogni momento durante l'inserimento e l'aggiornamento.

Name Tipo di dati Label Required Marks Documentation
DIVISION_CODE varchar2 ID amministrativo Numero univoco interno dell'amministrazione di Exact Online.
DIVISION_HID int64 Administration Number of the Exact Online administration.Not guaranteed to be unique.
DIVISION_NAME varchar2(240) Nome dell'amministrazione Name of the Exact Online administration.Not guaranteed to be unique.
INTERFACE_URL varchar2(4000) URL dell'interfaccia URL utilizzato per collegare questa riga a 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 Numero di riga Numero della riga all'interno dei risultati, a partire da 1.

Note di rilascio

Cosa è cambiato, versione per versione, nelle tabelle, nelle colonne, negli attributi e nelle funzionalità del driver: