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 paBudgetEmplAcc PA4A001 EmployeeCode STRING 6 6 0 Employee Code
paBudgetEmplAcc PA4A002 AccumulatNo1 STRING 20 20 0 Accumulator 1
paBudgetEmplAcc PA4A003 AccumulatNo2 STRING 20 20 0 Accumulator 2
paBudgetEmplAcc PA4A004 AccumulatNo3 STRING 20 20 0 Accumulator 3
paBudgetEmplAcc PA4A005 AccumulatNo4 STRING 20 20 0 Accumulator 4
paBudgetEmplAcc PA4A006 AccumulatNo5 STRING 20 20 0 Accumulator 5
paBudgetEmplAcc PA4A007 AccumulatNo6 STRING 20 20 0 Accumulator 6
paBudgetEmplAcc PA4A008 AccumulatNo7 STRING 20 20 0 Accumulator 7
paBudgetEmplAcc PA4A009 AccumulatNo8 STRING 20 20 0 Accumulator 8
paBudgetEmplAcc PA4A010 AccumulatNo9 STRING 20 20 0 Accumulator 9
paBudgetEmplAcc PA4A011 AccumulatNo10 STRING 20 20 0 Accumulator 10
paBudgetEmplAcc PA4A012 AccumulatNo11 STRING 20 20 0 Accumulator 11
paBudgetEmplAcc PA4A013 AccumulatNo12 STRING 20 20 0 Accumulator 12
paBudgetEmplAcc PA4A014 AccumulatNo13 STRING 20 20 0 Accumulator 13
paBudgetEmplAcc PA4A015 AccumulatNo14 STRING 20 20 0 Accumulator 14
paBudgetEmplAcc PA4A016 AccumulatNo15 STRING 20 20 0 Accumulator 15
paBudgetEmplAcc PA4A017 AccumulatNo16 STRING 20 20 0 Accumulator 16
paBudgetEmplAcc PA4A018 AccumulatNo17 STRING 20 20 0 Accumulator 17
paBudgetEmplAcc PA4A019 AccumulatNo18 STRING 20 20 0 Accumulator 18
paBudgetEmplAcc PA4A020 AccumulatNo19 STRING 20 20 0 Accumulator 19
paBudgetEmplAcc PA4A021 AccumulatNo20 STRING 20 20 0 Accumulator 20
paBudgetEmplAcc PA4A022 AccumulatNo21 STRING 20 20 0 Accumulator 21
paBudgetEmplAcc PA4A023 AccumulatNo22 STRING 20 20 0 Accumulator 22
paBudgetEmplAcc PA4A024 AccumulatNo23 STRING 20 20 0 Accumulator 23
paBudgetEmplAcc PA4A025 AccumulatNo24 STRING 20 20 0 Accumulator 24
paBudgetEmplAcc PA4A026 AccumulatNo25 STRING 20 20 0 Accumulator 25
paBudgetEmplAcc PA4A027 AccumulatNo26 STRING 20 20 0 Accumulator 26
paBudgetEmplAcc PA4A028 AccumulatNo27 STRING 20 20 0 Accumulator 27
paBudgetEmplAcc PA4A029 AccumulatNo28 STRING 20 20 0 Accumulator 28
paBudgetEmplAcc PA4A030 AccumulatNo29 STRING 20 20 0 Accumulator 29
paBudgetEmplAcc PA4A031 AccumulatNo30 STRING 20 20 0 Accumulator 30
paBudgetEmplAcc PA4A032 AccumulatNo31 STRING 20 20 0 Accumulator 31
paBudgetEmplAcc PA4A033 AccumulatNo32 STRING 20 20 0 Accumulator 32
paBudgetEmplAcc PA4A034 AccumulatNo33 STRING 20 20 0 Accumulator 33
paBudgetEmplAcc PA4A035 AccumulatNo34 STRING 20 20 0 Accumulator 34
paBudgetEmplAcc PA4A036 AccumulatNo35 STRING 20 20 0 Accumulator 35
paBudgetEmplAcc PA4A037 AccumulatNo36 STRING 20 20 0 Accumulator 36
paBudgetEmplAcc PA4A038 AccumulatNo37 STRING 20 20 0 Accumulator 37
paBudgetEmplAcc PA4A039 AccumulatNo38 STRING 20 20 0 Accumulator 38
paBudgetEmplAcc PA4A040 AccumulatNo39 STRING 20 20 0 Accumulator 39
paBudgetEmplAcc PA4A041 AccumulatNo40 STRING 20 20 0 Accumulator 40
paBudgetEmplAcc PA4A042 AccumulatNo41 STRING 20 20 0 Accumulator 41
paBudgetEmplAcc PA4A043 AccumulatNo42 STRING 20 20 0 Accumulator 42
paBudgetEmplAcc PA4A044 AccumulatNo43 STRING 20 20 0 Accumulator 43
paBudgetEmplAcc PA4A045 AccumulatNo44 STRING 20 20 0 Accumulator 44
paBudgetEmplAcc PA4A046 AccumulatNo45 STRING 20 20 0 Accumulator 45
paBudgetEmplAcc PA4A047 AccumulatNo46 STRING 20 20 0 Accumulator 46
paBudgetEmplAcc PA4A048 AccumulatNo47 STRING 20 20 0 Accumulator 47
paBudgetEmplAcc PA4A049 AccumulatNo48 STRING 20 20 0 Accumulator 48
paBudgetEmplAcc PA4A050 AccumulatNo49 STRING 20 20 0 Accumulator 49
paBudgetEmplAcc PA4A051 AccumulatNo50 STRING 20 20 0 Accumulator 50
paBudgetEmplAcc PA4A052 AccumulatNo51 STRING 20 20 0 Accumulator 51
paBudgetEmplAcc PA4A053 AccumulatNo52 STRING 20 20 0 Accumulator 52
paBudgetEmplAcc PA4A054 AccumulatNo53 STRING 20 20 0 Accumulator 53
paBudgetEmplAcc PA4A055 AccumulatNo54 STRING 20 20 0 Accumulator 54
paBudgetEmplAcc PA4A056 AccumulatNo55 STRING 20 20 0 Accumulator 55
paBudgetEmplAcc PA4A057 AccumulatNo56 STRING 20 20 0 Accumulator 56
paBudgetEmplAcc PA4A058 AccumulatNo57 STRING 20 20 0 Accumulator 57
paBudgetEmplAcc PA4A059 AccumulatNo58 STRING 20 20 0 Accumulator 58
paBudgetEmplAcc PA4A060 AccumulatNo59 STRING 20 20 0 Accumulator 59
paBudgetEmplAcc PA4A061 AccumulatNo60 STRING 20 20 0 Accumulator 60
paBudgetEmplAcc PA4A062 AccumulatNo61 STRING 20 20 0 Accumulator 61
paBudgetEmplAcc PA4A063 AccumulatNo62 STRING 20 20 0 Accumulator 62
paBudgetEmplAcc PA4A064 AccumulatNo63 STRING 20 20 0 Accumulator 63
paBudgetEmplAcc PA4A065 AccumulatNo64 STRING 20 20 0 Accumulator 64
paBudgetEmplAcc PA4A066 AccumulatNo65 STRING 20 20 0 Accumulator 65
paBudgetEmplAcc PA4A067 AccumulatNo66 STRING 20 20 0 Accumulator 66
paBudgetEmplAcc PA4A068 AccumulatNo67 STRING 20 20 0 Accumulator 67
paBudgetEmplAcc PA4A069 AccumulatNo68 STRING 20 20 0 Accumulator 68
paBudgetEmplAcc PA4A070 AccumulatNo69 STRING 20 20 0 Accumulator 69
paBudgetEmplAcc PA4A071 AccumulatNo70 STRING 20 20 0 Accumulator 70
paBudgetEmplAcc PA4A072 AccumulatNo71 STRING 20 20 0 Accumulator 71
paBudgetEmplAcc PA4A073 AccumulatNo72 STRING 20 20 0 Accumulator 72
paBudgetEmplAcc PA4A074 AccumulatNo73 STRING 20 20 0 Accumulator 73
paBudgetEmplAcc PA4A075 AccumulatNo74 STRING 20 20 0 Accumulator 74
paBudgetEmplAcc PA4A076 AccumulatNo75 STRING 20 20 0 Accumulator 75
paBudgetEmplAcc PA4A077 AccumulatNo76 STRING 20 20 0 Accumulator 76
paBudgetEmplAcc PA4A078 AccumulatNo77 STRING 20 20 0 Accumulator 77
paBudgetEmplAcc PA4A079 AccumulatNo78 STRING 20 20 0 Accumulator 78
paBudgetEmplAcc PA4A080 AccumulatNo79 STRING 20 20 0 Accumulator 79
paBudgetEmplAcc PA4A081 AccumulatNo80 STRING 20 20 0 Accumulator 80
paBudgetEmplAcc PA4A082 AccumulatNo81 STRING 20 20 0 Accumulator 81
paBudgetEmplAcc PA4A083 AccumulatNo82 STRING 20 20 0 Accumulator 82
paBudgetEmplAcc PA4A084 AccumulatNo83 STRING 20 20 0 Accumulator 83
paBudgetEmplAcc PA4A085 AccumulatNo84 STRING 20 20 0 Accumulator 84
paBudgetEmplAcc PA4A086 AccumulatNo85 STRING 20 20 0 Accumulator 85
paBudgetEmplAcc PA4A087 AccumulatNo86 STRING 20 20 0 Accumulator 86
paBudgetEmplAcc PA4A088 AccumulatNo87 STRING 20 20 0 Accumulator 87
paBudgetEmplAcc PA4A089 AccumulatNo88 STRING 20 20 0 Accumulator 88
paBudgetEmplAcc PA4A090 AccumulatNo89 STRING 20 20 0 Accumulator 89
paBudgetEmplAcc PA4A091 AccumulatNo90 STRING 20 20 0 Accumulator 90
paBudgetEmplAcc PA4A092 AccumulatNo91 STRING 20 20 0 Accumulator 91
paBudgetEmplAcc PA4A093 AccumulatNo92 STRING 20 20 0 Accumulator 92
paBudgetEmplAcc PA4A094 AccumulatNo93 STRING 20 20 0 Accumulator 93
paBudgetEmplAcc PA4A095 AccumulatNo94 STRING 20 20 0 Accumulator 94
paBudgetEmplAcc PA4A096 AccumulatNo95 STRING 20 20 0 Accumulator 95
paBudgetEmplAcc PA4A097 AccumulatNo96 STRING 20 20 0 Accumulator 96