Не забудьте посетить страницу «Наши услуги» и заказать интеграцию Epicor Service Connect, отчет SSRS или что-то еще... / Be sure to visit our Services page and order an Epicor Service Connect integration, SSRS report, or anything else...

На один уровень вверх / One level Up: Изменение полей в таблицах БД iScala 3.5 по сравнению с iScala 2.2 / Difference between DB structure of iScala 3.5 and iScala 2.2

Изменения структуры таблиц модуля «Долговые обязательства» / Promissory Notes tables structure changes

Название Таблицы / Table Name Описание Таблицы / Table Description Поле / Field Расширенный комментарий / Extended Comment Тип данных / Data Type Длина поля iScala 3.5/ iScala 3.5 Length Точность iScala 3.5/ iScala 3.5 Precision Длина поля iScala 2.2/ iScala 2.2 Length Точность iScala 2.2/ iScala 2.2 Precision Новое поле? / is a New Field?
PN02 PN02 Prom.Notes PN02021 Input Transaction Number NCHAR 9   6  
PN02 PN02 Prom.Notes PN02022 Input Invoice Number NCHAR 25   15  
PN02 PN02 Prom.Notes PN02026 Accounting String Input NVARCHAR 120   50  
PN02 PN02 Prom.Notes PN02029 Output Transaction Number NCHAR 9   6  
PN02 PN02 Prom.Notes PN02030 Output Invoice Number NCHAR 25   15  
PN02 PN02 Prom.Notes PN02032 Accounting String Output NVARCHAR 120   50  
PN02 PN02 Prom.Notes PN02082 Originator/Drawee Bank Address Line 5 NVARCHAR 35   +
PN02 PN02 Prom.Notes PN02083 Originator/Drawee Bank Address Line 6 NVARCHAR 35   +
PN02 PN02 Prom.Notes PN02084 Originator/Drawee Bank Address Line 7 NVARCHAR 35   +
PN02 PN02 Prom.Notes PN02085 Payment Bank Address 5 NVARCHAR 35   +
PN02 PN02 Prom.Notes PN02086 Payment Bank Address 6 NVARCHAR 35   +
PN02 PN02 Prom.Notes PN02087 Payment Bank Address 7 NVARCHAR 35   +
PN02 PN02 Prom.Notes PN02088 Originator/Drawee Country Code NVARCHAR 3   +
PN02 PN02 Prom.Notes PN02089 Payment Country Code NVARCHAR 3   +
PN03 PN03 Partners PN03051 Address Line 5 NVARCHAR 35   +
PN03 PN03 Partners PN03052 Address Line 6 NVARCHAR 35   +
PN03 PN03 Partners PN03053 Address Line 7 NVARCHAR 35   +
PN03 PN03 Partners PN03054 Correspondent Bank Address Line 5 NVARCHAR 35   +
PN03 PN03 Partners PN03055 Correspondent Bank Address Line 6 NVARCHAR 35   +
PN03 PN03 Partners PN03056 Correspondent Bank Address Line 7 NVARCHAR 35   +
PN03 PN03 Partners PN03057 Correspondent Country Code NVARCHAR 3   +
PN04 PN04 Transactions PN04002 Transaction Number NCHAR 9   6  
PN04 PN04 Transactions PN04010 Accounting String NVARCHAR 120   50  
PN06 PN06 Portfolios PN06011 Accounting String Portfolio NVARCHAR 120   50  
PN06 PN06 Portfolios PN06012 Accounting String Stamp Duty NVARCHAR 120   50  
PN06 PN06 Portfolios PN06013 Accounting String Collection Fee NVARCHAR 120   50  
PN06 PN06 Portfolios PN06014 Accounting String Protested NVARCHAR 120   50  
PN06 PN06 Portfolios PN06015 Accounting String Reserved NVARCHAR 120   50  
PN06 PN06 Portfolios PN06016 Accounting String Bank NVARCHAR 120   50  
PN06 PN06 Portfolios PN06017 Accounting String Settlement Profit NVARCHAR 120   50  
PN06 PN06 Portfolios PN06018 Accounting String Settlement Loss NVARCHAR 120   50  
PN06 PN06 Portfolios PN06019 Accounting String Revaluation Profit NVARCHAR 120   50  
PN06 PN06 Portfolios PN06020 Accounting String Revaluation Loss NVARCHAR 120   50  
PN06 PN06 Portfolios PN06035 Accounting String Other NVARCHAR 120   50  
PN17 PN17 Reval.Work PN17005 PortfContStr NVARCHAR 120   50  
PN19 PN19 Bal.Rep.Work PN19006 AdditionInfo NCHAR 6   5  
PN20 PN Invvoices/Notes Cross Reference PN20002 Invoice Number NVARCHAR 25   15  
PN20 PN Invvoices/Notes Cross Reference PN20003 Payment Number NVARCHAR 6   2