ClsCustomer

Agvance location assigned to customer

Customer GUID

Customer ID

Grower Status

First Name

Last Name

Address line 1

Address line 2

Address line 3

Address line 4

City

State

Zip Code

Phone Number

Phone Number

Federal permit number

Federal permit expiration date

Notes from customer profile

Salesperson assigned to customer

Group from customer profile tab

Cross reference 1

Cross reference 2

Cross reference 3

Cross reference 4

Customer pricing level

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

Territory from customer profile tab

County

Country

Sales tax rate

Oracle ID

Oracle Bill to/Ship to address

Address latitude

Address longitude

State tax code

Adjustment tax code

Health ID

Prospect status

Agrian customer ID

Agrian state permit grower ID

Name for 1099

Global location number

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

Months over credit limit this year

Months over credit limit last year

High end of month balance this year

High end of month balance last year

Print Statement (True/False)

Credit Notes

Work in progress balance

Purchase Order Required (yes/no)

Available Credit (calculation)

Social Security Number/Tax ID (encrypted)

Credit line statue

Credit line name

Credit line amount

Budget (energy) balance

Never send credit letter

1099 Type

Interest on deferred payment contracts

Beginning year budget (energy) balance

Totals from other accounting systems

Totals from other accounting systems

Box 3 for PAT1099

Box 6 for PAT1099

Patron ACH account number

Patron ACH account type

Patron ACH routing number

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

Patron ACH name on account at the bank

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

Active patron status

Backup withhold 1099 status

Tax exemption expiration date

Tax exempt ID

Taxable status

Tax exempt reason

Default payment term

Extra Tax 1

Extra Tax 2

Grain tax exempt status

Grain ACH ID

ACH bank account number (encrypted)

ACH account type

ACH bank routing number

ACH type, e.g., PPD, CCD, or CTX

Minnesota leinholder ID

The last modified date of the customer in UTC format

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