| id |
char(36)
|
utf8mb4_general_ci
|
|
|
| name |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| date_entered |
datetime
|
|
|
|
| date_modified |
datetime
|
|
|
|
| modified_user_id |
char(36)
|
utf8mb4_general_ci
|
|
|
| created_by |
char(36)
|
utf8mb4_general_ci
|
|
|
| description |
text
|
utf8mb4_general_ci
|
|
|
| deleted |
tinyint(1)
|
|
|
|
| assigned_user_id |
char(36)
|
utf8mb4_general_ci
|
|
|
| billing_account_id |
char(36)
|
utf8mb4_general_ci
|
|
|
| billing_contact_id |
char(36)
|
utf8mb4_general_ci
|
|
|
| billing_address_street |
varchar(150)
|
utf8mb4_general_ci
|
|
|
| billing_address_city |
varchar(100)
|
utf8mb4_general_ci
|
|
|
| billing_address_state |
varchar(100)
|
utf8mb4_general_ci
|
|
|
| billing_address_postalcode |
varchar(20)
|
utf8mb4_general_ci
|
|
|
| billing_address_country |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| shipping_address_street |
varchar(150)
|
utf8mb4_general_ci
|
|
|
| shipping_address_city |
varchar(100)
|
utf8mb4_general_ci
|
|
|
| shipping_address_state |
varchar(100)
|
utf8mb4_general_ci
|
|
|
| shipping_address_postalcode |
varchar(20)
|
utf8mb4_general_ci
|
|
|
| shipping_address_country |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| number |
int(11)
|
|
|
|
| total_amt |
decimal(26,6)
|
|
|
|
| total_amt_usdollar |
decimal(26,6)
|
|
|
|
| subtotal_amount |
decimal(26,6)
|
|
|
|
| subtotal_amount_usdollar |
decimal(26,6)
|
|
|
|
| discount_amount |
decimal(26,6)
|
|
|
|
| discount_amount_usdollar |
decimal(26,6)
|
|
|
|
| tax_amount |
decimal(26,6)
|
|
|
|
| tax_amount_usdollar |
decimal(26,6)
|
|
|
|
| shipping_amount |
decimal(26,6)
|
|
|
|
| shipping_amount_usdollar |
decimal(26,6)
|
|
|
|
| shipping_tax |
varchar(100)
|
utf8mb4_general_ci
|
|
|
| shipping_tax_amt |
decimal(26,6)
|
|
|
|
| shipping_tax_amt_usdollar |
decimal(26,6)
|
|
|
|
| total_amount |
decimal(26,6)
|
|
|
|
| total_amount_usdollar |
decimal(26,6)
|
|
|
|
| currency_id |
char(36)
|
utf8mb4_general_ci
|
|
|
| quote_number |
int(11)
|
|
|
|
| quote_date |
date
|
|
|
|
| invoice_date |
date
|
|
|
|
| due_date |
date
|
|
|
|
| status |
varchar(100)
|
utf8mb4_general_ci
|
|
|
| template_ddown_c |
text
|
utf8mb4_general_ci
|
|
|
| subtotal_tax_amount |
decimal(26,6)
|
|
|
|
| subtotal_tax_amount_usdollar |
decimal(26,6)
|
|
|
|
