| Inventory_id |
int(15)
|
|
|
|
| part_name |
varchar(200)
|
utf8_general_ci
|
|
|
| part_drg_no |
varchar(200)
|
utf8_general_ci
|
|
|
| batch_no |
int(2)
|
|
|
|
| vendor_order_qty |
decimal(10,3)
|
|
|
|
| actual_qty |
decimal(10,3)
|
|
|
|
| reqd_total_qty |
decimal(10,3)
|
|
|
|
| mat_req_qty |
decimal(10,3)
|
|
|
|
| mat_recd_qty |
decimal(10,3)
|
|
|
|
| part_rcpt_qty |
decimal(10,3)
|
|
|
|
| accepted_qty |
decimal(10,3)
|
|
|
|
| rejected_qty |
decimal(10,3)
|
|
|
|
| rework_qty |
decimal(10,3)
|
|
|
|
| rework_issue_qty |
decimal(10,3)
|
|
|
|
| part_issue_qty |
decimal(10,3)
|
|
|
|
| trgt_date |
date
|
|
|
|
| class_of_parts |
varchar(50)
|
utf8_general_ci
|
|
|
| status |
decimal(10,3)
|
|
|
|
| raw_mat_spec |
varchar(300)
|
utf8_general_ci
|
|
|
| raw_mat_dimension |
varchar(500)
|
utf8_general_ci
|
|
|
| remarks |
varchar(500)
|
utf8_general_ci
|
|
|
| stock_remarks_by_date_time |
varchar(100)
|
utf8_general_ci
|
|
|
| bom_qty |
decimal(10,3)
|
|
|
|
| no_of_stages |
int(3)
|
|
|
|
| status_flag |
varchar(5)
|
utf8_general_ci
|
|
|
| pending_assly_issue_qty |
decimal(10,3)
|
|
|
|
| type |
varchar(50)
|
utf8_general_ci
|
|
|
| mr_na |
int(1)
|
|
|
|
| hsn_code |
int(10)
|
|
|
|
| sac_code |
int(10)
|
|
|
|
| uom |
varchar(10)
|
utf8_general_ci
|
|
|
| model |
varchar(30)
|
utf8_general_ci
|
|
|
| make |
varchar(30)
|
utf8_general_ci
|
|
|
| website |
varchar(500)
|
utf8_general_ci
|
|
|
| STOCK_AVAILABILITY_ALWAYS_ONDEMAND |
varchar(10)
|
utf8_general_ci
|
|
|
| SAFTEY_STOCK_LEVEL |
decimal(10,3)
|
|
|
|
| NUMBER_OF_UNITS_IN_THE_BATCH |
decimal(10,3)
|
|
|
|
| PART_SPACE_CONSTRAINT |
varchar(10)
|
utf8_general_ci
|
|
|
| MINIMUM_ORDER_QUANTITY |
decimal(10,3)
|
|
|
|
| SHELF_LIFE |
varchar(10)
|
utf8_general_ci
|
|
|
| PART_AVAILABILITY_TO_UPCOMING_PROJECT_SCHEDULE |
varchar(10)
|
utf8_general_ci
|
|
|
| PART_OR_PRODUCT |
varchar(10)
|
utf8_general_ci
|
|
|
| PART_ACCESS_RESTRICTED |
varchar(10)
|
utf8_general_ci
|
|
|
| inventory_update_by |
varchar(100)
|
utf8_general_ci
|
|
|
| inventory_update_date |
date
|
|
|
|
