Invoice_Item Table

Invoice_Item Table
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