QAD 2017 Enterprise Edition > Technical References > Database Definitions >
  
rqda_det
Requisition Approval Detail
 
 
Field Name
Label
Col-Label
Format
Dec
 
oid_rqda_det
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
rqda__chr01
 
 
x(8)
 
 
rqda__chr02
 
 
x(8)
 
 
rqda__chr03
 
 
x(8)
 
 
rqda__chr04
 
 
x(8)
 
 
rqda__qadc01
QAD Field
 
X(8)
0
 
rqda__qadc02
QAD Field
 
X(8)
0
 
rqda__qadc03
QAD Field
 
X(8)
0
 
rqda__qadc04
QAD Field
 
X(8)
0
 
rqda_action
Action
 
x(20)
 
 
rqda_apr_userid
User ID
 
x(8)
 
 
rqda_date
Date
 
99/99/99
 
 
rqda_domain
Domain
 
x(8)
 
 
rqda_ent_userid
Entered By
 
x(8)
 
 
rqda_nbr
Req Nbr
 
x(8)
 
 
rqda_time
Time
 
>>>>>>>9
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
oid_rqda_det
yes
oid_rqda_det
yes
no
 
rqda_apr_userid
no
rqda_domain
yes
no
 
 
 
rqda_apr_userid
yes
no
 
 
 
rqda_nbr
yes
no
rqda_nbr
yes
rqda_domain
yes
no
 
 
 
rqda_nbr
yes
no
 
 
 
rqda_apr_userid
yes
no
rqd_det
Requisition Detail
 
 
Field Name
Label
Col-Label
Format
Dec
 
oid_rqd_det
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
rqd__chr01
 
 
x(8)
 
 
rqd__chr02
 
 
x(8)
 
 
rqd__chr03
 
 
x(8)
 
 
rqd__chr04
 
 
x(8)
 
 
rqd__qadc01
QAD Field
 
X(8)
0
 
rqd__qadc02
QAD Field
 
X(8)
0
 
rqd__qadc03
QAD Field
 
X(8)
0
 
rqd__qadc04
QAD Field
 
X(8)
0
 
rqd_acct
Pur Acct
 
x(8)
 
 
rqd_aprv_stat
Aprvl Status
 
x(16)
 
 
rqd_assay
Assay %
 
>>9.99%
10
 
rqd_category
Category
 
x(8)
 
 
rqd_cc
Cost Ctr
CC
x(4)
 
 
rqd_cmtindx
Comment Index
Comment
>>>>>>>9
 
 
rqd_desc
Desc
 
x(30)
 
 
rqd_disc_pct
Disc%
 
->9.99%
10
 
rqd_domain
Domain
 
x(8)
 
 
rqd_due_date
Due Date
 
99/99/99
 
 
rqd_expire
Expire Date
Expire
99/99/99
 
 
rqd_grade
Grade
 
x(2)
 
 
rqd_insp_rqd
Inspect Req
Insp
yes/no
 
 
rqd_item_rev_date
Item Revision Date
Item Rev Date
99/99/99
 
 
rqd_line
Line
 
>>>
 
 
rqd_loc
Location
 
x(8)
 
 
rqd_lot_rcpt
Single Lot
 
yes/no
 
 
rqd_max_cost
Max Unit Cost
 
>>>,>>>,>>9.99<<<
10
 
rqd_nbr
Req Nbr
 
x(8)
 
 
rqd_need_date
Need Date
Need
99/99/99
 
 
rqd_oot_extra[8]
 
 
x(16)
 
 
rqd_oot_ponetcst
PO Net Unit Cost
PO Net!Unit Cost
>>>,>>>,>>9.99<<<
10
 
rqd_oot_poum
PO Stock UM
PO!Stk UM
x(2)
 
 
rqd_oot_rqnetcst
Req Max Unit Cost
Req Max!Unit Cost
>>>,>>>,>>9.99<<<
10
 
rqd_oot_rqum
Req Stock UM
Req!Stk UM
x(2)
 
 
rqd_op
Operation
 
>>>>>9
 
 
rqd_open
Open
 
yes/no
 
 
rqd_part
Item Number
 
x(18)
 
 
rqd_pr_list
Disc Tbl
 
x(8)
 
 
rqd_pr_list2
Pr Tbl
 
x(8)
 
 
rqd_project
Project
 
x(8)
 
 
rqd_pur_cost
Unit Cost
 
>>>,>>>,>>9.99<<<
10
 
rqd_rctstat
Receipt Status
Status
x(8)
 
 
rqd_rel_date
Release Date
Release
99/99/99
 
 
rqd_req_qty
Req Qty
 
>,>>>,>>9.9<<<<<<<<
10
 
rqd_rev
Item Revision
Item Rev
x(4)
 
 
rqd_ship
Ship-to
 
x(8)
 
 
rqd_site
Site
 
x(8)
 
 
rqd_status
Status
 
x(1)
 
 
rqd_sub_type
Subcontract Type
 
x(12)
 
 
rqd_taxable
Tax
 
yes/no
 
 
rqd_type
Type
 
x(1)
 
 
rqd_um
UM
 
x(2)
 
 
rqd_um_conv
UM Conv
 
>>>>9.9999<<<<
10
 
rqd_vend
Supplier
 
x(8)
 
 
rqd_vpart
Supplier Part
 
x(30)
 
 
rqd_wip_lotser
Lot/Serial
 
x(18)
 
 
rqd_wo_lot
Work Order ID
 
x(8)
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
oid_rqd_det
yes
oid_rqd_det
yes
no
 
rqd_aprv_stat
no
rqd_domain
yes
no
 
 
 
rqd_aprv_stat
yes
no
 
 
 
rqd_nbr
yes
no
rqd_nbr
yes
rqd_domain
yes
no
 
 
 
rqd_nbr
yes
no
 
 
 
rqd_line
yes
no
 
rqd_need_date
no
rqd_domain
yes
no
 
 
 
rqd_need_date
yes
no
 
 
 
rqd_nbr
yes
no
 
 
 
rqd_line
yes
no
 
rqd_part
no
rqd_domain
yes
no
 
 
 
rqd_part
yes
no
 
 
 
rqd_nbr
yes
no
 
 
 
rqd_line
yes
no
 
rqd_site
no
rqd_domain
yes
no
 
 
 
rqd_site
yes
no
 
 
 
rqd_nbr
yes
no
 
 
 
rqd_line
yes
no
 
rqd_vend
no
rqd_domain
yes
no
 
 
 
rqd_vend
yes
no
 
 
 
rqd_nbr
yes
no
 
 
 
rqd_line
yes
no
rqf_ctrl
Requisition Control
 
 
Field Name
Label
Col-Label
Format
Dec
 
oid_rqf_ctrl
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
rqf__chr01
 
 
x(8)
 
 
rqf__chr02
 
 
x(8)
 
 
rqf__chr03
 
 
x(8)
 
 
rqf__chr04
 
 
x(8)
 
 
rqf__dec01
 
 
->>,>>9.99
10
 
rqf__dte01
 
 
99/99/99
 
 
rqf__log01
 
 
yes/no
 
 
rqf__qadc01
QAD Field
 
X(8)
0
 
rqf__qadc02
QAD Field
 
X(8)
0
 
rqf__qadc03
QAD Field
 
X(8)
0
 
rqf__qadc04
QAD Field
 
X(8)
0
 
rqf__qadi01
 
 
->>>>>>>9
 
 
rqf__qadl01
 
 
yes/no
 
 
rqf_appr_curr
Approval Currency
 
x(3)
 
 
rqf_appr_seq_id
Approval Sequence
 
x(8)
 
 
rqf_diraprs_req
Product Line Approvals Required
 
>9
 
 
rqf_domain
Domain
 
x(8)
 
 
rqf_email_opt
E-mail Option
 
x(1)
 
 
rqf_hcmmts
Header Comments
 
yes/no
 
 
rqf_horaprs_req
Horizontal Approvals Required
 
>9
 
 
rqf_lcmmts
Line Comments
 
yes/no
 
 
rqf_ln_fmt
Ln Format (S/M)
 
single/multi
 
 
rqf_nbr
Next Requisition Number
 
99999999
 
 
rqf_oot_rtg
Out Of Tolerance Routing
 
x(1)
 
 
rqf_oot_rtg_mode
Out of Tolerance Routing Mode (A/M)
 
automatic/manual
 
 
rqf_pc_line
Price by Requisition Line
 
yes/no
 
 
rqf_pre
Requisition Prefix
 
x(3)
 
 
rqf_prohibit
Prohibit Changes
 
yes/no
 
 
rqf_reset
Reset Approvals Upon Denial
 
yes/no
 
 
rqf_tol_pct
Tolerance Percent
 
>>9.99
10
 
rqf_tol_val
Tolerance Value
 
>>>>,>>9.99
10
 
rqf_use_tolpct
Use Tolerance Percent
 
yes/no
 
 
rqf_use_tolval
Use Tolerance Value
 
yes/no
 
 
rqf_vrtaprs_req
Vertical Approvals Required
 
>9
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
oid_rqf_ctrl
yes
oid_rqf_ctrl
yes
no
rqf_index1
yes
rqf_domain
yes
no
rqh_hist
Requisition History
 
 
Field Name
Label
Col-Label
Format
Dec
 
oid_rqh_hist
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
rqh__chr01
 
 
x(8)
 
 
rqh__chr02
 
 
x(8)
 
 
rqh__chr03
 
 
x(8)
 
 
rqh__chr04
 
 
x(8)
 
 
rqh__qadc01
QAD Field
 
X(8)
0
 
rqh__qadc02
QAD Field
 
X(8)
0
 
rqh__qadc03
QAD Field
 
X(8)
0
 
rqh__qadc04
QAD Field
 
X(8)
0
 
rqh_action
Action
 
x(20)
 
 
rqh_apr_userid
User ID
 
x(8)
 
 
rqh_date
Date
 
99/99/99
 
 
rqh_domain
Domain
 
x(8)
 
 
rqh_email_list
Email Sent To User ID
Email Sent!To User ID
x(255)
 
 
rqh_ent_userid
Entered By
 
x(8)
 
 
rqh_line
Line
 
>>>
 
 
rqh_nbr
Req Nbr
 
x(8)
 
 
rqh_role
Role
 
x(1)
 
 
rqh_role_list
Role
 
X(255)
 
 
rqh_rtto_userid
Route To
 
x(8)
 
 
rqh_seq_nbr
 
 
99999999
 
 
rqh_time
Time
 
>>>>>>>9
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
oid_rqh_hist
yes
oid_rqh_hist
yes
no
rqh_nbr
yes
rqh_domain
yes
no
 
 
 
rqh_nbr
yes
no
 
 
 
rqh_date
yes
no
 
 
 
rqh_time
yes
no
 
 
 
rqh_seq_nbr
yes
no
 
rqh_nbr_usr
no
rqh_domain
yes
no
 
 
 
rqh_nbr
yes
no
 
 
 
rqh_apr_userid
yes
no
 
 
 
rqh_date
yes
no
 
 
 
rqh_time
yes
no
 
 
 
rqh_seq_nbr
yes
no
rqj_mstr
Requisition Job Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
oid_rqj_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
rqj__chr01
 
 
x(8)
 
 
rqj__chr02
 
 
x(8)
 
 
rqj__chr03
 
 
x(8)
 
 
rqj__chr04
 
 
x(8)
 
 
rqj__qadc01
QAD Field
 
X(8)
0
 
rqj__qadc02
QAD Field
 
X(8)
0
 
rqj__qadc03
QAD Field
 
X(8)
0
 
rqj__qadc04
QAD Field
 
X(8)
0
 
rqj_desc
Description
 
x(24)
 
 
rqj_domain
Domain
 
x(8)
 
 
rqj_end
End Effective
 
99/99/99
 
 
rqj_job
Job
 
x(8)
 
 
rqj_start
Start Effective
 
99/99/99
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
oid_rqj_mstr
yes
oid_rqj_mstr
yes
no
rqj_job
yes
rqj_domain
yes
no
 
 
 
rqj_job
yes
no
rql_mstr
Requisition Approval Level Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
oid_rql_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
rql__chr01
 
 
x(8)
 
 
rql__chr02
 
 
x(8)
 
 
rql__chr03
 
 
x(8)
 
 
rql__chr04
 
 
x(8)
 
 
rql__dec01
 
 
->>,>>9.99
10
 
rql__qadc01
QAD Field
 
X(8)
0
 
rql__qadc02
QAD Field
 
X(8)
0
 
rql__qadc03
QAD Field
 
X(8)
0
 
rql__qadc04
QAD Field
 
X(8)
0
 
rql_amt
Amount
 
>>>,>>>,>>>,>>9
10
 
rql_desc
Description
 
x(34)
 
 
rql_domain
Domain
 
x(8)
 
 
rql_level
Approval Level
 
99
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
oid_rql_mstr
yes
oid_rql_mstr
yes
no
rql_lev
yes
rql_domain
yes
no
 
 
 
rql_level
yes
no
rqm_det
Requirement Detail
 
 
Field Name
Label
Col-Label
Format
Dec
 
oid_rqm_det
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
rqm__qadc01
 
 
x(8)
 
 
rqm_cat
Category
 
x(10)
 
 
rqm_date
Date
 
99/99/99
 
 
rqm_domain
Domain
 
x(8)
 
 
rqm_interval
Interval
 
x(1)
 
 
rqm_line
Line
 
>>9
 
 
rqm_nbr
Order
 
x(8)
 
 
rqm_reference
Reference
Ref
x(24)
 
 
rqm_rlse_id
Rlse Id
Rlse! Id
x(30)
 
 
rqm_time
Time
 
99:99
 
 
rqm_type
Type
 
>9
 
 
rqm_user1
Ufld1
 
x(8)
 
 
rqm_user2
Ufld2
 
x(8)
 
 
rqm_value
Value
 
x(24)
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
oid_rqm_det
yes
oid_rqm_det
yes
no
 
rqm_cat_val_date
no
rqm_domain
yes
no
 
 
 
rqm_cat
yes
no
 
 
 
rqm_value
yes
no
 
 
 
rqm_date
yes
no
 
 
 
rqm_type
yes
no
rqm_schd
no
rqm_domain
yes
no
 
 
 
rqm_type
yes
no
 
 
 
rqm_nbr
yes
no
 
 
 
rqm_line
yes
no
 
 
 
rqm_rlse_id
yes
no
 
 
 
rqm_date
yes
no
 
 
 
rqm_time
yes
no
 
 
 
rqm_interval
yes
no
 
 
 
rqm_reference
yes
no
 
 
 
rqm_cat
yes
no
 
rqm_value
no
rqm_domain
yes
no
 
 
 
rqm_type
yes
no
 
 
 
rqm_cat
yes
no
 
 
 
rqm_date
yes
no
 
 
 
rqm_value
yes
no
rqm_mstr
Requisition Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
oid_rqm_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
rqm__chr01
 
 
x(8)
 
 
rqm__chr02
 
 
x(8)
 
 
rqm__chr03
 
 
x(8)
 
 
rqm__chr04
 
 
x(8)
 
 
rqm__dec01
 
 
->>,>>9.99
10
 
rqm__log01
 
 
yes/no
 
 
rqm__qadc01
QAD Field
 
X(8)
0
 
rqm__qadc02
QAD Field
 
X(8)
0
 
rqm__qadc03
QAD Field
 
X(8)
0
 
rqm__qadc04
QAD Field
 
X(8)
0
 
rqm_acct
Account
 
x(8)
 
 
rqm_apr_cmtindx
Approval Comments
 
>>>>>>>9
 
 
rqm_aprv_stat
Aprvl Status
 
x(16)
 
 
rqm_bill
Bill-To
 
x(8)
 
 
rqm_buyer
Buyer
 
x(8)
 
 
rqm_category
Category
 
x(8)
 
 
rqm_cc
Cost Ctr
CC
x(4)
 
 
rqm_cls_date
Close Date
Closed
99/99/99
 
 
rqm_cmtindx
Comments
 
>>>>>>>9
 
 
rqm_contact
Contact
 
x(24)
 
 
rqm_curr
Currency
 
x(3)
 
 
rqm_daybookset
Daybook Set
Dybk Set
x(8)
 
 
rqm_direct
Direct Matls
 
yes/no
 
 
rqm_disc_pct
Disc %
 
->9.99%
10
 
rqm_domain
Domain
 
x(8)
 
 
rqm_due_date
Due Date
 
99/99/99
 
 
rqm_eby_userid
Entered By
 
x(8)
 
 
rqm_email_opt
E-mail Option
 
x(1)
 
 
rqm_end_userid
End User
 
x(8)
 
 
rqm_ent_date
Ent Date
 
99/99/99
 
 
rqm_ent_ex
Exch Rate
 
>>,>>9.99999<<<<<
10
 
rqm_entity
Entity
Ent
x(20)
 
 
rqm_ex_rate
Exch Rate
 
>>>>,>>>,>>9.9<<<<<<<<<
10
 
rqm_ex_rate2
Exch Rate 2
 
>>>>,>>>,>>9.9<<<<<<<<<
10
 
rqm_ex_ratetype
Rate Type
 
x(8)
 
 
rqm_exru_seq
Sequence
 
>>>>>>>>9
 
 
rqm_fix_pr
Fixed Price
 
yes/no
 
 
rqm_fix_rate
Fixed Rate
 
yes/no
 
 
rqm_fob
FOB
 
x(20)
 
 
rqm_job
Job
 
x(8)
 
 
rqm_lang
Lang
 
x(2)
 
 
rqm_ln_fmt
Single/Multi
 
single/multi
 
 
rqm_max_total
Max Ext Cost Total
Max Ext!Cost Total
->>>>,>>>,>>9.99<<<
10
 
rqm_nbr
Req Nbr
 
x(8)
 
 
rqm_need_date
Need Date
 
99/99/99
 
 
rqm_open
Open
 
yes/no
 
 
rqm_partial
Partial OK
 
yes/no
 
 
rqm_pent_userid
Prev Route To Entered By
 
x(8)
 
 
rqm_pr_list
Disc Tbl
 
x(8)
 
 
rqm_pr_list2
Price Tbl
Pr Tbl
x(8)
 
 
rqm_prev_rtp
 
 
yes/no
 
 
rqm_prev_userid
Prev Route To
 
X(8)
 
 
rqm_print
Print Req
 
yes/no
 
 
rqm_project
Project
 
x(8)
 
 
rqm_reason
Reason
 
x(30)
 
 
rqm_req_date
Rqstn Date
 
99/99/99
 
 
rqm_rmks
Remarks
 
x(40)
 
 
rqm_rqby_userid
Requested By
Req By
x(8)
 
 
rqm_rtdto_purch
Routed To Purchasing
Routed To!Purchasing
yes/no
 
 
rqm_rtto_date
Date Routed
 
99/99/99
 
 
rqm_rtto_time
Time Routed
 
>>>>>>>9
 
 
rqm_rtto_userid
Route To
 
x(8)
 
 
rqm_ship
Ship to
 
x(8)
 
 
rqm_shipvia
Ship Via
 
x(20)
 
 
rqm_site
Site
 
x(8)
 
 
rqm_status
Status
 
x(1)
 
 
rqm_sub
Sub-Account
Sub-Acct
x(8)
 
 
rqm_total
Ext Cost Total
Ext!Cost Total
->>>>,>>>,>>9.99<<<
10
 
rqm_type
Type
 
x(1)
 
 
rqm_vend
Supplier
 
x(8)
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
oid_rqm_mstr
yes
oid_rqm_mstr
yes
no
 
rqm_buyer
no
rqm_domain
yes
no
 
 
 
rqm_buyer
yes
no
 
 
 
rqm_rtdto_purch
yes
no
 
 
 
rqm_nbr
yes
no
 
rqm_job
no
rqm_domain
yes
no
 
 
 
rqm_job
yes
no
 
 
 
rqm_rtdto_purch
yes
no
 
 
 
rqm_nbr
yes
no
rqm_nbr
yes
rqm_domain
yes
no
 
 
 
rqm_nbr
yes
no
 
rqm_open
no
rqm_domain
yes
no
 
 
 
rqm_open
yes
no
 
 
 
rqm_rtdto_purch
yes
no
 
 
 
rqm_nbr
yes
no
 
rqm_rqby_userid
no
rqm_domain
yes
no
 
 
 
rqm_rqby_userid
yes
no
 
 
 
rqm_rtdto_purch
yes
no
 
 
 
rqm_nbr
yes
no
 
rqm_rtto
no
rqm_domain
yes
no
 
 
 
rqm_rtto_userid
yes
no
 
 
 
rqm_open
yes
no
 
 
 
rqm_nbr
yes
no
rqpo_ref
Requisition/PO Cross-Reference
 
 
Field Name
Label
Col-Label
Format
Dec
 
oid_rqpo_ref
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
rqpo__chr01
 
 
x(8)
 
 
rqpo__chr02
 
 
x(8)
 
 
rqpo__chr03
 
 
x(8)
 
 
rqpo__chr04
 
 
x(8)
 
 
rqpo__qadc01
QAD Field
 
X(8)
0
 
rqpo__qadc02
QAD Field
 
X(8)
0
 
rqpo__qadc03
QAD Field
 
X(8)
0
 
rqpo__qadc04
QAD Field
 
X(8)
0
 
rqpo_domain
Domain
 
x(8)
 
 
rqpo_po_line
PO Line
 
>>>
 
 
rqpo_po_nbr
Purchase Order
PO Nbr
x(8)
 
 
rqpo_qty_ord
Qty Ord
 
->,>>>,>>9.9<<<<<<<<
10
 
rqpo_req_line
Req Line
 
>>>
 
 
rqpo_req_nbr
Requisition
Req Nbr
x(8)
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
oid_rqpo_ref
yes
oid_rqpo_ref
yes
no
 
rqpo_po_nbr
no
rqpo_domain
yes
no
 
 
 
rqpo_po_nbr
yes
no
 
 
 
rqpo_po_line
yes
no
 
 
 
rqpo_req_nbr
yes
no
 
 
 
rqpo_req_line
yes
no
rqpo_req_nbr
yes
rqpo_domain
yes
no
 
 
 
rqpo_req_nbr
yes
no
 
 
 
rqpo_req_line
yes
no
 
 
 
rqpo_po_nbr
yes
no
 
 
 
rqpo_po_line
yes
no
rqr_mstr
Role Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
oid_rqr_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
rqr__chr01
 
 
x(8)
 
 
rqr__chr02
 
 
x(8)
 
 
rqr__chr03
 
 
x(8)
 
 
rqr__chr04
 
 
x(8)
 
 
rqr__qadc01
QAD Field
 
X(8)
0
 
rqr__qadc02
QAD Field
 
X(8)
0
 
rqr__qadc03
QAD Field
 
X(8)
0
 
rqr__qadc04
QAD Field
 
X(8)
0
 
rqr_domain
Domain
 
x(8)
 
 
rqr_role
Role
 
x(8)
 
 
rqr_userid
User ID
 
x(8)
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
oid_rqr_mstr
yes
oid_rqr_mstr
yes
no
 
rqr_role
yes
rqr_domain
yes
no
 
 
 
rqr_role
yes
no
 
 
 
rqr_userid
yes
no
rqr_userid
yes
rqr_domain
yes
no
 
 
 
rqr_userid
yes
no
 
 
 
rqr_role
yes
no
rq_mstr
Requirement Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
oid_rq_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
rq__chr01
 
 
x(8)
 
 
rq__chr02
 
 
x(8)
 
 
rq__chr03
 
 
x(8)
 
 
rq__chr04
 
 
x(8)
 
 
rq__chr05
 
 
x(8)
 
 
rq__dec01
 
 
>>>,>>>,>>9.99
10
 
rq__dec02
 
 
>>>,>>>,>>9.99
10
 
rq__dte01
 
 
99/99/99
 
 
rq__dte02
 
 
99/99/99
 
 
rq__log01
 
 
yes/no
 
 
rq_domain
Domain
 
x(8)
 
 
rq_end
End Date
End
99/99/99
 
 
rq_lead
Lead Time (Days)
LT
>>9
 
 
rq_lt_off
Offset (Days)
Offset
->>9
 
 
rq_part
Item Number
 
x(18)
 
 
rq_qty_per
Resource Qty Per
Qty Per
->,>>>,>>9.9<<<<<<<<
10
 
rq_ref
Reference
 
x(8)
 
 
rq_rsc
Resource
 
x(8)
 
 
rq_site
Site
 
x(8)
 
 
rq_start
Start Date
Start
99/99/99
 
 
rq_user1
Ufld1
 
x(8)
 
 
rq_user2
Ufld2
 
x(8)
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
oid_rq_mstr
yes
oid_rq_mstr
yes
no
rq_part
yes
rq_domain
yes
no
 
 
 
rq_part
yes
no
 
 
 
rq_site
yes
no
 
 
 
rq_rsc
yes
no
 
 
 
rq_ref
yes
no
 
 
 
rq_start
yes
no
 
rq_rsc
no
rq_domain
yes
no
 
 
 
rq_rsc
yes
no
 
 
 
rq_site
yes
no
RRCalc
Revenue recognition calculation
 
 
Field Name
Label
Col-Label
Format
Dec
 
Company_ID
Link to Company
 
-99999999999
 
 
CustomCombo0
 
 
x(20)
 
 
CustomCombo1
 
 
x(20)
 
 
CustomCombo2
 
 
x(20)
 
 
CustomCombo3
 
 
x(20)
 
 
CustomCombo4
 
 
x(20)
 
 
CustomCombo5
 
 
x(20)
 
 
CustomCombo6
 
 
x(20)
 
 
CustomCombo7
 
 
x(20)
 
 
CustomCombo8
 
 
x(20)
 
 
CustomCombo9
 
 
x(20)
 
 
CustomDate0
 
 
99/99/9999
 
 
CustomDate1
 
 
99/99/9999
 
 
CustomDate2
 
 
99/99/9999
 
 
CustomDate3
 
 
99/99/9999
 
 
CustomDate4
 
 
99/99/9999
 
 
CustomDecimal0
 
 
->,>>>,>>9.99
4
 
CustomDecimal1
 
 
->,>>>,>>9.99
4
 
CustomDecimal2
 
 
->,>>>,>>9.99
4
 
CustomDecimal3
 
 
->,>>>,>>9.99
4
 
CustomDecimal4
 
 
->,>>>,>>9.99
4
 
CustomInteger0
 
 
->,>>>,>>9
 
 
CustomInteger1
 
 
->,>>>,>>9
 
 
CustomInteger2
 
 
->,>>>,>>9
 
 
CustomInteger3
 
 
->,>>>,>>9
 
 
CustomInteger4
 
 
->,>>>,>>9
 
 
CustomLong0
 
 
x(255)
 
 
CustomLong1
 
 
x(255)
 
 
CustomNote
 
 
x(2000)
 
 
CustomShort1
 
 
x(20)
 
 
CustomShort2
 
 
x(20)
 
 
CustomShort3
 
 
x(20)
 
 
CustomShort4
 
 
x(20)
 
 
CustomShort5
 
 
x(20)
 
 
CustomShort6
 
 
x(20)
 
 
CustomShort7
 
 
x(20)
 
 
CustomShort8
 
 
x(20)
 
 
CustomShort9
 
 
x(20)
 
 
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)
 
 
QADC03
 
 
x(40)
 
 
QADC04
 
 
x(40)
 
 
QADC05
 
 
x(40)
 
 
QADC06
 
 
x(40)
 
 
QADD01
 
 
->,>>>,>>9.9999
10
 
QADD02
 
 
->,>>>,>>9.9999
10
 
QADD03
 
 
->,>>>,>>9.9999
10
 
QADD04
 
 
->,>>>,>>9.9999
10
 
QADD05
 
 
->,>>>,>>9.9999
10
 
QADD06
 
 
->,>>>,>>9.9999
10
 
QADL01
 
 
yes/no
 
 
QADL02
 
 
yes/no
 
 
QADL03
 
 
yes/no
 
 
QADL04
 
 
yes/no
 
 
QADL05
 
 
yes/no
 
 
QADL06
 
 
yes/no
 
 
QADT01
 
 
99/99/9999
 
 
QADT02
 
 
99/99/9999
 
 
QADT03
 
 
99/99/9999
 
 
QADT04
 
 
99/99/9999
 
 
QADT05
 
 
99/99/9999
 
 
QADT06
 
 
99/99/9999
 
 
RRCalc_ID
Record ID
 
-99999999999
 
 
RRCalcDescription
Description
 
x(40)
 
 
RRCalcEffectiveDate
Effective Date
Effective Date
99/99/9999
 
 
RRCalcIsForecast
Forecast
Forecast
yes/no
 
 
RRCalcIsOpeningBalance
Opening Balance
Opening Balance
yes/no
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
CalcDate
no
RRCalcEffectiveDate
yes
no
 ∗
Prim
yes
RRCalc_ID
yes
no
RRCalcCont
Revenue recognition calculation contract
 
 
Field Name
Label
Col-Label
Format
Dec
 
CustomCombo0
 
 
x(20)
 
 
CustomCombo1
 
 
x(20)
 
 
CustomCombo2
 
 
x(20)
 
 
CustomCombo3
 
 
x(20)
 
 
CustomCombo4
 
 
x(20)
 
 
CustomCombo5
 
 
x(20)
 
 
CustomCombo6
 
 
x(20)
 
 
CustomCombo7
 
 
x(20)
 
 
CustomCombo8
 
 
x(20)
 
 
CustomCombo9
 
 
x(20)
 
 
CustomDate0
 
 
99/99/9999
 
 
CustomDate1
 
 
99/99/9999
 
 
CustomDate2
 
 
99/99/9999
 
 
CustomDate3
 
 
99/99/9999
 
 
CustomDate4
 
 
99/99/9999
 
 
CustomDecimal0
 
 
->,>>>,>>9.99
4
 
CustomDecimal1
 
 
->,>>>,>>9.99
4
 
CustomDecimal2
 
 
->,>>>,>>9.99
4
 
CustomDecimal3
 
 
->,>>>,>>9.99
4
 
CustomDecimal4
 
 
->,>>>,>>9.99
4
 
CustomInteger0
 
 
->,>>>,>>9
 
 
CustomInteger1
 
 
->,>>>,>>9
 
 
CustomInteger2
 
 
->,>>>,>>9
 
 
CustomInteger3
 
 
->,>>>,>>9
 
 
CustomInteger4
 
 
->,>>>,>>9
 
 
CustomLong0
 
 
x(255)
 
 
CustomLong1
 
 
x(255)
 
 
CustomNote
 
 
x(2000)
 
 
CustomShort0
 
 
x(20)
 
 
CustomShort1
 
 
x(20)
 
 
CustomShort2
 
 
x(20)
 
 
CustomShort3
 
 
x(20)
 
 
CustomShort4
 
 
x(20)
 
 
CustomShort5
 
 
x(20)
 
 
CustomShort6
 
 
x(20)
 
 
CustomShort7
 
 
x(20)
 
 
CustomShort8
 
 
x(20)
 
 
CustomShort9
 
 
x(20)
 
 
DistrPosting_ID
 
 
-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)
 
 
Posting_ID
Record ID
 
-99999999999
 
 
QADC01
 
 
x(40)
 
 
QADC02
 
 
x(255)
 
 
QADC03
 
 
x(40)
 
 
QADC04
 
 
x(40)
 
 
QADC05
 
 
x(40)
 
 
QADC06
 
 
x(40)
 
 
QADD01
 
 
->,>>>,>>9.9999
10
 
QADD02
 
 
->,>>>,>>9.9999
10
 
QADD03
 
 
->,>>>,>>9.9999
10
 
QADD04
 
 
->,>>>,>>9.9999
10
 
QADD05
 
 
->,>>>,>>9.9999
10
 
QADD06
 
 
->,>>>,>>9.9999
10
 
QADL01
 
 
yes/no
 
 
QADL02
 
 
yes/no
 
 
QADL03
 
 
yes/no
 
 
QADL04
 
 
yes/no
 
 
QADL05
 
 
yes/no
 
 
QADL06
 
 
yes/no
 
 
QADT01
 
 
99/99/9999
 
 
QADT02
 
 
99/99/9999
 
 
QADT03
 
 
99/99/9999
 
 
QADT04
 
 
99/99/9999
 
 
QADT05
 
 
99/99/9999
 
 
QADT06
 
 
99/99/9999
 
 
RRCalc_ID
Record ID
 
-99999999999
 
 
RRCalcCont_ID
Record ID
 
-99999999999
 
 
RRCalcContContractValueTC
TC Contract Value
 
->>>,>>>,>>>,>>9.99
4
 
RRCalcContIsATPRedistributed
Invoice redistribution done during calculation
 
yes/no
 
 
RRCalcContIsCompleted
Completed
 
yes/no
 
 
RRCalcContIsOnHold
Is contract on hold
 
yes/no
 
 
RRCalcContItemContractValueTC
TC Total contract value for items only
 
->>>,>>>,>>>,>>9.99
4
 
RRCalcContTotalInvoiceCC
SC Total Invoice
 
->>>,>>>,>>>,>>9.99
4
 
RRCalcContTotalInvoiceLC
BC Total Invoice
 
->>>,>>>,>>>,>>9.99
4
 
RRCalcContTotalInvoiceTC
TC Total Invoice
 
->>>,>>>,>>>,>>9.99
4
 
RRCalcContTotalSSPTC
TC Total SSP Value
 
->>>,>>>,>>>,>>9.99
4
 
RRCalcContVerIsOnHold
Is contract version on hold
 
yes/no
 
 
RRContract_ID
Record ID
 
-99999999999
 
 
RRContrVer_ID
Contract version used for calculation
 
-99999999999
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
DistrPosting
no
DistrPosting_ID
yes
no
 
Posting
no
Posting_ID
yes
no
 ∗
Prim
yes
RRCalcCont_ID
yes
no
 
RRCalc
no
RRCalc_ID
yes
no
 
RRContract
no
RRContract_ID
yes
no
RRCalcContLine
Revenue recognition calculation performance obligation
 
 
Field Name
Label
Col-Label
Format
Dec
 
CustomCombo0
 
 
x(20)
 
 
CustomCombo1
 
 
x(20)
 
 
CustomCombo2
 
 
x(20)
 
 
CustomCombo3
 
 
x(20)
 
 
CustomCombo4
 
 
x(20)
 
 
CustomCombo5
 
 
x(20)
 
 
CustomCombo6
 
 
x(20)
 
 
CustomCombo7
 
 
x(20)
 
 
CustomCombo8
 
 
x(20)
 
 
CustomCombo9
 
 
x(20)
 
 
CustomDate0
 
 
99/99/9999
 
 
CustomDate1
 
 
99/99/9999
 
 
CustomDate2
 
 
99/99/9999
 
 
CustomDate3
 
 
99/99/9999
 
 
CustomDate4
 
 
99/99/9999
 
 
CustomDecimal0
 
 
->,>>>,>>9.99
4
 
CustomDecimal1
 
 
->,>>>,>>9.99
4
 
CustomDecimal2
 
 
->,>>>,>>9.99
4
 
CustomDecimal3
 
 
->,>>>,>>9.99
4
 
CustomDecimal4
 
 
->,>>>,>>9.99
4
 
CustomInteger0
 
 
->,>>>,>>9
 
 
CustomInteger1
 
 
->,>>>,>>9
 
 
CustomInteger2
 
 
->,>>>,>>9
 
 
CustomInteger3
 
 
->,>>>,>>9
 
 
CustomInteger4
 
 
->,>>>,>>9
 
 
CustomLong0
 
 
x(255)
 
 
CustomLong1
 
 
x(255)
 
 
CustomNote
 
 
x(2000)
 
 
CustomShort0
 
 
x(20)
 
 
CustomShort1
 
 
x(20)
 
 
CustomShort2
 
 
x(20)
 
 
CustomShort3
 
 
x(20)
 
 
CustomShort4
 
 
x(20)
 
 
CustomShort5
 
 
x(20)
 
 
CustomShort6
 
 
x(20)
 
 
CustomShort7
 
 
x(20)
 
 
CustomShort8
 
 
x(20)
 
 
CustomShort9
 
 
x(20)
 
 
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)
 
 
QADC03
 
 
x(40)
 
 
QADC04
 
 
x(40)
 
 
QADC05
 
 
x(40)
 
 
QADC06
 
 
x(40)
 
 
QADD01
 
 
->,>>>,>>9.9999
10
 
QADD02
 
 
->,>>>,>>9.9999
10
 
QADD03
 
 
->,>>>,>>9.9999
10
 
QADD04
 
 
->,>>>,>>9.9999
10
 
QADD05
 
 
->,>>>,>>9.9999
10
 
QADD06
 
 
->,>>>,>>9.9999
10
 
QADL01
 
 
yes/no
 
 
QADL02
 
 
yes/no
 
 
QADL03
 
 
yes/no
 
 
QADL04
 
 
yes/no
 
 
QADL05
 
 
yes/no
 
 
QADL06
 
 
yes/no
 
 
QADT01
 
 
99/99/9999
 
 
QADT02
 
 
99/99/9999
 
 
QADT03
 
 
99/99/9999
 
 
QADT04
 
 
99/99/9999
 
 
QADT05
 
 
99/99/9999
 
 
QADT06
 
 
99/99/9999
 
 
RRCalc_ID
Record ID
 
-99999999999
 
 
RRCalcCont_ID
Record ID
 
-99999999999
 
 
RRCalcContLine_ID
Record ID
 
-99999999999
 
 
RRCalcContLineAcrCreditCC
SC Accrued Credit
SC Accrued Credit
->>>,>>>,>>>,>>9.99
4
 
RRCalcContLineAcrCreditLC
BC Accrued Credit
BC Accrued Credit
->>>,>>>,>>>,>>9.99
4
 
RRCalcContLineAcrCreditTC
TC Accrued Credit
TC Accrued Credit
->>>,>>>,>>>,>>9.99
4
 
RRCalcContLineAcrDebitCC
SC Accrued Debit
SC Accrued Debit
->>>,>>>,>>>,>>9.99
4
 
RRCalcContLineAcrDebitLC
BC Accrued Debit
BC Accrued Debit
->>>,>>>,>>>,>>9.99
4
 
RRCalcContLineAcrDebitTC
TC Accrued Debit
TC Accrued Debit
->>>,>>>,>>>,>>9.99
4
 
RRCalcContLineAcrDeltaCreditCC
SC Delta Accrued Credit
SC Delta Accrued Credit
->>>,>>>,>>>,>>9.99
4
 
RRCalcContLineAcrDeltaCreditLC
BC Delta Accrued Credit
BC Delta Accrued Credit
->>>,>>>,>>>,>>9.99
4
 
RRCalcContLineAcrDeltaCreditTC
TC Delta Accrued Credit
TC Delta Accrued Credit
->>>,>>>,>>>,>>9.99
4
 
RRCalcContLineAcrDeltaDebitCC
SC Delta Accrued Debit
SC Delta Accrued Debit
->>>,>>>,>>>,>>9.99
4
 
RRCalcContLineAcrDeltaDebitLC
BC Delta Accrued Debit
BC Delta Accrued Debit
->>>,>>>,>>>,>>9.99
4
 
RRCalcContLineAcrDeltaDebitTC
TC Delta Accrued Debit
TC Delta Accrued Debit
->>>,>>>,>>>,>>9.99
4
 
RRCalcContLineCompleteAmtTC
TC Complete Value
TC Complete Value
->>>,>>>,>>>,>>9.99
4
 
RRCalcContLineCompleteDate
Complete Date
 
99/99/9999
 
 
RRCalcContLineCompletePerc
% Complete
% Complete
->>9.99
2
 
RRCalcContLineDefCreditCC
SC Deferred Credit
SC Deferred Credit
->>>,>>>,>>>,>>9.99
4
 
RRCalcContLineDefCreditLC
BC Deferred Credit
BC Deferred Credit
->>>,>>>,>>>,>>9.99
4
 
RRCalcContLineDefCreditTC
TC Deferred Credit
TC Deferred Credit
->>>,>>>,>>>,>>9.99
4
 
RRCalcContLineDefDebitCC
SC Deferred Debit
SC Deferred Debit
->>>,>>>,>>>,>>9.99
4
 
RRCalcContLineDefDebitLC
BC Deferred Debit
BC Deferred Debit
->>>,>>>,>>>,>>9.99
4
 
RRCalcContLineDefDebitTC
TC Deferred Debit
TC Deferred Debit
->>>,>>>,>>>,>>9.99
4
 
RRCalcContLineDefDeltaCreditCC
SC Delta Deferred Credit
SC Delta Deferred Credit
->>>,>>>,>>>,>>9.99
4
 
RRCalcContLineDefDeltaCreditLC
BC Delta Deferred Credit
BC Delta Deferred Credit
->>>,>>>,>>>,>>9.99
4
 
RRCalcContLineDefDeltaCreditTC
TC Delta Deferred Credit
TC Delta Deferred Credit
->>>,>>>,>>>,>>9.99
4
 
RRCalcContLineDefDeltaDebitCC
SC Delta Deferred Debit
SC Delta Deferred Debit
->>>,>>>,>>>,>>9.99
4
 
RRCalcContLineDefDeltaDebitLC
BC Delta Deferred Debit
BC Delta Deferred Debit
->>>,>>>,>>>,>>9.99
4
 
RRCalcContLineDefDeltaDebitTC
TC Delta Deferred Debit
TC Delta Deferred Debit
->>>,>>>,>>>,>>9.99
4
 
RRCalcContLineDistInvCreditCC
SC Invoiced Credit Redistributed
SC Inv Credit Redistr
->>>,>>>,>>>,>>9.99
4
 
RRCalcContLineDistInvCreditLC
BC Invoiced Credit Redistributed
BC Inv Credit Redistr
->>>,>>>,>>>,>>9.99
4
 
RRCalcContLineDistInvCreditTC
TC Invoiced Credit Redistributed
TC Inv Credit Redistr
->>>,>>>,>>>,>>9.99
4
 
RRCalcContLineDistInvDebitCC
SC Invoiced Debit Redistributed
SC Inv Debit Redistr
->>>,>>>,>>>,>>9.99
4
 
RRCalcContLineDistInvDebitLC
BC Invoiced Debit Redistributed
BC Inv Debit Redistr
->>>,>>>,>>>,>>9.99
4
 
RRCalcContLineDistInvDebitTC
TC Invoiced Debit Redistributed
TC Inv Debit Redistr
->>>,>>>,>>>,>>9.99
4
 
RRCalcContLineDistInvDeltaCrCC
SC Inv Delta Credit Redistributed
SC Inv Delta Cr Redistr
->>>,>>>,>>>,>>9.99
4
 
RRCalcContLineDistInvDeltaCrLC
BC Inv Delta Credit Redistributed
BC Inv Delta Cr Redistr
->>>,>>>,>>>,>>9.99
4
 
RRCalcContLineDistInvDeltaCrTC
TC Inv Delta Credit Redistributed
TC Inv Delta Cr Redistr
->>>,>>>,>>>,>>9.99
4
 
RRCalcContLineDistInvDeltaDbCC
SC Inv Delta Debit Redistributed
SC Inv Delta Db Redistr
->>>,>>>,>>>,>>9.99
4
 
RRCalcContLineDistInvDeltaDbLC
BC Inv Delta Debit Redistributed
BC Inv Delta Db Redistr
->>>,>>>,>>>,>>9.99
4
 
RRCalcContLineDistInvDeltaDbTC
TC Inv Delta Debit Redistributed
TC Inv Delta Db Redistr
->>>,>>>,>>>,>>9.99
4
 
RRCalcContLineInvCreditCC
SC Invoiced Credit
SC Invoiced Credit
->>>,>>>,>>>,>>9.99
4
 
RRCalcContLineInvCreditLC
BC Invoiced Credit
BC Invoiced Credit
->>>,>>>,>>>,>>9.99
4
 
RRCalcContLineInvCreditTC
TC Invoiced Credit
TC Invoiced Credit
->>>,>>>,>>>,>>9.99
4
 
RRCalcContLineInvDebitCC
SC Invoiced Debit
SC Invoiced Debit
->>>,>>>,>>>,>>9.99
4
 
RRCalcContLineInvDebitLC
BC Invoiced Debit
BC Invoiced Debit
->>>,>>>,>>>,>>9.99
4
 
RRCalcContLineInvDebitTC
TC Invoiced Debit
TC Invoiced Debit
->>>,>>>,>>>,>>9.99
4
 
RRCalcContLineIsCompleted
Completed
 
yes/no
 
 
RRCalcContLineIsRuleMet
Is Revenue Rule Met
 
yes/no
 
 
RRCalcContLineRecCreditCC
SC Recognized Credit
SC Recognized Credit
->>>,>>>,>>>,>>9.99
4
 
RRCalcContLineRecCreditLC
BC Recognized Credit
BC Recognized Credit
->>>,>>>,>>>,>>9.99
4
 
RRCalcContLineRecCreditTC
TC Recognized Credit
TC Recognized Credit
->>>,>>>,>>>,>>9.99
4
 
RRCalcContLineRecDebitCC
SC Recognized Debit
SC Recognized Debit
->>>,>>>,>>>,>>9.99
4
 
RRCalcContLineRecDebitLC
BC Recognized Debit
BC Recognized Debit
->>>,>>>,>>>,>>9.99
4
 
RRCalcContLineRecDebitTC
TC Recognized Debit
TC Recognized Debit
->>>,>>>,>>>,>>9.99
4
 
RRCalcContLineRecDeltaCreditCC
SC Delta Recognized Credit
SC Delta Recognized Credit
->>>,>>>,>>>,>>9.99
4
 
RRCalcContLineRecDeltaCreditLC
BC Delta Recognized Credit
BC Delta Recognized Credit
->>>,>>>,>>>,>>9.99
4
 
RRCalcContLineRecDeltaCreditTC
TC Delta Recognized Credit
TC Delta Recognized Credit
->>>,>>>,>>>,>>9.99
4
 
RRCalcContLineRecDeltaDebitCC
SC Delta Recognized Debit
SC Delta Recognized Debit
->>>,>>>,>>>,>>9.99
4
 
RRCalcContLineRecDeltaDebitLC
BC Delta Recognized Debit
BC Delta Recognized Debit
->>>,>>>,>>>,>>9.99
4
 
RRCalcContLineRecDeltaDebitTC
TC Delta Recognized Debit
TC Delta Recognized Debit
->>>,>>>,>>>,>>9.99
4
 
RRContractLine_ID
Record ID
 
-99999999999
 
 
RRRule_ID
Record ID
 
-99999999999
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 ∗
Prim
yes
RRCalcContLine_ID
yes
no
 
RRCalc
no
RRCalc_ID
yes
no
 
RRCalcCont
no
RRCalcCont_ID
yes
no
 
RRContractLine
no
RRContractLine_ID
yes
no
 
RRRule
no
RRRule_ID
yes
no
RRCalcContLink
Revenue recognition calculation link
 
 
Field Name
Label
Col-Label
Format
Dec
 
CustomCombo0
 
 
x(20)
 
 
CustomCombo1
 
 
x(20)
 
 
CustomCombo2
 
 
x(20)
 
 
CustomCombo3
 
 
x(20)
 
 
CustomCombo4
 
 
x(20)
 
 
CustomCombo5
 
 
x(20)
 
 
CustomCombo6
 
 
x(20)
 
 
CustomCombo7
 
 
x(20)
 
 
CustomCombo8
 
 
x(20)
 
 
CustomCombo9
 
 
x(20)
 
 
CustomDate0
 
 
99/99/9999
 
 
CustomDate1
 
 
99/99/9999
 
 
CustomDate2
 
 
99/99/9999
 
 
CustomDate3
 
 
99/99/9999
 
 
CustomDate4
 
 
99/99/9999
 
 
CustomDecimal0
 
 
->,>>>,>>9.99
4
 
CustomDecimal1
 
 
->,>>>,>>9.99
4
 
CustomDecimal2
 
 
->,>>>,>>9.99
4
 
CustomDecimal3
 
 
->,>>>,>>9.99
4
 
CustomDecimal4
 
 
->,>>>,>>9.99
4
 
CustomInteger0
 
 
->,>>>,>>9
 
 
CustomInteger1
 
 
->,>>>,>>9
 
 
CustomInteger2
 
 
->,>>>,>>9
 
 
CustomInteger3
 
 
->,>>>,>>9
 
 
CustomInteger4
 
 
->,>>>,>>9
 
 
CustomLong0
 
 
x(255)
 
 
CustomLong1
 
 
x(255)
 
 
CustomNote
 
 
x(2000)
 
 
CustomShort0
 
 
x(20)
 
 
CustomShort1
 
 
x(20)
 
 
CustomShort2
 
 
x(20)
 
 
CustomShort3
 
 
x(20)
 
 
CustomShort4
 
 
x(20)
 
 
CustomShort5
 
 
x(20)
 
 
CustomShort6
 
 
x(20)
 
 
CustomShort7
 
 
x(20)
 
 
CustomShort8
 
 
x(20)
 
 
CustomShort9
 
 
x(20)
 
 
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)
 
 
QADC03
 
 
x(40)
 
 
QADC04
 
 
x(40)
 
 
QADC05
 
 
x(40)
 
 
QADC06
 
 
x(40)
 
 
QADD01
 
 
->,>>>,>>9.9999
10
 
QADD02
 
 
->,>>>,>>9.9999
10
 
QADD03
 
 
->,>>>,>>9.9999
10
 
QADD04
 
 
->,>>>,>>9.9999
10
 
QADD05
 
 
->,>>>,>>9.9999
10
 
QADD06
 
 
->,>>>,>>9.9999
10
 
QADL01
 
 
yes/no
 
 
QADL02
 
 
yes/no
 
 
QADL03
 
 
yes/no
 
 
QADL04
 
 
yes/no
 
 
QADL05
 
 
yes/no
 
 
QADL06
 
 
yes/no
 
 
QADT01
 
 
99/99/9999
 
 
QADT02
 
 
99/99/9999
 
 
QADT03
 
 
99/99/9999
 
 
QADT04
 
 
99/99/9999
 
 
QADT05
 
 
99/99/9999
 
 
QADT06
 
 
99/99/9999
 
 
RRCalc_ID
Record ID
 
-99999999999
 
 
RRCalcContLine_ID
Record ID
 
-99999999999
 
 
RRCalcContLink_ID
Record ID
 
-99999999999
 
 
RRCalcContLinkAcrCreditCC
SC Acrued Credit
SC Acrued Credit
->>>,>>>,>>>,>>9.99
4
 
RRCalcContLinkAcrCreditLC
BC Acrued Credit
BC Acrued Credit
->>>,>>>,>>>,>>9.99
4
 
RRCalcContLinkAcrCreditTC
TC Acrued Credit
TC Acrued Credit
->>>,>>>,>>>,>>9.99
4
 
RRCalcContLinkAcrDebitCC
SC Acrued Debit
SC Acrued Debit
->>>,>>>,>>>,>>9.99
4
 
RRCalcContLinkAcrDebitLC
BC Acrued Debit
BC Acrued Debit
->>>,>>>,>>>,>>9.99
4
 
RRCalcContLinkAcrDebitTC
TC Acrued Debit
TC Acrued Debit
->>>,>>>,>>>,>>9.99
4
 
RRCalcContLinkAcrDeltaCreditCC
SC Delta Accrued Credit
SC Delta Accrued Credit
->>>,>>>,>>>,>>9.99
4
 
RRCalcContLinkAcrDeltaCreditLC
BC Delta Accrued Credit
BC Delta Accrued Credit
->>>,>>>,>>>,>>9.99
4
 
RRCalcContLinkAcrDeltaCreditTC
TC Delta Accrued Credit
TC Delta Accrued Credit
->>>,>>>,>>>,>>9.99
4
 
RRCalcContLinkAcrDeltaDebitCC
SC Delta Accrued Debit
SC Delta Accrued Debit
->>>,>>>,>>>,>>9.99
4
 
RRCalcContLinkAcrDeltaDebitLC
BC Delta Accrued Debit
BC Delta Accrued Debit
->>>,>>>,>>>,>>9.99
4
 
RRCalcContLinkAcrDeltaDebitTC
TC Delta Accrued Debit
TC Delta Accrued Debit
->>>,>>>,>>>,>>9.99
4
 
RRCalcContLinkAllocTransPRICE
Allocated Transaction Price
Allocated Transaction Price
->>>,>>>,>>9.99999
10
 
RRCalcContLinkAllocTrnsPriceDt
Allocated Transaction Price Valid From Date
Allocated Transaction Price Valid From Date
99/99/9999
 
 
RRCalcContLinkDefCreditCC
SC Deferred Credit
SC Deferred Credit
->>>,>>>,>>>,>>9.99
4
 
RRCalcContLinkDefCreditLC
BC Deferred Credit
BC Deferred Credit
->>>,>>>,>>>,>>9.99
4
 
RRCalcContLinkDefCreditTC
TC Deferred Credit
TC Deferred Credit
->>>,>>>,>>>,>>9.99
4
 
RRCalcContLinkDefDebitCC
SC Deferred Debit
SC Deferred Debit
->>>,>>>,>>>,>>9.99
4
 
RRCalcContLinkDefDebitLC
BC Deferred Debit
BC Deferred Debit
->>>,>>>,>>>,>>9.99
4
 
RRCalcContLinkDefDebitTC
TC Deferred Debit
TC Deferred Debit
->>>,>>>,>>>,>>9.99
4
 
RRCalcContLinkDefDeltaCreditCC
SC Delta Deferred Credit
SC Delta Deferred Credit
->>>,>>>,>>>,>>9.99
4
 
RRCalcContLinkDefDeltaCreditLC
BC Delta Deferred Credit
BC Delta Deferred Credit
->>>,>>>,>>>,>>9.99
4
 
RRCalcContLinkDefDeltaCreditTC
TC Delta Deferred Credit
TC Delta Deferred Credit
->>>,>>>,>>>,>>9.99
4
 
RRCalcContLinkDefDeltaDebitCC
SC Delta Deferred Debit
SC Delta Deferred Debit
->>>,>>>,>>>,>>9.99
4
 
RRCalcContLinkDefDeltaDebitLC
BC Delta Deferred Debit
BC Delta Deferred Debit
->>>,>>>,>>>,>>9.99
4
 
RRCalcContLinkDefDeltaDebitTC
TC Delta Deferred Debit
TC Delta Deferred Debit
->>>,>>>,>>>,>>9.99
4
 
RRCalcContLinkDistInvCreditCC
SC Invoiced Credit Redistributed
SC Inv Credit Redistr
->>>,>>>,>>>,>>9.99
4
 
RRCalcContLinkDistInvCreditLC
BC Invoiced Credit Redistributed
BC Inv Credit Redistr
->>>,>>>,>>>,>>9.99
4
 
RRCalcContLinkDistInvCreditTC
TC Invoiced Credit Redistributed
TC Inv Credit Redistr
->>>,>>>,>>>,>>9.99
4
 
RRCalcContLinkDistInvDebitCC
SC Invoiced Debit Redistributed
SC Inv Debit Redistr
->>>,>>>,>>>,>>9.99
4
 
RRCalcContLinkDistInvDebitLC
BC Invoiced Debit Redistributed
BC Inv Debit Redistr
->>>,>>>,>>>,>>9.99
4
 
RRCalcContLinkDistInvDebitTC
TC Invoiced Debit Redistributed
TC Inv Debit Redistr
->>>,>>>,>>>,>>9.99
4
 
RRCalcContLinkDistInvDeltaCrCC
SC Inv Delta Credit Redistributed
SC Inv Delta Cr Redistr
->>>,>>>,>>>,>>9.99
4
 
RRCalcContLinkDistInvDeltaCrLC
BC Inv Delta Credit Redistributed
BC Inv Delta Cr Redistr
->>>,>>>,>>>,>>9.99
4
 
RRCalcContLinkDistInvDeltaCrTC
TC Inv Delta Credit Redistributed
TC Inv Delta Cr Redistr
->>>,>>>,>>>,>>9.99
4
 
RRCalcContLinkDistInvDeltaDbCC
SC Inv Delta Debit Redistributed
SC Inv Delta Db Redistr
->>>,>>>,>>>,>>9.99
4
 
RRCalcContLinkDistInvDeltaDbLC
BC Inv Delta Debit Redistributed
BC Inv Delta Db Redistr
->>>,>>>,>>>,>>9.99
4
 
RRCalcContLinkDistInvDeltaDbTC
TC Inv Delta Debit Redistributed
TC Inv Delta Db Redistr
->>>,>>>,>>>,>>9.99
4
 
RRCalcContLinkInvCreditCC
SC Invoiced Credit
SC Invoiced Credit
->>>,>>>,>>>,>>9.99
4
 
RRCalcContLinkInvCreditLC
BC Invoiced Credit
BC Invoiced Credit
->>>,>>>,>>>,>>9.99
4
 
RRCalcContLinkInvCreditTC
TC Invoiced Credit
TC Invoiced Credit
->>>,>>>,>>>,>>9.99
4
 
RRCalcContLinkInvDebitCC
SC Invoiced Debit
SC Invoiced Debit
->>>,>>>,>>>,>>9.99
4
 
RRCalcContLinkInvDebitLC
BC Invoiced Debit
BC Invoiced Debit
->>>,>>>,>>>,>>9.99
4
 
RRCalcContLinkInvDebitTC
TC Invoiced Debit
TC Invoiced Debit
->>>,>>>,>>>,>>9.99
4
 
RRCalcContLinkIsRuleMet
Is Revenue Rule Met
 
yes/no
 
 
RRCalcContLinkNetPRICE
Net Price
 
->>>,>>>,>>9.99999
10
 
RRCalcContLinkOrderDate
Order Date
Order Date
99/99/9999
 
 
RRCalcContLinkOrderExRate
Exchange Rate (BC)
Exch Rate (BC)
->,>>>,>>9.9999999999
10
 
RRCalcContLinkOrderExRate2
Exchange Rate 2 (BC)
Exchange Rate 2 (BC)
->,>>>,>>9.9999999999
10
 
RRCalcContLinkOrderFixRate
Fixed Exchange Rate
Fixed Exchange Rate
yes/no
 
 
RRCalcContLinkOrderQTY
Qty
 
->>>,>>>,>>9.99999
10
 
RRCalcContLinkRecCreditCC
SC Recognized Credit
SC Recognized Credit
->>>,>>>,>>>,>>9.99
4
 
RRCalcContLinkRecCreditLC
BC Recognized Credit
BC Recognized Credit
->>>,>>>,>>>,>>9.99
4
 
RRCalcContLinkRecCreditTC
TC Recognized Credit
TC Recognized Credit
->>>,>>>,>>>,>>9.99
4
 
RRCalcContLinkRecDebitCC
SC Recognized Debit
SC Recognized Debit
->>>,>>>,>>>,>>9.99
4
 
RRCalcContLinkRecDebitLC
BC Recognized Debit
BC Recognized Debit
->>>,>>>,>>>,>>9.99
4
 
RRCalcContLinkRecDebitTC
TC Recognized Debit
TC Recognized Debit
->>>,>>>,>>>,>>9.99
4
 
RRCalcContLinkRecDeltaCreditCC
SC Delta Recognized Credit
SC Delta Recognized Credit
->>>,>>>,>>>,>>9.99
4
 
RRCalcContLinkRecDeltaCreditLC
BC Delta Recognized Credit
BC Delta Recognized Credit
->>>,>>>,>>>,>>9.99
4
 
RRCalcContLinkRecDeltaCreditTC
TC Delta Recognized Credit
TC Delta Recognized Credit
->>>,>>>,>>>,>>9.99
4
 
RRCalcContLinkRecDeltaDebitCC
SC Delta Recognized Debit
SC Delta Recognized Debit
->>>,>>>,>>>,>>9.99
4
 
RRCalcContLinkRecDeltaDebitLC
BC Delta Recognized Debit
BC Delta Recognized Debit
->>>,>>>,>>>,>>9.99
4
 
RRCalcContLinkRecDeltaDebitTC
TC Delta Recognized Debit
TC Delta Recognized Debit
->>>,>>>,>>>,>>9.99
4
 
RRCalcContLinkStandSellPRICE
Standalone Selling Price
Standalone Selling Price
->>>,>>>,>>9.99999
10
 
RRCalcContLinkStdSellPriceDate
Standalone Selling Price Valid From Date
Standalone Selling Price Valid From Date
99/99/9999
 
 
RRCalcContLinkTotalATPTC
TC Total in ATP
 
->>>,>>>,>>>,>>9.99
4
 
RRCalcContLinkTotalInvoicedQTY
Total invoiced quantity
 
->>>,>>>,>>9.99999
10
 
RRCalcContLinkTotalInvoicedTC
Total Invoiced amount
 
->>>,>>>,>>>,>>9.99
4
 
RRCalcContLinkTotalSSPTC
TC Total in SSP
 
->>>,>>>,>>>,>>9.99
4
 
RRCalcContLinkValueTC
TC Value
TC Value
->>>,>>>,>>>,>>9.99
4
 
RRContractLink_ID
Record ID
 
-99999999999
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 ∗
Prim
yes
RRCalcContLink_ID
yes
no
 
RRCalc
no
RRCalc_ID
yes
no
 
RRCalcContLine
no
RRCalcContLine_ID
yes
no
 
RRContractLink
no
RRContractLink_ID
yes
no
RRCalcContTran
Revenue recognition calculation transaction
 
 
Field Name
Label
Col-Label
Format
Dec
 
AccruedPostingLine_ID
Record ID
 
-99999999999
 
 
COGSDeferPostingLine_ID
Record ID
 
-99999999999
 
 
COGSExpensePostingLine_ID
Record ID
 
-99999999999
 
 
CustomCombo0
 
 
x(20)
 
 
CustomCombo1
 
 
x(20)
 
 
CustomCombo2
 
 
x(20)
 
 
CustomCombo3
 
 
x(20)
 
 
CustomCombo4
 
 
x(20)
 
 
CustomCombo5
 
 
x(20)
 
 
CustomCombo6
 
 
x(20)
 
 
CustomCombo7
 
 
x(20)
 
 
CustomCombo8
 
 
x(20)
 
 
CustomCombo9
 
 
x(20)
 
 
CustomDate0
 
 
99/99/9999
 
 
CustomDate1
 
 
99/99/9999
 
 
CustomDate2
 
 
99/99/9999
 
 
CustomDate3
 
 
99/99/9999
 
 
CustomDate4
 
 
99/99/9999
 
 
CustomDecimal0
 
 
->,>>>,>>9.99
4
 
CustomDecimal1
 
 
->,>>>,>>9.99
4
 
CustomDecimal2
 
 
->,>>>,>>9.99
4
 
CustomDecimal3
 
 
->,>>>,>>9.99
4
 
CustomDecimal4
 
 
->,>>>,>>9.99
4
 
CustomInteger0
 
 
->,>>>,>>9
 
 
CustomInteger1
 
 
->,>>>,>>9
 
 
CustomInteger2
 
 
->,>>>,>>9
 
 
CustomInteger3
 
 
->,>>>,>>9
 
 
CustomInteger4
 
 
->,>>>,>>9
 
 
CustomLong0
 
 
x(255)
 
 
CustomLong1
 
 
x(255)
 
 
CustomNote
 
 
x(2000)
 
 
CustomShort0
 
 
x(20)
 
 
CustomShort1
 
 
x(20)
 
 
CustomShort2
 
 
x(20)
 
 
CustomShort3
 
 
x(20)
 
 
CustomShort4
 
 
x(20)
 
 
CustomShort5
 
 
x(20)
 
 
CustomShort6
 
 
x(20)
 
 
CustomShort7
 
 
x(20)
 
 
CustomShort8
 
 
x(20)
 
 
CustomShort9
 
 
x(20)
 
 
DeferredPostingLine_ID
Record ID
 
-99999999999
 
 
DInvoice_ID
Record ID
 
-99999999999
 
 
DistrPostingLine_ID
Link to posting line on Distributed sales account
 
-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)
 
 
oid_idh_hist
Idh_Hist OID
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
oid_ih_hist
Ih_Hist OID
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
QADC01
 
 
x(40)
 
 
QADC02
 
 
x(255)
 
 
QADC03
 
 
x(40)
 
 
QADC04
 
 
x(40)
 
 
QADC05
 
 
x(40)
 
 
QADC06
 
 
x(40)
 
 
QADD01
 
 
->,>>>,>>9.9999
10
 
QADD02
 
 
->,>>>,>>9.9999
10
 
QADD03
 
 
->,>>>,>>9.9999
10
 
QADD04
 
 
->,>>>,>>9.9999
10
 
QADD05
 
 
->,>>>,>>9.9999
10
 
QADD06
 
 
->,>>>,>>9.9999
10
 
QADL01
 
 
yes/no
 
 
QADL02
 
 
yes/no
 
 
QADL03
 
 
yes/no
 
 
QADL04
 
 
yes/no
 
 
QADL05
 
 
yes/no
 
 
QADL06
 
 
yes/no
 
 
QADT01
 
 
99/99/9999
 
 
QADT02
 
 
99/99/9999
 
 
QADT03
 
 
99/99/9999
 
 
QADT04
 
 
99/99/9999
 
 
QADT05
 
 
99/99/9999
 
 
QADT06
 
 
99/99/9999
 
 
RecognizedPostingLine_ID
Record ID
 
-99999999999
 
 
RevAccruedPostingLine_ID
Record ID
 
-99999999999
 
 
RevDeferredPostingLine_ID
Record ID
 
-99999999999
 
 
RevDistrPostingLine_ID
Link to reversal of posting line to Distributed sales account
 
-99999999999
 
 
RevRecognizedPostingLine_ID
Record ID
 
-99999999999
 
 
RevSalesPostingLine_ID
Link to reversal of posting line to Sales account
 
-99999999999
 
 
RevWriteOffPostingLine_ID
Record ID
 
-99999999999
 
 
RRCalc_ID
Record ID
 
-99999999999
 
 
RRCalcContLink_ID
Record ID
 
-99999999999
 
 
RRCalcContTran_ID
Record ID
 
-99999999999
 
 
RRCalcContTranAcceptedDate
Accepted Date
Accepted Date
99/99/9999
 
 
RRCalcContTranAcceptedQTY
Accepted Qty
Accepted Qty
->>>,>>>,>>9.99999
10
 
RRCalcContTranAcrCreditCC
SC Accrued Credit
SC Accrued Credit
->>>,>>>,>>>,>>9.99
4
 
RRCalcContTranAcrCreditLC
BC Accrued Credit
BC Accrued Credit
->>>,>>>,>>>,>>9.99
4
 
RRCalcContTranAcrCreditTC
TC Accrued Credit
TC Accrued Credit
->>>,>>>,>>>,>>9.99
4
 
RRCalcContTranAcrDebitCC
SC Accrued Debit
SC Accrued Debit
->>>,>>>,>>>,>>9.99
4
 
RRCalcContTranAcrDebitLC
BC Accrued Debit
BC Accrued Debit
->>>,>>>,>>>,>>9.99
4
 
RRCalcContTranAcrDebitTC
TC Accrued Debit
TC Accrued Debit
->>>,>>>,>>>,>>9.99
4
 
RRCalcContTranAcrDeltaCreditCC
SC Delta Accrued Credit
SC Delta Accrued Credit
->>>,>>>,>>>,>>9.99
4
 
RRCalcContTranAcrDeltaCreditLC
BC Delta Accrued Credit
BC Delta Accrued Credit
->>>,>>>,>>>,>>9.99
4
 
RRCalcContTranAcrDeltaCreditTC
TC Delta Accrued Credit
TC Delta Accrued Credit
->>>,>>>,>>>,>>9.99
4
 
RRCalcContTranAcrDeltaDebitCC
SC Delta Accrued Debit
SC Delta Accrued Debit
->>>,>>>,>>>,>>9.99
4
 
RRCalcContTranAcrDeltaDebitLC
BC Delta Accrued Debit
BC Delta Accrued Debit
->>>,>>>,>>>,>>9.99
4
 
RRCalcContTranAcrDeltaDebitTC
TC Delta Accrued Debit
TC Delta Accrued Debit
->>>,>>>,>>>,>>9.99
4
 
RRCalcContTranDateOfNextRev
Next revaluation date
 
99/99/9999
 
 
RRCalcContTranDefCreditCC
SC Deferred Credit
SC Deferred Credit
->>>,>>>,>>>,>>9.99
4
 
RRCalcContTranDefCreditLC
BC Deferred Credit
BC Deferred Credit
->>>,>>>,>>>,>>9.99
4
 
RRCalcContTranDefCreditTC
TC Deferred Credit
TC Deferred Credit
->>>,>>>,>>>,>>9.99
4
 
RRCalcContTranDefDebitCC
SC Deferred Debit
SC Deferred Debit
->>>,>>>,>>>,>>9.99
4
 
RRCalcContTranDefDebitLC
BC Deferred Debit
BC Deferred Debit
->>>,>>>,>>>,>>9.99
4
 
RRCalcContTranDefDebitTC
TC Deferred Debit
TC Deferred Debit
->>>,>>>,>>>,>>9.99
4
 
RRCalcContTranDefDeltaCreditCC
SC Delta Deferred Credit
SC Delta Deferred Credit
->>>,>>>,>>>,>>9.99
4
 
RRCalcContTranDefDeltaCreditLC
BC Delta Deferred Credit
BC Delta Deferred Credit
->>>,>>>,>>>,>>9.99
4
 
RRCalcContTranDefDeltaCreditTC
TC Delta Deferred Credit
TC Delta Deferred Credit
->>>,>>>,>>>,>>9.99
4
 
RRCalcContTranDefDeltaDebitCC
SC Delta Deferred Debit
SC Delta Deferred Debit
->>>,>>>,>>>,>>9.99
4
 
RRCalcContTranDefDeltaDebitLC
BC Delta Deferred Debit
BC Delta Deferred Debit
->>>,>>>,>>>,>>9.99
4
 
RRCalcContTranDefDeltaDebitTC
TC Delta Deferred Debit
TC Delta Deferred Debit
->>>,>>>,>>>,>>9.99
4
 
RRCalcContTranDInvCloseDate
Invoice Closing Date
 
99/99/9999
 
 
RRCalcContTranDistInvCCRate
Redistributed Exchange Rate (SC)
Redist Exch Rate (CC)
->,>>>,>>9.9999999999
10
 
RRCalcContTranDistInvCCScale
Redistributed Exchange Rate Scale (SC)
Redist Exch Rate Scale (CC)
->,>>>,>>9.9999999999
10
 
RRCalcContTranDistInvCreditCC
SC Invoiced Credit Redistributed
SC Inv Credit Redistr
->>>,>>>,>>>,>>9.99
4
 
RRCalcContTranDistInvCreditLC
BC Invoiced Credit Redistributed
BC Inv Credit Redistr
->>>,>>>,>>>,>>9.99
4
 
RRCalcContTranDistInvCreditTC
TC Invoiced Credit Redistributed
TC Inv Credit Redistr
->>>,>>>,>>>,>>9.99
4
 
RRCalcContTranDistInvDebitCC
SC Invoiced Debit Redistributed
SC Inv Debit Redistr
->>>,>>>,>>>,>>9.99
4
 
RRCalcContTranDistInvDebitLC
BC Invoiced Debit Redistributed
BC Inv Debit Redistr
->>>,>>>,>>>,>>9.99
4
 
RRCalcContTranDistInvDebitTC
TC Invoiced Debit Redistributed
TC Inv Debit Redistr
->>>,>>>,>>>,>>9.99
4
 
RRCalcContTranDistInvDeltaCrCC
SC Delta Inv Cr Redistributed
SC Delta Inv Cr Redist
->>>,>>>,>>>,>>9.99
4
 
RRCalcContTranDistInvDeltaCrLC
BC Delta Inv Cr Redistributed
BC Delta Inv Cr Redist
->>>,>>>,>>>,>>9.99
4
 
RRCalcContTranDistInvDeltaCrTC
TC Delta Inv Cr Redistributed
TC Delta Inv Cr Redist
->>>,>>>,>>>,>>9.99
4
 
RRCalcContTranDistInvDeltaDbCC
SC Delta Inv Db Redistributed
SC Delta Inv Db Redist
->>>,>>>,>>>,>>9.99
4
 
RRCalcContTranDistInvDeltaDbLC
BC Delta Inv Db Redistributed
BC Delta Inv Db Redist
->>>,>>>,>>>,>>9.99
4
 
RRCalcContTranDistInvDeltaDbTC
TC Delta Inv Db Redistributed
TC Delta Inv Db Redist
->>>,>>>,>>>,>>9.99
4
 
RRCalcContTranDistInvLCRate
Redistributed Exchange Rate (BC)
Redist Exch Rate (BC)
->,>>>,>>9.9999999999
10
 
RRCalcContTranDistInvLCScale
Redistributed Exchange Rate Scale (BC)
Redist Exch Rate Scale (BC)
->,>>>,>>9.9999999999
10
 
RRCalcContTranEntity
Entity
 
x(20)
 
 
RRCalcContTranEventCode
Event
 
x(8)
 
 
RRCalcContTranEventComm
Event Comment
 
x(255)
 
 
RRCalcContTranEventInfo
Event Info
 
x(255)
 
 
RRCalcContTranEventType
Event Type
 
x(8)
 
 
RRCalcContTranInvCCRate
Exchange Rate (SC)
Exch Rate (CC)
->,>>>,>>9.9999999999
10
 
RRCalcContTranInvCCScale
Exchange Rate Scale (SC)
Exch Rate Scale (CC)
->,>>>,>>9.9999999999
10
 
RRCalcContTranInvCreditCC
SC Invoiced
SC Invoiced
->>>,>>>,>>>,>>9.99
4
 
RRCalcContTranInvCreditLC
BC Invoiced
BC Invoiced
->>>,>>>,>>>,>>9.99
4
 
RRCalcContTranInvCreditTC
TC Invoiced
TC Invoiced
->>>,>>>,>>>,>>9.99
4
 
RRCalcContTranInvDebitCC
SC Invoiced
SC Invoiced
->>>,>>>,>>>,>>9.99
4
 
RRCalcContTranInvDebitLC
BC Invoiced
BC Invoiced
->>>,>>>,>>>,>>9.99
4
 
RRCalcContTranInvDebitTC
TC Invoiced
TC Invoiced
->>>,>>>,>>>,>>9.99
4
 
RRCalcContTranInvLCRate
Exchange Rate (BC)
Exch Rate (BC)
->,>>>,>>9.9999999999
10
 
RRCalcContTranInvLCScale
Exchange Rate Scale (BC)
Exch Rate Scale (BC)
->,>>>,>>9.9999999999
10
 
RRCalcContTranInvoiceDate
Invoice Date
 
99/99/9999
 
 
RRCalcContTranInvoicedQTY
Invoiced Qty
Invoiced Qty
->>>,>>>,>>9.99999
10
 
RRCalcContTranIsAccepted
Accepted
Accepted
yes/no
 
 
RRCalcContTranIsCorrectionRev
Is Corrective revaluation
 
yes/no
 
 
RRCalcContTranIsDInvClosed
Is Invoice Closed
 
yes/no
 
 
RRCalcContTranIsRuleMet
Is Revenue Rule Met
 
yes/no
 
 
RRCalcContTranPODReference
POD Reference
POD Reference
x(40)
 
 
RRCalcContTranRecCreditCC
SC Recognized Credit
SC Recognized Credit
->>>,>>>,>>>,>>9.99
4
 
RRCalcContTranRecCreditLC
BC Recognized Credit
BC Recognized Credit
->>>,>>>,>>>,>>9.99
4
 
RRCalcContTranRecCreditTC
TC Recognized Credit
TC Recognized Credit
->>>,>>>,>>>,>>9.99
4
 
RRCalcContTranRecDebitCC
SC Recognized Debit
SC Recognized Debit
->>>,>>>,>>>,>>9.99
4
 
RRCalcContTranRecDebitLC
BC Recognized Debit
BC Recognized Debit
->>>,>>>,>>>,>>9.99
4
 
RRCalcContTranRecDebitTC
TC Recognized Debit
TC Recognized Debit
->>>,>>>,>>>,>>9.99
4
 
RRCalcContTranRecDeltaCreditCC
SC Delta Recognized Credit
SC Delta Recognized Credit
->>>,>>>,>>>,>>9.99
4
 
RRCalcContTranRecDeltaCreditLC
BC Delta Recognized Credit
BC Delta Recognized Credit
->>>,>>>,>>>,>>9.99
4
 
RRCalcContTranRecDeltaCreditTC
TC Delta Recognized Credit
TC Delta Recognized Credit
->>>,>>>,>>>,>>9.99
4
 
RRCalcContTranRecDeltaDebitCC
SC Delta Recognized Debit
SC Delta Recognized Debit
->>>,>>>,>>>,>>9.99
4
 
RRCalcContTranRecDeltaDebitLC
BC Delta Recognized Debit
BC Delta Recognized Debit
->>>,>>>,>>>,>>9.99
4
 
RRCalcContTranRecDeltaDebitTC
TC Delta Recognized Debit
TC Delta Recognized Debit
->>>,>>>,>>>,>>9.99
4
 
RRCalcContTranShipDate
Shipment Date
 
99/99/9999
 
 
RRCalcContTranSite
Site
 
x(20)
 
 
RRCalcContTranWriteOffCreditCC
SC Write-Off Credit
SC Write-Off Credit
->>>,>>>,>>>,>>9.99
4
 
RRCalcContTranWriteOffCreditLC
BC Write-Off Credit
BC Write-Off Credit
->>>,>>>,>>>,>>9.99
4
 
RRCalcContTranWriteOffCreditTC
TC Write-Off Credit
TC Write-Off Credit
->>>,>>>,>>>,>>9.99
4
 
RRCalcContTranWriteOffDebitCC
SC Write-Off Debit
SC Write-Off Debit
->>>,>>>,>>>,>>9.99
4
 
RRCalcContTranWriteOffDebitLC
BC Write-Off Debit
BC Write-Off Debit
->>>,>>>,>>>,>>9.99
4
 
RRCalcContTranWriteOffDebitTC
TC Write-Off Debit
TC Write-Off Debit
->>>,>>>,>>>,>>9.99
4
 
RRCalcContTranWriteOffDltCrCC
SC Write-Off Delta Credit
SC Write-Off Delta Credit
->>>,>>>,>>>,>>9.99
4
 
RRCalcContTranWriteOffDltCrLC
BC Write-Off Delta Credit
BC Write-Off Delta Credit
->>>,>>>,>>>,>>9.99
4
 
RRCalcContTranWriteOffDltCrTC
TC Write-Off Delta Credit
TC Write-Off Delta Credit
->>>,>>>,>>>,>>9.99
4
 
RRCalcContTranWriteOffDltDbCC
SC Write-Off Delta Debit
SC Write-Off Delta Debit
->>>,>>>,>>>,>>9.99
4
 
RRCalcContTranWriteOffDltDbLC
BC Write-Off Delta Debit
BC Write-Off Delta Debit
->>>,>>>,>>>,>>9.99
4
 
RRCalcContTranWriteOffDltDbTC
TC Write-Off Delta Debit
TC Write-Off Delta Debit
->>>,>>>,>>>,>>9.99
4
 
SalesPostingLine_ID
Link to posting line on Sales account
 
-99999999999
 
 
WriteOffPostingLine_ID
Record ID
 
-99999999999
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
DInvoice
no
DInvoice_ID
yes
no
 
EventCodeIdx
no
RRCalcContTranEventCode
yes
no
 
EventTypeIdx
no
RRCalcContTranEventType
yes
no
 
IdhHist
no
oid_idh_hist
yes
no
 
IhHist
no
oid_ih_hist
yes
no
 ∗
Prim
yes
RRCalcContTran_ID
yes
no
 
RRCalc
no
RRCalc_ID
yes
no
 
RRCalcContLink
no
RRCalcContLink_ID
yes
no
RRCompanyJrnl
Revenue recognition company journal
 
 
Field Name
Label
Col-Label
Format
Dec
 
Company_ID
Link to Company
 
-99999999999
 
 
CustomCombo0
 
 
x(20)
 
 
CustomCombo1
 
 
x(20)
 
 
CustomCombo2
 
 
x(20)
 
 
CustomCombo3
 
 
x(20)
 
 
CustomCombo4
 
 
x(20)
 
 
CustomCombo5
 
 
x(20)
 
 
CustomCombo6
 
 
x(20)
 
 
CustomCombo7
 
 
x(20)
 
 
CustomCombo8
 
 
x(20)
 
 
CustomCombo9
 
 
x(20)
 
 
CustomDate0
 
 
99/99/9999
 
 
CustomDate1
 
 
99/99/9999
 
 
CustomDate2
 
 
99/99/9999
 
 
CustomDate3
 
 
99/99/9999
 
 
CustomDate4
 
 
99/99/9999
 
 
CustomDecimal0
 
 
->,>>>,>>9.99
4
 
CustomDecimal1
 
 
->,>>>,>>9.99
4
 
CustomDecimal2
 
 
->,>>>,>>9.99
4
 
CustomDecimal3
 
 
->,>>>,>>9.99
4
 
CustomDecimal4
 
 
->,>>>,>>9.99
4
 
CustomInteger0
 
 
->,>>>,>>9
 
 
CustomInteger1
 
 
->,>>>,>>9
 
 
CustomInteger2
 
 
->,>>>,>>9
 
 
CustomInteger3
 
 
->,>>>,>>9
 
 
CustomInteger4
 
 
->,>>>,>>9
 
 
CustomLong0
 
 
x(255)
 
 
CustomLong1
 
 
x(255)
 
 
CustomNote
 
 
x(2000)
 
 
CustomShort0
 
 
x(20)
 
 
CustomShort1
 
 
x(20)
 
 
CustomShort2
 
 
x(20)
 
 
CustomShort3
 
 
x(20)
 
 
CustomShort4
 
 
x(20)
 
 
CustomShort5
 
 
x(20)
 
 
CustomShort6
 
 
x(20)
 
 
CustomShort7
 
 
x(20)
 
 
CustomShort8
 
 
x(20)
 
 
CustomShort9
 
 
x(20)
 
 
ForecastJournal_ID
Link to Journal
 
-99999999999
 
 
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)
 
 
QADC03
 
 
x(40)
 
 
QADC04
 
 
x(40)
 
 
QADC05
 
 
x(40)
 
 
QADC06
 
 
x(40)
 
 
QADD01
 
 
->,>>>,>>9.9999
10
 
QADD02
 
 
->,>>>,>>9.9999
10
 
QADD03
 
 
->,>>>,>>9.9999
10
 
QADD04
 
 
->,>>>,>>9.9999
10
 
QADD05
 
 
->,>>>,>>9.9999
10
 
QADD06
 
 
->,>>>,>>9.9999
10
 
QADL01
 
 
yes/no
 
 
QADL02
 
 
yes/no
 
 
QADL03
 
 
yes/no
 
 
QADL04
 
 
yes/no
 
 
QADL05
 
 
yes/no
 
 
QADL06
 
 
yes/no
 
 
QADT01
 
 
99/99/9999
 
 
QADT02
 
 
99/99/9999
 
 
QADT03
 
 
99/99/9999
 
 
QADT04
 
 
99/99/9999
 
 
QADT05
 
 
99/99/9999
 
 
QADT06
 
 
99/99/9999
 
 
RRCompanyJrnl_ID
Record ID
 
-99999999999
 
 
RRCompanyJrnlValidFrom
Valid From
 
99/99/9999
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 ∗
Prim
yes
RRCompanyJrnl_ID
yes
no
 
UniqueIdx
yes
Company_ID
yes
no
 
 
 
RRCompanyJrnlValidFrom
yes
no
RRContract
Revenue recognition contract
 
 
Field Name
Label
Col-Label
Format
Dec
 
CorporateGroup_ID
Link to Corporate Group
 
-99999999999
 
 
Currency_ID
Currency
 
-99999999999
 
 
CustomCombo0
 
 
x(20)
 
 
CustomCombo1
 
 
x(20)
 
 
CustomCombo2
 
 
x(20)
 
 
CustomCombo3
 
 
x(20)
 
 
CustomCombo4
 
 
x(20)
 
 
CustomCombo5
 
 
x(20)
 
 
CustomCombo6
 
 
x(20)
 
 
CustomCombo7
 
 
x(20)
 
 
CustomCombo8
 
 
x(20)
 
 
CustomCombo9
 
 
x(20)
 
 
CustomDate0
 
 
99/99/9999
 
 
CustomDate1
 
 
99/99/9999
 
 
CustomDate2
 
 
99/99/9999
 
 
CustomDate3
 
 
99/99/9999
 
 
CustomDate4
 
 
99/99/9999
 
 
CustomDecimal0
 
 
->,>>>,>>9.99
4
 
CustomDecimal1
 
 
->,>>>,>>9.99
4
 
CustomDecimal2
 
 
->,>>>,>>9.99
4
 
CustomDecimal3
 
 
->,>>>,>>9.99
4
 
CustomDecimal4
 
 
->,>>>,>>9.99
4
 
CustomInteger0
 
 
->,>>>,>>9
 
 
CustomInteger1
 
 
->,>>>,>>9
 
 
CustomInteger2
 
 
->,>>>,>>9
 
 
CustomInteger3
 
 
->,>>>,>>9
 
 
CustomInteger4
 
 
->,>>>,>>9
 
 
CustomLong0
 
 
x(255)
 
 
CustomLong1
 
 
x(255)
 
 
CustomNote
 
 
x(2000)
 
 
CustomShort0
 
 
x(20)
 
 
CustomShort1
 
 
x(20)
 
 
CustomShort2
 
 
x(20)
 
 
CustomShort3
 
 
x(20)
 
 
CustomShort4
 
 
x(20)
 
 
CustomShort5
 
 
x(20)
 
 
CustomShort6
 
 
x(20)
 
 
CustomShort7
 
 
x(20)
 
 
CustomShort8
 
 
x(20)
 
 
CustomShort9
 
 
x(20)
 
 
Debtor_ID
Link to customer
 
-99999999999
 
 
Domain_ID
Link to Domains
 
-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)
 
 
QADC03
 
 
x(40)
 
 
QADC04
 
 
x(40)
 
 
QADC05
 
 
x(40)
 
 
QADC06
 
 
x(40)
 
 
QADD01
 
 
->,>>>,>>9.9999
10
 
QADD02
 
 
->,>>>,>>9.9999
10
 
QADD03
 
 
->,>>>,>>9.9999
10
 
QADD04
 
 
->,>>>,>>9.9999
10
 
QADD05
 
 
->,>>>,>>9.9999
10
 
QADD06
 
 
->,>>>,>>9.9999
10
 
QADL01
 
 
yes/no
 
 
QADL02
 
 
yes/no
 
 
QADL03
 
 
yes/no
 
 
QADL04
 
 
yes/no
 
 
QADL05
 
 
yes/no
 
 
QADL06
 
 
yes/no
 
 
QADT01
 
 
99/99/9999
 
 
QADT02
 
 
99/99/9999
 
 
QADT03
 
 
99/99/9999
 
 
QADT04
 
 
99/99/9999
 
 
QADT05
 
 
99/99/9999
 
 
QADT06
 
 
99/99/9999
 
 
Role_ID
Contract Administrator Role
 
-99999999999
 
 
RRContract_ID
Record ID
 
-99999999999
 
 
RRContractAgreementDate
Agreement Date
 
99/99/9999
 
 
RRContractDescription
Description
 
x(40)
 
 
RRContractEndDate
End Date
 
99/99/9999
 
 
RRContractIsActive
 
 
yes/no
 
 
RRContractIsCompleted
Completed
 
yes/no
 
 
RRContractIsOnHold
On Hold
 
yes/no
 
 
RRContractNote
Note
 
x(2000)
 
 
RRContractNumber
Contract number
 
x(20)
 
 
RRContractOrderTotalTC
TC Order Total
TC Order Total
->>>,>>>,>>>,>>9.99
4
 
RRContractReference
Reference
 
x(40)
 
 
RRContractReviewDate
Review Date
 
99/99/9999
 
 
RRContractReviewStatus
Review Status
 
x(8)
 
 
RRContractReviewUser
Review User
 
x(20)
 
 
RRContractStartDate
Start Date
 
99/99/9999
 
 
RRContractTotalAccrCC
SC Total Accrued
SC Total Accrued
->>>,>>>,>>>,>>9.99
4
 
RRContractTotalAccrLC
BC Total Accrued
BC Total Accrued
->>>,>>>,>>>,>>9.99
4
 
RRContractTotalAccrTC
TC Total Accrued
TC Total Accrued
->>>,>>>,>>>,>>9.99
4
 
RRContractTotalAllocTC
TC Allocated Total
TC Allocated Total
->>>,>>>,>>>,>>9.99
4
 
RRContractTotalDefCC
SC Total Deferred
SC Total Deferred
->>>,>>>,>>>,>>9.99
4
 
RRContractTotalDefLC
BC Total Deferred
BC Total Deferred
->>>,>>>,>>>,>>9.99
4
 
RRContractTotalDefTC
TC Total Deferred
TC Total Deferred
->>>,>>>,>>>,>>9.99
4
 
RRContractTotalInvCC
SC Total Invoiced
SC Total Invoiced
->>>,>>>,>>>,>>9.99
4
 
RRContractTotalInvLC
BC Total Invoiced
BC Total Invoiced
->>>,>>>,>>>,>>9.99
4
 
RRContractTotalInvTC
TC Total Invoiced
TC Total Invoiced
->>>,>>>,>>>,>>9.99
4
 
RRContractTotalRecCC
SC Total Recognized
SC Total Recognized
->>>,>>>,>>>,>>9.99
4
 
RRContractTotalRecLC
BC Total Recognized
BC Total Recognized
->>>,>>>,>>>,>>9.99
4
 
RRContractTotalRecTC
TC Total Recognized
TC Total Recognized
->>>,>>>,>>>,>>9.99
4
 
RRContractTotalSSPTC
TC SSP Total
TC SSP Total
->>>,>>>,>>>,>>9.99
4
 
RRContractTotalTC
TC Total
TC Total
->>>,>>>,>>>,>>9.99
4
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
CorpIdx
no
CorporateGroup_ID
yes
no
 ∗
Prim
yes
RRContract_ID
yes
no
 
Reference
no
Domain_ID
yes
no
 
 
 
Debtor_ID
yes
no
 
 
 
RRContractReference
yes
no
 
RoleIdx
no
Role_ID
yes
no
 
UniqueIdx
yes
Domain_ID
yes
no
 
 
 
RRContractNumber
yes
no
RRContractLine
Revenue recognition contract performance obligation
 
 
Field Name
Label
Col-Label
Format
Dec
 
Currency_ID
Link to Currency
 
-99999999999
 
 
CustomCombo0
 
 
x(20)
 
 
CustomCombo1
 
 
x(20)
 
 
CustomCombo2
 
 
x(20)
 
 
CustomCombo3
 
 
x(20)
 
 
CustomCombo4
 
 
x(20)
 
 
CustomCombo5
 
 
x(20)
 
 
CustomCombo6
 
 
x(20)
 
 
CustomCombo7
 
 
x(20)
 
 
CustomCombo8
 
 
x(20)
 
 
CustomCombo9
 
 
x(20)
 
 
CustomDate0
 
 
99/99/9999
 
 
CustomDate1
 
 
99/99/9999
 
 
CustomDate2
 
 
99/99/9999
 
 
CustomDate3
 
 
99/99/9999
 
 
CustomDate4
 
 
99/99/9999
 
 
CustomDecimal0
 
 
->,>>>,>>9.99
4
 
CustomDecimal1
 
 
->,>>>,>>9.99
4
 
CustomDecimal2
 
 
->,>>>,>>9.99
4
 
CustomDecimal3
 
 
->,>>>,>>9.99
4
 
CustomDecimal4
 
 
->,>>>,>>9.99
4
 
CustomInteger0
 
 
->,>>>,>>9
 
 
CustomInteger1
 
 
->,>>>,>>9
 
 
CustomInteger2
 
 
->,>>>,>>9
 
 
CustomInteger3
 
 
->,>>>,>>9
 
 
CustomInteger4
 
 
->,>>>,>>9
 
 
CustomLong0
 
 
x(255)
 
 
CustomLong1
 
 
x(255)
 
 
CustomNote
 
 
x(2000)
 
 
CustomShort0
 
 
x(20)
 
 
CustomShort1
 
 
x(20)
 
 
CustomShort2
 
 
x(20)
 
 
CustomShort3
 
 
x(20)
 
 
CustomShort4
 
 
x(20)
 
 
CustomShort5
 
 
x(20)
 
 
CustomShort6
 
 
x(20)
 
 
CustomShort7
 
 
x(20)
 
 
CustomShort8
 
 
x(20)
 
 
CustomShort9
 
 
x(20)
 
 
LastModifiedDate
Last Modified Date
Mod Date
99/99/9999
 
 
LastModifiedTime
Last Modified Time
Mod Time
99999
 
 
LastModifiedUser
Last Modified User
Mod User
x(20)
 
 
MasterRRContractLine_ID
Link to the same performance obligation
Common ID for the performance ob
-99999999999
 
 
QADC01
 
 
x(40)
 
 
QADC02
 
 
x(255)
 
 
QADC03
 
 
x(40)
 
 
QADC04
 
 
x(40)
 
 
QADC05
 
 
x(40)
 
 
QADC06
 
 
x(40)
 
 
QADD01
 
 
->,>>>,>>9.9999
10
 
QADD02
 
 
->,>>>,>>9.9999
10
 
QADD03
 
 
->,>>>,>>9.9999
10
 
QADD04
 
 
->,>>>,>>9.9999
10
 
QADD05
 
 
->,>>>,>>9.9999
10
 
QADD06
 
 
->,>>>,>>9.9999
10
 
QADL01
 
 
yes/no
 
 
QADL02
 
 
yes/no
 
 
QADL03
 
 
yes/no
 
 
QADL04
 
 
yes/no
 
 
QADL05
 
 
yes/no
 
 
QADL06
 
 
yes/no
 
 
QADT01
 
 
99/99/9999
 
 
QADT02
 
 
99/99/9999
 
 
QADT03
 
 
99/99/9999
 
 
QADT04
 
 
99/99/9999
 
 
QADT05
 
 
99/99/9999
 
 
QADT06
 
 
99/99/9999
 
 
RRContract_ID
Link to Revenue contract
 
-99999999999
 
 
RRContractLine_ID
Record ID
 
-99999999999
 
 
RRContractLineActFinalRecDate
Actual Final Recognition Date
 
99/99/9999
 
 
RRContractLineCCRate
Redistributed Exchange Rate (SC)
Redist Exch Rate (SC)
->,>>>,>>9.9999999999
10
 
RRContractLineCCScale
Redistributed Exchange Rate Scale (SC)
Redist Exch Rate Scale (SC)
->,>>>,>>9.9999999999
10
 
RRContractLineDescription
Description
 
x(40)
 
 
RRContractLineEndDate
End Date
 
99/99/9999
 
 
RRContractLineExpFinalRecDate
Expected Final Recognition Date
 
99/99/9999
 
 
RRContractLineIsCompleted
Contract Completed
 
yes/no
 
 
RRContractLineIsOnHold
On Hold
 
yes/no
 
 
RRContractLineLCRate
Redistributed Exchange Rate (BC)
Redist Exch Rate (BC)
->,>>>,>>9.9999999999
10
 
RRContractLineLCScale
Redistributed Exchange Rate Scale (BC)
Redist Exch Rate Scale (BC)
->,>>>,>>9.9999999999
10
 
RRContractLineNote
Note
 
x(4000)
 
 
RRContractLineNumber
Line Number
Line
->,>>>,>>9
 
 
RRContractLineStartDate
Start Date
 
99/99/9999
 
 
RRContractLineTotalAccrCC
SC Total Accrued
SC Total Accrued
->>>,>>>,>>>,>>9.99
4
 
RRContractLineTotalAccrLC
BC Total Accrued
BC Total Accrued
->,>>>,>>9.99
4
 
RRContractLineTotalAccrTC
TC Total Accrued
TC Total Accrued
->,>>>,>>9.99
4
 
RRContractLineTotalAllocTC
TC Allocated Total (Obsolete)
TC Allocated Total
->>>,>>>,>>>,>>9.99
4
 
RRContractLineTotalDefCC
SC Total Deferred
SC Total Deferred
->>>,>>>,>>>,>>9.99
4
 
RRContractLineTotalDefLC
BC Total Deferred
BC Total Deferred
->,>>>,>>9.99
4
 
RRContractLineTotalDefTC
TC Total Deferred
TC Total Deferred
->,>>>,>>9.99
4
 
RRContractLineTotalInvCC
SC Total Invoiced
SC Total Invoiced
->>>,>>>,>>>,>>9.99
4
 
RRContractLineTotalInvLC
BC Total Invoiced
BC Total Invoiced
->,>>>,>>9.99
4
 
RRContractLineTotalInvTC
TC Total Invoiced
TC Total Invoiced
->,>>>,>>9.99
4
 
RRContractLineTotalRecCC
SC Total Recognized
SC Total Recognized
->>>,>>>,>>>,>>9.99
4
 
RRContractLineTotalRecLC
BC Total Recognized
BC Total Recognized
->,>>>,>>9.99
4
 
RRContractLineTotalRecTC
TC Total Recognized
TC Total Recognized
->,>>>,>>9.99
4
 
RRContractLineTotalSSPTC
TC SSP Total (Obsolete)
TC SSP Total
->,>>>,>>9.99
4
 
RRContractLineTotalTC
TC Total
TC Total
->,>>>,>>9.99
4
 
RRContrHdr_ID
Link to Contract header
 
-99999999999
 
 
RRContrVer_ID
Link to Contract version
 
-99999999999
 
 
RRRule_ID
Link to Revenue Rule
Link to Revenue Rule
-99999999999
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
CHdrIdx
no
RRContrHdr_ID
yes
no
 
CurrIdx
no
Currency_ID
yes
no
 
CVerIdx
no
RRContrVer_ID
yes
no
 
MasterLineIdx
no
RRContract_ID
yes
no
 
MastIdx
no
MasterRRContractLine_ID
yes
no
 ∗
Prim
yes
RRContractLine_ID
yes
no
 
RuleIdx
no
RRRule_ID
yes
no
RRContractLink
Revenue recognition contract link
 
 
Field Name
Label
Col-Label
Format
Dec
 
AccruedCostCentre_ID
Link to Accrued Cost centre
 
-99999999999
 
 
AccruedDivision_ID
Link to Accrued Sub-account
 
-99999999999
 
 
AccruedGL_ID
Link to Accrued GL account
 
-99999999999
 
 
AccruedProject_ID
Link to Accrued Project
 
-99999999999
 
 
COGSDeferCostCentre_ID
Link to COGS Defer Cost centre
 
-99999999999
 
 
COGSDeferDivision_ID
Link to COGS Defer Sub-account
 
-99999999999
 
 
COGSDeferGL_ID
Link to COGS Defer GL account
 
-99999999999
 
 
COGSDeferProject_ID
Link to COGS Defer Project
 
-99999999999
 
 
COGSExpenseCostCentre_ID
Link to COGS Expense Cost centre
 
-99999999999
 
 
COGSExpenseDivision_ID
Link to COGS Expense Sub-account
 
-99999999999
 
 
COGSExpenseGL_ID
Link to COGS Expense GL account
 
-99999999999
 
 
COGSExpenseProject_ID
Link to COGS Expense Project
 
-99999999999
 
 
CustomCombo0
 
 
x(20)
 
 
CustomCombo1
 
 
x(20)
 
 
CustomCombo2
 
 
x(20)
 
 
CustomCombo3
 
 
x(20)
 
 
CustomCombo4
 
 
x(20)
 
 
CustomCombo5
 
 
x(20)
 
 
CustomCombo6
 
 
x(20)
 
 
CustomCombo7
 
 
x(20)
 
 
CustomCombo8
 
 
x(20)
 
 
CustomCombo9
 
 
x(20)
 
 
CustomDate0
 
 
99/99/9999
 
 
CustomDate1
 
 
99/99/9999
 
 
CustomDate2
 
 
99/99/9999
 
 
CustomDate3
 
 
99/99/9999
 
 
CustomDate4
 
 
99/99/9999
 
 
CustomDecimal0
 
 
->,>>>,>>9.99
4
 
CustomDecimal1
 
 
->,>>>,>>9.99
4
 
CustomDecimal2
 
 
->,>>>,>>9.99
4
 
CustomDecimal3
 
 
->,>>>,>>9.99
4
 
CustomDecimal4
 
 
->,>>>,>>9.99
4
 
CustomInteger0
 
 
->,>>>,>>9
 
 
CustomInteger1
 
 
->,>>>,>>9
 
 
CustomInteger2
 
 
->,>>>,>>9
 
 
CustomInteger3
 
 
->,>>>,>>9
 
 
CustomInteger4
 
 
->,>>>,>>9
 
 
CustomLong0
 
 
x(255)
 
 
CustomLong1
 
 
x(255)
 
 
CustomNote
 
 
x(2000)
 
 
CustomShort0
 
 
x(20)
 
 
CustomShort1
 
 
x(20)
 
 
CustomShort2
 
 
x(20)
 
 
CustomShort3
 
 
x(20)
 
 
CustomShort4
 
 
x(20)
 
 
CustomShort5
 
 
x(20)
 
 
CustomShort6
 
 
x(20)
 
 
CustomShort7
 
 
x(20)
 
 
CustomShort8
 
 
x(20)
 
 
CustomShort9
 
 
x(20)
 
 
DeferredCostCentre_ID
Link to Deferred Cost centre
 
-99999999999
 
 
DeferredDivision_ID
Link to Deferred Sub-account
 
-99999999999
 
 
DeferredGL_ID
Link to Deferred GL account
 
-99999999999
 
 
DeferredProject_ID
Link to Deferred Project
 
-99999999999
 
 
DInvoice_ID
Link to Dinvoice
 
-99999999999
 
 
DInvoicePostingLine_ID
Link to Customer invoice Sales posting line
 
-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)
 
 
LinkedRRContractLink_ID
Linked Contract Link
 
-99999999999
 
 
MasterRRContractLink_ID
Link to the same performance obligation
Common ID for the performance ob
-99999999999
 
 
QADC01
 
 
x(40)
 
 
QADC02
 
 
x(255)
 
 
QADC03
 
 
x(40)
 
 
QADC04
 
 
x(40)
 
 
QADC05
 
 
x(40)
 
 
QADC06
 
 
x(40)
 
 
QADD01
 
 
->,>>>,>>9.9999
10
 
QADD02
 
 
->,>>>,>>9.9999
10
 
QADD03
 
 
->,>>>,>>9.9999
10
 
QADD04
 
 
->,>>>,>>9.9999
10
 
QADD05
 
 
->,>>>,>>9.9999
10
 
QADD06
 
 
->,>>>,>>9.9999
10
 
QADL01
 
 
yes/no
 
 
QADL02
 
 
yes/no
 
 
QADL03
 
 
yes/no
 
 
QADL04
 
 
yes/no
 
 
QADL05
 
 
yes/no
 
 
QADL06
 
 
yes/no
 
 
QADT01
 
 
99/99/9999
 
 
QADT02
 
 
99/99/9999
 
 
QADT03
 
 
99/99/9999
 
 
QADT04
 
 
99/99/9999
 
 
QADT05
 
 
99/99/9999
 
 
QADT06
 
 
99/99/9999
 
 
RRContract_ID
Link to Revenue contract
 
-99999999999
 
 
RRContractLine_ID
Link to Revenue Contract Line
 
-99999999999
 
 
RRContractLink_ID
Record ID
 
-99999999999
 
 
RRContractLinkAccruedAmountCC
SC Accrued
SC Accrued
->>>,>>>,>>>,>>9.99
4
 
RRContractLinkAccruedAmountLC
BC Accrued
BC Accrued
->>>,>>>,>>>,>>9.99
4
 
RRContractLinkAccruedAmountTC
TC Accrued
TC Accrued
->>>,>>>,>>>,>>9.99
4
 
RRContractLinkActFinalRecDate
Actual Final Recognition Date
Actual Final Recognition Date
99/99/9999
 
 
RRContractLinkAllocTransPRICE
Allocated Transaction Price
Alloc Trans Price Total
->>>,>>>,>>9.99999
10
 
RRContractLinkDeferredAmountCC
SC Deferred
SC Deferred
->>>,>>>,>>>,>>9.99
4
 
RRContractLinkDeferredAmountLC
BC Deferred
BC Deferred
->>>,>>>,>>>,>>9.99
4
 
RRContractLinkDeferredAmountTC
TC Deferred
TC Deferred
->>>,>>>,>>>,>>9.99
4
 
RRContractLinkExpFinalRecDate
Expected Final Recognition Date
Exp Final Rec Date
99/99/9999
 
 
RRContractLinkInvoicedAmountCC
SC Invoiced
SC Invoiced
->>>,>>>,>>>,>>9.99
4
 
RRContractLinkInvoicedAmountLC
BC Invoiced
BC Invoiced
->>>,>>>,>>>,>>9.99
4
 
RRContractLinkInvoicedAmountTC
TC Invoiced
TC Invoiced
->>>,>>>,>>>,>>9.99
4
 
RRContractLinkItem
Item
Item
x(18)
 
 
RRContractLinkItemDesc
Description
Description
x(40)
 
 
RRContractLinkOrderCurr
Currency
 
x(3)
 
 
RRContractLinkOrderCust
 
Customer
x(8)
 
 
RRContractLinkOrderDomain
 
Order Domain
x(8)
 
 
RRContractLinkOrderLine
Line
Line
->,>>>,>>9
 
 
RRContractLinkOrderNbr
 
Order Number
x(8)
 
 
RRContractLinkOrderTrailerCode
Trailer Code
Trailer Code
x(2)
 
 
RRContractLinkOrderTrailerNo
Trailer Number
Trailer Number
->,>>>,>>9
 
 
RRContractLinkOrderType
Link Type
Link Type
x(8)
 
 
RRContractLinkQTY
Quantity
Quantity
->>>,>>>,>>9.99999
10
 
RRContractLinkRecognAmountCC
SC Recognized
SC Recognized
->>>,>>>,>>>,>>9.99
4
 
RRContractLinkRecognAmountLC
BC Recognized
BC Recognized
->>>,>>>,>>>,>>9.99
4
 
RRContractLinkRecognAmountTC
TC Recognized
TC Recognized
->>>,>>>,>>>,>>9.99
4
 
RRContractLinkSite
Site
Site
x(8)
 
 
RRContractLinkSSPHighPRICE
SSP Upper Limit
 
->>>,>>>,>>9.99999
10
 
RRContractLinkSSPLowPRICE
SSP Lower Limit
 
->>>,>>>,>>9.99999
10
 
RRContractLinkStandSellPRICE
Standalone Selling Price
SSP Total
->>>,>>>,>>9.99999
10
 
RRContractLinkUoM
Unit of Measure
UoM
x(2)
 
 
RRContrHdr_ID
Link to Contract header
 
-99999999999
 
 
RRContrVer_ID
Link to Contract version
 
-99999999999
 
 
SalesCostCentre_ID
Link to Sales Cost centre
 
-99999999999
 
 
SalesDivision_ID
Link to Sales Sub-account
 
-99999999999
 
 
SalesGL_ID
Link to Sales GL account
 
-99999999999
 
 
SalesProject_ID
Link to Sales Project
 
-99999999999
 
 
WriteOffCostCentre_ID
Link to WriteOff Cost centre
 
-99999999999
 
 
WriteOffDivision_ID
Link to WriteOff Sub-account
 
-99999999999
 
 
WriteOffGL_ID
Link to Write-Off GL account
 
-99999999999
 
 
WriteOffProject_ID
Link to WriteOff Project
 
-99999999999
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
MasterLinkIdx
no
RRContract_ID
yes
no
 
 
 
MasterRRContractLink_ID
yes
no
 
OrderIdx
no
RRContractLinkOrderDomain
yes
no
 
 
 
RRContractLinkOrderCust
yes
no
 
 
 
RRContractLinkOrderNbr
yes
no
 
 
 
RRContractLinkOrderLine
yes
no
 ∗
Prim
yes
RRContractLink_ID
yes
no
 
RRContr
no
RRContract_ID
yes
no
RRContractTran
Revenue recognition contract transaction
 
 
Field Name
Label
Col-Label
Format
Dec
 
CustomCombo0
 
 
x(20)
 
 
CustomCombo1
 
 
x(20)
 
 
CustomCombo2
 
 
x(20)
 
 
CustomCombo3
 
 
x(20)
 
 
CustomCombo4
 
 
x(20)
 
 
CustomCombo5
 
 
x(20)
 
 
CustomCombo6
 
 
x(20)
 
 
CustomCombo7
 
 
x(20)
 
 
CustomCombo8
 
 
x(20)
 
 
CustomCombo9
 
 
x(20)
 
 
CustomDate0
 
 
99/99/9999
 
 
CustomDate1
 
 
99/99/9999
 
 
CustomDate2
 
 
99/99/9999
 
 
CustomDate3
 
 
99/99/9999
 
 
CustomDate4
 
 
99/99/9999
 
 
CustomDecimal0
 
 
->,>>>,>>9.99
4
 
CustomDecimal1
 
 
->,>>>,>>9.99
4
 
CustomDecimal2
 
 
->,>>>,>>9.99
4
 
CustomDecimal3
 
 
->,>>>,>>9.99
4
 
CustomDecimal4
 
 
->,>>>,>>9.99
4
 
CustomInteger0
 
 
->,>>>,>>9
 
 
CustomInteger1
 
 
->,>>>,>>9
 
 
CustomInteger2
 
 
->,>>>,>>9
 
 
CustomInteger3
 
 
->,>>>,>>9
 
 
CustomInteger4
 
 
->,>>>,>>9
 
 
CustomLong0
 
 
x(255)
 
 
CustomLong1
 
 
x(255)
 
 
CustomNote
 
 
x(2000)
 
 
CustomShort0
 
 
x(20)
 
 
CustomShort1
 
 
x(20)
 
 
CustomShort2
 
 
x(20)
 
 
CustomShort3
 
 
x(20)
 
 
CustomShort4
 
 
x(20)
 
 
CustomShort5
 
 
x(20)
 
 
CustomShort6
 
 
x(20)
 
 
CustomShort7
 
 
x(20)
 
 
CustomShort8
 
 
x(20)
 
 
CustomShort9
 
 
x(20)
 
 
DInvoice_ID
Record ID
 
-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)
 
 
oid_idh_hist
Idh_Hist OID
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
oid_ih_hist
Ih_Hist OID
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
QADC01
 
 
x(40)
 
 
QADC02
 
 
x(255)
 
 
QADC03
 
 
x(40)
 
 
QADC04
 
 
x(40)
 
 
QADC05
 
 
x(40)
 
 
QADC06
 
 
x(40)
 
 
QADD01
 
 
->,>>>,>>9.9999
10
 
QADD02
 
 
->,>>>,>>9.9999
10
 
QADD03
 
 
->,>>>,>>9.9999
10
 
QADD04
 
 
->,>>>,>>9.9999
10
 
QADD05
 
 
->,>>>,>>9.9999
10
 
QADD06
 
 
->,>>>,>>9.9999
10
 
QADL01
 
 
yes/no
 
 
QADL02
 
 
yes/no
 
 
QADL03
 
 
yes/no
 
 
QADL04
 
 
yes/no
 
 
QADL05
 
 
yes/no
 
 
QADL06
 
 
yes/no
 
 
QADT01
 
 
99/99/9999
 
 
QADT02
 
 
99/99/9999
 
 
QADT03
 
 
99/99/9999
 
 
QADT04
 
 
99/99/9999
 
 
QADT05
 
 
99/99/9999
 
 
QADT06
 
 
99/99/9999
 
 
RRContract_ID
Record ID
 
-99999999999
 
 
RRContractLine_ID
Record ID
 
-99999999999
 
 
RRContractLink_ID
Record ID
 
-99999999999
 
 
RRContractTran_ID
Record ID
 
-99999999999
 
 
RRContractTranAcceptedDate
Accepted Date
 
99/99/9999
 
 
RRContractTranAcceptedQTY
Accepted Qty
 
->>>,>>>,>>9.99999
10
 
RRContractTranInvoicedQTY
Invoiced Qty
 
->>>,>>>,>>9.99999
10
 
RRContractTranIsAccepted
Accepted
 
yes/no
 
 
RRContractTranPODReference
POD Reference
 
x(40)
 
 
RRContrHdr_ID
Link to Contract header
 
-99999999999
 
 
RRContrVer_ID
Link to Contract version
 
-99999999999
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
IdhHist
no
oid_idh_hist
yes
no
 ∗
Prim
yes
RRContractTran_ID
yes
no
 
RRContractLink
no
RRContractLink_ID
yes
no
RRContrEstim
Revenue Recognition Contract Estimates
 
 
Field Name
Label
Col-Label
Format
Dec
 
CustomCombo0
 
 
x(20)
 
 
CustomCombo1
 
 
x(20)
 
 
CustomCombo2
 
 
x(20)
 
 
CustomCombo3
 
 
x(20)
 
 
CustomCombo4
 
 
x(20)
 
 
CustomCombo5
 
 
x(20)
 
 
CustomCombo6
 
 
x(20)
 
 
CustomCombo7
 
 
x(20)
 
 
CustomCombo8
 
 
x(20)
 
 
CustomCombo9
 
 
x(20)
 
 
CustomDate0
 
 
99/99/9999
 
 
CustomDate1
 
 
99/99/9999
 
 
CustomDate2
 
 
99/99/9999
 
 
CustomDate3
 
 
99/99/9999
 
 
CustomDate4
 
 
99/99/9999
 
 
CustomDecimal0
 
 
->,>>>,>>9.99
4
 
CustomDecimal1
 
 
->,>>>,>>9.99
4
 
CustomDecimal2
 
 
->,>>>,>>9.99
4
 
CustomDecimal3
 
 
->,>>>,>>9.99
4
 
CustomDecimal4
 
 
->,>>>,>>9.99
4
 
CustomInteger0
 
 
->,>>>,>>9
 
 
CustomInteger1
 
 
->,>>>,>>9
 
 
CustomInteger2
 
 
->,>>>,>>9
 
 
CustomInteger3
 
 
->,>>>,>>9
 
 
CustomInteger4
 
 
->,>>>,>>9
 
 
CustomLong0
 
 
x(255)
 
 
CustomLong1
 
 
x(255)
 
 
CustomNote
 
 
x(2000)
 
 
CustomShort0
 
 
x(20)
 
 
CustomShort1
 
 
x(20)
 
 
CustomShort2
 
 
x(20)
 
 
CustomShort3
 
 
x(20)
 
 
CustomShort4
 
 
x(20)
 
 
CustomShort5
 
 
x(20)
 
 
CustomShort6
 
 
x(20)
 
 
CustomShort7
 
 
x(20)
 
 
CustomShort8
 
 
x(20)
 
 
CustomShort9
 
 
x(20)
 
 
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)
 
 
QADC03
 
 
x(40)
 
 
QADC04
 
 
x(40)
 
 
QADC05
 
 
x(40)
 
 
QADC06
 
 
x(40)
 
 
QADD01
 
 
->,>>>,>>9.9999
10
 
QADD02
 
 
->,>>>,>>9.9999
10
 
QADD03
 
 
->,>>>,>>9.9999
10
 
QADD04
 
 
->,>>>,>>9.9999
10
 
QADD05
 
 
->,>>>,>>9.9999
10
 
QADD06
 
 
->,>>>,>>9.9999
10
 
QADL01
 
 
yes/no
 
 
QADL02
 
 
yes/no
 
 
QADL03
 
 
yes/no
 
 
QADL04
 
 
yes/no
 
 
QADL05
 
 
yes/no
 
 
QADL06
 
 
yes/no
 
 
QADT01
 
 
99/99/9999
 
 
QADT02
 
 
99/99/9999
 
 
QADT03
 
 
99/99/9999
 
 
QADT04
 
 
99/99/9999
 
 
QADT05
 
 
99/99/9999
 
 
QADT06
 
 
99/99/9999
 
 
RRContract_ID
Link to Revenue contract
 
-99999999999
 
 
RRContrEstim_ID
Record ID
 
-99999999999
 
 
RRContrEstimAllocTotalTC
TC Item Total by ATP
 
->>>,>>>,>>>,>>9.99
4
 
RRContrEstimATPRICE
Allocated Transaction Price
 
->>>,>>>,>>9.99999
10
 
RRContrEstimIsExplicit
Explicit Estimate
 
yes/no
 
 
RRContrEstimPart
Item
 
x(18)
 
 
RRContrEstimPRICE
Estimated Item Price
 
->>>,>>>,>>9.99999
10
 
RRContrEstimQTY
Estimated Item Qty
 
->>>,>>>,>>9.99999
10
 
RRContrEstimSSPHighPRICE
SSP Upper Limit
SSP Upper Limit
->>>,>>>,>>9.99999
10
 
RRContrEstimSSPLowPRICE
SSP Lower Limit
SSP Lower Limit
->>>,>>>,>>9.99999
10
 
RRContrEstimSSPRICE
Stand-Alone Selling Price
 
->>>,>>>,>>9.99999
10
 
RRContrEstimSSPTotalTC
TC Item Total by SSP
 
->>>,>>>,>>>,>>9.99
4
 
RRContrEstimTotalTC
TC Estimated Item Total
 
->>>,>>>,>>>,>>9.99
4
 
RRContrEstimTrailerCode
Trailer Code
Trailer Code
x(2)
 
 
RRContrEstimUoM
Unit of Measure
UoM
x(2)
 
 
RRContrHdr_ID
Link to Contract header
 
-99999999999
 
 
RRContrVer_ID
Link to Contract version
 
-99999999999
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 ∗
Prim
yes
RRContrEstim_ID
yes
no
 
RRContr
no
RRContract_ID
yes
no
 
RRContrHdr
no
RRContrHdr_ID
yes
no
 
RRContrVer
no
RRContrVer_ID
yes
no
 
UniqueIdx
yes
RRContract_ID
yes
no
 
 
 
RRContrVer_ID
yes
no
 
 
 
RRContrEstimPart
yes
no
 
 
 
RRContrEstimTrailerCode
yes
no
 
 
 
RRContrEstimUoM
yes
no
RRContrHdr
Revenue recognition contract header
 
 
Field Name
Label
Col-Label
Format
Dec
 
CustomCombo0
 
 
x(20)
 
 
CustomCombo1
 
 
x(20)
 
 
CustomCombo2
 
 
x(20)
 
 
CustomCombo3
 
 
x(20)
 
 
CustomCombo4
 
 
x(20)
 
 
CustomCombo5
 
 
x(20)
 
 
CustomCombo6
 
 
x(20)
 
 
CustomCombo7
 
 
x(20)
 
 
CustomCombo8
 
 
x(20)
 
 
CustomCombo9
 
 
x(20)
 
 
CustomDate0
 
 
99/99/9999
 
 
CustomDate1
 
 
99/99/9999
 
 
CustomDate2
 
 
99/99/9999
 
 
CustomDate3
 
 
99/99/9999
 
 
CustomDate4
 
 
99/99/9999
 
 
CustomDecimal0
 
 
->,>>>,>>9.99
4
 
CustomDecimal1
 
 
->,>>>,>>9.99
4
 
CustomDecimal2
 
 
->,>>>,>>9.99
4
 
CustomDecimal3
 
 
->,>>>,>>9.99
4
 
CustomDecimal4
 
 
->,>>>,>>9.99
4
 
CustomInteger0
 
 
->,>>>,>>9
 
 
CustomInteger1
 
 
->,>>>,>>9
 
 
CustomInteger2
 
 
->,>>>,>>9
 
 
CustomInteger3
 
 
->,>>>,>>9
 
 
CustomInteger4
 
 
->,>>>,>>9
 
 
CustomLong0
 
 
x(255)
 
 
CustomLong1
 
 
x(255)
 
 
CustomNote
 
 
x(2000)
 
 
CustomShort0
 
 
x(20)
 
 
CustomShort1
 
 
x(20)
 
 
CustomShort2
 
 
x(20)
 
 
CustomShort3
 
 
x(20)
 
 
CustomShort4
 
 
x(20)
 
 
CustomShort5
 
 
x(20)
 
 
CustomShort6
 
 
x(20)
 
 
CustomShort7
 
 
x(20)
 
 
CustomShort8
 
 
x(20)
 
 
CustomShort9
 
 
x(20)
 
 
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)
 
 
QADC03
 
 
x(40)
 
 
QADC04
 
 
x(40)
 
 
QADC05
 
 
x(40)
 
 
QADC06
 
 
x(40)
 
 
QADD01
 
 
->,>>>,>>9.9999
10
 
QADD02
 
 
->,>>>,>>9.9999
10
 
QADD03
 
 
->,>>>,>>9.9999
10
 
QADD04
 
 
->,>>>,>>9.9999
10
 
QADD05
 
 
->,>>>,>>9.9999
10
 
QADD06
 
 
->,>>>,>>9.9999
10
 
QADL01
 
 
yes/no
 
 
QADL02
 
 
yes/no
 
 
QADL03
 
 
yes/no
 
 
QADL04
 
 
yes/no
 
 
QADL05
 
 
yes/no
 
 
QADL06
 
 
yes/no
 
 
QADT01
 
 
99/99/9999
 
 
QADT02
 
 
99/99/9999
 
 
QADT03
 
 
99/99/9999
 
 
QADT04
 
 
99/99/9999
 
 
QADT05
 
 
99/99/9999
 
 
QADT06
 
 
99/99/9999
 
 
RRContract_ID
Record ID
 
-99999999999
 
 
RRContrHdr_ID
Record ID
 
-99999999999
 
 
RRContrHdrAdjustmentType
Adjustment Type
Adjustment Type
x(20)
 
 
RRContrHdrAgreementDate
Agreement Date
 
99/99/9999
 
 
RRContrHdrEndDate
End Date
 
99/99/9999
 
 
RRContrHdrIsCompleted
Completed
 
yes/no
 
 
RRContrHdrNote
Note
 
x(2000)
 
 
RRContrHdrOrderTotalTC
TC Order Total
TC Order Total
->>>,>>>,>>>,>>9.99
4
 
RRContrHdrStartDate
Start Date
 
99/99/9999
 
 
RRContrHdrTotalAccrCC
SC Total Accrued
SC Total Accrued
->>>,>>>,>>>,>>9.99
4
 
RRContrHdrTotalAccrLC
BC Total Accrued
BC Total Accrued
->>>,>>>,>>>,>>9.99
4
 
RRContrHdrTotalAccrTC
TC Total Accrued
TC Total Accrued
->>>,>>>,>>>,>>9.99
4
 
RRContrHdrTotalAllocTC
TC Allocated Total
TC Allocated Total
->>>,>>>,>>>,>>9.99
4
 
RRContrHdrTotalDefCC
SC Total Deferred
SC Total Deferred
->>>,>>>,>>>,>>9.99
4
 
RRContrHdrTotalDefLC
BC Total Deferred
BC Total Deferred
->>>,>>>,>>>,>>9.99
4
 
RRContrHdrTotalDefTC
TC Total Deferred
TC Total Deferred
->>>,>>>,>>>,>>9.99
4
 
RRContrHdrTotalInvCC
SC Total Invoiced
SC Total Invoiced
->>>,>>>,>>>,>>9.99
4
 
RRContrHdrTotalInvLC
BC Total Invoiced
BC Total Invoiced
->>>,>>>,>>>,>>9.99
4
 
RRContrHdrTotalInvTC
TC Total Invoiced
TC Total Invoiced
->>>,>>>,>>>,>>9.99
4
 
RRContrHdrTotalItemTC
TC total contract value for items only
 
->>>,>>>,>>>,>>9.99
4
 
RRContrHdrTotalRecCC
SC Total Recognized
SC Total Recognized
->>>,>>>,>>>,>>9.99
4
 
RRContrHdrTotalRecLC
BC Total Recognized
BC Total Recognized
->>>,>>>,>>>,>>9.99
4
 
RRContrHdrTotalRecTC
TC Total Recognized
TC Total Recognized
->>>,>>>,>>>,>>9.99
4
 
RRContrHdrTotalSSPTC
TC SSP Total
TC SSP Total
->>>,>>>,>>>,>>9.99
4
 
RRContrHdrTotalTC
TC Total
TC Total
->>>,>>>,>>>,>>9.99
4
 
RRContrHdrTotalTrailerTC
TC total contract value for trailers only
 
->>>,>>>,>>>,>>9.99
4
 
RRContrVer_ID
Link to Contract version
 
-99999999999
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 ∗
Prim
yes
RRContrHdr_ID
yes
no
RRContrLnCompl
Revenue recognition contract complete history
 
 
Field Name
Label
Col-Label
Format
Dec
 
CustomCombo0
 
 
x(20)
 
 
CustomCombo1
 
 
x(20)
 
 
CustomCombo2
 
 
x(20)
 
 
CustomCombo3
 
 
x(20)
 
 
CustomCombo4
 
 
x(20)
 
 
CustomCombo5
 
 
x(20)
 
 
CustomCombo6
 
 
x(20)
 
 
CustomCombo7
 
 
x(20)
 
 
CustomCombo8
 
 
x(20)
 
 
CustomCombo9
 
 
x(20)
 
 
CustomDate0
 
 
99/99/9999
 
 
CustomDate1
 
 
99/99/9999
 
 
CustomDate2
 
 
99/99/9999
 
 
CustomDate3
 
 
99/99/9999
 
 
CustomDate4
 
 
99/99/9999
 
 
CustomDecimal0
 
 
->,>>>,>>9.99
4
 
CustomDecimal1
 
 
->,>>>,>>9.99
4
 
CustomDecimal2
 
 
->,>>>,>>9.99
4
 
CustomDecimal3
 
 
->,>>>,>>9.99
4
 
CustomDecimal4
 
 
->,>>>,>>9.99
4
 
CustomInteger0
 
 
->,>>>,>>9
 
 
CustomInteger1
 
 
->,>>>,>>9
 
 
CustomInteger2
 
 
->,>>>,>>9
 
 
CustomInteger3
 
 
->,>>>,>>9
 
 
CustomInteger4
 
 
->,>>>,>>9
 
 
CustomLong0
 
 
x(255)
 
 
CustomLong1
 
 
x(255)
 
 
CustomNote
 
 
x(2000)
 
 
CustomShort0
 
 
x(20)
 
 
CustomShort1
 
 
x(20)
 
 
CustomShort2
 
 
x(20)
 
 
CustomShort3
 
 
x(20)
 
 
CustomShort4
 
 
x(20)
 
 
CustomShort5
 
 
x(20)
 
 
CustomShort6
 
 
x(20)
 
 
CustomShort7
 
 
x(20)
 
 
CustomShort8
 
 
x(20)
 
 
CustomShort9
 
 
x(20)
 
 
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)
 
 
QADC03
 
 
x(40)
 
 
QADC04
 
 
x(40)
 
 
QADC05
 
 
x(40)
 
 
QADC06
 
 
x(40)
 
 
QADD01
 
 
->,>>>,>>9.9999
10
 
QADD02
 
 
->,>>>,>>9.9999
10
 
QADD03
 
 
->,>>>,>>9.9999
10
 
QADD04
 
 
->,>>>,>>9.9999
10
 
QADD05
 
 
->,>>>,>>9.9999
10
 
QADD06
 
 
->,>>>,>>9.9999
10
 
QADL01
 
 
yes/no
 
 
QADL02
 
 
yes/no
 
 
QADL03
 
 
yes/no
 
 
QADL04
 
 
yes/no
 
 
QADL05
 
 
yes/no
 
 
QADL06
 
 
yes/no
 
 
QADT01
 
 
99/99/9999
 
 
QADT02
 
 
99/99/9999
 
 
QADT03
 
 
99/99/9999
 
 
QADT04
 
 
99/99/9999
 
 
QADT05
 
 
99/99/9999
 
 
QADT06
 
 
99/99/9999
 
 
RRContract_ID
Link to Revenue contract
 
-99999999999
 
 
RRContractLine_ID
Link to Revenue Rule
Link to Revenue Rule
-99999999999
 
 
RRContrHdr_ID
Link to Contract header
 
-99999999999
 
 
RRContrLnCompl_ID
Record ID
 
-99999999999
 
 
RRContrLnCompleteAmountTC
TC Cumulative Value
TC Cumulative Value
->>>,>>>,>>>,>>9.99
4
 
RRContrLnCompleteDate
% Complete Change Date
 
99/99/9999
 
 
RRContrLnCompletePerc
% Complete
% Complete
->>9.99
2
 
RRContrVer_ID
Link to Contract version
 
-99999999999
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 ∗
Prim
yes
RRContrLnCompl_ID
yes
no
RRContrLnkHist
Revenue recognition contract link history
 
 
Field Name
Label
Col-Label
Format
Dec
 
CustomCombo0
 
 
x(20)
 
 
CustomCombo1
 
 
x(20)
 
 
CustomCombo2
 
 
x(20)
 
 
CustomCombo3
 
 
x(20)
 
 
CustomCombo4
 
 
x(20)
 
 
CustomCombo5
 
 
x(20)
 
 
CustomCombo6
 
 
x(20)
 
 
CustomCombo7
 
 
x(20)
 
 
CustomCombo8
 
 
x(20)
 
 
CustomCombo9
 
 
x(20)
 
 
CustomDate0
 
 
99/99/9999
 
 
CustomDate1
 
 
99/99/9999
 
 
CustomDate2
 
 
99/99/9999
 
 
CustomDate3
 
 
99/99/9999
 
 
CustomDate4
 
 
99/99/9999
 
 
CustomDecimal0
 
 
->,>>>,>>9.99
4
 
CustomDecimal1
 
 
->,>>>,>>9.99
4
 
CustomDecimal2
 
 
->,>>>,>>9.99
4
 
CustomDecimal3
 
 
->,>>>,>>9.99
4
 
CustomDecimal4
 
 
->,>>>,>>9.99
4
 
CustomInteger0
 
 
->,>>>,>>9
 
 
CustomInteger1
 
 
->,>>>,>>9
 
 
CustomInteger2
 
 
->,>>>,>>9
 
 
CustomInteger3
 
 
->,>>>,>>9
 
 
CustomInteger4
 
 
->,>>>,>>9
 
 
CustomLong0
 
 
x(255)
 
 
CustomLong1
 
 
x(255)
 
 
CustomNote
 
 
x(2000)
 
 
CustomShort0
 
 
x(20)
 
 
CustomShort1
 
 
x(20)
 
 
CustomShort2
 
 
x(20)
 
 
CustomShort3
 
 
x(20)
 
 
CustomShort4
 
 
x(20)
 
 
CustomShort5
 
 
x(20)
 
 
CustomShort6
 
 
x(20)
 
 
CustomShort7
 
 
x(20)
 
 
CustomShort8
 
 
x(20)
 
 
CustomShort9
 
 
x(20)
 
 
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)
 
 
QADC03
 
 
x(40)
 
 
QADC04
 
 
x(40)
 
 
QADC05
 
 
x(40)
 
 
QADC06
 
 
x(40)
 
 
QADD01
 
 
->,>>>,>>9.9999
10
 
QADD02
 
 
->,>>>,>>9.9999
10
 
QADD03
 
 
->,>>>,>>9.9999
10
 
QADD04
 
 
->,>>>,>>9.9999
10
 
QADD05
 
 
->,>>>,>>9.9999
10
 
QADD06
 
 
->,>>>,>>9.9999
10
 
QADL01
 
 
yes/no
 
 
QADL02
 
 
yes/no
 
 
QADL03
 
 
yes/no
 
 
QADL04
 
 
yes/no
 
 
QADL05
 
 
yes/no
 
 
QADL06
 
 
yes/no
 
 
QADT01
 
 
99/99/9999
 
 
QADT02
 
 
99/99/9999
 
 
QADT03
 
 
99/99/9999
 
 
QADT04
 
 
99/99/9999
 
 
QADT05
 
 
99/99/9999
 
 
QADT06
 
 
99/99/9999
 
 
RRContract_ID
Link to Revenue contract
 
-99999999999
 
 
RRContractLink_ID
Link to Revenue Order Link
Link to Revenue Order Link
-99999999999
 
 
RRContrLnkHist_ID
Record ID
 
-99999999999
 
 
RRContrLnkHistAllocTransPRICE
Allocated Transaction Price
 
->>>,>>>,>>9.99999
10
 
RRContrLnkHistDate
Validity date of the value
Date
99/99/9999
 
 
RRContrLnkHistStandSellPRICE
Standalone Selling Price
 
->>>,>>>,>>9.99999
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 ∗
Prim
yes
RRContrLnkHist_ID
yes
no
 
UniqueIdx
yes
RRContractLink_ID
yes
no
 
 
 
RRContrLnkHistDate
yes
no