Таблица: OR04 - «Delivery Addresses». Маска имени таблицы: «OR04%cc00»
Поле | Тип поля | Тип поля iScala | Длина поля | Точность | Длина iScala | Комментарий | Расширенный комментарий | Дополнительное описание | Позиция в индексе | Первичный ключ? |
OR04001 | NVARCHAR | VSTRING | 10 | 0 | 10 | OrderNumb | Order Number | 1 | Да | |
OR04002 | NVARCHAR | VSTRING | 35 | 0 | 35 | CustName | Customer Name | |||
OR04003 | NVARCHAR | VSTRING | 35 | 0 | 35 | AddrLine1 | Address Line 1 | |||
OR04004 | NVARCHAR | VSTRING | 35 | 0 | 35 | AddrLine2 | Address Line 2 | |||
OR04005 | NVARCHAR | VSTRING | 35 | 0 | 35 | AddrLine3 | Address Line 3 | |||
OR04006 | NVARCHAR | VSTRING | 13 | 0 | 13 | ContanierNo | Container Number | |||
OR04007 | NVARCHAR | VSTRING | 35 | 0 | 35 | DelAddrNo | EDI Delivery Address Number | |||
OR04008 | NVARCHAR | VSTRING | 35 | 0 | 35 | AddressLine4 | Address Line 4 | |||
OR04009 | NVARCHAR | VSTRING | 10 | 0 | 10 | ZipCode | Zip Code | |||
OR04010 | NVARCHAR | VSTRING | 20 | 0 | 20 | TelephoneNo | Telephone Number | |||
OR04011 | NVARCHAR | VSTRING | 20 | 0 | 20 | TelefaxNo | Telefax Number | |||
OR04012 | NVARCHAR | VSTRING | 15 | 0 | 15 | InvNoDummy | Invoice Number Dummy | |||
OR04013 | INT | INTEGER | 0 | 0 | 2 | Localvat | Local Vat Code | |||
OR04014 | NVARCHAR | VSTRING | 35 | 0 | 35 | LTMAddrPattern | Lead Time Address Pattern | |||
OR04015 | NCHAR | STRING | 4 | 0 | 4 | VersionNumber | Version Number | |||
OR04016 | NVARCHAR | VSTRING | 10 | 0 | 10 | CityCode | City Code | |||
OR04017 | NVARCHAR | VSTRING | 3 | 0 | 3 | CountryCode | Country Code | |||
OR04018 | NVARCHAR | VSTRING | 10 | 0 | 10 | RegionCode | Region Code | GEO unit | ||
OR04019 | NVARCHAR | VSTRING | 10 | 0 | 10 | StateProvinceCode | State/Province Code | GEO unit | ||
OR04020 | NVARCHAR | VSTRING | 10 | 0 | 10 | CountyCode | County Code | GEO unit | ||
OR04021 | NVARCHAR | VSTRING | 200 | 0 | 200 | EmailAddress | Email address | |||
OR04022 | NVARCHAR | VSTRING | 35 | 0 | 35 | AddrLine5 | Address Line 5 | |||
OR04023 | NVARCHAR | VSTRING | 35 | 0 | 35 | AddrLine6 | Address Line 6 | |||
OR04024 | NVARCHAR | VSTRING | 35 | 0 | 35 | AddrLine7 | Address Line 7 | |||
OR04025 | NVARCHAR | VSTRING | 10 | 0 | 10 | CustomerCode | Customer code | |||
OR04026 | NVARCHAR | VSTRING | 2 | 0 | 2 | AddressNo | Address No |
Навигация: Структура БД iScala | Epicor iScala 3.00 (x64) - 3.00.02254 | Sales Order | Sales Order Delivery Addresses