| id |
char(36)
|
utf8mb4_general_ci
|
|
|
| name |
text
|
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
|
|
|
| currency_id |
char(36)
|
utf8mb4_general_ci
|
|
|
| part_number |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| item_description |
text
|
utf8mb4_general_ci
|
|
|
| number |
int(11)
|
|
|
|
| product_qty |
decimal(18,4)
|
|
|
|
| product_cost_price |
decimal(26,6)
|
|
|
|
| product_cost_price_usdollar |
decimal(26,6)
|
|
|
|
| product_list_price |
decimal(26,6)
|
|
|
|
| product_list_price_usdollar |
decimal(26,6)
|
|
|
|
| product_discount |
decimal(26,6)
|
|
|
|
| product_discount_usdollar |
decimal(26,6)
|
|
|
|
| product_discount_amount |
decimal(26,6)
|
|
|
|
| product_discount_amount_usdollar |
decimal(26,6)
|
|
|
|
| discount |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| product_unit_price |
decimal(26,6)
|
|
|
|
| product_unit_price_usdollar |
decimal(26,6)
|
|
|
|
| vat_amt |
decimal(26,6)
|
|
|
|
| vat_amt_usdollar |
decimal(26,6)
|
|
|
|
| product_total_price |
decimal(26,6)
|
|
|
|
| product_total_price_usdollar |
decimal(26,6)
|
|
|
|
| vat |
varchar(100)
|
utf8mb4_general_ci
|
|
|
| parent_type |
varchar(100)
|
utf8mb4_general_ci
|
|
|
| parent_id |
char(36)
|
utf8mb4_general_ci
|
|
|
| product_id |
char(36)
|
utf8mb4_general_ci
|
|
|
| group_id |
char(36)
|
utf8mb4_general_ci
|
|
|
