Таблица | Table: SMP4 - «Preventive Maintenance Proposal». Маска имени таблицы | Table Name Mask: «SMP4%cc00»
Поле | Тип поля | Тип поля iScala | Длина поля | Точность | Длина iScala | Комментарий | Расширенный комментарий | Дополнительное описание | Позиция в индексе | Первичный ключ? |
Field | Field Type | iScala Field Type | Field Length | Precision | iScala Length | Comment | Extended Comment | Additional Description | Index Position | Is Primary key? |
SMP4001 | NUMERIC | X_NUMERIC | 16 | 8 | 8 | Line | Line Number | 1 | Да / Yes | |
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 | Job# | 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 | PM Schedule Line Number | PM Schedule Line Number | |||
SMP4015 | NCHAR | STRING | 10 | 0 | 10 | Service order number | Service Order Number | |||
SMP4016 | NCHAR | STRING | 6 | 0 | 6 | Contract line number | Contract Line Number | |||
SMP4017 | NCHAR | STRING | 6 | 0 | 6 | Contract subline number | Contract Sub-line Number | |||
SMP4018 | NVARCHAR | VSTRING | 10 | 0 | 10 | Default Engineer | 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 |
Навигация / Shortcut: Структура БД iScala / iScala DB structure | Epicor iScala 2.3 SR3 - 2.03.12787 | Service Order Management | Preventive Maintenance Proposal