CNT_STYNLACT_VW

(SQL View)
 Index Back

Active Contract Style View

03/21/2022 SAGAKULK Active Contract Style language View

SELECT B.CNTRCT_STYLE_NAME, A.CNTRCT_STRUCT_CD, A.CNTRCT_STYLE, B.DESCR50, A.CNTRCT_PROC_OPT, A.ALLOW_ALL_DOCTYPES FROM PS_CNTRCT_STYLE A, PS_CNTRCT_STL_LNG B WHERE A.STYLE_STATUS = 'A' AND A.CNTRCT_PROC_OPT <> ' ' AND A.CNTRCT_STYLE = B.CNTRCT_STYLE

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 CNTRCT_STYLE_NAME Character(30) VARCHAR2(30) NOT NULL Contract Style
2 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
3 CNTRCT_STYLE Character(10) VARCHAR2(10) NOT NULL Style ID
4 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50
5 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
6 ALLOW_ALL_DOCTYPES Character(1) VARCHAR2(1) NOT NULL Contract Style Status