Lines 3319-3324
CREATE TABLE `aqorders` ( -- information related to the basket line items
Link Here
|
3319 |
suppliers_reference_number varchar(35) default NULL, -- Suppliers unique edifact quote ref |
3319 |
suppliers_reference_number varchar(35) default NULL, -- Suppliers unique edifact quote ref |
3320 |
suppliers_reference_qualifier varchar(3) default NULL, -- Type of number above usually 'QLI' |
3320 |
suppliers_reference_qualifier varchar(3) default NULL, -- Type of number above usually 'QLI' |
3321 |
`suppliers_report` MEDIUMTEXT COLLATE utf8mb4_unicode_ci, -- reports received from suppliers |
3321 |
`suppliers_report` MEDIUMTEXT COLLATE utf8mb4_unicode_ci, -- reports received from suppliers |
|
|
3322 |
`estimated_delivery_date` date default null, |
3322 |
PRIMARY KEY (`ordernumber`), |
3323 |
PRIMARY KEY (`ordernumber`), |
3323 |
KEY `basketno` (`basketno`), |
3324 |
KEY `basketno` (`basketno`), |
3324 |
KEY `biblionumber` (`biblionumber`), |
3325 |
KEY `biblionumber` (`biblionumber`), |
3325 |
- |
|
|