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 |