Apicosoft

ERP iScala Database Structure
iScala Supprort & Customization

Business processes implementation, ad-hock services, end-users training and education, maintenance support.

Read More Contact Us
Epicor Service Connect

Integration with any third-party services. Customize internal workflows.

Read More Contact Us
Reporting

SAP Crystal Reports, SQL Server Reporting Services, Excel.

Read More Contact Us
Tables
Name Description Dependences Example
HR01 Resource Master Table Company HR010100
HR02 Resource Templates Company HR020100
HR03 Resource Transactions Company HR030100
HR04 Time Planning Company HR040100
HR05 Payroll Transactions Company HR050100
HR06 Work Schedule (not used) Company HR060100
HR10 HR Courses Company HR100100
HR11 Course Multilingual Description Company HR110100
HR15 Course Plan Company HR150100
HR16 Course Details Company HR160100
HR17 Course Skills Company HR170100
HR18 Acquired Skills Company HR180100
HR19 Course Status Mapping Company HR190100
HR46 Course Details History Company HR460100
HRF1 Exposed Engineer Company HRF10100
HRX1 Time Planning 1 HRX10000
HRX2 Time Planning 2 HRX20000
HRX3 Time Planning 3 HRX30000
sca_trg_Audit_HR01 Audit trigger for HR01 table Company sca_trg_Audit_HR010100

Fields
PK Table Name Description Type Length Precision Note
1 HR06 HR06001 WorkSchedID VSTRING 6 6 0 Work Schedule Code
HR06 HR06002 WorkSchedYr VSTRING 4 4 0 Work Schedule Year
HR06 HR06003 Name VSTRING 25 25 0 Description
HR06 HR06004 Sh1StTimeMon VSTRING 5 5 0 Start Time 1 Monday
HR06 HR06005 Sh1StTimeTue VSTRING 5 5 0 Start Time 1 Tuesday
HR06 HR06006 Sh1StTimeWed VSTRING 5 5 0 Start Time 1 Wednesday
HR06 HR06007 Sh1StTimeThu VSTRING 5 5 0 Start Time 1 Thursday
HR06 HR06008 Sh1StTimeFri VSTRING 5 5 0 Start Time 1 Friday
HR06 HR06009 Sh1StTimeSat VSTRING 5 5 0 Start Time 1 Saturday
HR06 HR06010 Sh1StTimeSun VSTRING 5 5 0 Start Time 1 Sunday
HR06 HR06011 Sh1EnTimeMon VSTRING 5 5 0 End Time 1 Monday
HR06 HR06012 Sh1EnTimeTue VSTRING 5 5 0 End Time 1 Tuesday
HR06 HR06013 Sh1EnTimeWed VSTRING 5 5 0 End Time 1 Wednesday
HR06 HR06014 Sh1EnTimeThu VSTRING 5 5 0 End Time 1 Thursday
HR06 HR06015 Sh1EnTimeFri VSTRING 5 5 0 End Time 1 Friday
HR06 HR06016 Sh1EnTimeSat VSTRING 5 5 0 End Time 1 Saturday
HR06 HR06017 Sh1EnTimeSun VSTRING 5 5 0 End Time 1 Sunday
HR06 HR06018 Sh2StTimeMon VSTRING 5 5 0 Start Time 2 Monday
HR06 HR06019 Sh2StTimeTue VSTRING 5 5 0 Start Time 2 Tuesday
HR06 HR06020 Sh2StTimeWed VSTRING 5 5 0 Start Time 2 Wednesday
HR06 HR06021 Sh2StTimeThu VSTRING 5 5 0 Start Time 2 Thursday
HR06 HR06022 Sh2StTimeFri VSTRING 5 5 0 Start Time 2 Friday
HR06 HR06023 Sh2StTimeSat VSTRING 5 5 0 Start Time 2 Saturday
HR06 HR06024 Sh2StTimeSun VSTRING 5 5 0 Start Time 2 Sunday
HR06 HR06025 Sh2EnTimeMon VSTRING 5 5 0 End Time 2 Monday
HR06 HR06026 Sh2EnTimeTue VSTRING 5 5 0 End Time 2 Tuesday
HR06 HR06027 Sh2EnTimeWed VSTRING 5 5 0 End Time 2 Wednesday
HR06 HR06028 Sh2EnTimeThu VSTRING 5 5 0 End Time 2 Thursday
HR06 HR06029 Sh2EnTimeFri VSTRING 5 5 0 End Time 2 Friday
HR06 HR06030 Sh2EnTimeSat VSTRING 5 5 0 End Time 2 Saturday
HR06 HR06031 Sh2EnTimeSun VSTRING 5 5 0 End Time 2 Sunday
HR06 HR06032 Sh3StTimeMon VSTRING 5 5 0 Start Time 3 Monday
HR06 HR06033 Sh3StTimeTue VSTRING 5 5 0 Start Time 3 Tuesday
HR06 HR06034 Sh3StTimeWed VSTRING 5 5 0 Start Time 3 Wednesday
HR06 HR06035 Sh3StTimeThu VSTRING 5 5 0 Start Time 3 Thursday
HR06 HR06036 Sh3StTimeFri VSTRING 5 5 0 Start Time 3 Friday
HR06 HR06037 Sh3StTimeSat VSTRING 5 5 0 Start Time 3 Saturday
HR06 HR06038 Sh3StTimeSun VSTRING 5 5 0 Start Time 3 Sunday
HR06 HR06039 Sh3EnTimeMon VSTRING 5 5 0 End Time 3 Monday
HR06 HR06040 Sh3EnTimeTue VSTRING 5 5 0 End Time 3 Tuesday
HR06 HR06041 Sh3EnTimeWed VSTRING 5 5 0 End Time 3 Wednesday
HR06 HR06042 Sh3EnTimeThu VSTRING 5 5 0 End Time 3 Thursday
HR06 HR06043 Sh3EnTimeFri VSTRING 5 5 0 End Time 3 Friday
HR06 HR06044 Sh3EnTimeSat VSTRING 5 5 0 End Time 3 Saturday
HR06 HR06045 Sh3EnTimeSun VSTRING 5 5 0 End Time 3 Sunday
HR06 HR06046 OvertimeMon VSTRING 5 5 0 Overtime Monday
HR06 HR06047 OvertimeTue VSTRING 5 5 0 Overtime Tuesday
HR06 HR06048 OvertimeWed VSTRING 5 5 0 Overtime Wednesday
HR06 HR06049 OvertimeThu VSTRING 5 5 0 Overtime Thursday
HR06 HR06050 OvertimeFri VSTRING 5 5 0 Overtime Friday
HR06 HR06051 OvertimeSat VSTRING 5 5 0 Overtime Saturday
HR06 HR06052 OvertimeSun VSTRING 5 5 0 Overtime Sunday
HR06 HR06053 NonOpPerFrD1 DATE 8 0 0 None Operational Period From Date 1
HR06 HR06054 NonOpPerToD1 DATE 8 0 0 None Operational Period To Date 1
HR06 HR06055 NonOpPerFrD2 DATE 8 0 0 None Operational Period From Date 2
HR06 HR06056 NonOpPerToD2 DATE 8 0 0 None Operational Period To Date 2
HR06 HR06057 NonOpPerFrD3 DATE 8 0 0 None Operational Period From Date 3
HR06 HR06058 NonOpPerToD3 DATE 8 0 0 None Operational Period To Date 3
HR06 HR06059 NonOpPerFrD4 DATE 8 0 0 None Operational Period From Date 4
HR06 HR06060 NonOpPerToD4 DATE 8 0 0 None Operational Period To Date 4
HR06 HR06061 NonOpPerFrD5 DATE 8 0 0 None Operational Period From Date 5
HR06 HR06062 NonOpPerToD5 DATE 8 0 0 None Operational Period To Date 5
HR06 HR06063 NonOpPerFrD6 DATE 8 0 0 None Operational Period From Date 6
HR06 HR06064 NonOpPerToD6 DATE 8 0 0 None Operational Period To Date 6
HR06 HR06065 NonOpPerFrD7 DATE 8 0 0 None Operational Period From Date 7
HR06 HR06066 NonOpPerToD7 DATE 8 0 0 None Operational Period To Date 7
HR06 HR06067 NonOpPerFrD8 DATE 8 0 0 None Operational Period From Date 8
HR06 HR06068 NonOpPerToD8 DATE 8 0 0 None Operational Period To Date 8
HR06 HR06069 NonOpPerFrD9 DATE 8 0 0 None Operational Period From Date 9
HR06 HR06070 NonOpPerToD9 DATE 8 0 0 None Operational Period To Date 9
HR06 HR06071 NonOpPerFrD10 DATE 8 0 0 None Operational Period From Date 10
HR06 HR06072 NonOpPerToD10 DATE 8 0 0 None Operational Period To Date 10
HR06 HR06073 NonOpPerFrD11 DATE 8 0 0 None Operational Period From Date 11
HR06 HR06074 NonOpPerToD11 DATE 8 0 0 None Operational Period To Date 11
HR06 HR06075 NonOpPerFrD12 DATE 8 0 0 None Operational Period From Date 12
HR06 HR06076 NonOpPerToD12 DATE 8 0 0 None Operational Period To Date 12
HR06 HR06077 NonOpPerFrD13 DATE 8 0 0 None Operational Period From Date 13
HR06 HR06078 NonOpPerToD13 DATE 8 0 0 None Operational Period To Date 13
HR06 HR06079 NonOpPerFrD14 DATE 8 0 0 None Operational Period From Date 14
HR06 HR06080 NonOpPerToD14 DATE 8 0 0 None Operational Period To Date 14
HR06 HR06081 NonOpPerFrD15 DATE 8 0 0 None Operational Period From Date 15
HR06 HR06082 NonOpPerToD15 DATE 8 0 0 None Operational Period To Date 15
HR06 HR06083 NonOpPerFrD16 DATE 8 0 0 None Operational Period From Date 16
HR06 HR06084 NonOpPerToD16 DATE 8 0 0 None Operational Period To Date 16
HR06 HR06085 Spare DATE 8 0 0 (obsolete)
HR06 HR06086 Spare DATE 8 0 0 (obsolete)
HR06 HR06087 Spare DATE 8 0 0 (obsolete)
HR06 HR06088 Spare DATE 8 0 0 (obsolete)
HR06 HR06089 Spare DATE 8 0 0 (obsolete)
HR06 HR06090 Spare DATE 8 0 0 (obsolete)
HR06 HR06091 Spare DATE 8 0 0 (obsolete)
HR06 HR06092 Spare DATE 8 0 0 (obsolete)
HR06 HR06093 NonOpPerFrT1 VSTRING 5 5 0 Non Operational Period From Time 1
HR06 HR06094 NonOpPerToT1 VSTRING 5 5 0 Non Operational Period To Time 1
HR06 HR06095 NonOpPerFrT2 VSTRING 5 5 0 Non Operational Period From Time 2
HR06 HR06096 NonOpPerToT2 VSTRING 5 5 0 Non Operational Period To Time 2
HR06 HR06097 NonOpPerFrT3 VSTRING 5 5 0 Non Operational Period From Time 3
HR06 HR06098 NonOpPerToT3 VSTRING 5 5 0 Non Operational Period To Time 3
HR06 HR06099 NonOpPerFrT4 VSTRING 5 5 0 Non Operational Period From Time 4
HR06 HR06100 NonOpPerToT4 VSTRING 5 5 0 Non Operational Period To Time 4
HR06 HR06101 NonOpPerFrT5 VSTRING 5 5 0 Non Operational Period From Time 5
HR06 HR06102 NonOpPerToT5 VSTRING 5 5 0 Non Operational Period To Time 5
HR06 HR06103 NonOpPerFrT6 VSTRING 5 5 0 Non Operational Period From Time 6
HR06 HR06104 NonOpPerToT6 VSTRING 5 5 0 Non Operational Period To Time 6
HR06 HR06105 NonOpPerFrT7 VSTRING 5 5 0 Non Operational Period From Time 7
HR06 HR06106 NonOpPerToT7 VSTRING 5 5 0 Non Operational Period To Time 7
HR06 HR06107 NonOpPerFrT8 VSTRING 5 5 0 Non Operational Period From Time 8
HR06 HR06108 NonOpPerToT8 VSTRING 5 5 0 Non Operational Period To Time 8
HR06 HR06109 NonOpPerFrT9 VSTRING 5 5 0 Non Operational Period From Time 9
HR06 HR06110 NonOpPerToT9 VSTRING 5 5 0 Non Operational Period To Time 9
HR06 HR06111 NonOpPerFrT10 VSTRING 5 5 0 Non Operational Period From Time 10
HR06 HR06112 NonOpPerToT10 VSTRING 5 5 0 Non Operational Period To Time 10
HR06 HR06113 NonOpPerFrT11 VSTRING 5 5 0 Non Operational Period From Time 11
HR06 HR06114 NonOpPerToT11 VSTRING 5 5 0 Non Operational Period To Time 11
HR06 HR06115 NonOpPerFrT12 VSTRING 5 5 0 Non Operational Period From Time 12
HR06 HR06116 NonOpPerToT12 VSTRING 5 5 0 Non Operational Period To Time 12
HR06 HR06117 NonOpPerFrT13 VSTRING 5 5 0 Non Operational Period From Time 13
HR06 HR06118 NonOpPerToT13 VSTRING 5 5 0 Non Operational Period To Time 13
HR06 HR06119 NonOpPerFrT14 VSTRING 5 5 0 Non Operational Period From Time 14
HR06 HR06120 NonOpPerToT14 VSTRING 5 5 0 Non Operational Period To Time 14
HR06 HR06121 NonOpPerFrT15 VSTRING 5 5 0 Non Operational Period From Time 15
HR06 HR06122 NonOpPerToT15 VSTRING 5 5 0 Non Operational Period To Time 15
HR06 HR06123 NonOpPerFrT16 VSTRING 5 5 0 Non Operational Period From Time 16
HR06 HR06124 NonOpPerToT16 VSTRING 5 5 0 Non Operational Period To Time 16
HR06 HR06125 Spare VSTRING 5 5 0 (obsolete)
HR06 HR06126 Spare VSTRING 5 5 0 (obsolete)
HR06 HR06127 Spare VSTRING 5 5 0 (obsolete)
HR06 HR06128 Spare VSTRING 5 5 0 (obsolete)
HR06 HR06129 Spare VSTRING 5 5 0 (obsolete)
HR06 HR06130 Spare VSTRING 5 5 0 (obsolete)
HR06 HR06131 Spare VSTRING 5 5 0 (obsolete)
HR06 HR06132 Spare VSTRING 5 5 0 (obsolete)