Таблица | Table: GL53 - «Account Shedule». Маска имени таблицы | Table Name Mask: «GL53%cc%yy»

Поле Тип поля Тип поля iScala Длина поля Точ­ность Длина iScala Комментарий Расширенный комментарий Дополнительное описание Пози­ция в инде­ксе Первич­ный ключ?
Field Field Type iScala Field Type Field Length Pre­cision 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