пользователям программных продуктов 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: Структура таблиц Epicor iScala 3.0 FSP4 — 3.0.4267 :: Список таблиц модуля «General Ledger»

Структура таблиц Epicor iScala 3.0 FSP4 — 3.0.4267 :: Таблица GLEB — Extended General Ledger Balance

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

Поле Тип поля Тип поля Scala Длина поля Точ­ность Длина Scala Комментарий Расширенный комментарий Дополнительное описание Пози­ция в инде­ксе Первич­ный ключ?
GLEB001 NCHAR STRING 1 0 1 Type Type   1 Да
GLEB002 NVARCHAR VSTRING 12 0 12 Account Account   2 Да
GLEB003 NVARCHAR VSTRING 12 0 12 Segment 1 Segment 1   3 Да
GLEB004 NVARCHAR VSTRING 12 0 12 Segment 2 Segment 2   4 Да
GLEB005 NVARCHAR VSTRING 12 0 12 Segment 3 Segment 3   5 Да
GLEB006 NVARCHAR VSTRING 12 0 12 Segment 4 Segment 4   6 Да
GLEB007 NVARCHAR VSTRING 12 0 12 Segment 5 Segment 5   7 Да
GLEB008 NVARCHAR VSTRING 12 0 12 Segment 6 Segment 6   8 Да
GLEB009 NVARCHAR VSTRING 12 0 12 Segment 7 Segment 7   9 Да
GLEB010 NVARCHAR VSTRING 12 0 12 Segment 8 Segment 8   10 Да
GLEB011 NVARCHAR VSTRING 12 0 12 Segment 9 Segment 9   11 Да
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      

Навигация: