Таблица | Table: PC04 - «Delivery Addresses». Маска имени таблицы | Table Name Mask: «PC04%cc00»
Поле | Тип поля | Тип поля iScala | Длина поля | Точность | Длина iScala | Комментарий | Расширенный комментарий | Дополнительное описание | Позиция в индексе | Первичный ключ? |
Field | Field Type | iScala Field Type | Field Length | Precision | iScala Length | Comment | Extended Comment | Additional Description | Index Position | Is Primary key? |
PC04001 | NVARCHAR | VSTRING | 10 | 0 | 10 | OrderNumber | Purchase Order Number | 1 | Да / Yes | |
PC04002 | NVARCHAR | VSTRING | 35 | 0 | 35 | CustName | Customer Name | |||
PC04003 | NVARCHAR | VSTRING | 35 | 0 | 35 | AddressLine1 | Address Line 1 | |||
PC04004 | NVARCHAR | VSTRING | 35 | 0 | 35 | AddressLine2 | Address Line 2 | |||
PC04005 | NVARCHAR | VSTRING | 35 | 0 | 35 | AddressLine3 | Address Line 3 | |||
PC04006 | NVARCHAR | VSTRING | 35 | 0 | 35 | AddressLine4 | Address Line 4 | |||
PC04007 | NVARCHAR | VSTRING | 10 | 0 | 10 | ZipCode | Zip Code | |||
PC04008 | NVARCHAR | VSTRING | 20 | 0 | 20 | TelephoneNo | Telephone Number | |||
PC04009 | NVARCHAR | VSTRING | 20 | 0 | 20 | TelefaxNumb | Telefax Number | |||
PC04010 | NVARCHAR | VSTRING | 15 | 0 | 15 | InvoiceNo_Last | Invoice Number | |||
PC04011 | NVARCHAR | VSTRING | 35 | 0 | 35 | LTMAddrPattern | Lead Time Address Pattern | |||
PC04012 | NVARCHAR | VSTRING | 10 | 0 | 10 | CityCode | CityCode | |||
PC04013 | NCHAR | STRING | 3 | 0 | 3 | Country Code | Country Code | GEO unit | ||
PC04014 | NVARCHAR | VSTRING | 10 | 0 | 10 | Region Code | Region Code | GEO unit | ||
PC04015 | NVARCHAR | VSTRING | 10 | 0 | 10 | State/Province Code | State/Province Code | GEO unit | ||
PC04016 | NVARCHAR | VSTRING | 10 | 0 | 10 | County Code | County Code | GEO unit | ||
PC04017 | NVARCHAR | VSTRING | 35 | 0 | 35 | AddressLine5 | Address Line 5 | |||
PC04018 | NVARCHAR | VSTRING | 35 | 0 | 35 | AddressLine6 | Address Line 6 | |||
PC04019 | NVARCHAR | VSTRING | 35 | 0 | 35 | AddressLine7 | Address Line 7 |
Навигация / Shortcut: Структура БД iScala / iScala DB structure | Epicor iScala 2.3 SR3 - 2.03.12787 | Purchase Order | Delivery Addresses