Таблица: GL60 - «Allocation Description File». Маска имени таблицы: «GL60%cc00»

Поле Тип поля Тип поля iScala Длина поля Точ­ность Длина iScala Комментарий Расширенный комментарий Дополнительное описание Пози­ция в инде­ксе Первич­ный ключ?
GL60001 NCHAR STRING 2 0 2 Category Compound Category   1 Да
GL60002 NCHAR STRING 1 0 1 Type Type Allocation type:
0 - Transaction based allocation.
1 - Balance based allocation.
2 - Reversing balance based allocation.		 2 Да
GL60003 INT INTEGER 0 0 4 AllocNum Allocation Number   3 Да
GL60004 INT INTEGER 0 0 2 Tier Compound Tier      
GL60005 NVARCHAR VSTRING 8 0 8 Spare (obsolete)      
GL60006 NVARCHAR VSTRING 12 0 12 MinimumAccount Minimum Account      
GL60007 NVARCHAR VSTRING 12 0 12 MaximumAccount Maximum Account      
GL60008 NVARCHAR VSTRING 12 0 12 MinimumDimension1 Minimum Accounting Dimension 1      
GL60009 NVARCHAR VSTRING 12 0 12 Maximumdimension1 Maximum Accounting Dimension 1      
GL60010 NVARCHAR VSTRING 12 0 12 MinimumDimension2 Minimum Accounting Dimension 2      
GL60011 NVARCHAR VSTRING 12 0 12 Maximumdimension2 Maximum Accounting Dimension 2      
GL60012 NVARCHAR VSTRING 12 0 12 Minimumdim3 Minimum Accounting Dimension 3      
GL60013 NVARCHAR VSTRING 12 0 12 Maximumdim3 Maximum Accounting Dimension 3      
GL60014 NCHAR STRING 8 0 8 Flagsin Selection Flags (In) A string of 8 characters where each character is a flag between 0 and 3 and it's used to select which transaction lines that shall be selected when running the compound allocation. Each transaction line has a similar field of 8 character that stores the flags for the transaction line (GL06030).
0 - Select transaction lines that have 0 in the same position
1 - Select transaction lines that have 1 in the same position
2 - Select transaction lines that have 2 in the same position
3 - Select transaction lines that have 3 in the same position		    
GL60015 NCHAR STRING 8 0 8 FlagsOUT Selection Flags (Out) A string of 8 character used for selection of transaction lines. This string defines the value each flag on the transaction line should have after the compound allocation has been executed.    
GL60016 NCHAR STRING 6 0 6 Lastrun Date Run Period      
GL60017 NCHAR STRING 1 0 1 Flagcondition Condition Option 0 - Allocation will only be run on debit balance.
1 - Allocation will only be run on credit balance.
2 - Allocation will be run for both debit and credit balances.		    
GL60018 NCHAR STRING 1 0 1 Shifttime Shift Time Unit Time unit to be used for shift transaction in time (quantity defined by GL60019):
2 - Days
3 - Weeks
4 - Months
5 - Years
9 - Periods		    
GL60019 INT INTEGER 0 0 4 Shifttimereversal Shift Time Reversal Shift date based on number of days, weeks, months, years or periods (1-9999). The reversal transactions is shifted ahead in time from the originating transaction date. Time unit is defined by GL60018.    
GL60020 NCHAR STRING 8 0 8 FlagsNEW Selection Flags (New Transaction Lines) A string of 8 character used for selection of transaction lines. This string defines the value each flag shall have on transaction lines created as a result of a compound allocation.    
GL60021 INT INTEGER 0 0 2 ReversedTier Reversed Tier      
GL60022 NCHAR STRING 2 0 2 Reversedcategory Reversed Category      
GL60023 INT INTEGER 0 0 4 ReversedAllocation Reversed Allocation      
GL60024 NCHAR STRING 1 0 1 Spare2 (obsolete)      
GL60025 NVARCHAR ACCSTR 50 0 50 Dimaccstr Accounting Dimensions (4-9) Action for each accounting dimension on new transactions:
[blank] - Leave accounting dimension blank, A valid accounting dimension or a string with wildcards.
Wildcards: % - Copy character, $$ - Financial year, ### - Country code, ** - Insert company code, Anything else is literal.		    
GL60026 NCHAR STRING 1 0 1 Seltypeaccount Selection Type Account Type of test to be used for defined selection interval:
0 - Testing on full string (std).
1 - Testing character by character
2 - Testing on value range		    
GL60027 NCHAR STRING 1 0 1 Seltypedim1 Selection Type Account Dimension 1 Type of test to be used for defined selection interval:
0 - Testing on full string (std).
1 - Testing character by character
2 - Testing on value range		    
GL60028 NCHAR STRING 1 0 1 Seltypedim2 Selection Type Account Dimension 2 Type of test to be used for defined selection interval:
0 - Testing on full string (std).
1 - Testing character by character
2 - Testing on value range		    
GL60029 NCHAR STRING 1 0 1 Seltypedim3 Selection Type Account Dimension 3 Type of test to be used for defined selection interval:
0 - Testing on full string (std).
1 - Testing character by character
2 - Testing on value range		    

Навигация: Структура БД iScala | Epicor iScala 3.00 (x64) - 3.00.02254 | General Ledger | Compound Allocations