RUN_AP_SAM_RSON (SQL Table)	Index Back
Run Reason Codes

RUN_AP_SAM_RSON

(SQL Table)

Run Reason Codes

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
Default Value: RUN_AP_SAM_LOAD.OPRID

2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
Default Value: RUN_AP_SAM_LOAD.RUN_CNTL_ID

3 REQUEST_NBR Number(4,0) SMALLINT NOT NULL Request Number
Default Value: RUN_AP_SAM_LOAD.REQUEST_NBR

4 PYMNT_HOLD_REASON Character(3) VARCHAR2(3) NOT NULL Hold Reason
ACC=Accounting in Dispute
ACV=Federal Supplier Inactive
ALC=Agency Location Code Required
AMT=Amount in Dispute
CCR=CCR Expired
CRT=Contract Retention
EFT=EFT incomplete or not Prenoted
FNS=Financial Sanctions
GDS=Goods in Dispute
GNV=G-Invoicing Hold
IPC=Inbound IPAC Required
OTH=Other
QTY=Quantity in Dispute
SAM=SAM Expired
WTH=Withholding Hold

5 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN). Default Value: RUN_AP_SAM_LOAD.OPRID
2	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID Default Value: RUN_AP_SAM_LOAD.RUN_CNTL_ID
3	REQUEST_NBR	Number(4,0)	SMALLINT NOT NULL	Request Number Default Value: RUN_AP_SAM_LOAD.REQUEST_NBR
4	PYMNT_HOLD_REASON	Character(3)	VARCHAR2(3) NOT NULL	Hold Reason ACC=Accounting in Dispute ACV=Federal Supplier Inactive ALC=Agency Location Code Required AMT=Amount in Dispute CCR=CCR Expired CRT=Contract Retention EFT=EFT incomplete or not Prenoted FNS=Financial Sanctions GDS=Goods in Dispute GNV=G-Invoicing Hold IPC=Inbound IPAC Required OTH=Other QTY=Quantity in Dispute SAM=SAM Expired WTH=Withholding Hold
5	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance