One level Up / One level Up: Структура таблиц / Table structure Epicor iScala 3.3 (x64) — 3.3.0419 :: Список таблиц модуля /List of tables of module «Service Order Management»

Структура таблиц / Table structure Epicor iScala 3.3 (x64) — 3.3.0419 :: Таблица / Table SMP1 — Preventive Maintenance Plan

Таблица / Table: SMP1 — «Peventative Maintenance Plan». Маска имени таблицы / Table name mask: «SMP1%cc00»

Поле / Field Тип поля / Field Type Тип поля Scala / iScala Field Type Длина поля / Field length Точность / Precision Длина Scala / iScala length Комментарий / Comment Расширенный комментарий / Extended comment Дополнительное описание / Additional description Позиция в индексе / Index position Первичный ключ? / Is Primary key?
SMP1001 NCHAR STRING 10 0 10 ContractNumber Contract Number   1 Да / Yes
SMP1002 NCHAR STRING 3 0 3 TemplateNumber Template Number   2 Да / Yes
SMP1003 NCHAR STRING 5 0 5 Line Line Number   3 Да / Yes
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 20 8 12 QtyCycle Quantity Cycle      
SMP1008 NCHAR STRING 2 0 2 QtyType 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 PMInterval 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 QtyAgreed Quantity Agreed      
SMP1014 NCHAR STRING 1 0 1 ServiceType 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 QtyCycleInitial Quantity Cycle Initial Value      
SMP1016 NCHAR STRING 10 0 10 CustomerCode Customer Code      
SMP1017 NUMERIC X_NUMERIC 28 8 20 QtyOverPrice Over Price per Quantity      
SMP1018 NUMERIC X_NUMERIC 28 8 20 QtyUnderPrice Under Price per Quantity      
SMP1019 NUMERIC X_NUMERIC 28 8 20 AmountOldInvoiced Amount Invoiced Old      
SMP1020 NCHAR STRING 6 0 6 Contractlinenumber Contract Line number      
SMP1021 NCHAR STRING 6 0 6 ContractSublineNum 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      
SMP1028 INT INTEGER 0 0 9 UseEndDate Use of End Date      

Навигация / Navigation: