пользователям программных продуктов Scala 5.1, iScala 2.1, iScala 2.2, iScala 2.3, iScala 3.0, iScala 3.1, iScala 3.2, iScala 3.3 (и так далее)
На один уровень выше / One level Up: Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Список таблиц модуля «Книга Продаж» / List of tables of module «Sales Ledger»

Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Таблица / Table SLUL — Advanced credit control utilized amounts

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

Поле / Field Тип поля / Field Type Тип поля Scala / iScala Field Type Длина поля / Field length Точность / Precision Длина Scala / iScala length Комментарий / Comment Расширенный комментарий / Extended comment Дополнительное описание / Additional description Позиция в индексе / Index position Первичный ключ? / Is Primary key?
SLUL001 NCHAR STRING 15 0 15 Order No Order No   1 Да / Yes
SLUL002 NCHAR STRING 10 0 10 Invoice Customer Invoice Customer   2 Да / Yes
SLUL003 INT INTEGER 0 0 1 Source module Source module   3 Да / Yes
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      

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