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