ClsCustomerAdd

Agvance location assigned to customer

The Globally Unique Identifier of the customer. If not filled out, the GUID will be automatically generated

The Agvance Customer Identifier, also commonly called Grower ID, this is used to reference the customer throughout Agvance and the API

True if the customer is a grower, False otherwise

The customer's first name, can be blank

The customer's last name. Can also be the company's name if the customer is a business or co-op or other entity

Attention To, Care Of, or company name

Street address or P.O. box

Any other address specifics, Apartment #, Floor, etc.

The city the customer lives in

The state the customer lives in

The zip code for the customer's address

The customer's primary phone number

The customer's alternate phone number

Notes from customer profile

Salesperson assigned to customer

Optional information to help categorize customers

Cross reference 1

Cross reference 2

Cross reference 3

Cross reference 4

The default price level for this customer

True if the customer is a placeholder, false otherwise

Active/Inactive flag. A=Active, I=Inactive

The name of the territory for Canadian customers

The name of the county

The name of the country

The tax rate this customer is to receive if using one other than the location's default rate

Oracle ID

Oracle Bill to/Ship to address

Address latitude

Address longitude

State tax code

Adjustment tax code

The Health Industry Number for animal health customers

Prospect status

If customers are linked between Agrian and Agvance, this is the customer's Agrian ID

Agrian state permit grower ID

If the name to print on the 1099 is different than the customer’s name, enter it in this area

The Global Location Number assigned to the customer, must be 13 digits

Print Dollars Per Acre on Invoice

Beginning year balance

Beginning month balance

Current balance

Unapplied cash balance

Beginning year prepay balance

Current prepay balance

Credit limit

Finance charge %

Date credit opened

Date of last financial statement

Date of last credit review

Credit status, default available options are 'Excellent', 'Fair', 'Good', 'Hold', 'Poor'

Months over credit limit this year, Agvance will automatically set this to zero at year end

Months over credit limit last year, Agvance will automatically set this at year end

High end of month balance this year, this is set automatically when a month ends

High end of month balance last year, this is set automatically when a year ends

Print Statement. Valid options are Y (Yes), N (No), or F (If 30 Days Past Due)

Notes related to this customer's credit

Work in progress balance

Whether or not a Purchase Order is required for this customer

The customer's Available Credit, this amount will be calculated after each transaction

Social Security Number/Tax ID (encrypted)

Whether or not this customer has a credit line

The name of this customer's credit line

The maximum amount of this customer's credit line

This customer's budget (energy) balance

Whether or not to never send a credit letter

1099 type related to this customer. Valid values are: 'None' or 'Interest'

This customer's interest on deferred payment contracts

This customer's beginning year budget (energy) balance

This customer's patronage account number

This customer's patronage ACH account type. Valid type are: 'C' (Checking) or 'S' (Savings)

This customer's patronage ACH routing number

Whether or not to print the budget billing statement (energy). Valid values are: 'Y' or 'N'

Regular balance end of fiscal month 1

Regular balance end of fiscal month 2

Regular balance end of fiscal month 3

Regular balance end of fiscal month 4

Regular balance end of fiscal month 5

Regular balance end of fiscal month 6

Regular balance end of fiscal month 7

Regular balance end of fiscal month 8

Regular balance end of fiscal month 9

Regular balance end of fiscal month 10

Regular balance end of fiscal month 11

Regular balance end of fiscal month 12

Prepay Balance end of fiscal month 1

Prepay Balance end of fiscal month 2

Prepay Balance end of fiscal month 3

Prepay Balance end of fiscal month 4

Prepay Balance end of fiscal month 5

Prepay Balance end of fiscal month 6

Prepay Balance end of fiscal month 7

Prepay Balance end of fiscal month 8

Prepay Balance end of fiscal month 9

Prepay Balance end of fiscal month 10

Prepay Balance end of fiscal month 11

Prepay Balance end of fiscal month 12

Budget (energy) balance end of fiscal month 1

Budget (energy) balance end of fiscal month 2

Budget (energy) balance end of fiscal month 3

Budget (energy) balance end of fiscal month 4

Budget (energy) balance end of fiscal month 5

Budget (energy) balance end of fiscal month 6

Budget (energy) balance end of fiscal month 7

Budget (energy) balance end of fiscal month 8

Budget (energy) balance end of fiscal month 9

Budget (energy) balance end of fiscal month 10

Budget (energy) balance end of fiscal month 11

Budget (energy) balance end of fiscal month 12

Birth date of this customer in MM/dd/yyyy format

Whether or not this customer is an active patron

Whether or not this customer is a corporation

The tax exempt ID related to this customer

Whether or not this customer is sales taxable

The ID of the tax exempt reason for this customer

The ID of the payment terms related to this customer

Whether or not this customer is grain tax exempt

This customer's tax exemption expiration date

ACH bank account number (encrypted)

ACH account type, "C" for checking and "S" for savings.

ACH bank routing number

The customer ID of a condo storage owner that has granted this customer permission to store in his or her condo space

This customer's Minnesota lienholder ID if applicable

Federal permit numbers along with permit expiration date related to this customer

Price level defaults related to this customer based on inventory deparments

JDF Multi-Use Account integration, such as credit plan numbers, descriptive billing codes, terminal numbers, and preferences

Addresses and email information for various people associated with the customer. Authorized Agents for the customer account and relations to the account may also be established here

Classifications this customer belongs to

Extra charges related to this customer

Attributes related to this customer

Family members and work relationships related to this customer

Significant dates and descriptions of those dates. These could be important customer dates such as anniversaries, birthdays, etc.

Types of work the customer is involved in and to what extent

Document specific rules detailing the document type, how they should be sent, and the email address they should be sent to

The list of Agvance customers who are authorized to use this customer's grain bank account

Account types, routing numbers, and account numbers for bank accounts related to this customer