Название Таблицы / 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 |
|
— |
— |
+ |