|
id
|
char(36)
|
|
|
|
|
name
|
varchar(255)
|
|
|
|
|
date_entered
|
datetime
|
|
|
|
|
date_modified
|
datetime
|
|
|
|
|
modified_user_id
|
char(36)
|
|
|
|
|
created_by
|
char(36)
|
|
|
|
|
description
|
text
|
|
|
|
|
deleted
|
tinyint(1)
|
|
|
0
|
|
assigned_user_id
|
char(36)
|
|
|
|
|
total_amt
|
decimal(26,6)
|
|
|
|
|
total_amt_usdollar
|
decimal(26,6)
|
|
|
|
|
discount_amount
|
decimal(26,6)
|
|
|
|
|
discount_amount_usdollar
|
decimal(26,6)
|
|
|
|
|
subtotal_amount
|
decimal(26,6)
|
|
|
|
|
subtotal_amount_usdollar
|
decimal(26,6)
|
|
|
|
|
tax_amount
|
decimal(26,6)
|
|
|
|
|
tax_amount_usdollar
|
decimal(26,6)
|
|
|
|
|
subtotal_tax_amount
|
decimal(26,6)
|
|
|
|
|
subtotal_tax_amount_usdollar
|
decimal(26,6)
|
|
|
|
|
total_amount
|
decimal(26,6)
|
|
|
|
|
total_amount_usdollar
|
decimal(26,6)
|
|
|
|
|
parent_type
|
varchar(100)
|
|
|
|
|
parent_id
|
char(36)
|
|
|
|
|
number
|
int(11)
|
|
|
|
|
currency_id
|
char(36)
|
|
|
|