Таблица | Table: MA01 - «Market DataBase». Маска имени таблицы | Table Name Mask: «MA01%cc00»
Поле | Тип поля | Тип поля iScala | Длина поля | Точность | Длина iScala | Комментарий | Расширенный комментарий | Дополнительное описание | Позиция в индексе | Первичный ключ? |
Field | Field Type | iScala Field Type | Field Length | Precision | iScala Length | Comment | Extended Comment | Additional Description | Index Position | Is Primary key? |
MA01001 | NCHAR | STRING | 10 | 0 | 10 | CustomerCode | Prospect Code | 1 | Да / Yes | |
MA01002 | NVARCHAR | VSTRING | 35 | 0 | 35 | CustomerName | Prospect Name | |||
MA01003 | NVARCHAR | VSTRING | 35 | 0 | 35 | MailAddLine1 | Address Line 1 | |||
MA01004 | NVARCHAR | VSTRING | 35 | 0 | 35 | MailAddLine2 | Address Line 2 | |||
MA01005 | NVARCHAR | VSTRING | 35 | 0 | 35 | MailAddLine3 | Address Line 3 | |||
MA01006 | NVARCHAR | VSTRING | 35 | 0 | 35 | VistingAddr1 | Visiting Address Line 1 | |||
MA01007 | NVARCHAR | VSTRING | 35 | 0 | 35 | VistingAddr2 | Visiting Address Line 2 | |||
MA01008 | NVARCHAR | VSTRING | 35 | 0 | 35 | VistingAddr3 | Visiting Address Line 3 | |||
MA01009 | NVARCHAR | VSTRING | 20 | 0 | 20 | TelephoneNo | Telephone Number | |||
MA01010 | NVARCHAR | VSTRING | 10 | 0 | 10 | TelexNo | Telex Number | |||
MA01011 | NVARCHAR | VSTRING | 20 | 0 | 20 | TelefaxNo | Telefax Number | |||
MA01012 | NVARCHAR | VSTRING | 3 | 0 | 3 | LanguageCode | Language | |||
MA01013 | NCHAR | STRING | 3 | 0 | 3 | SalesMan | Salesman | |||
MA01014 | NVARCHAR | VSTRING | 20 | 0 | 20 | BudgetPotential | Budget Potential | |||
MA01015 | NVARCHAR | VSTRING | 30 | 0 | 30 | InternNote1 | Internal Note 1 | |||
MA01016 | NVARCHAR | VSTRING | 30 | 0 | 30 | InternNote2 | Internal Note 2 | |||
MA01017 | NVARCHAR | VSTRING | 35 | 0 | 35 | AlphaSrchKey | Prospect Search Key | |||
MA01018 | NVARCHAR | VSTRING | 10 | 0 | 10 | MainCustCode | Main Customer Code | |||
MA01019 | NCHAR | STRING | 4 | 0 | 4 | Category | Category | |||
MA01020 | NCHAR | STRING | 2 | 0 | 2 | District | District | |||
MA01021 | NCHAR | STRING | 2 | 0 | 2 | AdvertCode | Advertising Area | |||
MA01022 | NCHAR | STRING | 4 | 0 | 4 | CityCode | Area Code | |||
MA01023 | NCHAR | STRING | 5 | 0 | 5 | SNICode | Trade Code | |||
MA01024 | NCHAR | STRING | 2 | 0 | 2 | ProspectType | Market Segment | |||
MA01025 | NVARCHAR | VSTRING | 8 | 0 | 8 | InformatSrc | Information Source | |||
MA01026 | DATETIME | DATE | 0 | 0 | 8 | DateEnterDB | Date Entered | |||
MA01027 | DATETIME | DATE | 0 | 0 | 8 | LatestUpDate | Date Update | |||
MA01028 | DATETIME | DATE | 0 | 0 | 8 | LatestContD | Last Contact Date | |||
MA01029 | NVARCHAR | VSTRING | 15 | 0 | 15 | UserDefData1 | User Defined Field 1 | |||
MA01030 | NVARCHAR | VSTRING | 10 | 0 | 10 | UserDefData2 | User Defined Field 2 | |||
MA01031 | NVARCHAR | VSTRING | 10 | 0 | 10 | UserDefData3 | User Defined Field 3 | |||
MA01032 | NVARCHAR | VSTRING | 5 | 0 | 5 | UserDefData4 | User Defined Field 4 | |||
MA01033 | NCHAR | STRING | 1 | 0 | 1 | UserSwitch1 | User Defined Field 5 | |||
MA01034 | NCHAR | STRING | 1 | 0 | 1 | UserSwitch2 | User Defined Field 6 | |||
MA01035 | NCHAR | STRING | 1 | 0 | 1 | UserSwitch3 | User Defined Field 7 | |||
MA01036 | NCHAR | STRING | 1 | 0 | 1 | UserSwitch4 | User Defined Field 8 | |||
MA01037 | BINARY | BINSTRING | 15 | 0 | 15 | AttributeTags | Attributes | This is a binary area of 15 bytes containing the 105 attributes that can be defined for a prospect. In each byte, bit 1-7 is used as true/false flags for the attribute. | ||
MA01038 | NVARCHAR | VSTRING | 8 | 0 | 8 | OwnerGroup | User Group | |||
MA01039 | DATETIME | DATE | 0 | 0 | 8 | NextContactDate | Next Contact Date | |||
MA01040 | NVARCHAR | VSTRING | 2 | 0 | 2 | ContactFrequence | Contact Frequency | The first character in the string defined the unit of measure and the second the quantity, the following units are valid for the first character:
0 - Days 1 - Weeks 2 - Month 3 - Years |
||
MA01041 | NVARCHAR | VSTRING | 10 | 0 | 10 | ZipCode | Zip Code | |||
MA01042 | NVARCHAR | VSTRING | 10 | 0 | 10 | CustomerCode | Customer Code | |||
MA01043 | NVARCHAR | VSTRING | 10 | 0 | 10 | SupplierCode | Supplier Code | |||
MA01044 | NVARCHAR | VSTRING | 35 | 0 | 35 | MailAddLine4 | Address Line 4 | |||
MA01045 | NVARCHAR | VSTRING | 35 | 0 | 35 | VistingAddr4 | Visiting Address Line 4 | |||
MA01046 | NVARCHAR | VSTRING | 10 | 0 | 10 | ZipCodeAddr | Visiting Address Zip Code | |||
MA01047 | NVARCHAR | VSTRING | 35 | 0 | 35 | MailAddLine5 | Address Line 5 | |||
MA01048 | NVARCHAR | VSTRING | 35 | 0 | 35 | MailAddLine6 | Address Line 6 | |||
MA01049 | NVARCHAR | VSTRING | 35 | 0 | 35 | MailAddLine7 | Address Line 7 | |||
MA01050 | NVARCHAR | VSTRING | 35 | 0 | 35 | VistingAddr5 | Visiting Address Line 5 | |||
MA01051 | NVARCHAR | VSTRING | 35 | 0 | 35 | VistingAddr6 | Visiting Address Line 6 | |||
MA01052 | NVARCHAR | VSTRING | 35 | 0 | 35 | VistingAddr7 | Visiting Address Line 7 | |||
MA01053 | NVARCHAR | VSTRING | 3 | 0 | 3 | MailCountryCode | Mail Country Code | |||
MA01054 | NVARCHAR | VSTRING | 3 | 0 | 3 | VisitingCountryCode | Visiting Country Code |
Навигация / Shortcut: Структура БД iScala / iScala DB structure | Epicor iScala 2.3 SR3 - 2.03.12787 | Market Database | Market Database