| Field Name | Data Type | Constraints | Default Value | Description |
|---|---|---|---|---|
|
Receipt_Number |
Int |
Primary Key |
|
System Generated Incremental Number |
|
Invoice_Number |
Int |
Foreign Key |
References Invoice |
|
|
User_Number |
Int |
Foreign Key |
References User |
|
|
Receipt_Date |
Timestamp |
Not NULL |
|
Date that the amount was received and processed by the volunteer |
|
Receipt_Amount |
Float |
Not NULL |
0.00 |
Amount received from the user |
|
Receipt_Payment_Type |
String (30) |
Not NULL |
|
One of “Cash”, “Cheque”, “Credit Card” or some other description |
|
Receipt_Entered_By |
String (16) |
Not NULL |
|
The name of the GPFN Volunteer adding this receipt to the system |