Table: dbo.AP_Enter_Transaction_Description_Type
This table contains the three possible fields for Description column in Enter AP Transactions.
Columns
NameTypeConstraintsDescription
ap_enter_transaction_description_type_KEYint (4)NOT NULLPrimary Key. Also a Foreign Key to the AP_Enter_Transaction_List_View_Column_Option table. Not null.
descriptionnvarchar (44)NOT NULLRepresents the field to be used as Description column in Enter AP Transactions (Vendor, Journal or GL Account). Not null.
Primary key
NameColumnsDescription
PK_AP_Enter_Transaction_Description_Typeap_enter_transaction_description_type_KEY
Unique constraints
NameColumnsDescription
UK_AP_Enter_Transaction_Description_Type$descriptiondescription
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_AP_Enter_Transaction_List_View_Column_Option__AP_Enter_Transaction_Description_Type__default__ap_enter_transaction_descriptiodefault__ap_enter_transaction_description_type_KEYAP_Enter_Transaction_List_View_Column_Option

Schema diagram