CNTRCT_TMPLT (SQL Table)	Index Back
Contract Change Templates Contract Change templates by contract process option

CNTRCT_TMPLT

(SQL Table)

Contract Change Templates

Contract Change templates by contract process option

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
Default Value: CNTRCT_CONTROL.SETID

2 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

3 CHNG_TMPLT_ID Character(10) VARCHAR2(10) NOT NULL Change Template
Prompt Table: CHG_TMPLT_CT_VW
Set Control Field: SETID

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Default Value: CNTRCT_CONTROL.SETID
2	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
3	CHNG_TMPLT_ID	Character(10)	VARCHAR2(10) NOT NULL	Change Template Prompt Table: CHG_TMPLT_CT_VW Set Control Field: SETID