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