|
 | Comments | VARCHAR(2000) | Null | Comments to be included at the top of the email when the invoice is sent out. |
| Creation Date | datetime | Null | The date the record was created. |
| Creation User Name | VARCHAR(15) | Null | The name of the relevant user as used for logging into the system, e.g jtench. |
| Do Not Email | ENUM('Y','N') | NotNull | Invoice not to be emailed. |
| Edit Date | datetime | Null | The date the record was last edited. |
| Edit User Name | VARCHAR(15) | Null | The name of the relevant user as used for logging into the system, e.g jtench. |
| Email Address | VARCHAR(50) | Null | An email address in the format local-part@domain-name |
| Invoice Amount | DECIMAL(8,2) | Null | The amount on the invoice. |
| Invoice Date | DATE | Null | The invoice date as it appears on the invoice. |
| Invoice Line | VARCHAR(80) | Null | The line item as it appears on the invoice. By default this is generated from the membership type and the membership expiry date, e.g. Professional Membership subscription from 2012-06-11 to 2013-06-10''. |