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

Структура таблиц / Table structure Epicor iScala 3.3 (x64) — 3.3.0419 :: Таблица / Table MA03 — Contacts

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

Поле / Field Тип поля / Field Type Тип поля Scala / iScala Field Type Длина поля / Field length Точность / Precision Длина Scala / iScala length Комментарий / Comment Расширенный комментарий / Extended comment Дополнительное описание / Additional description Позиция в индексе / Index position Первичный ключ? / Is Primary key?
MA03001 NCHAR STRING 10 0 10 CustomerCode Prospect Code   1 Да / Yes
MA03002 NCHAR STRING 3 0 3 ContactNo Contact Number   2 Да / Yes
MA03003 NVARCHAR VSTRING 35 0 35 ContactName Contact Name      
MA03004 NVARCHAR VSTRING 35 0 35 MapeAddLine1 Address Line 1      
MA03005 NVARCHAR VSTRING 35 0 35 MapeAddLine2 Address Line 2      
MA03006 NVARCHAR VSTRING 35 0 35 MapeAddLine3 Address Line 3      
MA03007 NVARCHAR VSTRING 35 0 35 VistingAddr1 Visiting Address Line 1      
MA03008 NVARCHAR VSTRING 35 0 35 VistingAddr2 Visiting Address Line 2      
MA03009 NVARCHAR VSTRING 35 0 35 VistingAddr3 Visiting Address Line 3      
MA03010 NVARCHAR VSTRING 20 0 20 TelephoneNo Telephone Number      
MA03011 NVARCHAR VSTRING 10 0 10 TelexNo Telex Number      
MA03012 NVARCHAR VSTRING 20 0 20 TelefaxNo Telefax Number      
MA03013 NVARCHAR VSTRING 30 0 30 InternalNote1 Internal Note 1      
MA03014 NVARCHAR VSTRING 30 0 30 InternalNote2 Internal Note 2      
MA03015 NVARCHAR VSTRING 35 0 35 AlphaSrchKey Contact Search Key      
MA03016 NCHAR STRING 4 0 4 ContactCateg Contact Category      
MA03017 NCHAR STRING 2 0 2 Title Title      
MA03018 NVARCHAR VSTRING 8 0 8 SourceOfInfo Information Source      
MA03019 DATETIME DATE 0 0 8 DateEnterDB Date Entered      
MA03020 DATETIME DATE 0 0 8 LatestUpDate Date Update      
MA03021 DATETIME DATE 0 0 8 LatestContD Last Contact Date      
MA03022 NVARCHAR VSTRING 15 0 15 UserDefData1 User Defined Field 1      
MA03023 NVARCHAR VSTRING 10 0 10 UserDefData2 User Defined Field 2      
MA03024 NVARCHAR VSTRING 10 0 10 UserDefData3 User Defined Field 3      
MA03025 NVARCHAR VSTRING 5 0 5 UserDefData4 User Defined Field 4      
MA03026 NCHAR STRING 1 0 1 UserSwitch1 User Defined Field 5      
MA03027 NCHAR STRING 1 0 1 UserSwitch2 User Defined Field 6      
MA03028 NCHAR STRING 1 0 1 UserSwitch3 User Defined Field 7      
MA03029 NCHAR STRING 1 0 1 UserSwitch4 User Defined Field 8      
MA03030 BINARY BINSTRING 15 0 15 AttributeTag 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.    
MA03031 DATETIME DATE 0 0 8 NextContactDate Next Contact Date      
MA03032 NCHAR STRING 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
   
MA03033 NVARCHAR VSTRING 10 0 10 ZipCode Zip Code      
MA03034 NVARCHAR VSTRING 20 0 20 MobileTeleph Mobile Phone Number      
MA03035 NVARCHAR VSTRING 20 0 20 MBSNo Pager Number      
MA03036 NVARCHAR VSTRING 35 0 35 VistingAddr4 Visiting Address Line 4      
MA03037 NVARCHAR VSTRING 35 0 35 MapeAddLine4 Address Line 4      
MA03038 NVARCHAR VSTRING 10 0 10 ZipCodeAddr Visiting Address Zip Code      
MA03039 NVARCHAR VSTRING 35 0 35 MapeAddLine5 Address Line 5      
MA03040 NVARCHAR VSTRING 35 0 35 MapeAddLine6 Address Line 6      
MA03041 NVARCHAR VSTRING 35 0 35 MapeAddLine7 Address Line 7      
MA03042 NVARCHAR VSTRING 35 0 35 VistingAddr5 Visiting Address Line 5      
MA03043 NVARCHAR VSTRING 35 0 35 VistingAddr6 Visiting Address Line 6      
MA03044 NVARCHAR VSTRING 35 0 35 VistingAddr7 Visiting Address Line 7      
MA03045 NVARCHAR VSTRING 3 0 3 MapeCountryCode Mape Country Code      
MA03046 NVARCHAR VSTRING 3 0 3 VistingCountryCode Visting Country Code      
MA03047 NVARCHAR VSTRING 200 0 200 EmailAddress E-mail address      
MA03048 NVARCHAR VSTRING 40 0 40 Documents Documents      

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