Details
| Name | Data Type | Is Nullable |
|---|---|---|
| Id | Integer | False |
| WarehouseId | Integer | False |
| ReferenceCode | String | False |
| EffectiveDate | DateTime | True |
| ExpirationDate | DateTime | True |
| Comment | String | False |
| AllocationGroupId | Integer | False |
| SystemAllocationMethodId | Integer | False |
| MaximumPercentage | Decimal | False |
| StatisticId | Integer | True |
|
AverageMonths
Maximum number of months to average for getting statistic used for calculating agency percentage of product. This can be 1, if only the most recent applicable statistic should be used. If the average number for the allocation is greater than 1, but a particular agency has fewer months of statistics submitted, then the average will be calculated based on however many statistics have been submitted. Example, if average months is set up as 5, then an agency that only has submitted statistics for 3 months will have the average calculated for those 3 months. Agencies with 5 or more months will be calculated for 5 months. |
Integer | True |
|
OffsetMonths
Exclude most recent months from averaging. Enter -2 to exclude the 2 most recent months. Enter 0 to not exclude any months. |
Integer | True |
| CreatedOn | DateTime | False |
| CreatedBy | Integer | False |
| ModifiedOn | DateTime | False |
| ModifiedBy | Integer | False |
| InactiveOn | DateTime | True |
| InactiveBy | Integer | True |
| IsInactive | Boolean | False |
| WarehouseId::Warehouse.Name | String | False |
| WarehouseId_FormattedValue | String | False |
| AllocationGroupId::AllocationGroup.ReferenceCode | String | False |
| AllocationGroupId::AllocationGroup.Name | String | False |
| AllocationGroupId_FormattedValue | String | False |
| SystemAllocationMethodId::SystemAllocationMethod.Name | String | False |
| SystemAllocationMethodId_FormattedValue | String | False |
| StatisticId::Statistic.Name | String | False |
| StatisticId_FormattedValue | String | False |
Object:
{
Id":####,WarehouseId":####,
ReferenceCode":"abcABC123",
EffectiveDate":"MM-dd-yyyy hh:mm:ss",
ExpirationDate":"MM-dd-yyyy hh:mm:ss",
Comment":"abcABC123",
AllocationGroupId":####,
SystemAllocationMethodId":####,
MaximumPercentage":###.##,
StatisticId":####,
AverageMonths":####,
OffsetMonths":####,
CreatedOn":"MM-dd-yyyy hh:mm:ss",
CreatedBy":####,
ModifiedOn":"MM-dd-yyyy hh:mm:ss",
ModifiedBy":####,
InactiveOn":"MM-dd-yyyy hh:mm:ss",
InactiveBy":####,
IsInactive":True/False,
WarehouseId::Warehouse.Name":"abcABC123",
WarehouseId_FormattedValue":"abcABC123",
AllocationGroupId::AllocationGroup.ReferenceCode":"abcABC123",
AllocationGroupId::AllocationGroup.Name":"abcABC123",
AllocationGroupId_FormattedValue":"abcABC123",
SystemAllocationMethodId::SystemAllocationMethod.Name":"abcABC123",
SystemAllocationMethodId_FormattedValue":"abcABC123",
StatisticId::Statistic.Name":"abcABC123",
StatisticId_FormattedValue":"abcABC123"
}