invantive documentation
Foros de Soporte de InvantiveIniciar Sesión / Registrarse

PayrollComponentOutputs: Exact Online Payroll Component Outputs

insert update per partition XML

  • Catálogo: ExactOnlineXML
  • Esquema: XML
  • Label: Payroll Component Outputs

Los datos de esta tabla están divididos por el valor de la columna Division.

Permite recuperar y modificar datos mediante insert y update.

Resumen

Additional where-clause columns supported:

  • division

Fuente de la API

  • Servicio XML: PayrollComponents
  • Tema XML: PayrollComponents
  • Ruta XML: /PayrollComponentOutputs/PayrollComponentOutput

Columnas de la Tabla

A continuación se muestran las columnas de la tabla PayrollComponentOutputs. Cada columna tiene un tipo de datos SQL. Se debe proporcionar un nuevo valor no nulo para cada columna requerida en todo momento durante la inserción y la actualización.

Name Tipo de Datos 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 Identificación de la Administración Número único Interno de la administración de Exact Online.
DIVISION_HID int64 Administration Number of the Exact Online administration.Not guaranteed to be unique.
DIVISION_NAME varchar2(240) Nombre de la Adminisración 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) URL de Interfaz URL utilizada para que interactúe esta fila con Exact Online.
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 Número de la Fila Número de fila dentro de los resultados, empezando por el 1.

Notas de la Versión

Cambios introducidos en cada versión en las tablas, columnas, atributos y capacidades del controlador: