Таблица / Table: PA03 — «PA03 Wage Types». Маска имени таблицы / Table name mask: «PA03%cc00»
Поле / Field | Тип поля / Field Type | Тип поля Scala / iScala Field Type | Длина поля / Field length | Точность / Precision | Длина Scala / iScala length | Комментарий / Comment | Расширенный комментарий / Extended comment | Дополнительное описание / Additional description | Позиция в индексе / Index position | Первичный ключ? / Is Primary key? |
PA03001 | NCHAR | STRING | 6 | 0 | 6 | SalaryType | Wage Type | 1 | Да / Yes | |
PA03002 | NVARCHAR | VSTRING | 25 | 0 | 25 | Description | Description | |||
PA03003 | NVARCHAR | VSTRING | 25 | 0 | 25 | Explanation | Explanation | |||
PA03004 | NCHAR | STRING | 1 | 0 | 1 | Spare | (obsolete) | |||
PA03005 | NCHAR | STRING | 1 | 0 | 1 | Spare | (obsolete) | |||
PA03006 | NCHAR | STRING | 1 | 0 | 1 | Spare | (obsolete) | |||
PA03007 | NVARCHAR | VSTRING | 50 | 0 | 50 | AccString | Accounting String | Each accounting dimension can be either a valid code, empty or it might include wild-cards. | ||
PA03008 | NVARCHAR | VSTRING | 20 | 0 | 20 | Constant1 | Constant 1 | |||
PA03009 | NVARCHAR | VSTRING | 20 | 0 | 20 | Constant2 | Constant 2 | |||
PA03010 | NVARCHAR | VSTRING | 20 | 0 | 20 | Constant3 | Constant 3 | |||
PA03011 | NVARCHAR | VSTRING | 20 | 0 | 20 | Constant4 | Constant 4 | |||
PA03012 | NVARCHAR | VSTRING | 15 | 0 | 15 | Prompt1 | Question 1 — Label | |||
PA03013 | NVARCHAR | VSTRING | 15 | 0 | 15 | Prompt2 | Question 2 — Label | |||
PA03014 | NCHAR | STRING | 1 | 0 | 1 | FlagAddUp | Summarize on Payslip | |||
PA03015 | NCHAR | STRING | 5 | 0 | 5 | SalaryCmdNo1 | 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). |
||
PA03016 | NCHAR | STRING | 5 | 0 | 5 | SalaryCmdNo2 | Calculation Command 2 | |||
PA03017 | NCHAR | STRING | 5 | 0 | 5 | SalaryCmdNo3 | Calculation Command 3 | |||
PA03018 | NCHAR | STRING | 5 | 0 | 5 | SalaryCmdNo4 | Calculation Command 4 | |||
PA03019 | NCHAR | STRING | 5 | 0 | 5 | SalaryCmdNo5 | Calculation Command 5 | |||
PA03020 | NCHAR | STRING | 5 | 0 | 5 | SalaryCmdNo6 | Calculation Command 6 | |||
PA03021 | NCHAR | STRING | 5 | 0 | 5 | SalaryCmdNo7 | Calculation Command 7 | |||
PA03022 | NCHAR | STRING | 5 | 0 | 5 | SalaryCmdNo8 | Calculation Command 8 | |||
PA03023 | NCHAR | STRING | 5 | 0 | 5 | SalaryCmdNo9 | Calculation Command 9 | |||
PA03024 | NCHAR | STRING | 5 | 0 | 5 | SalaryCmdN10 | Calculation Command 10 | |||
PA03025 | NCHAR | STRING | 5 | 0 | 5 | SalaryCmdN11 | Calculation Command 11 | |||
PA03026 | NCHAR | STRING | 5 | 0 | 5 | SalaryCmdN12 | Calculation Command 12 | |||
PA03027 | NCHAR | STRING | 5 | 0 | 5 | SalaryCmdN13 | Calculation Command 13 | |||
PA03028 | NCHAR | STRING | 5 | 0 | 5 | SalaryCmdN14 | Calculation Command 14 | |||
PA03029 | NCHAR | STRING | 5 | 0 | 5 | SalaryCmdN15 | Calculation Command 15 | |||
PA03030 | NCHAR | STRING | 5 | 0 | 5 | SalaryCmdN16 | Calculation Command 16 | |||
PA03031 | NCHAR | STRING | 5 | 0 | 5 | SalaryCmdN17 | Calculation Command 17 | |||
PA03032 | NCHAR | STRING | 5 | 0 | 5 | SalaryCmdN18 | Calculation Command 18 | |||
PA03033 | NCHAR | STRING | 5 | 0 | 5 | SalaryCmdN19 | Calculation Command 19 | |||
PA03034 | NCHAR | STRING | 5 | 0 | 5 | SalaryCmdN20 | Calculation Command 20 | |||
PA03035 | NCHAR | STRING | 5 | 0 | 5 | SalaryCmdN21 | Calculation Command 21 | |||
PA03036 | NCHAR | STRING | 5 | 0 | 5 | SalaryCmdN22 | Calculation Command 22 | |||
PA03037 | NCHAR | STRING | 5 | 0 | 5 | SalaryCmdN23 | Calculation Command 23 | |||
PA03038 | NCHAR | STRING | 5 | 0 | 5 | SalaryCmdN24 | Calculation Command 24 | |||
PA03039 | NCHAR | STRING | 5 | 0 | 5 | SalaryCmdN25 | Calculation Command 25 | |||
PA03040 | NCHAR | STRING | 5 | 0 | 5 | SalaryCmdN26 | Calculation Command 26 | |||
PA03041 | NCHAR | STRING | 5 | 0 | 5 | SalaryCmdN27 | Calculation Command 27 | |||
PA03042 | NCHAR | STRING | 5 | 0 | 5 | SalaryCmdN28 | Calculation Command 28 | |||
PA03043 | NCHAR | STRING | 5 | 0 | 5 | SalaryCmdN29 | Calculation Command 29 | |||
PA03044 | NCHAR | STRING | 5 | 0 | 5 | SalaryCmdN30 | Calculation Command 30 | |||
PA03045 | NCHAR | STRING | 5 | 0 | 5 | SalaryCmdN31 | Calculation Command 31 | |||
PA03046 | NCHAR | STRING | 5 | 0 | 5 | SalaryCmdN32 | Calculation Command 32 | |||
PA03047 | NCHAR | STRING | 5 | 0 | 5 | SalaryCmdN33 | Calculation Command 33 | |||
PA03048 | NCHAR | STRING | 5 | 0 | 5 | SalaryCmdN34 | Calculation Command 34 | |||
PA03049 | NCHAR | STRING | 5 | 0 | 5 | SalaryCmdN35 | Calculation Command 35 | |||
PA03050 | NCHAR | STRING | 5 | 0 | 5 | SalaryCmdN36 | Calculation Command 36 | |||
PA03051 | NCHAR | STRING | 5 | 0 | 5 | SalaryCmdN37 | Calculation Command 37 | |||
PA03052 | NCHAR | STRING | 5 | 0 | 5 | SalaryCmdN38 | Calculation Command 38 | |||
PA03053 | NCHAR | STRING | 5 | 0 | 5 | SalaryCmdN39 | Calculation Command 39 | |||
PA03054 | NCHAR | STRING | 5 | 0 | 5 | SalaryCmdN40 | Calculation Command 40 | |||
PA03055 | NCHAR | STRING | 5 | 0 | 5 | SalaryCmdN41 | Calculation Command 41 | |||
PA03056 | NCHAR | STRING | 5 | 0 | 5 | SalaryCmdN42 | Calculation Command 42 | |||
PA03057 | NCHAR | STRING | 5 | 0 | 5 | SalaryCmdN43 | Calculation Command 43 | |||
PA03058 | NCHAR | STRING | 5 | 0 | 5 | SalaryCmdN44 | Calculation Command 44 | |||
PA03059 | NCHAR | STRING | 5 | 0 | 5 | SalaryCmdN45 | Calculation Command 45 | |||
PA03060 | NCHAR | STRING | 5 | 0 | 5 | SalaryCmdN46 | Calculation Command 46 | |||
PA03061 | NCHAR | STRING | 5 | 0 | 5 | SalaryCmdN47 | Calculation Command 47 | |||
PA03062 | NCHAR | STRING | 5 | 0 | 5 | SalaryCmdN48 | Calculation Command 48 | |||
PA03063 | NCHAR | STRING | 5 | 0 | 5 | SalaryCmdN49 | Calculation Command 49 | |||
PA03064 | NCHAR | STRING | 5 | 0 | 5 | SalaryCmdN50 | Calculation Command 50 | |||
PA03065 | NCHAR | STRING | 5 | 0 | 5 | SalaryCmdN51 | Calculation Command 51 | |||
PA03066 | NCHAR | STRING | 5 | 0 | 5 | SalaryCmdN52 | Calculation Command 52 | |||
PA03067 | NCHAR | STRING | 5 | 0 | 5 | SalaryCmdN53 | Calculation Command 53 | |||
PA03068 | NCHAR | STRING | 5 | 0 | 5 | SalaryCmdN54 | Calculation Command 54 | |||
PA03069 | NCHAR | STRING | 5 | 0 | 5 | SalaryCmdN55 | Calculation Command 55 | |||
PA03070 | NCHAR | STRING | 5 | 0 | 5 | SalaryCmdN56 | Calculation Command 56 | |||
PA03071 | NCHAR | STRING | 5 | 0 | 5 | SalaryCmdN57 | Calculation Command 57 | |||
PA03072 | NCHAR | STRING | 5 | 0 | 5 | SalaryCmdN58 | Calculation Command 58 | |||
PA03073 | NCHAR | STRING | 5 | 0 | 5 | SalaryCmdN59 | Calculation Command 59 | |||
PA03074 | NCHAR | STRING | 5 | 0 | 5 | SalaryCmdN60 | Calculation Command 60 | |||
PA03075 | NCHAR | SWITCH | 1 | 0 | 1 | CalcSocInsurance | Calculate Social Tax | |||
PA03076 | NCHAR | STRING | 5 | 0 | 5 | FixedTaxRate | Fixed Tax Rate % | |||
PA03077 | NCHAR | STRING | 1 | 0 | 1 | PrnSalarySpec | Print on Payslip | |||
PA03078 | NCHAR | STRING | 6 | 0 | 6 | ChainSalType | Chained Wage Type | |||
PA03079 | NCHAR | SWITCH | 1 | 0 | 1 | PayrollTax1 | 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 |
||
PA03080 | NCHAR | SWITCH | 1 | 0 | 1 | PayrollTax2 | 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 |
||
PA03081 | NCHAR | SWITCH | 1 | 0 | 1 | PayrollTax3 | 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 |
||
PA03082 | NCHAR | SWITCH | 1 | 0 | 1 | PayrollTax4 | 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 |
||
PA03083 | NCHAR | SWITCH | 1 | 0 | 1 | PayrollTax5 | 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 |
||
PA03084 | NCHAR | STRING | 5 | 0 | 5 | LaboAgreArea | Labour Agreement Area | |||
PA03085 | NCHAR | SWITCH | 1 | 0 | 1 | EnterReference | Enter Reference | 0 — No entry of reference 1 — Manual entry 2 — Entry from history 3 — Entry from recipient 4 — Entry from recipient and history |
||
PA03086 | NCHAR | STRING | 1 | 0 | 1 | Spare | (obsolete) | |||
PA03087 | NCHAR | SWITCH | 1 | 0 | 1 | OnlyTaxCalculation | 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 |
||
PA03088 | NVARCHAR | VSTRING | 35 | 0 | 35 | WarningText1 | Warning Text Line 1 | |||
PA03089 | NVARCHAR | VSTRING | 35 | 0 | 35 | WarningText2 | Warning Text Line 2 | |||
PA03090 | NCHAR | STRING | 1 | 0 | 1 | Constant1Decimals | Constant 1 — Number of Decimals | |||
PA03091 | NCHAR | STRING | 1 | 0 | 1 | Constant2Decimals | Constant 2 — Number of Decimals | |||
PA03092 | NCHAR | STRING | 1 | 0 | 1 | Constant3Decimals | Constant 3 — Number of Decimals | |||
PA03093 | NCHAR | STRING | 1 | 0 | 1 | Constant4Decimals | Constant 4 — Number of Decimals | |||
PA03094 | NCHAR | STRING | 1 | 0 | 1 | Question1Decimals | Question 1 — Number of Decimals | |||
PA03095 | NCHAR | STRING | 1 | 0 | 1 | Question2Decimals | Question 2 — Number of Decimals | |||
PA03096 | NCHAR | SWITCH | 1 | 0 | 1 | PayrollTax6 | 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 |
||
PA03097 | NCHAR | SWITCH | 1 | 0 | 1 | PayrollTax7 | 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 |
||
PA03098 | NCHAR | SWITCH | 1 | 0 | 1 | PayrollTax8 | 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 |
||
PA03099 | NCHAR | SWITCH | 1 | 0 | 1 | PayrollTax9 | 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 |
||
PA03100 | NCHAR | SWITCH | 1 | 0 | 1 | PayrollTax10 | 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 |
||
PA03101 | NCHAR | SWITCH | 1 | 0 | 1 | CouldBeReported | Can be Reported | |||
PA03102 | NCHAR | SWITCH | 1 | 0 | 1 | CouldBeFixed | Can be Used as Fixed | |||
PA03103 | NVARCHAR | VSTRING | 12 | 0 | 12 | StatistAccnt | Statistical Account | |||
PA03104 | NCHAR | STRING | 1 | 0 | 1 | StatAccCntr | Statistical Account Counter Number | |||
PA03105 | NCHAR | STRING | 2 | 0 | 2 | AutoWTFileNo | 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. |
||
PA03106 | NCHAR | STRING | 3 | 0 | 3 | AutWTFieldNo | Automatic Wage Type Field Number | |||
PA03107 | NCHAR | STRING | 8 | 0 | 8 | UserGroup | User Group | |||
PA03108 | NCHAR | STRING | 2 | 0 | 2 | Counter1Currency | Currency in Counter 1 | |||
PA03109 | NCHAR | STRING | 2 | 0 | 2 | Counter2Currency | Currency in Counter 2 | |||
PA03110 | NCHAR | STRING | 2 | 0 | 2 | Counter3Currency | Currency in Counter 3 | |||
PA03111 | NCHAR | STRING | 2 | 0 | 2 | Counter4Currency | Currency in Counter 4 | |||
PA03112 | NCHAR | STRING | 2 | 0 | 2 | Counter5Currency | Currency in Counter 5 | |||
PA03113 | NCHAR | STRING | 2 | 0 | 2 | Counter6Currency | Currency in Counter 6 | |||
PA03114 | NCHAR | STRING | 2 | 0 | 2 | Counter7Currency | Currency in Counter 7 | |||
PA03115 | NCHAR | STRING | 2 | 0 | 2 | Counter8Currency | Currency in Counter 8 |
Навигация / Navigation:
- Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Список системных таблиц / System Tables
- Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Список таблиц модуля «Управление Основными Средствами» / List of tables of module «Asset Management»
- Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Список таблиц модуля «Управление Контрактами» / List of tables of module «Contract Management»
- Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Список таблиц модуля «Прямая выписка счетов» / List of tables of module «Direct Invoicing»
- Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Список таблиц модуля «Главная Книга» / List of tables of module «General Ledger»
- Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Список таблиц модуля «Управление Ресурсами» / List of tables of module «Resourse Management»
- Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Список таблиц модуля «База данных рынка» / List of tables of module «Market Database»
- Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Список таблиц модуля «Управление Производством» / List of tables of module «Material Production Control»
- Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Список таблиц модуля «Заказы на Продажу» / List of tables of module «Sales Order»
- Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Список таблиц модуля «Заработная плата» / List of tables of module «Payroll»
- Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Список таблиц модуля «Заказы на Закупку» / List of tables of module «Purchase Order»
- Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Список таблиц модуля «Книга Закупок» / List of tables of module «Purchase Ledger»
- Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Список таблиц модуля «Долговые обязательства» / List of tables of module «Promissory Notes»
- Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Список таблиц модуля «Управление проектами» / List of tables of module «Project Management»
- Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Список таблиц модуля «Управление Запасами» / List of tables of module «Stock Control»
- Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Список таблиц модуля «Книга Продаж» / List of tables of module «Sales Ledger»
- Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Список таблиц модуля «Управление заказом на обслуживание» / List of tables of module «Service Order Management»
- Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Список таблиц модуля «Статистика» / List of tables of module «Statistics»
- Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Список таблиц модуля «Системные Утилиты» / List of tables of module «System Utilities/Office Autom.»