Invoice_Item Table
Submitted by Daryle on Mon, 03/12/2012 - 10:57
Field Name | Data Type | Constraints | Default Value | Description |
---|---|---|---|---|
Item_Number |
Int |
Primary Key |
|
System Generated Incremental Number |
Invoice_Number |
Int |
Foreign Key |
References Invoice |
|
User_Number |
Int |
Foreign Key |
References User |
|
Item_Description |
String (60) |
Not NULL |
|
Description of the line item for the invoice |
Item_Amount |
Float |
Not NULL |
0.00 |
Amount of the line item for the invoice |