Table: dbo.Bank_Feeds_Assignment_Rule | |||
This table hold the information of Create Rules dialog. The dialog should allow the user to create rules for assigning a description, reference, vendor, and account to bank statement transactions. The user may use the reference, description, amount, vendor, or account fields to apply the rules. | |||
Columns | |||
Name | Type | Constraints | Description |
bank_feeds_assignment_rule_KEY | int (4) | NOT NULL | Primary key for table. |
predicate_xml | nvarchar (-1) | NOT NULL | This column indicates an xml schema to capture the predicate syntax and stores each rules predicate in an xml string. |
name | nvarchar (100) | NOT NULL | This column indicates the identification of created Rule. |
client_KEY | int (4) | NOT NULL | Key of client to which this rule belongs |
Primary key | |||
Name | Columns | Description | |
PK_Bank_Feeds_Assignment_Rule | bank_feeds_assignment_rule_KEY | ||
Unique constraints | |||
Name | Columns | Description | |
UK_Bank_Feeds_Assignment_Rule$name$client_KEY | name, client_KEY |
Foreign keys | |||
Name | Columns | Referenced table | Description |
FK_Bank_Feeds_Assignment_Rule__Client__client_KEY | client_KEY | Client (client_KEY) |