Таблица: 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