PO_APR_NOT_RQ (SQL Table)	Index Back
PO Approvals Not Required Purchase Order Approvals Not Required table.

PO_APR_NOT_RQ

(SQL Table)

PO Approvals Not Required

Purchase Order Approvals Not Required table.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT

2 PO_PROCESS_ID Character(3) VARCHAR2(3) NOT NULL Shows the process that created the row on the stage table
CON=Contract Releases
CRT=PAR Location Replenishment
OLS=Manual / Expedite Requisitions
OMR=Order Management Referenced
PLL=Planning System
RFQ=Request for Quotation
SFL=Production/Shop Floor
SPO=Services Work Order
SRC=AutoSelect / Quick Source
WKM=Work Order Management

3 APPR_NOT_RQED Character(1) VARCHAR2(1) NOT NULL Approval Not Required
Y/N Table Edit

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
2	PO_PROCESS_ID	Character(3)	VARCHAR2(3) NOT NULL	Shows the process that created the row on the stage table CON=Contract Releases CRT=PAR Location Replenishment OLS=Manual / Expedite Requisitions OMR=Order Management Referenced PLL=Planning System RFQ=Request for Quotation SFL=Production/Shop Floor SPO=Services Work Order SRC=AutoSelect / Quick Source WKM=Work Order Management
3	APPR_NOT_RQED	Character(1)	VARCHAR2(1) NOT NULL	Approval Not Required Y/N Table Edit