Таблица: MA03 - «Contacts». Маска имени таблицы: «MA03%cc00»

Поле Тип поля Тип поля Scala Длина поля Точ­ность Длина Scala Комментарий Расширенный комментарий Дополнительное описание Пози­ция в инде­ксе Первич­ный ключ?
MA03001 NCHAR STRING 10 0 10 CustomerCode Prospect Code   1 Да
MA03002 NCHAR STRING 3 0 3 ContactNo Contact Number   2 Да
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 Address Line 4      
MA03037 NVARCHAR VSTRING 35 0 35 MapeAddLine4 Visiting Address Line 4      
MA03038 NVARCHAR VSTRING 10 0 10 ZipCodeAddr Visiting Address Zip Code      

Навигация: Структура БД iScala | Epicor iScala 2.3 - 2.03.3363 | Market Database | Contacts