Таблица: SL14 - «Delivery Addresses». Маска имени таблицы: «SL14%cc00»
Поле | Тип поля | Тип поля Scala | Длина поля | Точность | Длина Scala | Комментарий | Расширенный комментарий | Дополнительное описание | Позиция в индексе | Первичный ключ? |
SL14001 | NVARCHAR | VSTRING | 10 | 0 | 10 | CustomerCode | Customer Code | 1 | Да | |
SL14002 | NVARCHAR | VSTRING | 2 | 0 | 2 | AddressNo | Address Number | 2 | Да | |
SL14003 | NVARCHAR | VSTRING | 35 | 0 | 35 | CustomerName | Customer Name | |||
SL14004 | NVARCHAR | VSTRING | 35 | 0 | 35 | AddressLine1 | Address Line 1 | |||
SL14005 | NVARCHAR | VSTRING | 35 | 0 | 35 | AddressLine2 | Address Line 2 | |||
SL14006 | NVARCHAR | VSTRING | 35 | 0 | 35 | AddressLine3 | Address Line 3 | |||
SL14007 | NVARCHAR | VSTRING | 13 | 0 | 13 | ContainerNo | Container Number | |||
SL14008 | NVARCHAR | VSTRING | 35 | 0 | 35 | DelivAddrNo | EDI Delivery Address Number | |||
SL14009 | NVARCHAR | VSTRING | 6 | 0 | 6 | DefWarehNo | Default Warehouse | |||
SL14010 | NVARCHAR | VSTRING | 35 | 0 | 35 | AddressLine4 | Address Line 4 | |||
SL14011 | NVARCHAR | VSTRING | 10 | 0 | 10 | ZipCode | Zip Code | |||
SL14012 | NVARCHAR | VSTRING | 20 | 0 | 20 | TelephonNo | Telephone Number | |||
SL14013 | NVARCHAR | VSTRING | 20 | 0 | 20 | TelefaxNo | Telefax Number | |||
SL14014 | NVARCHAR | VSTRING | 2 | 0 | 2 | VATCode2 | VAT Code 2 | |||
SL14015 | NVARCHAR | VSTRING | 50 | 0 | 50 | AccString | Accounting String | |||
SL14016 | INT | INTEGER | 0 | 0 | 9 | Calendar_Collection_Reference | Calendar Collection | |||
SL14017 | NVARCHAR | VSTRING | 35 | 0 | 35 | LTMAddrPattern | Lead Time Address Pattern | |||
SL14018 | NCHAR | STRING | 6 | 0 | 6 | TaxLiability | Tax Liability | |||
SL14019 | NVARCHAR | VSTRING | 10 | 0 | 10 | CityCode | City Code | |||
SL14020 | NCHAR | STRING | 4 | 0 | 4 | InvIssuerCode | Invoice Issuer Code | |||
SL14021 | NCHAR | SWITCH | 1 | 0 | 1 | InvoiceCategory | Invoice Category |
Навигация: Структура БД iScala | Epicor iScala 2.3 - 2.03.3363 | Sales Ledger | Customer Delivery Addresses