About This Guide > rqm_mstr
  
rqm_mstr
Requisition Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
oid_rqm_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
rqm__chr01
 
 
x(8)
 
 
rqm__chr02
 
 
x(8)
 
 
rqm__chr03
 
 
x(8)
 
 
rqm__chr04
 
 
x(8)
 
 
rqm__dec01
 
 
->>,>>9.99
10
 
rqm__log01
 
 
yes/no
 
 
rqm__qadc01
QAD Field
 
X(8)
0
 
rqm__qadc02
QAD Field
 
X(8)
0
 
rqm__qadc03
QAD Field
 
X(8)
0
 
rqm__qadc04
QAD Field
 
X(8)
0
 
rqm_acct
Account
 
x(8)
 
 
rqm_apr_cmtindx
Approval Comments
 
>>>>>>>9
 
 
rqm_aprv_stat
Aprvl Status
 
x(16)
 
 
rqm_bill
Bill-To
 
x(8)
 
 
rqm_buyer
Buyer
 
x(8)
 
 
rqm_category
Category
 
x(8)
 
 
rqm_cc
Cost Ctr
CC
x(4)
 
 
rqm_cls_date
Close Date
Closed
99/99/99
 
 
rqm_cmtindx
Comments
 
>>>>>>>9
 
 
rqm_contact
Contact
 
x(24)
 
 
rqm_curr
Currency
 
x(3)
 
 
rqm_daybookset
Daybook Set
Dybk Set
x(8)
 
 
rqm_direct
Direct Matls
 
yes/no
 
 
rqm_disc_pct
Disc %
 
->9.99%
10
 
rqm_domain
Domain
 
x(8)
 
 
rqm_due_date
Due Date
 
99/99/99
 
 
rqm_eby_userid
Entered By
 
x(8)
 
 
rqm_email_opt
E-mail Option
 
x(1)
 
 
rqm_end_userid
End User
 
x(8)
 
 
rqm_ent_date
Ent Date
 
99/99/99
 
 
rqm_ent_ex
Exch Rate
 
>>,>>9.99999<<<<<
10
 
rqm_entity
Entity
Ent
x(20)
 
 
rqm_ex_rate
Exch Rate
 
>>>>,>>>,>>9.9<<<<<<<<<
10
 
rqm_ex_rate2
Exch Rate 2
 
>>>>,>>>,>>9.9<<<<<<<<<
10
 
rqm_ex_ratetype
Rate Type
 
x(8)
 
 
rqm_exru_seq
Sequence
 
>>>>>>>>9
 
 
rqm_fix_pr
Fixed Price
 
yes/no
 
 
rqm_fix_rate
Fixed Rate
 
yes/no
 
 
rqm_fob
FOB
 
x(20)
 
 
rqm_job
Job
 
x(8)
 
 
rqm_lang
Lang
 
x(2)
 
 
rqm_ln_fmt
Single/Multi
 
single/multi
 
 
rqm_max_total
Max Ext Cost Total
Max Ext!Cost Total
->>>>,>>>,>>9.99<<<
10
 
rqm_nbr
Req Nbr
 
x(8)
 
 
rqm_need_date
Need Date
 
99/99/99
 
 
rqm_open
Open
 
yes/no
 
 
rqm_partial
Partial OK
 
yes/no
 
 
rqm_pent_userid
Prev Route To Entered By
 
x(8)
 
 
rqm_pr_list
Disc Tbl
 
x(8)
 
 
rqm_pr_list2
Price Tbl
Pr Tbl
x(8)
 
 
rqm_prev_rtp
 
 
yes/no
 
 
rqm_prev_userid
Prev Route To
 
X(8)
 
 
rqm_print
Print Req
 
yes/no
 
 
rqm_project
Project
 
x(8)
 
 
rqm_reason
Reason
 
x(30)
 
 
rqm_req_date
Rqstn Date
 
99/99/99
 
 
rqm_rmks
Remarks
 
x(40)
 
 
rqm_rqby_userid
Requested By
Req By
x(8)
 
 
rqm_rtdto_purch
Routed To Purchasing
Routed To!Purchasing
yes/no
 
 
rqm_rtto_date
Date Routed
 
99/99/99
 
 
rqm_rtto_time
Time Routed
 
>>>>>>>9
 
 
rqm_rtto_userid
Route To
 
x(8)
 
 
rqm_ship
Ship to
 
x(8)
 
 
rqm_shipvia
Ship Via
 
x(20)
 
 
rqm_site
Site
 
x(8)
 
 
rqm_status
Status
 
x(1)
 
 
rqm_sub
Sub-Account
Sub-Acct
x(8)
 
 
rqm_total
Ext Cost Total
Ext!Cost Total
->>>>,>>>,>>9.99<<<
10
 
rqm_type
Type
 
x(1)
 
 
rqm_vend
Supplier
 
x(8)
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
oid_rqm_mstr
yes
oid_rqm_mstr
yes
no
 
rqm_buyer
no
rqm_domain
yes
no
 
 
 
rqm_buyer
yes
no
 
 
 
rqm_rtdto_purch
yes
no
 
 
 
rqm_nbr
yes
no
 
rqm_job
no
rqm_domain
yes
no
 
 
 
rqm_job
yes
no
 
 
 
rqm_rtdto_purch
yes
no
 
 
 
rqm_nbr
yes
no
rqm_nbr
yes
rqm_domain
yes
no
 
 
 
rqm_nbr
yes
no
 
rqm_open
no
rqm_domain
yes
no
 
 
 
rqm_open
yes
no
 
 
 
rqm_rtdto_purch
yes
no
 
 
 
rqm_nbr
yes
no
 
rqm_rqby_userid
no
rqm_domain
yes
no
 
 
 
rqm_rqby_userid
yes
no
 
 
 
rqm_rtdto_purch
yes
no
 
 
 
rqm_nbr
yes
no
 
rqm_rtto
no
rqm_domain
yes
no
 
 
 
rqm_rtto_userid
yes
no
 
 
 
rqm_open
yes
no
 
 
 
rqm_nbr
yes
no