agency_

number

char   

25 

25  

Account Code

agency_

name

char 

80

80

Account Description

address_

1  

char

80

80

Street Address

address_

2

char

80

80

2nd Line of Street Address

address_

3

char

80

80

3rd Line of Street Address

city 

char 

40

40

City for Account Address

state

char 

4

4

State for Account Address

country

char 

24

24

Country for Account Address

postal_

code

char 

20

20

Zip/Postal Code for Account Address

phone_

1 

char 

16

16

1st Phone for Account

phone_

2  

char 

16

16

2nd Phone for Account

phone_

3 

char 

16

16

3rd Phone for Account

agency_

comment 

varchar

255

255

Comment on Account

tax_exempt_

id 

char 

25 

25 

Tax Exempt ID

agency_

priority  

int 

4 

10

0 

Multi Account Priority number

tender_

code

char

2

2

POS code of Tender linked to Account

discount_

code 

char  

4 

4 

POS code of Discount linked to Account

change_

limit

money  

8

19

4 

Maximum Amount of change permitted

dcc_

array 

varchar 

300

300

6 Digit permissible DCC’s  concatenated together

discount_

array 

varchar 

150

150

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

b_change_

due

tinyint 

1

3

0

0=No Change due 1=Permit Change Due

b_tax_

exempt 

tinyint 

1  

3

0

0= taxable; 1=tax exempt

b_open_

drawer  

tinyint 

1

3

0

0=Do not open Drawer 1=Open Drawer

b_

delete   

tinyint

1 

3

0  

0= add, 1 = delete

b_

debit 

tinyint  

1

3 

0

0=debit, 1=credit, 2=Bad Check

b_set_credit_

limit 

tinyint

1

3 

0

0=Do not set limit 1=Set Credit Limit

f_print_

endorse 

tinyint

1

3 

0

0

f_agency_

type

tinyint

1

3 

0

B=Bad Check, C=Campus, D=Catalogue Sales, F=Financial Aid, G=Gift Certificate, R=Revolving, S=Special Orders, X=Store Defined

f_agency_

status

tinyint

1

3 

0

0=inactive, 1=active

f_discount_

type 

tinyint

1

3 

0

0=Off Retail 1=Above Cost

agency_

id 

int 

4 

10

0

AgencyID from Acct_Agency

tm_

stamp 

timestamp

8  

8  

SQL timestamp

 f_Agency_

Type

char 

1

'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

Account Code

agency_

name

char 

80

Account Description    

address_

1

char

80 

Street Address   

address_2 

char 

80

2nd Line of Street Address  

address_

3

char  

80

3rd Line of Street

Address   

city 

char

40 

City for Account Address     

state

char

4 

State for Account

Address     

country

char

24

Country for Account Address     

postal_

code  

char  

20 

Zip/Postal Code for Account Address  

phone_

1 

char 

16

1st Phone for Account 

phone_

2

char  

16

2nd Phone for

Account  

phone_

3     

char  

16

3rd Phone for Account 

b_tax_

exempt  

int

1

0=taxable; 1=tax exempt

agency_

comment 

varchar

255 

Comment on

Account     

tender_

code  

char 

2

POS code of Tender linked to Account  

b_change_

due 

int 

1

0=No Change due 1=Permit Change Due

change_

limit  

money  

8 

Maximum Amount of change permitted

b_open_

drawer

int 

1

0=Do not open Drawer 1=Open Drawer

f_print_

endorse 

int 

1

0=No Endorse, 8=Prism POS Half

Sheet   

dcc_

array 

varchar

300

6 Digit permissible DCC’s  concatenated

together    

discount_

array

varchar

150

6 Digit permissible DCC’s  concatenated together      

b_

delete 

tinyint  

1 

0= add, 1 = delete

f_

status

int

1

0=inactive, 1=active

discount_

code

char  

4

POS code of Discount linked to

Account   

tax_exempt_

id  

char

25 

Tax Exempt

ID  

b_

debit  

int 

1

0=debit, 1=credit, 2=Bad Check

f_discount_

type  

int 

1

0=Off Retail 1=Above

Cost   

b_set_credit_

limit 

int 

1

0=Do not set limit 1=Set Credit Limit

agency_

priority 

int 

1

Multi Account Priority number

Account Type 

1 

Includes the following account types:

'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  

Account Code.

Account

Name  

30

Account Name.

Account Address

#1

30

Account Address Line 1.

Account Address

#2 

30 

Account Address Line 2.

Account Address

#3

30

Account Address Line 3.

Account

City  

15  

Account Code.

Account

State  

3 

Account State.

Account

Country 

10

Account Country.

Account Zip

Code  

10 

Account Zip Code.

Account Phone

#1  

15 

Account Phone #1.

Account Phone

#2

15

Account Phone #2.

Account Phone

#3 

15

Account Phone #3.

Account Tax

Exempt  

1

This is a 0/1 flag that indicates to the POS

system that this account is tax exempt.

Account Comment 

60  

Comment.

Account Tender

Code

2

This is the numeric tender code used in the POS system.

Change

Limit 

1

This is a 0/1 flag that indicates to the POS system

if change is allowed.

Change

Limit 

8 

This is a numeric field that indicates to the POS

system the amount of change allowed.

Open Cash

Drawer

1

This is a 0/1 flag that

indicates to the POS system if the cash

drawer should be opened for this tender.

Printer

Endorse

1

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

This is a list of up to 50

allowable DCC's for this account.

Discount % by DCC 3*50

150

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

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

Account

Status 

1

This is a 0/1 flag used to

indicate 0=Inactive or 1=Active

Discount

Code 

3 

This is the numeric discount code to use on the

POS system for discounted DCC sales.

Account Federal

ID

10

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

Used for record separators.

receipt_id 

int

4

10

0 

Index Key

store_id  

int

4

10

0 

POSID of Store

invoice_id

int 

4

10

0

InvoiceID code

customer_acct 

char

25

25

CustomerID

agency_number

char 

25

25

Account Description

receipt_number  

char 

25

25

Receipt Number

cashier 

char

30

30

Cashier Name

receipt_date

datetime 

8

23 

3 

Date of Receipt

receipt_total

money 

8 

19

4

Total Amount of receipt

tax_total 

money 

8

19

4

Total Tax on receipt

tax_exempt_

total

money 

8

19

4 

Tax Exempt amount on receipt

ship_

total 

money 

8 

19 

4

Amount of Shipping on receipt

discount_total 

money 

8

19 

4 

Total Discount amount on receipt

tender_

total 

money

8

19

4

Amount tendered on receipt

status

tinyint 

2

3

0 

89 BUYBACK, 65 CANCELLED, 67 CHECK CASHING, 88 CLOSING (EX), 78 NO SALE, 73 PAY IN, 79 PAY OUT, 0 POST VOID/SUSPENDED, 86 POST VOIDED, 82 REFUND, 83 SALE or EXCHANGE, 66 SUSPENDED

tran_

code

char

2

2

AS Account Sale, SA Sale, RT Refund, AR Account Refund

request_

number 

char

25

25

Requisition Number

tm_

stamp

timestamp

8

8

SQL timestamp

customer_

acct 

char

25

CustomerID

agency_

number 

char 

25 

Account Code

receipt_number

char

25

Receipt Number 

cashier 

char 

30

Cashier Name 

receipt_date

datetime

Date of Receipt      

receipt_

total

money 

Total Amount of receipt 

tax_

total

money  

Total Tax on receipt

tax_exempt_

total  

money  

Tax Exempt amount on receipt

ship_

total 

money

Amount of Shipping on receipt

discount_

total

money

Total Discount amount on receipt

tender_

total    

money   

Amount tendered on receipt

status

int 

2  

89 BUYBACK, 65 CANCELLED, 67 CHECK CASHING, 88 CLOSING (EX), 78 NO SALE, 73 PAY IN, 79 PAY OUT, 0 POST VOID/SUSPENDED, 86 POST VOIDED, 82 REFUND, 83 SALE or EXCHANGE, 66 SUSPENDED

tran_

code 

char

2

AS Account Sale, SA Sale, RT Refund, AR Account Refund, PI PayIn, PO

PayOut   

request_

number   

char 

25

Requisition Number  

store_

id 

int 

POSID of Store