PO_CMEDIT_PARM

(SQL Table)
Index Back

Change Order Edit Parameters

Parameters used by PO batch change common edit.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
3 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
4 AE_CALLER_ID Character(12) VARCHAR2(12) NOT NULL Application Engine Caller Prog
5 PROCESS_FREQUENCY Character(1) VARCHAR2(1) NOT NULL Process Frequency
A=Always Process
N=Don't Run
O=Process Once

Default Value: N

6 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Prompt Table: SP_BU_PM_NONVW

7 BUSINESS_UNIT_TO Character(5) VARCHAR2(5) NOT NULL 04/10/00 SCC (Internet Architecture): Add label BUSINESS_UNIT

Prompt Table: SP_BU_PM_NONVW

8 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

Prompt Table: CHNG_SOURCE_VW

9 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order

Prompt Table: CHNG_RQST_VW3

10 PO_ID_TO Character(10) VARCHAR2(10) NOT NULL PO_ID in a range

Prompt Table: CHNG_RQST_VW3

11 OVR_BUYER_STS Character(1) VARCHAR2(1) NOT NULL Override Dflt Buyer's PO Sts

Y/N Table Edit

Default Value: N

12 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

Prompt Table: PO_STATUS_VW

13 SELECTION_CRIT_LBL Character(1) VARCHAR2(1) NOT NULL Selection Criteria
14 USE_CURR_UR Character(1) VARCHAR2(1) NOT NULL Use Current UOM Conv Rate

Y/N Table Edit

Default Value: Y

15 SELECT_PARM Character(254) VARCHAR2(254) NOT NULL Dynamic Where Clause Sel Parms