Table: dbo.AP_Enter_Transaction_Description_Type | |||
This table contains the three possible fields for Description column in Enter AP Transactions. | |||
Columns | |||
Name | Type | Constraints | Description |
ap_enter_transaction_description_type_KEY | int (4) | NOT NULL | Primary Key. Also a Foreign Key to the AP_Enter_Transaction_List_View_Column_Option table. Not null. |
description | nvarchar (44) | NOT NULL | Represents the field to be used as Description column in Enter AP Transactions (Vendor, Journal or GL Account). Not null. |
Primary key | |||
Name | Columns | Description | |
PK_AP_Enter_Transaction_Description_Type | ap_enter_transaction_description_type_KEY | ||
Unique constraints | |||
Name | Columns | Description | |
UK_AP_Enter_Transaction_Description_Type$description | description |
Incoming foreign keys | |||
Name | Columns | Referencing table | Description |
FK_AP_Enter_Transaction_List_View_Column_Option__AP_Enter_Transaction_Description_Type__default__ap_enter_transaction_descriptio | default__ap_enter_transaction_description_type_KEY | AP_Enter_Transaction_List_View_Column_Option |