Таблица: SMP1 - «Peventative Maintenance Plan». Маска имени таблицы: «SMP1%cc00»
Поле | Тип поля | Тип поля Scala | Длина поля | Точность | Длина Scala | Комментарий | Расширенный комментарий | Дополнительное описание | Позиция в индексе | Первичный ключ? |
SMP1001 | NCHAR | STRING | 10 | 0 | 10 | ContractNumber | Contract Number | 1 | Да | |
SMP1002 | NCHAR | STRING | 3 | 0 | 3 | TemplateNumber | Template Number | 2 | Да | |
SMP1003 | NCHAR | STRING | 5 | 0 | 5 | Line | Line Number | 3 | Да | |
SMP1004 | NCHAR | STRING | 35 | 0 | 35 | ObjCode | Stock/Asset Code | |||
SMP1005 | NCHAR | STRING | 20 | 0 | 20 | SerialNumber | Serial Number | |||
SMP1006 | NCHAR | STRING | 4 | 0 | 4 | Site | Site Code | |||
SMP1007 | NUMERIC | X_NUMERIC | 16 | 8 | 8 | Qty_Cycle | Quantity Cycle | |||
SMP1008 | NCHAR | STRING | 2 | 0 | 2 | Qty_Type | Quantity Type | |||
SMP1009 | NCHAR | STRING | 8 | 0 | 8 | JobNumber | Job Number | |||
SMP1010 | DATETIME | DATE | 0 | 0 | 8 | StartDate | Start Date | |||
SMP1011 | DATETIME | DATE | 0 | 0 | 8 | EndDate | End Date | |||
SMP1012 | NCHAR | STRING | 4 | 0 | 4 | PM Interval | Forecast Interval | First character in string specifies the unit used for the interval ([D]ays, [W]eeks, [M]onth, [Y]ears, [P]eriod, [Q]Quater) | ||
SMP1013 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | Qty_Agreed | Quantity Agreed | |||
SMP1014 | NCHAR | STRING | 1 | 0 | 1 | Service_Type | Service Type | 0 - Order creation is allowed on bases of proposal
1 - Order creation is not allowed on bases of proposal |
||
SMP1015 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | Qty_Cycle_Initial | Quantity Cycle Initial Value | |||
SMP1016 | NCHAR | STRING | 10 | 0 | 10 | Customer_Code | Customer Code | |||
SMP1017 | NUMERIC | X_NUMERIC | 28 | 8 | 20 | Qty_OverPrice | Over Price per Quantity | |||
SMP1018 | NUMERIC | X_NUMERIC | 28 | 8 | 20 | Qty_UnderPrice | Under Price per Quantity | |||
SMP1019 | NUMERIC | X_NUMERIC | 28 | 8 | 20 | Amount_Old_Invoiced | Amount Invoiced Old | |||
SMP1020 | NCHAR | STRING | 6 | 0 | 6 | Contract line number | Contract Line number | |||
SMP1021 | NCHAR | STRING | 6 | 0 | 6 | Contract subline number | Contract Sub-line Number | |||
SMP1022 | NVARCHAR | VSTRING | 10 | 0 | 10 | DefaultEngineer | Default Engineer | |||
SMP1023 | NVARCHAR | VSTRING | 200 | 0 | 200 | TemplateDescr | Template Description | |||
SMP1024 | NCHAR | STRING | 1 | 0 | 1 | ServObjType | Service Object Type | |||
SMP1025 | NCHAR | STRING | 10 | 0 | 10 | ValueComponentNo | Value Component No | |||
SMP1026 | INT | INTEGER | 0 | 0 | 9 | JobID | Job ID | |||
SMP1027 | NCHAR | STRING | 6 | 0 | 6 | OrdType | Order Type |
Навигация: Структура БД iScala | Epicor iScala 2.3 SR1 - 2.03.8155 | Service Order Management | Preventive Maintenance Plan