На один уровень вверх / One level Up: Структура таблиц / Table structure Epicor iScala 3.2 (x64) — 3.2.0317 :: Список таблиц модуля «Главная Книга»/List of tables of module «General Ledger»

Структура таблиц / Table structure Epicor iScala 3.2 (x64) — 3.2.0317 :: Таблица / Table GL09 — Report Layouts

Таблица / Table: GL09 — «Report Layouts». Маска имени таблицы / Table name mask: «GL09%cc00»

Поле / Field Тип поля / Field Type Тип поля Scala / iScala Field Type Длина поля / Field length Точность / Precision Длина Scala / iScala length Комментарий / Comment Расширенный комментарий / Extended comment Дополнительное описание / Additional description Позиция в индексе / Index position Первичный ключ? / Is Primary key?
GL09001 NVARCHAR VSTRING 2 0 2 LayoutNumber Layout Number   1 Да / Yes
GL09002 NVARCHAR VSTRING 25 0 25 Name Name      
GL09003 INT INTEGER 0 0 2 lifno0 Layout Information Number (0)      
GL09004 INT INTEGER 0 0 1 lifpx0 Layout Amount Format (0)      
GL09005 INT INTEGER 0 0 1 lifli0 Layout Line (0)      
GL09006 INT INTEGER 0 0 3 lifpo0 Layout Position (0)      
GL09007 NVARCHAR VSTRING 25 0 25 lifhe10 Layout Head 1 (0)      
GL09008 NVARCHAR VSTRING 25 0 25 lifhe20 Layout Head 2 (0)      
GL09009 NVARCHAR VSTRING 3 0 3 lifhol0 Layout Formula Column (0)      
GL09010 NVARCHAR VSTRING 1 0 1 lifmath0 Layout Formula Operation (0)      
GL09011 NVARCHAR VSTRING 9 0 9 lifop0 Layout Formula Constant (0)      
GL09012 INT INTEGER 0 0 2 lifno1 Layout Information Number (1)      
GL09013 INT INTEGER 0 0 1 lifpx1 Layout Amount Format (1)      
GL09014 INT INTEGER 0 0 1 lifli1 Layout Line (1)      
GL09015 INT INTEGER 0 0 3 lifpo1 Layout Position (1)      
GL09016 NVARCHAR VSTRING 25 0 25 lifhe11 Layout Head 1 (1)      
GL09017 NVARCHAR VSTRING 25 0 25 lifhe21 Layout Head 2 (1)      
GL09018 NVARCHAR VSTRING 3 0 3 lifkol1 Layout Formula Column (1)      
GL09019 NVARCHAR VSTRING 1 0 1 lifmath1 Layout Formula Operation (1)      
GL09020 NVARCHAR VSTRING 9 0 9 lifop1 Layout Formula Constant (1)      
GL09021 INT INTEGER 0 0 2 lifno2 Layout Information Number (2)      
GL09022 INT INTEGER 0 0 1 lifpx2 Layout Amount Format (2)      
GL09023 INT INTEGER 0 0 1 lifli2 Layout Line (2)      
GL09024 INT INTEGER 0 0 3 lifpo2 Layout Position (2)      
GL09025 NVARCHAR VSTRING 25 0 25 lifhe12 Layout Head 1 (2)      
GL09026 NVARCHAR VSTRING 25 0 25 lifhe22 Layout Head 2 (2)      
GL09027 NVARCHAR VSTRING 3 0 3 lifkol2 Layout Formula Column (2)      
GL09028 NVARCHAR VSTRING 1 0 1 lifmath2 Layout Formula Operation (2)      
GL09029 NVARCHAR VSTRING 9 0 9 lifop2 Layout Formula Constant (2)      
GL09030 INT INTEGER 0 0 2 lifno3 Layout Information Number (3)      
GL09031 INT INTEGER 0 0 1 lifpx3 Layout Amount Format (3)      
GL09032 INT INTEGER 0 0 1 lifli3 Layout Line (3)      
GL09033 INT INTEGER 0 0 3 lifpo3 Layout Position (3)      
GL09034 NVARCHAR VSTRING 25 0 25 lifhe13 Layout Head 1 (3)      
GL09035 NVARCHAR VSTRING 25 0 25 lifhe23 Layout Head 2 (3)      
GL09036 NVARCHAR VSTRING 3 0 3 lifkol3 Layout Formula Column (3)      
GL09037 NVARCHAR VSTRING 1 0 1 lifmath3 Layout Formula Operation (3)      
GL09038 NVARCHAR VSTRING 9 0 9 lifop3 Layout Formula Constant (3)      
GL09039 INT INTEGER 0 0 2 lifno4 Layout Information Number (4)      
GL09040 INT INTEGER 0 0 1 lifpx4 Layout Amount Format (4)      
GL09041 INT INTEGER 0 0 1 lifli4 Layout Line (4)      
GL09042 INT INTEGER 0 0 3 lifpo4 Layout Position (4)      
GL09043 NVARCHAR VSTRING 25 0 25 lifhe14 Layout Head 1 (4)      
GL09044 NVARCHAR VSTRING 25 0 25 lifhe24 Layout Head 2 (4)      
GL09045 NVARCHAR VSTRING 3 0 3 lifkol4 Layout Formula Column (4)      
GL09046 NVARCHAR VSTRING 1 0 1 lifmath4 Layout Formula Operation (4)      
GL09047 NVARCHAR VSTRING 9 0 9 lifop4 Layout Formula Constant (4)      
GL09048 INT INTEGER 0 0 2 lifno5 Layout Information Number (5)      
GL09049 INT INTEGER 0 0 1 lifpx5 Layout Amount Format (5)      
GL09050 INT INTEGER 0 0 1 lifli5 Layout Line (5)      
GL09051 INT INTEGER 0 0 3 lifpo5 Layout Position (5)      
GL09052 NVARCHAR VSTRING 25 0 25 lifhe15 Layout Head 1 (5)      
GL09053 NVARCHAR VSTRING 25 0 25 lifhe25 Layout Head 2 (5)      
GL09054 NVARCHAR VSTRING 3 0 3 lifkol5 Layout Formula Column (5)      
GL09055 NVARCHAR VSTRING 1 0 1 lifmath5 Layout Formula Operation (5)      
GL09056 NVARCHAR VSTRING 9 0 9 lifop5 Layout Formula Constant (5)      
GL09057 INT INTEGER 0 0 2 lifno6 Layout Information Number (6)      
GL09058 INT INTEGER 0 0 1 lifpx6 Layout Amount Format (6)      
GL09059 INT INTEGER 0 0 1 lifli6 Layout Line (6)      
GL09060 INT INTEGER 0 0 3 lifpo6 Layout Position (6)      
GL09061 NVARCHAR VSTRING 25 0 25 lifhe16 Layout Head 1 (6)      
GL09062 NVARCHAR VSTRING 25 0 25 lifhe26 Layout Head 2 (6)      
GL09063 NVARCHAR VSTRING 3 0 3 lifkol6 Layout Formula Column (6)      
GL09064 NVARCHAR VSTRING 1 0 1 lifmath6 Layout Formula Operation (6)      
GL09065 NVARCHAR VSTRING 9 0 9 lifop6 Layout Formula Constant (6)      
GL09066 INT INTEGER 0 0 2 lifno7 Layout Information Number (7)      
GL09067 INT INTEGER 0 0 1 lifpx7 Layout Amount Format (7)      
GL09068 INT INTEGER 0 0 1 lifli7 Layout Line (7)      
GL09069 INT INTEGER 0 0 3 lifpo7 Layout Position (7)      
GL09070 NVARCHAR VSTRING 25 0 25 lifhe17 Layout Head 1 (7)      
GL09071 NVARCHAR VSTRING 25 0 25 lifhe27 Layout Head 2 (7)      
GL09072 NVARCHAR VSTRING 3 0 3 lifkol7 Layout Formula Column (7)      
GL09073 NVARCHAR VSTRING 1 0 1 lifmath7 Layout Formula Operation (7)      
GL09074 NVARCHAR VSTRING 9 0 9 lifop7 Layout Formula Constant (7)      
GL09075 INT INTEGER 0 0 2 lifno8 Layout Information Number (8)      
GL09076 INT INTEGER 0 0 1 lifpx8 Layout Amount Format (8)      
GL09077 INT INTEGER 0 0 1 lifli8 Layout Line (8)      
GL09078 INT INTEGER 0 0 3 lifpo8 Layout Position (8)      
GL09079 NVARCHAR VSTRING 25 0 25 lifhe18 Layout Head 1 (8)      
GL09080 NVARCHAR VSTRING 25 0 25 lifhe28 Layout Head 2 (8)      
GL09081 NVARCHAR VSTRING 3 0 3 lifkol8 Layout Formula Column (8)      
GL09082 NVARCHAR VSTRING 1 0 1 lifmath8 Layout Formula Operation (8)      
GL09083 NVARCHAR VSTRING 9 0 9 lifop8 Layout Formula Constant (8)      
GL09084 INT INTEGER 0 0 2 lifno9 Layout Information Number (9)      
GL09085 INT INTEGER 0 0 1 lifpx9 Layout Amount Format (9)      
GL09086 INT INTEGER 0 0 1 lifli9 Layout Line (9)      
GL09087 INT INTEGER 0 0 3 lifpo9 Layout Position (9)      
GL09088 NVARCHAR VSTRING 25 0 25 lifhe19 Layout Head 1 (9)      
GL09089 NVARCHAR VSTRING 25 0 25 lifhe29 Layout Head 2 (9)      
GL09090 NVARCHAR VSTRING 3 0 3 lifkol9 Layout Formula Column (9)      
GL09091 NVARCHAR VSTRING 1 0 1 lifmath9 Layout Formula Operation (9)      
GL09092 NVARCHAR VSTRING 9 0 9 lifop9 Layout Formula Constant (9)      
GL09093 INT INTEGER 0 0 2 lifno10 Layout Information Number (10)      
GL09094 INT INTEGER 0 0 1 lifpx10 Layout Amount Format (10)      
GL09095 INT INTEGER 0 0 1 lifli10 Layout Line (10)      
GL09096 INT INTEGER 0 0 3 lifpo10 Layout Position (10)      
GL09097 NVARCHAR VSTRING 25 0 25 lifhe110 Layout Head 1 (10)      
GL09098 NVARCHAR VSTRING 25 0 25 lifhe210 Layout Head 2 (10)      
GL09099 NVARCHAR VSTRING 3 0 3 lifkol10 Layout Formula Column (10)      
GL09100 NVARCHAR VSTRING 1 0 1 lifmath10 Layout Formula Operation (10)      
GL09101 NVARCHAR VSTRING 9 0 9 lifop10 Layout Formula Constant (10)      
GL09102 INT INTEGER 0 0 2 lifno11 Layout Information Number (11)      
GL09103 INT INTEGER 0 0 1 lifpx11 Layout Amount Format (11)      
GL09104 INT INTEGER 0 0 1 lifli11 Layout Line (11)      
GL09105 INT INTEGER 0 0 3 lifpo11 Layout Position (11)      
GL09106 NVARCHAR VSTRING 25 0 25 lifhe111 Layout Head 1 (11)      
GL09107 NVARCHAR VSTRING 25 0 25 lifhe211 Layout Head 2 (11)      
GL09108 NVARCHAR VSTRING 3 0 3 lifkol11 Layout Formula Column (11)      
GL09109 NVARCHAR VSTRING 1 0 1 lifmath11 Layout Formula Operation (11)      
GL09110 NVARCHAR VSTRING 9 0 9 lifop11 Layout Formula Constant (11)      
GL09111 INT INTEGER 0 0 2 lifno12 Layout Information Number (12)      
GL09112 INT INTEGER 0 0 1 lifpx12 Layout Amount Format (12)      
GL09113 INT INTEGER 0 0 1 lifli12 Layout Line (12)      
GL09114 INT INTEGER 0 0 3 lifpo12 Layout Position (12)      
GL09115 NVARCHAR VSTRING 25 0 25 lifhe112 Layout Head 1 (12)      
GL09116 NVARCHAR VSTRING 25 0 25 lifhe212 Layout Head 2 (12)      
GL09117 NVARCHAR VSTRING 3 0 3 lifkol12 Layout Formula Column (12)      
GL09118 NVARCHAR VSTRING 1 0 1 lifmath12 Layout Formula Operation (12)      
GL09119 NVARCHAR VSTRING 9 0 9 lifop12 Layout Formula Constant (12)      
GL09120 INT INTEGER 0 0 2 lifno13 Layout Information Number (13)      
GL09121 INT INTEGER 0 0 1 lifpx13 Layout Amount Format (13)      
GL09122 INT INTEGER 0 0 1 lifli13 Layout Line (13)      
GL09123 INT INTEGER 0 0 3 lifpo13 Layout Position (13)      
GL09124 NVARCHAR VSTRING 25 0 25 lifhe113 Layout Head 1 (13)      
GL09125 NVARCHAR VSTRING 25 0 25 lifhe213 Layout Head 2 (13)      
GL09126 NVARCHAR VSTRING 3 0 3 lifkol13 Layout Formula Column (13)      
GL09127 NVARCHAR VSTRING 1 0 1 lifmath13 Layout Formula Operation (13)      
GL09128 NVARCHAR VSTRING 9 0 9 lifop13 Layout Formula Constant (13)      
GL09129 NCHAR STRING 2 0 2 Licurr0 Currency Code for Column (0)      
GL09130 NCHAR STRING 2 0 2 Licuurr1 Currency Code for Column (1)      
GL09131 NCHAR STRING 2 0 2 Licurr2 Currency Code for Column (2)      
GL09132 NCHAR STRING 2 0 2 Licurr3 Currency Code for Column (3)      
GL09133 NCHAR STRING 2 0 2 Licurr4 Currency Code for Column (4)      
GL09134 NCHAR STRING 2 0 2 Licurr5 Currency Code for Column (5)      
GL09135 NCHAR STRING 2 0 2 Licurr6 Currency Code for Column (6)      
GL09136 NCHAR STRING 2 0 2 Licurr7 Currency Code for Column (7)      
GL09137 NCHAR STRING 2 0 2 Licurr8 Currency Code for Column (8)      
GL09138 NCHAR STRING 2 0 2 Licurr9 Currency Code for Column (9)      
GL09139 NCHAR STRING 2 0 2 Licurr10 Currency Code for Column (10)      
GL09140 NCHAR STRING 2 0 2 Licurr11 Currency Code for Column (11)      
GL09141 NCHAR STRING 2 0 2 Licurr12 Currency Code for Column (12)      
GL09142 NCHAR STRING 2 0 2 Licurr13 Currency Code for Column (13)      

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