Таблица | Table: GL10 - «GL Parameters». Маска имени таблицы | Table Name Mask: «GL10%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?
GL10001 NCHAR STRING 4 0 4 CompYear Index Key   1 Да / Yes
GL10002 NVARCHAR VSTRING 2 0 2 AutoAlloc Next Period Automatic Allocations      
GL10003 NVARCHAR VSTRING 2 0 2 LowestAccPer Open From Period (GL)      
GL10004 DATETIME DATE 0 0 8 DateEmptying Date Transaction File Emptied      
GL10005 NVARCHAR VSTRING 2 0 2 NoOfAccPer Number of Accounting Periods      
GL10006 NVARCHAR VSTRING 1 0 1 AccessLevel (obsolete)      
GL10007 NVARCHAR VSTRING 1 0 1 DummyCounter (obsolete)      
GL10008 DATETIME DATE 0 0 8 AccPer1Start Accounting Period 01 Start Date      
GL10009 DATETIME DATE 0 0 8 AccPer1End Accounting Period 01 End Date      
GL10010 DATETIME DATE 0 0 8 AccPer2Start Accounting Period 02 Start Date      
GL10011 DATETIME DATE 0 0 8 AccPer2End Accounting Period 02 End Date      
GL10012 DATETIME DATE 0 0 8 AccPer3Start Accounting Period 03 Start Date      
GL10013 DATETIME DATE 0 0 8 AccPer3End Accounting Period 03 End Date      
GL10014 DATETIME DATE 0 0 8 AccPer4Start Accounting Period 04 Start Date      
GL10015 DATETIME DATE 0 0 8 AccPer4End Accounting Period 04 End Date      
GL10016 DATETIME DATE 0 0 8 AccPer5Start Accounting Period 05 Start Date      
GL10017 DATETIME DATE 0 0 8 AccPer5End Accounting Period 05 End Date      
GL10018 DATETIME DATE 0 0 8 AccPer6Start Accounting Period 06 Start Date      
GL10019 DATETIME DATE 0 0 8 AccPer6End Accounting Period 06 End Date      
GL10020 DATETIME DATE 0 0 8 AccPer7Start Accounting Period 07 Start Date      
GL10021 DATETIME DATE 0 0 8 AccPer7End Accounting Period 07 End Date      
GL10022 DATETIME DATE 0 0 8 AccPer8Start Accounting Period 08 Start Date      
GL10023 DATETIME DATE 0 0 8 AccPer8End Accounting Period 08 End Date      
GL10024 DATETIME DATE 0 0 8 AccPer9Start Accounting Period 09 Start Date      
GL10025 DATETIME DATE 0 0 8 AccPer9End Accounting Period 09 End Date      
GL10026 DATETIME DATE 0 0 8 AccPer10St Accounting Period 10 Start Date      
GL10027 DATETIME DATE 0 0 8 AccPer10End Accounting Period 10 End Date      
GL10028 DATETIME DATE 0 0 8 AccPer11St Accounting Period 11 Start Date      
GL10029 DATETIME DATE 0 0 8 AccPer11End Accounting Period 11 End Date      
GL10030 DATETIME DATE 0 0 8 AccPer12St Accounting Period 12 Start Date      
GL10031 DATETIME DATE 0 0 8 AccPer12End Accounting Period 12 End Date      
GL10032 DATETIME DATE 0 0 8 AccPer13St Accounting Period 13 Start Date      
GL10033 DATETIME DATE 0 0 8 AccPer13End Accounting Period 13 End Date      
GL10034 DATETIME DATE 0 0 8 AccPer14St Accounting Period 14 Start Date      
GL10035 DATETIME DATE 0 0 8 AccPer14End Accounting Period 14 End Date      
GL10036 DATETIME DATE 0 0 8 AccPer15St Accounting Period 15 Start Date      
GL10037 DATETIME DATE 0 0 8 AccPer15End Accounting Period 15 End Date      
GL10038 DATETIME DATE 0 0 8 AccPer16St Accounting Period 16 Start Date      
GL10039 DATETIME DATE 0 0 8 AccPer16End Accounting Period 16 End Date      
GL10040 DATETIME DATE 0 0 8 AccPer17St Accounting Period 17 Start Date      
GL10041 DATETIME DATE 0 0 8 AccPer17End Accounting Period 17 End Date      
GL10042 DATETIME DATE 0 0 8 AccPer18St Accounting Period 18 Start Date      
GL10043 DATETIME DATE 0 0 8 AccPer18End Accounting Period 18 End Date      
GL10044 NVARCHAR VSTRING 18 0 18 Switches General Ledger Switches Each character in the string is a parameter switch (1-16)
1 - Enter Display Total
2 - Automatic Transaction Number
3 - Reports from Company 01
4 - Report Layouts from Company 01
5 - Journal Control
6 - Obligatory Batch Control
7 - Print Account Summary on Journals
8 - Automatic Error Bookings
17 - Create Projects in Project Module
   
GL10045 DATETIME DATE 0 0 8 AccPer19St Accounting Period 19 Start Date      
GL10046 DATETIME DATE 0 0 8 AccPer19End Accounting Period 19 End Date      
GL10047 DATETIME DATE 0 0 8 AccPer20St Accounting Period 20 Start Date      
GL10048 DATETIME DATE 0 0 8 AccPer20End Accounting Period 20 End Date      
GL10049 DATETIME DATE 0 0 8 AccPer21St Accounting Period 21 Start Date      
GL10050 DATETIME DATE 0 0 8 AccPer21End Accounting Period 21 End Date      
GL10051 DATETIME DATE 0 0 8 AccPer22St Accounting Period 22 Start Date      
GL10052 DATETIME DATE 0 0 8 AccPer22End Accounting Period 22 End Date      
GL10053 DATETIME DATE 0 0 8 AccPer23St Accounting Period 23 Start Date      
GL10054 DATETIME DATE 0 0 8 AccPer23End Accounting Period 23 End Date      
GL10055 DATETIME DATE 0 0 8 AccPer24St Accounting Period 24 Start Date      
GL10056 DATETIME DATE 0 0 8 AccPer24End Accounting Period 24 End Date      
GL10057 DATETIME DATE 0 0 8 ClAccPerSt Closing Period Start Date      
GL10058 DATETIME DATE 0 0 8 ClAccPerEnd Closing Period End Date      
GL10059 NCHAR STRING 6 0 6 ClJourCode Closing Journal Code      
GL10060 NUMERIC MONEY 28 8 20 RoundOffTolerance Rounding Tolerance Limit      
GL10061 NVARCHAR VSTRING 12 0 12 RoundOffProfitAcc Rounding Profit Account      
GL10062 NVARCHAR VSTRING 12 0 12 RoundOffLossAcc Rounding Loss Account      
GL10063 NCHAR SWITCH 1 0 1 CloseGL Close GL Flag      
GL10064 NCHAR SWITCH 1 0 1 ClosePL Close PL Flag      
GL10065 NCHAR SWITCH 1 0 1 CloseSL Close SL Flag      
GL10066 NCHAR SWITCH 1 0 1 ClosePA Close PA Flag      
GL10067 NCHAR SWITCH 1 0 1 Close PR Close PR Flag      
GL10068 NCHAR SWITCH 1 0 1 Close SC Close SC Flag      
GL10069 NCHAR SWITCH 1 0 1 Close SM Close SM Flag      
GL10070 NCHAR SWITCH 1 0 1 Close MP Close MP Flag      
GL10071 NVARCHAR VSTRING 256 0 256 GLTransactionsFilePath GLTransactionsFilePath      
GL10072 INT INTEGER 0 0 9 Journal line counter Journal line counter      
GL10073 NUMERIC MONEY 28 8 20 Journal running total amount Journal running total amount      
GL10074 NCHAR SWITCH 1 0 1 Opening journal printed Opening journal printed      
GL10075 NCHAR SWITCH 1 0 1 Closing journal printed Closing journal printed      
GL10076 DATETIME DATE 0 0 8 Journal closing date Journal closing date      
GL10077 NCHAR SWITCH 1 0 1 Use GL Transaction number Use GL Transaction number      

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