Таблица: PA61 - «PA61 Ts Main». Маска имени таблицы: «PA61%cc00»
Поле | Тип поля | Тип поля Scala | Длина поля | Точность | Длина Scala | Комментарий | Расширенный комментарий | Дополнительное описание | Позиция в индексе | Первичный ключ? |
AccString | NVARCHAR | VSTRING | 50 | 0 | 50 | Acc String | Accounting String | |||
DateEnd | DATETIME | DATE | 0 | 0 | 8 | Date End | Date End | 4 | Да | |
DateStart | DATETIME | DATE | 0 | 0 | 8 | Date Start | Date Start | 3 | Да | |
EmplCode | NCHAR | STRING | 6 | 0 | 6 | Employee Code | Employee Code | 1 | Да | |
InPayrollStatus | NCHAR | STRING | 1 | 0 | 1 | In Payroll Status | In Payroll Status | Payroll Status:
0 - Not Approved Yet 1 - Completed |
||
MngAccStatus | NCHAR | STRING | 1 | 0 | 1 | Mng Acc Status | Mng Accept Status | 0 - Not Approved Yet
1 - Approved 2 - Rejected |
||
MngEmplStatus | NCHAR | STRING | 1 | 0 | 1 | Mng Employee Status | Mng Employee Status | 0 - Not Approved Yet
1 - Approved 2 - Rejected |
||
PayrollNumber | INT | INTEGER | 0 | 0 | 4 | Payroll Number | Payroll Number | |||
SubmittedBy | NVARCHAR | VSTRING | 150 | 0 | 150 | Submitted By | Submitted By | |||
SubmittedOn | DATETIME | DATE | 0 | 0 | 8 | Submitted On | Submitted On | |||
SubmittedOnAcc | DATETIME | DATE | 0 | 0 | 8 | Submitted On Acc | Submitted On Accept | |||
TaskIdAccept | NCHAR | STRING | 32 | 0 | 32 | Task Id Accept | Task ID Accept | |||
TaskIdApprove | NCHAR | STRING | 32 | 0 | 32 | Task Id Approve | Task ID Approve | |||
TaskIdSubmit | NCHAR | STRING | 32 | 0 | 32 | Task Id Submit | Task ID Submit | |||
TsNumber | NUMERIC | NUMBER | 20 | 0 | 13 | Ts Number | Timesheet Number | 2 | Да |
Навигация: Структура БД iScala | Epicor iScala 2.3 SR1 - 2.03.8155 | Payroll | Individual Timesheet