Структура таблиц Epicor iScala 3.00 (x64) - 3.00.02254 :: Список таблиц модуля «Payroll»
Название Таблицы | Маска Таблицы | Описание Таблицы |
PA01 | PA01%cc%yy | PA01 - Payroll Parameters |
PA02 | PA02%cc00 | PA02 - Unions |
PA03 | PA03%cc00 | PA03 - Wage Types |
PA04 | PA04%cc00 | PA04 - Employees |
PA05 | PA05%cc00 | PA05 - Fixed Wage Types |
PA06 | PA06%cc00 | PA06 - Payroll Statistics |
PA07 | PA07%cc00 | PA07 - Reported Salary Transaction |
PA08 | PA08%cc00 | PA08 - Tax Tables |
PA09 | PA09%cc00 | PA09 - Payroll Calculation |
PA10 | PA10%cc00 | PA10 - Payroll Payment List |
PA11 | PA11%cc00 | PA11 - Employee History |
PA12 | PA12%cc00 | PA12 - Employee Search Table |
PA13 | PA13%cc00 | PA13 - Employee Record Setup |
PA14 | PA14%cc00 | PA14 - Report Names |
PA17 | PA17%cc%yy | PA17 - Payroll Journal |
PA19 | PA19%cc00 | PA19 - Payroll Calculation Constants |
PA20 | PA20%cc00 | PA20 - Extended Accumulators |
PA23 | PA23%cc00 | PA23 - Previous Employees |
PA24 | PA24%cc00 | PA24 - Previous Employees Search Table |
PA25 | PA25%cc00 | PA25 - Previous Employees Extended Accumulators |
PA2A | PA2A%cc00 | PA2A - Previous Employees Accumulators |
PA2B | PA2B%cc00 | PA2B - Extended Accumulators Template |
PA31 | PA31%cc00 | PA31 - Work Calendar |
PA32 | PA32%cc00 | PA32 - Timesheet Parameters |
PA33 | PA33%cc00 | PA33 - Time Sheets |
PA34 | PA34%cc00 | PA34 - Payroll Periodical Accumulators |
PA35 | PA35%cc00 | PA35 - Payroll Calculation Models |
PA37 | PA37%cc00 | PA37 - Other Tables |
PA38 | PA38%cc00 | PA38 - User Table Setup |
PA39 | PA39%cc00 | PA39 - Payroll Dictionaries |
PA3A | PA3A%cc00 | PA3A - Timesheet Parameters 2 |
PA40 | PA40%cc00 | PA40 - Dictionary Search Table |
PA41 | PA41%cc00 | PA41 - Multilingual Name |
PA44 | PA44%cc00 | PA44 - Periodical Accumulators Setup |
PA45 | PA45%cc00 | PA45 - Report Work Table |
PA46 | PA46%cc00 | PA46 - Employee History of Field Changes |
PA4A | PA4A%cc00 | PA4A - Employee Accumulators |
PA4B | PA4B%cc00 | PA4B - Employee Templates |
PA4C | PA4C%cc00 | PA4C - Employees Accumulator Templates |
PA4D | PA4D%cc00 | PA4D - Employee Image |
PA50 | PA50%cc00 | PA50 - Dictionary Links |
PA60 | PA60%cc00 | PA60 - Individual Timesheet Details |
PA61 | PA61%cc00 | PA61 - Individual Timesheet |
PA62 | PA62%cc00 | PA62 - PA62 Ts Signs |
PA63 | PA63%cc00 | PA63 - PA63 Tc Main |
PA64 | PA64%cc00 | PA64 - PA64 Tc Line |
PA70 | PA70%cc00 | PA70 - Time Type |
PA75 | PA75%cc00 | PA75 - Payroll History |
PA76 | PA76%cc00 | PA76 - Payroll Transaction |
PA77 | PA77%cc00 | PA77 - Payroll Groups |
PA81 | PA81%cc00 | PA81 - Task Main |
PA82 | PA82%cc00 | PA82 - Task Details |
paAuditDetails | paAuditDetails%cc00 | paAuditDetails - Audit details |
paAuditHeader | paAuditHeader%cc00 | paAuditHeader - Audit header |
paBatchHeader | paBatchHeader%cc00 | paBatchHeader - Batch header |
paBatchRepWages | paBatchRepWages%cc00 | paBatchRepWages - Batch of reported wages |
paBTRepWages | paBTRepWages%cc00 | paBTRepWages - Business Transactions for Reported Wages |
paBudgetDraft | paBudgetDraft%cc00 | paBudgetDraft - Budget Draft |
paBudgetEmplAcc | paBudgetEmplAcc%cc00 | paBudgetEmplAcc - Budget Accumulators |
paBudgetEmplCard | paBudgetEmplCard%cc00 | paBudgetEmplCard - Budget Employee Card |
paBudgetEmplExtAcc | paBudgetEmplExtAcc%cc00 | paBudgetEmplExtAcc - Budget Extended Acc. |
paBudgetEmplHistory | paBudgetEmplHistory%cc00 | paBudgetEmplHistory - Budget Employee History |
paBudgetEmplPerAcc | paBudgetEmplPerAcc%cc00 | paBudgetEmplPerAcc - Spare table |
paBudgetEmplSearch | paBudgetEmplSearch%cc00 | paBudgetEmplSearch - Budget Employee Search |
paBudgetFixedWages | paBudgetFixedWages%cc00 | paBudgetFixedWages - Budget Fixed Wages |
paBudgetHistoryOfChanges | paBudgetHistoryOfChanges%cc00 | paBudgetHistoryOfChanges - Budget History of Changes |
paBudgetLevels | paBudgetLevels%cc00 | paBudgetLevels - Budget Levels |
paBudgetLevelsWages | paBudgetLevelsWages%cc00 | paBudgetLevelsWages - Budget Levels Wages |
paBudgetPerAccsData | paBudgetPerAccsData%cc00 | paBudgetPerAccsData - Budget Periodical Accumulators |
paBudgetPeriodDetails | paBudgetPeriodDetails%cc00 | paBudgetPeriodDetails - Budget Period Details |
paBudgetPeriodHead | paBudgetPeriodHead%cc00 | paBudgetPeriodHead - Budget Period Head |
paBudgetStat | paBudgetStat%cc00 | paBudgetStat - Budget Statistics |
paCalcModelWages | paCalcModelWages%cc00 | paCalcModelWages - Calculated model wage types |
paContractExt | paContractExt%cc00 | paContractExt - Contract extended attributes |
paCustomFilterConfig | paCustomFilterConfig%cc00 | paCustomFilterConfig - Custom filter metadescriptions |
paCustomTreeConfig | paCustomTreeConfig%cc00 | paCustomTreeConfig - Custom tree configuration |
paDictExt | paDictExt%cc00 | paDictExt - Extension of dictionaries |
paEmplHistory | paEmplHistory%cc00 | paEmplHistory - Employee history |
paHistoryCategoryFields | paHistoryCategoryFields%cc00 | paHistoryCategoryFields - Fields of History Categories |
paHistoryOfChanges | paHistoryOfChanges%cc00 | paHistoryOfChanges - History of Changes |
PAL1 | PAL1%cc00 | PAL1 - PAL1 Comp Report Main |
PAL2 | PAL2%cc00 | PAL2 - PAL2 Comp Report Details |
paOlapLayouts | paOlapLayouts%cc00 | paOlapLayouts - OLAP Layouts |
paPerAccs | paPerAccs%cc00 | paPerAccs - Periodical Accumulators Setup (Advanced Payroll) |
paPerAccsData | paPerAccsData%cc00 | paPerAccsData - Periodical Accumulators Data (Advanced Payroll) |
paPerAccsNames | paPerAccsNames%cc00 | paPerAccsNames - Periodical Accumulators Names |
PAR1 | PAR1%cc00 | PAR1 - Report Main |
PAR2 | PAR2%cc00 | PAR2 - Report Details |
PAR3 | PAR3%cc00 | PAR3 - Definition |
PAR4 | PAR4%cc00 | PAR4 - Definition Rules |
paReportAccess | paReportAccess%cc00 | paReportAccess - Reports access |
paShifts | paShifts%cc00 | paShifts - Shifts |
paTaxes | paTaxes%cc%yy | paTaxes - Taxes |
paTaxesDetails | paTaxesDetails%cc%yy | paTaxesDetails - Details of taxes |
paTaxesNames | paTaxesNames%cc%yy | paTaxesNames - Taxes names |
paTimeActGroups | paTimeActGroups%cc00 | paTimeActGroups - Time Activity Groups |
paTimeTrans | paTimeTrans%cc00 | paTimeTrans - Time transaction items |
paTimeTransBatch | paTimeTransBatch%cc00 | paTimeTransBatch - Headers of time transactions |
paTimeTransLinks | paTimeTransLinks%cc00 | paTimeTransLinks - Time transaction links |
paTreeRelations | paTreeRelations%cc00 | paTreeRelations - Tree Relations |
paTSStat | paTSStat%cc00 | paTSStat - Timesheet statistics |
PAU3 | PAU3%cc00 | PAU3 - PAU3 User Group Rights |
paWageExt | paWageExt%cc00 | paWageExt - Extension of wage types |
PAX0 | PAX0%cc00 | PAX0 - Synchronization |
Навигация: Структура БД iScala | Epicor iScala 3.00 (x64) - 3.00.02254 | Payroll