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

Contains all Accounts

Browser not supported