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

Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Таблица / Table GL10 — General Ledger Parameters

Таблица / Table: GL10 — «GL Parameters». Маска имени таблицы / Table name mask: «GL10%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?
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 ClosePR Close PR Flag      
GL10068 NCHAR SWITCH 1 0 1 CloseSC Close SC Flag      
GL10069 NCHAR SWITCH 1 0 1 CloseSM Close SM Flag      
GL10070 NCHAR SWITCH 1 0 1 CloseMP Close MP Flag      
GL10071 NVARCHAR VSTRING 256 0 256 GLTransactionsFilePath GLTransactionsFilePath      
GL10072 INT INTEGER 0 0 9 JournalLineCounter Journal line counter      
GL10073 NUMERIC MONEY 28 8 20 JournalRunningTotalAmnt Journal running total amount      
GL10074 NCHAR SWITCH 1 0 1 OpeningJournalPrinted Opening journal printed      
GL10075 NCHAR SWITCH 1 0 1 ClosingJournalPrinted Closing journal printed      
GL10076 DATETIME DATE 0 0 8 JournalCloseDate Journal closing date      
GL10077 NCHAR SWITCH 1 0 1 UseGLTransNum Use GL Transaction number      
GL10078 NCHAR SWITCH 1 0 1 Automatic transformation at update of journals Automatic transformation at update of journals BLiner functionality    
GL10079 NCHAR SWITCH 1 0 1 Use system rules at automatic transformation Use system rules at automatic transformation BLiner functionality    
GL10080 NCHAR SWITCH 1 0 1 Allocation Sorting Allocation Sorting Daybook journal transactions created during execution of compound or periodic automatic allocations in non-condensed mode have transaction lines sorted    

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