| Col # | Column Name | Data Type | Field Length | Not Null? | Data Def. | Comment | 1 |
|---|
ID | NUMBER | 22 | N | | 'Primary' key2 |
ACCOUNT_TYPE | VARCHAR2 | 15 | Y | | The account type (Business/Private)3 |
OWNER_ID | NUMBER | 22 | Y | | Foreign key to USER-table4 |
STATUS_ID | NUMBER | 22 | Y | | Status table check5 |
INVOICE_CYCLE_DAY | NUMBER | 22 | Y | | Day for the Invoice cycle6 |
INVOICE_CYCLE_LENGTH | NUMBER | 22 | Y | | Length of the invoice cycle in days7 |
SMALL_INVOICE_LIMIT | NUMBER | 22 | Y | | The minimum amount for the invoice a invoice must have before it is closed8 |
OLDID | NUMBER | 22 | Y | | ? | 9 |
LAST_CHANGED_DATE | DATE | 7 | Y | | The date of the last change made to the account10 |
PARTNER_CODE | VARCHAR2 | 15 | Y | | Sales partner code11 |
CURRENT_BALANCE | NUMBER | 22 | Y | | The current balance for the account12 |
CUSTOMER_NUMBER | VARCHAR2 | 50 | Y | | Customer number13 |
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 account16 |
CAMPAIGN | VARCHAR2 | 30 | Y | | NOT USED Campaign description17 |
INSURANCE | VARCHAR2 | 30 | Y | | NOT USED Insurance name18 |
ACC_ROW_ID | VARCHAR2 | 40 | Y | | ? | 19 |
ACCOUNT_GROUP_ID | NUMBER | 22 | Y | | The ID for the account group20 |
BRAND_ID | NUMBER | 22 | Y | | Foreign key - BRAND-table |
| 21 | ACCOUNT_SIGNUP_SHOP_ID | NUMBER | 22 | Y | | The ID for the sales Shop22 |
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-table26 |
ALIAS | VARCHAR2 | 100 | Y | | Alias for the account (Account name) |