Таблица: GLCY - «Petty Cash Transaction File». Маска имени таблицы: «GLCY%cc%yy»
Поле | Тип поля | Тип поля Scala | Длина поля | Точность | Длина Scala | Комментарий | Расширенный комментарий | Дополнительное описание | Позиция в индексе | Первичный ключ? |
GLCY001 | NCHAR | STRING | 8 | 0 | 8 | CashDeskLocation | Cash Office Code | 1 | Да | |
GLCY002 | INT | INTEGER | 0 | 0 | 2 | CashDeskCurrCode | Currency Code Cash Office | 2 | Да | |
GLCY003 | NCHAR | SWITCH | 1 | 0 | 1 | CashDocType | Document Type | 3 | Да | |
GLCY004 | NCHAR | STRING | 6 | 0 | 6 | CashDocNumber | Document Number | 4 | Да | |
GLCY005 | NUMERIC | NUMBER | 20 | 0 | 8 | RecordCounter | Record Number | |||
GLCY006 | NCHAR | STRING | 6 | 0 | 6 | XactionNumber | Transaction Number | |||
GLCY007 | NCHAR | STRING | 5 | 0 | 5 | LineNumber | Line Number | 5 | Да | |
GLCY008 | DATETIME | DATE | 0 | 0 | 8 | XactionDate | Transaction Date | |||
GLCY009 | NCHAR | SWITCH | 1 | 0 | 1 | PrimaryFlag | Primary Line Currency | |||
GLCY010 | NVARCHAR | ACCSTR | 50 | 0 | 50 | AccountingString | Accounting String | |||
GLCY011 | NUMERIC | MONEY | 28 | 8 | 20 | AmountLCU | Amount (Local Currency) | |||
GLCY012 | INT | INTEGER | 0 | 0 | 2 | CurrencyCode | Currency Code Line | |||
GLCY013 | NVARCHAR | ACCSTR | 50 | 0 | 50 | AccountingStringOCU | Accounting String Line Currency | |||
GLCY014 | NUMERIC | MONEY | 28 | 8 | 20 | AmountOCU | Amount (Line Currency) | |||
GLCY015 | NVARCHAR | VSTRING | 25 | 0 | 25 | XactionText | Transaction Line Text | |||
GLCY016 | NCHAR | STRING | 10 | 0 | 10 | Code1 | Customer/Supplier Code | |||
GLCY017 | NVARCHAR | VSTRING | 23 | 0 | 23 | Code2 | Document Number | |||
GLCY018 | NCHAR | STRING | 6 | 0 | 6 | Code3 | Journal Code | |||
GLCY019 | NCHAR | STRING | 2 | 0 | 2 | Code4 | General Ledger Period | |||
GLCY020 | NVARCHAR | VSTRING | 35 | 0 | 35 | Code5 | Foreign Amount (Currency Account) | |||
GLCY021 | NCHAR | STRING | 8 | 0 | 8 | Code6 | Compound Allocation Switches | |||
GLCY022 | 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) |
||
GLCY023 | 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 |
||
GLCY024 | 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 |
||
GLCY025 | NCHAR | STRING | 1 | 0 | 1 | XactionLineType | 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 |
||
GLCY026 | NCHAR | STRING | 1 | 0 | 1 | XactionLineSign | Transaction Sign | 0 - Normal Sign (+ debit, - credit)
1 - Reversed Sign (+ credit, - debit) |
||
GLCY027 | NUMERIC | NUMBER | 20 | 0 | 1 | NOofDecimals | Number of Decimals | |||
GLCY028 | NCHAR | STRING | 5 | 0 | 5 | LinkCode | Link Code | |||
GLCY029 | NUMERIC | X_NUMERIC | 28 | 8 | 20 | Quantity | Quantity | |||
GLCY030 | NCHAR | STRING | 2 | 0 | 2 | UnitCode | Unit Code | |||
GLCY031 | NUMERIC | MONEY | 28 | 8 | 20 | AmountCCU | Amount (Alternative Currency) | |||
GLCY032 | NCHAR | STRING | 13 | 0 | 13 | ContaAccount | Contra Account | |||
GLCY033 | NCHAR | STRING | 6 | 0 | 6 | JournalNumber | Journal Number | |||
GLCY034 | NCHAR | STRING | 6 | 0 | 6 | PLReference | PL Reference | |||
GLCY035 | NCHAR | STRING | 6 | 0 | 6 | SubProjectCode | Sub-Project Number | |||
GLCY036 | NCHAR | STRING | 6 | 0 | 6 | ActivityCode | Activity Code | |||
GLCY037 | NCHAR | STRING | 8 | 0 | 8 | UserID | Entered By | |||
GLCY038 | DATETIME | DATE | 0 | 0 | 8 | DateOfEntry | Date Entered | |||
GLCY039 | NCHAR | STRING | 8 | 0 | 8 | UserIDUpdated | Updated By | |||
GLCY040 | DATETIME | DATE | 0 | 0 | 8 | DateOfUpdate | Date Updated | |||
GLCY041 | NVARCHAR | VSTRING | 25 | 0 | 25 | XactionTextOCU | Transaction Text Line Currency |
Навигация: Структура БД iScala | iScala 2.2 HF 2.3318 - 2.02.3318 | General Ledger | Petty Cash Transaction File