Table: dbo.AR_Transaction_Type
This table stores the AR transaction types.
Columns
NameTypeConstraintsDescription
ar_transaction_type_KEYint (4)NOT NULLPrimary key for this table.
descriptionnvarchar (28)NOT NULLdescription of the AR transaction type.
Primary key
NameColumnsDescription
PK_AR_Transaction_Typear_transaction_type_KEY
Unique constraints
NameColumnsDescription
UK_AR_Transaction_Type$descriptiondescription
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_AR_Transaction_Template__AR_Transaction_Type__ar_transaction_type_KEYar_transaction_type_KEYAR_Transaction_Template
FK_AR_Enter_Invoice_Option__AR_Transaction_Type__default__ar_transaction_type_KEYdefault__ar_transaction_type_KEYAR_Enter_Invoice_Option
FK_AR_Transaction__AR_Transaction_Type__ar_transaction_type_KEYar_transaction_type_KEYAR_Transaction

Schema diagram