Таблица: SMP4 - «Preventive Maintenance Proposal». Маска имени таблицы: «SMP4%cc00»
Поле | Тип поля | Тип поля iScala | Длина поля | Точность | Длина iScala | Комментарий | Расширенный комментарий | Дополнительное описание | Позиция в индексе | Первичный ключ? |
SMP4001 | NUMERIC | X_NUMERIC | 16 | 8 | 8 | Line | Line Number | 1 | Да | |
SMP4002 | NCHAR | STRING | 10 | 0 | 10 | Customer | Customer Code | |||
SMP4003 | NCHAR | STRING | 4 | 0 | 4 | Site | Site Code | |||
SMP4004 | NCHAR | STRING | 35 | 0 | 35 | ObjCode | Stock/Asset Code | |||
SMP4005 | NCHAR | STRING | 20 | 0 | 20 | SerialNumber | Serial Number | |||
SMP4006 | NCHAR | STRING | 10 | 0 | 10 | Contract | Contract Number | |||
SMP4007 | NCHAR | STRING | 8 | 0 | 8 | JobNum | Job Number | |||
SMP4008 | DATETIME | DATE | 0 | 0 | 8 | StartDate | Start Date | |||
SMP4009 | NCHAR | STRING | 6 | 0 | 6 | OrderType | Order Type | |||
SMP4010 | NCHAR | STRING | 1 | 0 | 1 | OrdeCreateFlag | Order Created | |||
SMP4011 | DATETIME | DATE | 0 | 0 | 8 | PlanDate | Planned Date | |||
SMP4012 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | PlanQty | Planned Quantity | |||
SMP4013 | NCHAR | STRING | 2 | 0 | 2 | QtyType | Quantity Type | |||
SMP4014 | NCHAR | STRING | 5 | 0 | 5 | PMScheduleLineNumber | PM Schedule Line Number | |||
SMP4015 | NCHAR | STRING | 10 | 0 | 10 | Serviceordernumber | Service Order Number | |||
SMP4016 | NCHAR | STRING | 6 | 0 | 6 | Contractlinenumber | Contract Line Number | |||
SMP4017 | NCHAR | STRING | 6 | 0 | 6 | ContractSublineNum | Contract Sub-line Number | |||
SMP4018 | NVARCHAR | VSTRING | 10 | 0 | 10 | DefaultEngineer | Default Engineer | |||
SMP4019 | NCHAR | STRING | 1 | 0 | 1 | ServObjType | Service Object Type | |||
SMP4020 | NCHAR | STRING | 10 | 0 | 10 | ValueComponentNo | Value Component No | |||
SMP4021 | INT | INTEGER | 0 | 0 | 9 | JobID | Job ID |
Навигация: Структура БД iScala | Epicor iScala 3.00 (x64) - 3.00.02254 | Service Order Management | Preventive Maintenance Proposal