Таблица: MP5J - «Wrk.Dispatching». Маска имени таблицы: «MP5J0000»
Поле | Тип поля | Тип поля Scala | Длина поля | Точность | Длина Scala | Комментарий | Расширенный комментарий | Дополнительное описание | Позиция в индексе | Первичный ключ? |
MP5J001 | NCHAR | STRING | 3 | 0 | 3 | DispatchOrder | 1 | Да | ||
MP5J002 | NCHAR | STRING | 35 | 0 | 35 | DispatchTerm | 2 | Да | ||
MP5J003 | DATETIME | DATE | 0 | 0 | 8 | StartDate | 3 | Да | ||
MP5J004 | NCHAR | STRING | 1 | 0 | 1 | Priority | 4 | Да | ||
MP5J005 | NCHAR | STRING | 10 | 0 | 10 | ReportNumber | 5 | Да | ||
MP5J006 | NCHAR | STRING | 10 | 0 | 10 | WONumber | ||||
MP5J007 | NCHAR | STRING | 3 | 0 | 3 | OperationNo | ||||
MP5J008 | NVARCHAR | VSTRING | 20 | 0 | 20 | OperatDescr | ||||
MP5J009 | NVARCHAR | VSTRING | 35 | 0 | 35 | StockCode | ||||
MP5J010 | NVARCHAR | VSTRING | 25 | 0 | 25 | SckCodeDesc1 | ||||
MP5J011 | NVARCHAR | VSTRING | 25 | 0 | 25 | SckCodeDesc2 | ||||
MP5J012 | NUMERIC | X_NUMERIC | 14 | 8 | 6 | PlSetupTime | ||||
MP5J013 | NUMERIC | X_NUMERIC | 17 | 8 | 9 | PlannRunTime | ||||
MP5J014 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | PlannedQty | ||||
MP5J015 | INT | INTEGER | 0 | 0 | 4 | UnitCode | ||||
MP5J016 | NCHAR | STRING | 10 | 0 | 10 | SalesOrderNo | ||||
MP5J017 | NCHAR | STRING | 6 | 0 | 6 | ORPosition | ||||
MP5J018 | NCHAR | STRING | 6 | 0 | 6 | ORStructPos | ||||
MP5J019 | NUMERIC | X_NUMERIC | 14 | 8 | 6 | ActSetupTime | ||||
MP5J020 | NUMERIC | X_NUMERIC | 17 | 8 | 9 | ActRunTime | ||||
MP5J021 | NUMERIC | X_NUMERIC | 14 | 8 | 6 | StopTime | ||||
MP5J022 | DATETIME | DATE | 0 | 0 | 8 | DueDate | ||||
MP5J023 | NVARCHAR | VSTRING | 15 | 0 | 15 | ToolNumber | ||||
MP5J024 | NVARCHAR | VSTRING | 30 | 0 | 30 | ToolDescription | ||||
MP5J025 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | ActualQty | ||||
MP5J026 | NVARCHAR | VSTRING | 10 | 0 | 10 | ScCodeUsrF1 | ||||
MP5J027 | NVARCHAR | VSTRING | 10 | 0 | 10 | ScCodeUsrF2 | ||||
MP5J028 | NVARCHAR | VSTRING | 8 | 0 | 8 | ScCodeUsrF3 | ||||
MP5J029 | NVARCHAR | VSTRING | 6 | 0 | 6 | ScCodeUsrF4 | ||||
MP5J030 | NVARCHAR | VSTRING | 4 | 0 | 4 | ScCodeUsrF5 | ||||
MP5J031 | NVARCHAR | VSTRING | 4 | 0 | 4 | ScCodeUsrF6 | ||||
MP5J032 | NVARCHAR | VSTRING | 2 | 0 | 2 | ScCodeUsrF7 | ||||
MP5J033 | INT | INTEGER | 0 | 0 | 2 | OperationStatus | ||||
MP5J034 | NVARCHAR | VSTRING | 10 | 0 | 10 | Person | ||||
MP5J035 | NVARCHAR | VSTRING | 35 | 0 | 35 | PhantomSckCode | ||||
MP5J036 | NVARCHAR | VSTRING | 25 | 0 | 25 | StckCodeDsc1 | ||||
MP5J037 | NVARCHAR | VSTRING | 25 | 0 | 25 | StckCodeDsc2 | ||||
MP5J038 | NVARCHAR | VSTRING | 25 | 0 | 25 | WOText1 | ||||
MP5J039 | NVARCHAR | VSTRING | 25 | 0 | 25 | WOText2 | ||||
MP5J040 | NVARCHAR | VSTRING | 25 | 0 | 25 | WOText3 | ||||
MP5J041 | NVARCHAR | VSTRING | 10 | 0 | 10 | SCUsrF1Phant | ||||
MP5J042 | NVARCHAR | VSTRING | 10 | 0 | 10 | SCUsrF2Phant | ||||
MP5J043 | NVARCHAR | VSTRING | 8 | 0 | 8 | SCUsrF3Phant | ||||
MP5J044 | NVARCHAR | VSTRING | 6 | 0 | 6 | SCUsrF4Phant | ||||
MP5J045 | NVARCHAR | VSTRING | 4 | 0 | 4 | SCUsrF5Phant | ||||
MP5J046 | NVARCHAR | VSTRING | 4 | 0 | 4 | SCUsrF6Phant | ||||
MP5J047 | NVARCHAR | VSTRING | 2 | 0 | 2 | SCUsrF7Phant | ||||
MP5J048 | NVARCHAR | VSTRING | 10 | 0 | 10 | CustomerNo | ||||
MP5J049 | INT | INTEGER | 0 | 0 | 6 | MatShortages | ||||
MP5J050 | NVARCHAR | VSTRING | 16 | 0 | 16 | EANCode | ||||
MP5J051 | NVARCHAR | VSTRING | 20 | 0 | 20 | DrawingNo | ||||
MP5J052 | NVARCHAR | VSTRING | 2 | 0 | 2 | ScCodeUsrF8 | ||||
MP5J053 | NVARCHAR | VSTRING | 2 | 0 | 2 | ScCodeUsrF9 | ||||
MP5J054 | NVARCHAR | VSTRING | 2 | 0 | 2 | ScCodeUsrF10 | ||||
MP5J055 | NVARCHAR | VSTRING | 2 | 0 | 2 | SCUsrF8Phant | ||||
MP5J056 | NVARCHAR | VSTRING | 2 | 0 | 2 | SCUsrF9Phant | ||||
MP5J057 | NVARCHAR | VSTRING | 2 | 0 | 2 | SCUsrF10Phant | ||||
MP5J058 | NCHAR | STRING | 6 | 0 | 6 | ProdWH |
Навигация: Структура БД iScala | Epicor iScala 2.3 SR1 - 2.03.8155 | Material Production Control | Wrk.Dispatching