Be sure to visit our Services page and order an Epicor Service Connect integration, SSRS report, or anything else... / Не забудьте посетить страницу «Наши услуги» и заказать интеграцию Epicor Service Connect, отчет SSRS или что-то еще...
Таблица: OR51 - «Packaging Material per Sales Order Line, history». Маска имени таблицы: «OR51%cc00»
Поле | Тип поля | Тип поля iScala | Длина поля | Точность | Длина iScala | Комментарий | Расширенный комментарий | Дополнительное описание | Позиция в индексе | Первичный ключ? |
OR51001 | NCHAR | STRING | 10 | 0 | 10 | OrderNumber | Order Number | 1 | Да | |
OR51002 | NCHAR | STRING | 6 | 0 | 6 | OrderLineNum | Order Line Number | 3 | Да | |
OR51003 | NCHAR | STRING | 6 | 0 | 6 | StructLineNum | Structure Line Number | 4 | Да | |
OR51004 | NVARCHAR | VSTRING | 5 | 0 | 5 | MaterialCode1 | Material Code 1 | |||
OR51005 | NUMERIC | X_NUMERIC | 18 | 8 | 10 | Weight1 | Weight 1 | |||
OR51006 | NVARCHAR | VSTRING | 5 | 0 | 5 | MaterialCode2 | Material Code 2 | |||
OR51007 | NUMERIC | X_NUMERIC | 18 | 8 | 10 | Weight2 | Weight 2 | |||
OR51008 | NVARCHAR | VSTRING | 5 | 0 | 5 | MaterialCode3 | Material Code 3 | |||
OR51009 | NUMERIC | X_NUMERIC | 18 | 8 | 10 | Weight3 | Weight 3 | |||
OR51010 | NVARCHAR | VSTRING | 5 | 0 | 5 | MaterialCode4 | Material Code 4 | |||
OR51011 | NUMERIC | X_NUMERIC | 18 | 8 | 10 | Weight4 | Weight 4 | |||
OR51012 | NVARCHAR | VSTRING | 5 | 0 | 5 | MaterialCode5 | Material Code 5 | |||
OR51013 | NUMERIC | X_NUMERIC | 18 | 8 | 10 | Weight5 | Weight 5 | |||
OR51014 | NVARCHAR | VSTRING | 5 | 0 | 5 | MaterialCode6 | Material Code 6 | |||
OR51015 | NUMERIC | X_NUMERIC | 18 | 8 | 10 | Weight6 | Weight 6 | |||
OR51016 | NVARCHAR | VSTRING | 5 | 0 | 5 | MaterialCode7 | Material Code 7 | |||
OR51017 | NUMERIC | X_NUMERIC | 18 | 8 | 10 | Weight7 | Weight 7 | |||
OR51018 | NVARCHAR | VSTRING | 5 | 0 | 5 | MaterialCode8 | Material Code 8 | |||
OR51019 | NUMERIC | X_NUMERIC | 18 | 8 | 10 | Weight8 | Weight 8 | |||
OR51020 | NVARCHAR | VSTRING | 5 | 0 | 5 | MaterialCode9 | Material Code 9 | |||
OR51021 | NUMERIC | X_NUMERIC | 18 | 8 | 10 | Weight9 | Weight 9 | |||
OR51022 | NVARCHAR | VSTRING | 5 | 0 | 5 | MaterialCode10 | Material Code 10 | |||
OR51023 | NUMERIC | X_NUMERIC | 18 | 8 | 10 | Weight10 | Weight 10 | |||
OR51024 | NVARCHAR | VSTRING | 5 | 0 | 5 | MaterialCode11 | Material Code 11 | |||
OR51025 | NUMERIC | X_NUMERIC | 18 | 8 | 10 | Weight11 | Weight 11 | |||
OR51026 | NVARCHAR | VSTRING | 5 | 0 | 5 | MaterialCode12 | Material Code 12 | |||
OR51027 | NUMERIC | X_NUMERIC | 18 | 8 | 10 | Weight12 | Weight 12 | |||
OR51028 | NVARCHAR | VSTRING | 5 | 0 | 5 | MaterialCode13 | Material Code 13 | |||
OR51029 | NUMERIC | X_NUMERIC | 18 | 8 | 10 | Weight13 | Weight 13 | |||
OR51030 | NVARCHAR | VSTRING | 5 | 0 | 5 | MaterialCode14 | Material Code 14 | |||
OR51031 | NUMERIC | X_NUMERIC | 18 | 8 | 10 | Weight14 | Weight 14 | |||
OR51032 | NVARCHAR | VSTRING | 5 | 0 | 5 | MaterialCode15 | Material Code 15 | |||
OR51033 | NUMERIC | X_NUMERIC | 18 | 8 | 10 | Weight15 | Weight 15 | |||
OR51034 | NVARCHAR | VSTRING | 5 | 0 | 5 | MaterialCode16 | Material Code 16 | |||
OR51035 | NUMERIC | X_NUMERIC | 18 | 8 | 10 | Weight16 | Weight 16 | |||
OR51036 | NVARCHAR | VSTRING | 5 | 0 | 5 | MaterialCode17 | Material Code 17 | |||
OR51037 | NUMERIC | X_NUMERIC | 18 | 8 | 10 | Weight17 | Weight 17 | |||
OR51038 | NVARCHAR | VSTRING | 5 | 0 | 5 | MaterialCode18 | Material Code 18 | |||
OR51039 | NUMERIC | X_NUMERIC | 18 | 8 | 10 | Weight18 | Weight 18 | |||
OR51040 | NVARCHAR | VSTRING | 5 | 0 | 5 | MaterialCode19 | Material Code 19 | |||
OR51041 | NUMERIC | X_NUMERIC | 18 | 8 | 10 | Weight19 | Weight 19 | |||
OR51042 | NVARCHAR | VSTRING | 5 | 0 | 5 | MaterialCode20 | Material Code 20 | |||
OR51043 | NUMERIC | X_NUMERIC | 18 | 8 | 10 | Weight20 | Weight 20 | |||
OR51044 | NCHAR | STRING | 15 | 0 | 15 | InvNumDummy | Invoice Number (dummy) | 2 | Да |
Навигация: Структура БД iScala | Epicor iScala 3.00 (x64) - 3.00.02254 | Sales Order | Packaging Material per Sales Order Line, history