Be sure to visit our Services page and order an Epicor Service Connect integration, SSRS report, or anything else... / Не забудьте посетить страницу «Наши услуги» и заказать интеграцию Epicor Service Connect, отчет SSRS или что-то еще...
Таблица: 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 |
Навигация: Структура БД iScala | iScala 2.2 HF 2.3318 - 2.02.3318 | System Utilities/Office Autom. | Customer Site Addresses