One level Up / One level Up: Структура таблиц / Table structure Epicor iScala 3.5 (x64) — 3.5.0429 :: Список таблиц модуля /List of tables of module «Market Database»

Структура таблиц / Table structure Epicor iScala 3.5 (x64) — 3.5.0429 :: Таблица / Table MA01 — Market Database

Таблица / Table: MA01 — «Market DataBase». Маска имени таблицы / Table name mask: «MA01%cc00»

Поле / Field Тип поля / Field Type Тип поля Scala / iScala Field Type Длина поля / Field length Точность / Precision Длина Scala / 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 CustCode 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      

Навигация / Navigation: