Не забудьте посетить страницу «Наши услуги» и заказать интеграцию Epicor Service Connect, отчет SSRS или что-то еще... / Be sure to visit our Services page and order an Epicor Service Connect integration, SSRS report, or anything else...
Таблица: SC18 - «Supplier Prices» («Цены Поставщика»)
| Поле | Тип поля Scala | Длина Scala | Комментарий | Первичный ключ? |
| SC18001 | STRING | 1 | RecordType | Да |
| SC18002 | VSTRING | 45 | CusSupStCod1 | Да |
| SC18003 | VSTRING | 35 | CusSupStCod2 | |
| SC18004 | VSTRING | 25 | CustSuppDes1 | |
| SC18005 | VSTRING | 25 | CustSuppDes2 | |
| SC18006 | VSTRING | 20 | Remark | |
| SC18007 | VSTRING | 2 | CurrCode | |
| SC18008 | MONEY | 20 | Price | |
| SC18009 | VSTRING | 6 | Discount | |
| SC18010 | DATE | 8 | ValidFromDat | |
| SC18011 | DATE | 8 | ValidToDate | |
| SC18012 | X_NUMERIC | 12 | ReOrderLevel | |
| SC18013 | INTEGER | 3 | DelTimeWeeks | |
| SC18014 | X_NUMERIC | 12 | OptimPurcQty | |
| SC18015 | X_NUMERIC | 12 | DiscouLevel1 | |
| SC18016 | X_NUMERIC | 6 | Discount1 | |
| SC18017 | MONEY | 20 | PricDiscLev1 | |
| SC18018 | X_NUMERIC | 12 | DiscouLevel2 | |
| SC18019 | X_NUMERIC | 6 | Discount2 | |
| SC18020 | MONEY | 20 | PricDiscLev2 | |
| SC18021 | X_NUMERIC | 12 | DiscouLevel3 | |
| SC18022 | X_NUMERIC | 6 | Discount3 | |
| SC18023 | MONEY | 20 | PricDiscLev3 | |
| SC18024 | X_NUMERIC | 12 | DiscountLev4 | |
| SC18025 | X_NUMERIC | 6 | Discount4 | |
| SC18026 | MONEY | 20 | PricDiscLev4 | |
| SC18027 | X_NUMERIC | 12 | DiscountLev5 | |
| SC18028 | X_NUMERIC | 6 | Discount5 | |
| SC18029 | MONEY | 20 | PricDiscLev5 | |
| SC18030 | X_NUMERIC | 12 | DiscountLev6 | |
| SC18031 | X_NUMERIC | 6 | Discount6 | |
| SC18032 | MONEY | 20 | PricDiscLev6 | |
| SC18033 | X_NUMERIC | 12 | DiscountLev7 | |
| SC18034 | X_NUMERIC | 6 | Discount7 | |
| SC18035 | MONEY | 20 | PricDiscLev7 | |
| SC18036 | X_NUMERIC | 12 | DiscountLev8 | |
| SC18037 | X_NUMERIC | 6 | Discount8 | |
| SC18038 | MONEY | 20 | PricDiscLev8 | |
| SC18039 | INTEGER | 1 | DelTimeUnit | |
| SC18040 | X_NUMERIC | 10 | SupplPriceMult |
Навигация: Структура БД Scala/iScala | Scala 5.1 SR13 | Stock Control (Управление Запасами) | Supplier Prices (Цены Поставщика)
/* */