One level Up / One level Up: Структура таблиц / Table structure Epicor iScala 3.2 (x64) — 3.2.0317 :: Список таблиц модуля «Главная Книга»/List of tables of module «General Ledger»

Структура таблиц / Table structure Epicor iScala 3.2 (x64) — 3.2.0317 :: Таблица / 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 Company Year   1 Да / Yes
GL10002 NVARCHAR VSTRING 2 0 2 AutoAlloc Next Period for Automatic Allocation      
GL10003 NVARCHAR VSTRING 2 0 2 LowestAccPer Lowest Accounting Period (GL)      
GL10004 DATETIME DATE 0 0 8 DateEmptying Date of Emptying      
GL10005 NVARCHAR VSTRING 2 0 2 NoOfAccPer Number of Accounting Periods      
GL10006 NVARCHAR VSTRING 1 0 1 AccessLevel Access Level      
GL10007 NVARCHAR VSTRING 1 0 1 DummyCounter Dummy Counter      
GL10008 DATETIME DATE 0 0 8 AccPer1Start Account Period 1 Start Date      
GL10009 DATETIME DATE 0 0 8 AccPer1End Account Period 1 End Date      
GL10010 DATETIME DATE 0 0 8 AccPer2Start Account Period 2 Start Date      
GL10011 DATETIME DATE 0 0 8 AccPer2End Account Period 2 End Date      
GL10012 DATETIME DATE 0 0 8 AccPer3Start Account Period 3 Start Date      
GL10013 DATETIME DATE 0 0 8 AccPer3End Account Period 3 End Date      
GL10014 DATETIME DATE 0 0 8 AccPer4Start Account Period 4 Start Date      
GL10015 DATETIME DATE 0 0 8 AccPer4End Account Period 4 End Date      
GL10016 DATETIME DATE 0 0 8 AccPer5Start Account Period 5 Start Date      
GL10017 DATETIME DATE 0 0 8 AccPer5End Account Period 5 End Date      
GL10018 DATETIME DATE 0 0 8 AccPer6Start Account Period 6 Start Date      
GL10019 DATETIME DATE 0 0 8 AccPer6End Account Period 6 End Date      
GL10020 DATETIME DATE 0 0 8 AccPer7Start Account Period 7 Start Date      
GL10021 DATETIME DATE 0 0 8 AccPer7End Account Period 7 End Date      
GL10022 DATETIME DATE 0 0 8 AccPer8Start Account Period 8 Start Date      
GL10023 DATETIME DATE 0 0 8 AccPer8End Account Period 8 End Date      
GL10024 DATETIME DATE 0 0 8 AccPer9Start Account Period 9 Start Date      
GL10025 DATETIME DATE 0 0 8 AccPer9End Account Period 9 End Date      
GL10026 DATETIME DATE 0 0 8 AccPer10St Account Period 10 Start Date      
GL10027 DATETIME DATE 0 0 8 AccPer10End Account Period 10 End Date      
GL10028 DATETIME DATE 0 0 8 AccPer11St Account Period 11 Start Date      
GL10029 DATETIME DATE 0 0 8 AccPer11End Account Period 11 End Date      
GL10030 DATETIME DATE 0 0 8 AccPer12St Account Period 12 Start Date      
GL10031 DATETIME DATE 0 0 8 AccPer12End Account Period 12 End Date      
GL10032 DATETIME DATE 0 0 8 AccPer13St Account Period 13 Start Date      
GL10033 DATETIME DATE 0 0 8 AccPer13End Account Period 13 End Date      
GL10034 DATETIME DATE 0 0 8 AccPer14St Account Period 14 Start Date      
GL10035 DATETIME DATE 0 0 8 AccPer14End Account Period 14 End Date      
GL10036 DATETIME DATE 0 0 8 AccPer15St Account Period 15 Start Date      
GL10037 DATETIME DATE 0 0 8 AccPer15End Account Period 15 End Date      
GL10038 DATETIME DATE 0 0 8 AccPer16St Account Period 16 Start Date      
GL10039 DATETIME DATE 0 0 8 AccPer16End Account Period 16 End Date      
GL10040 DATETIME DATE 0 0 8 AccPer17St Account Period 17 Start Date      
GL10041 DATETIME DATE 0 0 8 AccPer17End Account Period 17 End Date      
GL10042 DATETIME DATE 0 0 8 AccPer18St Account Period 18 Start Date      
GL10043 DATETIME DATE 0 0 8 AccPer18End Account Period 18 End Date      
GL10044 NVARCHAR VSTRING 18 0 18 Switches 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 Account Period 19 Start Date      
GL10046 DATETIME DATE 0 0 8 AccPer19End Account Period 19 End Date      
GL10047 DATETIME DATE 0 0 8 AccPer20St Account Period 20 Start Date      
GL10048 DATETIME DATE 0 0 8 AccPer20End Account Period 20 End Date      
GL10049 DATETIME DATE 0 0 8 AccPer21St Account Period 21 Start Date      
GL10050 DATETIME DATE 0 0 8 AccPer21End Account Period 21 End Date      
GL10051 DATETIME DATE 0 0 8 AccPer22St Account Period 22 Start Date      
GL10052 DATETIME DATE 0 0 8 AccPer22End Account Period 22 End Date      
GL10053 DATETIME DATE 0 0 8 AccPer23St Account Period 23 Start Date      
GL10054 DATETIME DATE 0 0 8 AccPer23End Account Period 23 End Date      
GL10055 DATETIME DATE 0 0 8 AccPer24St Account Period 24 Start Date      
GL10056 DATETIME DATE 0 0 8 AccPer24End Account 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-Off Tolerance Amount      
GL10061 NVARCHAR VSTRING 12 0 12 RoundOffProfitAcc Rounding-Off Profit Account      
GL10062 NVARCHAR VSTRING 12 0 12 RoundOffLossAcc Rounding-Off Loss Account      
GL10063 NCHAR SWITCH 1 0 1 CloseGL Close GL      
GL10064 NCHAR SWITCH 1 0 1 ClosePL Close PL      
GL10065 NCHAR SWITCH 1 0 1 CloseSL Close SL      
GL10066 NCHAR SWITCH 1 0 1 ClosePA Close PA      
GL10067 NCHAR SWITCH 1 0 1 ClosePR Close PR      
GL10068 NCHAR SWITCH 1 0 1 CloseSC Close SC      
GL10069 NCHAR SWITCH 1 0 1 CloseSM Close SM      
GL10070 NCHAR SWITCH 1 0 1 CloseMP Close MP      
GL10071 NVARCHAR VSTRING 256 0 256 GLTransactionsFilePath GL Transactions File Path (Hospitality)      
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 (Revenue Recognition)      
GL10078 NCHAR SWITCH 1 0 1 Automatic transformation at update of journals Auto. transformation at journal update BLiner functionality    
GL10079 NCHAR SWITCH 1 0 1 Use system rules at automatic transformation Use system rules at auto. transformation BLiner functionality    
GL10080 NCHAR SWITCH 1 0 1 AllocationSorting Allocation sorting flag Daybook journal transactions created during execution of compound or periodic automatic allocations in non-condensed mode have transaction lines sorted    
GL10081 NCHAR SWITCH 1 0 1 TaxonomyCodeFlag Taxonomy Code Flag      
GL10082 NCHAR SWITCH 1 0 1 ApplyPartPosting Apply Partial Posting      
GL10083 NCHAR SWITCH 1 0 1 GroupCategoryFlag Group Category Flag      
GL10084 NCHAR SWITCH 1 0 1 AccountPerCashOffice One Account Per Cash Office      

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