Таблица: SY80 - «Customer Site Address File I/O». Маска имени таблицы: «SY80%cc00»
Поле | Тип поля | Тип поля Scala | Длина поля | Точность | Длина Scala | Комментарий | Расширенный комментарий | Дополнительное описание | Позиция в индексе | Первичный ключ? |
SY80001 | NCHAR | STRING | 10 | 0 | 10 | CustomerCode | Customer Code | 1 | Да | |
SY80002 | NCHAR | STRING | 4 | 0 | 4 | SiteNo | Site Code | 2 | Да | |
SY80003 | NVARCHAR | VSTRING | 35 | 0 | 35 | CustomerName | Customer Name | |||
SY80004 | NVARCHAR | VSTRING | 35 | 0 | 35 | AddressLine1 | Address Line 1 | |||
SY80005 | NVARCHAR | VSTRING | 35 | 0 | 35 | AddressLine2 | Address Line 2 | |||
SY80006 | NVARCHAR | VSTRING | 35 | 0 | 35 | AddressLine3 | Address Line 3 | |||
SY80007 | NVARCHAR | VSTRING | 35 | 0 | 35 | AddressLine4 | Address Line 4 | |||
SY80008 | NVARCHAR | VSTRING | 13 | 0 | 13 | Spare | (obsolete) | |||
SY80009 | NVARCHAR | VSTRING | 13 | 0 | 13 | Spare | (obsolete) | |||
SY80010 | NCHAR | STRING | 10 | 0 | 10 | ZipCode | Zip Code | |||
SY80011 | NCHAR | STRING | 20 | 0 | 20 | TelephonNo | Telephone Number | |||
SY80012 | NCHAR | STRING | 20 | 0 | 20 | TelefaxNo | Telefax Number | |||
SY80013 | NVARCHAR | VSTRING | 25 | 0 | 25 | Reference | Reference | |||
SY80014 | NVARCHAR | VSTRING | 40 | 0 | 40 | Remark1 | Remark Line 1 | |||
SY80015 | NVARCHAR | VSTRING | 40 | 0 | 40 | Remark2 | Remark Line 2 | |||
SY80016 | NVARCHAR | VSTRING | 40 | 0 | 40 | Remark3 | Remark Line 3 | |||
SY80017 | NUMERIC | X_NUMERIC | 13 | 8 | 5 | MONOpen | Monday Open From | |||
SY80018 | NUMERIC | X_NUMERIC | 13 | 8 | 5 | MONClose | Monday Open To | |||
SY80019 | NUMERIC | X_NUMERIC | 13 | 8 | 5 | TUEOpen | Tuesday Open From | |||
SY80020 | NUMERIC | X_NUMERIC | 13 | 8 | 5 | TUEClose | Tuesday Open To | |||
SY80021 | NUMERIC | X_NUMERIC | 13 | 8 | 5 | WEDOpen | Wednesday Open From | |||
SY80022 | NUMERIC | X_NUMERIC | 13 | 8 | 5 | WEDClose | Wednesday Open To | |||
SY80023 | NUMERIC | X_NUMERIC | 13 | 8 | 5 | THUOpen | Thursday Open From | |||
SY80024 | NUMERIC | X_NUMERIC | 13 | 8 | 5 | THUClose | Thursday Open To | |||
SY80025 | NUMERIC | X_NUMERIC | 13 | 8 | 5 | FRIOpen | Friday Open From | |||
SY80026 | NUMERIC | X_NUMERIC | 13 | 8 | 5 | FRIClose | Friday Open To | |||
SY80027 | NUMERIC | X_NUMERIC | 13 | 8 | 5 | SATOpen | Saturday Open From | |||
SY80028 | NUMERIC | X_NUMERIC | 13 | 8 | 5 | SATClose | Saturday Open To | |||
SY80029 | NUMERIC | X_NUMERIC | 13 | 8 | 5 | SUNOpen | Sunday Open From | |||
SY80030 | NUMERIC | X_NUMERIC | 13 | 8 | 5 | SUNClose | Sunday Open To | |||
SY80031 | INT | INTEGER | 0 | 0 | 2 | TimeZone | Time Zone | |||
SY80032 | NCHAR | STRING | 1 | 0 | 1 | Spare | (obsolete) | |||
SY80033 | NCHAR | STRING | 1 | 0 | 1 | Spare | (obsolete) | |||
SY80034 | NCHAR | STRING | 1 | 0 | 1 | Spare | (obsolete) | |||
SY80035 | NVARCHAR | ACCSTR | 50 | 0 | 50 | AccString | Accounting String | |||
SY80036 | NCHAR | STRING | 15 | 0 | 15 | AlfaSrchName | Alpha Search Name | |||
SY80037 | NCHAR | STRING | 15 | 0 | 15 | AlfaSrchRef | Alpha Search Reference | |||
SY80038 | NCHAR | STRING | 15 | 0 | 15 | AlfaSrchAdr2 | Alpha Search Address Line 2 | |||
SY80039 | NCHAR | STRING | 12 | 0 | 12 | InternSiteNo | Internal Site Number | |||
SY80040 | NCHAR | STRING | 1 | 0 | 1 | TextYN | Extra Text Exist | |||
SY80041 | NCHAR | STRING | 2 | 0 | 2 | TaxCode | VAT Code | |||
SY80042 | INT | INTEGER | 0 | 0 | 9 | Calendar_Collection_Reference | Calendar Collection | |||
SY80043 | NVARCHAR | VSTRING | 35 | 0 | 35 | LTMAddrPattern | Lead Time Address Pattern | |||
SY80044 | NCHAR | STRING | 6 | 0 | 6 | TaxLiabilityCode | Tax Liability Code | |||
SY80045 | NVARCHAR | VSTRING | 10 | 0 | 10 | CityCode | CityCode | |||
SY80046 | NVARCHAR | VSTRING | 10 | 0 | 10 | DefaultEngineer | Default Engineer | |||
SY80047 | NVARCHAR | VSTRING | 10 | 0 | 10 | OrderNumber | Order Number |
Навигация: Структура БД iScala | Epicor iScala 2.3 SR1 - 2.03.8155 | System Utilities/Office Autom. | Customer Site Addresses