| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Prompt Table:
OPRID_VW
|
| 2 |
ORIGIN |
Character(3) |
VARCHAR2(3) NOT NULL |
Origin
Default Value: ORIGIN_PO.ORIGIN
Prompt Table:
ORIGIN_PO
|
| 3 |
DEPTID |
Character(10) |
VARCHAR2(10) NOT NULL |
Department
Default Value: ORIGIN_PO.DEPTID
Prompt Table:
DEPT_TBL
|
| 4 |
CNTRCT_ENTRY |
Character(1) |
VARCHAR2(1) NOT NULL |
Enter Contracts
Y/N Table Edit
Default Value: N
|
| 5 |
CNTRCT_APPROVE |
Character(1) |
VARCHAR2(1) NOT NULL |
Change Approve
Y/N Table Edit
Default Value: N
|
| 6 |
CNTRCT_HOLD |
Character(1) |
VARCHAR2(1) NOT NULL |
Hold Contracts
Y/N Table Edit
Default Value: N
|
| 7 |
CNTRCT_CLOSE |
Character(1) |
VARCHAR2(1) NOT NULL |
Close Contracts
Y/N Table Edit
Default Value: N
|
| 8 |
CNTRCT_CANCEL |
Character(1) |
VARCHAR2(1) NOT NULL |
Procurement Contract cancel authorization
Y/N Table Edit
Default Value: N
|
| 9 |
CNTRCT_PO_RLS |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow PO Contract Releases
Y/N Table Edit
Default Value: N
|
| 10 |
CNTRCT_AP_RLS |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow AP Contract Releases
Y/N Table Edit
Default Value: N
|
| 11 |
REQ_SOURCE |
Character(1) |
VARCHAR2(1) NOT NULL |
Requisition Source
Y/N Table Edit
Default Value: N
|
| 12 |
SHIPTO_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Ship To Location
Prompt Table:
SHIPTO_VW
|
| 13 |
LOCATION |
Character(10) |
VARCHAR2(10) NOT NULL |
Location Code
Prompt Table:
LOCATION_TBL
|
| 14 |
CNTRCT_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Contract Status
A=Approved
C=Closed
H=On-Hold
O=Open
P=Pre-Approved
X=Canceled
Default Value: O
|
| 15 |
RFQ_ENTRY |
Character(1) |
VARCHAR2(1) NOT NULL |
Request For Quotes Entry
Y/N Table Edit
Default Value: N
|
| 16 |
RFQ_HOLD |
Character(1) |
VARCHAR2(1) NOT NULL |
Request For Quotes Hold
Y/N Table Edit
Default Value: N
|
| 17 |
RFQ_APPROVE |
Character(1) |
VARCHAR2(1) NOT NULL |
Approve RFQ
Y/N Table Edit
Default Value: N
|
| 18 |
RFQ_CLOSE |
Character(1) |
VARCHAR2(1) NOT NULL |
Request For Quotes Close
Y/N Table Edit
Default Value: N
|
| 19 |
RFQ_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
RFQ Status
A=Approved
C=Closed
H=On Hold
O=Open
X=Canceled
Default Value: O
|
| 20 |
BUSINESS_UNIT_RECV |
Character(5) |
VARCHAR2(5) NOT NULL |
Receiving Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
Prompt Table:
%EDITTABLE
|
| 21 |
EDIT_CHARTFIELDS |
Character(1) |
VARCHAR2(1) NOT NULL |
Edit Chartfields
Y/N Table Edit
Default Value: N
|
| 22 |
PO_ONLY_RECEIVE |
Character(1) |
VARCHAR2(1) NOT NULL |
Only Receive PO's
Y/N Table Edit
Default Value: Y
|
| 23 |
ALL_BUYERS_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Full Authority for All Buyers
Y/N Table Edit
Default Value: N
|
| 24 |
ALL_REQUESTORS_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Full Auth for All Requesters
Y/N Table Edit
Default Value: N
|
| 25 |
PO_APPROVAL_AUTH |
Character(1) |
VARCHAR2(1) NOT NULL |
Purchase Order Approval
Y/N Table Edit
Default Value: N
|
| 26 |
PO_WRK_APPR_AUTH |
Character(1) |
VARCHAR2(1) NOT NULL |
Can Work Approved PO's
Y/N Table Edit
Default Value: N
|
| 27 |
PO_VRBT_SECURITY |
Character(1) |
VARCHAR2(1) NOT NULL |
Rebate Agreement ID Security Control
1-Update
2-View Only
3-Hidden
H=Hidden
U=Update
V=View Only
Default Value: V
|
| 28 |
PO_CLOSE_AUTH |
Character(1) |
VARCHAR2(1) NOT NULL |
Can Cancel Purchase Orders
Y/N Table Edit
Default Value: N
|
| 29 |
PO_REOPEN_AUTH |
Character(1) |
VARCHAR2(1) NOT NULL |
Can Reopen Purchase Order
Y/N Table Edit
Default Value: N
|
| 30 |
NOTIFY_APPRVR_PO |
Character(1) |
VARCHAR2(1) NOT NULL |
Can Send Approval Reminders
Y/N Table Edit
Default Value: N
|
| 31 |
OVRD_PO_FOR_CLOSE |
Character(1) |
VARCHAR2(1) NOT NULL |
Override Non-Qual.PO for Close
Y/N Table Edit
Default Value: N
|
| 32 |
DISPATCH_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Dispatch Flag
Y/N Table Edit
Default Value: Y
|
| 33 |
REQ_APPROVAL_AUTH |
Character(1) |
VARCHAR2(1) NOT NULL |
Requisition Approval
Y/N Table Edit
Default Value: N
|
| 34 |
NOTIFY_APPRVR_REQ |
Character(1) |
VARCHAR2(1) NOT NULL |
Can Send Approval Reminder
Y/N Table Edit
Default Value: N
|
| 35 |
REQ_WRK_APPR_AUTH |
Character(1) |
VARCHAR2(1) NOT NULL |
Change Approved Reqs
Y/N Table Edit
Default Value: N
|
| 36 |
REQ_CLOSE_AUTH |
Character(1) |
VARCHAR2(1) NOT NULL |
Can Cancel Requisitions
Y/N Table Edit
Default Value: N
|
| 37 |
REQ_REOPEN_AUTH |
Character(1) |
VARCHAR2(1) NOT NULL |
Can ReOpen Requisitions
Y/N Table Edit
Default Value: N
|
| 38 |
OVRD_REQ_FOR_CLOSE |
Character(1) |
VARCHAR2(1) NOT NULL |
Override Non-Qual.Req for Clos
Y/N Table Edit
Default Value: N
|
| 39 |
REQUESTOR_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Requestor id
Prompt Table:
REQUESTOR_VW
|
| 40 |
HELP_LEVEL |
Character(1) |
VARCHAR2(1) NOT NULL |
EZ Req Help Level
|
| 41 |
OVERRIDE_SUGG_VNDR |
Character(1) |
VARCHAR2(1) NOT NULL |
Override Suggested Vendor
Y/N Table Edit
Default Value: Y
|
| 42 |
INV_RECEIVER |
Character(1) |
VARCHAR2(1) NOT NULL |
Inventory Receiver
Y/N Table Edit
Default Value: N
|
| 43 |
BLIND_RECEIPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Blind Receipt
Y/N Table Edit
Default Value: N
|
| 44 |
INTFC_RECEIPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Interface Receipt
Y/N Table Edit
Default Value: N
|
| 45 |
DUE_DT_DAYS |
Number(3,0) |
SMALLINT NOT NULL |
Days +/- Today
Default Value: 30
|
| 46 |
RB_QTY_RECVD_OPT |
Number(1,0) |
SMALLINT NOT NULL |
Receipt Qty Options
1=No Order Qty
2=Ordered Qty
3=PO Remaining Qty
Default Value: 2
|
| 47 |
RFQ_VNDR_LIST_AUTH |
Character(1) |
VARCHAR2(1) NOT NULL |
Define Dispatch Suppliers
Y/N Table Edit
Default Value: N
|
| 48 |
PREPAID_AUTH_STAT |
Character(1) |
VARCHAR2(1) NOT NULL |
Prepaid Authorization Status
A=Authorized
N=Not Approved
P=Pending Authorization
Default Value: N
|
| 49 |
DELETE_PO_ALLOWED |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow PO Deletion
Y/N Table Edit
Default Value: N
|
| 50 |
DELETE_REQ_ALLOWED |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow Requisition Deletion
Y/N Table Edit
Default Value: N
|
| 51 |
DOC_TOL_OVRD_PR |
Character(1) |
VARCHAR2(1) NOT NULL |
Authority to override PO->Requisition Document Tolerance Exceptions
Y/N Table Edit
Default Value: N
|
| 52 |
DOC_TOL_OVRD_VP |
Character(1) |
VARCHAR2(1) NOT NULL |
Authority to override Voucher->PO Document Tolerance Exceptions
Y/N Table Edit
Default Value: N
|
| 53 |
PO_CLOSE_ALL |
Character(1) |
VARCHAR2(1) NOT NULL |
Can Close Purchase Orders
Y/N Table Edit
Default Value: N
|
| 54 |
REQ_CLOSE_ALL |
Character(1) |
VARCHAR2(1) NOT NULL |
Can Close Requisitions
Y/N Table Edit
Default Value: N
|
| 55 |
REQ_ADJ_DTL_AUTH |
Character(1) |
VARCHAR2(1) NOT NULL |
View/Override VAT Details
Y/N Table Edit
Default Value: N
|
| 56 |
OVERRIDE_RFQ_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Override RFQ Required Flag
Y/N Table Edit
Default Value: Y
|
| 57 |
PRIMARY_BUYER |
Character(30) |
VARCHAR2(30) NOT NULL |
Primary Buyer
Prompt Table:
BUYER_ACTIVE_VW
|
| 58 |
VRBT_STATUS |
Character(2) |
VARCHAR2(2) NOT NULL |
Vendor Rebate Status
A=Approved
C=Closed
H=Hold
O=Open
X=Cancelled
Default Value: O
|
| 59 |
VRBT_APPROVE_AUTH |
Character(1) |
VARCHAR2(1) NOT NULL |
Authority to Approve Vendor Rebate
Y/N Table Edit
Default Value: N
|
| 60 |
VRBT_CANCEL_AUTH |
Character(1) |
VARCHAR2(1) NOT NULL |
Authority to Cancel Vendor Rebate
Y/N Table Edit
Default Value: N
|
| 61 |
VRBT_CLOSE_AUTH |
Character(1) |
VARCHAR2(1) NOT NULL |
Authority to Close Vendor Rebate
Y/N Table Edit
Default Value: N
|
| 62 |
VRBT_ENTRY_AUTH |
Character(1) |
VARCHAR2(1) NOT NULL |
Authority to Add/Update Vendor Rebates
Y/N Table Edit
Default Value: N
|
| 63 |
VRBT_ONHOLD_AUTH |
Character(1) |
VARCHAR2(1) NOT NULL |
Authority to put a Vendor Rebate On Hold
Y/N Table Edit
Default Value: N
|
| 64 |
VRBT_UNRESTRICT_FL |
Character(1) |
VARCHAR2(1) NOT NULL |
Unrestricted Rebate Manager
Y/N Table Edit
Default Value: N
|
| 65 |
CHG_NONPO_RECV_PRC |
Character(1) |
VARCHAR2(1) NOT NULL |
F-KDHIL-R87H8 052004 MLM New field to detemine whether price changes can be made on non-PO receipts for receiving related enhancements.
Y/N Table Edit
Default Value: N
|
| 66 |
OVRRD_NONQLF_RCPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Receiver Workbench Override Non Qualified Receipt for Close
Y/N Table Edit
Default Value: N
|
| 67 |
SUBCONTRACT_COMP |
Character(1) |
VARCHAR2(1) NOT NULL |
Production Complete indicator for streamline processing
Y/N Table Edit
Default Value: Y
|
| 68 |
RUN_CLOSE_SHORT |
Character(1) |
VARCHAR2(1) NOT NULL |
Run Close Short - used as checkbox on Receipt
Y/N Table Edit
Default Value: N
|
| 69 |
RTV_INV_ADJ_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
RTV INV Destroy Option
1=Manual
2=Express
9=Default to Business Unit
Default Value: 9
|
| 70 |
RTV_INV_SHIP_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
RTV Inv Ship Option
1=Manual
2=Express
3=Fulfillment
9=Default to Business Unit
Default Value: 9
|
| 71 |
RTV_DISPATCH_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
RTV Dispatch Option
1=Manual
2=Dispatch When Shipped
3=Dispatched
9=Default to Business Unit
Default Value: 9
|
| 72 |
CNT_DSP_HDR |
Character(1) |
VARCHAR2(1) NOT NULL |
Header Information
0=Open
1=Collapsed
Default Value: 0
|
| 73 |
CNT_DSP_COPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Open Item
0=Open
1=Collapsed
Default Value: 0
|
| 74 |
CNT_DSP_VOPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Invoice Options
0=Open
1=Collapsed
Default Value: 0
|
| 75 |
CNT_DSP_ITM_SRCH |
Character(1) |
VARCHAR2(1) NOT NULL |
Item Search Area
0=Open
1=Collapsed
Default Value: 0
|
| 76 |
CNT_DSP_ITM_LINES |
Character(1) |
VARCHAR2(1) NOT NULL |
Item Lines
0=Open
1=Collapsed
Default Value: 0
|
| 77 |
CNT_DSP_CAT_LINES |
Character(1) |
VARCHAR2(1) NOT NULL |
Category Lines
0=Open
1=Collapsed
Default Value: 0
|
| 78 |
CNT_DSP_ADVPO_INF |
Character(1) |
VARCHAR2(1) NOT NULL |
Advanced PO Information
0=Open
1=Collapsed
Default Value: 0
|
| 79 |
CNT_DSP_PO_INFO |
Character(1) |
VARCHAR2(1) NOT NULL |
PO Information
0=Open
1=Collapsed
Default Value: 0
|
| 80 |
CNT_DSP_CNTCTRL |
Character(1) |
VARCHAR2(1) NOT NULL |
Contract Control
0=Open
1=Collapsed
|
| 81 |
CNT_DSP_AMTSUMM |
Character(1) |
VARCHAR2(1) NOT NULL |
Amount Summary
0=Open
1=Collapsed
|
| 82 |
CNTRCT_PROC_OPT |
Character(4) |
VARCHAR2(4) NOT NULL |
Contract Process Option
AP=Recurring Voucher
BPO=Release to Single PO Only
DST=Distributor
GN=General Contract
GRPM=Group Multi Supplier
GRPS=Group Single Supplier
MFG=Manufacturer
PADV=Prepaid Voucher w/ Advance PO
PO=Purchase Order
PPAY=Prepaid Voucher
RPOV=Recurring PO Voucher
SPP=Special Purpose
Default Value: GN
|
| 83 |
CNTRCT_STYLE |
Character(10) |
VARCHAR2(10) NOT NULL |
Contract Style
Prompt Table:
CNT_STYL_ACT_VW
|
| 84 |
SERVER_NAME |
Character(8) |
VARCHAR2(8) NOT NULL |
Server Name
Prompt Table:
SERVERDEFN
|
| 85 |
OUTDESTTYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Process Request output destination type.
0=Any
1=(None)
2=File
3=Printer
4=Window
5=Email
6=Web
7=Default
8=Feed
9=IB Node
|
| 86 |
OUTDESTFORMAT |
Character(3) |
VARCHAR2(3) NOT NULL |
Process Request output format
0=Any
1=(None)
10=Postscript (*.lis)
11=Crystal Report (*.rpt)
12=Rich Text File (*.rtf)
13=SQR Portable Format (*.spf)
14=Text Files (*.txt)
15=Other
16=Default
17=XML Format(*.xml)
18=Data Mover Data File (*.dat)
19=Crystal Report Explorer(*.rpt)
2=Acrobat (*.pdf)
20=XMLP
21=Atom
22=Transformation
23=Printer Command Lang. (*.pcl)
24=PostScript (*.ps)
3=Comma delimited (*.csv)
4=HP Format (*.lis)
5=HTML Documents (*.htm)
6=Line Printer Format (*.lis)
7=Lotus 1-2-3 Files (*.wks)
8=Microsoft Excel Files (*.xls)
9=Microsoft Word (*.doc)
|
| 87 |
OUTDEST |
Character(127) |
VARCHAR2(127) NOT NULL |
Process Scheduler Output Destination
|
| 88 |
GNV_PREPARER_NAME |
Character(100) |
VARCHAR2(100) NOT NULL |
EZ Invoice Preparer Name
|
| 89 |
GNV_PREPARER_EMAIL |
Character(100) |
VARCHAR2(100) NOT NULL |
EZ Invoice Preparer Email
|
| 90 |
GNV_PREPARER_PHONE |
Character(20) |
VARCHAR2(20) NOT NULL |
EZ Invoice Preparer Phone
|