Не забудьте посетить страницу «Наши услуги» и заказать интеграцию Epicor Service Connect, отчет SSRS или что-то еще... / Be sure to visit our Services page and order an Epicor Service Connect integration, SSRS report, or anything else...
Таблица: MA01 - «Market DataBase» («База данных рынка»)
| Поле | Тип поля Scala | Длина Scala | Комментарий | Первичный ключ? |
| MA01001 | STRING | 10 | CustomerCode | Да |
| MA01002 | VSTRING | 35 | CustomerName | |
| MA01003 | VSTRING | 35 | MailAddLine1 | |
| MA01004 | VSTRING | 35 | MailAddLine2 | |
| MA01005 | VSTRING | 35 | MailAddLine3 | |
| MA01006 | VSTRING | 35 | VistingAddr1 | |
| MA01007 | VSTRING | 35 | VistingAddr2 | |
| MA01008 | VSTRING | 35 | VistingAddr3 | |
| MA01009 | VSTRING | 20 | TelephoneNo | |
| MA01010 | VSTRING | 10 | TelexNo | |
| MA01011 | VSTRING | 20 | TelefaxNo | |
| MA01012 | STRING | 1 | LanguageCode | |
| MA01013 | STRING | 3 | SalesMan | |
| MA01014 | VSTRING | 20 | BudgetPotential | |
| MA01015 | VSTRING | 30 | InternNote1 | |
| MA01016 | VSTRING | 30 | InternNote2 | |
| MA01017 | VSTRING | 35 | AlphaSrchKey | |
| MA01018 | VSTRING | 10 | MainCustCode | |
| MA01019 | STRING | 4 | Category | |
| MA01020 | STRING | 2 | District | |
| MA01021 | STRING | 2 | AdvertCode | |
| MA01022 | STRING | 4 | CityCode | |
| MA01023 | STRING | 5 | SNICode | |
| MA01024 | STRING | 2 | ProspectType | |
| MA01025 | VSTRING | 8 | InformatSrc | |
| MA01026 | DATE | 8 | DateEnterDB | |
| MA01027 | DATE | 8 | LatestUpDate | |
| MA01028 | DATE | 8 | LatestContD | |
| MA01029 | VSTRING | 15 | UserDefData1 | |
| MA01030 | VSTRING | 10 | UserDefData2 | |
| MA01031 | VSTRING | 10 | UserDefData3 | |
| MA01032 | VSTRING | 5 | UserDefData4 | |
| MA01033 | STRING | 1 | UserSwitch1 | |
| MA01034 | STRING | 1 | UserSwitch2 | |
| MA01035 | STRING | 1 | UserSwitch3 | |
| MA01036 | STRING | 1 | UserSwitch4 | |
| MA01037 | BINSTRING | 15 | AttributeTags | |
| MA01038 | VSTRING | 8 | OwnerGroup | |
| MA01039 | DATE | 8 | NextContactDate | |
| MA01040 | VSTRING | 2 | ContactFrequence | |
| MA01041 | VSTRING | 10 | ZipCode | |
| MA01042 | VSTRING | 10 | CustomerCode | |
| MA01043 | VSTRING | 10 | SupplierCode | |
| MA01044 | VSTRING | 35 | MailAddLine4 | |
| MA01045 | VSTRING | 35 | VistingAddr4 | |
| MA01046 | VSTRING | 10 | ZipCodeAddr |
Навигация: Структура БД Scala/iScala | Scala 5.1 SR13 | Market DataBase (База данных рынка) | Market DataBase (База данных рынка)
/* */