| field name | data type | mnd. | description |
|---|
| cm_addr | character(80) | yes | Customer |
| cm_ship | character(80) | no | Ship-To |
| cm_type | character(30) | no | Type |
| cm_cr_terms | character(80) | no | Terms |
| cm_xslspsn | character(80) | no | Slspsn[1] |
| cm__qadi01 | integer | no | |
| cm_pr_list | character(80) | no | Disc Tbl |
| cm_disc_pct | decimal(10) | no | Disc % |
| cm_partial | logical | no | Partial OK |
| cm_stmt | logical | no | Statement |
| cm_dun | logical | no | Dun Letter |
| cm_fin | logical | no | Finance Chg |
| cm_ar_acct | character(80) | no | AR Acct |
| cm_ar_cc | character(30) | no | AR Cost Ctr |
| cm__qadc07 | character(80) | no | |
| cm__qadc01 | character(80) | no | |
| cm_stmt_cyc | character(30) | no | Stmt Cycle |
| cm_shipvia | character(30) | no | Ship Via |
| cm_rmks | character(80) | no | Remarks |
| cm_resale | character(30) | no | Resale |
| cm_region | character(30) | no | Region |
| cm_sort | character(30) | no | Sort Name |
| cm_balance | decimal(10) | no | Balance |
| cm_taxable | logical | no | Taxable |
| cm_pay_date | date | no | Last Payment |
| cm_xslspsn2 | character(80) | no | Slspsn[2] |
| cm__qadi02 | integer | no | |
| cm_avg_pay | integer | no | Avg Days Paid Late |
| cm_user1 | character(80) | no | Ufld1 |
| cm_user2 | character(80) | no | Ufld2 |
| cm_curr | character(30) | no | Currency |
| cm_lang | character(30) | no | Language |
| cm_db | character(30) | no | DB Number |
| cm_cr_hold | logical | no | Credit Hold |
| cm_cr_rating | character(80) | no | Credit Rating |
| cm_high_cr | decimal(10) | no | High Credit |
| cm_high_date | date | no | High Date |
| cm_sale_date | date | no | Last Sale |
| cm_invoices | integer | no | Total Invoices |
| cm_fin_date | date | no | Last Finance Charge Date |
| cm__qad06 | logical | no | |
| cm_fst_id | character(30) | no | FST ID |
| cm_pst_id | character(30) | no | PST ID |
| cm_pst | logical | no | PST Taxable |
| cm_tax_in | logical | no | Tax In |
| cm_site | character(80) | no | Site |
| cm_class | character(80) | no | Class |
| cm_taxc | character(30) | no | Tax Class |
| cm_bill | character(80) | no | Bill-To |
| cm__chr01 | character(80) | no | |
| cm__chr02 | character(80) | no | |
| cm__chr03 | character(80) | no | |
| cm__chr04 | character(80) | no | |
| cm__chr05 | character(80) | no | |
| cm__chr06 | character(80) | no | |
| cm__chr07 | character(80) | no | |
| cm__chr08 | character(80) | no | |
| cm__chr09 | character(80) | no | |
| cm__chr10 | character(80) | no | |
| cm__dte01 | date | no | |
| cm__dte02 | date | no | |
| cm__dec01 | decimal(10) | no | |
| cm__dec02 | decimal(10) | no | |
| cm__log01 | logical | no | |
| cm__qadc02 | character(80) | no | |
| cm_fr_list | character(80) | no | Freight List |
| cm_fr_terms | character(80) | no | Freight Terms |
| cm_mod_date | date | no | Modified Date |
| cm_userid | character(80) | no | User ID |
| cm_conrep_logic | character(30) | no | Consume/Replace Logic |
| cm_fr_min_wt | decimal(0) | no | Min Frt Wt |
| cm_drft_bal | decimal(10) | no | Draft Balance |
| cm_lc_bal | decimal(10) | no | LC Balance |
| cm_pr_list2 | character(80) | no | Price Tbl |
| cm_fix_pr | logical | no | Fixed Price |
| cm_cr_update | date | no | Last Credit Update |
| cm_cr_review | date | no | Last Credit Review |
| cm_coll_mthd | character(30) | no | Collection Method |
| cm_drft_min | decimal(10) | no | Min Draft Amt |
| cm_drft_max | decimal(10) | no | Max Draft Amt |
| cm_drft_disc | logical | no | Discountable |
| cm_drft_apv | logical | no | Approved |
| cm_internal | logical | no | Internal |
| cm_svc_list | character(80) | no | Service Price List |
| cm_po_reqd | logical | no | PO Required |
| cm_serv_terms | character(80) | no | Service Terms |
| cm_cr_limit | decimal(0) | no | Credit Limit |
| cm_promo | character(80) | no | Promotion Group |
| cm_btb_cr | logical | no | EMT Credit Flow |
| cm_btb_type | character(30) | no | EMT Type |
| cm_ship_lt | integer | no | Customer Shipping LT |
| cm_btb_mthd | logical | no | Confirmed EMT SO |
| cm_ex_ratetype | character(80) | no | Rate Type |
| cm_disc_comb | character(30) | no | Discount Combination Type |
| cm_scurr | character(30) | no | Second Cur |
| cm__qadc03 | character(80) | no | |
| cm__qadc04 | character(80) | no | |
| cm__qadc05 | character(80) | no | |
| cm__qadc06 | character(80) | no | |
| cm__qadd01 | decimal(10) | no | |
| cm__qadd02 | decimal(10) | no | |
| cm__qadl01 | logical | no | |
| cm__qadl02 | logical | no | |
| cm__qadl03 | logical | no | |
| cm__qadl04 | logical | no | |
| cm__qadt01 | date | no | |
| cm__qadt02 | date | no | |
| cm__qadi03 | integer | no | |
| cm__qadi04 | integer | no | |
| cm_ar_sub | character(80) | no | AR Sub-Acct |
| cm_sic | character(30) | no | SIC |
| cm_pay_method | character(30) | no | Payment Method |
| cm_submit_prop | logical | no | Allow Submission Proposed Drft |
| cm_bank | character(30) | no | Bank |
| cm_domain | character(8) | yes | Domain |
| oid_cm_mstr | decimal(10) | no | |
| cm_rss_cal_option | integer | no | RSS Calendar Option |
| oid_btr_mstr | decimal(10) | no | |
| cm_active | logical | no | Active |
| cm_datacomplete | logical | no | Data Complete |
| cm_daybookset | character(8) | no | Daybook Set |
| cm_tax_zone | character(16) | no | Tax Zone |
| cm_tax_usage | character(8) | no | Tax Usage |
| cm_gst_id | character(18) | no | Tax ID - Federal |
| cm_misc1_id | character(18) | no | Tax ID - Misc 1 |
| cm_misc2_id | character(18) | no | Tax ID - Misc 2 |
| cm_misc3_id | character(18) | no | Tax ID - Misc 3 |
| cm_tax_in_city | logical | no | In City |
| cm_sb_auto_payment | logical | no | Self-Bill Automatic Payment |
| tc_Rowid | character | yes | primary index |
| tc_ParentRowid | character | no | empty string |
| tc_Status | character | no | update status |