VendorGroup
Retrieves VendorGroup report data.
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 Id field of the VendorGroup object. |
| Recordno | String | False |
The Recordno field of the VendorGroup object. |
| Name | String | False |
The Name field of the VendorGroup object. |
| Description | String | False |
The Description field of the VendorGroup object. |
| Grouptype | String | False |
The Grouptype field of the VendorGroup object. |
| Whencreated | Datetime | False |
The Whencreated field of the VendorGroup object. |
| Whenmodified | Datetime | False |
The Whenmodified field of the VendorGroup object. |
| Createdby | Int64 | False |
The Createdby field of the VendorGroup object. |
| Modifiedby | Int64 | False |
The Modifiedby field of the VendorGroup object. |
| Megaentitykey | Int64 | False |
The Megaentitykey field of the VendorGroup object. |
| Megaentityid | String | False |
The Megaentityid field of the VendorGroup object. |
| Megaentityname | String | False |
The Megaentityname field of the VendorGroup object. |
Pseudo-Columns
| Name | Type | Description |
| Memberfilters | String |
Filters of a Vendorgroup. |
| SortField | String |
Sortfield of a Vendorgroup. |
| ConditionType | String |
ConditionType of a Vendorgroup. Valid values are: 'AND', 'OR'. |