Таблица: PL45 - «Extended Bank Info». Маска имени таблицы: «PL45%cc00»
Поле | Тип поля | Тип поля Scala | Длина поля | Точность | Длина Scala | Комментарий | Расширенный комментарий | Дополнительное описание | Позиция в индексе | Первичный ключ? |
PL45001 | NCHAR | STRING | 10 | 0 | 10 | SupplierCode | Supplier Code | 1 | Да | |
PL45002 | NCHAR | STRING | 2 | 0 | 2 | BankNo | Bank Number | 2 | Да | |
PL45003 | NVARCHAR | VSTRING | 35 | 0 | 35 | BankName | Bank Name | |||
PL45004 | NVARCHAR | VSTRING | 10 | 0 | 10 | ExtBankCode | Extended Bank Code | |||
PL45005 | NVARCHAR | VSTRING | 34 | 0 | 34 | AccountNo | Account Number | |||
PL45006 | NVARCHAR | VSTRING | 35 | 0 | 35 | Address1 | Address Line 1 | |||
PL45007 | NVARCHAR | VSTRING | 35 | 0 | 35 | Address2 | Address Line 2 | |||
PL45008 | NVARCHAR | VSTRING | 35 | 0 | 35 | Address3 | Address Line 3 | |||
PL45009 | NVARCHAR | VSTRING | 35 | 0 | 35 | Address4 | Address Line 4 | |||
PL45010 | NVARCHAR | VSTRING | 10 | 0 | 10 | ZipCode | Zip Code | |||
PL45011 | NVARCHAR | VSTRING | 20 | 0 | 20 | Telephone | Telephone Number | |||
PL45012 | NVARCHAR | VSTRING | 20 | 0 | 20 | Telefax | Telefax Number | |||
PL45013 | NVARCHAR | VSTRING | 35 | 0 | 35 | CorrBankName | Correspondent Bank Name | |||
PL45014 | NVARCHAR | VSTRING | 10 | 0 | 10 | CorreExtCode | Correspondent Bank Extended Code | |||
PL45015 | NVARCHAR | VSTRING | 34 | 0 | 34 | CorrespAccNo | Correspondent Account Number | |||
PL45016 | NVARCHAR | VSTRING | 35 | 0 | 35 | CorrespAddr1 | Correspondent Bank Address Line 1 | |||
PL45017 | NVARCHAR | VSTRING | 35 | 0 | 35 | CorrespAddr2 | Correspondent Bank Address Line 2 | |||
PL45018 | NVARCHAR | VSTRING | 35 | 0 | 35 | CorrespAddr3 | Correspondent Bank Address Line 3 | |||
PL45019 | NVARCHAR | VSTRING | 35 | 0 | 35 | CorrespAddr4 | Correspondent Bank Address Line 4 | |||
PL45020 | NVARCHAR | VSTRING | 1 | 0 | 1 | PaymPriority | Payment Priority |
Навигация: Структура БД iScala | Epicor iScala 2.3 - 2.03.3363 | Purchase Ledger | Extended Bank Info