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
PA01 Payroll Parameters Company Year PA010112
PA02 Unions Company PA020100
PA03 Wage Types Company PA030100
PA04 Employees Company PA040100
PA05 Fixed Wage Types Company PA050100
PA06 Payroll Statistics Company PA060100
PA07 Reported Salary Transaction Company PA070100
PA08 Tax Tables Company PA080100
PA09 Payroll Calculation Company PA090100
PA10 Payroll Payment List Company PA100100
PA11 Employee History Company PA110100
PA12 Employee Search Table Company PA120100
PA13 Employee Record Setup Company PA130100
PA14 Report Names Company PA140100
PA17 Payroll Journal Company Year PA170112
PA19 Payroll Calculation Constants Company PA190100
PA20 Extended Accumulators Company PA200100
PA23 Previous Employees Company PA230100
PA24 Previous Employees Search Table Company PA240100
PA25 Previous Employees Extended Accumulators Company PA250100
PA2A Previous Employees Accumulators Company PA2A0100
PA2B Extended Accumulators Template Company PA2B0100
PA31 Work Calendar Company PA310100
PA32 Timesheet Parameters Company PA320100
PA33 Time Sheets Company PA330100
PA34 Payroll Periodical Accumulators Company PA340100
PA35 Payroll Calculation Models Company PA350100
PA37 Other Tables Company PA370100
PA38 User Table Setup Company PA380100
PA39 Payroll Dictionaries Company PA390100
PA3A Timesheet Parameters 2 Company PA3A0100
PA40 Dictionary Search Table Company PA400100
PA41 Multilingual Name Company PA410100
PA44 Periodical Accumulators Setup Company PA440100
PA45 Report Work Table Company PA450100
PA46 Employee History of Field Changes Company PA460100
PA4A Employee Accumulators Company PA4A0100
PA4B Employee Templates Company PA4B0100
PA4C Employees Accumulator Templates Company PA4C0100
PA4D Employee Image Company PA4D0100
PA50 Dictionary Links Company PA500100
PA60 Individual Timesheet Details Company PA600100
PA61 Individual Timesheet Company PA610100
PA62 PA62 Ts Signs Company PA620100
PA63 PA63 Tc Main Company PA630100
PA64 PA64 Tc Line Company PA640100
PA70 Time Type Company PA700100
PA75 Payroll History Company PA750100
PA76 Payroll Transaction Company PA760100
PA77 Payroll Groups Company PA770100
PA81 Task Main Company PA810100
PA82 Task Details Company PA820100
paAuditDetails Audit details Company paAuditDetails0100
paAuditHeader Audit header Company paAuditHeader0100
paBatchHeader Batch header Company paBatchHeader0100
paBatchRepWages Batch of reported wages Company paBatchRepWages0100
paBTRepWages Business Transactions for Reported Wages Company paBTRepWages0100
paBudgetDraft Budget Draft Company paBudgetDraft0100
paBudgetEmplAcc Budget Accumulators Company paBudgetEmplAcc0100
paBudgetEmplCard Budget Employee Card Company paBudgetEmplCard0100
paBudgetEmplExtAcc Budget Extended Acc. Company paBudgetEmplExtAcc0100
paBudgetEmplHistory Budget Employee History Company paBudgetEmplHistory0100
paBudgetEmplPerAcc Spare table Company paBudgetEmplPerAcc0100
paBudgetEmplSearch Budget Employee Search Company paBudgetEmplSearch0100
paBudgetEmplTaxes Budget employees-taxes links Company Year paBudgetEmplTaxes0112
paBudgetFixedWages Budget Fixed Wages Company paBudgetFixedWages0100
paBudgetHistoryOfChanges Budget History of Changes Company paBudgetHistoryOfChanges0100
paBudgetHistoryOfChangesYD Budget History Of Changes (year dependent) Company Year paBudgetHistoryOfChangesYD0112
paBudgetLevels Budget Levels Company paBudgetLevels0100
paBudgetLevelsWages Budget Levels Wages Company paBudgetLevelsWages0100
paBudgetPerAccsData Budget Periodical Accumulators Company paBudgetPerAccsData0100
paBudgetPeriodDetails Budget Period Details Company paBudgetPeriodDetails0100
paBudgetPeriodHead Budget Period Head Company paBudgetPeriodHead0100
paBudgetStat Budget Statistics Company paBudgetStat0100
paCalcAccum Calculated Accumulators Company paCalcAccum0100
paCalcModelWages Calculated model wage types Company paCalcModelWages0100
paContractExt Contract extended attributes Company paContractExt0100
paCustomFilterConfig Custom filter metadescriptions Company paCustomFilterConfig0100
paCustomTreeConfig Company paCustomTreeConfig0100
paDictExt Extension of dictionaries Company paDictExt0100
paEmplCard Employees (Advanced PA) Company paEmplCard0100
paEmplHistory Employee history Company paEmplHistory0100
paEmplSearch Employee Search (Advanced PA) Company paEmplSearch0100
paEmplTaxes Employees-taxes links Company Year paEmplTaxes0112
paHistoryCategoryFields Fields of History Categories Company paHistoryCategoryFields0100
paHistoryOfChanges History of Changes Company paHistoryOfChanges0100
paHistoryOfChangesYD History Of Changes (year dependent) Company Year paHistoryOfChangesYD0112
PAL1 PAL1 Comp Report Main Company PAL10100
PAL2 PAL2 Comp Report Details Company PAL20100
paOlapLayouts OLAP Layouts Company paOlapLayouts0100
paPerAccs Periodical Accumulators Setup (Advanced Payroll) Company paPerAccs0100
paPerAccsData Periodical Accumulators Data (Advanced Payroll) Company paPerAccsData0100
paPerAccsNames Periodical Accumulators Names Company paPerAccsNames0100
paPersCard Persons (Advanced PA) Company paPersCard0100
paPersSearch Person Search (Advanced PA) Company paPersSearch0100
PAR1 Report Main Company PAR10100
PAR2 Report Details Company PAR20100
PAR3 Definition Company PAR30100
PAR4 Definition Rules Company PAR40100
paReportAccess Company paReportAccess0100
paSetupHist History of changes - Setup Company paSetupHist0100
paSetupHistYD History of changes - Setup (year dependent) Company Year paSetupHistYD0112
paShifts Company paShifts0100
paTaxes Taxes Company Year paTaxes0112
paTaxesDetails Details of taxes Company Year paTaxesDetails0112
paTaxesNames Taxes names Company Year paTaxesNames0112
paTimeActGroups Company paTimeActGroups0100
paTimeTrans Company paTimeTrans0100
paTimeTransBatch Company paTimeTransBatch0100
paTimeTransLinks Company paTimeTransLinks0100
paTransStat Payroll Journal Statistics Company Year paTransStat0112
paTreeRelations Tree Relations Company paTreeRelations0100
paTSStat Timesheet statistics Company paTSStat0100
PAU3 PAU3 User Group Rights Company PAU30100
paWageExt Extension of wage types Company paWageExt0100
PAX0 Synchronization Company PAX00100

Fields
PK Table Name Description Type Length Precision Note
1 PA32 PA32001 IndexKey STRING 4 4 0 Index Key Always the company code + '00'
PA32 PA32002 FileNo0 STRING 2 2 0 Day Type 0
PA32 PA32003 FieldNo0 STRING 3 3 0 Field Number/Hour Type 0 If the parameter type is 2 (employee information) this will be the field number in the employee record, for parameter type 4 and 6 it will be the hour type 0-9.
PA32 PA32004 Total0 STRING 1 1 0 Total Required 0
PA32 PA32005 Type0 STRING 2 2 0 Parameter Type 0 0 - Not used
1 - Zero field
2 - Employee information
3 - Worked days
4 - Worked hours
5 - Planned days
6 - Planned hours
PA32 PA32006 FileNo1 STRING 2 2 0 Day Type 1
PA32 PA32007 FieldNo1 STRING 3 3 0 Field Number/Hour Type 1
PA32 PA32008 Total1 STRING 1 1 0 Total Required 1
PA32 PA32009 Type1 STRING 2 2 0 Parameter Type 1
PA32 PA32010 FileNo2 STRING 2 2 0 Day Type 2
PA32 PA32011 FieldNo2 STRING 3 3 0 Field Number/Hour Type 2
PA32 PA32012 Total2 STRING 1 1 0 Total Required 2
PA32 PA32013 Type2 STRING 2 2 0 Parameter Type 2
PA32 PA32014 FileNo3 STRING 2 2 0 Day Type 3
PA32 PA32015 FieldNo3 STRING 3 3 0 Field Number/Hour Type 3
PA32 PA32016 Total3 STRING 1 1 0 Total Required 3
PA32 PA32017 Type3 STRING 2 2 0 Parameter Type 3
PA32 PA32018 FileNo4 STRING 2 2 0 Day Type 4
PA32 PA32019 FieldNo4 STRING 3 3 0 Field Number/Hour Type 4
PA32 PA32020 Total4 STRING 1 1 0 Total Required 4
PA32 PA32021 Type4 STRING 2 2 0 Parameter Type 4
PA32 PA32022 FileNo5 STRING 2 2 0 Day Type 5
PA32 PA32023 FieldNo5 STRING 3 3 0 Field Number/Hour Type 5
PA32 PA32024 Total5 STRING 1 1 0 Total Required 5
PA32 PA32025 Type5 STRING 2 2 0 Parameter Type 5
PA32 PA32026 FileNo6 STRING 2 2 0 Day Type 6
PA32 PA32027 FieldNo6 STRING 3 3 0 Field Number/Hour Type 6
PA32 PA32028 Total6 STRING 1 1 0 Total Required 6
PA32 PA32029 Type6 STRING 2 2 0 Parameter Type 6
PA32 PA32030 FileNo7 STRING 2 2 0 Day Type 7
PA32 PA32031 FieldNo7 STRING 3 3 0 Field Number/Hour Type 7
PA32 PA32032 Total7 STRING 1 1 0 Total Required 7
PA32 PA32033 Type7 STRING 2 2 0 Parameter Type 7
PA32 PA32034 FileNo8 STRING 2 2 0 Day Type 8
PA32 PA32035 FieldNo8 STRING 3 3 0 Field Number/Hour Type 8
PA32 PA32036 Total8 STRING 1 1 0 Total Required 8
PA32 PA32037 Type8 STRING 2 2 0 Parameter Type 8
PA32 PA32038 FileNo9 STRING 2 2 0 Day Type 9
PA32 PA32039 FieldNo9 STRING 3 3 0 Field Number/Hour Type 9
PA32 PA32040 Total9 STRING 1 1 0 Total Required 9
PA32 PA32041 Type9 STRING 2 2 0 Parameter Type 9
PA32 PA32042 FileNo10 STRING 2 2 0 Day Type 10
PA32 PA32043 FieldNo10 STRING 3 3 0 Field Number/Hour Type 10
PA32 PA32044 Total10 STRING 1 1 0 Total Required 10
PA32 PA32045 Type10 STRING 2 2 0 Parameter Type 10
PA32 PA32046 FileNo11 STRING 2 2 0 Day Type 11
PA32 PA32047 FieldNo11 STRING 3 3 0 Field Number/Hour Type 11
PA32 PA32048 Total11 STRING 1 1 0 Total Required 11
PA32 PA32049 Type11 STRING 2 2 0 Parameter Type 11
PA32 PA32050 FileNo12 STRING 2 2 0 Day Type 12
PA32 PA32051 FieldNo12 STRING 3 3 0 Field Number/Hour Type 12
PA32 PA32052 Total12 STRING 1 1 0 Total Required 12
PA32 PA32053 Type12 STRING 2 2 0 Parameter Type 12
PA32 PA32054 FileNo13 STRING 2 2 0 Day Type 13
PA32 PA32055 FieldNo13 STRING 3 3 0 Field Number/Hour Type 13
PA32 PA32056 Total13 STRING 1 1 0 Total Required 13
PA32 PA32057 Type13 STRING 2 2 0 Parameter Type 13
PA32 PA32058 FileNo14 STRING 2 2 0 Day Type 14
PA32 PA32059 FieldNo14 STRING 3 3 0 Field Number/Hour Type 14
PA32 PA32060 Total14 STRING 1 1 0 Total Required 14
PA32 PA32061 Type14 STRING 2 2 0 Parameter Type 14
PA32 PA32062 FileNo15 STRING 2 2 0 Day Type 15
PA32 PA32063 FieldNo15 STRING 3 3 0 Field Number/Hour Type 15
PA32 PA32064 Total15 STRING 1 1 0 Total Required 15
PA32 PA32065 Type15 STRING 2 2 0 Parameter Type 15
PA32 PA32066 FileNo16 STRING 2 2 0 Day Type 16
PA32 PA32067 FieldNo16 STRING 3 3 0 Field Number/Hour Type 16
PA32 PA32068 Total16 STRING 1 1 0 Total Required 16
PA32 PA32069 Type16 STRING 2 2 0 Parameter Type 16
PA32 PA32070 FileNo17 STRING 2 2 0 Day Type 17
PA32 PA32071 FieldNo17 STRING 3 3 0 Field Number/Hour Type 17
PA32 PA32072 Total17 STRING 1 1 0 Total Required 17
PA32 PA32073 Type17 STRING 2 2 0 Parameter Type 17
PA32 PA32074 FileNo18 STRING 2 2 0 Day Type 18
PA32 PA32075 FieldNo18 STRING 3 3 0 Field Number/Hour Type 18
PA32 PA32076 Total18 STRING 1 1 0 Total Required 18
PA32 PA32077 Type18 STRING 2 2 0 Parameter Type 18
PA32 PA32078 FileNo19 STRING 2 2 0 Day Type 19
PA32 PA32079 FieldNo19 STRING 3 3 0 Field Number/Hour Type 19
PA32 PA32080 Total19 STRING 1 1 0 Total Required 19
PA32 PA32081 Type19 STRING 2 2 0 Parameter Type 19
PA32 PA32082 FileNo20 STRING 2 2 0 Day Type 20
PA32 PA32083 FieldNo20 STRING 3 3 0 Field Number/Hour Type 20
PA32 PA32084 Total20 STRING 1 1 0 Total Required 20
PA32 PA32085 Type20 STRING 2 2 0 Parameter Type 20
PA32 PA32086 FileNo21 STRING 2 2 0 Day Type 21
PA32 PA32087 FieldNo21 STRING 3 3 0 Field Number/Hour Type 21
PA32 PA32088 Total21 STRING 1 1 0 Total Required 21
PA32 PA32089 Type21 STRING 2 2 0 Parameter Type 21
PA32 PA32090 FileNo22 STRING 2 2 0 Day Type 22
PA32 PA32091 FieldNo22 STRING 3 3 0 Field Number/Hour Type 22
PA32 PA32092 Total22 STRING 1 1 0 Total Required 22
PA32 PA32093 Type22 STRING 2 2 0 Parameter Type 22
PA32 PA32094 FileNo23 STRING 2 2 0 Day Type 23
PA32 PA32095 FieldNo23 STRING 3 3 0 Field Number/Hour Type 23
PA32 PA32096 Total23 STRING 1 1 0 Total Required 23
PA32 PA32097 Type23 STRING 2 2 0 Parameter Type 23
PA32 PA32098 FileNo24 STRING 2 2 0 Day Type 24
PA32 PA32099 FieldNo24 STRING 3 3 0 Field Number/Hour Type 24
PA32 PA32100 Total24 STRING 1 1 0 Total Required 24
PA32 PA32101 Type24 STRING 2 2 0 Parameter Type 24
PA32 PA32102 FileNo25 STRING 2 2 0 Day Type 25
PA32 PA32103 FieldNo25 STRING 3 3 0 Field Number/Hour Type 25
PA32 PA32104 Total25 STRING 1 1 0 Total Required 25
PA32 PA32105 Type25 STRING 2 2 0 Parameter Type 25
PA32 PA32106 FileNo26 STRING 2 2 0 Day Type 26
PA32 PA32107 FieldNo26 STRING 3 3 0 Field Number/Hour Type 26
PA32 PA32108 Total26 STRING 1 1 0 Total Required 26
PA32 PA32109 Type26 STRING 2 2 0 Parameter Type 26
PA32 PA32110 FileNo27 STRING 2 2 0 Day Type 27
PA32 PA32111 FieldNo27 STRING 3 3 0 Field Number/Hour Type 27
PA32 PA32112 Total27 STRING 1 1 0 Total Required 27
PA32 PA32113 Type27 STRING 2 2 0 Parameter Type 27
PA32 PA32114 FileNo28 STRING 2 2 0 Day Type 28
PA32 PA32115 FieldNo28 STRING 3 3 0 Field Number/Hour Type 28
PA32 PA32116 Total28 STRING 1 1 0 Total Required 28
PA32 PA32117 Type28 STRING 2 2 0 Parameter Type 28
PA32 PA32118 FileNo29 STRING 2 2 0 Day Type 29
PA32 PA32119 FieldNo29 STRING 3 3 0 Field Number/Hour Type 29
PA32 PA32120 Total29 STRING 1 1 0 Total Required 29
PA32 PA32121 Type29 STRING 2 2 0 Parameter Type 29
PA32 PA32122 FileNo30 STRING 2 2 0 Day Type 30
PA32 PA32123 FieldNo30 STRING 3 3 0 Field Number/Hour Type 30
PA32 PA32124 Total30 STRING 1 1 0 Total Required 30
PA32 PA32125 Type30 STRING 2 2 0 Parameter Type 30
PA32 PA32126 FileNo31 STRING 2 2 0 Day Type 31
PA32 PA32127 FieldNo31 STRING 3 3 0 Field Number/Hour Type 31
PA32 PA32128 Total31 STRING 1 1 0 Total Required 31
PA32 PA32129 Type31 STRING 2 2 0 Parameter Type 31
PA32 PA32130 FileNo32 STRING 2 2 0 Day Type 32
PA32 PA32131 FieldNo32 STRING 3 3 0 Field Number/Hour Type 32
PA32 PA32132 Total32 STRING 1 1 0 Total Required 32
PA32 PA32133 Type32 STRING 2 2 0 Parameter Type 32
PA32 PA32134 FileNo33 STRING 2 2 0 Day Type 33
PA32 PA32135 FieldNo33 STRING 3 3 0 Field Number/Hour Type 33
PA32 PA32136 Total33 STRING 1 1 0 Total Required 33
PA32 PA32137 Type33 STRING 2 2 0 Parameter Type 33
PA32 PA32138 FileNo34 STRING 2 2 0 Day Type 34
PA32 PA32139 FieldNo34 STRING 3 3 0 Field Number/Hour Type 34
PA32 PA32140 Total34 STRING 1 1 0 Total Required 34
PA32 PA32141 Type34 STRING 2 2 0 Parameter Type 34
PA32 PA32142 FileNo35 STRING 2 2 0 Day Type 35
PA32 PA32143 FieldNo35 STRING 3 3 0 Field Number/Hour Type 35
PA32 PA32144 Total35 STRING 1 1 0 Total Required 35
PA32 PA32145 Type35 STRING 2 2 0 Parameter Type 35
PA32 PA32146 FileNo36 STRING 2 2 0 Day Type 36
PA32 PA32147 FieldNo36 STRING 3 3 0 Field Number/Hour Type 36
PA32 PA32148 Total36 STRING 1 1 0 Total Required 36
PA32 PA32149 Type36 STRING 2 2 0 Parameter Type 36
PA32 PA32150 FileNo37 STRING 2 2 0 Day Type 37
PA32 PA32151 FieldNo37 STRING 3 3 0 Field Number/Hour Type 37
PA32 PA32152 Total37 STRING 1 1 0 Total Required 37
PA32 PA32153 Type37 STRING 2 2 0 Parameter Type 37
PA32 PA32154 FileNo38 STRING 2 2 0 Day Type 38
PA32 PA32155 FieldNo38 STRING 3 3 0 Field Number/Hour Type 38
PA32 PA32156 Total38 STRING 1 1 0 Total Required 38
PA32 PA32157 Type38 STRING 2 2 0 Parameter Type 38
PA32 PA32158 FileNo39 STRING 2 2 0 Day Type 39
PA32 PA32159 FieldNo39 STRING 3 3 0 Field Number/Hour Type 39
PA32 PA32160 Total39 STRING 1 1 0 Total Required 39
PA32 PA32161 Type39 STRING 2 2 0 Parameter Type 39
PA32 PA32162 FileNo40 STRING 2 2 0 Day Type 40
PA32 PA32163 FieldNo40 STRING 3 3 0 Field Number/Hour Type 40
PA32 PA32164 Total40 STRING 1 1 0 Total Required 40
PA32 PA32165 Type40 STRING 2 2 0 Parameter Type 40
PA32 PA32166 FileNo41 STRING 2 2 0 Day Type 41
PA32 PA32167 FieldNo41 STRING 3 3 0 Field Number/Hour Type 41
PA32 PA32168 Total41 STRING 1 1 0 Total Required 41
PA32 PA32169 Type41 STRING 2 2 0 Parameter Type 41
PA32 PA32170 FileNo42 STRING 2 2 0 Day Type 42
PA32 PA32171 FieldNo42 STRING 3 3 0 Field Number/Hour Type 42
PA32 PA32172 Total42 STRING 1 1 0 Total Required 42
PA32 PA32173 Type42 STRING 2 2 0 Parameter Type 42
PA32 PA32174 FileNo43 STRING 2 2 0 Day Type 43
PA32 PA32175 FieldNo43 STRING 3 3 0 Field Number/Hour Type 43
PA32 PA32176 Total43 STRING 1 1 0 Total Required 43
PA32 PA32177 Type43 STRING 2 2 0 Parameter Type 43
PA32 PA32178 FileNo44 STRING 2 2 0 Day Type 44
PA32 PA32179 FieldNo44 STRING 3 3 0 Field Number/Hour Type 44
PA32 PA32180 Total44 STRING 1 1 0 Total Required 44
PA32 PA32181 Type44 STRING 2 2 0 Parameter Type 44
PA32 PA32182 FileNo45 STRING 2 2 0 Day Type 45
PA32 PA32183 FieldNo45 STRING 3 3 0 Field Number/Hour Type 45
PA32 PA32184 Total45 STRING 1 1 0 Total Required 45
PA32 PA32185 Type45 STRING 2 2 0 Parameter Type 45
PA32 PA32186 FileNo46 STRING 2 2 0 Day Type 46
PA32 PA32187 FieldNo46 STRING 3 3 0 Field Number/Hour Type 46
PA32 PA32188 Total46 STRING 1 1 0 Total Required 46
PA32 PA32189 Type46 STRING 2 2 0 Parameter Type 46
PA32 PA32190 FileNo47 STRING 2 2 0 Day Type 47
PA32 PA32191 FieldNo47 STRING 3 3 0 Field Number/Hour Type 47
PA32 PA32192 Total47 STRING 1 1 0 Total Required 47
PA32 PA32193 Type47 STRING 2 2 0 Parameter Type 47