| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 3 |
BUSINESS_UNIT_PO |
Character(5) |
VARCHAR2(5) NOT NULL |
PO Business Unit
|
| 4 |
BUSINESS_UNIT_RECV |
Character(5) |
VARCHAR2(5) NOT NULL |
Receiving Business Unit
|
| 5 |
BUSINESS_UNIT_REQ |
Character(5) |
VARCHAR2(5) NOT NULL |
Requesting Business Unit
|
| 6 |
BUYER_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Buyer
|
| 7 |
COMMENT_ID |
DateTime(26) |
TIMESTAMP |
DtTm Entered
|
| 8 |
DBNAME |
Character(8) |
VARCHAR2(8) NOT NULL |
Database Name
|
| 9 |
ERROR_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Error Flag
|
| 10 |
FROMDATE |
Date(10) |
DATE |
From Date
|
| 11 |
OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 12 |
OPRID_ENTERED_BY |
Character(30) |
VARCHAR2(30) NOT NULL |
Entered By
07/25/2011 MRAD 12383033 :Ensured that OPRID_ENTERED_BY is set with format type of MixedCase.
03/22/2013 GL 16482301: Switched OPRID_ENTERED_BY back to MixedCase again. Please don't change it to UpperCase!!!
FYI - The alternatives to use a User ID as uppercase:
1) Create your own User ID, add comments in the Field Properties, and fill out the Owner ID
2) Use %Upper meta-SQL in SQL statements
3) Use Upper function in peoplecodes
|
| 13 |
ORIGIN |
Character(3) |
VARCHAR2(3) NOT NULL |
Origin
|
| 14 |
ORIGIN_PO |
Character(3) |
VARCHAR2(3) NOT NULL |
Origin
|
| 15 |
ORIGIN_RECV |
Character(3) |
VARCHAR2(3) NOT NULL |
Origin
|
| 16 |
PO_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Purchase Order
|
| 17 |
PO_ID_FROM |
Character(10) |
VARCHAR2(10) NOT NULL |
From/To
|
| 18 |
PO_ID_TO |
Character(10) |
VARCHAR2(10) NOT NULL |
PO_ID in a range
|
| 19 |
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
|
| 20 |
PV_BUYER_ID_PO |
Character(30) |
VARCHAR2(30) NOT NULL |
Buyer Name
|
| 21 |
PV_BUYER_ID_RECV |
Character(30) |
VARCHAR2(30) NOT NULL |
Buyer Name
|
| 22 |
PV_BUYER_ID_REQ |
Character(30) |
VARCHAR2(30) NOT NULL |
Buyer Name
|
| 23 |
PV_DBLINK_NAME |
Character(60) |
VARCHAR2(60) NOT NULL |
Database Link Name
|
| 24 |
PV_DBLINK_PO |
Character(1) |
VARCHAR2(1) NOT NULL |
Link Type
E=FDM
H=HRMS
O=Other
|
| 25 |
PV_DBLINK_RECV |
Character(1) |
VARCHAR2(1) NOT NULL |
Link Type
E=FDM
H=HRMS
O=Other
|
| 26 |
PV_DBLINK_REQ |
Character(1) |
VARCHAR2(1) NOT NULL |
Link Type
E=FDM
H=HRMS
O=Other
|
| 27 |
PV_DBLINK_VCHR |
Character(1) |
VARCHAR2(1) NOT NULL |
Link Type
E=FDM
H=HRMS
O=Other
|
| 28 |
PV_FROMDATE_PO |
Date(10) |
DATE |
From Date
|
| 29 |
PV_FROMDATE_RECV |
Date(10) |
DATE |
From Date
|
| 30 |
PV_FROMDATE_REQ |
Date(10) |
DATE |
From Date
|
| 31 |
PV_ORIGIN_REQ |
Character(3) |
VARCHAR2(3) NOT NULL |
Origin
|
| 32 |
PV_PRCS_TR_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Transaction Type
1 = Purchase Orders
2 = Requisitions
3 = Receipts
1=PO
2=Reqs
3=Receipts
4=Vouchers
|
| 33 |
PV_PO_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Process Purchase Orders?
|
| 34 |
PV_RECV_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Process Receipts?
|
| 35 |
PV_REQ_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Process Requisitions?
|
| 36 |
PV_THRU_DT_PO |
Date(10) |
DATE |
Through Date
|
| 37 |
PV_THRU_DT_RECV |
Date(10) |
DATE |
Through Date
|
| 38 |
PV_THRU_DT_REQ |
Date(10) |
DATE |
Through Date
|
| 39 |
PV_TR_ERP_PO |
Character(1) |
VARCHAR2(1) NOT NULL |
Bring new POs from Backbone
|
| 40 |
PV_TR_ERP_DSP_PO |
Character(1) |
VARCHAR2(1) NOT NULL |
Bring dispatched POs from BB
|
| 41 |
PV_TR_ERP_REQ |
Character(1) |
VARCHAR2(1) NOT NULL |
Update Sourced Reqs from ERP
|
| 42 |
PV_VCHR_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Process Vouchers?
|
| 43 |
PV_VENDOR_ID_PO |
Character(10) |
VARCHAR2(10) NOT NULL |
Vendor Identifier
|
| 44 |
PV_VENDOR_ID_RECV |
Character(10) |
VARCHAR2(10) NOT NULL |
Vendor Identifier
|
| 45 |
PV_VENDOR_ID_REQ |
Character(10) |
VARCHAR2(10) NOT NULL |
Vendor Identifier
|
| 46 |
RANDOM_CMMT_NBR |
Number(4,0) |
SMALLINT NOT NULL |
Random Comments Number
|
| 47 |
RECCOUNT |
Number(5,0) |
INTEGER NOT NULL |
Records Retrieved
|
| 48 |
RECEIVER_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Receiver number
|
| 49 |
PV_RECVR_ID_FROM |
Character(10) |
VARCHAR2(10) NOT NULL |
Receipt Number
|
| 50 |
PV_RECVR_ID_TO |
Character(10) |
VARCHAR2(10) NOT NULL |
Receipt Number
|
| 51 |
RECNAME_SOURCE |
Character(15) |
VARCHAR2(15) NOT NULL |
Source Recname
|
| 52 |
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
|
| 53 |
REQ_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Requisition ID
|
| 54 |
REQ_ID_FROM |
Character(10) |
VARCHAR2(10) NOT NULL |
Requisition ID From
|
| 55 |
REQ_ID_TO |
Character(10) |
VARCHAR2(10) NOT NULL |
Requisition ID To
|
| 56 |
REQ_STATUS |
Character(4) |
VARCHAR2(4) NOT NULL |
Req status
A=Approved
C=Complete
D=Denied
I=Initial
LA=Line Approved
O=Open
P=Pending Approval
V=Preview
X=Canceled
|
| 57 |
RUN_CNTL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
|
| 58 |
SELECT_PARM |
Character(254) |
VARCHAR2(254) NOT NULL |
Dynamic Where Clause Sel Parms
|
| 59 |
SQL_STMT_254 |
Character(254) |
VARCHAR2(254) NOT NULL |
An internal work field that contains SQL text that is to be utilized in treasury application p
|
| 60 |
THRU_DATE |
Date(10) |
DATE |
Through Date
|
| 61 |
VENDOR_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Vendor Identifier
|
| 62 |
RECNAME |
Character(15) |
VARCHAR2(15) NOT NULL |
Record (Table) Name (see PSRECDEFN).
|
| 63 |
FIELDNAME |
Character(18) |
VARCHAR2(18) NOT NULL |
Field Name (see PSDBFIELD).
|
| 64 |
COMMENTS_2000 |
Long Character |
CLOB |
Comment Text
|