Не забудьте посетить страницу «Наши услуги» и заказать интеграцию Epicor Service Connect, отчет SSRS или что-то еще... / Be sure to visit our Services page and order an Epicor Service Connect integration, SSRS report, or anything else...
Таблица: GLGL - «GL Consolidation». Маска имени таблицы: «GLGL%cc00»
Поле | Тип поля | Тип поля Scala | Длина поля | Точность | Длина Scala | Комментарий | Расширенный комментарий | Дополнительное описание | Позиция в индексе | Первичный ключ? |
GLGL001 | NCHAR | STRING | 36 | 0 | 36 | JournalID | Journal ID | 1 | Да | |
GLGL002 | NUMERIC | NUMBER | 20 | 0 | 8 | RecCounter | Record Counter | |||
GLGL003 | NCHAR | STRING | 6 | 0 | 6 | TransNum | Transaction Number | 2 | Да | |
GLGL004 | NCHAR | STRING | 5 | 0 | 5 | LineNum | Line Number | 3 | Да | |
GLGL005 | DATETIME | DATE | 0 | 0 | 8 | TransDate | Transaction Date | |||
GLGL006 | NCHAR | SWITCH | 1 | 0 | 1 | Flag | Primary Line Currency | |||
GLGL007 | NVARCHAR | ACCSTR | 50 | 0 | 50 | AccString | Accounting String | |||
GLGL008 | NUMERIC | MONEY | 28 | 8 | 20 | AmountLCU | Amount (Local Currency) | |||
GLGL009 | INT | INTEGER | 0 | 0 | 2 | CurrCode | Currency Code Line | |||
GLGL010 | NVARCHAR | ACCSTR | 50 | 0 | 50 | AccStringOCU | Accounting String Line Currency | |||
GLGL011 | NUMERIC | MONEY | 28 | 8 | 20 | AmountOCU | Amount (Line Currency) | |||
GLGL012 | NVARCHAR | VSTRING | 25 | 0 | 25 | TransText | Transaction Line Text | |||
GLGL013 | NCHAR | STRING | 10 | 0 | 10 | Code1 | Customer/Supplier Code | |||
GLGL014 | NVARCHAR | VSTRING | 23 | 0 | 23 | Code2 | Document Number | |||
GLGL015 | NCHAR | STRING | 6 | 0 | 6 | Code3 | Journal Code | |||
GLGL016 | NCHAR | STRING | 2 | 0 | 2 | Code4 | General Ledger Period | |||
GLGL017 | NVARCHAR | VSTRING | 35 | 0 | 35 | Code5 | Foreign Amount (Currency Account) | |||
GLGL018 | NCHAR | STRING | 8 | 0 | 8 | Code6 | Compound Allocation Switches | |||
GLGL019 | NCHAR | STRING | 1 | 0 | 1 | Tag1 | Period Allocation | 0 - Period allocation has not been executed for the transaction line
1 - Period allocation has been executed for the transaction line 2 - (used with analytical ledger) 3 - (used with analytical ledger) |
||
GLGL020 | NCHAR | STRING | 1 | 0 | 1 | Tag2 | Project Line Type | Only valid of GL07031 and GL07032 has a value:
0 - GL07032 is linked to a project activity line 1 - GL07032 is linked to a activity code |
||
GLGL021 | NCHAR | STRING | 1 | 0 | 1 | Tag3 | Transaction Flag | 0 - Standard value
1 - Transaction line is a currency revaluation transaction line 2 - Transaction line is in closing period |
||
GLGL022 | NCHAR | STRING | 1 | 0 | 1 | TransLineType | Line Type | 0 - Manual Transaction in General Ledger
1 - Reversal Transaction in General Ledger 2 - Accrued Transaction (Periodic Allocation) 3 - Customer Invoice (From Sales Ledger) 4 - Customer Payment (From Sales Ledger) 5 - Supplier Invoice (From Purchase Ledger) 6 - Supplier Payment (From Purchase Ledger) 7 - Depreciation Transaction (From Asset Management) 8 - Automatic Period Allocation 9 - Transaction from Project Management A - Transaction from Payroll B - Transaction from Stock Journal C - Transaction from Promissory Notes D - Petty Cash Transaction K - Fixed Assets Revaluation Transaction L - Cash-Books Transaction M - Transaction from MPC WIP Journal S - Transaction from Source Company (Consolidation) T - Temporary Cheque Transactions (Day-Book Journal) i - Closing Period Transaction k - Year End Closing Transaction | - Transferred Open Balances of Currency Accounts |
||
GLGL023 | NCHAR | STRING | 1 | 0 | 1 | TransLineSign | Transaction Sign | 0 - Normal Sign (+ debit, - credit)
1 - Reversed Sign (+ credit, - debit) |
||
GLGL024 | NUMERIC | NUMBER | 20 | 0 | 1 | NumOfDecimals | Number of Decimals | |||
GLGL025 | NCHAR | STRING | 5 | 0 | 5 | LinkCode | Link Code | |||
GLGL026 | NUMERIC | X_NUMERIC | 28 | 8 | 20 | Quantity | Quantity | |||
GLGL027 | NCHAR | STRING | 2 | 0 | 2 | UnitCode | Unit Code | |||
GLGL028 | NUMERIC | MONEY | 28 | 8 | 20 | AmountCCU | Amount (Alternative Currency) | |||
GLGL029 | NCHAR | STRING | 13 | 0 | 13 | ContraAcc | Contra Account | |||
GLGL030 | NUMERIC | NUMBER | 20 | 0 | 6 | JournalNum | Journal Number | |||
GLGL031 | NCHAR | STRING | 6 | 0 | 6 | PLReference | PL Reference | |||
GLGL032 | NCHAR | STRING | 6 | 0 | 6 | SubPrjCode | Sub-Project Number | |||
GLGL033 | NCHAR | STRING | 6 | 0 | 6 | ActivityCode | Activity Code | |||
GLGL034 | NCHAR | STRING | 8 | 0 | 8 | UsrIDEntBy | Entered By | |||
GLGL035 | DATETIME | DATE | 0 | 0 | 8 | DateOfEntry | Date Entered | |||
GLGL036 | NCHAR | STRING | 8 | 0 | 8 | UsrIDUpdBy | Updated By | |||
GLGL037 | DATETIME | DATE | 0 | 0 | 8 | DateOfUpd | Date Updated | |||
GLGL038 | NVARCHAR | VSTRING | 25 | 0 | 25 | TransTxtOCU | Transaction Text Line Currency |
Навигация: Структура БД iScala | Epicor iScala 2.3 - 2.03.3363 | General Ledger | GL Consolidation