VendorGroup
Contains detailed information about vendor groups, including group attributes, associated entities, and creation/modification details.
Table Specific Info
When INSERTing a Vendorgroup with GroupType='ALL', Memberfilters and a Sortfield must be set. 'Memberfilters' should be set to an XML aggregate determining the conditions for inclusion in the group, and 'Sortfield' should be set to a Vendorgroup field.
INSERT INTO Vendorgroup (Id, Name, Grouptype, SORTFIELD, MEMBERFILTERS)
VALUES
('123abcde',
'123abcde',
'ALL',
'VENDORID',
'<filter>
<MEMBERFILTERS><FIELD>VENDTYPE</FIELD><OPERATOR>=</OPERATOR><VALUE>Supplier</VALUE></MEMBERFILTERS>
<MEMBERFILTERS><FIELD>City</FIELD><OPERATOR>=</OPERATOR><VALUE>Burnham</VALUE></MEMBERFILTERS>
</filter>')
Columns
| Name | Type | ReadOnly | Description |
| Id [KEY] | String | False |
The unique identifier for the vendor group. |
| Recordno | String | False |
A unique record number for the vendor group used for internal purposes. |
| Name | String | False |
The name of the vendor group. |
| Description | String | False |
A description providing more details about the vendor group. |
| Grouptype | String | False |
The type of group, which categorizes the vendor group (e.g., active, inactive). |
| Whencreated | Datetime | False |
The date and time when the vendor group was created. |
| Whenmodified | Datetime | False |
The date and time when the vendor group was last modified. |
| Createdby | Int64 | False |
The ID of the user who created the vendor group. |
| Modifiedby | Int64 | False |
The ID of the user who last modified the vendor group. |
| Megaentitykey | Int64 | False |
The key identifier for the mega entity associated with the vendor group. |
| Megaentityid | String | False |
The unique ID of the mega entity associated with the vendor group. |
| Megaentityname | String | False |
The name of the mega entity associated with the vendor group. |
Pseudo-Columns
| Name | Type | Description |
| Memberfilters | String |
Filters applied to the members of the vendor group, such as status or location. |
| SortField | String |
The field by which the vendor group data will be sorted (e.g., by name or creation date). |
| ConditionType | String |
The logical condition type used to filter the vendor group members. Valid values are 'AND' or 'OR'. |