| Column |
Type |
Size |
Nulls |
Auto |
Default |
Children |
Parents |
| id |
char |
36 |
|
|
|
|
|
| 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 |
|
|
| annual_revenue |
decimal |
26,6 |
√ |
|
null |
|
|
| book_value_usdollar |
decimal |
26,6 |
√ |
|
null |
|
|
| cost_price |
decimal |
26,6 |
√ |
|
null |
|
|
| cost_usdollar |
decimal |
26,6 |
√ |
|
null |
|
|
| date_closed |
date |
10 |
√ |
|
null |
|
|
| date_closed_timestamp |
bigint unsigned |
20 |
√ |
|
null |
|
|
| deal_calc |
decimal |
26,6 |
√ |
|
null |
|
|
| deal_calc_usdollar |
decimal |
26,6 |
√ |
|
null |
|
|
| discount_amount |
decimal |
26,6 |
√ |
|
0.000000 |
|
|
| discount_amount_signed |
decimal |
26,6 |
√ |
|
0.000000 |
|
|
| discount_amount_usdollar |
decimal |
26,6 |
√ |
|
null |
|
|
| discount_price |
decimal |
26,6 |
√ |
|
null |
|
|
| discount_select |
bit |
1 |
√ |
|
0 |
|
|
| discount_usdollar |
decimal |
26,6 |
√ |
|
null |
|
|
| list_usdollar |
decimal |
26,6 |
√ |
|
null |
|
|
| mft_part_num |
varchar |
50 |
√ |
|
null |
|
|
| revenue |
decimal |
26,6 |
√ |
|
null |
|
|
| revenue_usdollar |
decimal |
26,6 |
√ |
|
null |
|
|
| total_amount |
decimal |
26,6 |
√ |
|
null |
|
|
| category_id |
char |
36 |
√ |
|
null |
|
|
| manufacturer_id |
char |
36 |
√ |
|
null |
|
|
| product_template_id |
char |
36 |
√ |
|
null |
|
|
| lock_duration |
bit |
1 |
√ |
|
0 |
|
|
| product_type_id |
char |
36 |
√ |
|
null |
|
|
| purchase_id |
char |
36 |
√ |
|
null |
|
|
| revenuelineitem_id |
char |
36 |
√ |
|
null |
|
|
| renewal_opp_id |
char |
36 |
√ |
|
null |
|
|
| account_id |
char |
36 |
√ |
|
null |
|
|
| sync_key |
varchar |
100 |
√ |
|
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 |
|
|
| asset_number |
varchar |
50 |
√ |
|
null |
|
|
| book_value |
decimal |
26,6 |
√ |
|
null |
|
|
| book_value_date |
date |
10 |
√ |
|
null |
|
|
| date_purchased |
date |
10 |
√ |
|
null |
|
|
| date_support_expires |
date |
10 |
√ |
|
null |
|
|
| date_support_starts |
date |
10 |
√ |
|
null |
|
|
| list_price |
decimal |
26,6 |
√ |
|
null |
|
|
| pricing_factor |
int |
4 |
√ |
|
null |
|
|
| pricing_formula |
varchar |
100 |
√ |
|
null |
|
|
| quantity |
decimal |
12,2 |
√ |
|
1.00 |
|
|
| serial_number |
varchar |
50 |
√ |
|
null |
|
|
| renewable |
bit |
1 |
√ |
|
0 |
|
|
| service |
bit |
1 |
√ |
|
0 |
|
|
| service_duration_value |
int |
5 |
√ |
|
null |
|
|
| service_duration_unit |
varchar |
50 |
√ |
|
null |
|
|
| catalog_service_duration_value |
int |
5 |
√ |
|
null |
|
|
| catalog_service_duration_unit |
varchar |
50 |
√ |
|
null |
|
|
| service_duration_multiplier |
decimal |
10 |
√ |
|
null |
|
|
| service_end_date |
date |
10 |
√ |
|
null |
|
|
| service_start_date |
date |
10 |
√ |
|
null |
|
|
| support_contact |
varchar |
50 |
√ |
|
null |
|
|
| support_description |
varchar |
255 |
√ |
|
null |
|
|
| support_name |
varchar |
50 |
√ |
|
null |
|
|
| support_term |
varchar |
100 |
√ |
|
null |
|
|
| tax_class |
varchar |
100 |
√ |
|
Taxable |
|
|
| type_id |
unknown |
0 |
|
|
|
|
|
| vendor_part_num |
varchar |
50 |
√ |
|
null |
|
|
| website |
varchar |
255 |
√ |
|
null |
|
|
| weight |
decimal |
12,2 |
√ |
|
null |
|
|
| currency_id |
char |
36 |
√ |
|
-99 |
|
|
| base_rate |
decimal |
26,6 |
√ |
|
null |
|
|
Analyzed at Mon Sep 28 07:45 UTC 2020
|
