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 PA03 PA03001 SalaryType STRING 6 6 0 Wage Type
PA03 PA03002 Description VSTRING 256 256 0 Description
PA03 PA03003 Explanation VSTRING 256 256 0 Explanation
PA03 PA03004 Spare STRING 1 1 0 (obsolete)
PA03 PA03005 Spare STRING 1 1 0 (obsolete)
PA03 PA03006 Spare STRING 1 1 0 (obsolete)
PA03 PA03007 AccString ACCSTR 120 120 0 Accounting String Each accounting dimension can be either a valid code, empty or it might include wild-cards.
PA03 PA03008 Constant1 VSTRING 20 20 0 Constant 1
PA03 PA03009 Constant2 VSTRING 20 20 0 Constant 2
PA03 PA03010 Constant3 VSTRING 20 20 0 Constant 3
PA03 PA03011 Constant4 VSTRING 20 20 0 Constant 4
PA03 PA03012 Prompt1 VSTRING 256 256 0 Question 1 - Label
PA03 PA03013 Prompt2 VSTRING 256 256 0 Question 2 - Label
PA03 PA03014 FlagAddUp STRING 1 1 0 Summarize on Payslip
PA03 PA03015 SalaryCmdNo1 STRING 5 5 0 Calculation Command 1 Calculation command including command (first character), first operand (character 2 and 3), second operand (character 4 and 5). The meaning with the operands depends on the command.
Note: The same structure is used for all commands (1-60).
PA03 PA03016 SalaryCmdNo2 STRING 5 5 0 Calculation Command 2
PA03 PA03017 SalaryCmdNo3 STRING 5 5 0 Calculation Command 3
PA03 PA03018 SalaryCmdNo4 STRING 5 5 0 Calculation Command 4
PA03 PA03019 SalaryCmdNo5 STRING 5 5 0 Calculation Command 5
PA03 PA03020 SalaryCmdNo6 STRING 5 5 0 Calculation Command 6
PA03 PA03021 SalaryCmdNo7 STRING 5 5 0 Calculation Command 7
PA03 PA03022 SalaryCmdNo8 STRING 5 5 0 Calculation Command 8
PA03 PA03023 SalaryCmdNo9 STRING 5 5 0 Calculation Command 9
PA03 PA03024 SalaryCmdN10 STRING 5 5 0 Calculation Command 10
PA03 PA03025 SalaryCmdN11 STRING 5 5 0 Calculation Command 11
PA03 PA03026 SalaryCmdN12 STRING 5 5 0 Calculation Command 12
PA03 PA03027 SalaryCmdN13 STRING 5 5 0 Calculation Command 13
PA03 PA03028 SalaryCmdN14 STRING 5 5 0 Calculation Command 14
PA03 PA03029 SalaryCmdN15 STRING 5 5 0 Calculation Command 15
PA03 PA03030 SalaryCmdN16 STRING 5 5 0 Calculation Command 16
PA03 PA03031 SalaryCmdN17 STRING 5 5 0 Calculation Command 17
PA03 PA03032 SalaryCmdN18 STRING 5 5 0 Calculation Command 18
PA03 PA03033 SalaryCmdN19 STRING 5 5 0 Calculation Command 19
PA03 PA03034 SalaryCmdN20 STRING 5 5 0 Calculation Command 20
PA03 PA03035 SalaryCmdN21 STRING 5 5 0 Calculation Command 21
PA03 PA03036 SalaryCmdN22 STRING 5 5 0 Calculation Command 22
PA03 PA03037 SalaryCmdN23 STRING 5 5 0 Calculation Command 23
PA03 PA03038 SalaryCmdN24 STRING 5 5 0 Calculation Command 24
PA03 PA03039 SalaryCmdN25 STRING 5 5 0 Calculation Command 25
PA03 PA03040 SalaryCmdN26 STRING 5 5 0 Calculation Command 26
PA03 PA03041 SalaryCmdN27 STRING 5 5 0 Calculation Command 27
PA03 PA03042 SalaryCmdN28 STRING 5 5 0 Calculation Command 28
PA03 PA03043 SalaryCmdN29 STRING 5 5 0 Calculation Command 29
PA03 PA03044 SalaryCmdN30 STRING 5 5 0 Calculation Command 30
PA03 PA03045 SalaryCmdN31 STRING 5 5 0 Calculation Command 31
PA03 PA03046 SalaryCmdN32 STRING 5 5 0 Calculation Command 32
PA03 PA03047 SalaryCmdN33 STRING 5 5 0 Calculation Command 33
PA03 PA03048 SalaryCmdN34 STRING 5 5 0 Calculation Command 34
PA03 PA03049 SalaryCmdN35 STRING 5 5 0 Calculation Command 35
PA03 PA03050 SalaryCmdN36 STRING 5 5 0 Calculation Command 36
PA03 PA03051 SalaryCmdN37 STRING 5 5 0 Calculation Command 37
PA03 PA03052 SalaryCmdN38 STRING 5 5 0 Calculation Command 38
PA03 PA03053 SalaryCmdN39 STRING 5 5 0 Calculation Command 39
PA03 PA03054 SalaryCmdN40 STRING 5 5 0 Calculation Command 40
PA03 PA03055 SalaryCmdN41 STRING 5 5 0 Calculation Command 41
PA03 PA03056 SalaryCmdN42 STRING 5 5 0 Calculation Command 42
PA03 PA03057 SalaryCmdN43 STRING 5 5 0 Calculation Command 43
PA03 PA03058 SalaryCmdN44 STRING 5 5 0 Calculation Command 44
PA03 PA03059 SalaryCmdN45 STRING 5 5 0 Calculation Command 45
PA03 PA03060 SalaryCmdN46 STRING 5 5 0 Calculation Command 46
PA03 PA03061 SalaryCmdN47 STRING 5 5 0 Calculation Command 47
PA03 PA03062 SalaryCmdN48 STRING 5 5 0 Calculation Command 48
PA03 PA03063 SalaryCmdN49 STRING 5 5 0 Calculation Command 49
PA03 PA03064 SalaryCmdN50 STRING 5 5 0 Calculation Command 50
PA03 PA03065 SalaryCmdN51 STRING 5 5 0 Calculation Command 51
PA03 PA03066 SalaryCmdN52 STRING 5 5 0 Calculation Command 52
PA03 PA03067 SalaryCmdN53 STRING 5 5 0 Calculation Command 53
PA03 PA03068 SalaryCmdN54 STRING 5 5 0 Calculation Command 54
PA03 PA03069 SalaryCmdN55 STRING 5 5 0 Calculation Command 55
PA03 PA03070 SalaryCmdN56 STRING 5 5 0 Calculation Command 56
PA03 PA03071 SalaryCmdN57 STRING 5 5 0 Calculation Command 57
PA03 PA03072 SalaryCmdN58 STRING 5 5 0 Calculation Command 58
PA03 PA03073 SalaryCmdN59 STRING 5 5 0 Calculation Command 59
PA03 PA03074 SalaryCmdN60 STRING 5 5 0 Calculation Command 60
PA03 PA03075 CalcSocInsurance SWITCH 1 1 0 Calculate Social Tax
PA03 PA03076 FixedTaxRate STRING 5 5 0 Fixed Tax Rate %
PA03 PA03077 PrnSalarySpec STRING 1 1 0 Print on Payslip
PA03 PA03078 ChainSalType STRING 6 6 0 Chained Wage Type
PA03 PA03079 PayrollTax1 SWITCH 1 1 0 Social Tax 1 0 - No tax will be calculated
1 - Tax will be calculated according to standard parameters
2 - Tax amount will be calculated by other wage type
PA03 PA03080 PayrollTax2 SWITCH 1 1 0 Social Tax 2 0 - No tax will be calculated
1 - Tax will be calculated according to standard parameters
2 - Tax amount will be calculated by other wage type
PA03 PA03081 PayrollTax3 SWITCH 1 1 0 Social Tax 3 0 - No tax will be calculated
1 - Tax will be calculated according to standard parameters
2 - Tax amount will be calculated by other wage type
PA03 PA03082 PayrollTax4 SWITCH 1 1 0 Social Tax 4 0 - No tax will be calculated
1 - Tax will be calculated according to standard parameters
2 - Tax amount will be calculated by other wage type
PA03 PA03083 PayrollTax5 SWITCH 1 1 0 Social Tax 5 0 - No tax will be calculated
1 - Tax will be calculated according to standard parameters
2 - Tax amount will be calculated by other wage type
PA03 PA03084 LaboAgreArea STRING 5 5 0 Labour Agreement Area
PA03 PA03085 EnterReference SWITCH 1 1 0 Enter Reference 0 - No entry of reference
1 - Manual entry
2 - Entry from history
3 - Entry from recipient
4 - Entry from recipient and history
PA03 PA03086 Spare STRING 1 1 0 (obsolete)
PA03 PA03087 OnlyTaxCalculation SWITCH 1 1 0 Wage Type Affects 0 - Create transactions, affects net and tax
1 - No transactions, affects only tax
2 - Create transactions, affects only tax
3 - No transactions, affects net and tax
PA03 PA03088 WarningText1 VSTRING 35 35 0 Warning Text Line 1
PA03 PA03089 WarningText2 VSTRING 35 35 0 Warning Text Line 2
PA03 PA03090 Constant1Decimals STRING 1 1 0 Constant 1 - Number of Decimals
PA03 PA03091 Constant2Decimals STRING 1 1 0 Constant 2 - Number of Decimals
PA03 PA03092 Constant3Decimals STRING 1 1 0 Constant 3 - Number of Decimals
PA03 PA03093 Constant4Decimals STRING 1 1 0 Constant 4 - Number of Decimals
PA03 PA03094 Question1Decimals STRING 1 1 0 Question 1 - Number of Decimals
PA03 PA03095 Question2Decimals STRING 1 1 0 Question 2 - Number of Decimals
PA03 PA03096 PayrollTax6 SWITCH 1 1 0 Social Tax 6 0 - No tax will be calculated
1 - Tax will be calculated according to standard parameters
2 - Tax amount will be calculated by other wage type
PA03 PA03097 PayrollTax7 SWITCH 1 1 0 Social Tax 7 0 - No tax will be calculated
1 - Tax will be calculated according to standard parameters
2 - Tax amount will be calculated by other wage type
PA03 PA03098 PayrollTax8 SWITCH 1 1 0 Social Tax 8 0 - No tax will be calculated
1 - Tax will be calculated according to standard parameters
2 - Tax amount will be calculated by other wage type
PA03 PA03099 PayrollTax9 SWITCH 1 1 0 Social Tax 9 0 - No tax will be calculated
1 - Tax will be calculated according to standard parameters
2 - Tax amount will be calculated by other wage type
PA03 PA03100 PayrollTax10 SWITCH 1 1 0 Social Tax 10 0 - No tax will be calculated
1 - Tax will be calculated according to standard parameters
2 - Tax amount will be calculated by other wage type
PA03 PA03101 CouldBeReported SWITCH 1 1 0 Can be Reported
PA03 PA03102 CouldBeFixed SWITCH 1 1 0 Can be Used as Fixed
PA03 PA03103 StatistAccnt VSTRING 12 12 0 Statistical Account
PA03 PA03104 StatAccCntr STRING 1 1 0 Statistical Account Counter Number
PA03 PA03105 AutoWTFileNo STRING 2 2 0 Automatic Wage Type - Not an automatic wage type
01 - Wage type is calculated if field number (PL03106) in payroll parameters (PA01) is not equal to zero.
04 - Wage type is calculated if field number (PL03106) in employee table (PA04) is not equal to zero.
20 - Wage type is calculated if field number (PL03106) in employee table (PA04) is not equal to zero.
PA03 PA03106 AutWTFieldNo STRING 3 3 0 Automatic Wage Type Field Number
PA03 PA03107 UserGroup STRING 8 8 0 User Group
PA03 PA03108 Counter1Currency STRING 2 2 0 Currency in Counter 1
PA03 PA03109 Counter2Currency STRING 2 2 0 Currency in Counter 2
PA03 PA03110 Counter3Currency STRING 2 2 0 Currency in Counter 3
PA03 PA03111 Counter4Currency STRING 2 2 0 Currency in Counter 4
PA03 PA03112 Counter5Currency STRING 2 2 0 Currency in Counter 5
PA03 PA03113 Counter6Currency STRING 2 2 0 Currency in Counter 6
PA03 PA03114 Counter7Currency STRING 2 2 0 Currency in Counter 7
PA03 PA03115 Counter8Currency STRING 2 2 0 Currency in Counter 8