На один уровень вверх / One level Up: Структура таблиц / Table structure Epicor iScala 3.5 (x64) — 3.5.0429 :: Список таблиц модуля /List of tables of module «Sales Ledger»

Структура таблиц / Table structure Epicor iScala 3.5 (x64) — 3.5.0429 :: Таблица / Table SLH2 — Invoice Issuer/Recipient History

Таблица / Table: SLH2 — «Invoice Issuer/Recipient History». Маска имени таблицы / Table name mask: «SLH2%cc00»

Поле / Field Тип поля / Field Type Тип поля Scala / iScala Field Type Длина поля / Field length Точность / Precision Длина Scala / iScala length Комментарий / Comment Расширенный комментарий / Extended comment Дополнительное описание / Additional description Позиция в индексе / Index position Первичный ключ? / Is Primary key?
SLH2001 NVARCHAR VSTRING 10 0 10 CustomerCode Customer Code   1 Да / Yes
SLH2002 NVARCHAR VSTRING 25 0 25 InvoiceNo Invoice No   2 Да / Yes
SLH2003 INT INTEGER 0 0 4 Type Type 0 — issuer (own company)

1 – recipient (invoice customer)		 3 Да / Yes
SLH2004 NVARCHAR VSTRING 50 0 50 CompanyName Company Name      
SLH2005 NVARCHAR VSTRING 20 0 20 TaxRegistrationNumber Tax Registration Number      
SLH2006 NVARCHAR VSTRING 20 0 20 StateRegistrationNumber State Registration Number      
SLH2007 NVARCHAR VSTRING 35 0 35 AddressLine1 Address Line 1      
SLH2008 NVARCHAR VSTRING 35 0 35 AddressLine2 Address Line 2      
SLH2009 NVARCHAR VSTRING 35 0 35 AddressLine3 Address Line 3      
SLH2010 NVARCHAR VSTRING 35 0 35 AddressLine4 Address Line 4      
SLH2011 NVARCHAR VSTRING 35 0 35 AddressLine5 Address Line 5      
SLH2012 NVARCHAR VSTRING 35 0 35 AddressLine6 Address Line 6      
SLH2013 NVARCHAR VSTRING 35 0 35 AddressLine7 Address Line 7      
SLH2014 NVARCHAR VSTRING 10 0 10 ZipCode Zip Code      
SLH2015 NVARCHAR VSTRING 50 0 50 EmailAddress Email Address      
SLH2016 NVARCHAR VSTRING 20 0 20 PhoneNo Phone No      
SLH2017 NVARCHAR VSTRING 20 0 20 FaxNo Fax No      
SLH2018 NVARCHAR VSTRING 120 0 120 UserDefined1 User Defined 1      
SLH2019 NVARCHAR VSTRING 120 0 120 UserDefined2 User Defined 2      
SLH2020 NVARCHAR VSTRING 120 0 120 UserDefined3 User Defined 3      
SLH2021 NVARCHAR VSTRING 120 0 120 UserDefined4 User Defined 4      
SLH2022 NVARCHAR VSTRING 120 0 120 UserDefined5 User Defined 5      
SLH2023 NVARCHAR VSTRING 120 0 120 UserDefined6 User Defined 6      
SLH2024 NVARCHAR VSTRING 120 0 120 UserDefined7 User Defined 7      
SLH2025 NVARCHAR VSTRING 120 0 120 UserDefined8 User Defined 8      
SLH2026 NVARCHAR VSTRING 120 0 120 UserDefined9 User Defined 9      
SLH2027 NVARCHAR VSTRING 120 0 120 UserDefined10 User Defined 10      
SLH2028 NVARCHAR VSTRING 120 0 120 UserDefined11 User Defined 11      
SLH2029 NVARCHAR VSTRING 120 0 120 UserDefined12 User Defined 12      
SLH2030 NVARCHAR VSTRING 120 0 120 UserDefined13 User Defined 13      
SLH2031 NVARCHAR VSTRING 120 0 120 UserDefined14 User Defined 14      
SLH2032 NVARCHAR VSTRING 120 0 120 UserDefined15 User Defined 15      
SLH2033 NVARCHAR VSTRING 120 0 120 UserDefined16 User Defined 16      
SLH2034 NVARCHAR VSTRING 120 0 120 UserDefined17 User Defined 17      
SLH2035 NVARCHAR VSTRING 120 0 120 UserDefined18 User Defined 18      
SLH2036 NVARCHAR VSTRING 120 0 120 UserDefined19 User Defined 19      
SLH2037 NVARCHAR VSTRING 120 0 120 UserDefined20 User Defined 20      
SLH2038 NVARCHAR VSTRING 3 0 3 CountryCode Country Code      
SLH2039 NVARCHAR VSTRING 10 0 10 RegionCode Region Code      
SLH2040 NVARCHAR VSTRING 10 0 10 StateProvinceCode State Province Code      
SLH2041 NVARCHAR VSTRING 10 0 10 CountyCode County Code      
SLH2042 NVARCHAR VSTRING 10 0 10 CityCode City Code      
SLH2043 NVARCHAR VSTRING 120 0 120 UserDefined21 User Defined 21      
SLH2044 NVARCHAR VSTRING 120 0 120 UserDefined22 User Defined 22      
SLH2045 NVARCHAR VSTRING 120 0 120 UserDefined23 User Defined 23      
SLH2046 NVARCHAR VSTRING 120 0 120 UserDefined24 User Defined 24      
SLH2047 NVARCHAR VSTRING 120 0 120 UserDefined25 User Defined 25      
SLH2048 NVARCHAR VSTRING 120 0 120 UserDefined26 User Defined 26      
SLH2049 NVARCHAR VSTRING 120 0 120 UserDefined27 User Defined 27      
SLH2050 NVARCHAR VSTRING 120 0 120 UserDefined28 User Defined 28      
SLH2051 NVARCHAR VSTRING 120 0 120 UserDefined29 User Defined 29      
SLH2052 NVARCHAR VSTRING 120 0 120 UserDefined30 User Defined 30      
SLH2053 NVARCHAR VSTRING 25 0 25 EndpointID PEPPOL Endpoint ID      
SLH2054 INT INTEGER 0 0 4 EndpointSchemeID PEPPOL EndpointScheme ID      
SLH2055 INT INTEGER 0 0 1 ExportCode Export Code      

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