Column |
Type |
Size |
Nulls |
Auto |
Default |
Children |
Parents |
id |
char |
36 |
|
|
|
calls.parent_id
|
Defined in XML R |
meetings.parent_id
|
Defined in XML R |
notes.parent_id
|
Defined in XML R |
|
|
name |
varchar |
50 |
√ |
|
null |
|
|
date_entered |
datetime |
19 |
√ |
|
null |
|
|
date_modified |
datetime |
19 |
√ |
|
null |
|
|
modified_user_id |
char |
36 |
√ |
|
null |
|
users.id
|
Defined in XML R |
|
created_by |
char |
36 |
√ |
|
null |
|
users.id
|
Defined in XML R |
|
description |
text |
65535 |
√ |
|
null |
|
|
deleted |
bit |
1 |
√ |
|
0 |
|
|
revenuelineitem_id |
char |
36 |
√ |
|
null |
|
|
product_template_id |
char |
36 |
√ |
|
null |
|
|
account_id |
char |
36 |
√ |
|
null |
|
|
contact_id |
char |
36 |
√ |
|
null |
|
|
subtotal |
decimal |
26,6 |
√ |
|
null |
|
|
total_amount |
decimal |
26,6 |
√ |
|
0.000000 |
|
|
type_id |
char |
36 |
√ |
|
null |
|
|
quote_id |
char |
36 |
√ |
|
null |
|
|
manufacturer_id |
char |
36 |
√ |
|
null |
|
|
category_id |
char |
36 |
√ |
|
null |
|
|
mft_part_num |
varchar |
50 |
√ |
|
null |
|
|
vendor_part_num |
varchar |
50 |
√ |
|
null |
|
|
date_purchased |
date |
10 |
√ |
|
null |
|
|
cost_price |
decimal |
26,6 |
√ |
|
null |
|
|
discount_price |
decimal |
26,6 |
√ |
|
null |
|
|
discount_amount |
decimal |
26,6 |
√ |
|
null |
|
|
discount_rate_percent |
decimal |
26,2 |
√ |
|
null |
|
|
discount_amount_usdollar |
decimal |
26,6 |
√ |
|
null |
|
|
discount_select |
bit |
1 |
√ |
|
0 |
|
|
deal_calc |
decimal |
26,6 |
√ |
|
null |
|
|
deal_calc_usdollar |
decimal |
26,6 |
√ |
|
null |
|
|
list_price |
decimal |
26,6 |
√ |
|
null |
|
|
cost_usdollar |
decimal |
26,6 |
√ |
|
null |
|
|
discount_usdollar |
decimal |
26,6 |
√ |
|
null |
|
|
list_usdollar |
decimal |
26,6 |
√ |
|
null |
|
|
status |
varchar |
100 |
√ |
|
|
|
|
tax_class |
varchar |
100 |
√ |
|
null |
|
|
website |
varchar |
255 |
√ |
|
null |
|
|
weight |
decimal |
12,2 |
√ |
|
null |
|
|
quantity |
decimal |
12,2 |
√ |
|
1.00 |
|
|
support_name |
varchar |
50 |
√ |
|
null |
|
|
support_description |
varchar |
255 |
√ |
|
null |
|
|
support_contact |
varchar |
50 |
√ |
|
null |
|
|
support_term |
varchar |
100 |
√ |
|
null |
|
|
date_support_expires |
date |
10 |
√ |
|
null |
|
|
date_support_starts |
date |
10 |
√ |
|
null |
|
|
pricing_formula |
varchar |
100 |
√ |
|
null |
|
|
pricing_factor |
int |
4 |
√ |
|
null |
|
|
serial_number |
varchar |
50 |
√ |
|
null |
|
|
asset_number |
varchar |
50 |
√ |
|
null |
|
|
book_value |
decimal |
26,6 |
√ |
|
null |
|
|
book_value_usdollar |
decimal |
26,6 |
√ |
|
null |
|
|
book_value_date |
date |
10 |
√ |
|
null |
|
|
date_closed |
date |
10 |
√ |
|
null |
|
|
date_closed_timestamp |
bigint unsigned |
20 |
√ |
|
null |
|
|
next_step |
varchar |
100 |
√ |
|
null |
|
|
campaign_id |
char |
36 |
√ |
|
null |
|
|
opportunity_id |
char |
36 |
√ |
|
null |
|
|
assigned_user_id |
char |
36 |
√ |
|
null |
|
users.id
|
Defined in XML R |
|
team_id |
char |
36 |
√ |
|
null |
|
teams.id
|
Defined in XML R |
|
team_set_id |
char |
36 |
√ |
|
null |
|
|
acl_team_set_id |
char |
36 |
√ |
|
null |
|
|
currency_id |
char |
36 |
√ |
|
-99 |
|
|
base_rate |
decimal |
26,6 |
√ |
|
null |
|
|
Analyzed at Fri Mar 24 22:27 UTC 2017
|