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

Структура таблиц / Table structure Epicor iScala 3.2 (x64) — 3.2.0317 :: Таблица / 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 NCHAR STRING 1 0 1 RecordType Record Type (Always E)   1 Да / Yes
SC38002 NVARCHAR VSTRING 45 0 45 CstSupStkCd1 Stock Item Template Code   2 Да / Yes
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
   

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