QAD 2017 Enterprise Edition > Technical References > Database Definitions >
  
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
grad_det
GL Report Writer Analysis Code Detail
 
 
Field Name
Label
Col-Label
Format
Dec
 
grad__qadc01
 
 
x(8)
 
 
grad_an_code
Analysis Code
 
x(8)
 
 
grad_domain
Domain
 
x(8)
 
 
grad_gl_code
G/L Code
 
x(20)
 
 
grad_gl_type
G/L Type
 
x(1)
 
 
grad_user1
Ufld1
 
x(8)
 
 
grad_user2
Ufld2
 
x(8)
 
 
oid_grad_det
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
grad_an_code
no
grad_domain
yes
no
 
 
 
grad_an_code
yes
no
 
 
 
grad_gl_type
yes
no
 
 
 
grad_gl_code
yes
no
 
oid_grad_det
yes
oid_grad_det
yes
no
gral_det
GL Report Writer Analysis Code Link-File Detail
 
 
Field Name
Label
Col-Label
Format
Dec
 
gral__qadc01
 
 
x(8)
 
 
gral_an_code
Analysis Code
Code
x(8)
 
 
gral_domain
Domain
 
x(8)
 
 
gral_link_code
Linked Analysis Code
Link Code
x(8)
 
 
gral_seq
Sequence
Seq
>>9.9<
10
 
gral_user1
Ufld1
 
x(8)
 
 
gral_user2
Ufld2
 
x(8)
 
 
oid_gral_det
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
gral_an_code
yes
gral_domain
yes
no
 
 
 
gral_an_code
yes
no
 
 
 
gral_link_code
yes
no
 
 
 
gral_seq
yes
no
 
gral_link_code
no
gral_domain
yes
no
 
 
 
gral_link_code
yes
no
 
gral_seq
yes
gral_domain
yes
no
 
 
 
gral_an_code
yes
no
 
 
 
gral_seq
yes
no
 
oid_gral_det
yes
oid_gral_det
yes
no
gras_det
GL Report Writer Selection Detail
 
 
Field Name
Label
Col-Label
Format
Dec
 
gras__qadc01
 
 
x(8)
 
 
gras_an_code
Analysis Code
Code
x(8)
 
 
gras_domain
Domain
 
x(8)
 
 
gras_gl_type
G/L Type
 
x(1)
 
 
gras_include
Include
Incl
yes/no
 
 
gras_sel_high
To G/L Code
To Code
x(20)
 
 
gras_sel_low
From G/L Code
From Code
x(20)
 
 
gras_user1
Ufld1
 
x(8)
 
 
gras_user2
Ufld2
 
x(8)
 
 
oid_gras_det
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
gras_an_code
yes
gras_domain
yes
no
 
 
 
gras_an_code
yes
no
 
 
 
gras_gl_type
yes
no
 
 
 
gras_include
yes
no
 
 
 
gras_sel_low
yes
no
 
 
 
gras_sel_high
yes
no
 
oid_gras_det
yes
oid_gras_det
yes
no
gra_mstr
GL Report Writer Analysis Code Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
gra__qadc01
 
 
x(8)
 
 
gra_add_date
Date Created
 
99/99/99
 
 
gra_add_id
Originator
 
x(8)
 
 
gra_an_code
Analysis Code
Code
x(8)
 
 
gra_cmtindx
Comment Index
 
>>>>>>>9
 
 
gra_desc
Description
 
x(24)
 
 
gra_domain
Domain
 
x(8)
 
 
gra_gl_type
G/L Type
 
x(1)
 
 
gra_group
Security Groups
 
x(72)
 
 
gra_link
Link To
 
CODE/ITEM
 
 
gra_mod_date
Modified Date
Mod Date
99/99/99
 
 
gra_mod_id
Modified By
 
x(8)
 
 
gra_status
Status
 
Live/Test
 
 
gra_user1
Ufld1
 
x(8)
 
 
gra_user2
Ufld2
 
x(8)
 
 
oid_gra_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
gra_an_code
yes
gra_domain
yes
no
 
 
 
gra_an_code
yes
no
 
gra_desc
yes
gra_domain
yes
no
 
 
 
gra_gl_type
yes
no
 
 
 
gra_desc
yes
no
 
 
 
gra_an_code
yes
no
 
gra_type
yes
gra_domain
yes
no
 
 
 
gra_gl_type
yes
no
 
 
 
gra_an_code
yes
no
 
oid_gra_mstr
yes
oid_gra_mstr
yes
no
grbg_det
GL Report Writer Budgeted Account Balance Detail
 
 
Field Name
Label
Col-Label
Format
Dec
 
grbg__qadc01
 
 
x(8)
 
 
grbg_acc
Account
 
x(8)
 
 
grbg_amt
Budget Amount
 
->>,>>>,>>>,>>>,>>9.99
10
 
grbg_beg_bal
Beginning Balance
 
->>,>>>,>>>,>>>,>>9.99
10
 
grbg_cc
Cost Ctr
CC
x(4)
 
 
grbg_code
Budget Code
Budget
x(8)
 
 
grbg_domain
Domain
 
x(8)
 
 
grbg_entity
Entity
Enty
x(20)
 
 
grbg_per
Period
Pd
>9
 
 
grbg_per_bal
Period Budgeted Balance
 
->>,>>>,>>>,>>>,>>9.99<<<<<<<<
10
 
grbg_project
Project
 
x(8)
 
 
grbg_sub
Sub-Account
Sub-Acct
x(8)
 
 
grbg_user1
Ufld1
 
x(8)
 
 
grbg_user2
Ufld2
 
x(8)
 
 
grbg_year
Year
 
9999
 
 
grbg_ytd_bal
Year to Date Budget
 
->>,>>>,>>>,>>>,>>9.99<<<<<<<<
10
 
oid_grbg_det
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
grbg_bypace
no
grbg_domain
yes
no
 
 
 
grbg_code
yes
no
 
 
 
grbg_year
yes
no
 
 
 
grbg_per
yes
no
 
 
 
grbg_acc
yes
no
 
 
 
grbg_cc
yes
no
 
 
 
grbg_entity
yes
no
 
grbg_bypaes
no
grbg_domain
yes
no
 
 
 
grbg_code
yes
no
 
 
 
grbg_year
yes
no
 
 
 
grbg_per
yes
no
 
 
 
grbg_acc
yes
no
 
 
 
grbg_entity
yes
no
 
 
 
grbg_sub
yes
no
grbg_bypascej
yes
grbg_domain
yes
no
 
 
 
grbg_code
yes
no
 
 
 
grbg_year
yes
no
 
 
 
grbg_per
yes
no
 
 
 
grbg_acc
yes
no
 
 
 
grbg_sub
yes
no
 
 
 
grbg_cc
yes
no
 
 
 
grbg_entity
yes
no
 
 
 
grbg_project
yes
no
 
grbg_bypceja
no
grbg_domain
yes
no
 
 
 
grbg_code
yes
no
 
 
 
grbg_year
yes
no
 
 
 
grbg_per
yes
no
 
 
 
grbg_cc
yes
no
 
 
 
grbg_entity
yes
no
 
 
 
grbg_project
yes
no
 
 
 
grbg_acc
yes
no
 
grbg_bypcja
no
grbg_domain
yes
no
 
 
 
grbg_code
yes
no
 
 
 
grbg_year
yes
no
 
 
 
grbg_per
yes
no
 
 
 
grbg_cc
yes
no
 
 
 
grbg_project
yes
no
 
 
 
grbg_acc
yes
no
 
grbg_bypejas
no
grbg_domain
yes
no
 
 
 
grbg_code
yes
no
 
 
 
grbg_year
yes
no
 
 
 
grbg_per
yes
no
 
 
 
grbg_entity
yes
no
 
 
 
grbg_project
yes
no
 
 
 
grbg_acc
yes
no
 
 
 
grbg_sub
yes
no
 
grbg_bypjasc
no
grbg_domain
yes
no
 
 
 
grbg_code
yes
no
 
 
 
grbg_year
yes
no
 
 
 
grbg_per
yes
no
 
 
 
grbg_project
yes
no
 
 
 
grbg_acc
yes
no
 
 
 
grbg_sub
yes
no
 
 
 
grbg_cc
yes
no
 
grbg_bypscej
no
grbg_domain
yes
no
 
 
 
grbg_code
yes
no
 
 
 
grbg_year
yes
no
 
 
 
grbg_per
yes
no
 
 
 
grbg_sub
yes
no
 
 
 
grbg_cc
yes
no
 
 
 
grbg_entity
yes
no
 
 
 
grbg_project
yes
no
 
grbg_bypsej
no
grbg_domain
yes
no
 
 
 
grbg_code
yes
no
 
 
 
grbg_year
yes
no
 
 
 
grbg_per
yes
no
 
 
 
grbg_sub
yes
no
 
 
 
grbg_entity
yes
no
 
 
 
grbg_project
yes
no
 
grbg_bypsjc
no
grbg_domain
yes
no
 
 
 
grbg_code
yes
no
 
 
 
grbg_year
yes
no
 
 
 
grbg_per
yes
no
 
 
 
grbg_sub
yes
no
 
 
 
grbg_project
yes
no
 
 
 
grbg_cc
yes
no
 
oid_grbg_det
yes
oid_grbg_det
yes
no
grcd_det
GL Report Writer Column Group Detail
 
 
Field Name
Label
Col-Label
Format
Dec
 
grcd__qadc01
 
 
x(8)
 
 
grcd_activity
Activity Type
 
x(1)
 
 
grcd_bg_code
Budget Code
 
x(8)
 
 
grcd_bg_roll
Roll Budgets Into Actuals
 
yes/no
 
 
grcd_calc[5]
Formula
 
x(50)
 
 
grcd_col
Column
 
9999
 
 
grcd_col_group
Column Group
 
x(8)
 
 
grcd_col_type
Column Type
 
x(1)
 
 
grcd_currency
Currency
 
Foreign/Base
 
 
grcd_desc
Description
 
x(24)
 
 
grcd_domain
Domain
 
x(8)
 
 
grcd_format
Format
 
x(20)
 
 
grcd_label[3]
Column Label
 
x(20)
 
 
grcd_override
Allow Override
 
yes/no
 
 
grcd_per_from
Period
 
x(4)
 
 
grcd_per_to
To
 
x(4)
 
 
grcd_percent
Percentage
 
yes/no
 
 
grcd_print
Print
 
yes/no
 
 
grcd_project
Project
 
x(8)
 
 
grcd_quarter
Quarter
 
x(2)
 
 
grcd_round
Rounding
 
x(3)
 
 
grcd_rvpol
Reverse Polish Calculation
 
x(76)
 
 
grcd_symbol
Currency Symbol
Sym
x(3)
 
 
grcd_user1
Ufld1
 
x(8)
 
 
grcd_user2
Ufld2
 
x(8)
 
 
grcd_width
Column Width
 
>9
 
 
grcd_year
Year
 
x(4)
 
 
oid_grcd_det
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
grcd_col_group
yes
grcd_domain
yes
no
 
 
 
grcd_col_group
yes
no
 
 
 
grcd_col
yes
no
 
grcd_col_type
yes
grcd_domain
yes
no
 
 
 
grcd_col_group
yes
no
 
 
 
grcd_col_type
yes
no
 
 
 
grcd_col
yes
no
 
oid_grcd_det
yes
oid_grcd_det
yes
no
grc_mstr
GL Report Writer Column Group Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
grc__qadc01
 
 
x(8)
 
 
grc_add_date
Date Created
 
99/99/99
 
 
grc_add_id
Originator
 
x(8)
 
 
grc_cmtindx
Comment Index
 
>>>>>>>9
 
 
grc_col_group
Column Group
 
x(8)
 
 
grc_desc
Description
 
x(24)
 
 
grc_domain
Domain
 
x(8)
 
 
grc_group
Security Groups
 
x(72)
 
 
grc_mod_date
Modified Date
Mod Date
99/99/99
 
 
grc_mod_id
Modified By
 
x(8)
 
 
grc_status
Status
 
Live/Test
 
 
grc_user1
Ufld1
 
x(8)
 
 
grc_user2
Ufld2
 
x(8)
 
 
oid_grc_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
grc_col_group
yes
grc_domain
yes
no
 
 
 
grc_col_group
yes
no
 
oid_grc_mstr
yes
oid_grc_mstr
yes
no
grdf_mtx
GL Report Writer Definition Matrix
 
 
Field Name
Label
Col-Label
Format
Dec
 
grdf__qadc01
 
 
x(8)
 
 
grdf_col
Cell Column
 
999
 
 
grdf_domain
Domain
 
x(8)
 
 
grdf_format
Cell Format
 
x(20)
 
 
grdf_formula
Formula
 
x(76)
 
 
grdf_print
Print
 
yes/no
 
 
grdf_reverse
Reverse Sign
 
yes/no
 
 
grdf_round
Rounding
 
x(3)
 
 
grdf_row
Cell Row
 
>>>9
 
 
grdf_run_id
Report Run ID
 
>>>>>>9
 
 
grdf_user1
Ufld1
 
x(8)
 
 
grdf_user2
Ufld2
 
x(8)
 
 
oid_grdf_mtx
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
grdf_col
yes
grdf_domain
yes
no
 
 
 
grdf_run_id
yes
no
 
 
 
grdf_col
yes
no
 
 
 
grdf_row
yes
no
grdf_row
yes
grdf_domain
yes
no
 
 
 
grdf_run_id
yes
no
 
 
 
grdf_row
yes
no
 
 
 
grdf_col
yes
no
 
oid_grdf_mtx
yes
oid_grdf_mtx
yes
no
grhd_det
GL Report Writer Group Row/Column Sequence Detail
 
 
Field Name
Label
Col-Label
Format
Dec
 
grhd__qadc01
 
 
x(8)
 
 
grhd_code
Code
 
x(20)
 
 
grhd_domain
Domain
 
x(8)
 
 
grhd_explode
Explode
 
yes/no
 
 
grhd_group
Group
 
x(8)
 
 
grhd_link
Link
 
CODE/ITEM
 
 
grhd_link_type
Link Type
T
x(1)
 
 
grhd_priority
Priority
 
z
 
 
grhd_seq
Sequence
Seq
9999
 
 
grhd_sub_indent
Sub Total Indent
SB Ind
zz
 
 
grhd_type
Group Type
T
x(1)
 
 
grhd_user1
Ufld1
 
x(8)
 
 
grhd_user2
Ufld2
 
x(8)
 
 
oid_grhd_det
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
grhd_code
no
grhd_domain
yes
no
 
 
 
grhd_code
yes
no
 
 
 
grhd_link
yes
no
 
 
 
grhd_link_type
yes
no
grhd_group
yes
grhd_domain
yes
no
 
 
 
grhd_group
yes
no
 
 
 
grhd_type
yes
no
 
 
 
grhd_seq
yes
no
 
 
 
grhd_code
yes
no
 
 
 
grhd_link
yes
no
 
 
 
grhd_link_type
yes
no
 
grhd_link
yes
grhd_domain
yes
no
 
 
 
grhd_group
yes
no
 
 
 
grhd_type
yes
no
 
 
 
grhd_seq
yes
no
 
 
 
grhd_link
yes
no
 
 
 
grhd_link_type
yes
no
 
 
 
grhd_code
yes
no
 
grhd_link_type
no
grhd_domain
yes
no
 
 
 
grhd_group
yes
no
 
 
 
grhd_type
yes
no
 
 
 
grhd_link_type
yes
no
 
grhd_priority
no
grhd_domain
yes
no
 
 
 
grhd_group
yes
no
 
 
 
grhd_type
yes
no
 
 
 
grhd_seq
yes
no
 
 
 
grhd_priority
yes
no
 
 
 
grhd_explode
yes
no
 
 
 
grhd_link
yes
no
 
grhd_type_link
no
grhd_domain
yes
no
 
 
 
grhd_type
yes
no
 
 
 
grhd_link_type
yes
no
 
oid_grhd_det
yes
oid_grhd_det
yes
no
grib_det
GL Report Writer Break Group Detail
 
 
Field Name
Label
Col-Label
Format
Dec
 
grib__qadc01
 
 
x(8)
 
 
grib_an_code
Analysis Code
 
x(8)
 
 
grib_basepage
Base Page
B Pg
>>>>9
 
 
grib_desc
Description
 
x(24)
 
 
grib_domain
Domain
 
x(8)
 
 
grib_level
Level
 
999999
 
 
grib_link_code
Link Code
 
x(8)
 
 
grib_link_type
G/L Type
 
x(1)
 
 
grib_pages
Group Pages
G Pgs
>>>>9
 
 
grib_run_id
Report Run ID
 
>>>>>>>9
 
 
grib_select
Sel
 
yes/no
 
 
grib_user1
Ufld1
 
x(8)
 
 
grib_user2
Ufld2
 
x(8)
 
 
oid_grib_det
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
grib_an_code
no
grib_domain
yes
no
 
 
 
grib_run_id
yes
no
 
 
 
grib_link_type
yes
no
 
 
 
grib_an_code
yes
no
 
 
 
grib_link_code
yes
no
 
grib_level
no
grib_domain
yes
no
 
 
 
grib_run_id
no
no
 
 
 
grib_level
no
no
 
 
 
grib_an_code
no
no
 
grib_link
no
grib_domain
yes
no
 
 
 
grib_run_id
yes
no
 
 
 
grib_link_type
yes
no
 
 
 
grib_link_code
yes
no
 
 
 
grib_an_code
yes
no
 
oid_grib_det
yes
oid_grib_det
yes
no
gric_det
GL Report Writer Image Column Detail
 
 
Field Name
Label
Col-Label
Format
Dec
 
gric__qadc01
 
 
x(8)
 
 
gric_activity
Activity
 
x(1)
 
 
gric_bg_code
Budget Code
 
x(8)
 
 
gric_col
Column
 
>>>9
 
 
gric_col_type
Column Type
 
x(1)
 
 
gric_currency
Currency
Curr
Foreign/Base
 
 
gric_domain
Domain
 
x(8)
 
 
gric_label[3]
Column Label
 
x(20)
 
 
gric_per_from
Period
 
>>9
 
 
gric_per_to
To
 
>>9
 
 
gric_print
Print Cell
 
yes/no
 
 
gric_quarter
Quarter
 
9
 
 
gric_run_id
Report Run ID
 
>>>>>>9
 
 
gric_select
Sel
 
yes/no
 
 
gric_symbol
Currency Symbol
Sym
x(3)
 
 
gric_user1
Ufld1
 
x(8)
 
 
gric_user2
Ufld2
 
x(8)
 
 
gric_width
Column Width
 
>9
 
 
gric_year
Year
 
9999
 
 
oid_gric_det
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
gric_col
yes
gric_domain
yes
no
 
 
 
gric_run_id
yes
no
 
 
 
gric_col
yes
no
 
oid_gric_det
yes
oid_gric_det
yes
no
grid_det
GL Report Writer Report Image Detail
 
 
Field Name
Label
Col-Label
Format
Dec
 
grid__qadc01
 
 
x(8)
 
 
grid_allzero
AZ
 
yes/no
 
 
grid_apply_sym
Apply Curr Symbol
Sym
yes/no
 
 
grid_domain
Domain
 
x(8)
 
 
grid_expl_line
Exploded Line
E Ln
-999
 
 
grid_indent
Indent
 
zz
 
 
grid_label
Row Label
 
x(36)
 
 
grid_line
Exploded Line Number
 
999999
 
 
grid_page
Page Break After Total
 
yes/no
 
 
grid_post_und
Post-Underline Character
 
x(1)
 
 
grid_pre_und
Pre-Underline Character
 
x(1)
 
 
grid_print
Print Cell
 
yes/no
 
 
grid_row
Row
 
9999
 
 
grid_row_type
Row Type
 
x(1)
 
 
grid_run_id
Report Run ID
 
>>>>>>9
 
 
grid_select
Sel
 
yes/no
 
 
grid_skips
Lines To Skip
 
zz
 
 
grid_stl
Sub-Total Level
 
-999
 
 
grid_text[5]
Text
 
x(48)
 
 
grid_user1
Ufld1
 
x(8)
 
 
grid_user2
Ufld2
 
x(8)
 
 
grid_zero_suppress
Zero Suppress
Z
x(1)
 
 
oid_grid_det
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
grid_row
yes
grid_domain
yes
no
 
 
 
grid_run_id
yes
no
 
 
 
grid_row
yes
no
 
 
 
grid_line
yes
no
 
 
 
grid_stl
yes
no
 
oid_grid_det
yes
oid_grid_det
yes
no
grig_mtx
GL Report Writer Report Image Matrix
 
 
Field Name
Label
Col-Label
Format
Dec
 
grig__qadc01
 
 
x(8)
 
 
grig_amt
Cell Amount - Data
 
->>,>>>,>>>,>>>,>>9.99<<<<<<<<
10
 
grig_amt_txt
Cell Amount - Text
 
x(20)
 
 
grig_brk_gp
Break Group Element
 
x(8)
 
 
grig_col
Cell Column
 
999
 
 
grig_domain
Domain
 
x(8)
 
 
grig_line
Exploded Line Number
 
999999
 
 
grig_print
Print Cell
 
yes/no
 
 
grig_row
Cell Row
 
9999
 
 
grig_run_id
Report Run ID
 
>>>>>>9
 
 
grig_stl
Sub-Total Level
 
999
 
 
grig_type
Type
 
x(1)
 
 
grig_user1
Ufld1
 
x(8)
 
 
grig_user2
Ufld2
 
x(8)
 
 
oid_grig_mtx
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
grig_col
no
grig_domain
yes
no
 
 
 
grig_run_id
yes
no
 
 
 
grig_col
yes
no
 
 
 
grig_row
yes
no
 
 
 
grig_line
yes
no
 
 
 
grig_stl
yes
no
grig_row
yes
grig_domain
yes
no
 
 
 
grig_run_id
yes
no
 
 
 
grig_brk_gp
yes
no
 
 
 
grig_row
yes
no
 
 
 
grig_line
yes
no
 
 
 
grig_stl
yes
no
 
 
 
grig_col
yes
no
 
oid_grig_mtx
yes
oid_grig_mtx
yes
no
grit_wkf
GL Report Writer Analysis Code and Item Type Work Table
 
 
Field Name
Label
Col-Label
Format
Dec
 
grit__qadc01
 
 
x(8)
 
 
grit_an_code
Analysis Code
 
x(8)
 
 
grit_desc
Description
 
x(28)
 
 
grit_domain
Domain
 
x(8)
 
 
grit_gl_code
G/L Code
 
x(20)
 
 
grit_gl_type
GL Type
T
x(1)
 
 
grit_marker
Select
Sel
x(1)
 
 
grit_runid
runid
 
x(18)
 
 
grit_user1
Ufld1
 
x(8)
 
 
grit_user2
Ufld2
 
x(8)
 
 
oid_grit_wkf
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
grit_desc
no
grit_domain
yes
no
 
 
 
grit_desc
yes
no
 
 
 
grit_gl_code
yes
no
 
 
 
grit_runid
yes
no
grit_gl_code
yes
grit_domain
yes
no
 
 
 
grit_runid
yes
no
 
 
 
grit_gl_code
yes
no
 
oid_grit_wkf
yes
oid_grit_wkf
yes
no
gri_mstr
GL Report Writer Report Image Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
gri__qadc01
 
 
x(8)
 
 
gri_cont_pg
Continuous Pages
CP
yes/no
 
 
gri_date
Run Date
 
99/99/99
 
 
gri_defprt
Default Printer
Def Prt
x(8)
 
 
gri_desc
Description
 
x(24)
 
 
gri_domain
Domain
 
x(8)
 
 
gri_filtered
Filtered
 
yes/no
 
 
gri_format
Format
 
x(20)
 
 
gri_lab_bc
Row Labels Before Column
 
>>9
 
 
gri_lab_width
Row Labels Width
RW
99
 
 
gri_mrg_bot
Bottom Margin
BM
>9
 
 
gri_mrg_left
Left Marging
LM
>9
 
 
gri_mrg_right
Right Margin
RM
>9
 
 
gri_mrg_top
Top Margin
TM
>9
 
 
gri_ovr_code[5]
Override Code
Ovr Code
x(8)
 
 
gri_ovr_type[5]
Override Type
T
x(1)
 
 
gri_paginated
Paginated
 
yes/no
 
 
gri_per
Period
Per
>>9
 
 
gri_prt_wrk
Print Working Papers
 
yes/no
 
 
gri_report
Report
 
x(8)
 
 
gri_round
Rounding
 
x(3)
 
 
gri_run_id
Report Run ID
Run ID
>>>>>>9
 
 
gri_status
Status
 
Live/Test
 
 
gri_text_ix[3]
String Index
Strng Ix
>>>>>>>9
 
 
gri_time
Run Time
 
x(8)
 
 
gri_user1
Ufld1
 
x(8)
 
 
gri_user2
Ufld2
 
x(8)
 
 
gri_userid
User ID
 
x(8)
 
 
gri_year
Year
 
9999
 
 
gri_zero_suppress
Zero Supression
ZS
x(1)
 
 
oid_gri_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
gri_report
yes
gri_domain
yes
no
 
 
 
gri_report
yes
no
 
 
 
gri_run_id
yes
no
 
gri_run_id
yes
gri_domain
yes
no
 
 
 
gri_run_id
yes
no
 
oid_gri_mstr
yes
oid_gri_mstr
yes
no
GrossIncAcc
Gross Income Accounting
 
 
Field Name
Label
Col-Label
Format
Dec
 
Company_ID
Link to Company
 
-99999999999
 
 
CustomCombo0
Custom Combo Field
 
x(20)
 
 
CustomCombo1
Custom Combo Field
 
x(20)
 
 
CustomCombo2
Custom Combo Field
 
x(20)
 
 
CustomCombo3
Custom Combo Field
 
x(20)
 
 
CustomCombo4
Custom Combo Field
 
x(20)
 
 
CustomCombo5
Custom Combo Field
 
x(20)
 
 
CustomCombo6
Custom Combo Field
 
x(20)
 
 
CustomCombo7
Custom Combo Field
 
x(20)
 
 
CustomCombo8
Custom Combo Field
 
x(20)
 
 
CustomCombo9
Custom Combo Field
 
x(20)
 
 
CustomDate0
Custom Date Field
 
99/99/9999
 
 
CustomDate1
Custom Date Field
 
99/99/9999
 
 
CustomDate2
Custom Date Field
 
99/99/9999
 
 
CustomDate3
Custom Date Field
 
99/99/9999
 
 
CustomDate4
Custom Date Field
 
99/99/9999
 
 
CustomDecimal0
Custom Decimal Field
 
->,>>>,>>9.99
4
 
CustomDecimal1
Custom Decimal Field
 
->,>>>,>>9.99
4
 
CustomDecimal2
Custom Decimal Field
 
->,>>>,>>9.99
4
 
CustomDecimal3
Custom Decimal Field
 
->,>>>,>>9.99
4
 
CustomDecimal4
Custom Decimal Field
 
->,>>>,>>9.99
4
 
CustomInteger0
Custom Integer Field
 
->,>>>,>>9
 
 
CustomInteger1
Custom Integer Field
 
->,>>>,>>9
 
 
CustomInteger2
Custom Integer Field
 
->,>>>,>>9
 
 
CustomInteger3
Custom Integer Field
 
->,>>>,>>9
 
 
CustomInteger4
Custom Integer Field
 
->,>>>,>>9
 
 
CustomLong0
Custom Long Field
 
x(255)
 
 
CustomLong1
Custom Long Field
 
x(255)
 
 
CustomNote
Custom Note Field
 
x(2000)
 
 
CustomShort0
Custom Short Field
 
x(20)
 
 
CustomShort1
Custom Short Field
 
x(20)
 
 
CustomShort2
Custom Short Field
 
x(20)
 
 
CustomShort3
Custom Short Field
 
x(20)
 
 
CustomShort4
Custom Short Field
 
x(20)
 
 
CustomShort5
Custom Short Field
 
x(20)
 
 
CustomShort6
Custom Short Field
 
x(20)
 
 
CustomShort7
Custom Short Field
 
x(20)
 
 
CustomShort8
Custom Short Field
 
x(20)
 
 
CustomShort9
Custom Short Field
 
x(20)
 
 
GrossIncAcc_ID
Record ID
 
-99999999999
 
 
GrossIncAccIsAllCostCentre
All Cost Centers
 
yes/no
 
 
GrossIncAccIsAllDivision
All Sub-Accounts
 
yes/no
 
 
GrossIncAccIsAllProject
All Projects
 
yes/no
 
 
Journal_ID
Link To Journal
 
-99999999999
 
 
LastModifiedDate
Last Modified Date
Mod Date
99/99/9999
 
 
LastModifiedTime
Last Modified Time
Mod Time
99999
 
 
LastModifiedUser
Last Modified User
Mod User
x(20)
 
 
QADC01
 
 
x(40)
 
 
QADC02
 
 
x(255)
 
 
QADD01
 
 
->,>>>,>>9.9999
10
 
QADT01
 
 
99/99/9999
 
 
SalesCostCentre_ID
Link To CostCentre (Sales)
 
-99999999999
 
 
SalesDivision_ID
Link To Division (Sales)
 
-99999999999
 
 
SalesGL_ID
Link To GL (Sales)
 
-99999999999
 
 
SalesProject_ID
Link To Project (Sales)
 
-99999999999
 
 
TaxExpenseCostCentre_ID
Link To CostCentre (Tax Expense)
 
-99999999999
 
 
TaxExpenseDivision_ID
Link To Division (Tax Expense)
 
-99999999999
 
 
TaxExpenseGL_ID
Link To GL (Tax Expense)
 
-99999999999
 
 
TaxExpenseProject_ID
Link To Project (Tax Expense)
 
-99999999999
 
 
TaxPayableDivision_ID
Link To Division (Tax Payable)
 
-99999999999
 
 
TaxPayableGL_ID
Link To GL (Tax Payable)
 
-99999999999
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
AltUniqIdx
yes
Company_ID
yes
no
 
 
 
SalesGL_ID
yes
no
 
 
 
SalesDivision_ID
yes
no
 
 
 
SalesCostCentre_ID
yes
no
 
 
 
SalesProject_ID
yes
no
 
 
 
TaxPayableGL_ID
yes
no
 
 
 
TaxPayableDivision_ID
yes
no
 
CyIdx
no
Company_ID
yes
no
 
JournalIdx
no
Journal_ID
yes
no
 ∗
Prim
yes
GrossIncAcc_ID
yes
no
 
SalesCC
no
SalesCostCentre_ID
yes
no
 
SalesDiv
no
SalesDivision_ID
yes
no
 
SalesGL
no
SalesGL_ID
yes
no
 
SalesPrj
no
SalesProject_ID
yes
no
 
TaxExpCC
no
TaxExpenseCostCentre_ID
yes
no
 
TaxExpDiv
no
TaxExpenseDivision_ID
yes
no
 
TaxExpGL
no
TaxExpenseGL_ID
yes
no
 
TaxExpPrj
no
TaxExpenseProject_ID
yes
no
 
TaxPayDiv
no
TaxPayableDivision_ID
yes
no
 
TaxPayGL
no
TaxPayableGL_ID
yes
no
grqd_det
GL Report Writer Fiscal Quarter Calendar
 
 
Field Name
Label
Col-Label
Format
Dec
 
grqd__qadc01
 
 
x(8)
 
 
grqd_domain
Domain
 
x(8)
 
 
grqd_per_end
Period End
Per!End
>>9
 
 
grqd_per_start
Period Start
Per!Strt
>>9
 
 
grqd_quarter
Quarter
Qtr
9
 
 
grqd_user1
Ufld1
 
x(8)
 
 
grqd_user2
Ufld2
 
x(8)
 
 
grqd_year
Year
 
9999
 
 
oid_grqd_det
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
grqd_period
yes
grqd_domain
yes
no
 
 
 
grqd_year
yes
no
 
 
 
grqd_per_start
yes
no
 
 
 
grqd_per_end
yes
no
grqd_quarter
yes
grqd_domain
yes
no
 
 
 
grqd_year
yes
no
 
 
 
grqd_quarter
yes
no
 
oid_grqd_det
yes
oid_grqd_det
yes
no
grrd_det
GL Report Writer Row Group Detail
 
 
Field Name
Label
Col-Label
Format
Dec
 
grrd__qadc01
 
 
x(8)
 
 
grrd_apply_sym
Apply Curr Symbol
Sym
yes/no
 
 
grrd_calc[5]
Formula
 
x(50)
 
 
grrd_domain
Domain
 
x(8)
 
 
grrd_format
Format
 
x(20)
 
 
grrd_indent
Indent
 
zz
 
 
grrd_label
Label
 
x(36)
 
 
grrd_override
Allow Override
 
yes/no
 
 
grrd_page
Page Break After Total
 
yes/no
 
 
grrd_percent
Percentage
 
yes/no
 
 
grrd_post_und
Post-Underline Character
 
x(1)
 
 
grrd_pre_und
Pre-Underline Character
 
x(1)
 
 
grrd_precedence
Precedence
 
Row/Column
 
 
grrd_print
Print
 
yes/no
 
 
grrd_reverse
Reverse Sign
 
yes/no
 
 
grrd_round
Rounding
 
x(3)
 
 
grrd_row
Row
 
9999
 
 
grrd_row_group
Row Group
 
x(8)
 
 
grrd_row_type
Row Type
 
x(1)
 
 
grrd_rvpol
Reverse Polish Calculation
 
x(76)
 
 
grrd_show
Show Codes
 
yes/no
 
 
grrd_skips
Lines To Skip
 
>9
 
 
grrd_start_col
Start Column
 
>>>9
 
 
grrd_text[5]
Text
 
x(48)
 
 
grrd_user1
Ufld1
 
x(8)
 
 
grrd_user2
Ufld2
 
x(8)
 
 
grrd_zero_suppress
Zero Suppression
ZS
x(1)
 
 
oid_grrd_det
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
grrd_row_group
yes
grrd_domain
yes
no
 
 
 
grrd_row_group
yes
no
 
 
 
grrd_row
yes
no
 
grrd_row_type
yes
grrd_domain
yes
no
 
 
 
grrd_row_group
yes
no
 
 
 
grrd_row_type
yes
no
 
 
 
grrd_row
yes
no
 
oid_grrd_det
yes
oid_grrd_det
yes
no
grr_mstr
GL Report Writer Row Group Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
grr__qadc01
 
 
x(8)
 
 
grr_add_date
Date Created
 
99/99/99
 
 
grr_add_id
Originator
 
x(8)
 
 
grr_brk_ac
Using Analysis Code
 
x(8)
 
 
grr_brk_gl
Control Report By
 
x(1)
 
 
grr_cmtindx
Comment Index
 
>>>>>>>9
 
 
grr_cont_pg
Continuous Page Numbers
 
yes/no
 
 
grr_desc
Description
 
x(24)
 
 
grr_domain
Domain
 
x(8)
 
 
grr_group
Security Groups
 
x(72)
 
 
grr_mod_date
Modified Date
Mod Date
99/99/99
 
 
grr_mod_id
Modified By
 
x(8)
 
 
grr_row_group
Row Group
 
x(8)
 
 
grr_status
Status
 
Live/Test
 
 
grr_user1
Ufld1
 
x(8)
 
 
grr_user2
Ufld2
 
x(8)
 
 
grr_width
Row Width
 
>9
 
 
oid_grr_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
grr_brk_ac
no
grr_domain
yes
no
 
 
 
grr_brk_ac
yes
no
 
 
 
grr_brk_gl
yes
no
 
 
 
grr_row_group
yes
no
grr_row_group
yes
grr_domain
yes
no
 
 
 
grr_row_group
yes
no
 
oid_grr_mstr
yes
oid_grr_mstr
yes
no
grtx_det
GL Report Writer Text String Detail
 
 
Field Name
Label
Col-Label
Format
Dec
 
grtx__qadc01
 
 
x(8)
 
 
grtx_domain
Domain
 
x(8)
 
 
grtx_fmt_txt
Formatted Text
 
x(76)
 
 
grtx_indx
Index
 
>>>>>>>9
 
 
grtx_seq
Line
 
>>>9
 
 
grtx_text
Text
 
x(76)
 
 
grtx_user1
Ufld1
 
x(8)
 
 
grtx_user2
Ufld2
 
x(8)
 
 
oid_grtx_det
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
grtx_index
yes
grtx_domain
yes
no
 
 
 
grtx_indx
yes
no
 
 
 
grtx_seq
yes
no
 
oid_grtx_det
yes
oid_grtx_det
yes
no
grv_det
GL Report Writer Account Balance Detail
 
 
Field Name
Label
Col-Label
Format
Dec
 
grv__qadc01
 
 
x(8)
 
 
grv_acc
Account
 
x(8)
 
 
grv_cc
Cost Ctr
CC
x(4)
 
 
grv_domain
Domain
 
x(8)
 
 
grv_entity
Entity
Enty
x(20)
 
 
grv_project
Project
 
x(8)
 
 
grv_sub
Sub-Account
Sub-Acct
x(8)
 
 
grv_user1
Ufld1
 
x(8)
 
 
grv_user2
Ufld2
 
x(8)
 
 
oid_grv_det
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
grv_ace
no
grv_domain
yes
no
 
 
 
grv_acc
yes
no
 
 
 
grv_cc
yes
no
 
 
 
grv_entity
yes
no
 
grv_aes
no
grv_domain
yes
no
 
 
 
grv_acc
yes
no
 
 
 
grv_entity
yes
no
 
 
 
grv_sub
yes
no
grv_ascej
yes
grv_domain
yes
no
 
 
 
grv_acc
yes
no
 
 
 
grv_sub
yes
no
 
 
 
grv_cc
yes
no
 
 
 
grv_entity
yes
no
 
 
 
grv_project
yes
no
 
grv_ceja
no
grv_domain
yes
no
 
 
 
grv_cc
yes
no
 
 
 
grv_entity
yes
no
 
 
 
grv_project
yes
no
 
 
 
grv_acc
yes
no
 
grv_cja
no
grv_domain
yes
no
 
 
 
grv_cc
yes
no
 
 
 
grv_project
yes
no
 
 
 
grv_acc
yes
no
 
grv_ejas
no
grv_domain
yes
no
 
 
 
grv_entity
yes
no
 
 
 
grv_project
yes
no
 
 
 
grv_acc
yes
no
 
 
 
grv_sub
yes
no
 
grv_jasc
no
grv_domain
yes
no
 
 
 
grv_project
yes
no
 
 
 
grv_acc
yes
no
 
 
 
grv_sub
yes
no
 
 
 
grv_cc
yes
no
 
grv_scej
no
grv_domain
yes
no
 
 
 
grv_sub
yes
no
 
 
 
grv_cc
yes
no
 
 
 
grv_entity
yes
no
 
 
 
grv_project
yes
no
 
grv_sej
no
grv_domain
yes
no
 
 
 
grv_sub
yes
no
 
 
 
grv_entity
yes
no
 
 
 
grv_project
yes
no
 
grv_sjc
no
grv_domain
yes
no
 
 
 
grv_sub
yes
no
 
 
 
grv_project
yes
no
 
 
 
grv_cc
yes
no
 
oid_grv_det
yes
oid_grv_det
yes
no
grx1_wkfl
GL Report Writer Analysis Code Explosion Work Table
 
 
Field Name
Label
Col-Label
Format
Dec
 
grx1__qadc01
 
 
x(8)
 
 
grx1_an_code
Analysis Code
 
x(8)
 
 
grx1_domain
Domain
 
x(8)
 
 
grx1_link_code
Link Code
 
x(8)
 
 
grx1_link_type
G/L Type
 
x(1)
 
 
grx1_run_id
Report Run ID
 
>>>>>>9
 
 
grx1_user1
Ufld1
 
x(8)
 
 
grx1_user2
Ufld2
 
x(8)
 
 
oid_grx1_wkfl
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
grx1_an_code
no
grx1_domain
yes
no
 
 
 
grx1_run_id
yes
no
 
 
 
grx1_link_type
yes
no
 
 
 
grx1_an_code
yes
no
 
 
 
grx1_link_code
yes
no
 
grx1_link
no
grx1_domain
yes
no
 
 
 
grx1_run_id
yes
no
 
 
 
grx1_link_type
yes
no
 
 
 
grx1_link_code
yes
no
 
 
 
grx1_an_code
yes
no
 
oid_grx1_wkfl
yes
oid_grx1_wkfl
yes
no
grx2_wkfl
GL Report Writer Row/Column Explosion (Separate) Work Table
 
 
Field Name
Label
Col-Label
Format
Dec
 
grx2__qadc01
 
 
x(8)
 
 
grx2_acct
Account
 
x(8)
 
 
grx2_actual
Actual/Budget
 
yes/no
 
 
grx2_bg_code
Budget Code
 
x(8)
 
 
grx2_cc
Cost Center
CC
x(8)
 
 
grx2_domain
Domain
 
x(8)
 
 
grx2_entity
Entity
 
x(20)
 
 
grx2_level
Level
 
999
 
 
grx2_nbr
Row or Column Number
 
9999
 
 
grx2_project
Project
 
x(8)
 
 
grx2_run_id
Report Run ID
 
>>>>>>9
 
 
grx2_sub
Sub-Account
Sub-Acct
x(8)
 
 
grx2_type
Type - Row or Column
 
Row/Col
 
 
grx2_user1
Ufld1
 
x(8)
 
 
grx2_user2
Ufld2
 
x(8)
 
 
oid_grx2_wkfl
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
grx2_level
no
grx2_domain
yes
no
 
 
 
grx2_run_id
yes
no
 
 
 
grx2_type
yes
no
 
 
 
grx2_nbr
yes
no
 
 
 
grx2_level
yes
no
 
oid_grx2_wkfl
yes
oid_grx2_wkfl
yes
no
grx3_wkfl
GL Report Writer Row/Column Explosion (Hier.) Work Table
 
 
Field Name
Label
Col-Label
Format
Dec
 
grx3__qadc01
 
 
x(8)
 
 
grx3_col
Column
 
999
 
 
grx3_domain
Domain
 
x(8)
 
 
grx3_element1
Element 1
 
x(8)
 
 
grx3_element2
Element 2
 
x(8)
 
 
grx3_element3
Element 3
 
x(8)
 
 
grx3_element4
Element 4
 
x(8)
 
 
grx3_element5
Element 5
 
x(8)
 
 
grx3_explode
Explode To Level
 
99
 
 
grx3_line
Exploded Line Number
 
999999
 
 
grx3_priority
Element Priority
 
99999
 
 
grx3_row
Row
 
9999
 
 
grx3_run_id
Report Run ID
 
>>>>>>9
 
 
grx3_user1
Ufld1
 
x(8)
 
 
grx3_user2
Ufld2
 
x(8)
 
 
oid_grx3_wkfl
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
grx3_element
no
grx3_domain
yes
no
 
 
 
grx3_run_id
yes
no
 
 
 
grx3_row
yes
no
 
 
 
grx3_element1
yes
no
 
 
 
grx3_element2
yes
no
 
 
 
grx3_element3
yes
no
 
 
 
grx3_element4
yes
no
 
 
 
grx3_element5
yes
no
 
grx3_line
no
grx3_domain
yes
no
 
 
 
grx3_run_id
yes
no
 
 
 
grx3_row
yes
no
 
 
 
grx3_col
yes
no
 
 
 
grx3_line
yes
no
grx3_row
no
grx3_domain
yes
no
 
 
 
grx3_run_id
yes
no
 
 
 
grx3_row
yes
no
 
 
 
grx3_col
yes
no
 
 
 
grx3_element1
yes
no
 
 
 
grx3_element2
yes
no
 
 
 
grx3_element3
yes
no
 
 
 
grx3_element4
yes
no
 
 
 
grx3_element5
yes
no
 
oid_grx3_wkfl
yes
oid_grx3_wkfl
yes
no