One level Up / One level Up: Структура таблиц / Table structure Epicor iScala 3.3 (x64) — 3.3.0419 :: Список таблиц модуля /List of tables of module «Payroll»

Структура таблиц / Table structure Epicor iScala 3.3 (x64) — 3.3.0419 :: Таблица / Table PA35 — Payroll Calculation Models

Таблица / Table: PA35 — «PA35 Calcul.Models». Маска имени таблицы / Table name mask: «PA35%cc00»

Поле / Field Тип поля / Field Type Тип поля Scala / iScala Field Type Длина поля / Field length Точность / Precision Длина Scala / iScala length Комментарий / Comment Расширенный комментарий / Extended comment Дополнительное описание / Additional description Позиция в индексе / Index position Первичный ключ? / Is Primary key?
PA35001 NCHAR STRING 3 0 3 ModeNo Mode Number   1 Да / Yes
PA35002 NCHAR STRING 1 0 1 PaymntPeriod Payment Basis      
PA35003 NCHAR STRING 6 0 6 EmplCodeFrom Employee Code From      
PA35004 NCHAR STRING 6 0 6 EmplCodeTo Employee Code To      
PA35005 NCHAR STRING 5 0 5 DepartmtFrom Department From      
PA35006 NCHAR STRING 5 0 5 DepartmtTo Department To      
PA35007 NCHAR STRING 5 0 5 CategoryFrom Category From      
PA35008 NCHAR STRING 5 0 5 CategoryTo Category To      
PA35009 NVARCHAR VSTRING 15 0 15 SplFieldFrom Split Field From      
PA35010 NVARCHAR VSTRING 15 0 15 SplFieldTo Split Field To      
PA35011 NCHAR SWITCH 1 0 1 InclFixWages Include Fixed Wage Types      
PA35012 NCHAR SWITCH 1 0 1 InclRepWages Include Reported Wage Types      
PA35013 NCHAR STRING 6 0 6 AutWageType1 Automatic Wage Type 1      
PA35014 NCHAR STRING 6 0 6 AutWageType2 Automatic Wage Type 2      
PA35015 NCHAR STRING 6 0 6 AutWageType3 Automatic Wage Type 3      
PA35016 NCHAR STRING 6 0 6 AutWageType4 Automatic Wage Type 4      
PA35017 NCHAR STRING 6 0 6 AutWageType5 Automatic Wage Type 5      
PA35018 NCHAR STRING 6 0 6 AutWageType6 Automatic Wage Type 6      
PA35019 NCHAR STRING 6 0 6 AutWageType7 Automatic Wage Type 7      
PA35020 NCHAR STRING 6 0 6 AutWageType8 Automatic Wage Type 8      
PA35021 NCHAR STRING 6 0 6 AutWageType9 Automatic Wage Type 9      
PA35022 NCHAR STRING 6 0 6 AutWageTyp10 Automatic Wage Type 10      
PA35023 NCHAR STRING 6 0 6 AutWageTyp11 Automatic Wage Type 11      
PA35024 NCHAR STRING 6 0 6 AutWageTyp12 Automatic Wage Type 12      
PA35025 NCHAR STRING 6 0 6 AutWageTyp13 Automatic Wage Type 13      
PA35026 NCHAR STRING 6 0 6 AutWageTyp14 Automatic Wage Type 14      
PA35027 NCHAR STRING 6 0 6 AutWageTyp15 Automatic Wage Type 15      
PA35028 NCHAR STRING 6 0 6 AutWageTyp16 Automatic Wage Type 16      
PA35029 NCHAR STRING 6 0 6 AutWageTyp17 Automatic Wage Type 17      
PA35030 NCHAR STRING 6 0 6 AutWageTyp18 Automatic Wage Type 18      
PA35031 NCHAR STRING 6 0 6 AutWageTyp19 Automatic Wage Type 19      
PA35032 NCHAR STRING 6 0 6 AutWageTyp20 Automatic Wage Type 20      
PA35033 NCHAR STRING 6 0 6 AutWageTyp21 Automatic Wage Type 21      
PA35034 NCHAR STRING 6 0 6 AutWageTyp22 Automatic Wage Type 22      
PA35035 NCHAR STRING 6 0 6 AutWageTyp23 Automatic Wage Type 23      
PA35036 NCHAR STRING 6 0 6 AutWageTyp24 Automatic Wage Type 24      
PA35037 NCHAR STRING 6 0 6 AutWageTyp25 Automatic Wage Type 25      
PA35038 NCHAR STRING 6 0 6 AutWageTyp26 Automatic Wage Type 26      
PA35039 NCHAR STRING 6 0 6 AutWageTyp27 Automatic Wage Type 27      
PA35040 NCHAR STRING 6 0 6 AutWageTyp28 Automatic Wage Type 28      
PA35041 NCHAR STRING 6 0 6 AutWageTyp29 Automatic Wage Type 29      
PA35042 NCHAR STRING 6 0 6 AutWageTyp30 Automatic Wage Type 30      
PA35043 NCHAR STRING 6 0 6 AutWageTyp31 Automatic Wage Type 31      
PA35044 NCHAR STRING 6 0 6 AutWageTyp32 Automatic Wage Type 32      
PA35045 NCHAR STRING 6 0 6 AutWageTyp33 Automatic Wage Type 33      
PA35046 NCHAR STRING 6 0 6 AutWageTyp34 Automatic Wage Type 34      
PA35047 NCHAR STRING 6 0 6 AutWageTyp35 Automatic Wage Type 35      
PA35048 NCHAR STRING 6 0 6 AutWageTyp36 Automatic Wage Type 36      
PA35049 NCHAR STRING 6 0 6 AutWageTyp37 Automatic Wage Type 37      
PA35050 NCHAR STRING 6 0 6 AutWageTyp38 Automatic Wage Type 38      
PA35051 NCHAR STRING 6 0 6 AutWageTyp39 Automatic Wage Type 39      
PA35052 NCHAR STRING 6 0 6 AutWageTyp40 Automatic Wage Type 40      
PA35053 NCHAR STRING 6 0 6 AutWageTyp41 Automatic Wage Type 41      
PA35054 NCHAR STRING 6 0 6 AutWageTyp42 Automatic Wage Type 42      
PA35055 NCHAR STRING 6 0 6 AutWageTyp43 Automatic Wage Type 43      
PA35056 NCHAR STRING 6 0 6 AutWageTyp44 Automatic Wage Type 44      
PA35057 NCHAR STRING 6 0 6 AutWageTyp45 Automatic Wage Type 45      
PA35058 NCHAR STRING 6 0 6 AutWageTyp46 Automatic Wage Type 46      
PA35059 NCHAR STRING 6 0 6 AutWageTyp47 Automatic Wage Type 47      
PA35060 NCHAR STRING 6 0 6 AutWageTyp48 Automatic Wage Type 48      
PA35061 NCHAR STRING 6 0 6 AutWageTyp49 Automatic Wage Type 49      
PA35062 NCHAR STRING 6 0 6 AutWageTyp50 Automatic Wage Type 50      
PA35063 NCHAR STRING 6 0 6 AutWageTyp51 Automatic Wage Type 51      
PA35064 NCHAR STRING 6 0 6 AutWageTyp52 Automatic Wage Type 52      
PA35065 NCHAR STRING 6 0 6 AutWageTyp53 Automatic Wage Type 53      
PA35066 NCHAR STRING 6 0 6 AutWageTyp54 Automatic Wage Type 54      
PA35067 NCHAR STRING 6 0 6 AutWageTyp55 Automatic Wage Type 55      
PA35068 NCHAR STRING 6 0 6 AutWageTyp56 Automatic Wage Type 56      
PA35069 NCHAR STRING 6 0 6 AutWageTyp57 Automatic Wage Type 57      
PA35070 NCHAR STRING 6 0 6 AutWageTyp58 Automatic Wage Type 58      
PA35071 NCHAR STRING 6 0 6 AutWageTyp59 Automatic Wage Type 59      
PA35072 NCHAR STRING 6 0 6 AutWageTyp60 Automatic Wage Type 60      
PA35073 NCHAR STRING 6 0 6 AutWageTyp61 Automatic Wage Type 61      
PA35074 NCHAR STRING 6 0 6 AutWageTyp62 Automatic Wage Type 62      
PA35075 NCHAR STRING 6 0 6 AutWageTyp63 Automatic Wage Type 63      
PA35076 NCHAR STRING 6 0 6 AutWageTyp64 Automatic Wage Type 64      
PA35077 NCHAR STRING 6 0 6 AutWageTyp65 Automatic Wage Type 65      
PA35078 NCHAR STRING 6 0 6 AutWageTyp66 Automatic Wage Type 66      
PA35079 NCHAR STRING 6 0 6 AutWageTyp67 Automatic Wage Type 67      
PA35080 NCHAR STRING 6 0 6 AutWageTyp68 Automatic Wage Type 68      
PA35081 NCHAR STRING 6 0 6 AutWageTyp69 Automatic Wage Type 69      
PA35082 NCHAR STRING 6 0 6 AutWageTyp70 Automatic Wage Type 70      
PA35083 NCHAR STRING 6 0 6 AutWageTyp71 Automatic Wage Type 71      
PA35084 NCHAR STRING 6 0 6 AutWageTyp72 Automatic Wage Type 72      
PA35085 NCHAR STRING 6 0 6 AutWageTyp73 Automatic Wage Type 73      
PA35086 NCHAR STRING 6 0 6 AutWageTyp74 Automatic Wage Type 74      
PA35087 NCHAR STRING 6 0 6 AutWageTyp75 Automatic Wage Type 75      
PA35088 NCHAR STRING 6 0 6 AutWageTyp76 Automatic Wage Type 76      
PA35089 NCHAR STRING 6 0 6 AutWageTyp77 Automatic Wage Type 77      
PA35090 NCHAR STRING 6 0 6 AutWageTyp78 Automatic Wage Type 78      
PA35091 NCHAR STRING 6 0 6 AutWageTyp79 Automatic Wage Type 79      
PA35092 NCHAR STRING 6 0 6 AutWageTyp80 Automatic Wage Type 80      
PA35093 NCHAR STRING 1 0 1 ModelType Model Type 0 — Regular model

1 — Statistical model
   
PA35094 NCHAR STRING 6 0 6 CompanyHdrFrom Company Header From      
PA35095 NCHAR STRING 6 0 6 CompanyHdrTo Company Header To      
PA35096 NCHAR STRING 6 0 6 CompanyFtrFrom Company Footer From      
PA35097 NCHAR STRING 6 0 6 CompanyFtrTo Company Footer To      
PA35098 NCHAR STRING 6 0 6 EmployeeHdrFrom Employee Header From      
PA35099 NCHAR STRING 6 0 6 EmployeeHdrTo Employee Header To      
PA35100 NCHAR STRING 6 0 6 EmployeeFtrFrom Employee Footer From      
PA35101 NCHAR STRING 6 0 6 EmployeeFtrTo Employee Footer To      
PA35102 NCHAR STRING 6 0 6 TSFrom Time Sheet From      
PA35103 NCHAR STRING 6 0 6 TSTo Time Sheet To      
PA35104 NCHAR STRING 1 0 1 Model type Model type      
PA35105 NCHAR STRING 1 0 1 Detail persist schema Detail persist schema      
PA35106 NCHAR STRING 1 0 1 A skip flag of employee card validation code N 24(custom calculation model) A skip flag of employee card validation code N 24(custom calculation model)      

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