CS_CT_ACT_VOUCP (SQL View)	Index Back
Contract Activity - Voucher Voucher Contract Activity for Remote Nodes

CS_CT_ACT_VOUCP

(SQL View)

Contract Activity - Voucher

Voucher Contract Activity for Remote Nodes

SELECT A.CNTRCT_SETID , A.CNTRCT_ID , A.CNTRCT_LINE_NBR , MAX(A.CS_CNTRCT_ID_PR) , MAX(A.VENDOR_SETID) , MAX(A.VENDOR_ID) , MAX(A.PRCR_DOC_TYPE) , MAX(A.CURRENCY_CD) , SUM(A.MERCHANDISE_AMT) , MAX(A.CNTRCT_PROC_OPT) , MAX(A.CNTRCT_STATUS) , SUM(A.MERCH_AMT_CNTRCT) , SUM(A.AMT_LINE_RELEASED) FROM %Table(CS_CT_ACT_VOUUP) A GROUP BY A.CNTRCT_SETID , A.CNTRCT_ID , A.CNTRCT_LINE_NBR

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 CNTRCT_SETID Character(5) VARCHAR2(5) NOT NULL SetID

2 CNTRCT_ID Character(25) VARCHAR2(25) NOT NULL Buying Agreement ID

3 CNTRCT_LINE_NBR Number(5,0) INTEGER NOT NULL Buying Agreement Line Nbr

4 CS_CNTRCT_ID_PR Character(30) VARCHAR2(30) NOT NULL Parent Contract ID

5 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID

6 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier

7 PRCR_DOC_TYPE Character(3) VARCHAR2(3) NOT NULL Document Type
CNT=Contract
IUR=Inter Unit Receipt
MSR=MSR
PMT=Payment
PO=Purchase Order
RCV=Receipt
REQ=Requisition
RFQ=Request For Quote
RTV=Return To Vendor (Supplier)
SSE=Strategic Sourcing Event
VOU=Voucher
WO=Work Order

8 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

9 MERCHANDISE_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Merchandise Amt F_KDHIL_R87H8 062804 MLM: Added new Line Amount Received Label

10 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

11 CNTRCT_STATUS Character(1) VARCHAR2(1) NOT NULL Contract Status
A=Approved
C=Closed
H=On-Hold
O=Open
P=Pre-Approved
X=Canceled

12 MERCH_AMT_CNTRCT Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount In Contract Currency

13 AMT_LINE_RELEASED Signed Number(28,3) DECIMAL(26,3) NOT NULL Total Line Amt Released

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	CNTRCT_SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
2	CNTRCT_ID	Character(25)	VARCHAR2(25) NOT NULL	Buying Agreement ID
3	CNTRCT_LINE_NBR	Number(5,0)	INTEGER NOT NULL	Buying Agreement Line Nbr
4	CS_CNTRCT_ID_PR	Character(30)	VARCHAR2(30) NOT NULL	Parent Contract ID
5	VENDOR_SETID	Character(5)	VARCHAR2(5) NOT NULL	Vendor SetID
6	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier
7	PRCR_DOC_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Document Type CNT=Contract IUR=Inter Unit Receipt MSR=MSR PMT=Payment PO=Purchase Order RCV=Receipt REQ=Requisition RFQ=Request For Quote RTV=Return To Vendor (Supplier) SSE=Strategic Sourcing Event VOU=Voucher WO=Work Order
8	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
9	MERCHANDISE_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Merchandise Amt F_KDHIL_R87H8 062804 MLM: Added new Line Amount Received Label
10	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
11	CNTRCT_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Contract Status A=Approved C=Closed H=On-Hold O=Open P=Pre-Approved X=Canceled
12	MERCH_AMT_CNTRCT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Amount In Contract Currency
13	AMT_LINE_RELEASED	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Total Line Amt Released