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 PA13 PA13001 IndexKey STRING 4 4 0 Index Key Always the company code + '00'
PA13 PA13002 AccumNumDec0 STRING 1 1 0 Decimals in Accumulator 0
PA13 PA13003 AccumNumDec1 STRING 1 1 0 Decimals in Accumulator 1
PA13 PA13004 AccumNumDec2 STRING 1 1 0 Decimals in Accumulator 2
PA13 PA13005 AccumNumDec3 STRING 1 1 0 Decimals in Accumulator 3
PA13 PA13006 AccumNumDec4 STRING 1 1 0 Decimals in Accumulator 4
PA13 PA13007 AccumNumDec5 STRING 1 1 0 Decimals in Accumulator 5
PA13 PA13008 AccumNumDec6 STRING 1 1 0 Decimals in Accumulator 6
PA13 PA13009 AccumNumDec7 STRING 1 1 0 Decimals in Accumulator 7
PA13 PA13010 AccumNumDec8 STRING 1 1 0 Decimals in Accumulator 8
PA13 PA13011 AccumNumDec9 STRING 1 1 0 Decimals in Accumulator 9
PA13 PA13012 AccumNoDec10 STRING 1 1 0 Decimals in Accumulator 10
PA13 PA13013 AccumNoDec11 STRING 1 1 0 Decimals in Accumulator 11
PA13 PA13014 AccumNoDec12 STRING 1 1 0 Decimals in Accumulator 12
PA13 PA13015 AccumNoDec13 STRING 1 1 0 Decimals in Accumulator 13
PA13 PA13016 AccumNoDec14 STRING 1 1 0 Decimals in Accumulator 14
PA13 PA13017 AccumNoDec15 STRING 1 1 0 Decimals in Accumulator 15
PA13 PA13018 AccumNoDec16 STRING 1 1 0 Decimals in Accumulator 16
PA13 PA13019 AccumNoDec17 STRING 1 1 0 Decimals in Accumulator 17
PA13 PA13020 AccumNoDec18 STRING 1 1 0 Decimals in Accumulator 18
PA13 PA13021 AccumNoDec19 STRING 1 1 0 Decimals in Accumulator 19
PA13 PA13022 AccumNoDec20 STRING 1 1 0 Decimals in Accumulator 20
PA13 PA13023 AccumNoDec21 STRING 1 1 0 Decimals in Accumulator 21
PA13 PA13024 AccumNoDec22 STRING 1 1 0 Decimals in Accumulator 22
PA13 PA13025 AccumNoDec23 STRING 1 1 0 Decimals in Accumulator 23
PA13 PA13026 AccumNoDec24 STRING 1 1 0 Decimals in Accumulator 24
PA13 PA13027 AccumNoDec25 STRING 1 1 0 Decimals in Accumulator 25
PA13 PA13028 AccumNoDec26 STRING 1 1 0 Decimals in Accumulator 26
PA13 PA13029 AccumNoDec27 STRING 1 1 0 Decimals in Accumulator 27
PA13 PA13030 AccumNoDec28 STRING 1 1 0 Decimals in Accumulator 28
PA13 PA13031 AccumNoDec29 STRING 1 1 0 Decimals in Accumulator 29
PA13 PA13032 AccumNoDec30 STRING 1 1 0 Decimals in Accumulator 30
PA13 PA13033 AccumNoDec31 STRING 1 1 0 Decimals in Accumulator 31
PA13 PA13034 AccumNoDec32 STRING 1 1 0 Decimals in Accumulator 32
PA13 PA13035 AccumNoDec33 STRING 1 1 0 Decimals in Accumulator 33
PA13 PA13036 AccumNoDec34 STRING 1 1 0 Decimals in Accumulator 34
PA13 PA13037 AccumNoDec35 STRING 1 1 0 Decimals in Accumulator 35
PA13 PA13038 AccumNoDec36 STRING 1 1 0 Decimals in Accumulator 36
PA13 PA13039 AccumNoDec37 STRING 1 1 0 Decimals in Accumulator 37
PA13 PA13040 AccumNoDec38 STRING 1 1 0 Decimals in Accumulator 38
PA13 PA13041 AccumNoDec39 STRING 1 1 0 Decimals in Accumulator 39
PA13 PA13042 AccumNoDec40 STRING 1 1 0 Decimals in Accumulator 40
PA13 PA13043 AccumNoDec41 STRING 1 1 0 Decimals in Accumulator 41
PA13 PA13044 AccumNoDec42 STRING 1 1 0 Decimals in Accumulator 42
PA13 PA13045 AccumNoDec43 STRING 1 1 0 Decimals in Accumulator 43
PA13 PA13046 AccumNoDec44 STRING 1 1 0 Decimals in Accumulator 44
PA13 PA13047 AccumNoDec45 STRING 1 1 0 Decimals in Accumulator 45
PA13 PA13048 AccumNoDec46 STRING 1 1 0 Decimals in Accumulator 46
PA13 PA13049 AccumNoDec47 STRING 1 1 0 Decimals in Accumulator 47
PA13 PA13050 AccumNoDec48 STRING 1 1 0 Decimals in Accumulator 48
PA13 PA13051 AccumNoDec49 STRING 1 1 0 Decimals in Accumulator 49
PA13 PA13052 AccumNoDec50 STRING 1 1 0 Decimals in Accumulator 50
PA13 PA13053 AccumNoDec51 STRING 1 1 0 Decimals in Accumulator 51
PA13 PA13054 AccumNoDec52 STRING 1 1 0 Decimals in Accumulator 52
PA13 PA13055 AccumNoDec53 STRING 1 1 0 Decimals in Accumulator 53
PA13 PA13056 AccumNoDec54 STRING 1 1 0 Decimals in Accumulator 54
PA13 PA13057 AccumNoDec55 STRING 1 1 0 Decimals in Accumulator 55
PA13 PA13058 AccumNoDec56 STRING 1 1 0 Decimals in Accumulator 56
PA13 PA13059 AccumNoDec57 STRING 1 1 0 Decimals in Accumulator 57
PA13 PA13060 AccumNoDec58 STRING 1 1 0 Decimals in Accumulator 58
PA13 PA13061 AccumNoDec59 STRING 1 1 0 Decimals in Accumulator 59
PA13 PA13062 AccumNoDec60 STRING 1 1 0 Decimals in Accumulator 60
PA13 PA13063 AccumNoDec61 STRING 1 1 0 Decimals in Accumulator 61
PA13 PA13064 AccumNoDec62 STRING 1 1 0 Decimals in Accumulator 62
PA13 PA13065 AccumNoDec63 STRING 1 1 0 Decimals in Accumulator 63
PA13 PA13066 AccumNoDec64 STRING 1 1 0 Decimals in Accumulator 64
PA13 PA13067 AccumNoDec65 STRING 1 1 0 Decimals in Accumulator 65
PA13 PA13068 AccumNoDec66 STRING 1 1 0 Decimals in Accumulator 66
PA13 PA13069 AccumNoDec67 STRING 1 1 0 Decimals in Accumulator 67
PA13 PA13070 AccumNoDec68 STRING 1 1 0 Decimals in Accumulator 68
PA13 PA13071 AccumNoDec69 STRING 1 1 0 Decimals in Accumulator 69
PA13 PA13072 AccumNoDec70 STRING 1 1 0 Decimals in Accumulator 70
PA13 PA13073 AccumNoDec71 STRING 1 1 0 Decimals in Accumulator 71
PA13 PA13074 AccumNoDec72 STRING 1 1 0 Decimals in Accumulator 72
PA13 PA13075 AccumNoDec73 STRING 1 1 0 Decimals in Accumulator 73
PA13 PA13076 AccumNoDec74 STRING 1 1 0 Decimals in Accumulator 74
PA13 PA13077 AccumNoDec75 STRING 1 1 0 Decimals in Accumulator 75
PA13 PA13078 AccumNoDec76 STRING 1 1 0 Decimals in Accumulator 76
PA13 PA13079 AccumNoDec77 STRING 1 1 0 Decimals in Accumulator 77
PA13 PA13080 AccumNoDec78 STRING 1 1 0 Decimals in Accumulator 78
PA13 PA13081 AccumNoDec79 STRING 1 1 0 Decimals in Accumulator 79
PA13 PA13082 AccumNoDec80 STRING 1 1 0 Decimals in Accumulator 80
PA13 PA13083 AccumNoDec81 STRING 1 1 0 Decimals in Accumulator 81
PA13 PA13084 AccumNoDec82 STRING 1 1 0 Decimals in Accumulator 82
PA13 PA13085 AccumNoDec83 STRING 1 1 0 Decimals in Accumulator 83
PA13 PA13086 AccumNoDec84 STRING 1 1 0 Decimals in Accumulator 84
PA13 PA13087 AccumNoDec85 STRING 1 1 0 Decimals in Accumulator 85
PA13 PA13088 AccumNoDec86 STRING 1 1 0 Decimals in Accumulator 86
PA13 PA13089 AccumNoDec87 STRING 1 1 0 Decimals in Accumulator 87
PA13 PA13090 AccumNoDec88 STRING 1 1 0 Decimals in Accumulator 88
PA13 PA13091 AccumNoDec89 STRING 1 1 0 Decimals in Accumulator 89
PA13 PA13092 AccumNoDec90 STRING 1 1 0 Decimals in Accumulator 90
PA13 PA13093 AccumNoDec91 STRING 1 1 0 Decimals in Accumulator 91
PA13 PA13094 AccumNoDec92 STRING 1 1 0 Decimals in Accumulator 92
PA13 PA13095 AccumNoDec93 STRING 1 1 0 Decimals in Accumulator 93
PA13 PA13096 AccumNoDec94 STRING 1 1 0 Decimals in Accumulator 94
PA13 PA13097 AccumNoDec95 STRING 1 1 0 Decimals in Accumulator 95
PA13 PA13098 DefFldDec0 STRING 1 1 0 Decimals in User Defined Parameter 0
PA13 PA13099 DefFldDec1 STRING 1 1 0 Decimals in User Defined Parameter 1
PA13 PA13100 DefFldDec2 STRING 1 1 0 Decimals in User Defined Parameter 2
PA13 PA13101 DefFldDec3 STRING 1 1 0 Decimals in User Defined Parameter 3
PA13 PA13102 DefFldDec4 STRING 1 1 0 Decimals in User Defined Parameter 4
PA13 PA13103 DefFldDec5 STRING 1 1 0 Decimals in User Defined Parameter 5
PA13 PA13104 DefFldDec6 STRING 1 1 0 Decimals in User Defined Parameter 6
PA13 PA13105 DefFldDec7 STRING 1 1 0 Decimals in User Defined Parameter 7
PA13 PA13106 DefFldDec8 STRING 1 1 0 Decimals in User Defined Parameter 8
PA13 PA13107 DefFldDec9 STRING 1 1 0 Decimals in User Defined Parameter 9
PA13 PA13108 ExtAccumDec0 STRING 1 1 0 Decimals in Extended Accumulator 0
PA13 PA13109 ExtAccumDec1 STRING 1 1 0 Decimals in Extended Accumulator 1
PA13 PA13110 ExtAccumDec2 STRING 1 1 0 Decimals in Extended Accumulator 2
PA13 PA13111 ExtAccumDec3 STRING 1 1 0 Decimals in Extended Accumulator 3
PA13 PA13112 ExtAccumDec4 STRING 1 1 0 Decimals in Extended Accumulator 4
PA13 PA13113 ExtAccumDec5 STRING 1 1 0 Decimals in Extended Accumulator 5
PA13 PA13114 ExtAccumDec6 STRING 1 1 0 Decimals in Extended Accumulator 6
PA13 PA13115 ExtAccumDec7 STRING 1 1 0 Decimals in Extended Accumulator 7
PA13 PA13116 ExtAccumDec8 STRING 1 1 0 Decimals in Extended Accumulator 8
PA13 PA13117 ExtAccumDec9 STRING 1 1 0 Decimals in Extended Accumulator 9
PA13 PA13118 ExtAccumDe10 STRING 1 1 0 Decimals in Extended Accumulator 10
PA13 PA13119 ExtAccumDe11 STRING 1 1 0 Decimals in Extended Accumulator 11
PA13 PA13120 ExtAccumDe12 STRING 1 1 0 Decimals in Extended Accumulator 12
PA13 PA13121 ExtAccumDe13 STRING 1 1 0 Decimals in Extended Accumulator 13
PA13 PA13122 ExtAccumDe14 STRING 1 1 0 Decimals in Extended Accumulator 14
PA13 PA13123 ExtAccumDe15 STRING 1 1 0 Decimals in Extended Accumulator 15
PA13 PA13124 ExtAccumDe16 STRING 1 1 0 Decimals in Extended Accumulator 16
PA13 PA13125 ExtAccumDe17 STRING 1 1 0 Decimals in Extended Accumulator 17
PA13 PA13126 ExtAccumDe18 STRING 1 1 0 Decimals in Extended Accumulator 18
PA13 PA13127 ExtAccumDe19 STRING 1 1 0 Decimals in Extended Accumulator 19
PA13 PA13128 ExtAccumDe20 STRING 1 1 0 Decimals in Extended Accumulator 20
PA13 PA13129 ExtAccumDe21 STRING 1 1 0 Decimals in Extended Accumulator 21
PA13 PA13130 ExtAccumDe22 STRING 1 1 0 Decimals in Extended Accumulator 22
PA13 PA13131 ExtAccumDe23 STRING 1 1 0 Decimals in Extended Accumulator 23
PA13 PA13132 ExtAccumDe24 STRING 1 1 0 Decimals in Extended Accumulator 24
PA13 PA13133 ExtAccumDe25 STRING 1 1 0 Decimals in Extended Accumulator 25
PA13 PA13134 ExtAccumDe26 STRING 1 1 0 Decimals in Extended Accumulator 26
PA13 PA13135 ExtAccumDe27 STRING 1 1 0 Decimals in Extended Accumulator 27
PA13 PA13136 ExtAccumDe28 STRING 1 1 0 Decimals in Extended Accumulator 28
PA13 PA13137 ExtAccumDe29 STRING 1 1 0 Decimals in Extended Accumulator 29