Не забудьте посетить страницу «Наши услуги» и заказать интеграцию 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

Изменения структуры таблиц модуля «Прямая выписка счетов» / Direct Invoicing 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?
DI01 Stock Item File DI01018 VAT Code NVARCHAR 6   2  
DI01 Stock Item File DI01024 Accounting String NVARCHAR 120   50  
DI03 Invoicing Parameter File DI03005 Normal VAT Code NVARCHAR 6   2  
DI08 Invoice Library File DI08006 VAT Code NVARCHAR 6   2  
DI08 Invoice Library File DI08009 Accounting String NVARCHAR 120   50  
DI08 Invoice Library File DI08014 Accounting Code 2 NCHAR 2   +
DI10 Invoice Head DI10001 Invoice Number NCHAR 15   6  
DI10 Invoice Head DI10003 Our Reference NVARCHAR 35   25  
DI10 Invoice Head DI10004 Your Reference NVARCHAR 35   25  
DI10 Invoice Head DI10005 Accounting String NVARCHAR 120   50  
DI10 Invoice Head DI10026 Orig Terms Payment NVARCHAR 2   +
DI10 Invoice Head DI10027 TaxLiabilityCode NVARCHAR 6   +
DI10 Invoice Head DI10028 OperationType NVARCHAR 10   +
DI10 Invoice Head DI10029 FiscalOperationCode NVARCHAR 10   +
DI10 Invoice Head DI10030 Own Bank Code 1 NCHAR 2   +
DI10 Invoice Head DI10031 Own Bank Code 2 NCHAR 2   +
DI10 Invoice Head DI10032 Bank Code 1 NVARCHAR 10   +
DI10 Invoice Head DI10033 Bank Account 1 NVARCHAR 34   +
DI10 Invoice Head DI10034 Bank Code 2 NVARCHAR 10   +
DI10 Invoice Head DI10035 Bank Account 2 NVARCHAR 34   +
DI10 Invoice Head DI10036 Tax Registration Country NCHAR 3   +
DI11 Invoice Lines DI11001 Invoice Number NCHAR 15   6  
DI11 Invoice Lines DI11006 VAT Code NVARCHAR 6   2  
DI11 Invoice Lines DI11009 Accounting String NVARCHAR 120   50  
DI11 Invoice Lines DI11013 Accounting Code 2 NCHAR 2   +
DI11 Invoice Lines DI11014 Taxation Reason Code NCHAR 3   +
DIH0 Direct Invoice Header History DIH0001 InvoiceNo NCHAR 15   +
DIH0 Direct Invoice Header History DIH0002 CustCode NVARCHAR 10   +
DIH0 Direct Invoice Header History DIH0003 OurReference NVARCHAR 35   +
DIH0 Direct Invoice Header History DIH0004 YourReference NVARCHAR 35   +
DIH0 Direct Invoice Header History DIH0005 AccString NVARCHAR 120   +
DIH0 Direct Invoice Header History DIH0006 PriceList NVARCHAR 2   +
DIH0 Direct Invoice Header History DIH0007 PaymentTerm NVARCHAR 2   +
DIH0 Direct Invoice Header History DIH0008 InvoiceFee NUMERIC 15 8 +
DIH0 Direct Invoice Header History DIH0009 Freight NUMERIC 15 8 +
DIH0 Direct Invoice Header History DIH0010 Discount NUMERIC 6 8 +
DIH0 Direct Invoice Header History DIH0011 DocStatus INT 1   +
DIH0 Direct Invoice Header History DIH0012 CurrencyCode NVARCHAR 2   +
DIH0 Direct Invoice Header History DIH0013 SalesPerson NVARCHAR 3   +
DIH0 Direct Invoice Header History DIH0014 InvoiceDate DATETIME 8   +
DIH0 Direct Invoice Header History DIH0015 DueDate DATETIME 8   +
DIH0 Direct Invoice Header History DIH0016 ExportCode NVARCHAR 1   +
DIH0 Direct Invoice Header History DIH0017 CurrContract NCHAR 1   +
DIH0 Direct Invoice Header History DIH0018 FixedExcRate NUMERIC 10 8 +
DIH0 Direct Invoice Header History DIH0019 ContractNo NVARCHAR 15   +
DIH0 Direct Invoice Header History DIH0020 LanguageCode NVARCHAR 3   +
DIH0 Direct Invoice Header History DIH0021 InterestBlock NCHAR 1   +
DIH0 Direct Invoice Header History DIH0022 InterLatePmt NVARCHAR 6   +
DIH0 Direct Invoice Header History DIH0023 BEDate DATETIME 8   +
DIH0 Direct Invoice Header History DIH0024 FixedExchgRate2 NUMERIC 10 8 +
DIH0 Direct Invoice Header History DIH0025 FixedExchgAlgtm NCHAR 3   +
DIH0 Direct Invoice Header History DIH0026 OrigTermsPayment NVARCHAR 2   +
DIH0 Direct Invoice Header History DIH0027 TaxLiabilityCode NVARCHAR 6   +
DIH0 Direct Invoice Header History DIH0028 OperationType NVARCHAR 10   +
DIH0 Direct Invoice Header History DIH0029 FiscalOperationCode NVARCHAR 10   +
DIH0 Direct Invoice Header History DIH0030 Own Bank Code 1 NCHAR 2   +
DIH0 Direct Invoice Header History DIH0031 Own Bank Code 2 NCHAR 2   +
DIH0 Direct Invoice Header History DIH0032 Bank Code 1 NVARCHAR 10   +
DIH0 Direct Invoice Header History DIH0033 Bank Account 1 NVARCHAR 34   +
DIH0 Direct Invoice Header History DIH0034 Bank Code 2 NVARCHAR 10   +
DIH0 Direct Invoice Header History DIH0035 Bank Account 2 NVARCHAR 34   +
DIH0 Direct Invoice Header History DIH0036 Tax Registration Country NCHAR 3   +
DIH1 Direct Invoice Header History DIH1001 InvoiceNo NCHAR 15   +
DIH1 Direct Invoice Header History DIH1002 LineNumber NCHAR 5   +
DIH1 Direct Invoice Header History DIH1003 LineType INT 1   +
DIH1 Direct Invoice Header History DIH1004 StockCode NVARCHAR 35   +
DIH1 Direct Invoice Header History DIH1005 LineSpecif NVARCHAR 70   +
DIH1 Direct Invoice Header History DIH1006 VATCode NVARCHAR 6   +
DIH1 Direct Invoice Header History DIH1007 AccCode1 NCHAR 2   +
DIH1 Direct Invoice Header History DIH1008 TaxCode INT 1   +
DIH1 Direct Invoice Header History DIH1009 AccString NVARCHAR 120   +
DIH1 Direct Invoice Header History DIH1010 Quantity NUMERIC 12 8 +
DIH1 Direct Invoice Header History DIH1011 Price NUMERIC 20 8 +
DIH1 Direct Invoice Header History DIH1012 Discount NUMERIC 6 8 +
DIH1 Direct Invoice Header History DIH1013 AccCode2 NCHAR 2   +
DIH1 Direct Invoice Header History DIH1014 Taxation Reason Code NCHAR 3   +
DIXY Workf.close Inv DIXY001 CodeString NVARCHAR 120   50  
DIXY Workf.close Inv DIXY005 Rate/VAT Code NVARCHAR 6   +