VOUCHER_GL_ACCOUNT_STOUT

General ledger voucher overview.

Daily

Director of Accounting Services
Ted Wenum

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 home page.

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

Primary Key Columns are identified with an asterisk(*)

VARCHAR2( N)  (N) = maximum length. Field contains letters and/or numbers. Trailing blanks are eliminated.
Example: VARCHAR2 (5) could contain ‘ABC12’ or  ‘ABC’ or ‘A’

NUMBER (N) (N) = length. Field contains only numbers.
NUMBER (X,Y) =  format for numbers with decimal positions
X = total number of digits Y = the number of digits after the decimal
Examples: NUMBER (6) represents 250012 NUMBER (6,2) represents 2500.12 

DATE  - Date can be in various formats. Date functions available with your query tool can be used to format the date.
Examples:  DATE (YYYYMMDD), DATE (YYDDD), DATE (DD-MM-YY)

CHAR(8)

Voucher Number

CHAR(8)

Purchase Order Number

CHAR(7)

Item Number

CHAR(3)

Voucher GL Line Number

CHAR(15)

GL Account No

CHAR(3)

Fund

CHAR(1)

Activity

CHAR(6)

Department

CHAR(5)

Account Number

NUMBER(6,3)

Voucher GL Account Percent

NUMBER(14,2)

Voucher GL Account Amount

DATE

The date and time these data were extracted.
Format : YYYYMMDD HH24:MI:SS