Be sure to visit our Services page and order an Epicor Service Connect integration, SSRS report, or anything else... / Не забудьте посетить страницу «Наши услуги» и заказать интеграцию Epicor Service Connect, отчет SSRS или что-то еще...
Таблица | Table: GL16 - «Alpha Transaction Numbers». Маска имени таблицы | Table Name Mask: «GL16%cc%yy»
Поле | Тип поля | Тип поля iScala | Длина поля | Точность | Длина iScala | Комментарий | Расширенный комментарий | Дополнительное описание | Позиция в индексе | Первичный ключ? |
Field | Field Type | iScala Field Type | Field Length | Precision | iScala Length | Comment | Extended Comment | Additional Description | Index Position | Is Primary key? |
GL16001 | NCHAR | STRING | 4 | 0 | 4 | CompYear | Company and Year | 1 | Да / Yes | |
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 | DummyCounter | (obsolete) | |||
GL16033 | NVARCHAR | VSTRING | 12 | 0 | 12 | erracc | Error Correction Account | |||
GL16034 | NVARCHAR | VSTRING | 1 | 0 | 1 | DummyCounter | (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 | Open from Period (CM) | bokPara25 |
Навигация / Shortcut: Структура БД iScala / iScala DB structure | Epicor iScala 2.3 SR3 - 2.03.12787 | General Ledger | General Ledger Parameters 2