Help Page Home

ClsCustomer

Name	Description	Type	Additional 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