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 GL11 — Automatic Allocations

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

Поле / Field Тип поля / Field Type Тип поля Scala / iScala Field Type Длина поля / Field length Точность / Precision Длина Scala / iScala length Комментарий / Comment Расширенный комментарий / Extended comment Дополнительное описание / Additional description Позиция в индексе / Index position Первичный ключ? / Is Primary key?
GL11001 NCHAR STRING 3 0 3 AllocationNo Allocation Number The first character defines the accounting dimension:

A — Account

B-J — Accounting Dimension 1-9

Character 2 and 3 defines the allocation number		 1 Да / Yes
GL11002 NVARCHAR VSTRING 40 0 40 Description Description      
GL11003 NVARCHAR VSTRING 12 0 12 AccNumber00 Accounting Dimension Line 0      
GL11004 NCHAR STRING 11 0 11 Percentage00 Percentage Line 0      
GL11005 NVARCHAR VSTRING 12 0 12 AccNumber01 Accounting Dimension Line 1      
GL11006 NCHAR STRING 11 0 11 Percentage01 Percentage Line 1      
GL11007 NVARCHAR VSTRING 12 0 12 AccNumber02 Accounting Dimension Line 2      
GL11008 NCHAR STRING 11 0 11 Percentage02 Percentage Line 2      
GL11009 NVARCHAR VSTRING 12 0 12 AccNumber03 Accounting Dimension Line 3      
GL11010 NCHAR STRING 11 0 11 Percentage03 Percentage Line 3      
GL11011 NVARCHAR VSTRING 12 0 12 AccNumber04 Accounting Dimension Line 4      
GL11012 NCHAR STRING 11 0 11 Percentage04 Percentage Line 4      
GL11013 NVARCHAR VSTRING 12 0 12 AccNumber05 Accounting Dimension Line 5      
GL11014 NCHAR STRING 11 0 11 Percentage05 Percentage Line 5      
GL11015 NVARCHAR VSTRING 12 0 12 AccNumber06 Accounting Dimension Line 6      
GL11016 NCHAR STRING 11 0 11 Percentage06 Percentage Line 6      
GL11017 NVARCHAR VSTRING 12 0 12 AccNumber07 Accounting Dimension Line 7      
GL11018 NCHAR STRING 11 0 11 Percentage07 Percentage Line 7      
GL11019 NVARCHAR VSTRING 12 0 12 AccNumber08 Accounting Dimension Line 8      
GL11020 NCHAR STRING 11 0 11 Percentage08 Percentage Line 8      
GL11021 NVARCHAR VSTRING 12 0 12 AccNumber09 Accounting Dimension Line 9      
GL11022 NCHAR STRING 11 0 11 Percentage09 Percentage Line 9      
GL11023 NVARCHAR VSTRING 12 0 12 AccNumber10 Accounting Dimension Line 10      
GL11024 NCHAR STRING 11 0 11 Percentage10 Percentage Line 10      
GL11025 NVARCHAR VSTRING 12 0 12 AccNumber11 Accounting Dimension Line 11      
GL11026 NCHAR STRING 11 0 11 Percentage11 Percentage Line 11      
GL11027 NVARCHAR VSTRING 12 0 12 AccNumber12 Accounting Dimension Line 12      
GL11028 NCHAR STRING 11 0 11 Percentage12 Percentage Line 12      
GL11029 NVARCHAR VSTRING 12 0 12 AccNumber13 Accounting Dimension Line 13      
GL11030 NCHAR STRING 11 0 11 Percentage13 Percentage Line 13      
GL11031 NVARCHAR VSTRING 12 0 12 AccNumber14 Accounting Dimension Line 14      
GL11032 NCHAR STRING 11 0 11 Percentage14 Percentage Line 14      
GL11033 NVARCHAR VSTRING 12 0 12 AccNumber15 Accounting Dimension Line 15      
GL11034 NCHAR STRING 11 0 11 Percentage15 Percentage Line 15      
GL11035 NVARCHAR VSTRING 12 0 12 AccNumber16 Accounting Dimension Line 16      
GL11036 NCHAR STRING 11 0 11 Percentage16 Percentage Line 16      
GL11037 NVARCHAR VSTRING 12 0 12 AccNumber17 Accounting Dimension Line 17      
GL11038 NCHAR STRING 11 0 11 Percentage17 Percentage Line 17      
GL11039 NVARCHAR VSTRING 12 0 12 AccNumber18 Accounting Dimension Line 18      
GL11040 NCHAR STRING 11 0 11 Percentage18 Percentage Line 18      
GL11041 NVARCHAR VSTRING 12 0 12 AccNumber19 Accounting Dimension Line 19      
GL11042 NCHAR STRING 11 0 11 Percentage19 Percentage Line 19      
GL11043 NVARCHAR VSTRING 12 0 12 AccNumber20 Accounting Dimension Line 20      
GL11044 NCHAR STRING 11 0 11 Percentage20 Percentage Line 20      
GL11045 NVARCHAR VSTRING 12 0 12 AccNumber21 Accounting Dimension Line 21      
GL11046 NCHAR STRING 11 0 11 Percentage21 Percentage Line 21      
GL11047 NVARCHAR VSTRING 12 0 12 AccNumber22 Accounting Dimension Line 22      
GL11048 NCHAR STRING 11 0 11 Percentage22 Percentage Line 22      
GL11049 NVARCHAR VSTRING 12 0 12 AccNumber23 Accounting Dimension Line 23      
GL11050 NCHAR STRING 11 0 11 Percentage23 Percentage Line 23      
GL11051 NVARCHAR VSTRING 12 0 12 AccNumber24 Accounting Dimension Line 24      
GL11052 NCHAR STRING 11 0 11 Percentage24 Percentage Line 24      
GL11053 NVARCHAR VSTRING 12 0 12 AccNumber25 Accounting Dimension Line 25      
GL11054 NCHAR STRING 11 0 11 Percentage25 Percentage Line 25      
GL11055 NVARCHAR VSTRING 12 0 12 AccNumber26 Accounting Dimension Line 26      
GL11056 NCHAR STRING 11 0 11 Percentage26 Percentage Line 26      
GL11057 NVARCHAR VSTRING 12 0 12 AccNumber27 Accounting Dimension Line 27      
GL11058 NCHAR STRING 11 0 11 Percentage27 Percentage Line 27      
GL11059 NVARCHAR VSTRING 12 0 12 AccNumber28 Accounting Dimension Line 28      
GL11060 NCHAR STRING 11 0 11 Percentage28 Percentage Line 28      
GL11061 NVARCHAR VSTRING 12 0 12 AccNumber29 Accounting Dimension Line 29      
GL11062 NCHAR STRING 11 0 11 Percentage29 Percentage Line 29      
GL11063 NVARCHAR VSTRING 12 0 12 AccNumber30 Accounting Dimension Line 30      
GL11064 NCHAR STRING 11 0 11 Percentage30 Percentage Line 30      
GL11065 NVARCHAR VSTRING 12 0 12 AccNumber31 Accounting Dimension Line 31      
GL11066 NCHAR STRING 11 0 11 Percentage31 Percentage Line 31      
GL11067 NVARCHAR VSTRING 12 0 12 AccNumber32 Accounting Dimension Line 32      
GL11068 NCHAR STRING 11 0 11 Percentage32 Percentage Line 32      
GL11069 NVARCHAR VSTRING 12 0 12 AccNumber33 Accounting Dimension Line 33      
GL11070 NCHAR STRING 11 0 11 Percentage33 Percentage Line 33      
GL11071 NVARCHAR VSTRING 12 0 12 AccNumber34 Accounting Dimension Line 34      
GL11072 NCHAR STRING 11 0 11 Percentage34 Percentage Line 34      
GL11073 NVARCHAR VSTRING 12 0 12 AccNumber35 Accounting Dimension Line 35      
GL11074 NCHAR STRING 11 0 11 Percentage35 Percentage Line 35      
GL11075 NVARCHAR VSTRING 12 0 12 AccNumber36 Accounting Dimension Line 36      
GL11076 NCHAR STRING 11 0 11 Percentage36 Percentage Line 36      
GL11077 NVARCHAR VSTRING 12 0 12 AccNumber37 Accounting Dimension Line 37      
GL11078 NCHAR STRING 11 0 11 Percentage37 Percentage Line 37      
GL11079 NVARCHAR VSTRING 12 0 12 AccNumber38 Accounting Dimension Line 38      
GL11080 NCHAR STRING 11 0 11 Percentage38 Percentage Line 38      
GL11081 NVARCHAR VSTRING 12 0 12 AccNumber39 Accounting Dimension Line 39      
GL11082 NCHAR STRING 11 0 11 Percentage39 Percentage Line 39      
GL11083 NVARCHAR VSTRING 12 0 12 AccNumber40 Accounting Dimension Line 40      
GL11084 NCHAR STRING 11 0 11 Percentage40 Percentage Line 40      
GL11085 NVARCHAR VSTRING 12 0 12 AccNumber41 Accounting Dimension Line 41      
GL11086 NCHAR STRING 11 0 11 Percentage41 Percentage Line 41      
GL11087 NVARCHAR VSTRING 12 0 12 AccNumber42 Accounting Dimension Line 42      
GL11088 NCHAR STRING 11 0 11 Percentage42 Percentage Line 42      
GL11089 NVARCHAR VSTRING 12 0 12 AccNumber43 Accounting Dimension Line 43      
GL11090 NCHAR STRING 11 0 11 Percentage43 Percentage Line 43      
GL11091 NVARCHAR VSTRING 12 0 12 AccNumber44 Accounting Dimension Line 44      
GL11092 NCHAR STRING 11 0 11 Percentage44 Percentage Line 44      
GL11093 NVARCHAR VSTRING 12 0 12 AccNumber45 Accounting Dimension Line 45      
GL11094 NCHAR STRING 11 0 11 Percentage45 Percentage Line 45      
GL11095 NVARCHAR VSTRING 12 0 12 AccNumber46 Accounting Dimension Line 46      
GL11096 NCHAR STRING 11 0 11 Percentage46 Percentage Line 46      
GL11097 NVARCHAR VSTRING 12 0 12 AccNumber47 Accounting Dimension Line 47      
GL11098 NCHAR STRING 11 0 11 Percentage47 Percentage Line 47      
GL11099 NVARCHAR VSTRING 12 0 12 AccNumber48 Accounting Dimension Line 48      
GL11100 NCHAR STRING 11 0 11 Percentage48 Percentage Line 48      
GL11101 NVARCHAR VSTRING 12 0 12 AccNumber49 Accounting Dimension Line 49      
GL11102 NCHAR STRING 11 0 11 Percentage49 Percentage Line 49      
GL11103 NVARCHAR VSTRING 12 0 12 AccNumber50 Accounting Dimension Line 50      
GL11104 NCHAR STRING 11 0 11 Percentage50 Percentage Line 50      
GL11105 NVARCHAR VSTRING 12 0 12 AccNumber51 Accounting Dimension Line 51      
GL11106 NCHAR STRING 11 0 11 Percentage51 Percentage Line 51      
GL11107 NVARCHAR VSTRING 12 0 12 AccNumber52 Accounting Dimension Line 52      
GL11108 NCHAR STRING 11 0 11 Percentage52 Percentage Line 52      
GL11109 NVARCHAR VSTRING 12 0 12 AccNumber53 Accounting Dimension Line 53      
GL11110 NCHAR STRING 11 0 11 Percentage 53 Percentage Line 53      
GL11111 NVARCHAR VSTRING 12 0 12 AccNumber 54 Accounting Dimension Line 54      
GL11112 NCHAR STRING 11 0 11 Percentage 54 Percentage Line 54      
GL11113 NVARCHAR VSTRING 12 0 12 AccNumber 55 Accounting Dimension Line 55      
GL11114 NCHAR STRING 11 0 11 Percentage 55 Percentage Line 55      
GL11115 NVARCHAR VSTRING 12 0 12 AccNumber 56 Accounting Dimension Line 56      
GL11116 NCHAR STRING 11 0 11 Percentage 56 Percentage Line 56      
GL11117 NVARCHAR VSTRING 12 0 12 AccNumber 57 Accounting Dimension Line 57      
GL11118 NCHAR STRING 11 0 11 Percentage 57 Percentage Line 57      
GL11119 NVARCHAR VSTRING 12 0 12 AccNumber 58 Accounting Dimension Line 58      
GL11120 NCHAR STRING 11 0 11 Percentage 58 Percentage Line 58      
GL11121 NVARCHAR VSTRING 12 0 12 AccNumber 59 Accounting Dimension Line 59      
GL11122 NCHAR STRING 11 0 11 Percentage 59 Percentage Line 59      
GL11123 NVARCHAR VSTRING 12 0 12 AccNumber 60 Accounting Dimension Line 60      
GL11124 NCHAR STRING 11 0 11 Percentage 60 Percentage Line 60      
GL11125 NVARCHAR VSTRING 12 0 12 AccNumber 61 Accounting Dimension Line 61      
GL11126 NCHAR STRING 11 0 11 Percentage 61 Percentage Line 61      
GL11127 NVARCHAR VSTRING 12 0 12 AccNumber 62 Accounting Dimension Line 62      
GL11128 NCHAR STRING 11 0 11 Percentage 62 Percentage Line 62      
GL11129 NVARCHAR VSTRING 12 0 12 AccNumber 63 Accounting Dimension Line 63      
GL11130 NCHAR STRING 11 0 11 Percentage 63 Percentage Line 63      
GL11131 NVARCHAR VSTRING 12 0 12 AccNumber 64 Accounting Dimension Line 64      
GL11132 NCHAR STRING 11 0 11 Percentage 64 Percentage Line 64      
GL11133 NVARCHAR VSTRING 12 0 12 AccNumber 65 Accounting Dimension Line 65      
GL11134 NCHAR STRING 11 0 11 Percentage 65 Percentage Line 65      
GL11135 NVARCHAR VSTRING 12 0 12 AccNumber 66 Accounting Dimension Line 66      
GL11136 NCHAR STRING 11 0 11 Percentage 66 Percentage Line 66      
GL11137 NVARCHAR VSTRING 12 0 12 AccNumber 67 Accounting Dimension Line 67      
GL11138 NCHAR STRING 11 0 11 Percentage 67 Percentage Line 67      
GL11139 NVARCHAR VSTRING 12 0 12 AccNumber 68 Accounting Dimension Line 68      
GL11140 NCHAR STRING 11 0 11 Percentage 68 Percentage Line 68      
GL11141 NVARCHAR VSTRING 12 0 12 AccNumber 69 Accounting Dimension Line 69      
GL11142 NCHAR STRING 11 0 11 Percentage 69 Percentage Line 69      
GL11143 NVARCHAR VSTRING 12 0 12 AccNumber 70 Accounting Dimension Line 70      
GL11144 NCHAR STRING 11 0 11 Percentage 70 Percentage Line 70      
GL11145 NVARCHAR VSTRING 12 0 12 AccNumber 71 Accounting Dimension Line 71      
GL11146 NCHAR STRING 11 0 11 Percentage 71 Percentage Line 71      
GL11147 NVARCHAR VSTRING 12 0 12 AccNumber 72 Accounting Dimension Line 72      
GL11148 NCHAR STRING 11 0 11 Percentage 72 Percentage Line 72      
GL11149 NVARCHAR VSTRING 12 0 12 AccNumber 73 Accounting Dimension Line 73      
GL11150 NCHAR STRING 11 0 11 Percentage 73 Percentage Line 73      
GL11151 NVARCHAR VSTRING 12 0 12 AccNumber 74 Accounting Dimension Line 74      
GL11152 NCHAR STRING 11 0 11 Percentage 74 Percentage Line 74      
GL11153 NVARCHAR VSTRING 12 0 12 AccNumber 75 Accounting Dimension Line 75      
GL11154 NCHAR STRING 11 0 11 Percentage 75 Percentage Line 75      
GL11155 NVARCHAR VSTRING 12 0 12 AccNumber 76 Accounting Dimension Line 76      
GL11156 NCHAR STRING 11 0 11 Percentage 76 Percentage Line 76      
GL11157 NVARCHAR VSTRING 12 0 12 AccNumber 77 Accounting Dimension Line 77      
GL11158 NCHAR STRING 11 0 11 Percentage 77 Percentage Line 77      
GL11159 NVARCHAR VSTRING 12 0 12 AccNumber 78 Accounting Dimension Line 78      
GL11160 NCHAR STRING 11 0 11 Percentage 78 Percentage Line 78      
GL11161 NVARCHAR VSTRING 12 0 12 AccNumber 79 Accounting Dimension Line 79      
GL11162 NCHAR STRING 11 0 11 Percentage 79 Percentage Line 79      
GL11163 NVARCHAR VSTRING 12 0 12 AccNumber 80 Accounting Dimension Line 80      
GL11164 NCHAR STRING 11 0 11 Percentage 80 Percentage Line 80      
GL11165 NVARCHAR VSTRING 12 0 12 AccNumber 81 Accounting Dimension Line 81      
GL11166 NCHAR STRING 11 0 11 Percentage 81 Percentage Line 81      
GL11167 NVARCHAR VSTRING 12 0 12 AccNumber 82 Accounting Dimension Line 82      
GL11168 NCHAR STRING 11 0 11 Percentage 82 Percentage Line 82      
GL11169 NVARCHAR VSTRING 12 0 12 AccNumber 83 Accounting Dimension Line 83      
GL11170 NCHAR STRING 11 0 11 Percentage 83 Percentage Line 83      
GL11171 NVARCHAR VSTRING 12 0 12 AccNumber 84 Accounting Dimension Line 84      
GL11172 NCHAR STRING 11 0 11 Percentage 84 Percentage Line 84      
GL11173 NVARCHAR VSTRING 12 0 12 AccNumber 85 Accounting Dimension Line 85      
GL11174 NCHAR STRING 11 0 11 Percentage 85 Percentage Line 85      
GL11175 NVARCHAR VSTRING 12 0 12 AccNumber 86 Accounting Dimension Line 86      
GL11176 NCHAR STRING 11 0 11 Percentage 86 Percentage Line 86      
GL11177 NVARCHAR VSTRING 12 0 12 AccNumber 87 Accounting Dimension Line 87      
GL11178 NCHAR STRING 11 0 11 Percentage 87 Percentage Line 87      
GL11179 NVARCHAR VSTRING 12 0 12 AccNumber 88 Accounting Dimension Line 88      
GL11180 NCHAR STRING 11 0 11 Percentage 88 Percentage Line 88      
GL11181 NVARCHAR VSTRING 12 0 12 AccNumber 89 Accounting Dimension Line 89      
GL11182 NCHAR STRING 11 0 11 Percentage 89 Percentage Line 89      
GL11183 NVARCHAR VSTRING 12 0 12 AccNumber 90 Accounting Dimension Line 90      
GL11184 NCHAR STRING 11 0 11 Percentage 90 Percentage Line 90      
GL11185 NVARCHAR VSTRING 12 0 12 AccNumber 91 Accounting Dimension Line 91      
GL11186 NCHAR STRING 11 0 11 Percentage 91 Percentage Line 91      
GL11187 NVARCHAR VSTRING 12 0 12 AccNumber 92 Accounting Dimension Line 92      
GL11188 NCHAR STRING 11 0 11 Percentage 92 Percentage Line 92      
GL11189 NVARCHAR VSTRING 12 0 12 AccNumber 93 Accounting Dimension Line 93      
GL11190 NCHAR STRING 11 0 11 Percentage 93 Percentage Line 93      
GL11191 NVARCHAR VSTRING 12 0 12 AccNumber 94 Accounting Dimension Line 94      
GL11192 NCHAR STRING 11 0 11 Percentage 94 Percentage Line 94      
GL11193 NVARCHAR VSTRING 12 0 12 AccNumber 95 Accounting Dimension Line 95      
GL11194 NCHAR STRING 11 0 11 Percentage 95 Percentage Line 95      
GL11195 NVARCHAR VSTRING 12 0 12 AccNumber 96 Accounting Dimension Line 96      
GL11196 NCHAR STRING 11 0 11 Percentage 96 Percentage Line 96      
GL11197 NVARCHAR VSTRING 12 0 12 AccNumber 97 Accounting Dimension Line 97      
GL11198 NCHAR STRING 11 0 11 Percentage 97 Percentage Line 97      
GL11199 NVARCHAR VSTRING 12 0 12 AccNumber 98 Accounting Dimension Line 98      
GL11200 NCHAR STRING 11 0 11 Percentage 98 Percentage Line 98      
GL11201 NVARCHAR VSTRING 12 0 12 AccNumber 99 Accounting Dimension Line 99      
GL11202 NCHAR STRING 11 0 11 Percentage 99 Percentage Line 99      
GL11203 NVARCHAR VSTRING 12 0 12 SPARE SPARE      
GL11204 NCHAR STRING 11 0 11 SPARE SPARE      

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