Difference between revisions of "VbzCart/tables/rstk rcd"
Jump to navigation
Jump to search
m (tag) |
m (fixed table name in link) |
||
| Line 2: | Line 2: | ||
[[category:VbzCart/tables]] | [[category:VbzCart/tables]] | ||
* '''Created''': 2008-11-07 | * '''Created''': 2008-11-07 | ||
| − | * Master record for a restock shipment received; contents are in [[../ | + | * Master record for a restock shipment received; contents are in [[../rstk_recd_line]] |
==SQL== | ==SQL== | ||
<section begin=sql /><mysql>CREATE TABLE `rstk_recd` ( | <section begin=sql /><mysql>CREATE TABLE `rstk_recd` ( | ||
| Line 19: | Line 19: | ||
/* Final = Merch + Ship + Adj */ | /* Final = Merch + Ship + Adj */ | ||
`TotalInvFinal` DECIMAL(9,2) COMMENT "final total on invoice (must match amt paid)", | `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", | + | `PayMethod` VARCHAR(63) COMMENT "how payment was made, if not same as restock request", |
`Notes` TEXT DEFAULT NULL COMMENT "human-entered notes", | `Notes` TEXT DEFAULT NULL COMMENT "human-entered notes", | ||
PRIMARY KEY(`ID`) | PRIMARY KEY(`ID`) | ||
Revision as of 01:50, 8 November 2008
About
- Created: 2008-11-07
- Master record for a restock shipment received; contents are in VbzCart/tables/rstk_recd_line
SQL
<mysql>CREATE TABLE `rstk_recd` (
`ID` INT NOT NULL AUTO_INCREMENT, `ID_Restock` INT COMMENT "core_restocks.ID of restock this shipment fulfills", `SuppInvcNum` VARCHAR(63) COMMENT "supplier's invoice number", `CarrierDescr` VARCHAR(63) COMMENT "shipping carrier (UPS, USPS...)",
/* 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 by us", `TotalEstFinal` DECIMAL(9,2) COMMENT "estimate of final charge", /* 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>