One level Up / One level Up: Структура таблиц / Table structure Epicor iScala 3.4 (x64) — 3.4.0399 :: Список таблиц модуля /List of tables of module «Sales Order»

Структура таблиц / Table structure Epicor iScala 3.4 (x64) — 3.4.0399 :: Таблица / Table OR26 — Order Total Amounts History

Таблица / Table: OR26 — «Order total amounts». Маска имени таблицы / Table name mask: «OR26%cc00»

Поле / Field Тип поля / Field Type Тип поля Scala / iScala Field Type Длина поля / Field length Точность / Precision Длина Scala / iScala length Комментарий / Comment Расширенный комментарий / Extended comment Дополнительное описание / Additional description Позиция в индексе / Index position Первичный ключ? / Is Primary key?
OR26001 NCHAR STRING 10 0 10 OrderNo Order Number   1 Да / Yes
OR26002 NCHAR STRING 15 0 15 InvoiceNo Invoice Number   2 Да / Yes
OR26003 INT INTEGER 0 0 2 InvoiceCurr Currency Code Invoice      
OR26004 INT INTEGER 0 0 2 OrderCurr Currency Code Order      
OR26005 INT INTEGER 0 0 1 TaxCalcMeth Tax Calculation Method Tax is calculated:

0 — On order line

1 — On total order base amount
   
OR26006 NUMERIC MONEY 28 8 20 OrderTaxTotalAmLCU Taxable Total Amount (Local Currency)      
OR26007 NUMERIC MONEY 28 8 20 OrderTaxTotalAmICU Taxable Total Amount (Invoice Currency)      
OR26008 NUMERIC MONEY 28 8 20 OrderNonTaxTotAmLCU Non Taxable Total Amount (Local Currency)      
OR26009 NUMERIC MONEY 28 8 20 OrderNonTaxTotAmICU Non Taxable Total Amount (Invoice Currency)      
OR26010 NUMERIC MONEY 28 8 20 OrderTotalTaxAmLCU Total Tax Amount (Local Currency)      
OR26011 NUMERIC MONEY 28 8 20 AllowAmICU Allowance Amount (Invoice Currency)      
OR26012 NCHAR STRING 6 0 6 AllowTaxRate Allowance Tax Rate      
OR26013 NUMERIC MONEY 28 8 20 SurchargeAmICU Surcharge Amount (Invoice Currency)      
OR26014 NCHAR STRING 6 0 6 SurchargeTaxRate Surcharge Tax Rate      
OR26015 NUMERIC MONEY 28 8 20 AdvAmount Advance Amount (Invoice Currency)      
OR26016 DATETIME DATE 0 0 8 DeliveryDate Delivery Date      
OR26017 NVARCHAR VSTRING 6 0 6 DelDate Delivery Note Number      
OR26018 NUMERIC X_NUMERIC 18 8 10 InvDateExchRate1 Invoice Date Exchange Rate      
OR26019 NUMERIC X_NUMERIC 18 8 10 InvDateExchRate2 Invoice Date Exchange Rate 2      
OR26020 NCHAR STRING 3 0 3 InvDateExchAlg Invoice Date Exchange Algorithm      

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