About This Guide > qo_mstr
  
qo_mstr
Sales Quotation Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
oid_qo_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
qo__chr01
 
 
x(8)
 
 
qo__chr02
 
 
x(8)
 
 
qo__chr03
 
 
x(8)
 
 
qo__chr04
 
 
x(8)
 
 
qo__chr05
 
 
x(8)
 
 
qo__chr06
 
 
x(8)
 
 
qo__chr07
 
 
x(8)
 
 
qo__chr08
 
 
x(8)
 
 
qo__chr09
 
 
x(8)
 
 
qo__chr10
 
 
x(8)
 
 
qo__dec01
PST
 
>>>,>>>,>>9.99
10
 
qo__dec02
 
 
>>>,>>>,>>9.99
10
 
qo__dte01
 
 
99/99/99
 
 
qo__dte02
 
 
99/99/99
 
 
qo__log01
 
 
yes/no
 
 
qo__qad01
 
 
-z,zzz,zzz,zz9.99
10
 
qo__qad02
 
 
-z,zzz,zzz,zz9.99
10
 
qo__qad03
Fixed Price
 
-z,zzz,zzz,zz9.99
10
 
qo__qad04
 
 
>
 
 
qo__qad05[2]
 
 
>>9.9<<
10
 
qo_app_owner
Owner Application
 
x(12)
 
 
qo_ar_acct
AR Account
AR
x(8)
 
 
qo_ar_cc
Cost Ctr
CC
x(4)
 
 
qo_ar_sub
AR Sub-Acct
Sub-Acct
x(8)
 
 
qo_bank
Bank
 
x(2)
 
 
qo_bill
Bill-To
 
x(8)
 
 
qo_bol
BOL
 
x(18)
 
 
qo_cartons
Cartons
 
->,>>>,>>9
 
 
qo_channel
Channel
 
x(8)
 
 
qo_cmtindx
Comment Index
Comment
>>>>>>>9
 
 
qo_comm_pct[4]
Commission
Comm%
>>9.99%
10
 
qo_confirm
Confirm Date
Confirm
99/99/99
 
 
qo_cr_card
Credit Card
Card
x(2)
 
 
qo_cr_init
Cr Initials
Initials
x(3)
 
 
qo_cr_terms
Credit Terms
Terms
x(8)
 
 
qo_curr
Currency
Curr
x(3)
 
 
qo_cust
Sold-To
 
x(8)
 
 
qo_cycle
Cycle Code
Cy
x(2)
 
 
qo_daybookset
Daybook Set
Dybk Set
x(8)
 
 
qo_disc_pct
Disc %
 
->>9.99%
10
 
qo_div
Division
 
x(8)
 
 
qo_domain
Domain
 
x(8)
 
 
qo_due_date
Due Date
Due
99/99/99
 
 
qo_ent_ex
Exch Rate
 
>>,>>9.99999<<<<<
10
 
qo_ex_rate
Exch Rate
 
>>>>,>>>,>>9.9<<<<<<<<<
10
 
qo_ex_rate2
Exch Rate 2
 
>>>>,>>>,>>9.9<<<<<<<<<
10
 
qo_ex_ratetype
Rate Type
 
x(8)
 
 
qo_exp_date
Expires
 
99/99/99
 
 
qo_exru_seq
Sequence
 
>>>>>>>>9
 
 
qo_fix_rate
Fixed Rate
Fixed
yes/no
 
 
qo_flw_date
Follow-up
 
99/99/99
 
 
qo_fob
FOB Point
 
x(20)
 
 
qo_fr_list
Freight List
Frt List
x(8)
 
 
qo_fr_min_wt
Frt Min Wt
 
->>>,>>>,>>9
10
 
qo_fr_terms
Freight Terms
Fr Terms
x(8)
 
 
qo_fst_id
FST ID
 
x(18)
 
 
qo_inv_mthd
Invoicing Method
 
x(1)
 
 
qo_lang
Language
Lang
x(2)
 
 
qo_manual_fr_terms
Manual Fr Terms
 
yes/no
 
 
qo_nbr
Quote
 
x(8)
 
 
qo_ord_date
Quote Date
Quote
99/99/99
 
 
qo_partial
Partial OK
Partial
yes/no
 
 
qo_po
Purchase Order
 
x(20)
 
 
qo_pr_list
Manual
Disc Tbl
x(8)
 
 
qo_pr_list2
Price Tbl
Pr Tbl
x(8)
 
 
qo_prepaid
Prepaid Amount
 
-z,zzz,zzz,zz9.99
10
 
qo_priced_dt
Last Price Dt
Last Pri
99/99/99
 
 
qo_pricing_dt
Pricing Date
Price Dt
99/99/99
 
 
qo_print_bl
Print Bill of Lading
Print BOL
yes/no
 
 
qo_print_pl
Print Pack List
Print Pack
yes/no
 
 
qo_print_qo
Print Quote
Print QT
yes/no
 
 
qo_project
Project
 
x(8)
 
 
qo_pst
PST
 
yes/no
 
 
qo_pst_id
PST ID
 
x(18)
 
 
qo_pst_pct
PST Pct
 
->9.99<%
10
 
qo_recur
Recurring
Rec
yes/no
 
 
qo_rel_cnt
Release Count
Cnt
>>9
 
 
qo_rel_date
Release Date
Release
99/99/99
 
 
qo_release
Release
Rel
yes/no
 
 
qo_req_date
Required Date
Required
99/99/99
 
 
qo_rev
Revision
Rev
>>9
 
 
qo_rmks
Remarks
 
x(40)
 
 
qo_ship
Ship-To
 
x(8)
 
 
qo_ship_date
Ship Date
 
99/99/99
 
 
qo_shipvia
Ship Via
 
x(20)
 
 
qo_site
Site
 
x(8)
 
 
qo_size
Size
 
->,>>>,>>9.9<<<<<<<<
10
 
qo_size_um
Size UM
UM
x(2)
 
 
qo_slspsn[4]
Salesperson
Salespsn
x(8)
 
 
qo_so_nbr
Last Sales Order
Lst Ordr
x(8)
 
 
qo_source
Order Source
Source
x(8)
 
 
qo_stat
Action Status
St
x(2)
 
 
qo_tax_date
Tax Date
 
99/99/99
 
 
qo_tax_env
Tax Environment
Tax Env
x(16)
 
 
qo_tax_pct[3]
Tax
 
->9.99<%
10
 
qo_tax_usage
Tax Usage
TaxUsage
x(8)
 
 
qo_taxable
Taxable
Tax
yes/no
 
 
qo_taxc
Tax Class
TxC
x(3)
 
 
qo_trl1_amt
Trailer Amt 1
 
-zzzz,zzz,zz9.99
10
 
qo_trl1_cd
Trailer 1
Trl 1
x(4)
 
 
qo_trl2_amt
Trailer 2
 
-zzzz,zzz,zz9.99
10
 
qo_trl2_cd
Trailer 2
Trl 2
x(4)
 
 
qo_trl3_amt
Trailer 3
 
-zzzz,zzz,zz9.99
10
 
qo_trl3_cd
Trailer 3
Trl 3
x(4)
 
 
qo_user1
Ufld1
 
x(8)
 
 
qo_user2
Ufld2
 
x(8)
 
 
qo_userid
User ID
 
x(8)
 
 
qo_weight
Weight
 
->>>,>>>,>>9.9999
10
 
qo_weight_um
Weight UM
UM
x(2)
 
 
qo_xcomm_pct[2]
Commission
Comm%
>>9.99%
10
 
qo_xslspsn[2]
Salesperson
Salespsn
x(8)
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
oid_qo_mstr
yes
oid_qo_mstr
yes
no
 
qo_cust
no
qo_domain
yes
no
 
 
 
qo_cust
yes
no
qo_nbr
yes
qo_domain
yes
no
 
 
 
qo_nbr
yes
no
 
qo_print_qo
no
qo_domain
yes
no
 
 
 
qo_print_qo
yes
no
 
qo_release
no
qo_domain
yes
no
 
 
 
qo_release
yes
no
 
 
 
qo_nbr
yes
no
 
qo_ship
no
qo_domain
yes
no
 
 
 
qo_ship
yes
no