|
InfoAccess |
|
|---|---|
|
DATA VIEW NAME |
PO_GL_ACCOUNT_STOUT |
|
OVERVIEW |
This view contains information on funding source of each Purchase Order and Voucher |
|
LOAD FREQUENCY |
As changes occur |
|
DATA CUSTODIAN |
Purchasing Office |
|
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 |
|
LAST UPDATED |
Created 06/2002 |
|
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 |
|---|---|---|
|
PO_NO |
CHAR 8 |
Purchase Order number |
|
VOUCHER_NO |
CHAR 8 |
Voucher number |
|
ITEM_NO |
CHAR 7 |
Line item number |
|
PO_GL_LINE_NO |
CHAR 3 |
Account code charged for each item |
|
GL_ACCOUNT_NO |
CHAR 15 |
General Ledger Account Number of transaction |
|
FUND |
CHAR 3 |
Fund number of transaction |
|
ACTIVITY |
CHAR 1 |
Activity number of transaction |
|
DEPARTMENT |
CHAR 6 |
Department number of transaction |
|
ACCOUNT_NO |
CHAR 5 |
Object code of transaction |
|
PO_GL_ACCT_PCT |
NUM 6,3 |
Percent of transaction charged to General |
|
PO_GL_ACCT_AMT |
NUM 14,2 |
Amount of transaction charged to General Ledger Account Number |
|
EXTRACT_DATE_TIME |
Date |
The date and time
these data were extracted. |