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

Структура таблиц / Table structure Epicor iScala 3.4 (x64) — 3.4.0399 :: Таблица / Table SL45 — Extended Bank Info

Таблица / Table: SL45 — «Extended Bank Info». Маска имени таблицы / Table name mask: «SL45%cc00»

Поле / Field Тип поля / Field Type Тип поля Scala / iScala Field Type Длина поля / Field length Точность / Precision Длина Scala / iScala length Комментарий / Comment Расширенный комментарий / Extended comment Дополнительное описание / Additional description Позиция в индексе / Index position Первичный ключ? / Is Primary key?
SL45001 NCHAR STRING 10 0 10 CustomerCode Customer Code   1 Да / Yes
SL45002 NCHAR STRING 2 0 2 BankNo Bank Code   2 Да / Yes
SL45003 NVARCHAR VSTRING 35 0 35 BankName Bank Name      
SL45004 NVARCHAR VSTRING 11 0 11 ExtBankCode External Bank Code      
SL45005 NCHAR STRING 34 0 34 AccountNo Account Number      
SL45006 NVARCHAR VSTRING 35 0 35 Address1 Address Line 1      
SL45007 NVARCHAR VSTRING 35 0 35 Address2 Address Line 2      
SL45008 NVARCHAR VSTRING 35 0 35 Address3 Address Line 3      
SL45009 NVARCHAR VSTRING 35 0 35 Address4 Address Line 4      
SL45010 NVARCHAR VSTRING 10 0 10 ZipCode Post Code      
SL45011 NVARCHAR VSTRING 20 0 20 Telephone Telephone Number      
SL45012 NVARCHAR VSTRING 20 0 20 Telefax Telefax      
SL45013 NVARCHAR VSTRING 35 0 35 CorrBankName Correspondent Bank Name      
SL45014 NVARCHAR VSTRING 10 0 10 CorreExtCode Correspondent External Bank Code      
SL45015 NVARCHAR VSTRING 34 0 34 CorrespAccNo Correspondent Account Number      
SL45016 NVARCHAR VSTRING 35 0 35 CorrespAddr1 Correspondent Address Line 1      
SL45017 NVARCHAR VSTRING 35 0 35 CorrespAddr2 Correspondent Address Line 2      
SL45018 NVARCHAR VSTRING 35 0 35 CorrespAddr3 Correspondent Address Line 3      
SL45019 NVARCHAR VSTRING 35 0 35 CorrespAddr4 Correspondent Address Line 4      
SL45020 NCHAR STRING 1 0 1 PaymPriority Payment Priority      
SL45021 NVARCHAR VSTRING 35 0 35 Address5 Address Line 5      
SL45022 NVARCHAR VSTRING 35 0 35 Address6 Address Line 6      
SL45023 NVARCHAR VSTRING 35 0 35 Address7 Address Line 7      
SL45024 NVARCHAR VSTRING 35 0 35 CorrespAddr5 Correspondent Address Line 5      
SL45025 NVARCHAR VSTRING 35 0 35 CorrespAddr6 Correspondent Address Line 6      
SL45026 NVARCHAR VSTRING 35 0 35 CorrespAddr7 Correspondent Address Line 7      
SL45027 NCHAR STRING 3 0 3 CountryCode Country Code      
SL45028 NCHAR STRING 3 0 3 CorrespCountryCode Correspondent Country Code      
SL45029 NVARCHAR VSTRING 15 0 15 BIC BIC      
SL45030 NVARCHAR VSTRING 15 0 15 CorrespBIC Correspondent BIC      
SL45031 NCHAR STRING 1 0 1 BankAccType Bank Account Type      
SL45032 NCHAR STRING 1 0 1 DefaultAcc Default Code      
SL45033 INT INTEGER 0 0 2 TaxPaymCurrInvPoint Tax/vat Payment Currency — Invoice Point Currency for calculation of tax/vat payment at the invoice issue moment    
SL45034 INT INTEGER 0 0 2 TaxPaymCurrPaymPoint Tax/vat Payment Currency — Payment Point Currency for calculation of tax/vat payment at the payment moment    
SL45035 NVARCHAR VSTRING 12 0 12 GLTaxPaymAcc GL tax/vat payment account      

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