Таблица: SC18 - «Supplier/Customer Prices». Маска имени таблицы: «SC18%cc00»

Поле Тип поля Тип поля Scala Длина поля Точ­ность Длина Scala Комментарий Расширенный комментарий Дополнительное описание Пози­ция в инде­ксе Первич­ный ключ?
SC18001 NCHAR STRING 1 0 1 RecordType Record Type B - Supplier prices
C - Customer prices (customer sort order)
D - Customer price (stock item sort order)
E - Stock item volume discounts
1 Да
SC18002 NVARCHAR VSTRING 45 0 45 CusSupStCod1 Stock Item Code/Customer/Supplier Code   2 Да
SC18003 NVARCHAR VSTRING 35 0 35 CusSupStCod2 Customer/Supplier Stock Item Code      
SC18004 NVARCHAR VSTRING 25 0 25 CustSuppDes1 Description Line 1      
SC18005 NVARCHAR VSTRING 25 0 25 CustSuppDes2 Description Line 2      
SC18006 NVARCHAR VSTRING 20 0 20 Remark Remark      
SC18007 NVARCHAR VSTRING 2 0 2 CurrCode Currency Code Price      
SC18008 NUMERIC MONEY 28 8 20 Price Unit Price      
SC18009 NVARCHAR VSTRING 6 0 6 Discount Discount %      
SC18010 DATETIME DATE 0 0 8 ValidFromDat Date to Activate Discount      
SC18011 DATETIME DATE 0 0 8 ValidToDate Date to Deactivate Discount      
SC18012 NUMERIC X_NUMERIC 20 8 12 ReOrderLevel Re-order Level      
SC18013 INT INTEGER 0 0 3 DelTimeWeeks Delivery Time      
SC18014 NUMERIC X_NUMERIC 20 8 12 OptimPurcQty Optimal Purchase Quantity      
SC18015 NUMERIC X_NUMERIC 20 8 12 DiscouLevel1 Volume Discount 01 - From Quantity      
SC18016 NUMERIC X_NUMERIC 14 8 6 Discount1 Volume Discount 01 - Discount %      
SC18017 NUMERIC MONEY 28 8 20 PricDiscLev1 Volume Discount 01 - Price      
SC18018 NUMERIC X_NUMERIC 20 8 12 DiscouLevel2 Volume Discount 02 - From Quantity      
SC18019 NUMERIC X_NUMERIC 14 8 6 Discount2 Volume Discount 02 - Discount %      
SC18020 NUMERIC MONEY 28 8 20 PricDiscLev2 Volume Discount 02 - Price      
SC18021 NUMERIC X_NUMERIC 20 8 12 DiscouLevel3 Volume Discount 03 - From Quantity      
SC18022 NUMERIC X_NUMERIC 14 8 6 Discount3 Volume Discount 03 - Discount %      
SC18023 NUMERIC MONEY 28 8 20 PricDiscLev3 Volume Discount 03 - Price      
SC18024 NUMERIC X_NUMERIC 20 8 12 DiscountLev4 Volume Discount 04 - From Quantity      
SC18025 NUMERIC X_NUMERIC 14 8 6 Discount4 Volume Discount 04 - Discount %      
SC18026 NUMERIC MONEY 28 8 20 PricDiscLev4 Volume Discount 04 - Price      
SC18027 NUMERIC X_NUMERIC 20 8 12 DiscountLev5 Volume Discount 05 - From Quantity      
SC18028 NUMERIC X_NUMERIC 14 8 6 Discount5 Volume Discount 05 - Discount %      
SC18029 NUMERIC MONEY 28 8 20 PricDiscLev5 Volume Discount 05 - Price      
SC18030 NUMERIC X_NUMERIC 20 8 12 DiscountLev6 Volume Discount 06 - From Quantity      
SC18031 NUMERIC X_NUMERIC 14 8 6 Discount6 Volume Discount 06 - Discount %      
SC18032 NUMERIC MONEY 28 8 20 PricDiscLev6 Volume Discount 06 - Price      
SC18033 NUMERIC X_NUMERIC 20 8 12 DiscountLev7 Volume Discount 07 - From Quantity      
SC18034 NUMERIC X_NUMERIC 14 8 6 Discount7 Volume Discount 07 - Discount %      
SC18035 NUMERIC MONEY 28 8 20 PricDiscLev7 Volume Discount 07 - Price      
SC18036 NUMERIC X_NUMERIC 20 8 12 DiscountLev8 Volume Discount 08 - From Quantity      
SC18037 NUMERIC X_NUMERIC 14 8 6 Discount8 Volume Discount 08 - Discount %      
SC18038 NUMERIC MONEY 28 8 20 PricDiscLev8 Volume Discount 08 - Price      
SC18039 INT INTEGER 0 0 1 DelTimeUnit Delivery Time Unit 2 - Days
3 - Weeks
4 - Month
5 - Years
   
SC18040 NUMERIC X_NUMERIC 18 8 10 SupplPriceMult Supplier Price Multiplier      

Навигация: Структура БД iScala | Epicor iScala 2.3 - 2.03.3363 | Stock Control | Supplier/Customer Prices