From HTYP, the free directory anyone can edit
- Purpose: Master record for a restock shipment received; contents are in rstk_rcd_line
- History:
- 2008-11-07 Created
- 2008-12-17 Added InvcEntry field
CREATE TABLE `rstk_rcd` (
`ID` INT NOT NULL AUTO_INCREMENT,
`ID_Restock` INT COMMENT "rstk_req.ID of restock this shipment fulfills",
`SuppInvcNum` VARCHAR(63) COMMENT "supplier's invoice number",
`CarrierDescr` VARCHAR(63) COMMENT "shipping carrier (UPS, USPS...)",
`InvcEntry` TEXT DEFAULT NULL COMMENT "invoice lines as parseable text",
`WhenShipped` DATETIME DEFAULT NULL COMMENT "when supplier shipped the package",
`WhenReceived` DATETIME DEFAULT NULL COMMENT "when package was received from supplier",
`WhenDebited` DATETIME DEFAULT NULL COMMENT "when charge for order was debited",
`TrackingCode` VARCHAR(63) COMMENT "carrier's tracking number",
`TotalCalcMerch` DECIMAL(9,2) COMMENT "total cost of merchandise calculated from contents of received restock",
/* from supplier invoice */
`TotalInvMerch` DECIMAL(9,2) COMMENT "total cost of merchandise invoiced",
`TotalInvShip` DECIMAL(9,2) COMMENT "total shipping cost invoiced",
`TotalInvAdj` DECIMAL(9,2) COMMENT "total invoice adjustments",
`TotalInvFinal` DECIMAL(9,2) COMMENT "final total on invoice (must match amt paid)",
`InvcCondition` INT DEFAULT NULL COMMENT "do we have all the paperwork for this invoice?",
`PayMethod` VARCHAR(63) COMMENT "how payment was made, if not same as restock request",
`Notes` TEXT DEFAULT NULL COMMENT "human-entered notes",
PRIMARY KEY(`ID`)
)
ENGINE = MYISAM;
- TrackingCode: eventually there will be a table of carriers so we can retrieve tracking info or at least pull it up from the web
- TotalInvFinal: Final = Merch + Ship + Adj
- InvcCondition: 0 = absent, 1 = partial, 2 = complete
