AR_ITEM_PAYMENT_STOUT

Contains billing detail item information for payments.

Data is replaced every night.

Student Business Services.
Contact: Rick Olson

You must receive approval to access data from the data custodian.

For information about how to get authorized for InfoAccess data views, connect to the InfoAccess web site

Contact:  Division of Information Technology Help Desk
Phone:  264-4357 (HELP)

The codes following the field names in this document define the field.  The different types are:

A - Alphanumeric field.  This indicates the field may contain Letters and/or numbers.  The number following is the field length.  For example: a field defined as A5 could contain 'E10LN'.

N - Numeric data.  This indicates the field may contain only numbers.  The number following is the field length.  If two digits with a decimal point in between are present the first indicates the number of positions before the decimal point and the second the number of digits after the decimal point.  For example: a field defined as N4.2 would be in the format 9999.99 whereas N6 would be in the format 999999.

D - Date field -- this means the field is stored a date.           The format is described in the text description.  The way this type of field will display in the result section of a query will be dependent upon what default the query tool you are using is set to. Some query tools default to a date/time mode which would show the data 1998- 9-03 8:00 or some have a format DD-MMM-(YY)YY.  Most query tools allow you to change this to a format you want but you must be aware of what the default is.

VAR CHAR 2

Key-Payment Item ID

VARCHAR 2

Pointer to AR-Invoice-Payments for payments info

VARCHAR 2

Pointer to AR-Item-Invoice table for invoices

VARCHAR 2

AR code

NUM 8,2

Payment item amount

VARCHAR 10

For future use

DATE 19

Last time record created