GET api/orgAffiliateVw
Get all values from the AffiliateVw view
Request Information
URI Parameters
None.
Body Parameters
None.
Response Information
Resource Description
orgAffiliateVwDb| Name | Description | Type | Additional information |
|---|---|---|---|
| EntityID | integer |
Required |
|
| EntityName | string |
Max length: 100 |
|
| ShortName | string |
Max length: 20 |
|
| OnPropackHold | boolean |
Required |
|
| OnCreditHold | boolean |
Required |
|
| IsActive | boolean |
Required |
|
| IsShipCon | boolean |
Required |
|
| CreatedBy | integer |
Required |
|
| CreatedDate | date |
Required |
|
| UpdatedBy | integer |
Required |
|
| UpdatedDate | date |
Required |
|
| TerminalCount | integer |
Required |
|
| ActiveCount | integer |
Required |
|
| results | Collection of ValidationResult |
None. |
Response Formats
application/json, text/json
Sample:
{
"results": null,
"EntityID": 1,
"EntityName": "sample string 2",
"ShortName": "sample string 3",
"OnPropackHold": true,
"OnCreditHold": true,
"IsActive": true,
"IsShipCon": true,
"CreatedBy": 8,
"CreatedDate": "2025-12-06T23:40:54.1617621+00:00",
"UpdatedBy": 10,
"UpdatedDate": "2025-12-06T23:40:54.1617621+00:00",
"TerminalCount": 12,
"ActiveCount": 13
}
application/xml, text/xml
Sample:
<orgAffiliateVwDb xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.datacontract.org/2004/07/WebAPI.Data.Tables">
<results xmlns:d2p1="http://schemas.datacontract.org/2004/07/System.ComponentModel.DataAnnotations" i:nil="true" xmlns="http://schemas.datacontract.org/2004/07/WebAPI.Data.Utility" />
<ActiveCount>13</ActiveCount>
<CreatedBy>8</CreatedBy>
<CreatedDate xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
<d2p1:DateTime>2025-12-06T23:40:54.1617621Z</d2p1:DateTime>
<d2p1:OffsetMinutes>0</d2p1:OffsetMinutes>
</CreatedDate>
<EntityID>1</EntityID>
<EntityName>sample string 2</EntityName>
<IsActive>true</IsActive>
<IsShipCon>true</IsShipCon>
<OnCreditHold>true</OnCreditHold>
<OnPropackHold>true</OnPropackHold>
<ShortName>sample string 3</ShortName>
<TerminalCount>12</TerminalCount>
<UpdatedBy>10</UpdatedBy>
<UpdatedDate xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
<d2p1:DateTime>2025-12-06T23:40:54.1617621Z</d2p1:DateTime>
<d2p1:OffsetMinutes>0</d2p1:OffsetMinutes>
</UpdatedDate>
</orgAffiliateVwDb>