About This Guide > cm_mstr
  
cm_mstr
Customer Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
cm__chr01
 
 
x(8)
 
 
cm__chr02
 
 
x(8)
 
 
cm__chr03
 
 
x(8)
 
 
cm__chr04
 
 
x(8)
 
 
cm__chr05
 
 
x(8)
 
 
cm__chr06
 
 
x(8)
 
 
cm__chr07
 
 
x(8)
 
 
cm__chr08
 
 
x(8)
 
 
cm__chr09
 
 
x(8)
 
 
cm__chr10
 
 
x(8)
 
 
cm__dec01
 
 
>>>,>>>,>>9.99
10
 
cm__dec02
 
 
>>>,>>>,>>9.99
10
 
cm__dte01
 
 
99/99/99
 
 
cm__dte02
 
 
99/99/99
 
 
cm__log01
 
 
yes/no
 
 
cm__qad04[3]
 
 
->9.99<%
10
 
cm__qad06
 
 
yes/no
 
 
cm__qadc01
 
 
x(8)
 
 
cm__qadc02
 
 
x(8)
 
 
cm__qadc03
 
 
x(8)
 
 
cm__qadc04
 
 
x(8)
 
 
cm__qadc05
 
 
x(8)
 
 
cm__qadc06
 
 
x(8)
 
 
cm__qadc07
 
 
x(8)
 
 
cm__qadd01
 
 
->>>,>>>,>>9.9<<<<<<<<<
10
 
cm__qadd02
 
 
->>>,>>>,>>9.9<<<<<<<<<
10
 
cm__qadi01
 
 
->,>>>,>>9
 
 
cm__qadi02
 
 
->,>>>,>>9
 
 
cm__qadi03
 
 
>>>>>>9
 
 
cm__qadi04
 
 
>>>>>>9
 
 
cm__qadl01
 
 
yes/no
 
 
cm__qadl02
 
 
yes/no
 
 
cm__qadl03
 
 
yes/no
 
 
cm__qadl04
 
 
yes/no
 
 
cm__qadt01
 
 
99/99/99
 
 
cm__qadt02
 
 
99/99/99
 
 
cm_active
Active
 
yes/no
 
 
cm_addr
Customer
 
x(8)
 
 
cm_ar_acct
AR Acct
 
x(8)
 
 
cm_ar_cc
AR Cost Ctr
CC
x(4)
 
 
cm_ar_sub
AR Sub-Acct
Sub-Acct
x(8)
 
 
cm_avg_pay
Avg Days Paid Late
Avg!Days Late
->>,>>9
 
 
cm_balance
Balance
 
->>,>>>,>>>,>>9.99
10
 
cm_bank
Bank
Bk
x(2)
 
 
cm_bill
Bill-To
 
x(8)
 
 
cm_btb_cr
EMT Credit Flow
 
yes/no
 
 
cm_btb_mthd
Confirmed EMT SO
 
yes/no
 
 
cm_btb_type
EMT Type
 
xx
 
 
cm_class
Class
 
x(8)
 
 
cm_coll_mthd
Collection Method
M
x(1)
 
 
cm_conrep_logic
Consume/Replace Logic
 
x(1)
 
 
cm_cons_inv
Consolidate Invoices
 
yes/no
 
 
cm_cr_hold
Credit Hold
Hold
yes/no
 
 
cm_cr_limit
Credit Limit
Cr Limit
>>>,>>>,>>>,>>9
0
 
cm_cr_rating
Credit Rating
Cr Rate
x(8)
 
 
cm_cr_review
Last Credit Review
Cr Limit!Review
99/99/99
 
 
cm_cr_terms
Terms
 
x(8)
 
 
cm_cr_update
Last Credit Update
Cr Limit!Update
99/99/99
 
 
cm_curr
Currency
Cur
x(3)
 
 
cm_cust_itm_reqd
Customer Item Required
 
yes/no
 
 
cm_datacomplete
Data Complete
 
yes/no
 
 
cm_daybookset
Daybook Set
Dybk Set
x(8)
 
 
cm_db
DB Number
 
x(12)
 
 
cm_disc_comb
Discount Combination Type
 
x(24)
 
 
cm_disc_pct
Disc %
 
->>9.99%
10
 
cm_domain
Domain
 
x(8)
 
 
cm_drft_apv
Approved
Apv
yes/no
 
 
cm_drft_bal
Draft Balance
 
->>,>>>,>>>,>>9.99
10
 
cm_drft_disc
Discountable
Dsc
yes/no
 
 
cm_drft_max
Max Draft Amt
 
->>>>,>>>,>>9.99
10
 
cm_drft_min
Min Draft Amt
 
->>>>,>>>,>>9.99
10
 
cm_dun
Dun Letter
Dun
yes/no
 
 
cm_ex_ratetype
Rate Type
 
x(8)
 
 
cm_fin
Finance Chg
Fin
yes/no
 
 
cm_fin_date
Last Finance Charge Date
Last Finance!Charge Date
99/99/99
 
 
cm_fix_pr
Fixed Price
 
yes/no
 
 
cm_fr_list
Freight List
Frt List
x(8)
 
 
cm_fr_min_wt
Min Frt Wt
 
->>>,>>>,>>9
0
 
cm_fr_terms
Freight Terms
Fr Terms
x(8)
 
 
cm_fst_id
FST ID
 
x(18)
 
 
cm_gst_id
Tax ID - Federal
 
x(18)
 
 
cm_high_cr
High Credit
 
->>,>>>,>>>,>>9
10
 
cm_high_date
High Date
 
99/99/99
 
 
cm_internal
Internal
 
yes/no
 
 
cm_invoices
Total Invoices
Invoices
>,>>>,>>9
 
 
cm_lang
Language
 
x(2)
 
 
cm_lc_bal
LC Balance
 
->>,>>>,>>>,>>9.99
10
 
cm_misc1_id
Tax ID - Misc 1
 
x(18)
 
 
cm_misc2_id
Tax ID - Misc 2
 
x(18)
 
 
cm_misc3_id
Tax ID - Misc 3
 
x(18)
 
 
cm_mod_date
Modified Date
Mod Date
99/99/99
 
 
cm_partial
Partial OK
Partial
yes/no
 
 
cm_pay_date
Last Payment
Last Pay
99/99/99
 
 
cm_pay_method
Payment Method
PM
x(2)
 
 
cm_po_reqd
PO Required
PO Reqd
yes/no
 
 
cm_pr_list
Disc Tbl
 
x(8)
 
 
cm_pr_list2
Price Tbl
Pr Tbl
x(8)
 
 
cm_promo
Promotion Group
 
x(10)
 
 
cm_pst
PST Taxable
 
yes/no
 
 
cm_pst_id
PST ID
 
x(18)
 
 
cm_region
Region
 
x(4)
 
 
cm_resale
Resale
 
x(20)
 
 
cm_rmks
Remarks
 
x(40)
 
 
cm_rss_cal_option
RSS Calendar Option
 
>>9
 
 
cm_sale_date
Last Sale
 
99/99/99
 
 
cm_sb_auto_payment
Self-Bill Automatic Payment
 
yes/no
 
 
cm_scurr
Second Cur
2nd Cur
x(3)
 
 
cm_serv_terms
Service Terms
 
X(8)
 
 
cm_ship
Ship-To
 
x(8)
 
 
cm_ship_lt
Customer Shipping LT
Cust Ship LT
>>9
 
 
cm_shipvia
Ship Via
 
x(20)
 
 
cm_sic
SIC
 
x(4)
 
 
cm_site
Site
 
x(8)
 
 
cm_slspsn[4]
Salesperson
Salespsn
x(8)
 
 
cm_sort
Sort Name
 
x(28)
 
 
cm_stmt
Statement
Stmt
yes/no
 
 
cm_stmt_cyc
Stmt Cycle
Cycle
x(4)
 
 
cm_submit_prop
Allow Submission Proposed Drft
 
yes/no
 
 
cm_svc_list
Service Price List
 
x(8)
 
 
cm_tax_in
Tax In
 
yes/no
 
 
cm_tax_in_city
In City
 
yes/no
 
 
cm_tax_usage
Tax Usage
Tax Use
x(8)
 
 
cm_tax_zone
Tax Zone
 
x(16)
 
 
cm_taxable
Taxable
Tax
yes/no
 
 
cm_taxc
Tax Class
TxC
x(3)
 
 
cm_type
Type
 
x(4)
 
 
cm_user1
Ufld1
 
x(8)
 
 
cm_user2
Ufld2
 
x(8)
 
 
cm_userid
User ID
 
x(8)
 
 
cm_xslspsn
Slspsn[1]
 
x(8)
 
 
cm_xslspsn2
Slspsn[2]
 
x(8)
 
 
oid_btr_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
oid_cm_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
cm_active
no
cm_domain
yes
no
 
 
 
cm_active
yes
no
cm_addr
yes
cm_domain
yes
no
 
 
 
cm_addr
yes
no
 
cm_datacomplete
no
cm_domain
yes
no
 
 
 
cm_datacomplete
yes
no
 
cm_sort
no
cm_domain
yes
no
 
 
 
cm_sort
yes
no
 
oid_cm_mstr
yes
oid_cm_mstr
yes
no