{float:left|width=200px|background=lightgrey|border=solid blue 2px|margin=1px|padding=0px}
{children:page=Rator DB ER Diagram Navigator|depth=1|excerpt=trueindent=1px}
{float}
Column
width
33%
ACCOUNT
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 days
7
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