| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 2 |
PO_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Purchase Order
|
| 3 |
PO_STATUS |
Character(2) |
VARCHAR2(2) NOT NULL |
PO Status
A=Approved
C=Complete
D=Dispatched
DA=Denied
I=Initial
LD=Line Denied
O=Open
PA=Pending Approval/Approved
PX=Pending Cancel
X=Canceled
|
| 4 |
PO_DT |
Date(10) |
DATE |
Date
|
| 5 |
ACTIVITY_DATE |
Date(10) |
DATE |
Last Activity
|
| 6 |
RECV_REQ |
Character(1) |
VARCHAR2(1) NOT NULL |
Receiving Required
N=Optional
X=Do Not
Y=Required
|
| 7 |
BUYER_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Buyer
|
| 8 |
VENDOR_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Vendor Identifier
|
| 9 |
AVAILABLE_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Prepayment Available Amount
|
| 10 |
MATCH_ACTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Match Action
N=No Match
Y=Standard
|
| 11 |
CHNG_ORD_BATCH |
Number(3,0) |
SMALLINT NOT NULL |
Change Order Number
|
| 12 |
HOLD_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Hold From Further Processing
Y/N Table Edit
Default Value: N
|
| 13 |
BACKORDER_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Back Order Status
1=Not Backordered
2=Backordered
3=Backordered Received
|
| 14 |
BUDGET_HDR_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Budget Checking Header Status
E=Error in Budget Check
I=Document In Processing
N=Not Budget Checked
P=Provisionally Valid
V=Valid
|
| 15 |
BUDGET_HDR_STS_NP |
Character(1) |
VARCHAR2(1) NOT NULL |
Budget Ch'k Hdr Sts NonProrate
E=Error in Budget Check
N=Not Budget Checked
P=Provisionally Valid
V=Valid Budget Check
|
| 16 |
DOC_TOL_HDR_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Document Heade Document Tolerance Status
E=Error
N=Not Checked
R=Reset
V=Valid
Default Value: V
|
| 17 |
RECV_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Receipt Status
C=Closed Receipt
H=Hold Receipt
M=Moved to Destination
N=PO Not Received
O=Open
P=PO Partially Received
R=Fully Received
X=Canceled
|
| 18 |
CC_SECURITY_ID |
Number(10,0) |
DECIMAL(10) NOT NULL |
Procurement Card Number
|
| 19 |
CC_USE_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Procurement Card
Y/N Table Edit
Default Value: N
|