One level Up / One level Up: Структура таблиц Epicor iScala 3.0 FSP4 — 3.0.4267 :: Список таблиц модуля «Stock Control»

Структура таблиц Epicor iScala 3.0 FSP4 — 3.0.4267 :: Таблица SC38 — Stock Item Volume Discount Templates

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

Поле Тип поля Тип поля Scala Длина поля Точ­ность Длина Scala Комментарий Расширенный комментарий Дополнительное описание Пози­ция в инде­ксе Первич­ный ключ?
SC38001 NCHAR STRING 1 0 1 RecordType Record Type (Always E)   1 Да
SC38002 NVARCHAR VSTRING 45 0 45 CstSupStkCd1 Stock Item Template Code   2 Да
SC38003 NVARCHAR VSTRING 35 0 35 CstSupStkCd2 Customer/Supplier Stock Item Code      
SC38004 NVARCHAR VSTRING 25 0 25 CustSuppDes1 Description Line 1      
SC38005 NVARCHAR VSTRING 25 0 25 CustSuppDesc Description Line 2      
SC38006 NVARCHAR VSTRING 20 0 20 Remark Remark      
SC38007 NVARCHAR VSTRING 2 0 2 CurrCode Currency Code Price      
SC38008 NUMERIC MONEY 28 8 20 Price Unit Price      
SC38009 NUMERIC X_NUMERIC 14 8 6 Discount Discount %      
SC38010 DATETIME DATE 0 0 8 ValiFromDate Date to Activate Discount      
SC38011 DATETIME DATE 0 0 8 ValidToDate Date to Deactivate Discount      
SC38012 NVARCHAR VSTRING 12 0 12 ReOrderLevel Re-order Level      
SC38013 NVARCHAR VSTRING 3 0 3 DelTimeWeeks Delivery Time      
SC38014 NUMERIC X_NUMERIC 20 8 12 OptimPurcQty Optimal Purchase Quantity      
SC38015 NUMERIC X_NUMERIC 20 8 12 DiscouLevel1 Volume Discount 01 — From Quantity      
SC38016 NUMERIC X_NUMERIC 14 8 6 Discount1 Volume Discount 01 — Discount %      
SC38017 NUMERIC MONEY 28 8 20 PricDiscLev1 Volume Discount 01 — Price      
SC38018 NUMERIC X_NUMERIC 20 8 12 DiscouLevel2 Volume Discount 02 — From Quantity      
SC38019 NUMERIC X_NUMERIC 14 8 6 Discount2 Volume Discount 02 — Discount %      
SC38020 NUMERIC MONEY 28 8 20 PricDiscLev2 Volume Discount 02 — Price      
SC38021 NUMERIC X_NUMERIC 20 8 12 DiscouLevel3 Volume Discount 03 — From Quantity      
SC38022 NUMERIC X_NUMERIC 14 8 6 Discount3 Volume Discount 03 — Discount %      
SC38023 NUMERIC MONEY 28 8 20 PricDiscLev3 Volume Discount 03 — Price      
SC38024 NUMERIC X_NUMERIC 20 8 12 DiscouLevel4 Volume Discount 04 — From Quantity      
SC38025 NUMERIC X_NUMERIC 14 8 6 Discount4 Volume Discount 04 — Discount %      
SC38026 NUMERIC MONEY 28 8 20 PricDiscLev4 Volume Discount 04 — Price      
SC38027 NUMERIC X_NUMERIC 20 8 12 DiscouLevel5 Volume Discount 05 — From Quantity      
SC38028 NUMERIC X_NUMERIC 14 8 6 Discount5 Volume Discount 05 — Discount %      
SC38029 NUMERIC MONEY 28 8 20 PricDiscLev5 Volume Discount 05 — Price      
SC38030 NUMERIC X_NUMERIC 20 8 12 DiscouLevel6 Volume Discount 06 — From Quantity      
SC38031 NUMERIC X_NUMERIC 14 8 6 Discount6 Volume Discount 06 — Discount %      
SC38032 NUMERIC MONEY 28 8 20 PricDiscLev6 Volume Discount 06 — Price      
SC38033 NUMERIC X_NUMERIC 20 8 12 DiscouLevel7 Volume Discount 07 — From Quantity      
SC38034 NUMERIC X_NUMERIC 14 8 6 Discount7 Volume Discount 07 — Discount %      
SC38035 NUMERIC MONEY 28 8 20 PricDiscLev7 Volume Discount 07 — Price      
SC38036 NUMERIC X_NUMERIC 20 8 12 DiscouLevel8 Volume Discount 08 — From Quantity      
SC38037 NUMERIC X_NUMERIC 14 8 6 Discount8 Volume Discount 08 — Discount %      
SC38038 NUMERIC MONEY 28 8 20 PricDiscLev8 Volume Discount 08 — Price      
SC38039 INT INTEGER 0 0 1 DelTimeUnit Delivery Time Unit 2 — Days
3 — Weeks
4 — Month
5 — Years
   

Навигация: