One level Up / One level Up: Структура таблиц Epicor iScala 3.0 FSP4 — 3.0.4267 :: Список таблиц модуля «Sales Order»

Структура таблиц Epicor iScala 3.0 FSP4 — 3.0.4267 :: Таблица OR26 — Order Total Amounts History

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

Поле Тип поля Тип поля Scala Длина поля Точ­ность Длина Scala Комментарий Расширенный комментарий Дополнительное описание Пози­ция в инде­ксе Первич­ный ключ?
OR26001 NCHAR STRING 10 0 10 OrderNo Order Number   1 Да
OR26002 NCHAR STRING 15 0 15 InvoiceNo Invoice Number   2 Да
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      

Навигация: