PO_COAPR_NOT_RQ (SQL Table)	Index Back
PO Change Order Approvals Not PO Change Order Approvals Not Required table.

PO_COAPR_NOT_RQ

(SQL Table)

PO Change Order Approvals Not

PO Change 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 CHNG_SOURCE Character(3) VARCHAR2(3) NOT NULL Change Source
BPA=Contract Release to Single PO
CAP=Contract Batch Auto Approval
CRT=PAR Replenish/Close Backorders
CST=Close Short Purchase Orders
DRP=Order Management Referenced
EDX=PO Acknowledgments
EMC=Req. Requester Mass Change
EPO=eProcurement Change Request
EPR=User Change Request
IMC=Inventory Mass Change
ONL=On-line Purchase Order
PLN=Planning System
PMC=PO Buyer Mass Change
POC=PO Change Batch Process
PRD=Production/Shop Floor

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	CHNG_SOURCE	Character(3)	VARCHAR2(3) NOT NULL	Change Source BPA=Contract Release to Single PO CAP=Contract Batch Auto Approval CRT=PAR Replenish/Close Backorders CST=Close Short Purchase Orders DRP=Order Management Referenced EDX=PO Acknowledgments EMC=Req. Requester Mass Change EPO=eProcurement Change Request EPR=User Change Request IMC=Inventory Mass Change ONL=On-line Purchase Order PLN=Planning System PMC=PO Buyer Mass Change POC=PO Change Batch Process PRD=Production/Shop Floor
3	APPR_NOT_RQED	Character(1)	VARCHAR2(1) NOT NULL	Approval Not Required Y/N Table Edit