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

Структура таблиц Epicor iScala 3.0 FSP4 — 3.0.4267 :: Таблица SLUL — Advanced credit control utilized amounts

Таблица: SLUL — «Advanced credit control utilized amounts». Маска имени таблицы: «SLUL%cc00»

Поле Тип поля Тип поля Scala Длина поля Точ­ность Длина Scala Комментарий Расширенный комментарий Дополнительное описание Пози­ция в инде­ксе Первич­ный ключ?
SLUL001 NCHAR STRING 15 0 15 Order No Order No   1 Да
SLUL002 NCHAR STRING 10 0 10 Invoice Customer Invoice Customer   2 Да
SLUL003 INT INTEGER 0 0 1 Source module Source module   3 Да
SLUL004 NUMERIC X_NUMERIC 28 8 20 Ordered Not Delivered Amount Ordered Not Delivered Amount      
SLUL005 NUMERIC X_NUMERIC 28 8 20 Delivered Not Invoiced Amount Delivered Not Invoiced Amount      
SLUL006 NUMERIC X_NUMERIC 28 8 20 Taxes On Ordered Not Shipped Amount Taxes On Ordered Not Shipped Amount      
SLUL007 NUMERIC X_NUMERIC 28 8 20 Additional Costs (Ordered) Additional Costs (Ordered)      
SLUL008 NUMERIC X_NUMERIC 28 8 20 Taxes On Additional Costs (Ordered) Taxes On Additional Costs (Ordered)      
SLUL009 NUMERIC X_NUMERIC 28 8 20 Allocated Not Delivered Amount Allocated Not Delivered Amount      
SLUL010 NUMERIC X_NUMERIC 28 8 20 Taxes On Allocated Not Delivered Amount Taxes On Allocated Not Delivered Amount      
SLUL011 NUMERIC X_NUMERIC 28 8 20 Taxes On Delivered Not Invoiced Amount Taxes On Delivered Not Invoiced Amount      
SLUL012 NUMERIC X_NUMERIC 28 8 20 Additional Costs (Delivered) Additional Costs (Delivered)      
SLUL013 NUMERIC X_NUMERIC 28 8 20 Taxes On Addional Costs (Delivered) Taxes On Addional Costs (Delivered)      
SLUL014 INT INTEGER 0 0 1 Draft flag Draft flag      
SLUL015 DATETIME X_DATETIME 0 0 17 Date of Calculation Date of Calculation      
SLUL016 NUMERIC MONEY 28 8 20 WHTaxesOnOrderedNotShippedLCU WH Taxes On Ordered Not Shipped LCU      
SLUL017 NUMERIC MONEY 28 8 20 WHTaxesOnAddOrderCostsLCU WH Taxes On Add Order Costs LCU      
SLUL018 NUMERIC MONEY 28 8 20 WHTaxesOnAllocNotShippedLCU WH Taxes On Alloc Not Shipped LCU      
SLUL019 NUMERIC MONEY 28 8 20 WHTaxesOnShippedNotInvoicedLCU WH Taxes On Shipped Not Invoiced LCU      
SLUL020 NUMERIC MONEY 28 8 20 WHTaxesOnAddShippedCostsLCU WH Taxes On Add Shipped Costs LCU      

Навигация: