Invoice Table
Submitted by Daryle on Mon, 03/12/2012 - 10:55
| Field Name | Data Type | Constraints | Default Value | Description |
|---|---|---|---|---|
|
Invoice_Number |
Int |
Primary Key |
|
System Generated Incremental Number |
|
User_Number |
Int |
Foreign Key |
References User |
|
|
Invoice_Date |
Timestamp |
Not NULL |
|
Date on which the invoice was issued |
|
Invoice_Medium |
String (20) |
Not NULL |
|
One of “e-mail”, “paper”, “fax” or some other such descriptor of the method in which the invoice was delivered |
|
Invoice_Amount |
Float |
Not NULL |
|
The total value of the invoice |
|
Invoice_EnteredBy |
String (16) |
Not NULL |
|
The name of the GPFN Volunteer adding this invoice to the system |