|
InfoAccess |
|
|---|---|
|
DATA VIEW NAME |
PURCHASE_ORDER_ITEM_STOUT |
|
OVERVIEW |
This view contains information on Information for each Purchase Order |
|
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 |
|---|---|---|
|
FISCAL_YEAR |
CHAR 4 |
Fiscal year Transaction occurred in |
|
PO_NO |
CHAR 8 |
Purchase Order number |
|
PO_ITEM_NO |
CHAR 7 |
Number of each line item |
|
PO_ITEM_STATUS |
CHAR 12 |
Status description for each P.O. Item |
|
PO_ITEM_STATUS_DATE |
CHAR 19 |
Date on line item for any activity |
|
PO_ITEM_PRICE |
NUM 14,4 |
Price per unit |
|
PO_ITEM_ACCEPTED_PRICE |
NUM 14,4 |
Accepted price per unit |
|
PO_ITEM_QUANTITY |
NUM 10,3 |
Quantity of units |
|
PO_ITEM_ACCEPTED_QTY |
NUM 10,3 |
Quantity of units accepted |
|
PO_ITEM_UNIT |
CHAR 10 |
Unit description |
|
PO_ITEM_DISCOUNT_AMT |
NUM 14,2 |
Amount after discount |
|
PO_ITEM_DISCOUNT_PCT |
NUM 5,3 |
Percent of discount |
|
PO_ITEM_TOTAL |
NUM 14,2 |
Total after discount |
|
PO_ITEM_FIXED_ASSET_CODE |
CHAR 1 |
Single or multiple units |
|
PO_ITEM_EXPECTED_DATE |
DATE |
Delivery date |
|
PO_ITEM_LINE_COMMENTS |
CHAR 200 |
On-Line comments relative to item ordered |
|
PO_ITEM_COMMODITY_CODE |
CHAR 15 |
Commodity Code assigned to item |
|
EXTRACT_DATE_TIME |
DATE |
The date and time
these data were extracted. |