На один уровень выше / 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 SCP6 — Price and Discount per Stock code — Customer

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

Поле / Field Тип поля / Field Type Тип поля Scala / iScala Field Type Длина поля / Field length Точность / Precision Длина Scala / iScala length Комментарий / Comment Расширенный комментарий / Extended comment Дополнительное описание / Additional description Позиция в индексе / Index position Первичный ключ? / Is Primary key?
SCP6001 NVARCHAR VSTRING 35 0 35 StockCode Stock Code   1 Да / Yes
SCP6002 NVARCHAR VSTRING 10 0 10 CustomerCode Customer Code   2 Да / Yes
SCP6003 NVARCHAR VSTRING 35 0 35 CustomerStockCode Customer Stock Code      
SCP6004 NVARCHAR VSTRING 25 0 25 CustomerDescription1 Customer Description 1      
SCP6005 NVARCHAR VSTRING 25 0 25 CustomerDescription2 Customer Description 2      
SCP6006 NVARCHAR VSTRING 20 0 20 Remark Remark      
SCP6007 INT INTEGER 0 0 2 CurrencyCode Currency Code      
SCP6008 NUMERIC X_NUMERIC 28 8 20 Price Price      
SCP6009 NUMERIC X_NUMERIC 14 8 6 Discount Discount      
SCP6010 DATETIME DATE 0 0 8 ValidfromDate Valid from Date      
SCP6011 DATETIME DATE 0 0 8 ValidtoDate Valid to Date      
SCP6012 NUMERIC X_NUMERIC 20 8 12 YearlyBudget Yearly Budget      
SCP6013 INT INTEGER 0 0 1 BudgetProfile Budget Profile      
SCP6014 NVARCHAR VSTRING 10 0 10 Spare Spare      
SCP6015 NUMERIC X_NUMERIC 20 8 12 DiscountLevel1Quantity Discount Level 1, Quantity      
SCP6016 NUMERIC X_NUMERIC 14 8 6 DiscountLevel1Discount Discount Level 1, Discount      
SCP6017 NUMERIC X_NUMERIC 28 8 20 DiscountLevel1Price Discount Level 1, Price      
SCP6018 NUMERIC X_NUMERIC 20 8 12 DiscountLevel2Quantity Discount Level 2, Quantity      
SCP6019 NUMERIC X_NUMERIC 14 8 6 DiscountLevel2Discount Discount Level 2, Discount      
SCP6020 NUMERIC X_NUMERIC 28 8 20 DiscountLevel2Price Discount Level 2, Price      
SCP6021 NUMERIC X_NUMERIC 20 8 12 DiscountLevel3Quantity Discount Level 3, Quantity      
SCP6022 NUMERIC X_NUMERIC 14 8 6 DiscountLevel3Discount Discount Level 3, Discount      
SCP6023 NUMERIC X_NUMERIC 28 8 20 DiscountLevel3Price Discount Level 3, Price      
SCP6024 NUMERIC X_NUMERIC 20 8 12 DiscountLevel4Quantity Discount Level 4, Quantity      
SCP6025 NUMERIC X_NUMERIC 14 8 6 DiscountLevel4Discount Discount Level 4, Discount      
SCP6026 NUMERIC X_NUMERIC 28 8 20 DiscountLevel4Price Discount Level 4, Price      
SCP6027 NUMERIC X_NUMERIC 20 8 12 DiscountLevel5Quantity Discount Level 5, Quantity      
SCP6028 NUMERIC X_NUMERIC 14 8 6 DiscountLevel5Discount Discount Level 5, Discount      
SCP6029 NUMERIC X_NUMERIC 28 8 20 DiscountLevel5Price Discount Level 5, Price      
SCP6030 NUMERIC X_NUMERIC 20 8 12 DiscountLevel6Quantity Discount Level 6, Quantity      
SCP6031 NUMERIC X_NUMERIC 14 8 6 DiscountLevel6Discount Discount Level 6, Discount      
SCP6032 NUMERIC X_NUMERIC 28 8 20 DiscountLevel6Price Discount Level 6, Price      
SCP6033 NUMERIC X_NUMERIC 20 8 12 DiscountLevel7Quantity Discount Level 7, Quantity      
SCP6034 NUMERIC X_NUMERIC 14 8 6 DiscountLevel7Discount Discount Level 7, Discount      
SCP6035 NUMERIC X_NUMERIC 28 8 20 DiscountLevel7Price Discount Level 7, Price      
SCP6036 NUMERIC X_NUMERIC 20 8 12 DiscountLevel8Quantity Discount Level 8, Quantity      
SCP6037 NUMERIC X_NUMERIC 14 8 6 DiscountLevel8Discount Discount Level 8, Discount      
SCP6038 NUMERIC X_NUMERIC 28 8 20 DiscountLevel8Price Discount Level 8, Price      

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