Таблица: GL11 - «Automatic Allocations». Маска имени таблицы: «GL11%cc00»

Поле Тип поля Тип поля Scala Длина поля Точ­ность Длина Scala Комментарий Расширенный комментарий Дополнительное описание Пози­ция в инде­ксе Первич­ный ключ?
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 Да
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      

Навигация: Структура БД iScala | iScala 2.2 HF 2.3318 - 2.02.3318 | General Ledger | Automatic Allocations