CNT_ID_MFG_VW

(SQL View)
Index Back

Contract ID Prompt View

Contract ID Prompt View using by View CNT By PO 08/08/2018 JINGTLI PO002 MFG/DST contracts

SELECT DISTINCT SETID , CNTRCT_ID ,CNTRCT_STYLE ,CNTRCT_PROC_OPT FROM PS_CNTRCT_HDR WHERE CNTRCT_PROC_OPT NOT IN ('DST','SPP','GRPM','GRPS')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
2 CNTRCT_ID Character(25) VARCHAR2(25) NOT NULL Buying Agreement ID
3 CNTRCT_STYLE Character(10) VARCHAR2(10) NOT NULL Contract Style
4 CNTRCT_PROC_OPTN Character(4) VARCHAR2(4) NOT NULL Contract Process Option
AP=Recurring Voucher
BPO=Release to Single PO Only
GN=General Contract
MFG=Manufacturer
PADV=Prepaid Voucher w/ Advance PO
PO=Purchase Order
PPAY=Prepaid Voucher
RPOV=Recurring PO Voucher