NameDescriptionTypeAdditional Information
LocationID

Agvance location assigned to customer

string

Max length: 6

CustomerGUID

Customer GUID

string

Max length: 36

CustomerID

Customer ID

string

Max length: 6

OldGrowerID

string

Max length: 6

GrowerYN

Grower Status

boolean
FirstName

First Name

string

Max length: 20

LastName

Last Name

string

Max length: 50

AddressLine1

Address line 1

string

Max length: 50

AddressLine2

Address line 2

string

Max length: 50

AddressLine3

Address line 3

string

Max length: 50

Address4

Address line 4

string
City

City

string

Max length: 25

State

State

string

Max length: 2

Zip

Zip Code

string

Max length: 10

PhoneNumber

Phone Number

string

Max length: 15

PhoneNumber2

Phone Number

string

Max length: 15

PESTNUM

Federal permit number

string
Pestexp

Federal permit expiration date

string
NOTES

Notes from customer profile

string
Salesman

Salesperson assigned to customer

string
GROUP

Group from customer profile tab

string
MISC1

boolean
MISC2

boolean
MISC3

boolean
MISC4

boolean
MISC5

boolean
MISC6

boolean
xref1

Cross reference 1

string
xref2

Cross reference 2

string
xref3

Cross reference 3

string
xref4

Cross reference 4

string
PRICEING

Customer pricing level

integer
TempCust

boolean
PreviousID

string
GeoCode

GeoCode accuracy (A=best, C=worst, M=manual)

string
Territory

Territory from customer profile tab

string
County

County

string
Country

Country

string
TaxRate

Sales tax rate

decimal number
OracleID

Oracle ID

string
OracleAddrID

Oracle Bill to/Ship to address

string
EditStatus

string
AddrLat

Address latitude

integer
AddrLon

Address longitude

integer
ACSID

string
Sttaxcode

State tax code

string
Adjtaxcode

Adjustment tax code

string
HealthID

Health ID

string
ProspectYN

Prospect status

boolean
AgrianCustID

Agrian customer ID

string
AgrianStatePermitGrowerId

Agrian state permit grower ID

string
CompanyName1099

Name for 1099

string
GLN

Global location number

string
PrintDollarsPerAcreOnInvoice

Print Dollars Per Acre on Invoice

boolean
Begyear

Beginning year balance

decimal number
Begmth

Beginning month balance

decimal number
curbal

Current balance

decimal number
uacash

Unapplied cash balance

decimal number
begyearpp

Beginning year prepay balance

decimal number
CurbalPP

Current prepay balance

decimal number
Credlim

Credit limit

decimal number
finchrgper

Finance charge %

decimal number
opened

Date credit opened

string
laststatement

Date of last financial statement

string
lastreviewed

Date of last credit review

string
credstatus

Credit status

string
overlimthis

Months over credit limit this year

integer
overlimlast

Months over credit limit last year

decimal number
highbalthis

High end of month balance this year

decimal number
highballast

High end of month balance last year

decimal number
printstatment

Print Statement (True/False)

string
CredNotes

Credit Notes

string
WIP

Work in progress balance

decimal number
OverDueBalance

decimal number
PORequiredYN

Purchase Order Required (yes/no)

boolean
AvailableCredit

Available Credit (calculation)

decimal number
SSNTaxIDNum

Social Security Number/Tax ID (encrypted)

string
CreditActive

Credit line statue

boolean
CreditLineName

Credit line name

string
CreditLineAmt

Credit line amount

decimal number
budget

Budget (energy) balance

decimal number
CreditNeverSend

Never send credit letter

boolean
Type1099

1099 Type

string
Paid1099

Interest on deferred payment contracts

decimal number
BegYearBB

Beginning year budget (energy) balance

decimal number
box3

Totals from other accounting systems

decimal number
box6

Totals from other accounting systems

decimal number
Box31099

Box 3 for PAT1099

decimal number
Box61099

Box 6 for PAT1099

decimal number
AcctNum

Patron ACH account number

string
AcctType

Patron ACH account type

string
ABARouteNum

Patron ACH routing number

string
PrintBBStatement

Print budget billing (energy) statement (yes/no)

string
AchNameOnAccount

Patron ACH name on account at the bank

string
month1

Regular balance end of fiscal month 1

decimal number
month2

Regular balance end of fiscal month 2

decimal number
month3

Regular balance end of fiscal month 3

decimal number
month4

Regular balance end of fiscal month 4

decimal number
month5

Regular balance end of fiscal month 5

decimal number
month6

Regular balance end of fiscal month 6

decimal number
month7

Regular balance end of fiscal month 7

decimal number
month8

Regular balance end of fiscal month 8

decimal number
month9

Regular balance end of fiscal month 9

decimal number
month10

Regular balance end of fiscal month 10

decimal number
month11

Regular balance end of fiscal month 11

decimal number
month12

Regular balance end of fiscal month 12

decimal number
month1pp

Prepay Balance end of fiscal month 1

decimal number
month2pp

Prepay Balance end of fiscal month 2

decimal number
month3pp

Prepay Balance end of fiscal month 3

decimal number
month4pp

Prepay Balance end of fiscal month 4

decimal number
month5pp

Prepay Balance end of fiscal month 5

decimal number
month6pp

Prepay Balance end of fiscal month 6

decimal number
month7pp

Prepay Balance end of fiscal month 7

decimal number
month8pp

Prepay Balance end of fiscal month 8

decimal number
month9pp

Prepay Balance end of fiscal month 9

decimal number
month10pp

Prepay Balance end of fiscal month 10

decimal number
month11pp

Prepay Balance end of fiscal month 11

decimal number
month12pp

Prepay Balance end of fiscal month 12

decimal number
Month1BB

Budget (energy) balance end of fiscal month 1

decimal number
Month2BB

Budget (energy) balance end of fiscal month 2

decimal number
Month3BB

Budget (energy) balance end of fiscal month 3

decimal number
Month4BB

Budget (energy) balance end of fiscal month 4

decimal number
Month5BB

Budget (energy) balance end of fiscal month 5

decimal number
Month6BB

Budget (energy) balance end of fiscal month 6

decimal number
Month7BB

Budget (energy) balance end of fiscal month 7

decimal number
Month8BB

Budget (energy) balance end of fiscal month 8

decimal number
Month9BB

Budget (energy) balance end of fiscal month 9

decimal number
Month10BB

Budget (energy) balance end of fiscal month 10

decimal number
Month11BB

Budget (energy) balance end of fiscal month 11

decimal number
Month12BB

Budget (energy) balance end of fiscal month 12

decimal number
CustPatBDay

Birth Date

string
CustPatActiveMember

Active patron status

boolean
CustPatActiveMemberExists

boolean
CustPatWithHold1099

Backup withhold 1099 status

boolean
CustPatWithhold1099Exists

boolean
CustPatBDayExists

boolean
CustPatCorporation

boolean
ReasonExpDate

Tax exemption expiration date

string
TaxID

Tax exempt ID

string
taxable

Taxable status

boolean
Reason

Tax exempt reason

string
Discount

Default payment term

string
GSTTaxable

Extra Tax 1

boolean
PSTTaxable

Extra Tax 2

boolean
GrainTaxExempt

Grain tax exempt status

boolean
ACHUniqueID

Grain ACH ID

integer
ACHAcctDesc

string
ACHAcctNum

ACH bank account number (encrypted)

string
ACHAcctType

ACH account type

string
ACHABARouteNum

ACH bank routing number

string
GRCustUniqueID

integer
CondoGrowerID

string
MNLeinHolderID

Minnesota leinholder ID

string
LastModifiedUTC

The last modified date of the customer in UTC format

date

Required

LastModifiedExcludingBalancesUTC

The last modified date of the customer (excluding balance changes) in UTC format

date
FederalPermitList

Collection of ClsCustFedPerm
StatePermitList

Collection of ClsPermit
CustDeptPriceDefs

Collection of ClsCustDeptPriceDef
CustJDCAccounts

Collection of ClsCustJdcAccounts
CustContacts

Collection of ClsCustContacts
CustClassifications

Collection of ClsCustClass
ExtraChargesCust

Collection of ClsExtraChargesCustomer
CustAttributes

Collection of ClsCustAttributes
CustRelationship

Collection of ClsCustRelationship
CustDate

Collection of ClsCustDate
CustDetail

Collection of ClsCustDetail
CustNotify

Collection of ClsCustNotify
GRCustGBPool

Collection of ClsGrCustGbPool
CustBankAccounts

Collection of ClsCustBankAccounts