| grn_summary_id |
int(11)
|
|
|
|
| grn_no |
varchar(100)
|
utf8mb4_general_ci
|
|
|
| vendor |
varchar(100)
|
utf8mb4_general_ci
|
|
|
| vendor_po_no |
varchar(100)
|
utf8mb4_general_ci
|
|
|
| vendor_po_dt |
date
|
|
|
|
| grn_created_date |
date
|
|
|
|
| grn_created_by |
varchar(50)
|
utf8mb4_general_ci
|
|
|
| grn_type |
varchar(10)
|
utf8mb4_general_ci
|
|
|
| grn_status |
varchar(30)
|
utf8mb4_general_ci
|
|
|
| parts_count |
int(40)
|
|
|
|
| vendor_order_qty |
decimal(10,3)
|
|
|
|
| parts_receipt_qty |
decimal(10,3)
|
|
|
|
| accept_qty |
decimal(10,3)
|
|
|
|
| reject_qty |
decimal(10,3)
|
|
|
|
| rework_qty |
decimal(10,3)
|
|
|
|
| rework_issue_qty |
decimal(10,3)
|
|
|
|
| pending_qty |
decimal(10,3)
|
|
|
|
| grn_closed_date |
date
|
|
|
|
| grn_closed_by |
varchar(100)
|
utf8mb4_general_ci
|
|
|
| total_cost_without_tax |
decimal(10,3)
|
|
|
|
| total_cost_taxable |
decimal(10,3)
|
|
|
|
| os_planner |
varchar(100)
|
utf8mb4_general_ci
|
|
|
| oa_no |
varchar(50)
|
utf8mb4_general_ci
|
|
|
| last_updated |
timestamp
|
|
|
|
