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

Структура таблиц / Table structure Epicor iScala 3.5 (x64) — 3.5.0429 :: Таблица / Table GL16 — General Ledger Parameters 2

Таблица / Table: GL16 — «Alpha Transaction Numbers». Маска имени таблицы / Table name mask: «GL16%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?
GL16001 NCHAR STRING 4 0 4 CompYear Company Year   1 Да / Yes
GL16002 NVARCHAR VSTRING 1 0 1 DummyCount01 Counter A (Dummy Counter 01)      
GL16003 NVARCHAR VSTRING 1 0 1 DummyCount02 Counter B (Dummy Counter 02)      
GL16004 NVARCHAR VSTRING 1 0 1 DummyCount03 Counter C (Dummy Counter 03)      
GL16005 NVARCHAR VSTRING 1 0 1 DummyCount04 Counter D (Dummy Counter 04)      
GL16006 NVARCHAR VSTRING 1 0 1 DummyCount05 Counter E (Dummy Counter 05)      
GL16007 NVARCHAR VSTRING 1 0 1 DummyCount06 Counter F (Dummy Counter 06)      
GL16008 NVARCHAR VSTRING 1 0 1 DummyCount07 Counter G (Dummy Counter 07)      
GL16009 NVARCHAR VSTRING 1 0 1 DummyCount08 Counter H (Dummy Counter 08)      
GL16010 NVARCHAR VSTRING 1 0 1 DummyCount09 Counter I (Dummy Counter 09)      
GL16011 NVARCHAR VSTRING 1 0 1 DummyCount10 Counter J (Dummy Counter 10)      
GL16012 NVARCHAR VSTRING 1 0 1 DummyCount11 Counter K (Dummy Counter 11)      
GL16013 NVARCHAR VSTRING 1 0 1 DummyCount12 Counter L (Dummy Counter 12)      
GL16014 NVARCHAR VSTRING 1 0 1 DummyCount13 Counter M (Dummy Counter 13)      
GL16015 NVARCHAR VSTRING 1 0 1 DummyCount14 Counter N (Dummy Counter 14)      
GL16016 NVARCHAR VSTRING 1 0 1 DummyCount15 Counter O (Dummy Counter 15)      
GL16017 NVARCHAR VSTRING 1 0 1 DummyCount16 Counter P (Dummy Counter 16)      
GL16018 NVARCHAR VSTRING 1 0 1 DummyCount17 Counter Q (Dummy Counter 17)      
GL16019 NVARCHAR VSTRING 1 0 1 DummyCount18 Counter R (Dummy Counter 18)      
GL16020 NVARCHAR VSTRING 1 0 1 DummyCount19 Counter S (Dummy Counter 19)      
GL16021 NVARCHAR VSTRING 1 0 1 DummyCount20 Counter T (Dummy Counter 20      
GL16022 NVARCHAR VSTRING 1 0 1 DummyCount21 Counter U (Dummy Counter 21)      
GL16023 NVARCHAR VSTRING 1 0 1 DummyCount22 Counter V (Dummy Counter 22)      
GL16024 NVARCHAR VSTRING 1 0 1 DummyCount23 Counter W (Dummy Counter 23)      
GL16025 NVARCHAR VSTRING 1 0 1 DummyCount24 Counter X (Dummy Counter 24)      
GL16026 NVARCHAR VSTRING 1 0 1 DummyCount25 Counter Y (Dummy Counter 25)      
GL16027 NVARCHAR VSTRING 1 0 1 DummyCount26 Counter Z (Dummy Counter 26)      
GL16028 NVARCHAR VSTRING 2 0 2 bokPara08 Open from Period PL      
GL16029 NVARCHAR VSTRING 2 0 2 bokPara09 Open from Period SL      
GL16030 NVARCHAR VSTRING 2 0 2 bokPara10 Open from Period PA      
GL16031 NVARCHAR VSTRING 2 0 2 bokPara11 Open from Period PR      
GL16032 NVARCHAR VSTRING 1 0 1 DummyCount27 Daybook Journal Number (Dummy Counter 27)      
GL16033 NVARCHAR VSTRING 12 0 12 erracc Account for Automatic Error Booking      
GL16034 NVARCHAR VSTRING 1 0 1 DummyCount28 Cash Book Transaction Number (Dummy Counter 28)      
GL16035 NVARCHAR VSTRING 2 0 2 bokPara15 Book Parameter 15      
GL16036 NVARCHAR VSTRING 2 0 2 bokPara16 Open from period SC      
GL16037 NVARCHAR VSTRING 18 0 18 slask Switches Each characters in the string is a parameter switch (1-16),

1 — Enter Journal Codes

2 — Enter Document Number

3 — Automatic Backup (not used)

4 — Create Reporting Level Transactions

5 — 2D Ledger (not used)

6 — Allow Alphanumeric Account Numbers

7 — Automatic Reversal Transactions (Counter R)

8 — Mark Reversed Transactions

9 — Continues Consolidation Rate Option 1 (SL/PL) Entries

10 — Continues Consolidation Rate Option 2 (SL/PL) Entries

11 — Continues Consolidation Rate Option 3 (SL/PL) Entries

12 — Continues Consolidation Rate Option 4 (SL/PL) Entries

13 — Continues Consolidation Rate Option 5 (SL/PL) Entries

14 — Continues Consolidation Rate Option 6 (SL/PL) Entries
   
GL16038 NVARCHAR VSTRING 2 0 2 curco0 Continues Consolidation Target Company 1      
GL16039 NVARCHAR VSTRING 2 0 2 curco1 Continues Consolidation Target Company 2      
GL16040 NVARCHAR VSTRING 2 0 2 curco2 Continues Consolidation Target Company 3      
GL16041 NVARCHAR VSTRING 2 0 2 curco3 Continues Consolidation Target Company 4      
GL16042 NVARCHAR VSTRING 2 0 2 curco4 Continues Consolidation Target Company 5      
GL16043 NVARCHAR VSTRING 2 0 2 curco5 Continues Consolidation Target Company 6      
GL16044 NVARCHAR VSTRING 2 0 2 curmo0 Continues Consolidation Target Currency 1      
GL16045 NVARCHAR VSTRING 2 0 2 curmo1 Continues Consolidation Target Currency 2      
GL16046 NVARCHAR VSTRING 2 0 2 curmo2 Continues Consolidation Target Currency 3      
GL16047 NVARCHAR VSTRING 2 0 2 curmo3 Continues Consolidation Target Currency 4      
GL16048 NVARCHAR VSTRING 2 0 2 curmo4 Continues Consolidation Target Currency 5      
GL16049 NVARCHAR VSTRING 2 0 2 curmo5 Continues Consolidation Target Currency 6      
GL16050 NVARCHAR VSTRING 2 0 2 bokPara17 Open from Period SM      
GL16051 NVARCHAR VSTRING 2 0 2 bokPara18 Open from Period MP      
GL16052 NVARCHAR VSTRING 18 0 18 LenAccGr2 Length of Account Group 2      
GL16053 NVARCHAR VSTRING 18 0 18 AccGroupNo Number of Account Group      
GL16054 NVARCHAR VSTRING 18 0 18 LenAccGr1 Length of Account Group 1      
GL16055 NVARCHAR VSTRING 18 0 18 LenAccGr3 Length of Account Group 3      
GL16056 NVARCHAR VSTRING 18 0 18 bokPara23 Book Parameter 23      
GL16057 NVARCHAR VSTRING 18 0 18 bokPara24 Book Parameter 24      
GL16058 NVARCHAR VSTRING 50 0 50 Curco6to30 Continues Consolidation Target Company 7-31      
GL16059 NVARCHAR VSTRING 50 0 50 Curmo6to30 Continues Consolidation Target Currency 7-31      
GL16060 NVARCHAR VSTRING 25 0 25 Cursw6to30 Continues Consolidation Rate Option 7-31 (SL/PL)      
GL16061 NVARCHAR VSTRING 50 0 50 Curco31to50 Continues Consolidation Target Company 32-50      
GL16062 NVARCHAR VSTRING 50 0 50 Curmo31to50 Continues Consolidation Target Currency 33-50      
GL16063 NVARCHAR VSTRING 25 0 25 Cursw31to50 Continues Consolidation Rate Option 32-50 (SL/PL)      
GL16064 NVARCHAR VSTRING 2 0 2 OpenFromPeriodCM Open from Period CM      

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