One level Up / One level Up: Структура таблиц / Table structure Epicor iScala 3.4 (x64) — 3.4.0399 :: Список таблиц модуля /List of tables of module «General Ledger»

Структура таблиц / Table structure Epicor iScala 3.4 (x64) — 3.4.0399 :: Таблица / Table GL53 — Account Schedule

Таблица / Table: GL53 — «Account Shedule». Маска имени таблицы / Table name mask: «GL53%cc%yy»

Поле / Field Тип поля / Field Type Тип поля Scala / iScala Field Type Длина поля / Field length Точность / Precision Длина Scala / iScala length Комментарий / Comment Расширенный комментарий / Extended comment Дополнительное описание / Additional description Позиция в индексе / Index position Первичный ключ? / Is Primary key?
GL53001 NVARCHAR VSTRING 12 0 12 AccountNo Account Number   1 Да / Yes
GL53002 NVARCHAR VSTRING 100 0 100 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 Automatic Allocation No      
GL53005 NCHAR STRING 9 0 9 SegmentSw Segment Switches 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 Blocked Entry (Inactive) 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 Budget Model Number      
GL53008 NUMERIC MONEY 28 8 20 BookedAm Booked Amount      
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 100 0 100 DescrLine1 Account Description Line 1      
GL53011 NVARCHAR VSTRING 100 0 100 DescrLine2 Account Description Line 2      
GL53012 NVARCHAR VSTRING 100 0 100 DescrLine3 Account Description Line 3      
GL53013 NVARCHAR ACCSTR 120 0 120 DefaultSgmt Default Segment      
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 25 0 25 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 For Stat. Account      
GL53025 NVARCHAR VSTRING 8 0 8 ScalaUserGrp Scala User Group      
GL53026 NCHAR STRING 1 0 1 TransfNextYr Transfer to Next Year      
GL53027 NVARCHAR VSTRING 12 0 12 SubLedgPar10 Sub-Ledger Parameter 10 To be used as alternative account when the currency account is revalue.    
GL53028 NVARCHAR VSTRING 1 0 1 AccountSubType Account Sub-Type      
GL53029 NVARCHAR VSTRING 150 0 150 ExtUserDefFld1 Extended User defined field 1 Ext. User defined field 1    
GL53030 NVARCHAR VSTRING 150 0 150 ExtUserDefFld2 Extended User defined field 2 Ext. User defined field 2    
GL53031 NVARCHAR VSTRING 150 0 150 ExtUserDefFld3 Extended User defined field 3 Ext. User defined field 3    
GL53032 NVARCHAR VSTRING 150 0 150 ExtUserDefFld4 Extended User defined field 4 Ext. User defined field 4    
GL53033 NVARCHAR VSTRING 150 0 150 ExtUserDefFld5 Extended User defined field 5 Ext. User defined field 5    
GL53034 NVARCHAR VSTRING 150 0 150 ExtUserDefFld6 Extended User defined field 6 Ext. User defined field 6    
GL53035 NVARCHAR VSTRING 150 0 150 ExtUserDefFld7 Extended User defined field 7 Ext. User defined field 7    
GL53036 NVARCHAR VSTRING 150 0 150 ExtUserDefFld8 Extended User defined field 8 Ext. User defined field 8    
GL53037 NVARCHAR VSTRING 150 0 150 ExtUserDefFld9 Extended User defined field 9 Ext. User defined field 9    
GL53038 NVARCHAR VSTRING 150 0 150 ExtUserDefFld10 Extended User defined field 10 Ext. User defined field 10    
GL53039 NVARCHAR VSTRING 150 0 150 ExtUserDefFld11 Extended User defined field 11 Ext. User defined field 11    
GL53040 NVARCHAR VSTRING 150 0 150 ExtUserDefFld12 Extended User defined field 12 Ext. User defined field 12    
GL53041 NVARCHAR VSTRING 150 0 150 ExtUserDefFld13 Extended User defined field 13 Ext. User defined field 13    
GL53042 NVARCHAR VSTRING 150 0 150 ExtUserDefFld14 Extended User defined field 14 Ext. User defined field 14    
GL53043 NVARCHAR VSTRING 150 0 150 ExtUserDefFld15 Extended User defined field 15 Ext. User defined field 15    
GL53044 NVARCHAR VSTRING 150 0 150 ExtUserDefFld16 Extended User defined field 16 Ext. User defined field 16    
GL53045 NVARCHAR VSTRING 150 0 150 ExtUserDefFld17 Extended User defined field 17 Ext. User defined field 17    
GL53046 NVARCHAR VSTRING 150 0 150 ExtUserDefFld18 Extended User defined field 18 Ext. User defined field 18    
GL53047 NVARCHAR VSTRING 150 0 150 ExtUserDefFld19 Extended User defined field 19 Ext. User defined field 19    
GL53048 NVARCHAR VSTRING 150 0 150 ExtUserDefFld20 Extended User defined field 20 Ext. User defined field 20    
GL53049 NCHAR STRING 3 0 3 TaxonomyCode Taxonomy code for account      
GL53050 NCHAR STRING 6 0 6 AccGroupCategory Account Grouping Category      
GL53051 INT INTEGER 0 0 1 BalanceType Balance Type Balance Type    

Навигация / Navigation: