Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| code | VARCHAR | 80 | null |
|
|
|||||||||
| description | VARCHAR | 200 | √ | NULL |
|
|
||||||||
| can_be_invoiced | TINYINT | 3 | 1 |
|
|
boolean flag to denote if this debit type is available for manual invoicing |
||||||||
| can_be_sold | TINYINT | 3 | 0 |
|
|
boolean flag to denote if this debit type is available at point of sale |
||||||||
| default_amount | DECIMAL | 28,6 | √ | NULL |
|
|
||||||||
| is_system | TINYINT | 3 | 0 |
|
|
|||||||||
| archived | TINYINT | 3 | 0 |
|
|
boolean flag to denote if this till is archived or not |
||||||||
| restricts_checkouts | TINYINT | 3 | 1 |
|
|
boolean flag to denote if the noissuescharge syspref for this debit type is active |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| account_debit_types_s_pk | Primary key | Asc | code |
| PRIMARY | Must be unique | Asc | code |
Relationships
Close relationships within degrees of separation
