Infor FSM
As of 2024.07, you can use Financials & Supply Management Accounting dimensions labels and descriptions in the Payroll Export Task. The dimensions that can be configured are:
- Unit: ACCTU_LABEL and ACCTU_DESC
- Project: ACCTP_LABEL and ACCTP_DESC
- Account: ACCTA_LABEL and ACCTA_DESC
- User Defined Dimensions 1 to 10: DIMENSION1_ACCTD_LABEL and DIMENSION1_ACCTD_DESC
These fields are used in the <data> block of the XML
definition. For the interface field references, see VIEW_PAYEXP_CURRENT fields and
VIEW_PAYEXP_ADJUSTMENT fields.
Below are two examples of using the FSM dimensions with the Payroll Export Task.
Sample XML: Payroll Export Task with FSM dimensions
<payroll_export plugin="com.workbrain.app.export.payroll.basic.BasicPayrollExportPlugin">
<data>
<field name='EMP_NAME'/>
<field name='wrkd_minutes'/>
<field name='tcode_name'/>
<field name='htype_name'/>
<field name='ACCTU_LABEL'/>
<field name='ACCTU_DESC'/>
<field name='ACCTP_LABEL'/>
<field name='ACCTP_DESC'/>
<field name='ACCTA_LABEL'/>
<field name='ACCTA_DESC'/>
<field name='DIMENSION1_ACCTD_LABEL'/>
<field name='DIMENSION1_ACCTD_DESCRIPTION'/>
<field name='DIMENSION2_ACCTD_LABEL'/>
<field name='DIMENSION2_ACCTD_DESCRIPTION'/>
<field name='DIMENSION3_ACCTD_LABEL'/>
<field name='DIMENSION3_ACCTD_DESCRIPTION'/>
<field name='DIMENSION4_ACCTD_LABEL'/>
<field name='DIMENSION4_ACCTD_DESCRIPTION'/>
<field name='DIMENSION5_ACCTD_LABEL'/>
<field name='DIMENSION5_ACCTD_DESCRIPTION'/>
<field name='DIMENSION6_ACCTD_LABEL'/>
<field name='DIMENSION6_ACCTD_DESCRIPTION'/>
<field name='DIMENSION7_ACCTD_LABEL'/>
<field name='DIMENSION7_ACCTD_DESCRIPTION'/>
<field name='DIMENSION8_ACCTD_LABEL'/>
<field name='DIMENSION8_ACCTD_DESCRIPTION'/>
<field name='DIMENSION9_ACCTD_LABEL'/>
<field name='DIMENSION9_ACCTD_DESCRIPTION'/>
<field name='DIMENSION10_ACCTD_LABEL'/>
<field name='DIMENSION10_ACCTD_DESCRIPTION'/>
<field name='wrks_authorized'/>
<dummy_field name='earn_code'/>
</data>
<logic>
<match_output>
<match field="wrks_authorized" value="Y" />
<match field="tcode_name" value="%" />
<match field="htype_name" value="REG" />
<output_row>
<map field="earn_code" value="1" />
</output_row >
</match_output>
<match_output>
<match field="wrks_authorized" value="Y" />
<match field="tcode_name" value="%" />
<match field="htype_name" value="OT1.0" />
<output_row>
<map field="earn_code" value="4" />
</output_row >
</match_output>
<match_output>
<match field="wrks_authorized" value="Y" />
<match field="tcode_name" value="%" />
<match field="htype_name" value="OT1.5" />
<output_row>
<map field="earn_code" value="2" />
</output_row >
</match_output>
<match_output>
<match field="wrks_authorized" value="Y" />
<match field="tcode_name" value="%" />
<match field="htype_name" value="OT2.0" />
<output_row>
<map field="earn_code" value="5" />
</output_row >
</match_output>
<match_output>
<match field="tcode_name" value="UAT" />
<match field="htype_name" value="UNPAID" />
</match_output>
<match_output>
<output_row>
<map field="earn_code" value="E" />
</output_row >
</match_output>
</logic>
<format>
<header>
</header>
<body>
<string field='emp_name' />
<constant>,</constant>
<string field='earn_code'/>
<constant>,</constant>
<number field='wrkd_minutes' format='########0.00' divide='60' null='***'/>
<constant>,</constant>
<field name='ACCTU_LABEL'/>
<field name='ACCTU_DESC'/>
<field name='ACCTP_LABEL'/>
<field name='ACCTP_DESC'/>
<field name='ACCTA_LABEL'/>
<field name='ACCTA_DESC'/>
<field name='DIMENSION1_ACCTD_LABEL'/>
<field name='DIMENSION1_ACCTD_DESCRIPTION'/>
<field name='DIMENSION2_ACCTD_LABEL'/>
<field name='DIMENSION2_ACCTD_DESCRIPTION'/>
<field name='DIMENSION3_ACCTD_LABEL'/>
<field name='DIMENSION3_ACCTD_DESCRIPTION'/>
<field name='DIMENSION4_ACCTD_LABEL'/>
<field name='DIMENSION4_ACCTD_DESCRIPTION'/>
<field name='DIMENSION5_ACCTD_LABEL'/>
<field name='DIMENSION5_ACCTD_DESCRIPTION'/>
<field name='DIMENSION6_ACCTD_LABEL'/>
<field name='DIMENSION6_ACCTD_DESCRIPTION'/>
<field name='DIMENSION7_ACCTD_LABEL'/>
<field name='DIMENSION7_ACCTD_DESCRIPTION'/>
<field name='DIMENSION8_ACCTD_LABEL'/>
<field name='DIMENSION8_ACCTD_DESCRIPTION'/>
<field name='DIMENSION9_ACCTD_LABEL'/>
<field name='DIMENSION9_ACCTD_DESCRIPTION'/>
<field name='DIMENSION10_ACCTD_LABEL'/>
<field name='DIMENSION10_ACCTD_DESCRIPTION'/>
<new_line/>
</body>
<footer>
</footer>
</format>
</payroll_export>
Sample XML: GHR Payroll Export Task with FSM dimensions
<payroll_export plugin="com.workbrain.app.export.payroll.ghr.GHRPayrollExportPlugin">
<data>
<field name='EMP_NAME'/>
<field name='TCODE_NAME'/>
<field name='WRKD_MINUTES'/>
<field name='WRKD_RATE'/>
<field name='WRKD_WORK_DATE'/>
<field name='JOB_NAME'/>
<field name='DEPT_NAME'/>
<field name='PROJ_NAME'/>
<field name='DOCK_NAME'/>
<field name='ACCTU_LABEL'/>
<field name='ACCTU_DESC'/>
<field name='ACCTP_LABEL'/>
<field name='ACCTP_DESC'/>
<field name='ACCTA_LABEL'/>
<field name='ACCTA_DESC'/>
<field name='DIMENSION1_ACCTD_LABEL'/>
<field name='DIMENSION1_ACCTD_DESC'/>
<field name='DIMENSION2_ACCTD_LABEL'/>
<field name='DIMENSION2_ACCTD_DESC'/>
<field name='DIMENSION3_ACCTD_LABEL'/>
<field name='DIMENSION3_ACCTD_DESC'/>
<field name='DIMENSION4_ACCTD_LABEL'/>
<field name='DIMENSION4_ACCTD_DESC'/>
<field name='DIMENSION5_ACCTD_LABEL'/>
<field name='DIMENSION5_ACCTD_DESC'/>
<field name='DIMENSION6_ACCTD_LABEL'/>
<field name='DIMENSION6_ACCTD_DESC'/>
<field name='DIMENSION7_ACCTD_LABEL'/>
<field name='DIMENSION7_ACCTD_DESC'/>
<field name='DIMENSION8_ACCTD_LABEL'/>
<field name='DIMENSION8_ACCTD_DESC'/>
<field name='DIMENSION9_ACCTD_LABEL'/>
<field name='DIMENSION9_ACCTD_DESC'/>
<field name='DIMENSION10_ACCTD_LABEL'/>
<field name='DIMENSION10_ACCTD_DESC'/>
<dummy_field name='COMPANY'/>
<dummy_field name='BATCH_NBR'/>
<dummy_field name='UNIQUE_ID'/>
<dummy_field name='EMPLOYEE'/>
<dummy_field name='PAY_CODE'/>
<dummy_field name='JOB_CODE'/>
<dummy_field name='POSITION'/>
<dummy_field name='EMPJOB_WORKASSIGNMENT'/>
</data>
<logic>
<match_output>
<output_row />
</match_output>
</logic>
<format>
<header>
<constant>UniqueID</constant>
<constant>,</constant>
<constant>HROrganization</constant>
<constant>,</constant>
<constant>Employee</constant>
<constant>,</constant>
<constant>PayCode</constant>
<constant>,</constant>
<constant>Hours</constant>
<constant>,</constant>
<constant>Amount</constant>
<constant>,</constant>
<constant>TimeRecordDate</constant>
<constant>,</constant>
<constant>WorkAssignment</constant>
<constant>,</constant>
<constant>BatchNumber</constant>
<constant>,</constant>
<constant>ACCTU_LABEL</constant>
<constant>,</constant>
<constant>ACCTU_DESC</constant>
<constant>,</constant>
<constant>ACCTP_LABEL</constant>
<constant>,</constant>
<constant>ACCTP_DESC</constant>
<constant>,</constant>
<constant>ACCTA_LABEL</constant>
<constant>,</constant>
<constant>ACCTA_DESC</constant>
<constant>,</constant>
<constant>DIMENSION1_ACCTD_LABEL</constant>
<constant>,</constant>
<constant>DIMENSION1_ACCTD_DESC</constant>
<constant>,</constant>
<constant>DIMENSION2_ACCTD_LABEL</constant>
<constant>,</constant>
<constant>DIMENSION2_ACCTD_DESC</constant>
<constant>,</constant>
<constant>DIMENSION3_ACCTD_LABEL</constant>
<constant>,</constant>
<constant>DIMENSION3_ACCTD_DESC</constant>
<constant>,</constant>
<constant>DIMENSION4_ACCTD_LABEL</constant>
<constant>,</constant>
<constant>DIMENSION4_ACCTD_DESC</constant>
<constant>,</constant>
<constant>DIMENSION5_ACCTD_LABEL</constant>
<constant>,</constant>
<constant>DIMENSION5_ACCTD_DESC</constant>
<constant>,</constant>
<constant>DIMENSION6_ACCTD_LABEL</constant>
<constant>,</constant>
<constant>DIMENSION6_ACCTD_DESC</constant>
<constant>,</constant>
<constant>DIMENSION7_ACCTD_LABEL</constant>
<constant>,</constant>
<constant>DIMENSION7_ACCTD_DESC</constant>
<constant>,</constant>
<constant>DIMENSION8_ACCTD_LABEL</constant>
<constant>,</constant>
<constant>DIMENSION8_ACCTD_DESC</constant>
<constant>,</constant>
<constant>DIMENSION9_ACCTD_LABEL</constant>
<constant>,</constant>
<constant>DIMENSION9_ACCTD_DESC</constant>
<constant>,</constant>
<constant>DIMENSION10_ACCTD_LABEL</constant>
<constant>,</constant>
<constant>DIMENSION10_ACCTD_DESC</constant>
<new_line/>
</header>
<body>
<string field='UNIQUE_ID' />
<constant>,</constant>
<string field='COMPANY' />
<constant>,</constant>
<string field='EMPLOYEE' />
<constant>,</constant>
<string field='PAY_CODE'/>
<constant>,</constant>
<number field='WRKD_MINUTES' format='########0.00' divide='60' null='***'/>
<constant>,</constant>
<number field='WRKD_RATE' format='#0.000' null='***'/>
<constant>,</constant>
<datetime field='WRKD_WORK_DATE' format='yyyyMMdd'/>
<constant>,</constant>
<string field='EMPJOB_WORKASSIGNMENT' />
<constant>,</constant>
<string field='BATCH_NBR' />
<constant>,</constant>
<string field='ACCTU_LABEL' />
<constant>,</constant>
<string field='ACCTU_DESC' />
<constant>,</constant>
<string field='ACCTP_LABEL' />
<constant>,</constant>
<string field='ACCTP_DESC' />
<constant>,</constant>
<string field='ACCTA_LABEL' />
<constant>,</constant>
<string field='ACCTA_DESC' />
<constant>,</constant>
<string field='DIMENSION1_ACCTD_LABEL' />
<constant>,</constant>
<string field='DIMENSION1_ACCTD_DESC' />
<constant>,</constant>
<string field='DIMENSION2_ACCTD_LABEL' />
<constant>,</constant>
<string field='DIMENSION2_ACCTD_DESC' />
<constant>,</constant>
<string field='DIMENSION3_ACCTD_LABEL' />
<constant>,</constant>
<string field='DIMENSION3_ACCTD_DESC' />
<constant>,</constant>
<string field='DIMENSION4_ACCTD_LABEL' />
<constant>,</constant>
<string field='DIMENSION4_ACCTD_DESC' />
<constant>,</constant>
<string field='DIMENSION5_ACCTD_LABEL' />
<constant>,</constant>
<string field='DIMENSION5_ACCTD_DESC' />
<constant>,</constant>
<string field='DIMENSION6_ACCTD_LABEL' />
<constant>,</constant>
<string field='DIMENSION6_ACCTD_DESC' />
<constant>,</constant>
<string field='DIMENSION7_ACCTD_LABEL' />
<constant>,</constant>
<string field='DIMENSION7_ACCTD_DESC' />
<constant>,</constant>
<string field='DIMENSION8_ACCTD_LABEL' />
<constant>,</constant>
<string field='DIMENSION8_ACCTD_DESC' />
<constant>,</constant>
<string field='DIMENSION9_ACCTD_LABEL' />
<constant>,</constant>
<string field='DIMENSION9_ACCTD_DESC' />
<constant>,</constant>
<string field='DIMENSION10_ACCTD_LABEL' />
<constant>,</constant>
<string field='DIMENSION10_ACCTD_DESC' />
<new_line/>
</body>
<footer>
</footer>
</format>
</payroll_export>