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

Поле Тип поля Тип поля iScala Длина поля Точ­ность Длина iScala Комментарий Расширенный комментарий Дополнительное описание Пози­ция в инде­ксе Первич­ный ключ?
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 Да
GL03002 NVARCHAR VSTRING 12 0 12 AccountingDimensionCode Accounting Dimension Code   2 Да
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      

Навигация: Структура БД iScala | Epicor iScala 3.00 (x64) - 3.00.02254 | General Ledger | Accounting Dimensions