account_debit_types - testsql

Columns

Related columns Constraint Comments

Search:

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

code

VARCHAR

80

null

account_debit_types_branches.debit_type_code	account_debit_types_branches_ibfk_1 C
accountlines.debit_type_code	accountlines_ibfk_debit_type R

description

VARCHAR

200

√

null

can_be_invoiced

BIT

0

1

boolean flag to denote if this debit type is available for manual invoicing

can_be_sold

BIT

0

boolean flag to denote if this debit type is available at point of sale

default_amount

DECIMAL

28,6

√

null

is_system

BIT

0

archived

BIT

0

boolean flag to denote if this till is archived or not

Showing 1 to 7 of 7 entries

Table contained 0 rows

Indexes

Constraint Name	Type	Sort	Column(s)
PRIMARY	Primary key	Asc	code

Relationships

Close relationships within degrees of separation

One
Two degrees