| 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 |
|
|
| 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 |
|
|
| shipper_id |
char |
36 |
√ |
|
null |
|
|
| currency_id |
char |
36 |
√ |
|
-99 |
|
|
| base_rate |
decimal |
26,6 |
√ |
|
null |
|
|
| taxrate_id |
char |
36 |
√ |
|
null |
|
|
| show_line_nums |
bit |
1 |
√ |
|
1 |
|
|
| calc_grand_total |
bit |
1 |
√ |
|
1 |
|
|
| quote_type |
varchar |
100 |
√ |
|
null |
|
|
| date_quote_expected_closed |
date |
10 |
√ |
|
null |
|
|
| original_po_date |
date |
10 |
√ |
|
null |
|
|
| payment_terms |
varchar |
128 |
√ |
|
null |
|
|
| date_quote_closed |
date |
10 |
√ |
|
null |
|
|
| date_order_shipped |
date |
10 |
√ |
|
null |
|
|
| order_stage |
varchar |
100 |
√ |
|
null |
|
|
| quote_stage |
varchar |
100 |
√ |
|
null |
|
|
| purchase_order_num |
varchar |
50 |
√ |
|
null |
|
|
| quote_num |
int |
11 |
|
√ |
|
|
|
| subtotal |
decimal |
26,6 |
√ |
|
null |
|
|
| subtotal_usdollar |
decimal |
26,6 |
√ |
|
null |
|
|
| shipping |
decimal |
26,6 |
√ |
|
null |
|
|
| shipping_usdollar |
decimal |
26,6 |
√ |
|
null |
|
|
| discount |
decimal |
26,6 |
√ |
|
null |
|
|
| deal_tot |
decimal |
26,2 |
√ |
|
null |
|
|
| deal_tot_usdollar |
decimal |
26,2 |
√ |
|
null |
|
|
| new_sub |
decimal |
26,6 |
√ |
|
null |
|
|
| new_sub_usdollar |
decimal |
26,6 |
√ |
|
null |
|
|
| tax |
decimal |
26,6 |
√ |
|
null |
|
|
| tax_usdollar |
decimal |
26,6 |
√ |
|
null |
|
|
| total |
decimal |
26,6 |
√ |
|
null |
|
|
| total_usdollar |
decimal |
26,6 |
√ |
|
null |
|
|
| billing_address_street |
varchar |
150 |
√ |
|
null |
|
|
| billing_address_city |
varchar |
100 |
√ |
|
null |
|
|
| billing_address_state |
varchar |
100 |
√ |
|
null |
|
|
| billing_address_postalcode |
varchar |
20 |
√ |
|
null |
|
|
| billing_address_country |
varchar |
100 |
√ |
|
null |
|
|
| shipping_address_street |
varchar |
150 |
√ |
|
null |
|
|
| shipping_address_city |
varchar |
100 |
√ |
|
null |
|
|
| shipping_address_state |
varchar |
100 |
√ |
|
null |
|
|
| shipping_address_postalcode |
varchar |
20 |
√ |
|
null |
|
|
| shipping_address_country |
varchar |
100 |
√ |
|
null |
|
|
| system_id |
int |
11 |
√ |
|
null |
|
|
Analyzed at Mon Jun 16 07:58 UTC 2014
|
