One level Up / One level Up: Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Список таблиц модуля «Главная Книга» / List of tables of module «General Ledger»

Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Таблица / Table GLEB — Extended General Ledger Balance

Таблица / Table: GLEB — «Extended General Ledger Balance». Маска имени таблицы / Table name mask: «GLEB%cc%yy»

Поле / Field Тип поля / Field Type Тип поля Scala / iScala Field Type Длина поля / Field length Точность / Precision Длина Scala / iScala length Комментарий / Comment Расширенный комментарий / Extended comment Дополнительное описание / Additional description Позиция в индексе / Index position Первичный ключ? / Is Primary key?
GLEB001 NCHAR STRING 1 0 1 Type Type   1 Да / Yes
GLEB002 NVARCHAR VSTRING 12 0 12 Account Account   2 Да / Yes
GLEB003 NVARCHAR VSTRING 12 0 12 Segment 1 Segment 1   3 Да / Yes
GLEB004 NVARCHAR VSTRING 12 0 12 Segment 2 Segment 2   4 Да / Yes
GLEB005 NVARCHAR VSTRING 12 0 12 Segment 3 Segment 3   5 Да / Yes
GLEB006 NVARCHAR VSTRING 12 0 12 Segment 4 Segment 4   6 Да / Yes
GLEB007 NVARCHAR VSTRING 12 0 12 Segment 5 Segment 5   7 Да / Yes
GLEB008 NVARCHAR VSTRING 12 0 12 Segment 6 Segment 6   8 Да / Yes
GLEB009 NVARCHAR VSTRING 12 0 12 Segment 7 Segment 7   9 Да / Yes
GLEB010 NVARCHAR VSTRING 12 0 12 Segment 8 Segment 8   10 Да / Yes
GLEB011 NVARCHAR VSTRING 12 0 12 Segment 9 Segment 9   11 Да / Yes
GLEB012 NCHAR STRING 1 0 1 Reporting Level Reporting Level      
GLEB013 NUMERIC MONEY 28 8 20 FY Opening Balance FY Opening Balance      
GLEB014 NUMERIC MONEY 28 8 20 Debit Period 1 Debit Period 1      
GLEB015 NUMERIC MONEY 28 8 20 Debit Period 2 Debit Period 2      
GLEB016 NUMERIC MONEY 28 8 20 Debit Period 3 Debit Period 3      
GLEB017 NUMERIC MONEY 28 8 20 Debit Period 4 Debit Period 4      
GLEB018 NUMERIC MONEY 28 8 20 Debit Period 5 Debit Period 5      
GLEB019 NUMERIC MONEY 28 8 20 Debit Period 6 Debit Period 6      
GLEB020 NUMERIC MONEY 28 8 20 Debit Period 7 Debit Period 7      
GLEB021 NUMERIC MONEY 28 8 20 Debit Period 8 Debit Period 8      
GLEB022 NUMERIC MONEY 28 8 20 Debit Period 9 Debit Period 9      
GLEB023 NUMERIC MONEY 28 8 20 Debit Period 10 Debit Period 10      
GLEB024 NUMERIC MONEY 28 8 20 Debit Period 11 Debit Period 11      
GLEB025 NUMERIC MONEY 28 8 20 Debit Period 12 Debit Period 12      
GLEB026 NUMERIC MONEY 28 8 20 Debit Period 13 Debit Period 13      
GLEB027 NUMERIC MONEY 28 8 20 Debit Period 14 Debit Period 14      
GLEB028 NUMERIC MONEY 28 8 20 Debit Period 15 Debit Period 15      
GLEB029 NUMERIC MONEY 28 8 20 Debit Period 16 Debit Period 16      
GLEB030 NUMERIC MONEY 28 8 20 Debit Period 17 Debit Period 17      
GLEB031 NUMERIC MONEY 28 8 20 Debit Period 18 Debit Period 18      
GLEB032 NUMERIC MONEY 28 8 20 Debit Period 19 Debit Period 19      
GLEB033 NUMERIC MONEY 28 8 20 Debit Period 20 Debit Period 20      
GLEB034 NUMERIC MONEY 28 8 20 Debit Period 21 Debit Period 21      
GLEB035 NUMERIC MONEY 28 8 20 Debit Period 22 Debit Period 22      
GLEB036 NUMERIC MONEY 28 8 20 Debit Period 23 Debit Period 23      
GLEB037 NUMERIC MONEY 28 8 20 Debit Period 24 Debit Period 24      
GLEB038 NUMERIC MONEY 28 8 20 Debit Closing Period Debit Closing Period      
GLEB039 NUMERIC MONEY 28 8 20 Credit Period 1 Credit Period 1      
GLEB040 NUMERIC MONEY 28 8 20 Credit Period 2 Credit Period 2      
GLEB041 NUMERIC MONEY 28 8 20 Credit Period 3 Credit Period 3      
GLEB042 NUMERIC MONEY 28 8 20 Credit Period 4 Credit Period 4      
GLEB043 NUMERIC MONEY 28 8 20 Credit Period 5 Credit Period 5      
GLEB044 NUMERIC MONEY 28 8 20 Credit Period 6 Credit Period 6      
GLEB045 NUMERIC MONEY 28 8 20 Credit Period 7 Credit Period 7      
GLEB046 NUMERIC MONEY 28 8 20 Credit Period 8 Credit Period 8      
GLEB047 NUMERIC MONEY 28 8 20 Credit Period 9 Credit Period 9      
GLEB048 NUMERIC MONEY 28 8 20 Credit Period 10 Credit Period 10      
GLEB049 NUMERIC MONEY 28 8 20 Credit Period 11 Credit Period 11      
GLEB050 NUMERIC MONEY 28 8 20 Credit Period 12 Credit Period 12      
GLEB051 NUMERIC MONEY 28 8 20 Credit Period 13 Credit Period 13      
GLEB052 NUMERIC MONEY 28 8 20 Credit Period 14 Credit Period 14      
GLEB053 NUMERIC MONEY 28 8 20 Credit Period 15 Credit Period 15      
GLEB054 NUMERIC MONEY 28 8 20 Credit Period 16 Credit Period 16      
GLEB055 NUMERIC MONEY 28 8 20 Credit Period 17 Credit Period 17      
GLEB056 NUMERIC MONEY 28 8 20 Credit Period 18 Credit Period 18      
GLEB057 NUMERIC MONEY 28 8 20 Credit Period 19 Credit Period 19      
GLEB058 NUMERIC MONEY 28 8 20 Credit Period 20 Credit Period 20      
GLEB059 NUMERIC MONEY 28 8 20 Credit Period 21 Credit Period 21      
GLEB060 NUMERIC MONEY 28 8 20 Credit Period 22 Credit Period 22      
GLEB061 NUMERIC MONEY 28 8 20 Credit Period 23 Credit Period 23      
GLEB062 NUMERIC MONEY 28 8 20 Credit Period 24 Credit Period 24      
GLEB063 NUMERIC MONEY 28 8 20 Credit Closing Period Credit Closing Period      

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