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 paPersCard PA04001 EmployeeCode STRING 6 6 0 Employee Code
paPersCard PA04002 SocialId VSTRING 256 256 0 Social Identity Number
paPersCard PA04003 ShortName VSTRING 256 256 0 ShortName
paPersCard PA04004 SpareField3 VSTRING 256 256 0 Spare Field 3
paPersCard PA04005 SpareField4 VSTRING 256 256 0 SpareField 4
paPersCard PA04006 SpareField5 VSTRING 256 256 0 Spare Field 5
paPersCard PA04007 SpareField6 VSTRING 256 256 0 SpareField 6
paPersCard PA04008 CommunityCode1 VSTRING 256 256 0 Community Code 1
paPersCard PA04009 CommunityCode2 VSTRING 256 256 0 Community Code 2
paPersCard PA04010 CommunityCode3 VSTRING 256 256 0 Community Code 3
paPersCard PA04011 RegistrationDate DATE 8 0 0 Registration Date
paPersCard PA04012 CancellationDate DATE 8 0 0 Cancellation Date
paPersCard PA04013 Gender SWITCH 1 1 0 Gender 1 - Male
2 - Female
paPersCard PA04014 StatisticalCode1 VSTRING 256 256 0 Statistical Code 1
paPersCard PA04015 StatisticalCode2 VSTRING 256 256 0 Statistical Code 2
paPersCard PA04016 StatisticalCode3 VSTRING 256 256 0 Statistical Code 3
paPersCard PA04017 StatisticalCode4 VSTRING 256 256 0 Statistical Code 4
paPersCard PA04018 StatisticalCode5 VSTRING 256 256 0 Statistical Code 5
paPersCard PA04019 StatisticalCode6 VSTRING 256 256 0 Statistical Code 6
paPersCard PA04020 LanguageCode STRING 3 3 0 Language code
paPersCard PA04021 SpareField20 VSTRING 256 256 0 SpareField 20
paPersCard PA04022 PaymentPeriod STRING 1 1 0 Payment Basis
paPersCard PA04023 WayOfPayment STRING 1 1 0 Payment Method 1 - Cash payment
2 - Postal giro
3 - Bank automatic payment
paPersCard PA04024 SpareField23 VSTRING 256 256 0 Spare Field 23
paPersCard PA04025 SpareField24 VSTRING 256 256 0 Spare Field 24
paPersCard PA04026 SpareField25 VSTRING 256 256 0 Spare Field 25
paPersCard PA04027 SpareField26 VSTRING 256 256 0 Spare Field 26
paPersCard PA04028 SpareField27 VSTRING 256 256 0 Spare Field 27
paPersCard PA04029 SpareField28 VSTRING 256 256 0 Spare Field 28
paPersCard PA04030 SpareField29 VSTRING 256 256 0 Spare Field 29
paPersCard PA04031 SpareField30 VSTRING 256 256 0 Spare Field 30
paPersCard PA04032 SpareField31 VSTRING 256 256 0 Spare Field 31
paPersCard PA04033 SpareField32 VSTRING 256 256 0 Spare Field 32
paPersCard PA04034 SpareField33 VSTRING 256 256 0 Spare Field 33
paPersCard PA04035 SpareField34 VSTRING 256 256 0 Spare Field 34
paPersCard PA04036 SpareField35 VSTRING 256 256 0 Spare Field 35
paPersCard PA04037 SpareField36 VSTRING 256 256 0 Spare Field 36
paPersCard PA04038 SpareField37 VSTRING 256 256 0 Spare Field 37
paPersCard PA04039 SpareField38 VSTRING 256 256 0 Spare Field 38
paPersCard PA04040 SpareField39 VSTRING 256 256 0 Spare Field 39
paPersCard PA04041 SpareField40 VSTRING 256 256 0 Spare Field 40
paPersCard PA04042 SpareField41 VSTRING 256 256 0 Spare Field 41
paPersCard PA04043 SpareField42 VSTRING 256 256 0 Spare Field 42
paPersCard PA04044 SpareField43 VSTRING 256 256 0 Spare Field 43
paPersCard PA04045 LastName VSTRING 256 256 0 Last Name
paPersCard PA04046 PatronimicName VSTRING 256 256 0 Patronimic Name
paPersCard PA04047 FirstName VSTRING 256 256 0 First Name
paPersCard PA04048 ForeignLangName VSTRING 256 256 0 Foreign Language Name
paPersCard PA04049 SpareField48 VSTRING 256 256 0 Spare Field 48
paPersCard PA04050 SpareField49 VSTRING 256 256 0 Spare Field 49
paPersCard PA04051 SpareField50 VSTRING 256 256 0 Spare Field 50
paPersCard PA04052 SpareField51 VSTRING 256 256 0 Spare Field 51
paPersCard PA04053 SpareField52 VSTRING 256 256 0 Spare Field 52
paPersCard PA04054 SpareField53 VSTRING 256 256 0 Spare Field 53
paPersCard PA04055 SpareField54 VSTRING 256 256 0 Spare Field 54
paPersCard PA04056 SpareField55 VSTRING 256 256 0 Spare Field 55
paPersCard PA04057 SpareField56 VSTRING 256 256 0 Spare Field 56
paPersCard PA04058 SpareField57 VSTRING 256 256 0 Spare Field 57
paPersCard PA04059 RemarkLine1 VSTRING 256 256 0 Remark Line 1
paPersCard PA04060 RemarkLine2 VSTRING 256 256 0 Remark Line 2
paPersCard PA04061 LastUpdDate DATE 8 0 0 Date Updated
paPersCard PA04062 NameSrchKey VSTRING 256 256 0 Search Name
paPersCard PA04063 SpareField62 VSTRING 256 256 0 Spare Field 62
paPersCard PA04064 SpareField63 VSTRING 256 256 0 Spare Field 63
paPersCard PA04065 SpareField64 VSTRING 256 256 0 Spare Field 64
paPersCard PA04066 SpareField65 VSTRING 256 256 0 Spare Field 65
paPersCard PA04067 SpareField66 VSTRING 256 256 0 Spare Field 66
paPersCard PA04068 SpareField67 ACCSTR 120 120 0 Spare Field 67
paPersCard PA04069 SpareField68 VSTRING 256 256 0 Spare Field 68
paPersCard PA04070 SpareField69 VSTRING 256 256 0 Spare Field 69
paPersCard PA04071 SpareField70 STRING 4 4 0 Spare Field 70
paPersCard PA04072 DateOfBirth STRING 8 8 0 Date of Birth
paPersCard PA04073 SpareField72 VSTRING 256 256 0 Spare Field 72
paPersCard PA04074 SpareField73 VSTRING 256 256 0 Spare Field 73
paPersCard PA04075 SpareField74 VSTRING 256 256 0 Spare Field 74
paPersCard PA04076 SpareField75 VSTRING 256 256 0 Spare Field 75
paPersCard PA04077 SpareField76 VSTRING 256 256 0 Spare Field 76
paPersCard PA04078 ActivityCode STRING 1 1 0 Activity Code 0 - Active,
1 - Cancelled,
2 - Anonymized
paPersCard PA04079 SpareField78 VSTRING 32 32 0 Spare Field 78
paPersCard PA04080 IBANactivation INTEGER 1 0 0 IBAN Activation