Таблица: PC45 - «Delivery Address History». Маска имени таблицы: «PC45%cc00»
Поле | Тип поля | Тип поля iScala | Длина поля | Точность | Длина iScala | Комментарий | Расширенный комментарий | Дополнительное описание | Позиция в индексе | Первичный ключ? |
PC45001 | NVARCHAR | VSTRING | 10 | 0 | 10 | OrderNumber | Purchase Order Number | 1 | Да | |
PC45002 | NVARCHAR | VSTRING | 35 | 0 | 35 | CustName | Customer Name | |||
PC45003 | NVARCHAR | VSTRING | 35 | 0 | 35 | AddressLine1 | Address Line 1 | |||
PC45004 | NVARCHAR | VSTRING | 35 | 0 | 35 | AddressLine2 | Address Line 2 | |||
PC45005 | NVARCHAR | VSTRING | 35 | 0 | 35 | AddressLine3 | Address Line 3 | |||
PC45006 | NVARCHAR | VSTRING | 35 | 0 | 35 | AddressLine4 | Address Line 4 | |||
PC45007 | NVARCHAR | VSTRING | 10 | 0 | 10 | ZipCode | Zip Code | |||
PC45008 | NVARCHAR | VSTRING | 20 | 0 | 20 | TelephoneNo | Telephone Number | |||
PC45009 | NVARCHAR | VSTRING | 20 | 0 | 20 | TelefaxNumb | Telefax Number | |||
PC45010 | NVARCHAR | VSTRING | 25 | 0 | 25 | InvoiceNoLast | Invoice Number | 2 | Да | |
PC45011 | NVARCHAR | VSTRING | 35 | 0 | 35 | LTMAddrPattern | Lead Time Address Pattern | |||
PC45012 | NVARCHAR | VSTRING | 10 | 0 | 10 | CityCode | CityCode | |||
PC45013 | NCHAR | STRING | 3 | 0 | 3 | CountryCode | Country Code | GEO unit | ||
PC45014 | NVARCHAR | VSTRING | 10 | 0 | 10 | RegionCode | Region Code | GEO unit | ||
PC45015 | NVARCHAR | VSTRING | 10 | 0 | 10 | StateProvinceCode | State/Province Code | GEO unit | ||
PC45016 | NVARCHAR | VSTRING | 10 | 0 | 10 | CountyCode | County Code | GEO unit | ||
PC45017 | NVARCHAR | VSTRING | 35 | 0 | 35 | AddressLine5 | Address Line 5 | |||
PC45018 | NVARCHAR | VSTRING | 35 | 0 | 35 | AddressLine6 | Address Line 6 | |||
PC45019 | NVARCHAR | VSTRING | 35 | 0 | 35 | AddressLine7 | Address Line 7 |
Навигация: Структура БД iScala | Epicor iScala 3.00 (x64) - 3.00.02254 | Purchase Order | Delivery Address History