Не забудьте посетить страницу «Наши услуги» и заказать интеграцию Epicor Service Connect, отчет SSRS или что-то еще... / Be sure to visit our Services page and order an Epicor Service Connect integration, SSRS report, or anything else...
Таблица: 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 |
Навигация: Структура БД iScala | iScala 2.2 HF 2.3318 - 2.02.3318 | Stock Control | Stock Item Volume Discount Templates