Не забудьте посетить страницу «Наши услуги» и заказать интеграцию Epicor Service Connect, отчет SSRS или что-то еще... / Be sure to visit our Services page and order an Epicor Service Connect integration, SSRS report, or anything else...
Таблица: PA03 - «PA03 Wage Types». Маска имени таблицы: «PA03%cc00»
Поле | Тип поля | Тип поля Scala | Длина поля | Точность | Длина Scala | Комментарий | Расширенный комментарий | Дополнительное описание | Позиция в индексе | Первичный ключ? |
PA03001 | NCHAR | STRING | 6 | 0 | 6 | SalaryType | Wage Type | 1 | Да | |
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 |
Навигация: Структура БД iScala | Epicor iScala 2.3 SR2 - 2.03.10355 | Payroll | Wage Types