One level Up / One level Up: Структура таблиц / Table structure Epicor iScala 3.2 (x64) — 3.2.0317 :: Список таблиц модуля «Системные Утилиты/Автом. Офиса»/List of tables of module «System Utilities/Office Autom.»

Структура таблиц / Table structure Epicor iScala 3.2 (x64) — 3.2.0317 :: Таблица / Table SY80 — Customer Site Addresses

Таблица / Table: SY80 — «Customer Site Address File I/O». Маска имени таблицы / Table name mask: «SY80%cc00»

Поле / Field Тип поля / Field Type Тип поля Scala / iScala Field Type Длина поля / Field length Точность / Precision Длина Scala / iScala length Комментарий / Comment Расширенный комментарий / Extended comment Дополнительное описание / Additional description Позиция в индексе / Index position Первичный ключ? / Is Primary key?
SY80001 NCHAR STRING 10 0 10 CustomerCode Customer Code   1 Да / Yes
SY80002 NCHAR STRING 4 0 4 SiteNo Site Code   2 Да / Yes
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 120 0 120 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 CalendarColRef 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   3 Да / Yes
SY80048 NVARCHAR VSTRING 3 0 3 CountryCode Country Code      
SY80049 NVARCHAR VSTRING 200 0 200 EmailAddress Email address      
SY80050 NVARCHAR VSTRING 35 0 35 AddressLine5 Address Line 5      
SY80051 NVARCHAR VSTRING 35 0 35 AddressLine6 Address Line 6      
SY80052 NVARCHAR VSTRING 35 0 35 AddressLine7 Address Line 7      
SY80053 NUMERIC X_NUMERIC 36 8 28 Longitude Longitude      
SY80054 NUMERIC X_NUMERIC 36 8 28 Latitude Latitude      
SY80055 NUMERIC X_NUMERIC 36 8 28 Altitude Altitude      
SY80056 NVARCHAR VSTRING 36 0 36 ExternalID External ID      

Навигация / Navigation: