ACCOUNT

Unknown macro: {float}

Col #	Column Name	Data Type	Field Length	Not Null?	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)
27	CA_UCN	VARCHAR2	400	Y	?
28	CA_SEGMENT_TYPE	VARCHAR2	400	Y	?

Contains all Accounts