CS_CT_ACTX_H_VW

(SQL View)
 Index Back

Contract Activity Header

Contract Activity Header View 2/20/2008 RMK F-AHAYT-S60K7 Modified view text to get current version from cntrct_hdr (version_status = 'C'); added new column cat_line_nbr

SELECT A.OPRID , A.RUN_CNTL_ID , A.CNTRCT_SETID , A.CNTRCT_ID , A.CNTRCT_LINE_NBR , A.CAT_LINE_NBR , A.PRCR_DOC_TYPE , A.SUBNODE , A.VENDOR_SETID , A.VENDOR_ID , A.CNTRCT_STATUS , A.AMT_CNTRCT_MAX , A.MERCHANDISE_AMT , A.CURRENCY_CD , A.LASTUPDDTTM , B.BUYER_ID FROM %Table(CS_CT_ACTX_T) A , %Table(CNTRCT_HDR) B WHERE %Join(COMMON_KEYS, CS_CT_ACTX_T A, CNTRCT_HDR B) AND B.VERSION_STATUS = 'C'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

Default Value: OPR_DEF_TBL_FS.OPRID

Prompt Table: OPR_DEF_TBL_PM

2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
3 CNTRCT_SETID Character(5) VARCHAR2(5) NOT NULL SetID
4 CNTRCT_ID Character(25) VARCHAR2(25) NOT NULL Buying Agreement ID
5 CNTRCT_LINE_NBR Number(5,0) INTEGER NOT NULL Buying Agreement Line Nbr
6 CAT_LINE_NBR Number(5,0) INTEGER NOT NULL Contract Category Line Number
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 SUBNODE Character(30) VARCHAR2(30) NOT NULL Subscribing Node
9 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
10 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
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 AMT_CNTRCT_MAX Number(27,3) DECIMAL(26,3) NOT NULL Maximum Amount of Contract.
13 MERCHANDISE_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Merchandise Amt F_KDHIL_R87H8 062804 MLM: Added new Line Amount Received Label
14 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
15 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
16 BUYER_ID Character(30) VARCHAR2(30) NOT NULL Buyer

Prompt Table: BUYER_ACTIVE_VW