| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 2 |
RUN_CNTL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
|
| 3 |
BUSINESS_UNIT_SS |
Character(5) |
VARCHAR2(5) NOT NULL |
Strategic Sourcing BU
Prompt Table:
SP_AUC_BU_NONVW
|
| 4 |
BUSINESS_UNIT_PO |
Character(5) |
VARCHAR2(5) NOT NULL |
PO Business Unit
Prompt Table:
SP_BU_PM_NONVW
|
| 5 |
INV_ITEM_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Item ID
Prompt Table:
PURCH_ITEM_VW
Set Control Field: BUSINESS_UNIT_SS
|
| 6 |
AUC_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Event ID
Prompt Table:
AUC_AWARD_VW
Set Control Field: BUSINESS_UNIT_SS
|
| 7 |
PRCR_DOC_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Document Type
CNT=Contract
IUR=Inter Unit Receipt
MSR=MSR
PMT=Payment
PO=Purchase Order
RCV=Receipt
REQ=Requisition
RFQ=Request For Quote
RTV=Return To Vendor (Supplier)
SSE=Strategic Sourcing Event
VOU=Voucher
WO=Work Order
|
| 8 |
PRCR_DOC_ID |
Character(25) |
VARCHAR2(25) NOT NULL |
Go to this doc's inquiry page
|
| 9 |
VENDOR_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Vendor Identifier
Prompt Table:
VENDOR_VW
Set Control Field: BUSINESS_UNIT_SS
|
| 10 |
AUC_VERSION |
Number(5,0) |
INTEGER NOT NULL |
Event Version
|
| 11 |
AUC_ROUND |
Number(5,0) |
INTEGER NOT NULL |
Event Round
|
| 12 |
BUYER_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Buyer
Prompt Table:
BUYER_ACTIVE_VW
|
| 13 |
FROM_DATE |
Date(10) |
DATE |
From Date
|
| 14 |
TO_DATE |
Date(10) |
DATE |
To Date
|