Таблица: 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 StockItem Stock Item 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      

Навигация: Структура БД iScala | Epicor iScala 2.3 - 2.03.3363 | Service Order Management | Preventive Maintenance Plan