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

Структура таблиц / Table structure Epicor iScala 3.3 (x64) — 3.3.0419 :: Таблица / Table SC38 — Stock Item Volume Discount Templates

Таблица / Table: SC38 — «Standard Item Discounts». Маска имени таблицы / Table name mask: «SC38%cc00»

Поле / Field Тип поля / Field Type Тип поля Scala / iScala Field Type Длина поля / Field length Точность / Precision Длина Scala / iScala length Комментарий / Comment Расширенный комментарий / Extended comment Дополнительное описание / Additional description Позиция в индексе / Index position Первичный ключ? / Is Primary key?
SC38001 NVARCHAR VSTRING 35 0 35 StockCode Stock Code   1 Да / Yes
SC38002 NUMERIC X_NUMERIC 20 8 12 DiscountLevel1Quantity Discount Level 1, Quantity      
SC38003 NUMERIC X_NUMERIC 14 8 6 DiscountLevel1Discount Discount Level 1, Discount      
SC38004 NUMERIC MONEY 28 8 20 DiscountLevel1Price Discount Level 1, Price      
SC38005 NUMERIC X_NUMERIC 20 8 12 DiscountLevel2Quantity Discount Level 2, Quantity      
SC38006 NUMERIC X_NUMERIC 14 8 6 DiscountLevel2Discount Discount Level 2, Discount      
SC38007 NUMERIC MONEY 28 8 20 DiscountLevel2Price Discount Level 2, Price      
SC38008 NUMERIC X_NUMERIC 20 8 12 DiscountLevel3Quantity Discount Level 3, Quantity      
SC38009 NUMERIC X_NUMERIC 14 8 6 DiscountLevel3Discount Discount Level 3, Discount      
SC38010 NUMERIC MONEY 28 8 20 DiscountLevel3Price Discount Level 3, Price      
SC38011 NUMERIC X_NUMERIC 20 8 12 DiscountLevel4Quantity Discount Level 4, Quantity      
SC38012 NUMERIC X_NUMERIC 14 8 6 DiscountLevel4Discount Discount Level 4, Discount      
SC38013 NUMERIC MONEY 28 8 20 DiscountLevel4Price Discount Level 4, Price      
SC38014 NUMERIC X_NUMERIC 20 8 12 DiscountLevel5Quantity Discount Level 5, Quantity      
SC38015 NUMERIC X_NUMERIC 14 8 6 DiscountLevel5Discount Discount Level 5, Discount      
SC38016 NUMERIC MONEY 28 8 20 DiscountLevel5Price Discount Level 5, Price      
SC38017 NUMERIC X_NUMERIC 20 8 12 DiscountLevel6Quantity Discount Level 6, Quantity      
SC38018 NUMERIC X_NUMERIC 14 8 6 DiscountLevel6Discount Discount Level 6, Discount      
SC38019 NUMERIC MONEY 28 8 20 DiscountLevel6Price Discount Level 6, Price      
SC38020 NUMERIC X_NUMERIC 20 8 12 DiscountLevel7Quantity Discount Level 7, Quantity      
SC38021 NUMERIC X_NUMERIC 14 8 6 DiscountLevel7Discount Discount Level 7, Discount      
SC38022 NUMERIC MONEY 28 8 20 DiscountLevel7Price Discount Level 7, Price      
SC38023 NUMERIC X_NUMERIC 20 8 12 DiscountLevel8Quantity Discount Level 8, Quantity      
SC38024 NUMERIC X_NUMERIC 14 8 6 DiscountLevel8Discount Discount Level 8, Discount      
SC38025 NUMERIC MONEY 28 8 20 DiscountLevel8Price Discount Level 8, Price      

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