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

Структура таблиц / Table structure Epicor iScala 3.3 (x64) — 3.3.0419 :: Таблица / Table GL03 — Accounting Dimensions

Таблица / Table: GL03 — «Segment Codes». Маска имени таблицы / Table name mask: «GL03%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?
GL03001 NVARCHAR VSTRING 1 0 1 RecordType Record Type Accounting dimensions according to company setup

B — Accounting Dimension 1

C — Accounting Dimension 2

D — Accounting Dimension 3

E — Accounting Dimension 4

F — Accounting Dimension 5

G — Accounting Dimension 6

H — Accounting Dimension 7

I — Accounting Dimension 8

J — Accounting Dimension 9		 1 Да / Yes
GL03002 NVARCHAR VSTRING 12 0 12 AccountingDimensionCode Accounting Dimension Code   2 Да / Yes
GL03003 NVARCHAR VSTRING 100 0 100 Name Dimension Name      
GL03004 NVARCHAR VSTRING 100 0 100 Description1 Description 1      
GL03005 NVARCHAR VSTRING 100 0 100 Description2 Description 2      
GL03006 NVARCHAR VSTRING 12 0 12 Manager Manager      
GL03007 NCHAR STRING 1 0 1 ClCostCentr Closed Option 0 — The accounting dimension is open for entries

1 — The accounting dimension is closed for entries but will be copied to next year

2 — The accounting dimension is closed and will not be copied to next year		    
GL03008 NVARCHAR VSTRING 2 0 2 Category Category      
GL03009 NVARCHAR VSTRING 12 0 12 RepLevel1 Reporting Level 1      
GL03010 NVARCHAR VSTRING 12 0 12 RepLevel2 Reporting Level 2      
GL03011 NVARCHAR VSTRING 12 0 12 RepLevel3 Reporting Level 3      
GL03012 NVARCHAR VSTRING 12 0 12 RepLevel4 Reporting Level 4      
GL03013 NVARCHAR VSTRING 12 0 12 RepLevel5 Reporting Level 5      
GL03014 NCHAR STRING 1 0 1 ReportLevel Reporting Level Flag 0 — Not a reporting level

1 — Reporting Level to which subordinate accounting dimensions are to be totalled. No entry of either transactions or a budget can be made to this accounting dimension.		    
GL03015 NCHAR STRING 2 0 2 AccCode Automatic Allocation Number      
GL03016 NCHAR STRING 1 0 1 AutAccrual Automatic Accrual Flag 1 — This accounting dimension are to be accrued and automatically activated in period set in GL03017 and GL03017.

0 — Automatic accrual is not required.		    
GL03017 NVARCHAR VSTRING 12 0 12 AccrualAcc Accrual Account      
GL03018 NVARCHAR VSTRING 2 0 2 AccrualYear Accrual Year      
GL03019 NVARCHAR VSTRING 2 0 2 AccrualPer Accrual Period      
GL03020 NVARCHAR VSTRING 8 0 8 UserGroup User Group      
GL03021 NVARCHAR VSTRING 150 0 150 ExtUserDefFld1 Extended User defined field 1 Ext. User defined field 1    
GL03022 NVARCHAR VSTRING 150 0 150 ExtUserDefFld2 Extended User defined field 2 Ext. User defined field 2    
GL03023 NVARCHAR VSTRING 150 0 150 ExtUserDefFld3 Extended User defined field 3 Ext. User defined field 3    
GL03024 NVARCHAR VSTRING 150 0 150 ExtUserDefFld4 Extended User defined field 4 Ext. User defined field 4    
GL03025 NVARCHAR VSTRING 150 0 150 ExtUserDefFld5 Extended User defined field 5 Ext. User defined field 5    
GL03026 NVARCHAR VSTRING 150 0 150 ExtUserDefFld6 Extended User defined field 6 Ext. User defined field 6    
GL03027 NVARCHAR VSTRING 150 0 150 ExtUserDefFld7 Extended User defined field 7 Ext. User defined field 7    
GL03028 NVARCHAR VSTRING 150 0 150 ExtUserDefFld8 Extended User defined field 8 Ext. User defined field 8    
GL03029 NVARCHAR VSTRING 150 0 150 ExtUserDefFld9 Extended User defined field 9 Ext. User defined field 9    
GL03030 NVARCHAR VSTRING 150 0 150 ExtUserDefFld10 Extended User defined field 10 Ext. User defined field 10    
GL03031 NVARCHAR VSTRING 150 0 150 ExtUserDefFld11 Extended User defined field 11 Ext. User defined field 11    
GL03032 NVARCHAR VSTRING 150 0 150 ExtUserDefFld12 Extended User defined field 12 Ext. User defined field 12    
GL03033 NVARCHAR VSTRING 150 0 150 ExtUserDefFld13 Extended User defined field 13 Ext. User defined field 13    
GL03034 NVARCHAR VSTRING 150 0 150 ExtUserDefFld14 Extended User defined field 14 Ext. User defined field 14    
GL03035 NVARCHAR VSTRING 150 0 150 ExtUserDefFld15 Extended User defined field 15 Ext. User defined field 15    
GL03036 NVARCHAR VSTRING 150 0 150 ExtUserDefFld16 Extended User defined field 16 Ext. User defined field 16    
GL03037 NVARCHAR VSTRING 150 0 150 ExtUserDefFld17 Extended User defined field 17 Ext. User defined field 17    
GL03038 NVARCHAR VSTRING 150 0 150 ExtUserDefFld18 Extended User defined field 18 Ext. User defined field 18    
GL03039 NVARCHAR VSTRING 150 0 150 ExtUserDefFld19 Extended User defined field 19 Ext. User defined field 19    
GL03040 NVARCHAR VSTRING 150 0 150 ExtUserDefFld20 Extended User defined field 20 Ext. User defined field 20    

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