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 PA35 PA35001 ModeNo STRING 3 3 0 Mode Number
PA35 PA35002 PaymntPeriod STRING 1 1 0 Payment Basis
PA35 PA35003 EmplCodeFrom STRING 6 6 0 Employee Code From
PA35 PA35004 EmplCodeTo STRING 6 6 0 Employee Code To
PA35 PA35005 DepartmtFrom STRING 5 5 0 Department From
PA35 PA35006 DepartmtTo STRING 5 5 0 Department To
PA35 PA35007 CategoryFrom STRING 5 5 0 Category From
PA35 PA35008 CategoryTo STRING 5 5 0 Category To
PA35 PA35009 SplFieldFrom VSTRING 15 15 0 Split Field From
PA35 PA35010 SplFieldTo VSTRING 15 15 0 Split Field To
PA35 PA35011 InclFixWages SWITCH 1 1 0 Include Fixed Wage Types
PA35 PA35012 InclRepWages SWITCH 1 1 0 Include Reported Wage Types
PA35 PA35013 AutWageType1 STRING 6 6 0 Automatic Wage Type 1
PA35 PA35014 AutWageType2 STRING 6 6 0 Automatic Wage Type 2
PA35 PA35015 AutWageType3 STRING 6 6 0 Automatic Wage Type 3
PA35 PA35016 AutWageType4 STRING 6 6 0 Automatic Wage Type 4
PA35 PA35017 AutWageType5 STRING 6 6 0 Automatic Wage Type 5
PA35 PA35018 AutWageType6 STRING 6 6 0 Automatic Wage Type 6
PA35 PA35019 AutWageType7 STRING 6 6 0 Automatic Wage Type 7
PA35 PA35020 AutWageType8 STRING 6 6 0 Automatic Wage Type 8
PA35 PA35021 AutWageType9 STRING 6 6 0 Automatic Wage Type 9
PA35 PA35022 AutWageTyp10 STRING 6 6 0 Automatic Wage Type 10
PA35 PA35023 AutWageTyp11 STRING 6 6 0 Automatic Wage Type 11
PA35 PA35024 AutWageTyp12 STRING 6 6 0 Automatic Wage Type 12
PA35 PA35025 AutWageTyp13 STRING 6 6 0 Automatic Wage Type 13
PA35 PA35026 AutWageTyp14 STRING 6 6 0 Automatic Wage Type 14
PA35 PA35027 AutWageTyp15 STRING 6 6 0 Automatic Wage Type 15
PA35 PA35028 AutWageTyp16 STRING 6 6 0 Automatic Wage Type 16
PA35 PA35029 AutWageTyp17 STRING 6 6 0 Automatic Wage Type 17
PA35 PA35030 AutWageTyp18 STRING 6 6 0 Automatic Wage Type 18
PA35 PA35031 AutWageTyp19 STRING 6 6 0 Automatic Wage Type 19
PA35 PA35032 AutWageTyp20 STRING 6 6 0 Automatic Wage Type 20
PA35 PA35033 AutWageTyp21 STRING 6 6 0 Automatic Wage Type 21
PA35 PA35034 AutWageTyp22 STRING 6 6 0 Automatic Wage Type 22
PA35 PA35035 AutWageTyp23 STRING 6 6 0 Automatic Wage Type 23
PA35 PA35036 AutWageTyp24 STRING 6 6 0 Automatic Wage Type 24
PA35 PA35037 AutWageTyp25 STRING 6 6 0 Automatic Wage Type 25
PA35 PA35038 AutWageTyp26 STRING 6 6 0 Automatic Wage Type 26
PA35 PA35039 AutWageTyp27 STRING 6 6 0 Automatic Wage Type 27
PA35 PA35040 AutWageTyp28 STRING 6 6 0 Automatic Wage Type 28
PA35 PA35041 AutWageTyp29 STRING 6 6 0 Automatic Wage Type 29
PA35 PA35042 AutWageTyp30 STRING 6 6 0 Automatic Wage Type 30
PA35 PA35043 AutWageTyp31 STRING 6 6 0 Automatic Wage Type 31
PA35 PA35044 AutWageTyp32 STRING 6 6 0 Automatic Wage Type 32
PA35 PA35045 AutWageTyp33 STRING 6 6 0 Automatic Wage Type 33
PA35 PA35046 AutWageTyp34 STRING 6 6 0 Automatic Wage Type 34
PA35 PA35047 AutWageTyp35 STRING 6 6 0 Automatic Wage Type 35
PA35 PA35048 AutWageTyp36 STRING 6 6 0 Automatic Wage Type 36
PA35 PA35049 AutWageTyp37 STRING 6 6 0 Automatic Wage Type 37
PA35 PA35050 AutWageTyp38 STRING 6 6 0 Automatic Wage Type 38
PA35 PA35051 AutWageTyp39 STRING 6 6 0 Automatic Wage Type 39
PA35 PA35052 AutWageTyp40 STRING 6 6 0 Automatic Wage Type 40
PA35 PA35053 AutWageTyp41 STRING 6 6 0 Automatic Wage Type 41
PA35 PA35054 AutWageTyp42 STRING 6 6 0 Automatic Wage Type 42
PA35 PA35055 AutWageTyp43 STRING 6 6 0 Automatic Wage Type 43
PA35 PA35056 AutWageTyp44 STRING 6 6 0 Automatic Wage Type 44
PA35 PA35057 AutWageTyp45 STRING 6 6 0 Automatic Wage Type 45
PA35 PA35058 AutWageTyp46 STRING 6 6 0 Automatic Wage Type 46
PA35 PA35059 AutWageTyp47 STRING 6 6 0 Automatic Wage Type 47
PA35 PA35060 AutWageTyp48 STRING 6 6 0 Automatic Wage Type 48
PA35 PA35061 AutWageTyp49 STRING 6 6 0 Automatic Wage Type 49
PA35 PA35062 AutWageTyp50 STRING 6 6 0 Automatic Wage Type 50
PA35 PA35063 AutWageTyp51 STRING 6 6 0 Automatic Wage Type 51
PA35 PA35064 AutWageTyp52 STRING 6 6 0 Automatic Wage Type 52
PA35 PA35065 AutWageTyp53 STRING 6 6 0 Automatic Wage Type 53
PA35 PA35066 AutWageTyp54 STRING 6 6 0 Automatic Wage Type 54
PA35 PA35067 AutWageTyp55 STRING 6 6 0 Automatic Wage Type 55
PA35 PA35068 AutWageTyp56 STRING 6 6 0 Automatic Wage Type 56
PA35 PA35069 AutWageTyp57 STRING 6 6 0 Automatic Wage Type 57
PA35 PA35070 AutWageTyp58 STRING 6 6 0 Automatic Wage Type 58
PA35 PA35071 AutWageTyp59 STRING 6 6 0 Automatic Wage Type 59
PA35 PA35072 AutWageTyp60 STRING 6 6 0 Automatic Wage Type 60
PA35 PA35073 AutWageTyp61 STRING 6 6 0 Automatic Wage Type 61
PA35 PA35074 AutWageTyp62 STRING 6 6 0 Automatic Wage Type 62
PA35 PA35075 AutWageTyp63 STRING 6 6 0 Automatic Wage Type 63
PA35 PA35076 AutWageTyp64 STRING 6 6 0 Automatic Wage Type 64
PA35 PA35077 AutWageTyp65 STRING 6 6 0 Automatic Wage Type 65
PA35 PA35078 AutWageTyp66 STRING 6 6 0 Automatic Wage Type 66
PA35 PA35079 AutWageTyp67 STRING 6 6 0 Automatic Wage Type 67
PA35 PA35080 AutWageTyp68 STRING 6 6 0 Automatic Wage Type 68
PA35 PA35081 AutWageTyp69 STRING 6 6 0 Automatic Wage Type 69
PA35 PA35082 AutWageTyp70 STRING 6 6 0 Automatic Wage Type 70
PA35 PA35083 AutWageTyp71 STRING 6 6 0 Automatic Wage Type 71
PA35 PA35084 AutWageTyp72 STRING 6 6 0 Automatic Wage Type 72
PA35 PA35085 AutWageTyp73 STRING 6 6 0 Automatic Wage Type 73
PA35 PA35086 AutWageTyp74 STRING 6 6 0 Automatic Wage Type 74
PA35 PA35087 AutWageTyp75 STRING 6 6 0 Automatic Wage Type 75
PA35 PA35088 AutWageTyp76 STRING 6 6 0 Automatic Wage Type 76
PA35 PA35089 AutWageTyp77 STRING 6 6 0 Automatic Wage Type 77
PA35 PA35090 AutWageTyp78 STRING 6 6 0 Automatic Wage Type 78
PA35 PA35091 AutWageTyp79 STRING 6 6 0 Automatic Wage Type 79
PA35 PA35092 AutWageTyp80 STRING 6 6 0 Automatic Wage Type 80
PA35 PA35093 ModelType STRING 1 1 0 Model Type 0 - Regular model
1 - Statistical model
PA35 PA35094 CompanyHdrFrom STRING 6 6 0 Company Header From
PA35 PA35095 CompanyHdrTo STRING 6 6 0 Company Header To
PA35 PA35096 CompanyFtrFrom STRING 6 6 0 Company Footer From
PA35 PA35097 CompanyFtrTo STRING 6 6 0 Company Footer To
PA35 PA35098 EmployeeHdrFrom STRING 6 6 0 Employee Header From
PA35 PA35099 EmployeeHdrTo STRING 6 6 0 Employee Header To
PA35 PA35100 EmployeeFtrFrom STRING 6 6 0 Employee Footer From
PA35 PA35101 EmployeeFtrTo STRING 6 6 0 Employee Footer To
PA35 PA35102 TSFrom STRING 6 6 0 Time Sheet From
PA35 PA35103 TSTo STRING 6 6 0 Time Sheet To
PA35 PA35104 Model type STRING 1 1 0 Model type
PA35 PA35105 Detail persist schema STRING 1 1 0 Detail persist schema
PA35 PA35106 A skip flag of employee card validation code N 24(custom calculation model) STRING 1 1 0 A skip flag of employee card validation code N 24(custom calculation model)