One level Up / One level Up: Структура таблиц Epicor iScala 3.0 FSP4 — 3.0.4267 :: Список таблиц модуля «General Ledger»

Структура таблиц Epicor iScala 3.0 FSP4 — 3.0.4267 :: Таблица GL53 — Account Schedule

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

Поле Тип поля Тип поля Scala Длина поля Точ­ность Длина Scala Комментарий Расширенный комментарий Дополнительное описание Пози­ция в инде­ксе Первич­ный ключ?
GL53001 NVARCHAR VSTRING 12 0 12 AccountNo Account   1 Да
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 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 (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      
GL53029 NVARCHAR VSTRING 150 0 150 ExtUserDefFld1 ExtUserDefFld1 Ext. User defined field 1    
GL53030 NVARCHAR VSTRING 150 0 150 ExtUserDefFld2 ExtUserDefFld2 Ext. User defined field 2    
GL53031 NVARCHAR VSTRING 150 0 150 ExtUserDefFld3 ExtUserDefFld3 Ext. User defined field 3    
GL53032 NVARCHAR VSTRING 150 0 150 ExtUserDefFld4 ExtUserDefFld4 Ext. User defined field 4    
GL53033 NVARCHAR VSTRING 150 0 150 ExtUserDefFld5 ExtUserDefFld5 Ext. User defined field 5    
GL53034 NVARCHAR VSTRING 150 0 150 ExtUserDefFld6 ExtUserDefFld6 Ext. User defined field 6    
GL53035 NVARCHAR VSTRING 150 0 150 ExtUserDefFld7 ExtUserDefFld7 Ext. User defined field 7    
GL53036 NVARCHAR VSTRING 150 0 150 ExtUserDefFld8 ExtUserDefFld8 Ext. User defined field 8    
GL53037 NVARCHAR VSTRING 150 0 150 ExtUserDefFld9 ExtUserDefFld9 Ext. User defined field 9    
GL53038 NVARCHAR VSTRING 150 0 150 ExtUserDefFld10 ExtUserDefFld10 Ext. User defined field 10    
GL53039 NVARCHAR VSTRING 150 0 150 ExtUserDefFld11 ExtUserDefFld11 Ext. User defined field 11    
GL53040 NVARCHAR VSTRING 150 0 150 ExtUserDefFld12 ExtUserDefFld12 Ext. User defined field 12    
GL53041 NVARCHAR VSTRING 150 0 150 ExtUserDefFld13 ExtUserDefFld13 Ext. User defined field 13    
GL53042 NVARCHAR VSTRING 150 0 150 ExtUserDefFld14 ExtUserDefFld14 Ext. User defined field 14    
GL53043 NVARCHAR VSTRING 150 0 150 ExtUserDefFld15 ExtUserDefFld15 Ext. User defined field 15    
GL53044 NVARCHAR VSTRING 150 0 150 ExtUserDefFld16 ExtUserDefFld16 Ext. User defined field 16    
GL53045 NVARCHAR VSTRING 150 0 150 ExtUserDefFld17 ExtUserDefFld17 Ext. User defined field 17    
GL53046 NVARCHAR VSTRING 150 0 150 ExtUserDefFld18 ExtUserDefFld18 Ext. User defined field 18    
GL53047 NVARCHAR VSTRING 150 0 150 ExtUserDefFld19 ExtUserDefFld19 Ext. User defined field 19    
GL53048 NVARCHAR VSTRING 150 0 150 ExtUserDefFld20 ExtUserDefFld20 Ext. User defined field 20    

Навигация: