One level Up / One level Up: Структура таблиц / Table structure Epicor iScala 3.4 (x64) — 3.4.0399 :: Список таблиц модуля /List of tables of module «General Ledger»

Структура таблиц / Table structure Epicor iScala 3.4 (x64) — 3.4.0399 :: Таблица / 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 Segment1 Segment 1   3 Да / Yes
GLEB004 NVARCHAR VSTRING 12 0 12 Segment2 Segment 2   4 Да / Yes
GLEB005 NVARCHAR VSTRING 12 0 12 Segment3 Segment 3   5 Да / Yes
GLEB006 NVARCHAR VSTRING 12 0 12 Segment4 Segment 4   6 Да / Yes
GLEB007 NVARCHAR VSTRING 12 0 12 Segment5 Segment 5   7 Да / Yes
GLEB008 NVARCHAR VSTRING 12 0 12 Segment6 Segment 6   8 Да / Yes
GLEB009 NVARCHAR VSTRING 12 0 12 Segment7 Segment 7   9 Да / Yes
GLEB010 NVARCHAR VSTRING 12 0 12 Segment8 Segment 8   10 Да / Yes
GLEB011 NVARCHAR VSTRING 12 0 12 Segment9 Segment 9   11 Да / Yes
GLEB012 NCHAR STRING 1 0 1 ReportingLevel Reporting Level      
GLEB013 NUMERIC MONEY 28 8 20 FYOpeningBalance FY Opening Balance      
GLEB014 NUMERIC MONEY 28 8 20 DebitPeriod1 Debit Period 1      
GLEB015 NUMERIC MONEY 28 8 20 DebitPeriod2 Debit Period 2      
GLEB016 NUMERIC MONEY 28 8 20 DebitPeriod3 Debit Period 3      
GLEB017 NUMERIC MONEY 28 8 20 DebitPeriod4 Debit Period 4      
GLEB018 NUMERIC MONEY 28 8 20 DebitPeriod5 Debit Period 5      
GLEB019 NUMERIC MONEY 28 8 20 DebitPeriod6 Debit Period 6      
GLEB020 NUMERIC MONEY 28 8 20 DebitPeriod7 Debit Period 7      
GLEB021 NUMERIC MONEY 28 8 20 DebitPeriod8 Debit Period 8      
GLEB022 NUMERIC MONEY 28 8 20 DebitPeriod9 Debit Period 9      
GLEB023 NUMERIC MONEY 28 8 20 DebitPeriod10 Debit Period 10      
GLEB024 NUMERIC MONEY 28 8 20 DebitPeriod11 Debit Period 11      
GLEB025 NUMERIC MONEY 28 8 20 DebitPeriod12 Debit Period 12      
GLEB026 NUMERIC MONEY 28 8 20 DebitPeriod13 Debit Period 13      
GLEB027 NUMERIC MONEY 28 8 20 DebitPeriod14 Debit Period 14      
GLEB028 NUMERIC MONEY 28 8 20 DebitPeriod15 Debit Period 15      
GLEB029 NUMERIC MONEY 28 8 20 DebitPeriod16 Debit Period 16      
GLEB030 NUMERIC MONEY 28 8 20 DebitPeriod17 Debit Period 17      
GLEB031 NUMERIC MONEY 28 8 20 DebitPeriod18 Debit Period 18      
GLEB032 NUMERIC MONEY 28 8 20 DebitPeriod19 Debit Period 19      
GLEB033 NUMERIC MONEY 28 8 20 DebitPeriod20 Debit Period 20      
GLEB034 NUMERIC MONEY 28 8 20 DebitPeriod21 Debit Period 21      
GLEB035 NUMERIC MONEY 28 8 20 DebitPeriod22 Debit Period 22      
GLEB036 NUMERIC MONEY 28 8 20 DebitPeriod23 Debit Period 23      
GLEB037 NUMERIC MONEY 28 8 20 DebitPeriod24 Debit Period 24      
GLEB038 NUMERIC MONEY 28 8 20 DebitClosingPeriod Debit Closing Period      
GLEB039 NUMERIC MONEY 28 8 20 CreditPeriod1 Credit Period 1      
GLEB040 NUMERIC MONEY 28 8 20 CreditPeriod2 Credit Period 2      
GLEB041 NUMERIC MONEY 28 8 20 CreditPeriod3 Credit Period 3      
GLEB042 NUMERIC MONEY 28 8 20 CreditPeriod4 Credit Period 4      
GLEB043 NUMERIC MONEY 28 8 20 CreditPeriod5 Credit Period 5      
GLEB044 NUMERIC MONEY 28 8 20 CreditPeriod6 Credit Period 6      
GLEB045 NUMERIC MONEY 28 8 20 CreditPeriod7 Credit Period 7      
GLEB046 NUMERIC MONEY 28 8 20 CreditPeriod8 Credit Period 8      
GLEB047 NUMERIC MONEY 28 8 20 CreditPeriod9 Credit Period 9      
GLEB048 NUMERIC MONEY 28 8 20 CreditPeriod10 Credit Period 10      
GLEB049 NUMERIC MONEY 28 8 20 CreditPeriod11 Credit Period 11      
GLEB050 NUMERIC MONEY 28 8 20 CreditPeriod12 Credit Period 12      
GLEB051 NUMERIC MONEY 28 8 20 CreditPeriod13 Credit Period 13      
GLEB052 NUMERIC MONEY 28 8 20 CreditPeriod14 Credit Period 14      
GLEB053 NUMERIC MONEY 28 8 20 CreditPeriod15 Credit Period 15      
GLEB054 NUMERIC MONEY 28 8 20 CreditPeriod16 Credit Period 16      
GLEB055 NUMERIC MONEY 28 8 20 CreditPeriod17 Credit Period 17      
GLEB056 NUMERIC MONEY 28 8 20 CreditPeriod18 Credit Period 18      
GLEB057 NUMERIC MONEY 28 8 20 CreditPeriod19 Credit Period 19      
GLEB058 NUMERIC MONEY 28 8 20 CreditPeriod20 Credit Period 20      
GLEB059 NUMERIC MONEY 28 8 20 CreditPeriod21 Credit Period 21      
GLEB060 NUMERIC MONEY 28 8 20 CreditPeriod22 Credit Period 22      
GLEB061 NUMERIC MONEY 28 8 20 CreditPeriod23 Credit Period 23      
GLEB062 NUMERIC MONEY 28 8 20 CreditPeriod24 Credit Period 24      
GLEB063 NUMERIC MONEY 28 8 20 CreditClosingPeriod Credit Closing Period      

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