About This Guide > glt_det
  
glt_det
General Ledger Unposted Transaction Detail
 
 
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