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