VOUCHER_ITEM_STOUT

Item detail for vouchers.

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)

Format

Description

CHAR(4)

Fiscal Year

CHAR(8)

Voucher No

CHAR(7)

ITEM No

NUMBER(14,4)

Voucher Item Price

NUMBER(10,3)

Voucher Item Quantity

CHAR(10)

Voucher Item Unit

NUMBER (14,2)

Voucher Item Discount Amount

NUMBER (5,3)

Voucher Item Discount Percent

NUMBER (14,2)

Voucher Item Total

CHAR(10)

Voucher Item Invoice Number

DATE(19)

Voucher Item Invoice Date

CHAR(2000)

Voucher Item Description Line

DATE

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