One level Up / One level Up: Структура таблиц / Table structure Epicor iScala 3.2 (x64) — 3.2.0317 :: Список таблиц модуля «Прямая выписка счетов»/List of tables of module «Direct Invoicing»

Структура таблиц / Table structure Epicor iScala 3.2 (x64) — 3.2.0317 :: Таблица / Table DI10 — Invoice Head

Таблица / Table: DI10 — «Invoice Head». Маска имени таблицы / Table name mask: «DI10%cc00»

Поле / Field Тип поля / Field Type Тип поля Scala / iScala Field Type Длина поля / Field length Точность / Precision Длина Scala / iScala length Комментарий / Comment Расширенный комментарий / Extended comment Дополнительное описание / Additional description Позиция в индексе / Index position Первичный ключ? / Is Primary key?
DI10001 NCHAR STRING 15 0 15 InvoiceNo Invoice Number   1 Да / Yes
DI10002 NVARCHAR VSTRING 10 0 10 CustCode Customer Code      
DI10003 NVARCHAR VSTRING 25 0 25 OurReference Our Reference      
DI10004 NVARCHAR VSTRING 25 0 25 YourReference Your Reference      
DI10005 NVARCHAR ACCSTR 120 0 120 AccString Accounting String      
DI10006 NVARCHAR VSTRING 2 0 2 PriceList Price List      
DI10007 NVARCHAR VSTRING 2 0 2 PaymentTerm Payment Terms      
DI10008 NUMERIC X_NUMERIC 23 8 15 InvoiceFee Invoice Fee      
DI10009 NUMERIC X_NUMERIC 23 8 15 Freight Freight      
DI10010 NUMERIC X_NUMERIC 14 8 6 Discount Discount Invoice      
DI10011 INT INTEGER 0 0 1 DocStatus Document Status/Type Includes status of document and the type of document:

0 — Normal invoice (not printed)

1 — Credit note (not printed)

2 — Internal invoice (not printed)

3 — Normal invoice (printed)

4 — Credit note (printed)

5 — Internal invoice (printed)
   
DI10012 NVARCHAR VSTRING 2 0 2 CurrencyCode Currency Code      
DI10013 NVARCHAR VSTRING 3 0 3 SalesPerson Salesman      
DI10014 DATETIME DATE 0 0 8 InvoiceDate Invoice Date      
DI10015 DATETIME DATE 0 0 8 DueDate Due Date      
DI10016 NVARCHAR VSTRING 1 0 1 ExportCode Export Code      
DI10017 NCHAR SWITCH 1 0 1 CurrContract Currency Contract      
DI10018 NUMERIC X_NUMERIC 18 8 10 FixedExcRate Fixed Currency Exchange Rate 1      
DI10019 NVARCHAR VSTRING 15 0 15 ContractNo Currency Contract Number      
DI10020 NVARCHAR VSTRING 3 0 3 LanguageCode Language      
DI10021 NCHAR SWITCH 1 0 1 InterestBlock Interest Blocked      
DI10022 NVARCHAR VSTRING 6 0 6 InterLatePmt Interest Late Payment      
DI10023 DATETIME DATE 0 0 8 BEDate Book-Entry Date      
DI10024 NUMERIC X_NUMERIC 18 8 10 FixedExchgRate2 Fixed Currency Exchange Rate 2      
DI10025 NCHAR STRING 3 0 3 FixedExchgAlgtm Fixed Currency Exchange Rate Algorithm      
DI10026 NVARCHAR VSTRING 2 0 2 OrigTermsPayment Orig Terms Payment      
DI10027 NVARCHAR VSTRING 6 0 6 TaxLiabilityCode TaxLiabilityCode This field should contain the Tax Liability Code for invoice    
DI10028 NVARCHAR VSTRING 10 0 10 OperationType OperationType This field should contain the Operation Type for invoice header    
DI10029 NVARCHAR VSTRING 10 0 10 FiscalOperationCode FiscalOperationCode This field should contain the Fiscal Operation Code for invoice header    
DI10030 NCHAR STRING 2 0 2 OwnBankCode1 Own Bank Code 1      
DI10031 NCHAR STRING 2 0 2 OwnBankCode2 Own Bank Code 2      
DI10032 NVARCHAR VSTRING 10 0 10 BankCode1 Bank Code 1      
DI10033 NVARCHAR VSTRING 34 0 34 BankAccount1 Bank Account 1      
DI10034 NVARCHAR VSTRING 10 0 10 BankCode2 Bank Code 2      
DI10035 NVARCHAR VSTRING 34 0 34 BankAccount2 Bank Account 2      

Навигация / Navigation: