Details

Name Data Type Is Nullable
Id Integer False
ReferenceCode String False
Name

Enter the name of the agency. If more than one agency has the same name then make each name unique so that each agency can be selected by name as well as by reference number.

String False
AgencyStatusId

This field can be set up for your particular food bank for a unique identifier. It is set up by the food bank administrator.

Integer False
CarrierRoute

Enter the carrier route number that is used to presort large bulk mailings to get a discounted postage rate.

String False
AgencyGroupId

Select a group as an additional way to sort your agencies. For example, an agency can be a food bank, shelter, pantry, etc.

Integer True
AgencyTypeId

This is an additional way to categorize your agencies. These codes are used within several of the Primarius predefined reports, including the Quarterly Poundage Report.This field is created in the system element setup.

Integer True
LocaleServiced

Enter the locale that the agency provides services within. Use this field if the agency's service range is not define by either city or county. This is for information purposes only.

String False
RequireOnSiteProduct

Check if the product that the agency obtains from the food bank will be used when providing services at the agency site, such as a soup kitchen or day care.

Boolean False
RequireOffSiteProduct

Check if the product the agency obtains from the food bank will be used when providing services elsewhere, other than the agency site, such as Meals on Wheels.

Boolean False
AgencySizeId

Select the size of the agency. This is usually determined by the number of people or households the agency serves.

Integer True
AgencyPantrySizeId

Select the size of the agency’s pantry, if applicable. This is usually determined by the number of people or households the agency serves. This is used with the agency limits feature.

Integer True
AgencySiteSizeId

Select the size of the agency’s on site service. This is usually determined by the number of people or households that the agency serves. This can be used when setting agency limits.

Integer True
ServiceFeeId

Select the service fee for this agency. The service codes are set up by the system administrator.

Integer True
MarkupId

Select the markup that applies to the agency. This field cannot be left blank. (Markup is used for product that has a cost).

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

Select the federal district that the agency is located in. This can be the name of your federal representative.

Integer True
StateSenateDistrictId

Select the state district that the agency is located in. This can be the name of your state senator.

Integer True
StateHouseDistrictId

Select the state district that the agency is located in. This can be the name of your state representative.

Integer True
CountyCouncilDistrictId

Select the county district that the agency is located in.

Integer True
CityCouncilDistrictId

Select the city district that the agency is located in.

Integer True
LastPickup

This field is automatically updated each time an order for the agency is confirmed. Displays the last date an order was confirmed.

DateTime True
LastMonitored

Select the last time the agency was monitored. This is used when generating the Agency Monitoring Report to provide a list of those agencies with a Last Monitored date prior to the specified date.

DateTime True
NextMonitored

Select the next time the agency is due to be monitored. This field is required for the Agency Monitored Report. If the check box is cleared then the date is ignored.

DateTime True
NextMonitoredReminderSentDate

Select a date that you would like a reminder to maintain contact with this agency to appear.

DateTime True
LastSiteVisit

Select the last time a visit was made to the agency’s site. If the check box is cleared then the date is ignored.

DateTime True
OrderComments

Enter additional information here. For example, type delivery directions. Comments entered here will appear in the Notes field in Order Entry for all orders you place for this agency only.

String False
BranchId

The branch offered by the agency to the clients.

Integer True
LastOrder

Displays the last time an agency placed an order. This is automatically updated when an order for the agency is placed.

DateTime True
LastPayment

Displays the last time an agency made a payment. This field is automatically updated when a payment is entered.

DateTime True
LastStatistic

This field is automatically updated each time an order for the agency is confirmed. Displays the last statistic an order was confirmed.

DateTime True
ReceivesStatement

Select this box to get an AR statement for this agency when you print them at the end of each month.

Boolean False
CreditLimit

Enter a credit limit to prevent an agency from having an AR balance more than a certain dollar amount. Each agency can be given a different limit. Type 0 for no credit limit.

Decimal False
ApplyLateCharge

Select the box to charge the agency late charge for any overdue balances. When selected the agency will receive a finance charge at the end of each month.

Boolean False
FreeFoodOnly

Check to prevent an agency from ordering product with a charge. This option is used if an agency owes money, however, it can be used for other reasons. This affect Agency Orders.

Boolean False
IsFoodRescueParticipant

Check if this agency can use food from a food rescue program, if not checked the agency cannot order products that are flagged as food rescue. This affects Agency Orders-Products.

Boolean False
ParentAgencyId

Select the agency parent if applicable. The parent agency must be first entered in the Agency Maintenance. A parent agency is used in conjunction with children agencies for reporting purposes.

Integer True
PaymentTermId

Enter in any payment terms that the agency is eligible for.

Integer True
DefaultOrderWarehouseId

Select the warehouse that the agency places their orders at. This is a required field for PWW.

Integer False
DefaultPickupWarehouseId

Select the pickup warehouse that will be used for any of the agency's orders.

Integer True
DefaultShippingMethodId

Select the shipping method to be used for this agency. This is not a required field unless your food bank uses bar coding or if your agency will participate in Agency Retail Mobile.

Integer False
StatisticsRequired

Check to require the agency to enter statistics; use this check box if you do not require all of your member agencies to enter statistics before placing an order.

Boolean False
PreferredPickupTime

Select the time that this agency will pick up their orders or have their order delivered. Click on the hours or minutes to select then use the arrows to the right to set.

DateTime True
DefaultScheduleLocationId Integer True
MonthlyCreditLimit

Enter a credit limit to prevent an agency from ordering more than a certain dollar amount in a month. Each agency can be given a different limit. Default value is 0 for no credit limit.

Decimal False
MonthlyWeightLimit

Enter a weight limit to prevent an agency from ordering more than a certain poundage of product in a month. Each agency can be given a different limit. Default value is 0 for no weight limit.

Decimal False
IsSuspended

Check if the agency is a member of the food bank but you want to inform the order takers of an issue with this account. When you select this check box, you can then type a reason for the suspension as well as a date when the agency was suspended.

Boolean False
SuspendedOn

Displays the date and time the agency was placed on suspension.

DateTime True
SuspensionReason

Enter the reason this agency is to be suspended if the Suspended check box is selected.

String False
IsWarehouse

Check if the agency is also a warehouse. This is used for product allocation (transfers from food bank to to agency).

Boolean False
DefaultToRetailPUD Boolean False
FederalId String False
MaxDeliveriesPerPeriod

Enter the maximum deliveries that an agency can take in a set amount of time.

Integer False
StatisticGroupId

These groups are set by the food bank administrator and can be used for reporting purposes.

Integer False
DefaultToMobilePantryDrop

A check in this box will put a check in the mobile pantry drop on all of the agency's orders. If you do not use this box an individual agency order can still be checked as a mobile pantry drop likewise the check can be removed from a specific order.

Boolean False
MainContactId

Select the name of the primary contact person at the agency.

Integer True
MainAddressId

Select the mailing address for the agency. This is the agency’s primary address. If an agency has multiple addresses they can be added using the = hamburger or by clicking on the +.

Integer True
IsAgencyPickup

Check if the agency is allowed to pick up directly from the donor and this works in conjunction with Donors, the donor must be checked Is Agency Pickup.

Boolean False
IsCashAndCarry

Check if this agency can only shop at the cash and carry.

Boolean False
IsRecurringOrder

Check if this agency is to be part of the recurring order process.

Boolean False
RecurringOrderOffsetDays

Select the number of days from the start date for the recurring orders process. The first day of orders is 0; the second day of orders is 1.

Integer True
AgencyActivityId

This field is another that can be used to group your agencies. An example could be used for your programs/ NAR report such as Faith Based, Boys & Girls Club, etc.

Integer True
SchedulePickup String False
Ein

Enter the federal tax ID# for the agency.

String False
AccountOpened

Enter the date the agency opened an account with the food bank.

DateTime True
CreatedOn DateTime False
CreatedBy Integer False
ModifiedOn DateTime False
ModifiedBy Integer False
InactiveOn DateTime True
InactiveBy Integer True
IsInactive Boolean False
DefaultShipToAddressId

Select the shipping address to be used for orders. If selected, it will populate on the order but can be overridden on an order.

Integer True
DefaultShipToContactId

Select the contact person for the order to be addressed to. This field will populate on the order if set but it can be overridden on an order.

Integer True
PreferredPickupDay

Select the day of week that this agency will pick up their orders or have their order delivered. This can be used with PWW to limit the agency's pickup choice.

Integer True
MailingAddressId

Select the donor's mailing address from the drop-down menu.

Integer True
MailingContactId

Select the contact mailing address from the drop-down menu.

Integer True
BillToAddressId

Select the billing address for the agency from the drop-down menu.

Integer True
BillToContactId

Select the billing contact for the agency from the drop-down menu. .

Integer True
IsMobilePantry

A check in this field will allow a driver to quickly enter an order for the Agency through the Mobile Pantry feature instead of through Agency Orders. This affects Internal Programs-Mobile Pantry AND Agency Orders.

Boolean False
AgencyInventoryEnabled

Enables client services inventory features for this agency

Boolean False
DeliveriesPerYear

Enter the deliveries that an agency can take in a set amount of time.

Integer False
HasCooler

Enables agency to receive refrigerated product

Boolean False
HasFreezer

Enables agency to receive frozen product

Boolean False
IsFoodBankProgram

Check the box to enroll the agency in the food bank program.

Boolean False
IsSDO

Checking the box for 'Secondary Distribution Organization' allows tracking of information or merely reporting data.

Boolean False
IsOpen24

Check the box if the agency is open 24 hours.

Boolean False
HomeDeliveryProvided

Check the box if the agency offers home delivery.

Boolean False
PostPublicly

Check the box to track information or merely data reporting.

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

Alt reference Id 1 is carried over from Classic. It is used for mapping the data.

String False
AltReferenceId2

Alt reference Id 2 is carried over from Classic. It is used for mapping the data.

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"
}