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 PA03 — Wage Types

Таблица / 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 256 0 256 Description Description      
PA03003 NVARCHAR VSTRING 256 0 256 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 ACCSTR 120 0 120 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 256 0 256 Prompt1 Question 1 — Label      
PA03013 NVARCHAR VSTRING 256 0 256 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 — Not an 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: