Таблица: MP9W - «WIP Transactions History». Маска имени таблицы: «MP9W%cc00»

Поле Тип поля Тип поля iScala Длина поля Точ­ность Длина iScala Комментарий Расширенный комментарий Дополнительное описание Пози­ция в инде­ксе Первич­ный ключ?
MP9W001 NCHAR STRING 10 0 10 WorkOrder Work Order   1 Да
MP9W002 NCHAR STRING 2 0 2 Type Transaction Type   2 Да
MP9W003 NCHAR STRING 12 0 12 ReporBatchNo Report Number or Batch ID   3 Да
MP9W004 NCHAR STRING 4 0 4 OperationNo Operation Number   4 Да
MP9W005 NCHAR STRING 35 0 35 Component Stock Item Code Component   5 Да
MP9W006 NCHAR STRING 4 0 4 Number Line Number   6 Да
MP9W007 NUMERIC X_NUMERIC 20 8 12 Quantity Quantity      
MP9W008 NUMERIC MONEY 28 8 20 Value Amount (Local Currency)      
MP9W009 DATETIME DATE 0 0 8 Date_ Transaction Date      
MP9W010 INT INTEGER 0 0 2 AccCode Accounting Code      
MP9W011 NVARCHAR ACCSTR 50 0 50 AccString Accounting String      
MP9W012 NVARCHAR VSTRING 4 0 4 Spare (obsolete)      
MP9W013 NVARCHAR VSTRING 6 0 6 Spare (obsolete)      
MP9W014 NVARCHAR VSTRING 6 0 6 Spare (obsolete)      
MP9W015 NVARCHAR VSTRING 25 0 25 Text Text      
MP9W016 NVARCHAR VSTRING 8 0 8 WorkCentre Work Centre      
MP9W017 NVARCHAR VSTRING 15 0 15 Tool Tool Number      
MP9W018 NVARCHAR VSTRING 6 0 6 Warehouse Warehouse      
MP9W019 NUMERIC X_NUMERIC 14 8 6 SetUpTime Setup Time      
MP9W020 NUMERIC X_NUMERIC 28 8 20 RunTime Run Time      
MP9W021 NUMERIC X_NUMERIC 13 8 5 RunCrew Run Crew      
MP9W022 NUMERIC X_NUMERIC 13 8 5 SetUpCrew Setup Crew      
MP9W023 NUMERIC MONEY 28 8 20 SubcontrCost Sub-contractor Cost      
MP9W024 NUMERIC MONEY 28 8 20 SetUpCost Setup Cost      
MP9W025 NUMERIC MONEY 28 8 20 RunCost Run Cost      
MP9W026 NUMERIC MONEY 28 8 20 VarWrkCtrCst Work Centre Cost Variable      
MP9W027 NUMERIC MONEY 28 8 20 FixWrkCtrCst Work Centre Cost Fixed      
MP9W028 NUMERIC MONEY 28 8 20 VarToolCost Tool Cost Variable      
MP9W029 NUMERIC MONEY 28 8 20 FixToolCost Tool Cost Fixed      
MP9W030 INT INTEGER 0 0 1 Status Status      
MP9W031 NUMERIC MONEY 28 8 20 WrkCtrOverhead Work Centre Overhead      
MP9W032 NUMERIC MONEY 28 8 20 AmountCC Amount (Alternative Currency)      
MP9W033 NCHAR STRING 8 0 8 Spare Index Counter      

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