Account_

Type  

char

1 

Required:

'B' - Bad Check

'C' - Campus

'D' - Catalogue Sales

'F' - Financial Aid

'G' - Gift Certificate

'R' - Revolving

'S' - Special Orders

'X' - Store Defined

agency_

number 

char

25 

Required:  account code

agency_

name

char

80

Account Description

address_

1  

char

80

Street Address

address_

2 

char

80 

2^nd Line of Street Address

address_

3  

char 

80

3^rd Line of Street Address

city

char  

40

City for Account Address

state  

char 

4

State for Account Address

postal_

code

char  

20 

Zip/Postal Code for Account Address

country   

char

24 

Country for Account Address

phone_

1 

char 

16

1^st Phone for Account

phone_

2    

char 

16

2^nd Phone for Account

phone_

3   

char 

16

3^rd Phone for Account

tax_exempt_

id  

char 

25

Tax Exempt ID

agency_

comment   

varchar

255

Comment on Account

tender_

code 

char

2 

POS code of Tender linked to Account

discount_

code

char

4 

POS code of Discount linked to Account

agency_

priority 

int

Multi Account Priority number

change_

limit

money

Maximum Amount of change permitted

b_change_

due 

int    

0=No Change due 1=Permit Change Due

b_tax_

exempt

int  

0= taxable; 1=tax exempt        

b_open_

drawer 

int 

0=Do not open Drawer 1=Open Drawer

f_print_

endorse 

int 

0

f_

status   

int

Required: 0=inactive, 1=active   

b_

debit

int  

Required: 0=debit, 1=credit, 2=

Bad Check

f_discount_

type

int

0=Off Retail 1=Above Cost

b_set_credit_limit

int  

0=Do not set limit 1=Set Credit Limit

dcc_

array

varchar

300 

6 Digit permissible DCC’s concatenate the DCC’s together maximum of 50 DCC’s

discount_

array

varchar

150 

6 Digit permissible DCC’s concatenate the DCC’s together

b_

delete

tinyint

1  

Required: “0”= add, “1” =

delete

Account Type

1

REQUIRED FIELD.

'B' - Bad Check

'C' - Campus

'D' - Catalogue Sales

'F' - Financial Aid

'G' - Gift Certificate

'R' - Revolving

'S' - Special Orders

'X' - Store Defined

Account

Code

25

Required FIELD account code.

Account

Name   

30 

Required FIELD Account Description.

Account Address

#1 

30

OPTIONAL FIELD Street Address.

Account Address

#2 

30

OPTIONAL FIELD 2^nd Line of Street Address.

Account Address

#3

30

OPTIONAL FIELD 3^rd Line of Street Address.

Account

City  

15

OPTIONAL FIELD City for Account Address.

Account

State 

3

OPTIONAL FIELD State for Account Address.

Account Zip

Code

10

OPTIONAL FIELD Zip/Postal Code for Account Address.

Account

Country 

10 

OPTIONAL FIELD Country for Account Address.

Account Phone

#1 

15

OPTIONAL FIELD 1^st Phone for Account.

Account Phone

#2

15

OPTIONAL FIELD 2^nd Phone for Account.

Account Phone

#3   

15

OPTIONAL FIELD 3^rd Phone for Account.

Account Tax

Exempt 

1

OPTIONAL FIELD 0= taxable; 1=tax exempt.

Account

Comment   

60

OPTIONAL FIELD Comment on Account.

Account Tender

Code 

2

OPTIONAL FIELD POS code of Tender linked to Account.

Change Due

Flag

1

OPTIONAL FIELD 0=No Change due 1=Permit Change Due.

Change

Limit 

8

OPTIONAL FIELD Maximum Amount of change permitted.

Open Cash

Drawer  

1

OPTIONAL FIELD 0=Do not open Drawer 1=Open Drawer.

Printer

Endorse

1

OPTIONAL FIELD.  This field indicates to the

POS system which tender endorsement to use:

0 = None

1 = Check

2 = Gift Certificate

3 = Travelers Check

4 = Credit Memo

7 = Full Sheet

9 = Half Sheet

Allowable DCC 6*

50 

300 

OPTIONAL FIELD 6 Digit permissible DCC’s concatenate the DCC’s together maximum of 50 DCC’s

Discount % by DCC 3*50

150

OPTIONAL FIELD.  This is a list of up to 50

discount percentages to automatically apply

to the corresponding DCC's.  These are stored

with no decimal point. (xx.y = xxy).

Add/Delete

Flag 

1 

REQUIRED FIELD.  'A' for ADD, 'D' for DELETE.

Account

Status 

1

REQUIRED FILED 0=inactive, 1=active.

Discount

Code  

3 

OPTIONAL FIELD.  This is the numeric discount

code to use on the POS system for discounted

DCC sales.

Account Federal

ID

10 

OPTIONAL FIELD.  This is the federal tax id

to be used if the account is tax exempt.

Debit or

Credit 

1

'D'ebit, 'C'redit, or 'B'ad check

Discount

type 

1

'0' = off retail, '1' = above cost

Credit

Limit

1 

'1' = Set account limit  '0' = Unlimited

Priority

3

Numeric Multi-Account Priority Level

0 = do not select. Otherwise select in order

of lowest to highest.

Line

Feed  

1

OPTIONAL FIELD.  Use for record separators.