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 PA3A PA3A001 IndexKey STRING 4 4 0 Index Key Always the company code + '00'
PA3A PA3A002 Check0 STRING 1 1 0 Check Value 0
PA3A PA3A003 Lo0 VSTRING 19 19 0 Minimum Value 0
PA3A PA3A004 Hi0 VSTRING 19 19 0 Maximum Value 0
PA3A PA3A005 Check1 STRING 1 1 0 Check Value 1
PA3A PA3A006 Lo1 VSTRING 19 19 0 Minimum Value 1
PA3A PA3A007 Hi1 VSTRING 19 19 0 Maximum Value 1
PA3A PA3A008 Check2 STRING 1 1 0 Check Value 2
PA3A PA3A009 Lo2 VSTRING 19 19 0 Minimum Value 2
PA3A PA3A010 Hi2 VSTRING 19 19 0 Maximum Value 2
PA3A PA3A011 Check3 STRING 1 1 0 Check Value 3
PA3A PA3A012 Lo3 VSTRING 19 19 0 Minimum Value 3
PA3A PA3A013 Hi3 VSTRING 19 19 0 Maximum Value 3
PA3A PA3A014 Check4 STRING 1 1 0 Check Value 4
PA3A PA3A015 Lo4 VSTRING 19 19 0 Minimum Value 4
PA3A PA3A016 Hi4 VSTRING 19 19 0 Maximum Value 4
PA3A PA3A017 Check5 STRING 1 1 0 Check Value 5
PA3A PA3A018 Lo5 VSTRING 19 19 0 Minimum Value 5
PA3A PA3A019 Hi5 VSTRING 19 19 0 Maximum Value 5
PA3A PA3A020 Check6 STRING 1 1 0 Check Value 6
PA3A PA3A021 Lo6 VSTRING 19 19 0 Minimum Value 6
PA3A PA3A022 Hi6 VSTRING 19 19 0 Maximum Value 6
PA3A PA3A023 Check7 STRING 1 1 0 Check Value 7
PA3A PA3A024 Lo7 VSTRING 19 19 0 Minimum Value 7
PA3A PA3A025 Hi7 VSTRING 19 19 0 Maximum Value 7
PA3A PA3A026 Check8 STRING 1 1 0 Check Value 8
PA3A PA3A027 Lo8 VSTRING 19 19 0 Minimum Value 8
PA3A PA3A028 Hi8 VSTRING 19 19 0 Maximum Value 8
PA3A PA3A029 Check9 STRING 1 1 0 Check Value 9
PA3A PA3A030 Lo9 VSTRING 19 19 0 Minimum Value 9
PA3A PA3A031 Hi9 VSTRING 19 19 0 Maximum Value 9
PA3A PA3A032 Check10 STRING 1 1 0 Check Value 10
PA3A PA3A033 Lo10 VSTRING 19 19 0 Minimum Value 10
PA3A PA3A034 Hi10 VSTRING 19 19 0 Maximum Value 10
PA3A PA3A035 Check11 STRING 1 1 0 Check Value 11
PA3A PA3A036 Lo11 VSTRING 19 19 0 Minimum Value 11
PA3A PA3A037 Hi11 VSTRING 19 19 0 Maximum Value 11
PA3A PA3A038 Check12 STRING 1 1 0 Check Value 12
PA3A PA3A039 Lo12 VSTRING 19 19 0 Minimum Value 12
PA3A PA3A040 Hi12 VSTRING 19 19 0 Maximum Value 12
PA3A PA3A041 Check13 STRING 1 1 0 Check Value 13
PA3A PA3A042 Lo13 VSTRING 19 19 0 Minimum Value 13
PA3A PA3A043 Hi13 VSTRING 19 19 0 Maximum Value 13
PA3A PA3A044 Check14 STRING 1 1 0 Check Value 14
PA3A PA3A045 Lo14 VSTRING 19 19 0 Minimum Value 14
PA3A PA3A046 Hi14 VSTRING 19 19 0 Maximum Value 14
PA3A PA3A047 Check15 STRING 1 1 0 Check Value 15
PA3A PA3A048 Lo15 VSTRING 19 19 0 Minimum Value 15
PA3A PA3A049 Hi15 VSTRING 19 19 0 Maximum Value 15
PA3A PA3A050 Check16 STRING 1 1 0 Check Value 16
PA3A PA3A051 Lo16 VSTRING 19 19 0 Minimum Value 16
PA3A PA3A052 Hi16 VSTRING 19 19 0 Maximum Value 16
PA3A PA3A053 Check17 STRING 1 1 0 Check Value 17
PA3A PA3A054 Lo17 VSTRING 19 19 0 Minimum Value 17
PA3A PA3A055 Hi17 VSTRING 19 19 0 Maximum Value 17
PA3A PA3A056 Check18 STRING 1 1 0 Check Value 18
PA3A PA3A057 Lo18 VSTRING 19 19 0 Minimum Value 18
PA3A PA3A058 Hi18 VSTRING 19 19 0 Maximum Value 18
PA3A PA3A059 Check19 STRING 1 1 0 Check Value 19
PA3A PA3A060 Lo19 VSTRING 19 19 0 Minimum Value 19
PA3A PA3A061 Hi19 VSTRING 19 19 0 Maximum Value 19
PA3A PA3A062 Check20 STRING 1 1 0 Check Value 20
PA3A PA3A063 Lo20 VSTRING 19 19 0 Minimum Value 20
PA3A PA3A064 Hi20 VSTRING 19 19 0 Maximum Value 20
PA3A PA3A065 Check21 STRING 1 1 0 Check Value 21
PA3A PA3A066 Lo21 VSTRING 19 19 0 Minimum Value 21
PA3A PA3A067 Hi21 VSTRING 19 19 0 Maximum Value 21
PA3A PA3A068 Check22 STRING 1 1 0 Check Value 22
PA3A PA3A069 Lo22 VSTRING 19 19 0 Minimum Value 22
PA3A PA3A070 Hi22 VSTRING 19 19 0 Maximum Value 22
PA3A PA3A071 Check23 STRING 1 1 0 Check Value 23
PA3A PA3A072 Lo23 VSTRING 19 19 0 Minimum Value 23
PA3A PA3A073 Hi23 VSTRING 19 19 0 Maximum Value 23
PA3A PA3A074 Check24 STRING 1 1 0 Check Value 24
PA3A PA3A075 Lo24 VSTRING 19 19 0 Minimum Value 24
PA3A PA3A076 Hi24 VSTRING 19 19 0 Maximum Value 24
PA3A PA3A077 Check25 STRING 1 1 0 Check Value 25
PA3A PA3A078 Lo25 VSTRING 19 19 0 Minimum Value 25
PA3A PA3A079 Hi25 VSTRING 19 19 0 Maximum Value 25
PA3A PA3A080 Check26 STRING 1 1 0 Check Value 26
PA3A PA3A081 Lo26 VSTRING 19 19 0 Minimum Value 26
PA3A PA3A082 Hi26 VSTRING 19 19 0 Maximum Value 26
PA3A PA3A083 Check27 STRING 1 1 0 Check Value 27
PA3A PA3A084 Lo27 VSTRING 19 19 0 Minimum Value 27
PA3A PA3A085 Hi27 VSTRING 19 19 0 Maximum Value 27
PA3A PA3A086 Check28 STRING 1 1 0 Check Value 28
PA3A PA3A087 Lo28 VSTRING 19 19 0 Minimum Value 28
PA3A PA3A088 Hi28 VSTRING 19 19 0 Maximum Value 28
PA3A PA3A089 Check29 STRING 1 1 0 Check Value 29
PA3A PA3A090 Lo29 VSTRING 19 19 0 Minimum Value 29
PA3A PA3A091 Hi29 VSTRING 19 19 0 Maximum Value 29
PA3A PA3A092 Check30 STRING 1 1 0 Check Value 30
PA3A PA3A093 Lo30 VSTRING 19 19 0 Minimum Value 30
PA3A PA3A094 Hi30 VSTRING 19 19 0 Maximum Value 30
PA3A PA3A095 Check31 STRING 1 1 0 Check Value 31
PA3A PA3A096 Lo31 VSTRING 19 19 0 Minimum Value 31
PA3A PA3A097 Hi31 VSTRING 19 19 0 Maximum Value 31
PA3A PA3A098 Check32 STRING 1 1 0 Check Value 32
PA3A PA3A099 Lo32 VSTRING 19 19 0 Minimum Value 32
PA3A PA3A100 Hi32 VSTRING 19 19 0 Maximum Value 32
PA3A PA3A101 Check33 STRING 1 1 0 Check Value 33
PA3A PA3A102 Lo33 VSTRING 19 19 0 Minimum Value 33
PA3A PA3A103 Hi33 VSTRING 19 19 0 Maximum Value 33
PA3A PA3A104 Check34 STRING 1 1 0 Check Value 34
PA3A PA3A105 Lo34 VSTRING 19 19 0 Minimum Value 34
PA3A PA3A106 Hi34 VSTRING 19 19 0 Maximum Value 34
PA3A PA3A107 Check35 STRING 1 1 0 Check Value 35
PA3A PA3A108 Lo35 VSTRING 19 19 0 Minimum Value 35
PA3A PA3A109 Hi35 VSTRING 19 19 0 Maximum Value 35
PA3A PA3A110 Check36 STRING 1 1 0 Check Value 36
PA3A PA3A111 Lo36 VSTRING 19 19 0 Minimum Value 36
PA3A PA3A112 Hi36 VSTRING 19 19 0 Maximum Value 36
PA3A PA3A113 Check37 STRING 1 1 0 Check Value 37
PA3A PA3A114 Lo37 VSTRING 19 19 0 Minimum Value 37
PA3A PA3A115 Hi37 VSTRING 19 19 0 Maximum Value 37
PA3A PA3A116 Check38 STRING 1 1 0 Check Value 38
PA3A PA3A117 Lo38 VSTRING 19 19 0 Minimum Value 38
PA3A PA3A118 Hi38 VSTRING 19 19 0 Maximum Value 38
PA3A PA3A119 Check39 STRING 1 1 0 Check Value 39
PA3A PA3A120 Lo39 VSTRING 19 19 0 Minimum Value 39
PA3A PA3A121 Hi39 VSTRING 19 19 0 Maximum Value 39
PA3A PA3A122 Check40 STRING 1 1 0 Check Value 40
PA3A PA3A123 Lo40 VSTRING 19 19 0 Minimum Value 40
PA3A PA3A124 Hi40 VSTRING 19 19 0 Maximum Value 40
PA3A PA3A125 Check41 STRING 1 1 0 Check Value 41
PA3A PA3A126 Lo41 VSTRING 19 19 0 Minimum Value 41
PA3A PA3A127 Hi41 VSTRING 19 19 0 Maximum Value 41
PA3A PA3A128 Check42 STRING 1 1 0 Check Value 42
PA3A PA3A129 Lo42 VSTRING 19 19 0 Minimum Value 42
PA3A PA3A130 Hi42 VSTRING 19 19 0 Maximum Value 42
PA3A PA3A131 Check43 STRING 1 1 0 Check Value 43
PA3A PA3A132 Lo43 VSTRING 19 19 0 Minimum Value 43
PA3A PA3A133 Hi43 VSTRING 19 19 0 Maximum Value 43
PA3A PA3A134 Check44 STRING 1 1 0 Check Value 44
PA3A PA3A135 Lo44 VSTRING 19 19 0 Minimum Value 44
PA3A PA3A136 Hi44 VSTRING 19 19 0 Maximum Value 44
PA3A PA3A137 Check45 STRING 1 1 0 Check Value 45
PA3A PA3A138 Lo45 VSTRING 19 19 0 Minimum Value 45
PA3A PA3A139 Hi45 VSTRING 19 19 0 Maximum Value 45
PA3A PA3A140 Check46 STRING 1 1 0 Check Value 46
PA3A PA3A141 Lo46 VSTRING 19 19 0 Minimum Value 46
PA3A PA3A142 Hi46 VSTRING 19 19 0 Maximum Value 46
PA3A PA3A143 Check47 STRING 1 1 0 Check Value 47
PA3A PA3A144 Lo47 VSTRING 19 19 0 Minimum Value 47
PA3A PA3A145 Hi47 VSTRING 19 19 0 Maximum Value 47