NameDescriptionTypeAdditional 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