One level Up / One level Up: Структура таблиц / Table structure Epicor iScala 3.2 (x64) — 3.2.0317 :: Список таблиц модуля «Управление Запасами»/List of tables of module «Stock Control»

Структура таблиц / Table structure Epicor iScala 3.2 (x64) — 3.2.0317 :: Таблица / Table SC14 — Price Calculations

Таблица / Table: SC14 — «Price Calculations». Маска имени таблицы / Table name mask: «SC14%cc00»

Поле / Field Тип поля / Field Type Тип поля Scala / iScala Field Type Длина поля / Field length Точность / Precision Длина Scala / 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)      

Навигация / Navigation: