Таблица | Table: GL03 - «Segment Codes». Маска имени таблицы | Table Name Mask: «GL03%cc%yy»

Поле Тип поля Тип поля iScala Длина поля Точ­ность Длина iScala Комментарий Расширенный комментарий Дополнительное описание Пози­ция в инде­ксе Первич­ный ключ?
Field Field Type iScala Field Type Field Length Pre­cision 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 Accounting Dimension Code Accounting Dimension Code   2 Да / Yes
GL03003 NVARCHAR VSTRING 25 0 25 Name Name      
GL03004 NVARCHAR VSTRING 35 0 35 Description1 Description Line 1      
GL03005 NVARCHAR VSTRING 35 0 35 Description2 Description Line 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 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 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      

Навигация / Shortcut: Структура БД iScala / iScala DB structure | Epicor iScala 2.3 SR3 - 2.03.12787 | General Ledger | Accounting Dimensions