Не забудьте посетить страницу «Наши услуги» и заказать интеграцию 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 Items Discounts» («Скидки на Станд.Поз.»)
Поле | Тип поля Scala | Длина Scala | Комментарий | Первичный ключ? |
SC38001 | STRING | 1 | RecordType | Да |
SC38002 | VSTRING | 45 | CstSupStkCd1 | Да |
SC38003 | VSTRING | 35 | CstSupStkCd2 | |
SC38004 | VSTRING | 25 | CustSuppDes1 | |
SC38005 | VSTRING | 25 | CustSuppDesc | |
SC38006 | VSTRING | 20 | Remark | |
SC38007 | VSTRING | 2 | CurrCode | |
SC38008 | MONEY | 20 | Price | |
SC38009 | X_NUMERIC | 6 | Discount | |
SC38010 | DATE | 8 | ValiFromDate | |
SC38011 | DATE | 8 | ValidToDate | |
SC38012 | VSTRING | 12 | ReOrderLevel | |
SC38013 | VSTRING | 3 | DelTimeWeeks | |
SC38014 | X_NUMERIC | 12 | OptimPurcQty | |
SC38015 | X_NUMERIC | 12 | DiscouLevel1 | |
SC38016 | X_NUMERIC | 6 | Discount1 | |
SC38017 | MONEY | 20 | PricDiscLev1 | |
SC38018 | X_NUMERIC | 12 | DiscouLevel2 | |
SC38019 | X_NUMERIC | 6 | Discount2 | |
SC38020 | MONEY | 20 | PricDiscLev2 | |
SC38021 | X_NUMERIC | 12 | DiscouLevel3 | |
SC38022 | X_NUMERIC | 6 | Discount3 | |
SC38023 | MONEY | 20 | PricDiscLev3 | |
SC38024 | X_NUMERIC | 12 | DiscouLevel4 | |
SC38025 | X_NUMERIC | 6 | Discount4 | |
SC38026 | MONEY | 20 | PricDiscLev4 | |
SC38027 | X_NUMERIC | 12 | DiscouLevel5 | |
SC38028 | X_NUMERIC | 6 | Discount5 | |
SC38029 | MONEY | 20 | PricDiscLev5 | |
SC38030 | X_NUMERIC | 12 | DiscouLevel6 | |
SC38031 | X_NUMERIC | 6 | Discount6 | |
SC38032 | MONEY | 20 | PricDiscLev6 | |
SC38033 | X_NUMERIC | 12 | DiscouLevel7 | |
SC38034 | X_NUMERIC | 6 | Discount7 | |
SC38035 | MONEY | 20 | PricDiscLev7 | |
SC38036 | X_NUMERIC | 12 | DiscouLevel8 | |
SC38037 | X_NUMERIC | 6 | Discount8 | |
SC38038 | MONEY | 20 | PricDiscLev8 | |
SC38039 | INTEGER | 1 | DelTimeUnit |
Навигация: Структура БД Scala/iScala | Scala 5.1 SR13 | Stock Control (Управление Запасами) | Standard Items Discounts (Скидки на Станд.Поз.)