пользователям программных продуктов Scala 5.0, Scala 5.1, iScala 2.1, iScala 2.2, iScala 2.3, iScala 3.0 (и так далее)

Таблица: MP63 - «Routings». Маска имени таблицы: «MP63%cc00»

Поле Тип поля Тип поля iScala Длина поля Точ­ность Длина iScala Комментарий Расширенный комментарий Дополнительное описание Пози­ция в инде­ксе Первич­ный ключ?
MP63001 NCHAR STRING 1 0 1 OperationType Operation Type   1 Да
MP63002 NCHAR STRING 35 0 35 ParentItem Parent Stock Item   2 Да
MP63003 NCHAR STRING 2 0 2 Alternate Alternate Routing   3 Да
MP63004 NCHAR STRING 3 0 3 OperationNo Operation Number   4 Да
MP63005 INT INTEGER 0 0 1 OPType Work Centre Is Sub Contractor      
MP63006 NVARCHAR VSTRING 20 0 20 Description Description      
MP63007 NVARCHAR VSTRING 8 0 8 WorkCenter Work Centre      
MP63008 NVARCHAR VSTRING 15 0 15 ToolNumber Tool Number      
MP63009 NUMERIC X_NUMERIC 14 8 6 SetupTime1 Setup Time 1      
MP63010 NUMERIC X_NUMERIC 16 8 8 ProductRate1 Production Rate 1      
MP63011 NUMERIC X_NUMERIC 17 8 9 RunTime1 Run Time 1      
MP63012 NVARCHAR VSTRING 9 0 9 Spare (obsolete)      
MP63013 NCHAR STRING 3 0 3 CodeOpenRunTime Open Time Code      
MP63014 NVARCHAR VSTRING 3 0 3 Spare (obsolete)      
MP63015 NUMERIC X_NUMERIC 13 8 5 QueueTime Queue Time      
MP63016 NUMERIC X_NUMERIC 13 8 5 MoveTime Move Time      
MP63017 NUMERIC X_NUMERIC 15 8 7 Overlap Overlapping Time      
MP63018 NUMERIC MONEY 28 8 20 SubcontrCost Sub-contractor Cost      
MP63019 NVARCHAR VSTRING 3 0 3 CostCode Cost Code      
MP63020 NUMERIC X_NUMERIC 13 8 5 SetupCrew Setup Crew Number      
MP63021 NUMERIC X_NUMERIC 13 8 5 RunCrew Run Crew Number      
MP63022 INT INTEGER 0 0 2 NumberOfTime Job Tickets      
MP63023 NUMERIC X_NUMERIC 14 8 6 SetupTime2 Setup Time 2      
MP63024 NUMERIC X_NUMERIC 16 8 8 ProductRate2 Production Rate 2      
MP63025 NUMERIC X_NUMERIC 17 8 9 RunTime2 Run Time 2      
MP63026 INT INTEGER 0 0 1 TextCode Text Code Exist      
MP63027 NVARCHAR ACCSTR 50 0 50 AccString Accounting String      
MP63028 NVARCHAR VSTRING 6 0 6 Spare (obsolete)      
MP63029 NVARCHAR VSTRING 6 0 6 Spare (obsolete)      
MP63030 NVARCHAR VSTRING 6 0 6 Spare (obsolete)      
MP63031 INT INTEGER 0 0 2 AccCode Accounting Code      
MP63032 NUMERIC X_NUMERIC 12 8 4 NoResources Number of Resources      
MP63033 INT INTEGER 0 0 5 LeadTime Lead Time      
MP63034 NUMERIC X_NUMERIC 14 8 6 ScrapFactor Scrap %      
MP63035 NVARCHAR VSTRING 3 0 3 ProductiCode Production Code      
MP63036 NVARCHAR VSTRING 6 0 6 Spare (obsolete)      
MP63037 NVARCHAR VSTRING 35 0 35 ReturnItem Return Stock Item      
MP63038 NVARCHAR VSTRING 1 0 1 WeightType Weight Type      
MP63039 NVARCHAR VSTRING 1 0 1 RulePrinting Printing Rule      
MP63040 NUMERIC X_NUMERIC 18 8 10 Quantity Quantity      
MP63041 NVARCHAR VSTRING 1 0 1 OperType Type      
MP63042 NUMERIC X_NUMERIC 14 8 6 YieldFactor Yield Factor      
MP63043 NVARCHAR VSTRING 2 0 2 CompSetupTime Competence - Setup Time      
MP63044 NVARCHAR VSTRING 2 0 2 CompetRunTime Competence - Run Time      
MP63045 NUMERIC X_NUMERIC 14 8 6 SetupTimeInner Setup Time Inner      
MP63046 NCHAR SWITCH 1 0 1 Dispatching Dispatching      
MP63047 NUMERIC MONEY 28 8 20 StandardCost Standard Cost      
MP63048 NCHAR SWITCH 1 0 1 NotDependVolume Volume Independent      
MP63049 NVARCHAR VSTRING 1 0 1 CriticalOperation Is Critical Operation      
MP63050 NCHAR SWITCH 1 0 1 GRPMainOP GRP Main Operation      
MP63051 NVARCHAR VSTRING 1 0 1 Spare (obsolete)      
MP63052 NVARCHAR VSTRING 12 0 12 Spare (obsolete)      

Навигация: Структура БД iScala | Epicor iScala 3.00 (x64) - 3.00.02254 | Material Production Control | Routings

TopList

© Алексей Васильев. 2004-2019. При использовании материалов ссылка обязательна.