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