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

Структура таблиц / Table structure Epicor iScala 3.4 (x64) — 3.4.0399 :: Таблица / Table SCP7 — Price and Discount per Stock code — Supplier

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

Поле / Field Тип поля / Field Type Тип поля Scala / iScala Field Type Длина поля / Field length Точность / Precision Длина Scala / iScala length Комментарий / Comment Расширенный комментарий / Extended comment Дополнительное описание / Additional description Позиция в индексе / Index position Первичный ключ? / Is Primary key?
SCP7001 NVARCHAR VSTRING 35 0 35 StockCode Stock Code   1 Да / Yes
SCP7002 NVARCHAR VSTRING 10 0 10 SupplierCode Supplier Code   2 Да / Yes
SCP7003 NVARCHAR VSTRING 35 0 35 SupplierStockCode Supplier Stock Code      
SCP7004 NVARCHAR VSTRING 25 0 25 SupplierDescription1 Supplier Description 1      
SCP7005 NVARCHAR VSTRING 25 0 25 SupplierDescription2 Supplier Description 2      
SCP7006 NVARCHAR VSTRING 20 0 20 Remark Remark      
SCP7007 INT INTEGER 0 0 2 CurrencyCode Currency Code      
SCP7008 NUMERIC X_NUMERIC 28 8 20 Price Price      
SCP7009 NUMERIC X_NUMERIC 14 8 6 Discount Discount      
SCP7010 DATETIME DATE 0 0 8 ValidfromDate Valid from Date      
SCP7011 DATETIME DATE 0 0 8 ValidtoDate Valid to Date      
SCP7012 NUMERIC X_NUMERIC 20 8 12 ReOrderLevel Re-Order Level      
SCP7013 INT INTEGER 0 0 3 DeliveryTime Delivery Time      
SCP7014 NUMERIC X_NUMERIC 20 8 12 OptimalPurchaseQuantity Optimal Purchase Quantity      
SCP7015 NUMERIC X_NUMERIC 20 8 12 DiscountLevel1Quantity Discount Level 1, Quantity      
SCP7016 NUMERIC X_NUMERIC 14 8 6 DiscountLevel1Discount Discount Level 1, Discount      
SCP7017 NUMERIC X_NUMERIC 28 8 20 DiscountLevel1Price Discount Level 1, Price      
SCP7018 NUMERIC X_NUMERIC 20 8 12 DiscountLevel2Quantity Discount Level 2, Quantity      
SCP7019 NUMERIC X_NUMERIC 14 8 6 DiscountLevel2Discount Discount Level 2, Discount      
SCP7020 NUMERIC X_NUMERIC 28 8 20 DiscountLevel2Price Discount Level 2, Price      
SCP7021 NUMERIC X_NUMERIC 20 8 12 DiscountLevel3Quantity Discount Level 3, Quantity      
SCP7022 NUMERIC X_NUMERIC 14 8 6 DiscountLevel3Discount Discount Level 3, Discount      
SCP7023 NUMERIC X_NUMERIC 28 8 20 DiscountLevel3Price Discount Level 3, Price      
SCP7024 NUMERIC X_NUMERIC 20 8 12 DiscountLevel4Quantity Discount Level 4, Quantity      
SCP7025 NUMERIC X_NUMERIC 14 8 6 DiscountLevel4Discount Discount Level 4, Discount      
SCP7026 NUMERIC X_NUMERIC 28 8 20 DiscountLevel4Price Discount Level 4, Price      
SCP7027 NUMERIC X_NUMERIC 20 8 12 DiscountLevel5Quantity Discount Level 5, Quantity      
SCP7028 NUMERIC X_NUMERIC 14 8 6 DiscountLevel5Discount Discount Level 5, Discount      
SCP7029 NUMERIC X_NUMERIC 28 8 20 DiscountLevel5Price Discount Level 5, Price      
SCP7030 NUMERIC X_NUMERIC 20 8 12 DiscountLevel6Quantity Discount Level 6, Quantity      
SCP7031 NUMERIC X_NUMERIC 14 8 6 DiscountLevel6Discount Discount Level 6, Discount      
SCP7032 NUMERIC X_NUMERIC 28 8 20 DiscountLevel6Price Discount Level 6, Price      
SCP7033 NUMERIC X_NUMERIC 20 8 12 DiscountLevel7Quantity Discount Level 7, Quantity      
SCP7034 NUMERIC X_NUMERIC 14 8 6 DiscountLevel7Discount Discount Level 7, Discount      
SCP7035 NUMERIC X_NUMERIC 28 8 20 DiscountLevel7Price Discount Level 7, Price      
SCP7036 NUMERIC X_NUMERIC 20 8 12 DiscountLevel8Quantity Discount Level 8, Quantity      
SCP7037 NUMERIC X_NUMERIC 14 8 6 DiscountLevel8Discount Discount Level 8, Discount      
SCP7038 NUMERIC X_NUMERIC 28 8 20 DiscountLevel8Price Discount Level 8, Price      
SCP7039 INT INTEGER 0 0 1 DeliveryTimeUnit Delivery Time Unit      
SCP7040 NUMERIC X_NUMERIC 18 8 10 PriceMultiple Price Multiple      
SCP7041 NUMERIC X_NUMERIC 20 8 12 MultipleforMRPSRPandMPS Multiple for MRP, SRP and MPS      

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