Column Type Size Nulls Auto Default Children Parents Comments
ID serial 10 nextval('"accounts_ID_seq"'::regclass)
actionsteps.account FK_actionsteps_account N
addresses.account FK_addresses_account C
contracts.account FK_contracts_account N
dunning.account FK_dunning_account N
opportunities.account FK_opportunities_account N
payments.account FK_payments_account N
pricelists2accounts.account FK_pricelists2accounts_account C
suppliers.account FK_suppliers_account C
tickets.account FK_tickets_account N
transactions.account FK_transactions_account N
ownergroup int4 10 null
groups.ID FK_accounts_ownergroup C

The owner group (if owneruser and ownergroup are NULL, the element is public)

creator int4 10 null
users.ID FK_accounts_creator N

The object creator

assigneduser int4 10 null
users.ID FK_accounts_assigneduser N

The assigned user

creationdate int8 19 (date_part('epoch'::text, now()))::bigint

Last modification date/time (Unix timestamp in seconds)

lastmodified int8 19 (date_part('epoch'::text, now()))::bigint

Last modification date/time (Unix timestamp in seconds)

contact int4 10 null
contacts.ID FK_accounts_contact N

Reference to the associated contact

visibility int2 5 0

0: Visible, 1: Archived, 2: Deleted

lastname text 2147483647 ''::text
firstname text 2147483647 ''::text
type int2 5 0

0: Prospect, 1: Customer, 2: Supplier, 3: Customer and Supplier, 4: Competitor

customernum text 2147483647 ''::text

A unique customer number (only visible for types "Prospect" and "Customer")

suppliernum text 2147483647 ''::text

A unique supplier number (only visible for type "Supplier")

currency varchar 3 null

Currency symbol (e.g. EUR or USD)

locked int2 5 0

If no transactions can be created for this account

excludetax int2 5 0

Exclude the customer from taxation

description text 2147483647 ''::text

The general description field

Table contained 0 rows


Constraint Name Type Sort Column(s)
PK_accounts_ID Primary key Asc ID