InfoAccess

  

DATA VIEW NAME

AR_INVOICE_PAYMENT_STOUT

OVERVIEW 

Contains billing invoice or payment information. Current and historical data.

LOAD FREQUENCY

Data is updated every night.

DATA CUSTODIAN

Student Business Services.
 Contact: Rick Olson

AUTHORIZATION

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

SPECIAL CONSIDERATIONS

Key fields are identified with an asterisk (*).

QUESTIONS

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

LAST UPDATED

2/2003 Created
9/2008 Custodian Change c4j.

DATA FORMATS

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

CHAR2(N) OR CHAR(N)

Alphanumeric. (N)is the length of the field. Field contains letters and/or numbers. Example: CHAR (5) could contain ‘ABC12’ or ‘12345’ or ‘ABCDEF’ (N) is the length of the field. Field contains letters and/or numbers.

NUM (N)

Numeric Field. (N) is the length of the field. Field contains only numbers. Numbers with decimal points are represented as NUM (X.Y) X=total number of digits Y=the number of decimals after the decimal Examples: NUM (6,2) could contain 2500.12 NUM(6)could contain 000005 or 550000

DATE (XXXX)

Date field. (XXXX)is the format of the field. Date can be in various formats and date functions available based on your query tool can be used against the field. Examples: DATE(YYMMDD);DATE(YYDDD);DATE(DD-MM-YY)

Column Name

Format

Description

 
PERSON_ID  *

CHAR 7

Datatel person ID

AR_TYPE_CODE  *

CHAR 5

Account type (ie.01, 03) code

INVPMT_TERM  *

CHAR 7

Term record for

INVPMT_INVOICE_ID  *

CHAR 9

Invoice ID

INVPMT_PAYMENT_ID  *

CHAR 9

Payment ID

INVPMT_DESC

CHAR 30

Description

INVPMT_DATE

DATE 19

Date

INVPMT_INV_TYPE

CHAR 9

Invoice type

INVPMT_GL_REF_NO1

CHAR 10

GL ID – pointer to AR, GL – account table

INVPMT_GL_REF_NO2

CHAR 10

GL ID – pointer to AR – GL – account table

INVPMT_BILLING_START_DT

DATE 19

Billing start date

INVPMT_BILLING_END_DT

DATE 19

Billing end date

INVPMT_INVOICE_NO

CHAR 9

Billing invoice number

INVPMT_COMMENTS

CHAR 120

Comments

INVPMT_TOTAL_AMT

NUM (8,2)

Total amount of invoice or payment

INVPMT_CASH_RCPT_ID

CHAR 9

Cash receipt ID pointer to AR-Cash receipt table

INVPMT_FA_TRANSMITTAL_ID

CHAR 9

Financial aid transmittal ID

INVPMT_DEPOSIT_ITEM_ID

CHAR 9

Deposit item ID

INVPMT_REFUND_REASON

CHAR 4

Payment refund reason

INVPMT_REG_RATE_TABLE

CHAR 4

Billing registration rate code

INVPMT_FA_AWARD

CHAR 5

Financial aid award code for this payment

LAST_UPDATE_DATE_TIME

DATE 19

Date invoice payment record last updated