Customer
|
Name |
Data Type |
Export |
Export (Related Object) |
Import |
|---|---|---|---|---|
|
acct_code |
NOT_SET |
|
|
|
|
active |
CHAR |
|
|
|
|
address1 |
TEXT |
|
|
|
|
address2 |
TEXT |
|
|
|
|
address3 |
TEXT |
|
|
|
|
address4 |
TEXT |
|
|
|
|
billing_address1 |
NOT_SET |
|
|
|
|
billing_address2 |
NOT_SET |
|
|
|
|
billing_address3 |
TEXT |
|
|
|
|
billing_address4 |
TEXT |
|
|
|
|
billing_city |
NOT_SET |
|
|
|
|
billing_code |
TEXT |
|
— |
|
|
billing_contact_id |
ID |
|
— |
|
|
billing_country |
NOT_SET |
|
|
|
|
billing_email |
NOT_SET |
|
|
|
|
billing_fax |
NOT_SET |
|
|
|
|
billing_firstname |
TEXT |
|
|
|
|
billing_lastname |
TEXT |
|
|
|
|
billing_middle |
TEXT |
|
|
|
|
billing_mobile |
NOT_SET |
|
|
|
|
billing_phone |
NOT_SET |
|
|
|
|
billing_state |
NOT_SET |
|
|
|
|
billing_title |
NOT_SET |
|
|
|
|
billing_zip |
NOT_SET |
|
|
|
|
bus_typeid |
ID |
|
|
|
|
city |
TEXT |
|
|
|
|
company |
TEXT |
|
|
|
|
company_sizeid |
ID |
|
|
|
|
contact_address1 |
NOT_SET |
|
|
|
|
contact_address2 |
NOT_SET |
|
|
|
|
contact_address3 |
TEXT |
|
|
|
|
contact_address4 |
TEXT |
|
|
|
|
contact_city |
NOT_SET |
|
|
|
|
contact_country |
NOT_SET |
|
|
|
|
contact_email |
NOT_SET |
|
|
|
|
contact_fax |
NOT_SET |
|
|
|
|
contact_firstname |
TEXT |
|
|
|
|
contact_lastname |
TEXT |
|
|
|
|
contact_middle |
TEXT |
|
|
|
|
contact_mobile |
NOT_SET |
|
|
|
|
contact_phone |
NOT_SET |
|
|
|
|
contact_state |
NOT_SET |
|
|
|
|
NOT_SET |
|
|
|
|
contact_zip |
NOT_SET |
|
|
|
|
cost_center_id |
ID |
|
|
|
|
cost_center_<field_name> |
See Cost Center |
|
— |
— |
|
country |
TEXT |
|
|
|
|
created |
DATE |
|
|
|
|
credit_invoice_layout_id |
NOT_SET |
|
|
|
|
currency |
NOT_SET |
|
|
|
|
customer_locationid |
NOT_SET |
|
— |
— |
|
|
TEXT |
|
|
|
|
external_id |
NOT_SET |
|
|
|
|
fax |
TEXT |
|
|
|
|
filterset_ids |
NOT_SET |
|
— |
|
|
firstname |
TEXT |
|
|
|
|
hear_aboutid |
ID |
|
|
|
|
hierarchy_node_ids |
IDS |
|
— |
|
|
id |
ID |
|
|
|
|
invoice_layoutid |
ID |
|
— |
|
|
invoice_prefix |
TEXT |
|
— |
|
|
invoice_text |
TEXT |
|
— |
|
|
lastname |
TEXT |
|
|
|
|
middle |
TEXT |
|
|
|
|
mobile |
NOT_SET |
|
|
|
|
name |
TEXT |
|
|
|
|
notes |
TEXT |
|
|
|
|
phone |
TEXT |
|
|
|
|
primary_contactid |
ID |
|
— |
|
|
rate |
DECIMAL |
|
|
|
|
shipping_contactid |
ID |
|
— |
|
|
state |
TEXT |
|
|
|
|
TEXT |
|
|
|
|
ta_include |
NOT_SET |
|
— |
— |
|
tb_approvalprocess |
ID |
|
|
|
|
tb_approver |
ID |
|
|
|
|
te_include |
NOT_SET |
|
— |
— |
|
terms |
TEXT |
|
|
|
|
territoryid |
ID |
|
|
|
|
title |
TEXT |
|
|
|
|
type |
NOT_SET |
|
|
— |
|
updated |
DATE |
|
|
|
|
userid |
ID |
|
|
|
|
user_<field_name> |
See User |
|
— |
— |
|
web |
TEXT |
|
|
|
|
zip |
TEXT |
|
|
|
