Table: dbo.Quick_Books_Payee_Type
This table stores the valid Quick Books payee types
Columns
NameTypeConstraintsDescription
quick_books_payee_type_KEYint (4)NOT NULLPrimary key.
codenvarchar (2)NOT NULLPayee Type code.
descriptionnvarchar (20)NOT NULLPayee Type description of code.
Primary key
NameColumnsDescription
PK_Quick_Books_Payee_Typequick_books_payee_type_KEY
Unique constraints
NameColumnsDescription
UK_Quick_Books_Payee_Type$codecode
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Quick_Books_Payee__Quick_Books_Payee_Type__quick_books_payee_type_KEYquick_books_payee_type_KEYQuick_Books_Payee

Schema diagram