Таблица: OR43 - «Sales Order Delivery Address Historical Versions». Маска имени таблицы: «OR43%cc00»
Поле | Тип поля | Тип поля Scala | Длина поля | Точность | Длина Scala | Комментарий | Расширенный комментарий | Дополнительное описание | Позиция в индексе | Первичный ключ? |
OR43001 | NVARCHAR | VSTRING | 10 | 0 | 10 | OrderNumb | Order Number | 1 | Да | |
OR43002 | NVARCHAR | VSTRING | 35 | 0 | 35 | CustName | Customer Name | |||
OR43003 | NVARCHAR | VSTRING | 35 | 0 | 35 | AddrLine1 | Address Line 1 | |||
OR43004 | NVARCHAR | VSTRING | 35 | 0 | 35 | AddrLine2 | Address Line 2 | |||
OR43005 | NVARCHAR | VSTRING | 35 | 0 | 35 | AddrLine3 | Address Line 3 | |||
OR43006 | NVARCHAR | VSTRING | 13 | 0 | 13 | ContanierNo | Container Number | |||
OR43007 | NVARCHAR | VSTRING | 35 | 0 | 35 | DelAddrNo | EDI Delivery Address Number | |||
OR43008 | NVARCHAR | VSTRING | 35 | 0 | 35 | AddressLine4 | Address Line 4 | |||
OR43009 | NVARCHAR | VSTRING | 10 | 0 | 10 | ZipCode | Zip Code | |||
OR43010 | NVARCHAR | VSTRING | 20 | 0 | 20 | TelephoneNo | Telephone Number | |||
OR43011 | NVARCHAR | VSTRING | 20 | 0 | 20 | TelefaxNo | Telefax Number | |||
OR43012 | NVARCHAR | VSTRING | 15 | 0 | 15 | InvNoDummy | Invoice Number | |||
OR43013 | INT | INTEGER | 0 | 0 | 2 | Localvat | Local Vat Code | |||
OR43014 | NVARCHAR | VSTRING | 35 | 0 | 35 | LTMAddrPattern | Lead Time Address Pattern | |||
OR43015 | NCHAR | STRING | 4 | 0 | 4 | Version Number | Version Number | 2 | Да | |
OR43016 | NVARCHAR | VSTRING | 10 | 0 | 10 | CityCode | City Code | |||
OR43017 | NVARCHAR | VSTRING | 3 | 0 | 3 | CountryCode | Country Code |
Навигация: Структура БД iScala | Epicor iScala 2.3 SR1 - 2.03.8155 | Sales Order | Sales Order Delivery Address Historical Version