Не забудьте посетить страницу «Наши услуги» и заказать интеграцию Epicor Service Connect, отчет SSRS или что-то еще... / Be sure to visit our Services page and order an Epicor Service Connect integration, SSRS report, or anything else...
Таблица: paBudgetDraft - «Budget Draft». Маска имени таблицы: «paBudgetDraft%cc00»
Поле | Тип поля | Тип поля Scala | Длина поля | Точность | Длина Scala | Комментарий | Расширенный комментарий | Дополнительное описание | Позиция в индексе | Первичный ключ? |
PA09001 | NCHAR | STRING | 6 | 0 | 6 | EmployeeCode | Employee Code | 1 | Да | |
PA09002 | NCHAR | STRING | 6 | 0 | 6 | SalaryType | Wage Type | 2 | Да | |
PA09003 | INT | INTEGER | 0 | 0 | 3 | LineNo | Line Number | 3 | Да | |
PA09004 | NCHAR | STRING | 1 | 0 | 1 | LineType | Line Type | 0 - Normal payroll transaction
2 - Affects only tax 8 - Warning text 9 - Text line |
||
PA09005 | NVARCHAR | VSTRING | 50 | 0 | 50 | AccString | Accounting String | |||
PA09006 | NCHAR | STRING | 1 | 0 | 1 | Spare | (obsolete) | |||
PA09007 | NCHAR | STRING | 1 | 0 | 1 | Spare | (obsolete) | |||
PA09008 | NCHAR | STRING | 1 | 0 | 1 | Spare | (obsolete) | |||
PA09009 | NVARCHAR | VSTRING | 20 | 0 | 20 | Amount1 | Amount 1 | |||
PA09010 | NVARCHAR | VSTRING | 20 | 0 | 20 | Amount2 | Amount 2 | |||
PA09011 | NVARCHAR | VSTRING | 20 | 0 | 20 | Amount3 | Amount 3 | |||
PA09012 | NVARCHAR | VSTRING | 20 | 0 | 20 | Amount4 | Amount 4 | |||
PA09013 | NVARCHAR | VSTRING | 20 | 0 | 20 | Amount5 | Amount 5 | |||
PA09014 | NVARCHAR | VSTRING | 20 | 0 | 20 | Amount6 | Amount 6 | |||
PA09015 | NVARCHAR | VSTRING | 20 | 0 | 20 | Amount7 | Amount 7 | |||
PA09016 | NVARCHAR | VSTRING | 20 | 0 | 20 | Amount8 | Amount 8 | |||
PA09017 | NCHAR | STRING | 4 | 0 | 4 | TransactType | Transaction Type | The type depends on the first character:
0 - Fixed wage type, character 2-4 will hold the line number as reference to fixed wage type table (PA05) 1 - Reported wage type, character 2-4 will hold the line number as reference to reported wage type table (PA07) 2 - Automatic wage type |
||
PA09018 | DATETIME | DATE | 0 | 0 | 8 | StartDate | Start Date | |||
PA09019 | DATETIME | DATE | 0 | 0 | 8 | EndDate | End Date | |||
PA09020 | NVARCHAR | VSTRING | 15 | 0 | 15 | ReferenField | Reference Field | |||
PA09021 | NVARCHAR | VSTRING | 50 | 0 | 50 | Text | Text | |||
PA09022 | INT | INTEGER | 0 | 0 | 6 | Pacalcno | Payroll Calculation Number |
Навигация: Структура БД iScala | Epicor iScala 2.3 SR2 - 2.03.10355 | Payroll | Budget Draft