Difference between revisions of "VbzCart/tables/rstk rcd"
Jump to navigation
Jump to search
(→SQL: -TotalEstFinal) |
(→SQL: 3 "When" fields (how did I manage to leave these out? what else have I forgotten?)) |
||
Line 9: | Line 9: | ||
`SuppInvcNum` VARCHAR(63) COMMENT "supplier's invoice number", | `SuppInvcNum` VARCHAR(63) COMMENT "supplier's invoice number", | ||
`CarrierDescr` VARCHAR(63) COMMENT "shipping carrier (UPS, USPS...)", | `CarrierDescr` VARCHAR(63) COMMENT "shipping carrier (UPS, USPS...)", | ||
+ | `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", | ||
/* eventually there will be a table of carriers so we can retrieve tracking info or at least pull it up from the web */ | /* eventually there will be a table of carriers so we can retrieve tracking info or at least pull it up from the web */ | ||
`TrackingCode` VARCHAR(63) COMMENT "carrier's tracking number", | `TrackingCode` VARCHAR(63) COMMENT "carrier's tracking number", |
Revision as of 01:08, 10 November 2008
About
- Created: 2008-11-07
- Master record for a restock shipment received; contents are in VbzCart/tables/rstk_rcd_line
SQL
<mysql>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...)", `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",
/* eventually there will be a table of carriers so we can retrieve tracking info or at least pull it up from the web */
`TrackingCode` VARCHAR(63) COMMENT "carrier's tracking number", `TotalCalcMerch` DECIMAL(9,2) COMMENT "total cost of merchandise calculated from contents of received restock", /* amounts 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",
/* Final = Merch + Ship + Adj */
`TotalInvFinal` DECIMAL(9,2) COMMENT "final total on invoice (must match amt paid)", `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;</mysql>