Таблица: paTSStat - «Timesheet statistics». Маска имени таблицы: «paTSStat%cc00»
Поле | Тип поля | Тип поля Scala | Длина поля | Точность | Длина Scala | Комментарий | Расширенный комментарий | Дополнительное описание | Позиция в индексе | Первичный ключ? |
PA33001 | NCHAR | STRING | 6 | 0 | 6 | Employee code | 1 | Да | ||
PA33002 | DATETIME | DATE | 0 | 0 | 8 | Start period | 2 | Да | ||
PA33003 | NCHAR | STRING | 3 | 0 | 3 | TimesheetNo | 3 | Да | ||
PA33004 | DATETIME | DATE | 0 | 0 | 8 | End of period | ||||
PA33005 | NVARCHAR | VSTRING | 50 | 0 | 50 | Acc string | ||||
PA33006 | NCHAR | STRING | 1 | 0 | 1 | Spare | ||||
PA33007 | NCHAR | STRING | 1 | 0 | 1 | Spare | ||||
PA33008 | NCHAR | STRING | 1 | 0 | 1 | Spare | ||||
PA33009 | NVARCHAR | VSTRING | 15 | 0 | 15 | Reference | ||||
PA33010 | NVARCHAR | VSTRING | 19 | 0 | 19 | TimesheetPa1 | ||||
PA33011 | NVARCHAR | VSTRING | 19 | 0 | 19 | TimesheetPa2 | ||||
PA33012 | NVARCHAR | VSTRING | 19 | 0 | 19 | TimesheetPa3 | ||||
PA33013 | NVARCHAR | VSTRING | 19 | 0 | 19 | TimesheetPa4 | ||||
PA33014 | NVARCHAR | VSTRING | 19 | 0 | 19 | TimesheetPa5 | ||||
PA33015 | NVARCHAR | VSTRING | 19 | 0 | 19 | TimesheetPa6 | ||||
PA33016 | NVARCHAR | VSTRING | 19 | 0 | 19 | TimesheetPa7 | ||||
PA33017 | NVARCHAR | VSTRING | 19 | 0 | 19 | TimesheetPa8 | ||||
PA33018 | NVARCHAR | VSTRING | 19 | 0 | 19 | TimesheetPa9 | ||||
PA33019 | NVARCHAR | VSTRING | 19 | 0 | 19 | TimesheetPa10 | ||||
PA33020 | NVARCHAR | VSTRING | 19 | 0 | 19 | TimesheetPa11 | ||||
PA33021 | NVARCHAR | VSTRING | 19 | 0 | 19 | TimesheetPa12 | ||||
PA33022 | NVARCHAR | VSTRING | 19 | 0 | 19 | TimesheetPa13 | ||||
PA33023 | NVARCHAR | VSTRING | 19 | 0 | 19 | TimesheetPa14 | ||||
PA33024 | NVARCHAR | VSTRING | 19 | 0 | 19 | TimesheetPa15 | ||||
PA33025 | NVARCHAR | VSTRING | 19 | 0 | 19 | TimesheetPa16 | ||||
PA33026 | NVARCHAR | VSTRING | 19 | 0 | 19 | TimesheetPa17 | ||||
PA33027 | NVARCHAR | VSTRING | 19 | 0 | 19 | TimesheetPa18 | ||||
PA33028 | NVARCHAR | VSTRING | 19 | 0 | 19 | TimesheetPa19 | ||||
PA33029 | NVARCHAR | VSTRING | 19 | 0 | 19 | TimesheetPa20 | ||||
PA33030 | NVARCHAR | VSTRING | 19 | 0 | 19 | TimesheetPa21 | ||||
PA33031 | NVARCHAR | VSTRING | 19 | 0 | 19 | TimesheetPa22 | ||||
PA33032 | NVARCHAR | VSTRING | 19 | 0 | 19 | TimesheetPa23 | ||||
PA33033 | NVARCHAR | VSTRING | 19 | 0 | 19 | TimesheetPa24 | ||||
PA33034 | NVARCHAR | VSTRING | 19 | 0 | 19 | TimesheetPa25 | ||||
PA33035 | NVARCHAR | VSTRING | 19 | 0 | 19 | TimesheetPa26 | ||||
PA33036 | NVARCHAR | VSTRING | 19 | 0 | 19 | TimesheetPa27 | ||||
PA33037 | NVARCHAR | VSTRING | 19 | 0 | 19 | TimesheetPa28 | ||||
PA33038 | NVARCHAR | VSTRING | 19 | 0 | 19 | TimesheetPa29 | ||||
PA33039 | NVARCHAR | VSTRING | 19 | 0 | 19 | TimesheetPa30 | ||||
PA33040 | NVARCHAR | VSTRING | 19 | 0 | 19 | TimesheetPa31 | ||||
PA33041 | NVARCHAR | VSTRING | 19 | 0 | 19 | TimesheetPa32 | ||||
PA33042 | NVARCHAR | VSTRING | 19 | 0 | 19 | TimesheetPa33 | ||||
PA33043 | NVARCHAR | VSTRING | 19 | 0 | 19 | TimesheetPa34 | ||||
PA33044 | NVARCHAR | VSTRING | 19 | 0 | 19 | TimesheetPa35 | ||||
PA33045 | NVARCHAR | VSTRING | 19 | 0 | 19 | TimesheetPa36 | ||||
PA33046 | NVARCHAR | VSTRING | 19 | 0 | 19 | TimesheetPa37 | ||||
PA33047 | NVARCHAR | VSTRING | 19 | 0 | 19 | TimesheetPa38 | ||||
PA33048 | NVARCHAR | VSTRING | 19 | 0 | 19 | TimesheetPa39 | ||||
PA33049 | NVARCHAR | VSTRING | 19 | 0 | 19 | TimesheetPa40 | ||||
PA33050 | NVARCHAR | VSTRING | 19 | 0 | 19 | TimesheetPa41 | ||||
PA33051 | NVARCHAR | VSTRING | 19 | 0 | 19 | TimesheetPa42 | ||||
PA33052 | NVARCHAR | VSTRING | 19 | 0 | 19 | TimesheetPa43 | ||||
PA33053 | NVARCHAR | VSTRING | 19 | 0 | 19 | TimesheetPa44 | ||||
PA33054 | NVARCHAR | VSTRING | 19 | 0 | 19 | TimesheetPa45 | ||||
PA33055 | NVARCHAR | VSTRING | 19 | 0 | 19 | TimesheetPa46 | ||||
PA33056 | NVARCHAR | VSTRING | 19 | 0 | 19 | TimesheetPa47 | ||||
PA33057 | NVARCHAR | VSTRING | 19 | 0 | 19 | TimesheetPa48 | ||||
PA33058 | INT | INTEGER | 0 | 0 | 4 | Pacalcno | 4 | Да |
Навигация: Структура БД iScala | Epicor iScala 2.3 SR1 - 2.03.8155 | Payroll | Timesheet statistics