| Name | Description | Type | Additional information |
|---|---|---|---|
| IsRetailer | string |
None. |
|
| Signature | string |
None. |
|
| bfax | string |
None. |
|
| Province | string |
None. |
|
| city | string |
None. |
|
| registerType | string |
None. |
|
| cr_aging_limit | decimal number |
None. |
|
| aging | string |
None. |
|
| ar_customer | string |
None. |
|
| atn | string |
None. |
|
| avg_pay_days | decimal number |
None. |
|
| blanket_po | string |
None. |
|
| bo_flag | boolean |
None. |
|
| busn_class | string |
None. |
|
| buyer | string |
None. |
|
| buyer_email | string |
None. |
|
| buyer_ext | string |
None. |
|
| buyer_fax | string |
None. |
|
| buyer_phone | string |
None. |
|
| buying_group | string |
None. |
|
| buying_pct | string |
None. |
|
| cc_flag | boolean |
None. |
|
| com_class | string |
None. |
|
| com_min_flag | boolean |
None. |
|
| com_pct | decimal number |
None. |
|
| com_split1 | decimal number |
None. |
|
| com_split2 | decimal number |
None. |
|
| company_cu | string |
None. |
|
| company_oe | string |
None. |
|
| country_code | string |
None. |
|
| cr_atn | string |
None. |
|
| cr_limit | decimal number |
None. |
|
| cr_mgr | string |
None. |
|
| cu_acct_class | string |
None. |
|
| cu_group | string |
None. |
|
| tax_class | string |
None. |
|
| customer1 | string |
None. |
|
| db_rateing | string |
None. |
|
| delivery_route | string |
None. |
|
| delivery_terms | string |
None. |
|
| deposit | decimal number |
None. |
|
| discount_exclude | string |
None. |
|
| discount_pct | decimal number |
None. |
|
| dunning_code | string |
None. |
|
| dunning_flag | boolean |
None. |
|
| email_address | string |
None. |
|
| finance_flag | boolean |
None. |
|
| freight_zone | string |
None. |
|
| invoice_group | string |
None. |
|
| last_pay_amount | decimal number |
None. |
|
| last_sale_date | string |
None. |
|
| last_pay_date | string |
None. |
|
| mail_flag | boolean |
None. |
|
| last_sale_amount | decimal number |
None. |
|
| name | string |
None. |
|
| old_customer | string |
None. |
|
| opn_date | string |
None. |
|
| ord_class | string |
None. |
|
| parent_customer | string |
None. |
|
| payment_trend | string |
None. |
|
| phone_ext | string |
None. |
|
| po_flag | boolean |
None. |
|
| price_code | string |
None. |
|
| profile | string |
None. |
|
| rating_code | string |
None. |
|
| sales_ytd | decimal number |
None. |
|
| salesman1 | string |
None. |
|
| salesman2 | string |
None. |
|
| salesman3 | string |
None. |
|
| ship_complete | boolean |
None. |
|
| ship_via_code | string |
None. |
|
| sic_code | string |
None. |
|
| state | string |
None. |
|
| statement_type | boolean |
None. |
|
| stat | boolean |
None. |
|
| stop | decimal number |
None. |
|
| tax_code | string |
None. |
|
| tax_exempt | string |
None. |
|
| terms_code | string |
None. |
|
| tot_orders | decimal number |
None. |
|
| web_page | string |
None. |
|
| warehouse | string |
None. |
|
| sy_lookup | string |
None. |
|
| territory | string |
None. |
|
| taxable_flag | string |
None. |
|
| image | string |
None. |
|
| user_code | string |
None. |
|
| cr_pass_fail | string |
None. |
|
| cr_pct_past_due | decimal number |
None. |
|
| postal_code | string |
None. |
|
| phone | string |
None. |
|
| fax | string |
None. |
|
| adr | string |
None. |
|
| high_ar_ytd | decimal number |
None. |
|
| high_ar_lyr | decimal number |
None. |
|
| high_ar | decimal number |
None. |
|
| high_ar_ytd_dt | string |
None. |
|
| high_ar_lyr_dt | string |
None. |
|
| high_ar_dt | string |
None. |
|
| rating_cd | string |
None. |
|
| is_deleted | boolean |
None. |
|
| statement_print | boolean |
None. |
|
| pick_method | string |
None. |
|
| ship_via_acct | string |
None. |
|
| manifest_adr1 | string |
None. |
|
| manifest_adr2 | string |
None. |
|
| manifest_adr3 | string |
None. |
|
| manifest_adr4 | string |
None. |
|
| manifest_adr5 | string |
None. |
|
| manifest_adr6 | string |
None. |
|
| web_passwd | string |
None. |
|
| pick_sort | string |
None. |
|
| invc_sort | string |
None. |
|
| residential | boolean |
None. |
|
| Active | boolean |
None. |
|
| in_use | boolean |
None. |
|
| in_use_by | string |
None. |
|
| in_use_date | string |
None. |
|
| in_use_time | decimal number |
None. |
|
| tax_exp_date | string |
None. |
|
| dunning_letter_file | string |
None. |
|
| print_ackn_flag | boolean |
None. |
|
| form_quote_dest | string |
None. |
|
| form_ackn_dest | string |
None. |
|
| form_inv_dest | string |
None. |
|
| form_stmt_dest | string |
None. |
|
| cancel_days | decimal number |
None. |
|
| form_file_pick | string |
None. |
|
| form_file_pack | string |
None. |
|
| region | string |
None. |
|
| oe_label | string |
None. |
|
| cu_label | string |
None. |
|
| it_label | string |
None. |
|
| dup_po_allowed | boolean |
None. |
|
| currency_code | string |
None. |
|
| form_file_inv | string |
None. |
|
| finance_charge | decimal number |
None. |
|
| price_by | string |
None. |
|
| form_inv_copies | decimal number |
None. |
|
| cu_rebate_class | string |
None. |
|
| cr_atn_email | string |
None. |
|
| cr_atn_fax | string |
None. |
|
| return_days | decimal number |
None. |
|
| email_src_oa | string |
None. |
|
| email_src_pps | string |
None. |
|
| email_src_qu | string |
None. |
|
| email_src_inv | string |
None. |
|
| email_src_st | string |
None. |
|
| fax_src_oa | string |
None. |
|
| fax_src_pps | string |
None. |
|
| fax_src_qu | string |
None. |
|
| fax_src_inv | string |
None. |
|
| fax_src_st | string |
None. |
|
| email_src_oa_manual | string |
None. |
|
| email_src_pps_manual | string |
None. |
|
| email_src_qu_manual | string |
None. |
|
| email_src_inv_manual | string |
None. |
|
| email_src_st_manual | string |
None. |
|
| fax_src_st_manual | string |
None. |
|
| fax_src_inv_manual | string |
None. |
|
| fax_src_qu_manual | string |
None. |
|
| fax_src_pps_manual | string |
None. |
|
| fax_src_oa_manual | string |
None. |
|
| no_auto_bill_manifest | boolean |
None. |
|
| prospect_flag | boolean |
None. |
|
| cr_order_limit | decimal number |
None. |
|
| invc_cons_group | string |
None. |
|
| second_invoice_req | string |
None. |
|
| blanket_po_exp | string |
None. |
|
| pack_sort | string |
None. |
|
| pay_code | string |
None. |
|
| form_file_quote | string |
None. |
|
| form_file_ackn | string |
None. |
|
| c_tot_code | string |
None. |
|
| c_tot_code_amt | string |
None. |
|
| ship_confirmation | boolean |
None. |
|
| buying_group_basis | string |
None. |
|
| absorb_disc | boolean |
None. |
|
| notes_req | boolean |
None. |
|
| apply_amount | decimal number |
None. |
|
| apply_pct | decimal number |
None. |
|
| applied_amount | decimal number |
None. |
|
| department | string |
None. |
|
| form_file_stmt | string |
None. |
|
| customer_ext | string |
None. |
|
| bookto | string |
None. |
|
| oesg_autobill | boolean |
None. |
|
| pallet_gun_pick | boolean |
None. |
|
| pct_of_freight | decimal number |
None. |
|
| pct_of_freight_sr | decimal number |
None. |
|
| blind_ship | boolean |
None. |
|
| blanket_po_cr_limit | decimal number |
None. |
|
| buying_group_2 | string |
None. |
|
| buying_pct_2 | string |
None. |
|
| buying_group_basis_2 | string |
None. |
|
| location | string |
None. |
|
| num_locs | decimal number |
None. |
|
| un_sale | boolean |
None. |
|
| delivery_route_wd | string |
None. |
|
| stop_wd | string |
None. |
|
| referred_by_customer | string |
None. |
|
| date_referred | string |
None. |
|
| email_solicitation | boolean |
None. |
|
| fax_solicitation | boolean |
None. |
|
| voice_solicitation | boolean |
None. |
|
| pick_and_hold | boolean |
None. |
|
| source | string |
None. |
|
| points_per_unit | decimal number |
None. |
|
| points_flag | boolean |
None. |
|
| points_basis | string |
None. |
|
| credit_phone | string |
None. |
|
| credit_phone_ext | string |
None. |
|
| distrib | string |
None. |
|
| web_login | string |
None. |
|
| web_item_check | boolean |
None. |
|
| oa_ch_msg | boolean |
None. |
|
| profile2 | string |
None. |
|
| atn_first_name | string |
None. |
|
| atn_last_name | string |
None. |
|
| atn_suffix | string |
None. |
|
| mod_date | string |
None. |
|
| mod_time | decimal number |
None. |
|
| bill_method | string |
None. |
|
| fax_src_st_man_cc | string |
None. |
|
| fax_src_inv_man_cc | string |
None. |
|
| fax_src_qu_man_cc | string |
None. |
|
| fax_src_pps_man_cc | string |
None. |
|
| fax_src_oa_man_cc | string |
None. |
|
| fob | string |
None. |
|
| trans_bill_method | string |
None. |
|
| collections_date | string |
None. |
|
| in_collections | boolean |
None. |
|
| Collections_amt | decimal number |
None. |
|
| collections_paid | boolean |
None. |
|
| cell_phone | string |
None. |
|
| profile3 | string |
None. |
|
| bill_hold_flag | boolean |
None. |
|
| ipad_extract | boolean |
None. |
|
| last_update | string |
None. |
|
| cu_restrict_group | string |
None. |
|
| ch_grace_date | string |
None. |
|
| ch_grace_days | decimal number |
None. |
|
| req_date_ovrd_days | decimal number |
None. |
|
| DOD | string |
None. |
|
| DOR | string |
None. |
|
| tot_payments | decimal number |
None. |
|
| tot_days_to_pay | decimal number |
None. |
|
| future_ovrd | boolean |
None. |
|
| form_ackn_hard_copy | boolean |
None. |
|
| form_inv_hard_copy | boolean |
None. |
|
| form_quote_hard_copy | boolean |
None. |
|
| form_stmt_hard_copy | boolean |
None. |
|
| license | string |
None. |
|
| license_exp_date | string |
None. |
|
| license_recv_date | string |
None. |
|
| license_lookup | string |
None. |
|
| imp_oe_header | string |
None. |
|
| imp_oe_line | string |
None. |
|
| hold_bill_flag | boolean |
None. |
|
| wanted_days | decimal number |
None. |
|
| tax_id | string |
None. |
|
| ovrd_oechrg | boolean |
None. |
|
| factory_grp | string |
None. |
|
| fact_grp_dt | string |
None. |
|
| factory_grp_email | string |
None. |
|
| C__rowids | string |
None. |
|
| C__seq | integer |
None. |