Таблица | Table: MA08 - «Code File». Маска имени таблицы | Table Name Mask: «MA08%cc00»

Поле Тип поля Тип поля iScala Длина поля Точ­ность Длина iScala Комментарий Расширенный комментарий Дополнительное описание Пози­ция в инде­ксе Первич­ный ключ?
Field Field Type iScala Field Type Field Length Pre­cision iScala Length Comment Extended Comment Additional Description Index Position Is Primary key?
MA08001 NCHAR STRING 1 0 1 CodeNo Code Number This table is used as a general dictionary for different type of code files used in market database. The code number indicates the type of dictionary and these are the possible values:
1 - User Defined Field 1
2 - User Defined Field 2
3 - User Defined Field 3
4 - User Defined Field 4
5 - User Defined Field 5
6 - User Defined Field 6
7 - User Defined Field 7
8 - User Defined Field 8
A - Salesman
B - Category
C - District
D - Advertising Area
E - Area
F - Trade Code
G - Market Segment
H - Information Source
I - Contact Category
J - Title
K - Campaign
L - Campaign Reply		 1 Да / Yes
MA08002 NCHAR STRING 15 0 15 Key Key Value   2 Да / Yes
MA08003 NVARCHAR VSTRING 25 0 25 Text Text      
MA08004 NVARCHAR VSTRING 7 0 7 Spare (obsolete)      

Навигация / Shortcut: Структура БД iScala / iScala DB structure | Epicor iScala 2.3 SR3 - 2.03.12787 | Market Database | Code File