Таблица: SC14 - «Price Calculations». Маска имени таблицы: «SC14%cc00»
Поле | Тип поля | Тип поля Scala | Длина поля | Точность | Длина Scala | Комментарий | Расширенный комментарий | Дополнительное описание | Позиция в индексе | Первичный ключ? |
SC14001 | NVARCHAR | VSTRING | 35 | 0 | 35 | StockCode | Stock Item Code | 1 | Да | |
SC14002 | NVARCHAR | VSTRING | 2 | 0 | 2 | FromPrcLstNo | From Price List | For sales price calculations this field defines the minimum value in the interval of price lists to include in the price calculation. For cost calculations this field is always 'X_' | 2 | Да |
SC14003 | NVARCHAR | VSTRING | 2 | 0 | 2 | ToPrcLstNo | To Price List | For sales price calculations this field defines the maximum value in the interval of price lists to include in the price calculation. For cost calculations this field is always 'X_' | ||
SC14004 | NVARCHAR | VSTRING | 3 | 0 | 3 | Basis0 | Calculation Line 0 - Base Value | |||
SC14005 | NVARCHAR | VSTRING | 12 | 0 | 12 | Constant0 | Calculation Line 0 - Constant | |||
SC14006 | NVARCHAR | VSTRING | 3 | 0 | 3 | Basis1 | Calculation Line 1 - Base Value | |||
SC14007 | NVARCHAR | VSTRING | 12 | 0 | 12 | Constant1 | Calculation Line 1 - Constant | |||
SC14008 | NVARCHAR | VSTRING | 3 | 0 | 3 | Basis2 | Calculation Line 2 - Base Value | |||
SC14009 | NVARCHAR | VSTRING | 12 | 0 | 12 | Constant2 | Calculation Line 2 - Constant | |||
SC14010 | NVARCHAR | VSTRING | 3 | 0 | 3 | Basis3 | Calculation Line 3 - Base Value | |||
SC14011 | NVARCHAR | VSTRING | 12 | 0 | 12 | Constant3 | Calculation Line 3 - Constant | |||
SC14012 | NVARCHAR | VSTRING | 3 | 0 | 3 | Basis4 | Calculation Line 4 - Base Value | |||
SC14013 | NVARCHAR | VSTRING | 12 | 0 | 12 | Constan4 | Calculation Line 4 - Constant | |||
SC14014 | NVARCHAR | VSTRING | 3 | 0 | 3 | Basis5 | Calculation Line 5 - Base Value | |||
SC14015 | NVARCHAR | VSTRING | 12 | 0 | 12 | Constant5 | Calculation Line 5 - Constant | |||
SC14016 | NVARCHAR | VSTRING | 3 | 0 | 3 | Basis6 | Calculation Line 6 - Base Value | |||
SC14017 | NVARCHAR | VSTRING | 12 | 0 | 12 | Constant6 | Calculation Line 6 - Constant | |||
SC14018 | NVARCHAR | VSTRING | 3 | 0 | 3 | Basis7 | Calculation Line 7 - Base Value | |||
SC14019 | NVARCHAR | VSTRING | 12 | 0 | 12 | Constant7 | Calculation Line 7 - Constant | |||
SC14020 | NVARCHAR | VSTRING | 3 | 0 | 3 | Basis8 | Calculation Line 8 - Base Value | |||
SC14021 | NVARCHAR | VSTRING | 12 | 0 | 12 | Constant8 | Calculation Line 8 - Constant | |||
SC14022 | NVARCHAR | VSTRING | 3 | 0 | 3 | Basis9 | Calculation Line 9 - Base Value | |||
SC14023 | NVARCHAR | VSTRING | 12 | 0 | 12 | Constant9 | Calculation Line 9 - Constant | |||
SC14024 | INT | INTEGER | 0 | 0 | 1 | ModelNo16 | Calculation Model (1-6) |
Навигация: Структура БД iScala | Epicor iScala 2.3 - 2.03.3363 | Stock Control | Price Calculations