пользователям программных продуктов Scala 5.0, Scala 5.1, iScala 2.1, iScala 2.2, iScala 2.3, iScala 3.0 (и так далее)

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

Поле Тип поля Тип поля iScala Длина поля Точ­ность Длина iScala Комментарий Расширенный комментарий Дополнительное описание Пози­ция в инде­ксе Первич­ный ключ?
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      

Навигация: Структура БД iScala | Epicor iScala 3.00 (x64) - 3.00.02254 | General Ledger | General Ledger Parameters 2

TopList

© Алексей Васильев. 2004-2019. При использовании материалов ссылка обязательна.