|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
defr__qadc01
|
|
|
x(24)
|
|
|
|
defr__qadc02
|
|
|
x(24)
|
|
|
|
defr__qadd01
|
|
|
->>>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
defr__qadi01
|
|
|
->>>>>>>9
|
|
|
|
defr__qadl01
|
|
|
yes/no
|
|
|
|
defr__qadt01
|
|
|
99/99/99
|
|
|
|
defr_accr_amt
|
Accrued Amount
|
|
->>>>,>>>,>>9.99<
|
10
|
|
|
defr_acct
|
Deferred Revenue
|
Deferred
|
x(8)
|
|
|
|
defr_amt_type
|
Amount Type
|
AT
|
x(1)
|
|
|
|
defr_bill_to
|
Bill To
|
|
x(8)
|
|
|
|
defr_cc
|
Deferred Revenue CC
|
|
x(4)
|
|
|
|
defr_curr
|
Currency
|
Cur
|
x(3)
|
|
|
|
defr_cust
|
Customer
|
|
x(8)
|
|
|
|
defr_domain
|
Domain
|
|
x(8)
|
|
|
|
defr_dsc_acct
|
Discount Acct
|
|
x(8)
|
|
|
|
defr_dsc_cc
|
Discount CC
|
|
x(4)
|
|
|
|
defr_dsc_project
|
Project
|
|
x(8)
|
|
|
|
defr_dsc_sub
|
Discount Sub-Acct
|
|
x(8)
|
|
|
|
defr_eff_date
|
Effective Date
|
Eff Date
|
99/99/99
|
|
|
|
defr_entity
|
Entity
|
Enty
|
x(20)
|
|
|
|
defr_eu_nbr
|
End User
|
|
x(8)
|
|
|
|
defr_ex_rate
|
Exch Rate
|
|
>>>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
defr_ex_rate2
|
Exch Rate 2
|
|
>>>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
defr_ex_ratetype
|
Rate Type
|
|
x(8)
|
|
|
|
defr_exru_seq
|
Sequence
|
|
>>>>>>>>9
|
|
|
|
defr_for
|
Supported Item
|
Item
|
x(18)
|
|
|
|
defr_inv_amt
|
Invoiced Amount
|
|
->>>>,>>>,>>9.99<
|
10
|
|
|
defr_inv_nbr
|
Invoice
|
|
x(22)
|
|
|
|
defr_line
|
Contract Line
|
Con Line
|
>>>>>>>9
|
|
|
|
defr_mod_date
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
defr_mod_userid
|
User ID
|
|
x(8)
|
|
|
|
defr_nbr
|
Contract
|
|
x(8)
|
|
|
|
defr_per_period_amt
|
Per Period Amount
|
|
->>>>,>>>,>>9.99<
|
10
|
|
|
defr_per_prd_dsc_amt
|
Per Period Dsc Amount
|
|
->>>>,>>>,>>9.99<
|
10
|
|
|
defr_period_curr_amt
|
Period Cur Amount
|
|
->>>>,>>>,>>9.99<
|
10
|
|
|
defr_period_remain
|
Period Rem
|
|
->>>9.9<<<
|
10
|
|
|
defr_prd_dsc_curr_amt
|
Period Dsc Cur Amount
|
|
->>>>,>>>,>>9.99<
|
10
|
|
|
defr_prefix
|
Pf
|
|
x(1)
|
|
|
|
defr_project
|
Project
|
|
x(8)
|
|
|
|
defr_rec_amt
|
Recognized Amount
|
|
->>>>,>>>,>>9.99<
|
10
|
|
|
defr_rev_amt
|
Revenue Amount
|
|
->>>>,>>>,>>9.99<
|
10
|
|
|
defr_sls_acct
|
Sales Acct
|
|
x(8)
|
|
|
|
defr_sls_cc
|
Sales CC
|
|
x(4)
|
|
|
|
defr_sls_sub
|
Sales Sub-Acct
|
|
x(8)
|
|
|
|
defr_sub
|
Deferred Revenue Sub-Acct
|
|
x(8)
|
|
|
|
defr_user1
|
User Field Character 1
|
|
x(24)
|
|
|
|
defr_user2
|
User Field Character 2
|
|
x(24)
|
|
|
|
defr_userd01
|
User Field Decimal 1
|
|
->>>>,>>>,>>9.99<<<<<<<<
|
10
|
|
|
defr_useri01
|
User Field Integer 1
|
|
->>>>>>>9
|
|
|
|
defr_userl01
|
User Field Logical 1
|
|
yes/no
|
|
|
|
defr_usert01
|
User Field Date 1
|
|
99/99/99
|
|
|
|
oid_defr_det
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
defr_nbrln
|
yes
|
defr_domain
|
yes
|
no
|
|
|
|
|
defr_nbr
|
yes
|
no
|
|
|
|
|
defr_prefix
|
yes
|
no
|
|
|
|
|
defr_line
|
yes
|
no
|
|
|
|
|
defr_inv_nbr
|
yes
|
no
|
|
|
oid_defr_det
|
yes
|
oid_defr_det
|
yes
|
no
|