Таблица | Table: GL53 - «Account Shedule». Маска имени таблицы | Table Name Mask: «GL53%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? |
GL53001 | NVARCHAR | VSTRING | 12 | 0 | 12 | AccountNo | Account | 1 | Да / Yes | |
GL53002 | NVARCHAR | VSTRING | 25 | 0 | 25 | AccountName | Account Name | |||
GL53003 | NVARCHAR | VSTRING | 1 | 0 | 1 | AccountType | Account Type | 0 - Profit & Loss Account
1 - Balance Account 2 - Statistical Account |
||
GL53004 | NVARCHAR | VSTRING | 2 | 0 | 2 | AutomatAlloc | Automat Allocation | |||
GL53005 | NCHAR | STRING | 9 | 0 | 9 | SegmentSw | Accounting Dimension Options | String with on character per accounting dimension (character 1-9 = accounting dimension 1-9):
0 - Accounting dimension is not used for the account 1 - Accounting dimension is mandatory for the account 2 - Accounting dimension is optional for the account |
||
GL53006 | NCHAR | STRING | 1 | 0 | 1 | EntryBlock | Inactive Account | 0 - Active account, allows new entries
1 - Inactive account, no entries can be made (used for accounts to be deleted) 2 - No direct entries is allowed |
||
GL53007 | NCHAR | STRING | 1 | 0 | 1 | BudgetModNo | Default Budget Profile | |||
GL53008 | NUMERIC | MONEY | 28 | 8 | 20 | BookedAm | Current Balance (Local Currency) | |||
GL53009 | NVARCHAR | VSTRING | 2 | 0 | 2 | SubLedgerCode | Sub-Ledger Code | 00 - No sub-ledger
01 - Sales ledger account 02 - Purchase ledger account 03 - Sales ledger with currency account 04 - Purchase ledger with currency account 05 - Asset account 07 - Quantity accounting 08 - Quantity accounting with constant 09 - Currency account type 1 (statistical as secondary account) 10 - Currency account type 2 (statistical as primary account) 11 - Inter-company transactions 12 - Tax transactions 13 - Promissory notes 14 - Analytical ledger 15 - Direct tax transactions 16 - Petty cash-book |
||
GL53010 | NVARCHAR | VSTRING | 40 | 0 | 40 | DescrLine1 | Description Line 1 | |||
GL53011 | NVARCHAR | VSTRING | 40 | 0 | 40 | DescrLine2 | Description Line 2 | |||
GL53012 | NVARCHAR | VSTRING | 40 | 0 | 40 | DescrLine3 | Description Line 3 | |||
GL53013 | NVARCHAR | VSTRING | 50 | 0 | 50 | DefaultSgmt | Default Accounting Dimensions | |||
GL53014 | NVARCHAR | VSTRING | 15 | 0 | 15 | SubLedgPar1 | Sub-Ledger Parameter 1 | Used for sub-ledger code (GL53005), 07 and 08:
Label in dialog asking for quantity |
||
GL53015 | NVARCHAR | VSTRING | 12 | 0 | 12 | SubLedgPar2 | Sub-Ledger Parameter 2 | Usage depends on sub-ledger code (GL53005):
Sub-ledger 07 and 08: Statistical account to hold quantity Sub-ledger 16: Statistical account to hold amount in foreign currency Sub-ledger 03, 04, 09: Statistical account to hold amount in foreign currency or '*' to indicate that the account is linked to multiple statistical accounts, in this case the sub-ledger information is stored in GL5A. Sub-ledger 10: Account to hold amount in local currency |
||
GL53016 | NVARCHAR | VSTRING | 12 | 0 | 12 | SubLedgPar3 | Sub-Ledger Parameter 3 | Used for sub-ledger code (GL53005), 03, 04, 09, 10 and 16:
Profit account for revaluation |
||
GL53017 | NVARCHAR | VSTRING | 12 | 0 | 12 | SubLedgPar4 | Sub-Ledger Parameter 4 | Used for sub ledger code (GL53005) 03, 04, 09, 10 and 16:
Loss account for revaluation |
||
GL53018 | NVARCHAR | VSTRING | 12 | 0 | 12 | SubLedgPar5 | Sub-Ledger Parameter 5 | Only used for Greece: Analytical Ledger Allocation | ||
GL53019 | NVARCHAR | VSTRING | 10 | 0 | 10 | SubLedgPar6 | Sub-Ledger Parameter 6 | Used for sub-ledger code (GL53005), 08:
Constant |
||
GL53020 | NVARCHAR | VSTRING | 10 | 0 | 10 | SubLedgPar7 | Sub-Ledger Parameter 7 | Two first character in string is used for sub-ledger code (GL53005), 09, 10 and 16:
Rate option for debit, first character in string is for debit transaction lines and second character is for credit: 0 - Query menu to adjust the rate at transaction entry. 1 - Debit/Credit transactions are calculated using selling rate for currency. 2 - Debit/Credit transactions are calculated using buying rate for currency. Third character in string used for sub-ledger code (GL53005), 10: 0 - Currency code defined in GL53020 is used on entry of amount. 1 - Alternative currency code can be selected on entry of amount. Character 4-9 in string used for sub-ledger code (GL53005), 10: Valid currencies, (the 30 currencies are packed in-to the 5 character long string) |
||
GL53021 | NVARCHAR | VSTRING | 2 | 0 | 2 | SubLedgPar8 | Sub-Ledger Parameter 8 | Used for-sub-ledger code (GL53005), 03, 04, 09, 10 and 16:
Currency Code |
||
GL53022 | NVARCHAR | VSTRING | 2 | 0 | 2 | SubLedgPar9 | Sub-Ledger Parameter 9 | Used for sub-ledger code (GL53005), 03, 04, 09, 10 and 16:
Revaluation Method: 0 - No revaluation 1 - Only revaluate account when the result is a currency loss. 2 - Revaluate account regardless if the result is a profit or a loss. 3 - Only revaluate account when the result is a currency profit. |
||
GL53023 | NVARCHAR | VSTRING | 20 | 0 | 20 | ExtRepCode | External Report Code | |||
GL53024 | INT | INTEGER | 0 | 0 | 1 | DecimalStat | Number of Decimals (Statistical Accounts) | |||
GL53025 | NVARCHAR | VSTRING | 8 | 0 | 8 | ScalaUserGrp | User Group | |||
GL53026 | NCHAR | STRING | 1 | 0 | 1 | TransfNextYr | Transfer to Next Year (Statistical Accounts) | |||
GL53027 | NVARCHAR | VSTRING | 12 | 0 | 12 | SubLedgPar10 | Sub-Ledger Parameter 10 (Accrual Account) | To be used as alternative account when the currency account is revalue. | ||
GL53028 | NVARCHAR | VSTRING | 1 | 0 | 1 | AccountSubType | Account SubType |
Навигация / Shortcut: Структура БД iScala / iScala DB structure | Epicor iScala 2.3 SR3 - 2.03.12787 | General Ledger | Account Schedule