Be sure to visit our Services page and order an Epicor Service Connect integration, SSRS report, or anything else... / Не забудьте посетить страницу «Наши услуги» и заказать интеграцию Epicor Service Connect, отчет SSRS или что-то еще...
Таблица | Table: SC14 - «Price Calculations». Маска имени таблицы | Table Name Mask: «SC14%cc00»
Поле | Тип поля | Тип поля iScala | Длина поля | Точность | Длина iScala | Комментарий | Расширенный комментарий | Дополнительное описание | Позиция в индексе | Первичный ключ? |
Field | Field Type | iScala Field Type | Field Length | Precision | iScala Length | Comment | Extended Comment | Additional Description | Index Position | Is Primary key? |
SC14001 | NVARCHAR | VSTRING | 35 | 0 | 35 | StockCode | Stock Item Code | 1 | Да / Yes | |
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 | Да / Yes |
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) |
Навигация / Shortcut: Структура БД iScala / iScala DB structure | Epicor iScala 2.3 SR3 - 2.03.12787 | Stock Control | Price Calculations