About This Guide > grac_det
  
grac_det
GL Report Writer Account Balances
 
 
Field Name
Label
Col-Label
Format
Dec
 
grac__qadc01
 
 
x(8)
 
 
grac_acc
Account
 
x(8)
 
 
grac_amt
Amount
 
>>,>>>,>>>,>>>,>>9.99cr
10
 
grac_beg_bal
Beginning Balance
 
->>,>>>,>>>,>>>,>>9.99
10
 
grac_beg_cbal
Beginning Bal - Foreign Curr
Beg Bal - Foreign Curr
->>,>>>,>>>,>>>,>>9.99
10
 
grac_beg_cr_bal
Beginning CR Balance
 
->>,>>>,>>>,>>>,>>9.99
10
 
grac_beg_cr_cbal
Beginning CR Currency Bal
Beg CR Bal - Foreign Curr
->>,>>>,>>>,>>>,>>9.99
10
 
grac_beg_dr_bal
Beginning DR Balance
 
->>,>>>,>>>,>>>,>>9.99
10
 
grac_beg_dr_cbal
Beginning DR Currency Bal
Beg DR Bal - Foreign Curr
->>,>>>,>>>,>>>,>>9.99
10
 
grac_cc
Cost Ctr
CC
x(4)
 
 
grac_cr_amt
CR Activity
 
->>,>>>,>>>,>>9.99<
10
 
grac_cr_curr_amt
CR Currency Activity
 
->>,>>>,>>>,>>9.99<
10
 
grac_curr_amt
Activity - Foreign Currency
Activity - Foreign Curr
->>,>>>,>>>,>>>,>>9.99
10
 
grac_domain
Domain
 
x(8)
 
 
grac_dr_amt
DR Activity
 
->>,>>>,>>>,>>9.99<
10
 
grac_dr_curr_amt
DR Currency Activity
 
->>,>>>,>>>,>>9.99<
10
 
grac_entity
Entity
Enty
x(20)
 
 
grac_per
Period
Per
>>9
 
 
grac_per_bal
Period Balance
 
->>,>>>,>>>,>>>,>>9.99
10
 
grac_per_cbal
Period Balance - Foreign Curr
Per Bal - Foreign Curr
->>,>>>,>>>,>>>,>>9.99
10
 
grac_project
Project
 
x(8)
 
 
grac_sub
Sub-Account
Sub-Acct
x(8)
 
 
grac_user1
Ufld1
 
x(8)
 
 
grac_user2
Ufld2
 
x(8)
 
 
grac_year
Year
 
9999
 
 
grac_ytd_bal
Year to Date Balance
YTD Balance
->>,>>>,>>>,>>>,>>9.99
10
 
grac_ytd_cbal
Year to Date Bal - Foreign Cur
YTD Bal - Foreign Curr
->>,>>>,>>>,>>>,>>9.99
10
 
grac_ytd_cr_amt
YTD CR Activity
 
->>,>>>,>>>,>>9.99<
10
 
grac_ytd_cr_curr_amt
YTD CR Currency Activity
 
->>,>>>,>>>,>>9.99<
10
 
grac_ytd_dr_amt
YTD DR Activity
 
->>,>>>,>>>,>>9.99<
10
 
grac_ytd_dr_curr_amt
YTD DR Currency Activity
 
->>,>>>,>>>,>>9.99<
10
 
oid_grac_det
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
grac_ypace
no
grac_domain
yes
no
 
 
 
grac_year
yes
no
 
 
 
grac_per
yes
no
 
 
 
grac_acc
yes
no
 
 
 
grac_cc
yes
no
 
 
 
grac_entity
yes
no
 
grac_ypaes
no
grac_domain
yes
no
 
 
 
grac_year
yes
no
 
 
 
grac_per
yes
no
 
 
 
grac_acc
yes
no
 
 
 
grac_entity
yes
no
 
 
 
grac_sub
yes
no
∗
grac_ypascej
yes
grac_domain
yes
no
 
 
 
grac_year
yes
no
 
 
 
grac_per
yes
no
 
 
 
grac_acc
yes
no
 
 
 
grac_sub
yes
no
 
 
 
grac_cc
yes
no
 
 
 
grac_entity
yes
no
 
 
 
grac_project
yes
no
 
grac_ypceja
no
grac_domain
yes
no
 
 
 
grac_year
yes
no
 
 
 
grac_per
yes
no
 
 
 
grac_cc
yes
no
 
 
 
grac_entity
yes
no
 
 
 
grac_project
yes
no
 
 
 
grac_acc
yes
no
 
grac_ypcja
no
grac_domain
yes
no
 
 
 
grac_year
yes
no
 
 
 
grac_per
yes
no
 
 
 
grac_cc
yes
no
 
 
 
grac_project
yes
no
 
 
 
grac_acc
yes
no
 
grac_ypejas
no
grac_domain
yes
no
 
 
 
grac_year
yes
no
 
 
 
grac_per
yes
no
 
 
 
grac_entity
yes
no
 
 
 
grac_project
yes
no
 
 
 
grac_acc
yes
no
 
 
 
grac_sub
yes
no
 
grac_ypjasc
no
grac_domain
yes
no
 
 
 
grac_year
yes
no
 
 
 
grac_per
yes
no
 
 
 
grac_project
yes
no
 
 
 
grac_acc
yes
no
 
 
 
grac_sub
yes
no
 
 
 
grac_cc
yes
no
 
grac_ypscej
no
grac_domain
yes
no
 
 
 
grac_year
yes
no
 
 
 
grac_per
yes
no
 
 
 
grac_sub
yes
no
 
 
 
grac_cc
yes
no
 
 
 
grac_entity
yes
no
 
 
 
grac_project
yes
no
 
grac_ypsej
no
grac_domain
yes
no
 
 
 
grac_year
yes
no
 
 
 
grac_per
yes
no
 
 
 
grac_sub
yes
no
 
 
 
grac_entity
yes
no
 
 
 
grac_project
yes
no
 
grac_ypsjc
no
grac_domain
yes
no
 
 
 
grac_year
yes
no
 
 
 
grac_per
yes
no
 
 
 
grac_sub
yes
no
 
 
 
grac_project
yes
no
 
 
 
grac_cc
yes
no
 
oid_grac_det
yes
oid_grac_det
yes
no