CREATE TABLE `OrderDet` (
  `OrderNo` varchar(12) DEFAULT NULL,
  `JobNo` varchar(16) DEFAULT NULL,
  `PartNo` varchar(50) DEFAULT NULL,
  `PartDesc` longtext DEFAULT NULL,
  `Status` varchar(6) DEFAULT NULL,
  `BillingRate` smallint(6) DEFAULT NULL,
  `WorkCode` varchar(12) DEFAULT NULL,
  `ProdCode` varchar(12) DEFAULT NULL,
  `Priority` smallint(6) DEFAULT NULL,
  `UnitPrice` double DEFAULT NULL,
  `PricingUnit` varchar(3) DEFAULT NULL,
  `MasterJobNo` varchar(16) DEFAULT NULL,
  `MiscChg` double DEFAULT NULL,
  `MiscDescrip` varchar(30) DEFAULT NULL,
  `EstimStartDate` datetime DEFAULT NULL,
  `EstimEndDate` datetime DEFAULT NULL,
  `ActualStartDate` datetime DEFAULT NULL,
  `ActualEndDate` datetime DEFAULT NULL,
  `MiscChgBilled` char(1) DEFAULT NULL,
  `TravPrinted` char(1) DEFAULT 'N',
  `DiscPct` double DEFAULT NULL,
  `CumulativeBilling` double DEFAULT NULL,
  `FOB` varchar(30) DEFAULT NULL,
  `Revision` varchar(30) DEFAULT NULL,
  `CommPct` double DEFAULT NULL,
  `JobNotes` longtext DEFAULT NULL,
  `QtyOrdered` int(11) DEFAULT NULL,
  `QtyToMake` int(11) DEFAULT NULL,
  `QtyToStock` int(11) DEFAULT NULL,
  `QtyCanceled` int(11) DEFAULT NULL,
  `QtyShipped2Cust` int(11) DEFAULT NULL,
  `QtyShipped2Stock` int(11) DEFAULT NULL,
  `TotalEstHrs` double DEFAULT NULL,
  `TotalActualHrs` double DEFAULT NULL,
  `DueDate` datetime DEFAULT NULL,
  `PrevSaved` varchar(50) DEFAULT NULL,
  `RelSet` smallint(6) DEFAULT NULL,
  `DateFinished` datetime DEFAULT NULL,
  `CurrentWorkCntr` varchar(12) DEFAULT NULL,
  `ItemNo` smallint(6) DEFAULT NULL,
  `JobLabelPrinted` char(1) DEFAULT NULL,
  `ScheduleLocked` char(1) DEFAULT 'N',
  `Overlap` char(1) DEFAULT 'N',
  `Scheduled` char(1) DEFAULT 'N',
  `MasterStepNo` smallint(6) DEFAULT NULL,
  `OrderDet_ID` int(11) NOT NULL AUTO_INCREMENT,
  `User_Date1` datetime DEFAULT NULL,
  `User_Date2` datetime DEFAULT NULL,
  `User_Text1` varchar(30) DEFAULT NULL,
  `User_Text2` varchar(30) DEFAULT NULL,
  `User_Text3` varchar(30) DEFAULT NULL,
  `User_Text4` varchar(30) DEFAULT NULL,
  `User_Currency1` double DEFAULT NULL,
  `User_Currency2` double DEFAULT NULL,
  `User_Number1` double DEFAULT NULL,
  `User_Number2` double DEFAULT NULL,
  `User_Number3` double DEFAULT NULL,
  `User_Number4` double DEFAULT NULL,
  `User_Memo1` longtext DEFAULT NULL,
  `TempPriority` smallint(6) DEFAULT NULL,
  `QuoteNo` varchar(12) DEFAULT NULL,
  `QuoteItemNo` smallint(6) DEFAULT NULL,
  `JobOnHold` varchar(1) DEFAULT NULL,
  `Convert_Me` tinyint(1) DEFAULT NULL,
  `LastModDate` datetime DEFAULT NULL,
  `LastModUser` varchar(12) CHARACTER SET utf8 DEFAULT NULL,
  `IsTaxable` tinyint(4) NOT NULL DEFAULT 1,
  PRIMARY KEY (`OrderDet_ID`),
  UNIQUE KEY `IX_OrderDet_OrderNo_ItemNo` (`OrderNo`,`ItemNo`),
  KEY `IX_OrderDet_OrderNo` (`OrderNo`),
  KEY `IX_OrderDet_JobNo` (`JobNo`),
  KEY `IX_OrderDet_DueDate` (`DueDate`),
  KEY `IX_OrderDet_DateFinished` (`DateFinished`),
  KEY `IX_OrderDet_JobLabelPrinted` (`JobLabelPrinted`),
  KEY `IX_OrderDet_CurrentWorkCntr` (`CurrentWorkCntr`),
  KEY `IX_OrderDet_ScheduleLocked` (`ScheduleLocked`),
  KEY `IX_OrderDet_Scheduled` (`Scheduled`),
  KEY `IX_OrderDet_MasterJobNo_MasterStepNo` (`MasterJobNo`,`MasterStepNo`),
  KEY `IX_OrderDet_JobNo_Scheduled` (`JobNo`,`Scheduled`),
  KEY `IX_OrderDet_PartNo` (`PartNo`),
  KEY `IX_OrderDet_Status` (`Status`),
  KEY `IX_OrderDet_WorkCode` (`WorkCode`),
  KEY `IX_OrderDet_ProdCode` (`ProdCode`),
  KEY `IX_OrderDet_MasterJobNo` (`MasterJobNo`),
  KEY `IX_OrderDet_EstimStartDate` (`EstimStartDate`),
  KEY `IX_OrderDet_TravPrinted` (`TravPrinted`)
) ENGINE=InnoDB AUTO_INCREMENT=37690 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC

CREATE TABLE `CustReturnDet` (
  `CustRMANo` varchar(12) DEFAULT NULL,
  `OrigJobNo` varchar(16) DEFAULT NULL,
  `PartNo` varchar(50) DEFAULT NULL,
  `PartDesc` longtext DEFAULT NULL,
  `OrigQtyShipped` int(11) DEFAULT NULL,
  `QtyToRework` int(11) DEFAULT NULL,
  `QtyToRestock` int(11) DEFAULT NULL,
  `Unit` varchar(3) DEFAULT NULL,
  `CustPONum` varchar(30) DEFAULT NULL,
  `ReworkJobNo` varchar(16) DEFAULT NULL,
  `RMAItemNo` smallint(6) DEFAULT NULL,
  `Status` varchar(15) DEFAULT NULL,
  `BinLocation` varchar(50) DEFAULT NULL,
  `LotNumber` longtext DEFAULT NULL,
  `OrigOrderNo` varchar(12) DEFAULT NULL,
  `DelTicketNo` varchar(12) DEFAULT NULL,
  `DTItemNo` smallint(6) DEFAULT NULL,
  `QtyReturned` int(11) DEFAULT NULL,
  `QtyGood` int(11) DEFAULT NULL,
  `CreateCAR` varchar(1) DEFAULT NULL,
  `ReasonCode` varchar(12) DEFAULT NULL,
  `Description` longtext DEFAULT NULL,
  `CreateNC` varchar(1) DEFAULT NULL,
  `NonConfNo` varchar(12) DEFAULT NULL,
  `CorrectiveActionNo` varchar(12) DEFAULT NULL,
  `RestockingPct` float DEFAULT NULL,
  `CustReturnDet_ID` int(11) NOT NULL AUTO_INCREMENT,
  `LastModDate` datetime DEFAULT NULL,
  `LastModUser` varchar(12) CHARACTER SET utf8 DEFAULT NULL,
  PRIMARY KEY (`CustReturnDet_ID`),
  KEY `IX_CustReturnDet_OrigJobNo` (`OrigJobNo`),
  KEY `IX_CustReturnDet_PartNo` (`PartNo`),
  KEY `IX_CustReturnDet_CustRMANo` (`CustRMANo`),
  KEY `IX_CustReturnDet_CustRMANo_PartNo` (`CustRMANo`,`PartNo`),
  KEY `IX_CustReturnDet_ReworkJobNo` (`ReworkJobNo`)
) ENGINE=InnoDB AUTO_INCREMENT=322 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC

CREATE TABLE `JobMaterials` (
  `OrderNo` varchar(12) DEFAULT NULL,
  `JobNo` varchar(16) DEFAULT NULL,
  `PartNo` varchar(50) DEFAULT NULL,
  `Description` longtext DEFAULT NULL,
  `StepNo` smallint(6) DEFAULT 0,
  `MainPart` char(1) DEFAULT 'N',
  `BinLoc1` varchar(50) DEFAULT NULL,
  `QtyPosted1` double DEFAULT NULL,
  `BinLoc2` varchar(12) DEFAULT NULL,
  `QtyPosted2` double DEFAULT NULL,
  `BinLoc3` varchar(12) DEFAULT NULL,
  `QtyPosted3` double DEFAULT NULL,
  `BinLoc4` varchar(12) DEFAULT NULL,
  `QtyPosted4` double DEFAULT NULL,
  `BinLoc5` varchar(12) DEFAULT NULL,
  `QtyPosted5` double DEFAULT NULL,
  `PostedFromStock` char(1) DEFAULT NULL,
  `DatePosted` datetime DEFAULT NULL,
  `StockingCost` double DEFAULT NULL,
  `StockUnit` varchar(3) DEFAULT NULL,
  `PostedBy` varchar(12) DEFAULT NULL,
  `ResalePrice` double DEFAULT NULL,
  `PricingUnit` varchar(3) DEFAULT NULL,
  `ProdCode` varchar(12) DEFAULT NULL,
  `GLCode` varchar(12) DEFAULT NULL,
  `VendCode` varchar(12) DEFAULT NULL,
  `VendInvNo` varchar(30) DEFAULT NULL,
  `PONum` varchar(12) DEFAULT NULL,
  `PODate` datetime DEFAULT NULL,
  `OutsideService` char(1) DEFAULT NULL,
  `VendType` varchar(12) DEFAULT NULL,
  `ReceiverNo` varchar(12) DEFAULT NULL,
  `DelTicketNo` varchar(12) DEFAULT NULL,
  `ReceiverDate` datetime DEFAULT NULL,
  `DelTicketDate` datetime DEFAULT NULL,
  `Bin1Lot` longtext DEFAULT NULL,
  `Bin2Lot` longtext DEFAULT NULL,
  `Bin3Lot` longtext DEFAULT NULL,
  `Bin4Lot` longtext DEFAULT NULL,
  `Bin5Lot` longtext DEFAULT NULL,
  `JobMaterials_ID` int(11) NOT NULL AUTO_INCREMENT,
  `BinLocAutoNo` int(11) DEFAULT NULL,
  `OriginalBinCost` double DEFAULT NULL,
  `SubAssyJobNo` varchar(16) DEFAULT NULL,
  `MfgJobNo` varchar(16) DEFAULT NULL,
  `LastModDate` datetime DEFAULT NULL,
  `LastModUser` varchar(12) CHARACTER SET utf8 DEFAULT NULL,
  PRIMARY KEY (`JobMaterials_ID`),
  KEY `IX_JobMaterials_JobNo_PartNo` (`JobNo`,`PartNo`),
  KEY `IX_JobMaterials_BinLocAutoNo` (`BinLocAutoNo`),
  KEY `IX_JobMaterials_JobNo` (`JobNo`),
  KEY `IX_JobMaterials_PartNo` (`PartNo`),
  KEY `IX_JobMaterials_JobNo_StepNo` (`JobNo`,`StepNo`),
  KEY `IX_JobMaterials_PONum_PartNo` (`PONum`,`PartNo`),
  KEY `IX_JobMaterials_ReceiverNo_PartNo` (`ReceiverNo`,`PartNo`),
  KEY `IX_JobMaterials_DelTicketNo_PartNo` (`DelTicketNo`,`PartNo`),
  KEY `IX_JobMaterials_JobNo_PartNo_PostedFromStock` (`JobNo`,`PartNo`,`PostedFromStock`),
  KEY `IX_JobMaterials_ReceiverNo` (`ReceiverNo`)
) ENGINE=InnoDB AUTO_INCREMENT=167305 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC

CREATE TABLE `Releases` (
  `OrderNo` varchar(12) DEFAULT NULL,
  `JobNo` varchar(16) DEFAULT NULL,
  `PartNo` varchar(50) DEFAULT NULL,
  `PartDesc` longtext DEFAULT NULL,
  `DelType` smallint(6) DEFAULT NULL,
  `Qty` int(11) DEFAULT NULL,
  `DueDate` datetime DEFAULT NULL,
  `DateComplete` datetime DEFAULT NULL,
  `DeliveryTicketNo` varchar(12) DEFAULT NULL,
  `Comments` longtext DEFAULT NULL,
  `Releases_ID` int(11) NOT NULL AUTO_INCREMENT,
  `ItemNo` smallint(6) DEFAULT NULL,
  `DestJobNo` varchar(16) DEFAULT NULL,
  `MfgJobNo` varchar(16) DEFAULT NULL,
  `BinLocation` varchar(50) DEFAULT NULL,
  `LotNo` longtext DEFAULT NULL,
  `EDISoftItemNo` smallint(6) DEFAULT NULL,
  `LastModDate` datetime DEFAULT NULL,
  `LastModUser` varchar(12) CHARACTER SET utf8 DEFAULT NULL,
  PRIMARY KEY (`Releases_ID`),
  KEY `IX_Releases_OrderNo_ItemNo_DueDate` (`OrderNo`,`ItemNo`,`DueDate`),
  KEY `IX_Releases_DestJobNo` (`DestJobNo`),
  KEY `IX_Releases_JobNo` (`JobNo`),
  KEY `IX_Releases_OrderNo` (`OrderNo`),
  KEY `IX_Releases_OrderNo_ItemNo` (`OrderNo`,`ItemNo`),
  KEY `IX_Releases_DelType` (`DelType`),
  KEY `IX_Releases_DateComplete` (`DateComplete`),
  KEY `IX_Releases_DeliveryTicketNo` (`DeliveryTicketNo`),
  KEY `IX_Releases_JobNo_DateComplete_DelType` (`JobNo`,`DateComplete`,`DelType`),
  KEY `IX_Releases_MfgJobNo` (`MfgJobNo`)
) ENGINE=InnoDB AUTO_INCREMENT=179713 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC