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