WorkFerret/tables/invoice: Difference between revisions
< WorkFerret | tables
Jump to navigation
Jump to search
(Created page with '==About== * '''History''': ** '''2010-01-28''' Adapted from MS Access version * '''Fields''': ** '''InvcSeq''' is used to generate the invoice number. I'm thinking [invc ID [zero…') |
(+fields: InvcNum, Notes) |
||
| Line 2: | Line 2: | ||
* '''History''': | * '''History''': | ||
** '''2010-01-28''' Adapted from MS Access version | ** '''2010-01-28''' Adapted from MS Access version | ||
** '''2010-02-05''' Added fields: InvcNum, Notes | |||
* '''Fields''': | * '''Fields''': | ||
** '''InvcSeq''' is used to generate the invoice number. I'm thinking [invc ID [zero-padded]]-[invc pfx]-[InvcSeq] would be sortable ''and'' would provide a validity check (i.e. nobody could just make one up because of the ID). | ** '''InvcSeq''' is used to generate the invoice number. I'm thinking [invc ID [zero-padded]]-[invc pfx]-[InvcSeq] would be sortable ''and'' would provide a validity check (i.e. nobody could just make one up because of the ID). | ||
| Line 10: | Line 11: | ||
`ID_Proj` INT(4) NOT NULL COMMENT "Project to which this invoice applies", | `ID_Proj` INT(4) NOT NULL COMMENT "Project to which this invoice applies", | ||
`InvcSeq` VARCHAR(7) NOT NULL COMMENT "Invoice sequence number", | `InvcSeq` VARCHAR(7) NOT NULL COMMENT "Invoice sequence number", | ||
`InvcNum` VARCHAR(31) NOT NULL COMMENT "Complete invoice number", | |||
`TotalAmt` DECIMAL(9,2) NOT NULL COMMENT "total amount billed", | `TotalAmt` DECIMAL(9,2) NOT NULL COMMENT "total amount billed", | ||
`WhenCreated` DATETIME NOT NULL COMMENT "when the invoice was created", | `WhenCreated` DATETIME NOT NULL COMMENT "when the invoice was created", | ||
| Line 15: | Line 17: | ||
`WhenPaid` DATETIME DEFAULT NULL COMMENT "when payment was received on this invoice", | `WhenPaid` DATETIME DEFAULT NULL COMMENT "when payment was received on this invoice", | ||
`WhenVoid` DATETIME DEFAULT NULL COMMENT "when this invoice was cancelled or otherwise nullified", | `WhenVoid` DATETIME DEFAULT NULL COMMENT "when this invoice was cancelled or otherwise nullified", | ||
`Notes` VARCHAR(255) DEFAULT NULL COMMENT "human-entered notes", | |||
PRIMARY KEY(`ID`) | PRIMARY KEY(`ID`) | ||
) ENGINE=MyISAM;</mysql> | ) ENGINE=MyISAM;</mysql> | ||
Revision as of 16:58, 5 February 2010
About
- History:
- 2010-01-28 Adapted from MS Access version
- 2010-02-05 Added fields: InvcNum, Notes
- Fields:
- InvcSeq is used to generate the invoice number. I'm thinking [invc ID [zero-padded]]-[invc pfx]-[InvcSeq] would be sortable and would provide a validity check (i.e. nobody could just make one up because of the ID).
SQL
<mysql>DROP TABLE IF EXISTS `invoice`; CREATE TABLE `invoice` (
`ID` INT(4) NOT NULL AUTO_INCREMENT, `ID_Proj` INT(4) NOT NULL COMMENT "Project to which this invoice applies", `InvcSeq` VARCHAR(7) NOT NULL COMMENT "Invoice sequence number", `InvcNum` VARCHAR(31) NOT NULL COMMENT "Complete invoice number", `TotalAmt` DECIMAL(9,2) NOT NULL COMMENT "total amount billed", `WhenCreated` DATETIME NOT NULL COMMENT "when the invoice was created", `WhenSent` DATETIME DEFAULT NULL COMMENT "when the invoice was sent out to the client", `WhenPaid` DATETIME DEFAULT NULL COMMENT "when payment was received on this invoice", `WhenVoid` DATETIME DEFAULT NULL COMMENT "when this invoice was cancelled or otherwise nullified", `Notes` VARCHAR(255) DEFAULT NULL COMMENT "human-entered notes", PRIMARY KEY(`ID`)
) ENGINE=MyISAM;</mysql>