InfoAccess

  

DATA VIEW NAME

PURCHASE_ORDER_STOUT

OVERVIEW 

This view contains information on Information for each Purchase Order

LOAD FREQUENCY

As changes occur

DATA CUSTODIAN

Purchasing Office
Contact:  Ted Wenum

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

SPECIAL CONSIDERATIONS

  

QUESTIONS

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

LAST UPDATED

Created 06/2002
Custodian Change 9/2008 c4j

DATA FORMATS

Field Formats describe the field type and length.  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 (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

FISCAL_YEAR

CHAR 4

Fiscal year Transaction occurred in

PO_NO

CHAR 8

Purchase Order number

PO_DATE

DATE

Date of Purchase Order

PO_STATUS_CODE

CHAR 1

Datatel generated code for P.O. status

PO_STATUS_DESC   

CHAR 12

Status of Purchase Order

PO_STATUS_DATE

DATE

Date indicated for P.O. activity

PO_VENDOR_NO

CHAR 7

Number assigned to vendor

PO_VENDOR_ALT_FLAG

CHAR 1

  

PO_VENDOR_NAME

CHAR 30

Name of vendor   

PO_VENDOR_ADDRESS1

CHAR 30

First line of vendor address

PO_VENDOR_ADDRESS2

CHAR 30

Second line of vendor address

PO_VENDOR_CITY

CHAR 25

City of vendor address

PO_VENDOR_STATE

CHAR 2

State of vendor address

PO_VENDOR_ZIP

CHAR 10

Zip code of vendor address

PO_VENDOR_COUNTRY

CHAR 20

Country of vendor address

PO_VENDOR_TERMS_CODE     

CHAR 2

Vendor terms code

PO_VENDOR_TERMS_DESC

CHAR 20

Vendor terms

PO_SHIP_TO_CODE

CHAR 2

Codes for campus delivery

PO_ALT_SHIP_NAME

CHAR 30

Alternate campus ship to location name

PO_ALT_SHIP_ADDRESS1

CHAR 30

First line of campus alternate address

PO_ALT_SHIP_ADDRESS2

CHAR 30

Second line of campus alternate address

PO_ALT_SHIP_CITY

CHAR 25

City of campus alternate address

PO_ALT_SHIP_STATE

CHAR 2

State of campus alternate address

PO_ALT_SHIP_ZIP

CHAR 10

Zip of campus alternate address

PO_TYPE_CODE

CHAR 2

Numerical symbol for P. O. classification

PO_TYPE_DESC

CHAR 30

Classification of Purchase Order

PO_TOTAL_AMOUNT

NUM 14,2

Total amount of purchase order

PO_COMMENTS

CHAR 1400

On-Line comments relative to order

PO_PRINTED_COMMENTS

CHAR 2750

Printed comments on purchase order

PO_GENERAL_INFORMATION

CHAR 30

Information regarding price source

PO_BULLETIN_NO   

CHAR 10

Contract number assigned to item

PO_BID_NO

CHAR 10

Bid number assigned to item

PO_PRO-E-4

CHAR 10

Direct charge or item for resale

PO_GOVERNOR_WAIVER

CHAR 10

Waiver of bidding requirement number

PO_PRINTING_NO

CHAR 10

Printing purchase order requirements

PO_TOTAL_VOUCHERED

NUM 14,2

Amount of P. O. paid on voucher

PO_BUYER

CHAR 30

Name of buyer

PO_VENDOR_TYPE

CHAR 25

Vendor classification

PO_INITIATOR     

CHAR 30

Name of initiator

PO_FOB_CODE

CHAR 2

Code for shipping terms

PO_FOB_DESC

CHAR 15

Shipping terms

EXTRACT_DATE_TIME

DATE

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