CNT_STYPROCL_VW (SQL View)	Index Back
Contract Style To ProcOpt LVW 03/21/2022 SAGAKULK Contract Style To Proc Opt Language VW

CNT_STYPROCL_VW

(SQL View)

Contract Style To ProcOpt LVW

03/21/2022 SAGAKULK Contract Style To Proc Opt Language VW

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

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 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

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

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 CNTRCT_STYLE Character(10) VARCHAR2(10) NOT NULL Style ID

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 ALLOW_ALL_DOCTYPES Character(1) VARCHAR2(1) NOT NULL Contract Style Status

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