AUC_CNT_USRSTYL

(SQL View)
Index Back

Contract Style View

13-Oct-2015 MB : Contract Style View - A view for CNTRCT_STYLE record which fetches the contract style values for the four process options (GN, AP, PO, BPO).

SELECT A.OPRID ,B.CNTRCT_STYLE_NAME ,B.CNTRCT_STYLE ,B.CNTRCT_STRUCT_CD ,B.DESCR50 ,B.STYLE_STATUS ,B.CNTRCT_PROC_OPT FROM PS_CNTRCT_STYLE B , PS_OPR_DEF_TBL_SS A WHERE ((A.AUC_GENCONTRACT='Y' AND B.CNTRCT_PROC_OPT = 'GN') OR (A.AUC_SINGRELPOCONT='Y' AND B.CNTRCT_PROC_OPT = 'BPO') OR (A.AUC_PO_CONTRACT='Y' AND B.CNTRCT_PROC_OPT = 'PO') OR (A.AUC_REC_VCHRCNTRCT='Y' AND B.CNTRCT_PROC_OPT = 'AP')) AND B.STYLE_STATUS='A'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
2 CNTRCT_STYLE_NAME Character(30) VARCHAR2(30) NOT NULL Style Description
3 CNTRCT_STYLE Character(10) VARCHAR2(10) NOT NULL Contract Style
4 CNTRCT_STRUCT_CD Character(4) VARCHAR2(4) NOT NULL Valid Structures for Contract Styles
ADHD=Ad Hoc Document
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
POD=Purchase Order Document
PPAY=Prepaid Voucher
RPOV=Recurring PO Voucher
SED=Sourcing Event Document
SPP=Special Purpose
5 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50
6 STYLE_STATUS Character(1) VARCHAR2(1) NOT NULL Contract Style Status
A=Active
I=Inactive
7 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