Groups
ACCOUNT
| Col # | Column Name | Data Type | Field Length | Not Null? | Data Def. | Comment |
|---|---|---|---|---|---|---|
| 1 | ID | NUMBER | 22 | N | 'Primary' key | |
| 2 | ACCOUNT_TYPE | VARCHAR2 | 15 | Y | The account type (Business/Private) | |
| 3 | OWNER_ID | NUMBER | 22 | Y | Foreign key to USER-table | |
| 4 | STATUS_ID | NUMBER | 22 | Y | Status table check | |
| 5 | INVOICE_CYCLE_DAY | NUMBER | 22 | Y | Day for the Invoice cycle | |
| 6 | INVOICE_CYCLE_LENGTH | NUMBER | 22 | Y | Length of the invoice cycle in days | |
| 7 | SMALL_INVOICE_LIMIT | NUMBER | 22 | Y | The minimum amount for the invoice a invoice must have before it is closed | |
| 8 | OLDID | NUMBER | 22 | Y | ? | |
| 9 | LAST_CHANGED_DATE | DATE | 7 | Y | The date of the last change made to the account | |
| 10 | PARTNER_CODE | VARCHAR2 | 15 | Y | Sales partner code | |
| 11 | CURRENT_BALANCE | NUMBER | 22 | Y | The current balance for the account | |
| 12 | CUSTOMER_NUMBER | VARCHAR2 | 50 | Y | Customer number | |
| 13 | WARNING | VARCHAR2 | 1000 | Y | Warning message | |
| 14 | SALES_REP | VARCHAR2 | 50 | Y | The name or initials of the Sales rep. | |
| 15 | REFERENCED_BY | VARCHAR2 | 30 | Y | The name or code of the reference for creation of the account | |
| 16 | CAMPAIGN | VARCHAR2 | 30 | Y | NOT USED Campaign description | |
| 17 | INSURANCE | VARCHAR2 | 30 | Y | NOT USED Insurance name | |
| 18 | ACC_ROW_ID | VARCHAR2 | 40 | Y | ? | |
| 19 | ACCOUNT_GROUP_ID | NUMBER | 22 | Y | The ID for the account group | |
| 20 | BRAND_ID | NUMBER | 22 | Y | Foreign key - BRAND-table | |
| 21 | ACCOUNT_SIGNUP_SHOP_ID | NUMBER | 22 | Y | The ID for the sales Shop | |
| 22 | OWNER_CHECKED | CHAR | 1 | Y | ? | |
| 23 | SIGNED | VARCHAR2 | 10 | Y | ? | |
| 24 | COMPANY_NO | VARCHAR2 | 200 | Y | Company number (VAT no./CVR) | |
| 25 | PARENT_ID | NUMBER | 22 | Y | Foreign key - ACCOUNT-table | |
| 26 | ALIAS | VARCHAR2 | 100 | Y | Alias for the account (Account name) |
Contains all Accounts