| Name | Description | Type | Additional Information |
|---|---|---|---|
| CustomerID |
Agvance Customer ID (also referred to as Grower ID) |
string |
Max length: 6 |
| CustomerGUID |
Globally Unique Identifier of the Customer - if provided, will be used in place of CustomerID to identify the customer to be updated |
globally unique identifier | |
| FirstName |
First name of the customer |
string |
Max length: 20 |
| LastName |
Last name of the customer |
string |
Max length: 50 |
| Address1 |
Address line 1 |
string |
Max length: 50 |
| Address2 |
Address line 2 |
string |
Max length: 50 |
| Address3 |
Address line 3 |
string |
Max length: 50 |
| City |
City |
string |
Max length: 25 |
| State |
State |
string |
Max length: 2 |
| ZipCode |
Zip Code |
string |
Max length: 10 |
| Phone1 |
Phone Number 1 |
string |
Max length: 15 |
| Phone2 |
Phone Number 2 |
string |
Max length: 15 |
| Notes |
Notes from customer profile |
string | |
| Salesperson |
Salesperson assigned to the customer |
string |
Max length: 15 |
| EmailAddress |
Email address of this contact - FirstName and LastName or the LastName is required to update the email address |
string |
Max length: 50 |
| LocationID |
ID of the location assigned to the customer |
string |
Max length: 6 |
| CrossRef1 |
Cross reference 1 |
string |
Max length: 40 |
| CrossRef2 |
Cross reference 2 |
string |
Max length: 40 |
| CrossRef3 |
Cross reference 3 |
string |
Max length: 40 |
| CrossRef4 |
Cross reference 4 |
string |
Max length: 40 |
| CredLim |
Credit limit |
decimal number | |
| FinChrgPer |
Finance charge % |
decimal number | |
| CredStatus |
Credit status, default available options are 'Excellent', 'Fair', 'Good', 'Hold', 'Poor' |
string |
Max length: 20 |
| DefaultPaymentTerms |
The ID of the payment terms related to this customer |
string |
Max length: 15 |
| GrowerYN |
True if the customer is a grower, False otherwise |
boolean | |
| Active |
Active/Inactive flag. A=Active, I=Inactive |
string |
Max length: 1 |
| County |
The name of the county |
string |
Max length: 60 |
| Country |
The name of the country |
string |
Max length: 60 |
| AddrLat |
Address latitude |
integer |
Range: inclusive between -90000000 and 90000000 |
| AddrLon |
Address longitude |
integer |
Range: inclusive between -180000000 and 180000000 |
| StTaxCode |
State tax code |
string |
Max length: 15 |
| AdjTaxCode |
Adjustment tax code |
string |
Max length: 15 |
| HealthId |
The Health Industry Number for animal health customers |
string |
Max length: 20 |
| AgrianCustId |
If customers are linked between Agrian and Agvance, this is the customer's Agrian ID |
string |
Max length: 60 |
| AgrianStatePermitGrowerId |
Agrian state permit grower ID |
string |
Max length: 20 |
| Gln |
The Global Location Number assigned to the customer, must be 13 digits |
string |
Max length: 13 |
| PrintStatement |
Print Statement. Valid options are Y (Yes), N (No), or F (If 30 Days Past Due) |
string |
Max length: 1 |
| SsnTaxIdNum |
Social Security Number/Tax ID |
string |
Max length: 20 |
| CreditActive |
Whether or not this customer has a credit line |
boolean | |
| AcctNum |
This customer's patronage account number |
string |
Max length: 17 |
| AcctType |
This customer's patronage ACH account type. Valid type are: 'C' (Checking) or 'S' (Savings) |
string |
Max length: 1 |
| AbaRouteNum |
This customer's patronage ACH routing number |
string |
Max length: 9 |
| TaxId |
The tax exempt ID related to this customer |
string |
Max length: 15 |
| Taxable |
Whether or not this customer is sales taxable |
boolean | |
| Reason |
The ID of the tax exempt reason for this customer |
string |
Max length: 50 |
| ReasonExpDate |
This customer's tax exemption expiration date |
string |
Data type: DateTime Format must be MM/dd/yyyy |
| AchAcctNum |
ACH bank account number |
string |
Max length: 17 |
| AchAcctType |
ACH account type, "C" for checking and "S" for savings. |
string |
Max length: 1 |
| AchAbaRouteNum |
ACH bank routing number |
string |
Max length: 9 |
| AchNameOnAccount |
ACH name on account at the bank |
string |
Max length: 100 |
| PrintBbStatement |
Whether or not to print the budget billing statement (energy) |
boolean |
Must be 0, 1, True, or False |
| FederalPermitList |
List of federal permits for the customer |
Collection of ClsCustFedPermEdit | |
| CustomerContactList |
List of customer contacts for the customer |
Collection of ClsCustContactsEdit | |
| CustClassificationsEdit |
Classifications this customer belongs to. IF any values are provided, the customer's existing Classifications will be fully replaced. |
Collection of ClsCustClassEdit | |
| CustAttributesEdit |
Attributes related to this customer |
Collection of ClsCustAttributesEdit | |
| CustBankAccountsEdit |
Account types, routing numbers, and account numbers for bank accounts related to this customer |
Collection of ClsCustBankAccountsEdit | |
| ExtraChargesCust |
Extra Charges related to this customer |
Collection of ClsExtraChargesCustomerAdd | |
| CustNotify |
Document specific rules detailing the document type, how they should be sent, and the email address they should be sent to |
Collection of ClsCustNotifyEdit |