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 PA01 PA01001 IndexKey STRING 4 4 0 Index Key
PA01 PA01002 EuroPayroVer STRING 4 4 0 Euro Payroll Version
PA01 PA01003 Spare STRING 1 1 0 (obsolete)
PA01 PA01004 AccumNetPay STRING 2 2 0 Accumulator for Interim Calculation
PA01 PA01005 InterimCalculation SWITCH 1 1 0 Interim Calculation
PA01 PA01006 CurrCalcModel STRING 3 3 0 Model of Last Calculation
PA01 PA01007 PAPaymDate DATE 8 0 0 Payment Date of Last Calculation
PA01 PA01008 CurrPaymBasis STRING 1 1 0 Last Payment Basis
PA01 PA01009 Spare STRING 1 1 0 Payroll Calculation Status 0 - Payroll calculation is not done
1 - Calculation done
2 - Payslips printed
3 - Payroll transactions created, accumulators update
4 - Update complete
PA01 PA01010 Spare STRING 1 1 0 (obsolete)
PA01 PA01011 Spare STRING 1 1 0 (obsolete)
PA01 PA01012 StartInterimCalc DATE 8 0 0 Start Interim Calculation
PA01 PA01013 EndInterimCalc DATE 8 0 0 End Interim Calculation
PA01 PA01014 EmpCodeDigNo STRING 1 1 0 Number of Digits in Employee Number
PA01 PA01015 Spare STRING 1 1 0 (obsolete)
PA01 PA01016 UnclWorkVar INTEGER 2 0 0 First Non-zeroed Calculation Variable
PA01 PA01017 TimeshWrkVar INTEGER 2 0 0 Last Calculation Variable Zeroed on Time Sheet
PA01 PA01018 Spare STRING 1 1 0 (obsolete)
PA01 PA01019 NumDayTypes STRING 1 1 0 Number of Day Types
PA01 PA01020 NumHourTypes STRING 1 1 0 Number of Hour Types
PA01 PA01021 NextPANumber STRING 1 1 0 (obsolete)
PA01 PA01022 PayrollTax1 STRING 7 7 0 Social Tax 1 %
PA01 PA01023 PayrollTax2 STRING 7 7 0 Social Tax 2 %
PA01 PA01024 PayrollTax3 STRING 7 7 0 Social Tax 3 %
PA01 PA01025 PayrollTax4 STRING 7 7 0 Social Tax 4 %
PA01 PA01026 PayrollTax5 STRING 7 7 0 Social Tax 5 %
PA01 PA01027 PayrollTax6 STRING 7 7 0 Social Tax 6 %
PA01 PA01028 PayrollTax7 STRING 7 7 0 Social Tax 7 %
PA01 PA01029 PayrollTax8 STRING 7 7 0 Social Tax 8 %
PA01 PA01030 PayrollTax9 STRING 7 7 0 Social Tax 9 %
PA01 PA01031 PayrollTax10 STRING 7 7 0 Social Tax 10 %
PA01 PA01032 EncNoActiveEmpl STRING 1 1 0 Encoded number of active Employees
PA01 PA01033 UserDefTablesDec STRING 1 1 0 Number of Decimals for Additional Tables
PA01 PA01034 TransSourceCnt STRING 1 1 0 Transaction Source Counter
PA01 PA01035 Spare STRING 1 1 0 (obsolete)
PA01 PA01036 Spare STRING 1 1 0 (obsolete)
PA01 PA01037 Spare STRING 1 1 0 (obsolete)
PA01 PA01038 Spare STRING 1 1 0 (obsolete)
PA01 PA01039 Spare STRING 1 1 0 (obsolete)
PA01 PA01040 Spare STRING 1 1 0 (obsolete)
PA01 PA01041 Spare STRING 1 1 0 (obsolete)
PA01 PA01042 Spare STRING 1 1 0 (obsolete)
PA01 PA01043 Spare STRING 1 1 0 (obsolete)
PA01 PA01044 Spare STRING 1 1 0 (obsolete)
PA01 PA01045 Spare STRING 1 1 0 (obsolete)
PA01 PA01046 Spare STRING 1 1 0 (obsolete)
PA01 PA01047 Spare STRING 1 1 0 (obsolete)
PA01 PA01048 Spare STRING 1 1 0 (obsolete)
PA01 PA01049 Spare STRING 1 1 0 (obsolete)
PA01 PA01050 Spare STRING 1 1 0 (obsolete)
PA01 PA01051 MastCalcPeriod STRING 1 1 0 Master Calculation Period
PA01 PA01052 IntegratedGL SWITCH 1 1 0 Integrated With General Ledger
PA01 PA01053 UseGLTrCounter SWITCH 1 1 0 Use Transaction Number from General Ledger
PA01 PA01054 GenTrTimRepEntry SWITCH 1 1 0 Direct Entry to Accounts
PA01 PA01055 CompulSocSecEntry SWITCH 1 1 0 Mandatory Identity Number
PA01 PA01056 CDVCheck SWITCH 1 1 0 Check Digit Control for ID number
PA01 PA01057 ExecGLAutoAlloc SWITCH 1 1 0 Perform Automatic Allocations
PA01 PA01058 ReportComp01 SWITCH 1 1 0 Reports from Company 01
PA01 PA01059 TaxTabComp01 SWITCH 1 1 0 Tax Tables from Company 01
PA01 PA01060 PrintPADepartment SWITCH 1 1 0 Print Payroll per Department
PA01 PA01061 PrintWTSpecif SWITCH 1 1 0 Print Employee Specification in Payroll Summary
PA01 PA01062 PrintPAJournal SWITCH 1 1 0 Print Payroll Journal Transactions
PA01 PA01063 PrnPAJourSumm SWITCH 1 1 0 Print Payroll Journal Summary
PA01 PA01064 PrnZeroLines SWITCH 1 1 0 Print Zero Lines
PA01 PA01065 PrnPaySlips SWITCH 1 1 0 Print Payslips for Zero Payment
PA01 PA01066 EmpSortLastWrd SWITCH 1 1 0 Employee File Sorted by Last Word
PA01 PA01067 CrePAListUpdate SWITCH 1 1 0 Create Payroll Lists
PA01 PA01068 SaveEmplChng SWITCH 1 1 0 Save History of Changes
PA01 PA01069 SaveFuturPerTrans SWITCH 1 1 0 Save Future Period Wage Types
PA01 PA01070 DeemedTimesheets SWITCH 1 1 0 Deemed Time Sheets
PA01 PA01071 BiLineTransactions SWITCH 1 1 0 Bi-line Transactions
PA01 PA01072 DateCalcAlgo SWITCH 1 1 0 (obsolete)
PA01 PA01073 Spare SWITCH 1 1 0 (obsolete)
PA01 PA01074 Spare SWITCH 1 1 0 (obsolete)
PA01 PA01075 Spare SWITCH 1 1 0 (obsolete)
PA01 PA01076 Spare SWITCH 1 1 0 (obsolete)
PA01 PA01077 Spare SWITCH 1 1 0 (obsolete)
PA01 PA01078 Spare SWITCH 1 1 0 (obsolete)
PA01 PA01079 Spare SWITCH 1 1 0 (obsolete)
PA01 PA01080 Spare SWITCH 1 1 0 (obsolete)
PA01 PA01081 Spare SWITCH 1 1 0 (obsolete)
PA01 PA01082 Spare SWITCH 1 1 0 (obsolete)
PA01 PA01083 Spare SWITCH 1 1 0 (obsolete)
PA01 PA01084 AccCashPayments VSTRING 12 12 0 Account Cash Payments
PA01 PA01085 AccPostPayments VSTRING 12 12 0 Account Post Payments
PA01 PA01086 AccBankPayments VSTRING 12 12 0 Account Bank Payments
PA01 PA01087 AccBalDirCoding VSTRING 12 12 0 Account Settlement of Direct Coding
PA01 PA01088 AccPATax1PL VSTRING 12 12 0 Account Social Tax 1 (P&L)
PA01 PA01089 AccPATax1BAL VSTRING 12 12 0 Account Social Tax 1 (Balance)
PA01 PA01090 AccPATax2PL VSTRING 12 12 0 Account Social Tax 2 (P&L)
PA01 PA01091 AccPATax2BAL VSTRING 12 12 0 Account Social Tax 2 (Balance)
PA01 PA01092 AccPATax3PL VSTRING 12 12 0 Account Social Tax 3 (P&L)
PA01 PA01093 AccPATax3BAL VSTRING 12 12 0 Account Social Tax 3 (Balance)
PA01 PA01094 AccPATax4PL VSTRING 12 12 0 Account Social Tax 4 (P&L)
PA01 PA01095 AccPATax4BAL VSTRING 12 12 0 Account Social Tax 4 (Balance)
PA01 PA01096 AccPATax5PL VSTRING 12 12 0 Account Social Tax 5 (P&L)
PA01 PA01097 AccPATax5BAL VSTRING 12 12 0 Account Social Tax 5 (Balance)
PA01 PA01098 AccPATax6PL VSTRING 12 12 0 Account Social Tax 6 (P&L)
PA01 PA01099 AccPATax6BAL VSTRING 12 12 0 Account Social Tax 6 (Balance)
PA01 PA01100 AccPATax7PL VSTRING 12 12 0 Account Social Tax 7 (P&L)
PA01 PA01101 AccPATax7BAL VSTRING 12 12 0 Account Social Tax 7 (Balance)
PA01 PA01102 AccPATax8PL VSTRING 12 12 0 Account Social Tax 8 (P&L)
PA01 PA01103 AccPATax8BAL VSTRING 12 12 0 Account Social Tax 8 (Balance)
PA01 PA01104 AccPATax9PL VSTRING 12 12 0 Account Social Tax 9 (P&L)
PA01 PA01105 AccPATax9BAL VSTRING 12 12 0 Account Social Tax 9 (Balance)
PA01 PA01106 AccPATax10PL VSTRING 12 12 0 Account Social Tax 10 (P&L)
PA01 PA01107 AccPATx10BAL VSTRING 12 12 0 Account Social Tax 10 (Balance)
PA01 PA01108 Spare VSTRING 12 12 0 (obsolete)
PA01 PA01109 Spare VSTRING 12 12 0 (obsolete)
PA01 PA01110 Spare VSTRING 12 12 0 (obsolete)
PA01 PA01111 Spare VSTRING 12 12 0 (obsolete)
PA01 PA01112 Spare VSTRING 12 12 0 (obsolete)
PA01 PA01113 Spare VSTRING 12 12 0 (obsolete)
PA01 PA01114 Unit STRING 1 1 0 Payment Period 1 - Unit 1 - Days
2 - Month
4 - Half months
PA01 PA01115 StepUnits INTEGER 3 0 0 Payment Period 1 - Quantity
PA01 PA01116 StartDate DATE 8 0 0 Payment Period 1 - Start Date
PA01 PA01117 EndDate DATE 8 0 0 Payment Period 1 - End Date
PA01 PA01118 Unit STRING 1 1 0 Payment Period 2 - Unit
PA01 PA01119 StepUnits INTEGER 3 0 0 Payment Period 2 - Quantity
PA01 PA01120 StartDate DATE 8 0 0 Payment Period 2 - Start Date
PA01 PA01121 EndDate DATE 8 0 0 Payment Period 2 - End Date
PA01 PA01122 Unit STRING 1 1 0 Payment Period 3 - Unit
PA01 PA01123 StepUnits INTEGER 3 0 0 Payment Period 3 - Quantity
PA01 PA01124 StartDate DATE 8 0 0 Payment Period 3 - Start Date
PA01 PA01125 EndDate DATE 8 0 0 Payment Period 3 - End Date
PA01 PA01126 Unit STRING 1 1 0 Payment Period 4 - Unit
PA01 PA01127 StepUnits INTEGER 3 0 0 Payment Period 4 - Quantity
PA01 PA01128 StartDate DATE 8 0 0 Payment Period 4 - Start Date
PA01 PA01129 EndDate DATE 8 0 0 Payment Period 4 - End Date
PA01 PA01130 Unit STRING 1 1 0 Payment Period 5 - Unit
PA01 PA01131 StepUnits INTEGER 3 0 0 Payment Period 5 - Quantity
PA01 PA01132 StartDate DATE 8 0 0 Payment Period 5 - Start Date
PA01 PA01133 EndDate DATE 8 0 0 Payment Period 5 - End Date
PA01 PA01134 Unit STRING 1 1 0 Payment Period 6 - Unit
PA01 PA01135 StepUnits INTEGER 3 0 0 Payment Period 6 - Quantity
PA01 PA01136 StartDate DATE 8 0 0 Payment Period 6 - Start Date
PA01 PA01137 EndDate DATE 8 0 0 Payment Period 6 - End Date
PA01 PA01138 Unit STRING 1 1 0 Payment Period 7 - Unit
PA01 PA01139 StepUnits INTEGER 3 0 0 Payment Period 7 - Quantity
PA01 PA01140 StartDate DATE 8 0 0 Payment Period 7 - Start Date
PA01 PA01141 EndDate DATE 8 0 0 Payment Period 7 - End Date
PA01 PA01142 Unit STRING 1 1 0 Payment Period 8 - Unit
PA01 PA01143 StepUnits INTEGER 3 0 0 Payment Period 8 - Quantity
PA01 PA01144 StartDate DATE 8 0 0 Payment Period 8 - Start Date
PA01 PA01145 EndDate DATE 8 0 0 Payment Period 8 - End Date
PA01 PA01146 Unit STRING 1 1 0 Payment Period 9 - Unit
PA01 PA01147 StepUnits INTEGER 3 0 0 Payment Period 9 - Quantity
PA01 PA01148 StartDate DATE 8 0 0 Payment Period 9 - Start Date
PA01 PA01149 EndDate DATE 8 0 0 Payment Period 9 - End Date
PA01 PA01150 BasicLan STRING 3 3 0 Payroll Setup Language