На один уровень вверх / One level Up: Структура таблиц / Table structure Epicor iScala 3.5 (x64) — 3.5.0429 :: Список таблиц модуля /List of tables of module «Payroll»

Структура таблиц / Table structure Epicor iScala 3.5 (x64) — 3.5.0429 :: Таблица / Table PA01 — Payroll Parameters

Таблица / Table: PA01 — «PA01 Stand.Param.». Маска имени таблицы / Table name mask: «PA01%cc%yy»

Поле / Field Тип поля / Field Type Тип поля Scala / iScala Field Type Длина поля / Field length Точность / Precision Длина Scala / iScala length Комментарий / Comment Расширенный комментарий / Extended comment Дополнительное описание / Additional description Позиция в индексе / Index position Первичный ключ? / Is Primary key?
PA01001 NCHAR STRING 4 0 4 IndexKey Index Key   1 Да / Yes
PA01002 NCHAR STRING 4 0 4 EuroPayroVer Euro Payroll Version      
PA01003 NCHAR STRING 1 0 1 Spare (obsolete)      
PA01004 NCHAR STRING 2 0 2 AccumNetPay Accumulator for Interim Calculation      
PA01005 NCHAR SWITCH 1 0 1 InterimCalculation Interim Calculation      
PA01006 NCHAR STRING 3 0 3 CurrCalcModel Model of Last Calculation      
PA01007 DATETIME DATE 0 0 8 PAPaymDate Payment Date of Last Calculation      
PA01008 NCHAR STRING 1 0 1 CurrPaymBasis Last Payment Basis      
PA01009 NCHAR STRING 1 0 1 Spare Payroll Calculation Status 0 — Payroll calculation is not done

1 — Calculation done

2 — Payslips printed

3 — Payroll transactions created, accumulators update

4 — Update complete		    
PA01010 NCHAR STRING 1 0 1 Spare (obsolete)      
PA01011 NCHAR STRING 1 0 1 Spare (obsolete)      
PA01012 DATETIME DATE 0 0 8 StartInterimCalc Start Interim Calculation      
PA01013 DATETIME DATE 0 0 8 EndInterimCalc End Interim Calculation      
PA01014 NCHAR STRING 1 0 1 EmpCodeDigNo Number of Digits in Employee Number      
PA01015 NCHAR STRING 1 0 1 Spare (obsolete)      
PA01016 INT INTEGER 0 0 2 UnclWorkVar First Non-zeroed Calculation Variable      
PA01017 INT INTEGER 0 0 2 TimeshWrkVar Last Calculation Variable Zeroed on Time Sheet      
PA01018 NCHAR STRING 1 0 1 Spare (obsolete)      
PA01019 NCHAR STRING 1 0 1 NumDayTypes Number of Day Types      
PA01020 NCHAR STRING 1 0 1 NumHourTypes Number of Hour Types      
PA01021 NCHAR STRING 1 0 1 NextPANumber (obsolete)      
PA01022 NCHAR STRING 7 0 7 PayrollTax1 Social Tax 1 %      
PA01023 NCHAR STRING 7 0 7 PayrollTax2 Social Tax 2 %      
PA01024 NCHAR STRING 7 0 7 PayrollTax3 Social Tax 3 %      
PA01025 NCHAR STRING 7 0 7 PayrollTax4 Social Tax 4 %      
PA01026 NCHAR STRING 7 0 7 PayrollTax5 Social Tax 5 %      
PA01027 NCHAR STRING 7 0 7 PayrollTax6 Social Tax 6 %      
PA01028 NCHAR STRING 7 0 7 PayrollTax7 Social Tax 7 %      
PA01029 NCHAR STRING 7 0 7 PayrollTax8 Social Tax 8 %      
PA01030 NCHAR STRING 7 0 7 PayrollTax9 Social Tax 9 %      
PA01031 NCHAR STRING 7 0 7 PayrollTax10 Social Tax 10 %      
PA01032 NCHAR STRING 1 0 1 EncNoActiveEmpl Encoded number of active Employees      
PA01033 NCHAR STRING 1 0 1 UserDefTablesDec Number of Decimals for Additional Tables      
PA01034 NCHAR STRING 1 0 1 TransSourceCnt Transaction Source Counter      
PA01035 NCHAR STRING 1 0 1 Spare (obsolete)      
PA01036 NCHAR STRING 1 0 1 Spare (obsolete)      
PA01037 NCHAR STRING 1 0 1 Spare (obsolete)      
PA01038 NCHAR STRING 1 0 1 Spare (obsolete)      
PA01039 NCHAR STRING 1 0 1 Spare (obsolete)      
PA01040 NCHAR STRING 1 0 1 Spare (obsolete)      
PA01041 NCHAR STRING 1 0 1 Spare (obsolete)      
PA01042 NCHAR STRING 1 0 1 Spare (obsolete)      
PA01043 NCHAR STRING 1 0 1 Spare (obsolete)      
PA01044 NCHAR STRING 1 0 1 Spare (obsolete)      
PA01045 NCHAR STRING 1 0 1 Spare (obsolete)      
PA01046 NCHAR STRING 1 0 1 Spare (obsolete)      
PA01047 NCHAR STRING 1 0 1 Spare (obsolete)      
PA01048 NCHAR STRING 1 0 1 Spare (obsolete)      
PA01049 NCHAR STRING 1 0 1 Spare (obsolete)      
PA01050 NCHAR STRING 1 0 1 Spare (obsolete)      
PA01051 NCHAR STRING 1 0 1 MastCalcPeriod Master Calculation Period      
PA01052 NCHAR SWITCH 1 0 1 IntegratedGL Integrated With General Ledger      
PA01053 NCHAR SWITCH 1 0 1 UseGLTrCounter Use Transaction Number from General Ledger      
PA01054 NCHAR SWITCH 1 0 1 GenTrTimRepEntry Direct Entry to Accounts      
PA01055 NCHAR SWITCH 1 0 1 CompulSocSecEntry Mandatory Identity Number      
PA01056 NCHAR SWITCH 1 0 1 CDVCheck Check Digit Control for ID number      
PA01057 NCHAR SWITCH 1 0 1 ExecGLAutoAlloc Perform Automatic Allocations      
PA01058 NCHAR SWITCH 1 0 1 ReportComp01 Reports from Company 01      
PA01059 NCHAR SWITCH 1 0 1 TaxTabComp01 Tax Tables from Company 01      
PA01060 NCHAR SWITCH 1 0 1 PrintPADepartment Print Payroll per Department      
PA01061 NCHAR SWITCH 1 0 1 PrintWTSpecif Print Employee Specification in Payroll Summary      
PA01062 NCHAR SWITCH 1 0 1 PrintPAJournal Print Payroll Journal Transactions      
PA01063 NCHAR SWITCH 1 0 1 PrnPAJourSumm Print Payroll Journal Summary      
PA01064 NCHAR SWITCH 1 0 1 PrnZeroLines Print Zero Lines      
PA01065 NCHAR SWITCH 1 0 1 PrnPaySlips Print Payslips for Zero Payment      
PA01066 NCHAR SWITCH 1 0 1 EmpSortLastWrd Employee File Sorted by Last Word      
PA01067 NCHAR SWITCH 1 0 1 CrePAListUpdate Create Payroll Lists      
PA01068 NCHAR SWITCH 1 0 1 SaveEmplChng Save History of Changes      
PA01069 NCHAR SWITCH 1 0 1 SaveFuturPerTrans Save Future Period Wage Types      
PA01070 NCHAR SWITCH 1 0 1 DeemedTimesheets Deemed Time Sheets      
PA01071 NCHAR SWITCH 1 0 1 BiLineTransactions Bi-line Transactions      
PA01072 NCHAR SWITCH 1 0 1 DateCalcAlgo (obsolete)      
PA01073 NCHAR SWITCH 1 0 1 Spare (obsolete)      
PA01074 NCHAR SWITCH 1 0 1 Spare (obsolete)      
PA01075 NCHAR SWITCH 1 0 1 Spare (obsolete)      
PA01076 NCHAR SWITCH 1 0 1 Spare (obsolete)      
PA01077 NCHAR SWITCH 1 0 1 Spare (obsolete)      
PA01078 NCHAR SWITCH 1 0 1 Spare (obsolete)      
PA01079 NCHAR SWITCH 1 0 1 Spare (obsolete)      
PA01080 NCHAR SWITCH 1 0 1 Spare (obsolete)      
PA01081 NCHAR SWITCH 1 0 1 Spare (obsolete)      
PA01082 NCHAR SWITCH 1 0 1 Spare (obsolete)      
PA01083 NCHAR SWITCH 1 0 1 Spare (obsolete)      
PA01084 NVARCHAR VSTRING 12 0 12 AccCashPayments Account Cash Payments      
PA01085 NVARCHAR VSTRING 12 0 12 AccPostPayments Account Post Payments      
PA01086 NVARCHAR VSTRING 12 0 12 AccBankPayments Account Bank Payments      
PA01087 NVARCHAR VSTRING 12 0 12 AccBalDirCoding Account Settlement of Direct Coding      
PA01088 NVARCHAR VSTRING 12 0 12 AccPATax1PL Account Social Tax 1 (P&L)      
PA01089 NVARCHAR VSTRING 12 0 12 AccPATax1BAL Account Social Tax 1 (Balance)      
PA01090 NVARCHAR VSTRING 12 0 12 AccPATax2PL Account Social Tax 2 (P&L)      
PA01091 NVARCHAR VSTRING 12 0 12 AccPATax2BAL Account Social Tax 2 (Balance)      
PA01092 NVARCHAR VSTRING 12 0 12 AccPATax3PL Account Social Tax 3 (P&L)      
PA01093 NVARCHAR VSTRING 12 0 12 AccPATax3BAL Account Social Tax 3 (Balance)      
PA01094 NVARCHAR VSTRING 12 0 12 AccPATax4PL Account Social Tax 4 (P&L)      
PA01095 NVARCHAR VSTRING 12 0 12 AccPATax4BAL Account Social Tax 4 (Balance)      
PA01096 NVARCHAR VSTRING 12 0 12 AccPATax5PL Account Social Tax 5 (P&L)      
PA01097 NVARCHAR VSTRING 12 0 12 AccPATax5BAL Account Social Tax 5 (Balance)      
PA01098 NVARCHAR VSTRING 12 0 12 AccPATax6PL Account Social Tax 6 (P&L)      
PA01099 NVARCHAR VSTRING 12 0 12 AccPATax6BAL Account Social Tax 6 (Balance)      
PA01100 NVARCHAR VSTRING 12 0 12 AccPATax7PL Account Social Tax 7 (P&L)      
PA01101 NVARCHAR VSTRING 12 0 12 AccPATax7BAL Account Social Tax 7 (Balance)      
PA01102 NVARCHAR VSTRING 12 0 12 AccPATax8PL Account Social Tax 8 (P&L)      
PA01103 NVARCHAR VSTRING 12 0 12 AccPATax8BAL Account Social Tax 8 (Balance)      
PA01104 NVARCHAR VSTRING 12 0 12 AccPATax9PL Account Social Tax 9 (P&L)      
PA01105 NVARCHAR VSTRING 12 0 12 AccPATax9BAL Account Social Tax 9 (Balance)      
PA01106 NVARCHAR VSTRING 12 0 12 AccPATax10PL Account Social Tax 10 (P&L)      
PA01107 NVARCHAR VSTRING 12 0 12 AccPATx10BAL Account Social Tax 10 (Balance)      
PA01108 NVARCHAR VSTRING 12 0 12 Spare (obsolete)      
PA01109 NVARCHAR VSTRING 12 0 12 Spare (obsolete)      
PA01110 NVARCHAR VSTRING 12 0 12 Spare (obsolete)      
PA01111 NVARCHAR VSTRING 12 0 12 Spare (obsolete)      
PA01112 NVARCHAR VSTRING 12 0 12 Spare (obsolete)      
PA01113 NVARCHAR VSTRING 12 0 12 Spare (obsolete)      
PA01114 NCHAR STRING 1 0 1 Unit Payment Period 1 — Unit 1 — Days

2 — Month

4 — Half months		    
PA01115 INT INTEGER 0 0 3 StepUnits Payment Period 1 — Quantity      
PA01116 DATETIME DATE 0 0 8 StartDate Payment Period 1 — Start Date      
PA01117 DATETIME DATE 0 0 8 EndDate Payment Period 1 — End Date      
PA01118 NCHAR STRING 1 0 1 Unit Payment Period 2 — Unit      
PA01119 INT INTEGER 0 0 3 StepUnits Payment Period 2 — Quantity      
PA01120 DATETIME DATE 0 0 8 StartDate Payment Period 2 — Start Date      
PA01121 DATETIME DATE 0 0 8 EndDate Payment Period 2 — End Date      
PA01122 NCHAR STRING 1 0 1 Unit Payment Period 3 — Unit      
PA01123 INT INTEGER 0 0 3 StepUnits Payment Period 3 — Quantity      
PA01124 DATETIME DATE 0 0 8 StartDate Payment Period 3 — Start Date      
PA01125 DATETIME DATE 0 0 8 EndDate Payment Period 3 — End Date      
PA01126 NCHAR STRING 1 0 1 Unit Payment Period 4 — Unit      
PA01127 INT INTEGER 0 0 3 StepUnits Payment Period 4 — Quantity      
PA01128 DATETIME DATE 0 0 8 StartDate Payment Period 4 — Start Date      
PA01129 DATETIME DATE 0 0 8 EndDate Payment Period 4 — End Date      
PA01130 NCHAR STRING 1 0 1 Unit Payment Period 5 — Unit      
PA01131 INT INTEGER 0 0 3 StepUnits Payment Period 5 — Quantity      
PA01132 DATETIME DATE 0 0 8 StartDate Payment Period 5 — Start Date      
PA01133 DATETIME DATE 0 0 8 EndDate Payment Period 5 — End Date      
PA01134 NCHAR STRING 1 0 1 Unit Payment Period 6 — Unit      
PA01135 INT INTEGER 0 0 3 StepUnits Payment Period 6 — Quantity      
PA01136 DATETIME DATE 0 0 8 StartDate Payment Period 6 — Start Date      
PA01137 DATETIME DATE 0 0 8 EndDate Payment Period 6 — End Date      
PA01138 NCHAR STRING 1 0 1 Unit Payment Period 7 — Unit      
PA01139 INT INTEGER 0 0 3 StepUnits Payment Period 7 — Quantity      
PA01140 DATETIME DATE 0 0 8 StartDate Payment Period 7 — Start Date      
PA01141 DATETIME DATE 0 0 8 EndDate Payment Period 7 — End Date      
PA01142 NCHAR STRING 1 0 1 Unit Payment Period 8 — Unit      
PA01143 INT INTEGER 0 0 3 StepUnits Payment Period 8 — Quantity      
PA01144 DATETIME DATE 0 0 8 StartDate Payment Period 8 — Start Date      
PA01145 DATETIME DATE 0 0 8 EndDate Payment Period 8 — End Date      
PA01146 NCHAR STRING 1 0 1 Unit Payment Period 9 — Unit      
PA01147 INT INTEGER 0 0 3 StepUnits Payment Period 9 — Quantity      
PA01148 DATETIME DATE 0 0 8 StartDate Payment Period 9 — Start Date      
PA01149 DATETIME DATE 0 0 8 EndDate Payment Period 9 — End Date      
PA01150 NCHAR STRING 3 0 3 BasicLan Payroll Setup Language      

Навигация / Navigation: