На один уровень выше / 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 SCP5 — Discount per Stock Code

Таблица / Table: SCP5 — «Discount per Stock Code». Маска имени таблицы / Table name mask: «SCP5%cc00»

Поле / Field Тип поля / Field Type Тип поля Scala / iScala Field Type Длина поля / Field length Точность / Precision Длина Scala / iScala length Комментарий / Comment Расширенный комментарий / Extended comment Дополнительное описание / Additional description Позиция в индексе / Index position Первичный ключ? / Is Primary key?
SCP5001 NVARCHAR VSTRING 35 0 35 StockCode Stock Code   1 Да / Yes
SCP5002 NUMERIC X_NUMERIC 20 8 12 DiscountLevel1Quantity Discount Level 1, Quantity      
SCP5003 NUMERIC X_NUMERIC 14 8 6 DiscountLevel1Discount Discount Level 1, Discount      
SCP5004 NUMERIC X_NUMERIC 28 8 20 DiscountLevel1Price Discount Level 1, Price      
SCP5005 NUMERIC X_NUMERIC 20 8 12 DiscountLevel2Quantity Discount Level 2, Quantity      
SCP5006 NUMERIC X_NUMERIC 14 8 6 DiscountLevel2Discount Discount Level 2, Discount      
SCP5007 NUMERIC X_NUMERIC 28 8 20 DiscountLevel2Price Discount Level 2, Price      
SCP5008 NUMERIC X_NUMERIC 20 8 12 DiscountLevel3Quantity Discount Level 3, Quantity      
SCP5009 NUMERIC X_NUMERIC 14 8 6 DiscountLevel3Discount Discount Level 3, Discount      
SCP5010 NUMERIC X_NUMERIC 28 8 20 DiscountLevel3Price Discount Level 3, Price      
SCP5011 NUMERIC X_NUMERIC 20 8 12 DiscountLevel4Quantity Discount Level 4, Quantity      
SCP5012 NUMERIC X_NUMERIC 14 8 6 DiscountLevel4Discount Discount Level 4, Discount      
SCP5013 NUMERIC X_NUMERIC 28 8 20 DiscountLevel4Price Discount Level 4, Price      
SCP5014 NUMERIC X_NUMERIC 20 8 12 DiscountLevel5Quantity Discount Level 5, Quantity      
SCP5015 NUMERIC X_NUMERIC 14 8 6 DiscountLevel5Discount Discount Level 5, Discount      
SCP5016 NUMERIC X_NUMERIC 28 8 20 DiscountLevel5Price Discount Level 5, Price      
SCP5017 NUMERIC X_NUMERIC 20 8 12 DiscountLevel6Quantity Discount Level 6, Quantity      
SCP5018 NUMERIC X_NUMERIC 14 8 6 DiscountLevel6Discount Discount Level 6, Discount      
SCP5019 NUMERIC X_NUMERIC 28 8 20 DiscountLevel6Price Discount Level 6, Price      
SCP5020 NUMERIC X_NUMERIC 20 8 12 DiscountLevel7Quantity Discount Level 7, Quantity      
SCP5021 NUMERIC X_NUMERIC 14 8 6 DiscountLevel7Discount Discount Level 7, Discount      
SCP5022 NUMERIC X_NUMERIC 28 8 20 DiscountLevel7Price Discount Level 7, Price      
SCP5023 NUMERIC X_NUMERIC 20 8 12 DiscountLevel8Quantity Discount Level 8, Quantity      
SCP5024 NUMERIC X_NUMERIC 14 8 6 DiscountLevel8Discount Discount Level 8, Discount      
SCP5025 NUMERIC X_NUMERIC 28 8 20 DiscountLevel8Price Discount Level 8, Price      

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