Time Code Table Import
<table-config>
<table name="TIME_CODE" transaction-type="INSERT_UPDATE"
key-fields="TCODE_NAME" primary-key="TCODE_ID">
<fields>
<field index="1" db-field="TCODE_NAME" />
<field index="2" db-field="TCODE_DESC" />
<field index="3" db-field="TCODE_DOW" default-value="YYYYNN"/>
<field index="4" db-field="TCODE_OWS" default-value="Y"/>
<field index="5" db-field="COLR_ID" default-value="Black">
<reference table-name="COLOUR" supplied-value="COLR_NAME"
resolve-tofield="COLR_ID"/>
</field>
<field index="6" db-field="HTYPE_ID">
<reference table-name="HOUR_TYPE"
supplied-value="HTYPE_NAME"
resolve-to-field="HTYPE_ID"/>
</field>
<field index="7" db-field="TCODE_UNAUTHORIZE"
default-value="Y"/>
<field index="8" db-field="TCODE_SORTORDER"/>
<field index="9" db-field="TCODE_AFFECTS_BALANCES"
default-value="N"/>
<field index="10" db-field="TCODE_SUMMARIZE"/>
<field index="11" db-field="TCODE_FLAG1"/>
<field index="12" db-field="TCODE_FLAG2"/>
<field index="13" db-field="TCODE_FLAG3"/>
<field index="14" db-field="TCODE_FLAG4"/>
<field index="15" db-field="TCODE_FLAG5"/>
<field index="16" db-field="TCODE_DEFAULT_RATE"/>
<field index="17" db-field="LMS_ID" default-value="1" />
<field index="18" db-field="*CUSTOM"/>
</fields>
</table>
</table-config>
Department Table Import
<table-config>
<table name="DEPARTMENT" transaction-type="INSERT_UPDATE"
key-fields="DEPT_NAME" primary-key="DEPT_ID">
<fields>
<field index="1" db-field="DEPT_NAME" />
<field index="2" db-field="DEPT_DESC" />
<field index="3" db-field="DEPT_START_DATE"
date-format="yyyyMMdd" default-value="!SYSTEM_DATE"/>
<field index="4" db-field="DEPT_END_DATE"
date-format="yyyyMMdd" default-value="30000101"/>
<field index="5" db-field="DEPT_FLAG1" default-value="N"/>
<field index="6" db-field="DEPT_FLAG2" default-value="N"/>
<field index="7" db-field="DEPT_FLAG3" default-value="N"/>
<field index="8" db-field="DEPT_FLAG4" default-value="N"/>
<field index="9" db-field="DEPT_FLAG5" default-value="N"/>
<field index="10" db-field="DEPT_VAL1"/>
<field index="11" db-field="DEPT_VAL2"/>
<field index="12" db-field="DEPT_VAL3"/>
<field index="13" db-field="DEPT_VAL4"/>
<field index="14" db-field="DEPT_VAL5"/>
<field index="15" db-field="LMS_ID" default-value="1" />
<field index="16" db-field="*CUSTOM"/>
</fields>
</table>
</table-config>
Docket Table Import
<table-config>
<table name="DOCKET" transaction-type="INSERT_UPDATE"
key-fields="DOCK_NAME" primary-key="DOCK_ID">
<fields>
<field index="1" db-field="DOCK_NAME" />
<field index="2" db-field="DOCK_DESC" />
<field index="3" db-field="DOCK_QTY" default-value="0"/>
<field index="4" db-field="DOCK_STANDARD_QTY"/>
<field index="5" db-field="DOCK_STANDARD_DUR"/>
<field index="6" db-field="MACH_ID" default-value="NULL">
<reference table-name="MACHINE" supplied-value="MACH_NAME"
resolveto-field="MACH_ID"/>
</field>
<field index="7" db-field="PART_ID" default-value="NULL">
<reference table-name="PART" supplied-value="PART_NAME"
resolve-tofield="PART_ID"/>
</field>
<field index="8" db-field="PROJ_ID" default-value="0">
<reference table-name="PROJECT" supplied-value="PROJ_NAME"
resolve-to-field="PROJ_ID"/>
</field>
<field index="9" db-field="DOCK_PIECE_RATE"
default-value="0"/>
<field index="10" db-field ="ACTVSET_ID" default-value="NULL">
<reference table-name="ACTIVITY_SET" suppliedvalue="
ACTVSET_NAME" resolve-to-field="ACTVSET_ID"/>
</field>
<field index="11" db-field="DOCK_START_DATE"
date-format="yyyyMMdd" default-value="!SYSTEM_DATE"/>
<field index="12" db-field="DOCK_END_DATE"
date-format="yyyyMMdd" default-value="30000101"/>
<field index="13" db-field="DOCK_FLAG1" default-value="N"/>
<field index="14" db-field="DOCK_FLAG2" default-value="N"/>
<field index="15" db-field="DOCK_FLAG3" default-value="N"/>
<field index="16" db-field="DOCK_FLAG4" default-value="N"/>
<field index="17" db-field="DOCK_FLAG5" default-value="N"/>
<field index="18" db-field="DOCK_UDF1"/>
<field index="19" db-field="DOCK_UDF2"/>
<field index="20" db-field="DOCK_UDF3"/>
<field index="21" db-field="DOCK_UDF4"/>
<field index="22" db-field="DOCK_UDF5"/>
<field index="23" db-field="LMS_ID" default-value="1" />
<field index="24" db-field="*CUSTOM"/>
</fields>
</table>
</table-config>
Project Table Import
<table-config>
<table name="PROJECT" transaction-type="INSERT_UPDATE"
key-fields="PROJ_NAME" primary-key="PROJ_ID">
<fields>
<field index="1" db-field="PROJ_NAME" />
<field index="2" db-field="PROJ_DESC" />
<field index="3" db-field="PROJ_START_DATE"
date-format="yyyyMMdd" default-value="!SYSTEM_DATE"/>
<field index="4" db-field="PROJ_END_DATE"
date-format="yyyyMMdd" default-value="30000101"/>
<field index="5" db-field="PROJ_FLAG1" default-value="N"/>
<field index="6" db-field="PROJ_FLAG2" default-value="N"/>
<field index="7" db-field="PROJ_FLAG3" default-value="N"/>
<field index="8" db-field="PROJ_FLAG4" default-value="N"/>
<field index="9" db-field="PROJ_FLAG5" default-value="N"/>
<field index="10" db-field="PROJ_VAL1"/>
<field index="11" db-field="PROJ_VAL2"/>
<field index="12" db-field="PROJ_VAL3"/>
<field index="13" db-field="PROJ_VAL4"/>
<field index="14" db-field="PROJ_VAL5"/>
<field index="15" db-field="LMS_ID" default-value="1" />
<field index="16" db-field="*CUSTOM"/>
</fields>
</table>
</table-config>
Skill Table Import
<table-config>
<table name="ST_SKILL" transaction-type="INSERT_UPDATE"
key-fields="STSKL_NAME,STSKLTYP_ID" primary-key="STSKL_ID">
<fields>
<field index="1" db-field="STSKL_NAME" />
<field index="2" db-field="STSKL_DESC" />
<field index="3" db-field="STSKLTYP_ID" >
<reference table-name="ST_SKILL_TYPE"
supplied-value="STSKLTYP_NAME"
resolve-to-field="STSKLTYP_ID"/>
</field>
<field index="4" db-field="STSKL_FLAG1" default-value="N"/>
<field index="5" db-field="STSKL_FLAG2" default-value="N"/>
<field index="6" db-field="STSKL_FLAG3" default-value="N"/>
<field index="7" db-field="STSKL_FLAG4" default-value="N"/>
<field index="8" db-field="STSKL_FLAG5" default-value="N"/>
<field index="9" db-field="STSKL_UDF1"/>
<field index="10" db-field="STSKL_UDF2"/>
<field index="11" db-field="STSKL_UDF3"/>
<field index="12" db-field="STSKL_UDF4"/>
<field index="13" db-field="STSKL_UDF5"/>
</fields>
</table>
</table-config>
SO Results Detail Table Import
<table-config>
<table name="SO_RESULTS_DETAIL" transaction-type="INSERT"
primarykey="RESDET_ID">
<deletes>
<delete type="PRE">
<delete-field db-field="RESDET_DATE"
default-value="!SYSTEM_DATE" day="SAT"
condition="GREATER" offset="-7"/>
<delete-field db-field="RESDET_DATE"
default-value="!SYSTEM_DATE" day="SAT"
condition="LESS_EQUALS"/>
<delete-field db-field="INVTYP_ID" default-value="1"
condition="EQUALS"/>
</delete>
</deletes>
<fields>
<field index="1" db-field="SKDGRP_ID">
<reference table-name="SO_SCHEDULE_GROUP"
suppliedvalue="SKDGRP_CLIENTKEY"
resolve-to-field="SKDGRP_ID"/>
</field>
<field index="2" db-field="RESDET_DATE"
date-format="MM/dd/yyyy" default-value="!SYSTEM_DATE"/>
<field index="3" db-field="RESDET_TIME" date-format="HH:mm"/>
<field index="4" db-field="RESDET_VOLUME"/>
<field index="5" db-field="INVTYP_ID" default-value="1"/>
</fields>
</table>
</table-config>