Таблица | Table: GL06 - «Transactions». Маска имени таблицы | Table Name Mask: «GL06%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? |
GL06001 | NVARCHAR | ACCSTR | 50 | 0 | 50 | AccStrLCU | Accounting String | |||
GL06002 | NCHAR | STRING | 9 | 0 | 9 | TransactionNo | Transaction Number | |||
GL06003 | DATETIME | DATE | 0 | 0 | 8 | TransactionDate | Transaction Date | |||
GL06004 | NUMERIC | MONEY | 28 | 8 | 20 | AmountLCU | Amount (Local Currency) | |||
GL06005 | NVARCHAR | VSTRING | 25 | 0 | 25 | TransactTxt | Transaction Text | |||
GL06006 | NVARCHAR | VSTRING | 10 | 0 | 10 | CustCode | Customer/Supplier Code | Information depends on GL06012:
3 or 4 - Customer Code 5 or 6 - Supplier Code |
||
GL06007 | NVARCHAR | VSTRING | 23 | 0 | 23 | CodeString | Document Number | Information depends on GL06012:
3 or 4 - Customer Invoice Number 5 or 6 - Supplier Invoice Number Other - Document Number |
||
GL06008 | NVARCHAR | VSTRING | 6 | 0 | 6 | JournalCode | Journal Code | |||
GL06009 | NCHAR | STRING | 1 | 0 | 1 | PeriodAlloc | 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) |
||
GL06010 | NCHAR | STRING | 1 | 0 | 1 | ProjectUpd | Project Updated | 0 - Project Management has not been updated with the transaction line (GL06028 holds a project activity line)
1 - Project Management has been updated with the transaction line (GL06028 holds a project activity line) 2 - Project Management has not been updated with the transaction line (GL06028 holds an activity code) 3 - Project Management has been updated with the transaction line (GL06028 holds an activity code) |
||
GL06011 | NCHAR | STRING | 1 | 0 | 1 | CurrTrans | Currency Transaction | 0 - Standard value
1 - Transaction line is a currency revaluation transaction line 2 - Transaction line is in closing period |
||
GL06012 | BINARY | BINSTRING | 1 | 0 | 1 | TransType | Transaction Type | / - Opening Balances
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 Cheques Transactions (Day-Book Journal) U - Budget Alternative 1 V - Budget Alternative 2 W - Budget Alternative 3 X - Budget Alternative 4 Y - Budget Alternative 5 Z - Budget Previous Year \ - Reporting Level Transaction Opening balances a - Reporting Level Transaction c - Reporting Level Transaction Budget Alternative 1 d - Reporting Level Transaction Budget Alternative 2 e - Reporting Level Transaction Budget Alternative 3 f - Reporting Level Transaction Budget Alternative 4 g - Reporting Level Transaction Budget Alternative 5 h - Reporting Level Transaction Budget Previous Year i - Closing Period Transaction j - Reporting Level Closing Period Transaction k - Year End Closing Transaction | - Transferred Open Balances of Currency Accounts |
||
GL06013 | NVARCHAR | VSTRING | 8 | 0 | 8 | UserIDUpdatedBy | User Id for Update | |||
GL06014 | DATETIME | DATE | 0 | 0 | 8 | EntryDate | Date Entered | |||
GL06015 | NCHAR | STRING | 13 | 0 | 13 | ContraAccount | Contra Account | |||
GL06016 | NCHAR | STRING | 9 | 0 | 9 | RunningCount | Index Key | 1 | Да / Yes | |
GL06017 | NCHAR | STRING | 1 | 0 | 1 | TransactSign | Transaction Sign | 0 - Normal Sign (+ debit, - credit)
1 - Reversed Sign (+ credit, - debit) |
||
GL06018 | NUMERIC | MONEY | 28 | 8 | 20 | AmountOCU | Amount (Document Currency) | |||
GL06019 | NCHAR | STRING | 2 | 0 | 2 | CurrencyCode | Currency Code | |||
GL06020 | NUMERIC | X_NUMERIC | 28 | 8 | 20 | Quantity | Quantity | |||
GL06021 | INT | INTEGER | 0 | 0 | 4 | UnitCode | Unit Code | |||
GL06022 | NUMERIC | MONEY | 28 | 8 | 20 | AmountCCU | Amount (Alternative Currency) | |||
GL06023 | NVARCHAR | VSTRING | 9 | 0 | 9 | JournalNumber | Journal Number | |||
GL06024 | NCHAR | STRING | 9 | 0 | 9 | PLReference | Purchase Invoice Reference Number | |||
GL06025 | NCHAR | STRING | 8 | 0 | 8 | EntByUser | Name of Entry User | |||
GL06026 | DATETIME | DATE | 0 | 0 | 8 | DateOfUpdate | Date Updated | |||
GL06027 | NCHAR | STRING | 6 | 0 | 6 | SubProjectCode | Sub-project Code | |||
GL06028 | NCHAR | STRING | 6 | 0 | 6 | ActivityCode | Activity Code | |||
GL06029 | NCHAR | STRING | 9 | 0 | 9 | LegalTransNo | Legal Transaction Number | |||
GL06030 | NCHAR | STRING | 8 | 0 | 8 | ConsolidFlags | Compound Allocation Flags | A string of 8 characters where each character is a flag between 0 and 3 and it's used to select if the transaction line shall be selected when running the compound allocation. | ||
GL06031 | NCHAR | STRING | 9 | 0 | 9 | LinkdRecCnt | Linked Transaction Line (EMU Conversion) | |||
GL06032 | NVARCHAR | VSTRING | 12 | 0 | 12 | ConsSourceAccount | Consolidation Source Account | |||
GL06033 | NUMERIC | MONEY | 28 | 8 | 20 | ConsSourceAmount | Consolidation Source Amount | |||
GL06034 | NCHAR | STRING | 3 | 0 | 3 | ConsSourceCurrName | Consolidation Source Currency Name | |||
GL06035 | NVARCHAR | VSTRING | 15 | 0 | 15 | GLDrillDownInformation | General Ledger Drill Down Information | Link to journal transaction number in stock control (SCGL) | ||
GL06036 | INT | INTEGER | 0 | 0 | 1 | GLExportFlag | GL Export Flag | |||
GL06037 | NCHAR | STRING | 2 | 0 | 2 | SourceCompany | Source Company | |||
GL06038 | NCHAR | STRING | 2 | 0 | 2 | SourceModule | Source Module | |||
GL06039 | NCHAR | STRING | 8 | 0 | 8 | UserIDPrintedBy | Printed By | |||
GL06040 | DATETIME | DATE | 0 | 0 | 8 | DateOfPrint | Date Printed |
Навигация / Shortcut: Структура БД iScala / iScala DB structure | Epicor iScala 2.3 SR3 - 2.03.12787 | General Ledger | General Ledger Transactions