|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
glt__qadc01
|
|
|
x(8)
|
|
|
|
glt_acct
|
Account
|
|
x(8)
|
|
|
|
glt_addr
|
Address
|
|
x(8)
|
|
|
|
glt_amt
|
Amount
|
|
->>,>>>,>>>,>>9.99
|
10
|
|
|
glt_batch
|
Batch
|
|
x(8)
|
|
|
|
glt_cc
|
Cost Ctr
|
CC
|
x(4)
|
|
|
|
glt_correction
|
Correction
|
Corr
|
yes/no
|
|
|
|
glt_curr
|
Currency
|
Cur
|
x(3)
|
|
|
|
glt_curr_amt
|
Currency Amount
|
|
->>,>>>,>>>,>>9.99
|
10
|
|
|
glt_date
|
Entered
|
|
99/99/99
|
|
|
|
glt_desc
|
Description
|
|
x(24)
|
|
|
|
glt_doc
|
Document
|
|
x(16)
|
|
|
|
glt_doc_type
|
Document Type
|
T
|
x(2)
|
|
|
|
glt_domain
|
Domain
|
|
x(8)
|
|
|
|
glt_dy_code
|
Daybook
|
|
x(8)
|
|
|
|
glt_dy_num
|
Entry Number
|
|
x(40)
|
|
|
|
glt_ecur_amt
|
Amount in Entity Currency
|
Amt in Entity Curr
|
->>,>>>,>>>,>>9.99
|
10
|
|
|
glt_effdate
|
Effective
|
Eff Date
|
99/99/99
|
|
|
|
glt_en_exrate
|
Entity Exch Rate
|
|
>>>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
glt_en_exrate2
|
Entity Exch Rate 2
|
|
>>>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
glt_en_exru_seq
|
Sequence
|
|
>>>>>>>>9
|
|
|
|
glt_entity
|
Entity
|
Enty
|
x(20)
|
|
|
|
glt_entr_exrate
|
Entered Exchange Rate
|
Entered Ex Rate
|
>>,>>9.99999<<<<<
|
10
|
|
|
glt_error
|
Error Message
|
|
x(16)
|
|
|
|
glt_ex_rate
|
Exch Rate
|
|
>>>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
glt_ex_rate2
|
Exch Rate 2
|
|
>>>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
glt_ex_ratetype
|
Rate Type
|
|
x(8)
|
|
|
|
glt_exp
|
Transaction Posted
|
Trans!Posted
|
yes/no
|
|
|
|
glt_exru_seq
|
Sequence
|
|
>>>>>>>>9
|
|
|
|
glt_fx_ind
|
FX Conversion Index
|
FX
|
x(1)
|
|
|
|
glt_interco_ref
|
Intercompany Reference
|
|
x(40)
|
|
|
|
glt_lgd_nbr
|
Legal Doc Nbr
|
Legal Doc
|
x(12)
|
|
|
|
glt_line
|
Line
|
|
>>>9
|
|
|
|
glt_mgmt_curr
|
Management Currency
|
Mgmt!Curr
|
x(3)
|
|
|
|
glt_mgmt_curr_amt
|
Management Currency Amount
|
Mgmt Curr!Amount
|
->>,>>>,>>>,>>9.99
|
10
|
|
|
glt_mgmt_ex_rate
|
Exchange Rate
|
Exch Rate
|
>>>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
glt_mgmt_ex_rate2
|
Management Curr Exchange Rate
|
Mgmt Curr!Exch Rate
|
>>>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
glt_mgmt_ex_ratetype
|
Management Exchange Rate Type
|
Mgmt Exch!Rate Type
|
x(8)
|
|
|
|
glt_mirror_line_ref
|
Mirror Line Ref
|
Mirr!LnRef
|
x(20)
|
|
|
|
glt_mirror_ref
|
Mirror Ref
|
Mirror!Ref
|
x(20)
|
|
|
|
glt_per
|
Period
|
Per
|
>>9
|
|
|
|
glt_project
|
Project
|
|
x(8)
|
|
|
|
glt_ref
|
GL Reference
|
|
x(14)
|
|
|
|
glt_rflag
|
Reversing/Retroactive Line
|
Rev!Ret
|
yes/no
|
|
|
|
glt_src_desc
|
Source GL Description
|
|
x(32)
|
|
|
|
glt_sub
|
Sub-Account
|
Sub-Acct
|
x(8)
|
|
|
|
glt_tmp_nbr
|
Temporary Number
|
|
yes/no
|
|
|
|
glt_tr_type
|
Transaction Type
|
T
|
x(2)
|
|
|
|
glt_unb
|
Unbalanced
|
Unb
|
yes/no
|
|
|
|
glt_user1
|
Ufld1
|
|
x(8)
|
|
|
|
glt_user2
|
Ufld2
|
|
x(8)
|
|
|
|
glt_userid
|
User ID
|
|
x(8)
|
|
|
|
glt_year
|
Year
|
|
9999
|
|
|
|
oid_glt_det
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
glt_acc
|
no
|
glt_domain
|
yes
|
no
|
|
|
|
|
glt_acct
|
yes
|
no
|
|
|
glt_batch
|
no
|
glt_domain
|
yes
|
no
|
|
|
|
|
glt_batch
|
yes
|
no
|
|
|
|
|
glt_ref
|
yes
|
no
|
|
|
|
|
glt_rflag
|
yes
|
no
|
|
|
|
|
glt_line
|
yes
|
no
|
|
|
glt_costctr
|
no
|
glt_domain
|
yes
|
no
|
|
|
|
|
glt_cc
|
yes
|
no
|
|
|
glt_dy_code
|
no
|
glt_domain
|
yes
|
no
|
|
|
|
|
glt_dy_code
|
yes
|
no
|
|
|
|
|
glt_dy_num
|
yes
|
no
|
|
|
glt_index
|
no
|
glt_domain
|
yes
|
no
|
|
|
|
|
glt_entity
|
yes
|
no
|
|
|
|
|
glt_acct
|
yes
|
no
|
|
|
|
|
glt_sub
|
yes
|
no
|
|
|
|
|
glt_cc
|
yes
|
no
|
|
|
|
|
glt_effdate
|
yes
|
no
|
|
|
|
|
glt_project
|
yes
|
no
|
|
|
|
|
glt_ref
|
yes
|
no
|
|
|
glt_lgd_nbr
|
no
|
glt_domain
|
yes
|
no
|
|
|
|
|
glt_lgd_nbr
|
yes
|
no
|
|
|
glt_project
|
no
|
glt_domain
|
yes
|
no
|
|
|
|
|
glt_project
|
yes
|
no
|
|
∗
|
glt_ref
|
yes
|
glt_domain
|
yes
|
no
|
|
|
|
|
glt_ref
|
yes
|
no
|
|
|
|
|
glt_rflag
|
yes
|
no
|
|
|
|
|
glt_line
|
yes
|
no
|
|
|
glt_subacct
|
no
|
glt_domain
|
yes
|
no
|
|
|
|
|
glt_sub
|
yes
|
no
|
|
|
glt_tr_type
|
no
|
glt_domain
|
yes
|
no
|
|
|
|
|
glt_tr_type
|
yes
|
no
|
|
|
|
|
glt_ref
|
yes
|
no
|
|
|
|
|
glt_line
|
yes
|
no
|
|
|
glt_unb
|
no
|
glt_domain
|
yes
|
no
|
|
|
|
|
glt_unb
|
yes
|
no
|
|
|
|
|
glt_ref
|
yes
|
no
|
|
|
|
|
glt_rflag
|
yes
|
no
|
|
|
|
|
glt_line
|
yes
|
no
|
|
|
oid_glt_det
|
yes
|
oid_glt_det
|
yes
|
no
|