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

Поле Тип поля Тип поля Scala Длина поля Точ­ность Длина Scala Комментарий Расширенный комментарий Дополнительное описание Пози­ция в инде­ксе Первич­ный ключ?
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 Allocation_number 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 Minimum_Account Minimum Account      
GL60007 NVARCHAR VSTRING 12 0 12 Maximum_Account Maximum Account      
GL60008 NVARCHAR VSTRING 12 0 12 Minimum_Dimension_1 Minimum Accounting Dimension 1      
GL60009 NVARCHAR VSTRING 12 0 12 Maximum_dimension_1 Maximum Accounting Dimension 1      
GL60010 NVARCHAR VSTRING 12 0 12 Minimum_Dimension_2 Minimum Accounting Dimension 2      
GL60011 NVARCHAR VSTRING 12 0 12 Maximum_dimension_2 Maximum Accounting Dimension 2      
GL60012 NVARCHAR VSTRING 12 0 12 Minimum_dim_3 Minimum Accounting Dimension 3      
GL60013 NVARCHAR VSTRING 12 0 12 Maximum_dim_3 Maximum Accounting Dimension 3      
GL60014 NCHAR STRING 8 0 8 Flags_in 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 Flags_OUT 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 Last_run Date Run Period      
GL60017 NCHAR STRING 1 0 1 Flag_condition 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 Shift_time 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 Shift_time_reversal 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 Flags_NEW 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 Reversed_Tier Reversed Tier      
GL60022 NCHAR STRING 2 0 2 Reversed_category Reversed Category      
GL60023 INT INTEGER 0 0 4 Reversed_Allocation 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 Sel_type_account 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 Sel_type_dim1 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 Sel_type_dim2 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 Sel_type_dim3 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 2.3 - 2.03.3363 | General Ledger | Compound Allocations