|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|