One level Up / One level Up: Структура таблиц Epicor iScala 3.0 FSP4 — 3.0.4267 :: Список таблиц модуля «General Ledger»

Структура таблиц Epicor iScala 3.0 FSP4 — 3.0.4267 :: Таблица GL16 — General Ledger Parameters 2

Таблица: GL16 — «Alpha Transaction Numbers». Маска имени таблицы: «GL16%cc%yy»

Поле Тип поля Тип поля Scala Длина поля Точ­ность Длина Scala Комментарий Расширенный комментарий Дополнительное описание Пози­ция в инде­ксе Первич­ный ключ?
GL16001 NCHAR STRING 4 0 4 CompYear Company and Year   1 Да
GL16002 NVARCHAR VSTRING 1 0 1 DummyCount01 (obsolete)      
GL16003 NVARCHAR VSTRING 1 0 1 DummyCount02 (obsolete)      
GL16004 NVARCHAR VSTRING 1 0 1 DummyCount03 (obsolete)      
GL16005 NVARCHAR VSTRING 1 0 1 DummyCount04 (obsolete)      
GL16006 NVARCHAR VSTRING 1 0 1 DummyCount05 (obsolete)      
GL16007 NVARCHAR VSTRING 1 0 1 DummyCount06 (obsolete)      
GL16008 NVARCHAR VSTRING 1 0 1 DummyCount07 (obsolete)      
GL16009 NVARCHAR VSTRING 1 0 1 DummyCount08 (obsolete)      
GL16010 NVARCHAR VSTRING 1 0 1 DummyCount09 (obsolete)      
GL16011 NVARCHAR VSTRING 1 0 1 DummyCount10 (obsolete)      
GL16012 NVARCHAR VSTRING 1 0 1 DummyCount11 (obsolete)      
GL16013 NVARCHAR VSTRING 1 0 1 DummyCount12 (obsolete)      
GL16014 NVARCHAR VSTRING 1 0 1 DummyCount13 (obsolete)      
GL16015 NVARCHAR VSTRING 1 0 1 DummyCount14 (obsolete)      
GL16016 NVARCHAR VSTRING 1 0 1 DummyCount15 (obsolete)      
GL16017 NVARCHAR VSTRING 1 0 1 DummyCount16 (obsolete)      
GL16018 NVARCHAR VSTRING 1 0 1 DummyCount17 (obsolete)      
GL16019 NVARCHAR VSTRING 1 0 1 DummyCount18 (obsolete)      
GL16020 NVARCHAR VSTRING 1 0 1 DummyCount19 (obsolete)      
GL16021 NVARCHAR VSTRING 1 0 1 DummyCount20 (obsolete)      
GL16022 NVARCHAR VSTRING 1 0 1 DummyCount21 (obsolete)      
GL16023 NVARCHAR VSTRING 1 0 1 DummyCount22 (obsolete)      
GL16024 NVARCHAR VSTRING 1 0 1 DummyCount23 (obsolete)      
GL16025 NVARCHAR VSTRING 1 0 1 DummyCount24 (obsolete)      
GL16026 NVARCHAR VSTRING 1 0 1 DummyCount25 (obsolete)      
GL16027 NVARCHAR VSTRING 1 0 1 DummyCount26 (obsolete)      
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 (obsolete)      
GL16033 NVARCHAR VSTRING 12 0 12 erracc Error Correction Account      
GL16034 NVARCHAR VSTRING 1 0 1 DummyCount28 (obsolete)      
GL16035 NVARCHAR VSTRING 2 0 2 bokPara15 (obsolete)      
GL16036 NVARCHAR VSTRING 2 0 2 bokPara16 Open From Period (SC)      
GL16037 NVARCHAR VSTRING 18 0 18 slask Switch and Parameter Area 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 Account Group 2      
GL16053 NVARCHAR VSTRING 18 0 18 AccGroupNo Number of Account Groups      
GL16054 NVARCHAR VSTRING 18 0 18 LenAccGr1 Length Account Group 1      
GL16055 NVARCHAR VSTRING 18 0 18 LenAccGr3 Length Account Group 3      
GL16056 NVARCHAR VSTRING 18 0 18 bokPara23 (obsolete)      
GL16057 NVARCHAR VSTRING 18 0 18 bokPara24 (obsolete)      
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) Entries      
GL16061 NVARCHAR VSTRING 50 0 50 Curco31to50 Continues Consolidation Target Company 32 — 50      
GL16062 NVARCHAR VSTRING 50 0 50 Curmo31to50 Continues Consolidation Target Currency 32 — 50      
GL16063 NVARCHAR VSTRING 25 0 25 Cursw31to50 Continues Consolidation Rate Option 32 — 50 (SL/PL) Entries      
GL16064 NVARCHAR VSTRING 2 0 2 OpenFromPeriodCM bokPara25      

Навигация: