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

Поле Тип поля Тип поля iScala Длина поля Точ­ность Длина iScala Комментарий Расширенный комментарий Дополнительное описание Пози­ция в инде­ксе Первич­ный ключ?
Field Field Type iScala Field Type Field Length Pre­cision 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		    

Навигация / Shortcut: Структура БД iScala / iScala DB structure | Epicor iScala 2.3 SR3 - 2.03.12787 | Stock Control | Stock Item Volume Discount Templates