пользователям программных продуктов Scala 5.0, Scala 5.1, iScala 2.1, iScala 2.2, iScala 2.3, iScala 3.0 (и так далее)

Таблица: 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      

Навигация: Структура БД iScala | Epicor iScala 2.3 SR1 - 2.03.8155 | Sales Order | Order Total Amounts History

TopList

© Алексей Васильев. 2004-2019. При использовании материалов ссылка обязательна.