| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ID | int4 | 10 | √ | null |
|
|
Account ID |
|||||||||||||||||||||
| ownergroup | int4 | 10 | √ | null |
|
|
Owner group ID ( |
|||||||||||||||||||||
| creator | int4 | 10 | √ | null |
|
|
Creator user ID (defaults to authenticated user on creation) |
|||||||||||||||||||||
| assigneduser | int4 | 10 | √ | null |
|
|
Assigned user ID |
|||||||||||||||||||||
| creationdate | int8 | 19 | date_part('epoch'::text, now()) |
|
|
Creation date and time as a Unix time stamp (defaults to current date and time on creation) |
||||||||||||||||||||||
| lastmodified | int8 | 19 | date_part('epoch'::text, now()) |
|
|
Last modification date and time as a Unix time stamp (auto-reset on modification) |
||||||||||||||||||||||
| contact | int4 | 10 | √ | null |
|
|
Contact ID |
|||||||||||||||||||||
| visibility | int2 | 5 | 0 |
|
|
Visibility ( |
||||||||||||||||||||||
| lastname | text | 2147483647 | ''::text |
|
|
Last name (surname or company name); is required if |
||||||||||||||||||||||
| firstname | text | 2147483647 | ''::text |
|
|
First name (given name); is required if |
||||||||||||||||||||||
| type | int2 | 5 | 0 |
|
|
Account type ( |
||||||||||||||||||||||
| customernum | text | 2147483647 | ''::text |
|
|
Customer number (only for PROSPECT, CUSTOMERANDSUPPLIER, CUSTOMER or EMPLOYEE) |
||||||||||||||||||||||
| suppliernum | text | 2147483647 | ''::text |
|
|
Supplier number (only for SUPPLIER or CUSTOMERANDSUPPLIER) |
||||||||||||||||||||||
| currency | varchar | 3 | null |
|
|
Currency code (ISO 4217) (Pattern: |
||||||||||||||||||||||
| locked | int2 | 5 | 0 |
|
|
Deny booking of billing or procurement transactions |
||||||||||||||||||||||
| excludetax | int2 | 5 | 0 |
|
|
Exclude from taxation |
||||||||||||||||||||||
| description | text | 2147483647 | ''::text |
|
|
Detailed general description |
Table contained 0 rows
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| pk_accounts | Primary key | Asc | ID |
| fk_accounts_contact | Performance | Asc | contact |
| i_accounts_lastname_firstname_ID | Performance | Asc/Asc/Asc | lastname + firstname + ID |
| i_accounts_noowner | Performance | Asc | ownergroup |
| i_accounts_owner | Performance | Asc/Asc | ownergroup + assigneduser |
| s_accounts | Performance | Asc/Asc/Asc/Asc | lastname + firstname + customernum + suppliernum |
