Details
| Name | Data Type | Is Nullable |
|---|---|---|
| Id | Integer | False |
| ReferenceCode | String | False |
| Name | String | False |
| AgencyStatusId | Integer | False |
| CarrierRoute | String | False |
| AgencyGroupId | Integer | True |
| AgencyTypeId | Integer | True |
| LocaleServiced | String | False |
| RequireOnSiteProduct | Boolean | False |
| RequireOffSiteProduct | Boolean | False |
| AgencySizeId | Integer | True |
| AgencyPantrySizeId | Integer | True |
| AgencySiteSizeId | Integer | True |
| ServiceFeeId | Integer | True |
| MarkupId | Integer | True |
|
CityId
This field is used for reporting purposes so ensure you have the correct city information entered. |
Integer | True |
|
CountyId
This field is used for reporting purposes so ensure you have the correct county information entered. |
Integer | True |
| FederalDistrictId | Integer | True |
| StateSenateDistrictId | Integer | True |
| StateHouseDistrictId | Integer | True |
| CountyCouncilDistrictId | Integer | True |
| CityCouncilDistrictId | Integer | True |
| LastPickup | DateTime | True |
| LastMonitored | DateTime | True |
| NextMonitored | DateTime | True |
| NextMonitoredReminderSentDate | DateTime | True |
| LastSiteVisit | DateTime | True |
| OrderComments | String | False |
| BranchId | Integer | True |
| LastOrder | DateTime | True |
| LastPayment | DateTime | True |
| LastStatistic | DateTime | True |
| ReceivesStatement | Boolean | False |
| CreditLimit | Decimal | False |
| ApplyLateCharge | Boolean | False |
| FreeFoodOnly | Boolean | False |
| IsFoodRescueParticipant | Boolean | False |
| ParentAgencyId | Integer | True |
| PaymentTermId | Integer | True |
| DefaultOrderWarehouseId | Integer | False |
| DefaultPickupWarehouseId | Integer | True |
| DefaultShippingMethodId | Integer | False |
| StatisticsRequired | Boolean | False |
| PreferredPickupTime | DateTime | True |
| DefaultScheduleLocationId | Integer | True |
| MonthlyCreditLimit | Decimal | False |
| MonthlyWeightLimit | Decimal | False |
| IsSuspended | Boolean | False |
| SuspendedOn | DateTime | True |
| SuspensionReason | String | False |
| IsWarehouse | Boolean | False |
| DefaultToRetailPUD | Boolean | False |
| FederalId | String | False |
| MaxDeliveriesPerPeriod | Integer | False |
| StatisticGroupId | Integer | False |
| DefaultToMobilePantryDrop | Boolean | False |
| MainContactId | Integer | True |
| MainAddressId | Integer | True |
| IsAgencyPickup | Boolean | False |
| IsCashAndCarry | Boolean | False |
| IsRecurringOrder | Boolean | False |
| RecurringOrderOffsetDays | Integer | True |
| AgencyActivityId | Integer | True |
| SchedulePickup | String | False |
| Ein | String | False |
| AccountOpened | DateTime | True |
| CreatedOn | DateTime | False |
| CreatedBy | Integer | False |
| ModifiedOn | DateTime | False |
| ModifiedBy | Integer | False |
| InactiveOn | DateTime | True |
| InactiveBy | Integer | True |
| IsInactive | Boolean | False |
| DefaultShipToAddressId | Integer | True |
| DefaultShipToContactId | Integer | True |
| PreferredPickupDay | Integer | True |
| MailingAddressId | Integer | True |
| MailingContactId | Integer | True |
| BillToAddressId | Integer | True |
| BillToContactId | Integer | True |
| IsMobilePantry | Boolean | False |
|
AgencyInventoryEnabled
Enables client services inventory features for this agency |
Boolean | False |
| DeliveriesPerYear | Integer | False |
|
HasCooler
Enables agency to receive refrigerated product |
Boolean | False |
|
HasFreezer
Enables agency to receive frozen product |
Boolean | False |
| IsFoodBankProgram | Boolean | False |
| IsSDO | Boolean | False |
| IsOpen24 | Boolean | False |
| HomeDeliveryProvided | Boolean | False |
| PostPublicly | Boolean | False |
|
OverrideStatisticFrequencyGroupId
Fill this in only when this agency is required to submit statistics on a different frequency than what is setup in General Setup. |
Integer | True |
| AltReferenceId1 | String | False |
| AltReferenceId2 | String | False |
|
FaithBasedProgram
Indicates whether or not this is a faith based program |
Boolean | False |
|
ClientProductChoiceId
The product choice offered by the agency to the clients |
Integer | True |
| AgencyStatusId::AgencyStatus.Name | String | False |
| AgencyStatusId_FormattedValue | String | False |
| AgencyGroupId::AgencyGroup.Name | String | False |
| AgencyGroupId_FormattedValue | String | False |
| OverrideStatisticFrequencyGroupId::StatisticFrequencyGroup.Name | String | False |
| OverrideStatisticFrequencyGroupId_FormattedValue | String | False |
| AgencyTypeId::AgencyType.Name | String | False |
| AgencyTypeId_FormattedValue | String | False |
| AgencySizeId::AgencySize.ReferenceCode | String | False |
| AgencySizeId::AgencySize.Name | String | False |
| AgencySizeId_FormattedValue | String | False |
| AgencyPantrySizeId::AgencyPantrySize.ReferenceCode | String | False |
| AgencyPantrySizeId::AgencyPantrySize.Name | String | False |
| AgencyPantrySizeId_FormattedValue | String | False |
| AgencySiteSizeId::AgencySiteSize.ReferenceCode | String | False |
| AgencySiteSizeId::AgencySiteSize.Name | String | False |
| AgencySiteSizeId_FormattedValue | String | False |
| ServiceFeeId::ServiceFee.ReferenceCode | String | False |
| ServiceFeeId::ServiceFee.Name | String | False |
| ServiceFeeId_FormattedValue | String | False |
| MarkupId::Markup.Name | String | False |
| MarkupId_FormattedValue | String | False |
| CityId::City.Name | String | False |
| CityId_FormattedValue | String | False |
| CountyId::County.Name | String | False |
| CountyId_FormattedValue | String | False |
| FederalDistrictId::FederalDistrict.Name | String | False |
| FederalDistrictId_FormattedValue | String | False |
| StateSenateDistrictId::StateSenateDistrict.Name | String | False |
| StateSenateDistrictId_FormattedValue | String | False |
| StateHouseDistrictId::StateHouseDistrict.Name | String | False |
| StateHouseDistrictId_FormattedValue | String | False |
| CountyCouncilDistrictId::CountyCouncilDistrict.Name | String | False |
| CountyCouncilDistrictId_FormattedValue | String | False |
| CityCouncilDistrictId::CityCouncilDistrict.Name | String | False |
| CityCouncilDistrictId_FormattedValue | String | False |
| BranchId::Branch.Name | String | False |
| BranchId_FormattedValue | String | False |
| ParentAgencyId::Agency.ReferenceCode | String | False |
| ParentAgencyId::Agency.Name | String | False |
| ParentAgencyId_FormattedValue | String | False |
| PaymentTermId::PaymentTerm.ReferenceCode | String | False |
| PaymentTermId::PaymentTerm.Name | String | False |
| PaymentTermId_FormattedValue | String | False |
| DefaultOrderWarehouseId::Warehouse.ReferenceCode | String | False |
| DefaultOrderWarehouseId::Warehouse.Name | String | False |
| DefaultOrderWarehouseId_FormattedValue | String | False |
| DefaultPickupWarehouseId::Warehouse.ReferenceCode | String | False |
| DefaultPickupWarehouseId::Warehouse.Name | String | False |
| DefaultPickupWarehouseId_FormattedValue | String | False |
| DefaultShippingMethodId::ShippingMethod.Name | String | False |
| DefaultShippingMethodId_FormattedValue | String | False |
| DefaultShipToAddressId::AgencyAddress.Name | String | False |
| DefaultShipToAddressId::AgencyAddress.AddressLine1 | String | False |
| DefaultShipToAddressId::AgencyAddress.AddressLine2 | String | False |
| DefaultShipToAddressId::AgencyAddress.City | String | False |
| DefaultShipToAddressId::AgencyAddress.PostalCode | String | False |
| DefaultShipToAddressId_FormattedValue | String | False |
| DefaultShipToContactId::AgencyContact.FirstName | String | False |
| DefaultShipToContactId::AgencyContact.LastName | String | False |
| DefaultShipToContactId_FormattedValue | String | False |
| PreferredPickupDay::SystemDayOfWeek.Name | String | False |
| PreferredPickupDay_FormattedValue | String | False |
| DefaultScheduleLocationId::ScheduleLocation.ReferenceCode | String | False |
| DefaultScheduleLocationId::ScheduleLocation.Name | String | False |
| DefaultScheduleLocationId_FormattedValue | String | False |
| StatisticGroupId::StatisticGroup.Name | String | False |
| StatisticGroupId_FormattedValue | String | False |
| MainContactId::AgencyContact.Prefix | String | False |
| MainContactId::AgencyContact.FirstName | String | False |
| MainContactId::AgencyContact.LastName | String | False |
| MainContactId::AgencyContact.Suffix | String | False |
| MainContactId::AgencyContact.Telephone | String | False |
| MainContactId::AgencyContact.EmailAddress | String | False |
| MainContactId_FormattedValue | String | False |
| MainAddressId::AgencyAddress.Name | String | False |
| MainAddressId::AgencyAddress.AddressLine1 | String | False |
| MainAddressId::AgencyAddress.AddressLine2 | String | False |
| MainAddressId::AgencyAddress.City | String | False |
| MainAddressId::AgencyAddress.PostalCode | String | False |
| MainAddressId_FormattedValue | String | False |
| BillToContactId::AgencyContact.Prefix | String | False |
| BillToContactId::AgencyContact.FirstName | String | False |
| BillToContactId::AgencyContact.LastName | String | False |
| BillToContactId::AgencyContact.Suffix | String | False |
| BillToContactId::AgencyContact.Telephone | String | False |
| BillToContactId::AgencyContact.EmailAddress | String | False |
| BillToContactId_FormattedValue | String | False |
| BillToAddressId::AgencyAddress.Name | String | False |
| BillToAddressId::AgencyAddress.AddressLine1 | String | False |
| BillToAddressId::AgencyAddress.AddressLine2 | String | False |
| BillToAddressId::AgencyAddress.City | String | False |
| BillToAddressId_FormattedValue | String | False |
| MailingContactId::AgencyContact.Prefix | String | False |
| MailingContactId::AgencyContact.FirstName | String | False |
| MailingContactId::AgencyContact.LastName | String | False |
| MailingContactId::AgencyContact.Suffix | String | False |
| MailingContactId::AgencyContact.Telephone | String | False |
| MailingContactId::AgencyContact.EmailAddress | String | False |
| MailingContactId_FormattedValue | String | False |
| MailingAddressId::AgencyAddress.Name | String | False |
| MailingAddressId::AgencyAddress.AddressLine1 | String | False |
| MailingAddressId::AgencyAddress.AddressLine2 | String | False |
| MailingAddressId::AgencyAddress.City | String | False |
| MailingAddressId_FormattedValue | String | False |
| AgencyActivityId::AgencyActivity.Name | String | False |
| AgencyActivityId_FormattedValue | String | False |
| ClientProductChoiceId::ClientProductChoice.Name | String | False |
| ClientProductChoiceId_FormattedValue | String | False |
Object:
{
Id":####,ReferenceCode":"abcABC123",
Name":"abcABC123",
AgencyStatusId":####,
CarrierRoute":"abcABC123",
AgencyGroupId":####,
AgencyTypeId":####,
LocaleServiced":"abcABC123",
RequireOnSiteProduct":True/False,
RequireOffSiteProduct":True/False,
AgencySizeId":####,
AgencyPantrySizeId":####,
AgencySiteSizeId":####,
ServiceFeeId":####,
MarkupId":####,
CityId":####,
CountyId":####,
FederalDistrictId":####,
StateSenateDistrictId":####,
StateHouseDistrictId":####,
CountyCouncilDistrictId":####,
CityCouncilDistrictId":####,
LastPickup":"MM-dd-yyyy hh:mm:ss",
LastMonitored":"MM-dd-yyyy hh:mm:ss",
NextMonitored":"MM-dd-yyyy hh:mm:ss",
NextMonitoredReminderSentDate":"MM-dd-yyyy hh:mm:ss",
LastSiteVisit":"MM-dd-yyyy hh:mm:ss",
OrderComments":"abcABC123",
BranchId":####,
LastOrder":"MM-dd-yyyy hh:mm:ss",
LastPayment":"MM-dd-yyyy hh:mm:ss",
LastStatistic":"MM-dd-yyyy hh:mm:ss",
ReceivesStatement":True/False,
CreditLimit":###.##,
ApplyLateCharge":True/False,
FreeFoodOnly":True/False,
IsFoodRescueParticipant":True/False,
ParentAgencyId":####,
PaymentTermId":####,
DefaultOrderWarehouseId":####,
DefaultPickupWarehouseId":####,
DefaultShippingMethodId":####,
StatisticsRequired":True/False,
PreferredPickupTime":"MM-dd-yyyy hh:mm:ss",
DefaultScheduleLocationId":####,
MonthlyCreditLimit":###.##,
MonthlyWeightLimit":###.##,
IsSuspended":True/False,
SuspendedOn":"MM-dd-yyyy hh:mm:ss",
SuspensionReason":"abcABC123",
IsWarehouse":True/False,
DefaultToRetailPUD":True/False,
FederalId":"abcABC123",
MaxDeliveriesPerPeriod":####,
StatisticGroupId":####,
DefaultToMobilePantryDrop":True/False,
MainContactId":####,
MainAddressId":####,
IsAgencyPickup":True/False,
IsCashAndCarry":True/False,
IsRecurringOrder":True/False,
RecurringOrderOffsetDays":####,
AgencyActivityId":####,
SchedulePickup":"abcABC123",
Ein":"abcABC123",
AccountOpened":"MM-dd-yyyy hh:mm:ss",
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,
DefaultShipToAddressId":####,
DefaultShipToContactId":####,
PreferredPickupDay":####,
MailingAddressId":####,
MailingContactId":####,
BillToAddressId":####,
BillToContactId":####,
IsMobilePantry":True/False,
AgencyInventoryEnabled":True/False,
DeliveriesPerYear":####,
HasCooler":True/False,
HasFreezer":True/False,
IsFoodBankProgram":True/False,
IsSDO":True/False,
IsOpen24":True/False,
HomeDeliveryProvided":True/False,
PostPublicly":True/False,
OverrideStatisticFrequencyGroupId":####,
AltReferenceId1":"abcABC123",
AltReferenceId2":"abcABC123",
FaithBasedProgram":True/False,
ClientProductChoiceId":####,
AgencyStatusId::AgencyStatus.Name":"abcABC123",
AgencyStatusId_FormattedValue":"abcABC123",
AgencyGroupId::AgencyGroup.Name":"abcABC123",
AgencyGroupId_FormattedValue":"abcABC123",
OverrideStatisticFrequencyGroupId::StatisticFrequencyGroup.Name":"abcABC123",
OverrideStatisticFrequencyGroupId_FormattedValue":"abcABC123",
AgencyTypeId::AgencyType.Name":"abcABC123",
AgencyTypeId_FormattedValue":"abcABC123",
AgencySizeId::AgencySize.ReferenceCode":"abcABC123",
AgencySizeId::AgencySize.Name":"abcABC123",
AgencySizeId_FormattedValue":"abcABC123",
AgencyPantrySizeId::AgencyPantrySize.ReferenceCode":"abcABC123",
AgencyPantrySizeId::AgencyPantrySize.Name":"abcABC123",
AgencyPantrySizeId_FormattedValue":"abcABC123",
AgencySiteSizeId::AgencySiteSize.ReferenceCode":"abcABC123",
AgencySiteSizeId::AgencySiteSize.Name":"abcABC123",
AgencySiteSizeId_FormattedValue":"abcABC123",
ServiceFeeId::ServiceFee.ReferenceCode":"abcABC123",
ServiceFeeId::ServiceFee.Name":"abcABC123",
ServiceFeeId_FormattedValue":"abcABC123",
MarkupId::Markup.Name":"abcABC123",
MarkupId_FormattedValue":"abcABC123",
CityId::City.Name":"abcABC123",
CityId_FormattedValue":"abcABC123",
CountyId::County.Name":"abcABC123",
CountyId_FormattedValue":"abcABC123",
FederalDistrictId::FederalDistrict.Name":"abcABC123",
FederalDistrictId_FormattedValue":"abcABC123",
StateSenateDistrictId::StateSenateDistrict.Name":"abcABC123",
StateSenateDistrictId_FormattedValue":"abcABC123",
StateHouseDistrictId::StateHouseDistrict.Name":"abcABC123",
StateHouseDistrictId_FormattedValue":"abcABC123",
CountyCouncilDistrictId::CountyCouncilDistrict.Name":"abcABC123",
CountyCouncilDistrictId_FormattedValue":"abcABC123",
CityCouncilDistrictId::CityCouncilDistrict.Name":"abcABC123",
CityCouncilDistrictId_FormattedValue":"abcABC123",
BranchId::Branch.Name":"abcABC123",
BranchId_FormattedValue":"abcABC123",
ParentAgencyId::Agency.ReferenceCode":"abcABC123",
ParentAgencyId::Agency.Name":"abcABC123",
ParentAgencyId_FormattedValue":"abcABC123",
PaymentTermId::PaymentTerm.ReferenceCode":"abcABC123",
PaymentTermId::PaymentTerm.Name":"abcABC123",
PaymentTermId_FormattedValue":"abcABC123",
DefaultOrderWarehouseId::Warehouse.ReferenceCode":"abcABC123",
DefaultOrderWarehouseId::Warehouse.Name":"abcABC123",
DefaultOrderWarehouseId_FormattedValue":"abcABC123",
DefaultPickupWarehouseId::Warehouse.ReferenceCode":"abcABC123",
DefaultPickupWarehouseId::Warehouse.Name":"abcABC123",
DefaultPickupWarehouseId_FormattedValue":"abcABC123",
DefaultShippingMethodId::ShippingMethod.Name":"abcABC123",
DefaultShippingMethodId_FormattedValue":"abcABC123",
DefaultShipToAddressId::AgencyAddress.Name":"abcABC123",
DefaultShipToAddressId::AgencyAddress.AddressLine1":"abcABC123",
DefaultShipToAddressId::AgencyAddress.AddressLine2":"abcABC123",
DefaultShipToAddressId::AgencyAddress.City":"abcABC123",
DefaultShipToAddressId::AgencyAddress.PostalCode":"abcABC123",
DefaultShipToAddressId_FormattedValue":"abcABC123",
DefaultShipToContactId::AgencyContact.FirstName":"abcABC123",
DefaultShipToContactId::AgencyContact.LastName":"abcABC123",
DefaultShipToContactId_FormattedValue":"abcABC123",
PreferredPickupDay::SystemDayOfWeek.Name":"abcABC123",
PreferredPickupDay_FormattedValue":"abcABC123",
DefaultScheduleLocationId::ScheduleLocation.ReferenceCode":"abcABC123",
DefaultScheduleLocationId::ScheduleLocation.Name":"abcABC123",
DefaultScheduleLocationId_FormattedValue":"abcABC123",
StatisticGroupId::StatisticGroup.Name":"abcABC123",
StatisticGroupId_FormattedValue":"abcABC123",
MainContactId::AgencyContact.Prefix":"abcABC123",
MainContactId::AgencyContact.FirstName":"abcABC123",
MainContactId::AgencyContact.LastName":"abcABC123",
MainContactId::AgencyContact.Suffix":"abcABC123",
MainContactId::AgencyContact.Telephone":"abcABC123",
MainContactId::AgencyContact.EmailAddress":"abcABC123",
MainContactId_FormattedValue":"abcABC123",
MainAddressId::AgencyAddress.Name":"abcABC123",
MainAddressId::AgencyAddress.AddressLine1":"abcABC123",
MainAddressId::AgencyAddress.AddressLine2":"abcABC123",
MainAddressId::AgencyAddress.City":"abcABC123",
MainAddressId::AgencyAddress.PostalCode":"abcABC123",
MainAddressId_FormattedValue":"abcABC123",
BillToContactId::AgencyContact.Prefix":"abcABC123",
BillToContactId::AgencyContact.FirstName":"abcABC123",
BillToContactId::AgencyContact.LastName":"abcABC123",
BillToContactId::AgencyContact.Suffix":"abcABC123",
BillToContactId::AgencyContact.Telephone":"abcABC123",
BillToContactId::AgencyContact.EmailAddress":"abcABC123",
BillToContactId_FormattedValue":"abcABC123",
BillToAddressId::AgencyAddress.Name":"abcABC123",
BillToAddressId::AgencyAddress.AddressLine1":"abcABC123",
BillToAddressId::AgencyAddress.AddressLine2":"abcABC123",
BillToAddressId::AgencyAddress.City":"abcABC123",
BillToAddressId_FormattedValue":"abcABC123",
MailingContactId::AgencyContact.Prefix":"abcABC123",
MailingContactId::AgencyContact.FirstName":"abcABC123",
MailingContactId::AgencyContact.LastName":"abcABC123",
MailingContactId::AgencyContact.Suffix":"abcABC123",
MailingContactId::AgencyContact.Telephone":"abcABC123",
MailingContactId::AgencyContact.EmailAddress":"abcABC123",
MailingContactId_FormattedValue":"abcABC123",
MailingAddressId::AgencyAddress.Name":"abcABC123",
MailingAddressId::AgencyAddress.AddressLine1":"abcABC123",
MailingAddressId::AgencyAddress.AddressLine2":"abcABC123",
MailingAddressId::AgencyAddress.City":"abcABC123",
MailingAddressId_FormattedValue":"abcABC123",
AgencyActivityId::AgencyActivity.Name":"abcABC123",
AgencyActivityId_FormattedValue":"abcABC123",
ClientProductChoiceId::ClientProductChoice.Name":"abcABC123",
ClientProductChoiceId_FormattedValue":"abcABC123"
}