Groups
BRAND (Frontend)
Col # | Column Name | Data Type | Field Length | Not Null? | Data Def. | Comments |
|---|---|---|---|---|---|---|
| 1 | ID | NUMBER | 22 | N | Primary key | |
| 2 | NAME | VARCHAR2 | 100 | Y | ||
| 3 | MAIL_USERNAME | VARCHAR2 | 100 | Y | ||
| 4 | MAIL_PASSWORD | VARCHAR2 | 100 | Y | ||
| 5 | MAIL_POPSERVER | VARCHAR2 | 100 | Y | ||
| 6 | MAIL_SERVER_TYPE | VARCHAR2 | 100 | Y | ||
| 7 | MAIL_FROM_NAME | VARCHAR2 | 100 | Y | ||
| 8 | MAIL_POPPORT | NUMBER | 22 | Y | ||
| 9 | MAIL_SUPPORT_EMAIL | VARCHAR2 | 50 | Y | ||
| 10 | BRAND_KEY | VARCHAR2 | 10 | Y | ||
| 11 | BRAND_ACTIVE | VARCHAR2 | 4 | Y | ||
| 12 | INVOICE_DOC_TYPE | NUMBER | 22 | Y |
Definition of all Brands (currently there will be one: FNB)