CNT_STYLENM_VW (SQL View)	Index Back
Contract Relationship Table Contract Relationship Table

CNT_STYLENM_VW

(SQL View)

Contract Relationship Table

SELECT CNTRCT_STYLE , CNTRCT_STYLE_NAME , CNTRCT_STRUCT_CD , DESCR50 , STYLE_STATUS , CNTRCT_PROC_OPT , ALLOW_ALL_DOCTYPES FROM PS_CNTRCT_STYLE WHERE CNTRCT_STRUCT_CD NOT IN ('ADHD','GRPM','GRPS','SPP','AP','PPAY','POD','SED')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 CNTRCT_STYLE Character(10) VARCHAR2(10) NOT NULL Contract Style

2 CNTRCT_STYLE_NAME Character(30) VARCHAR2(30) NOT NULL Style Description

3 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

4 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50

5 STYLE_STATUS Character(1) VARCHAR2(1) NOT NULL Contract Style Status
A=Active
I=Inactive

6 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

7 ALLOW_ALL_DOCTYPES Character(1) VARCHAR2(1) NOT NULL Contract Style Status

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