CS_CT_ACT_PO1PQ

(SQL View)
 Index Back

Contract Activity - PO

Purchase Order Contract Activity for Parent Node 2/19/2008 RMK F-AHAYT-S60K7 Added cat_line_nbr as key field

SELECT A.CNTRCT_SETID , A.CNTRCT_ID , A.CNTRCT_LINE_NBR , a.CAT_LINE_NBR , A.CS_CNTRCT_ID_PR , A.VENDOR_SETID , A.VENDOR_ID , 'PO' , A.CURRENCY_CD , A.MERCHANDISE_AMT , A.MERCH_AMT_CNTRCT , A.CNTRCT_PROC_OPT , A.CNTRCT_STATUS , B.UNIT_OF_MEASURE , B.QTY_LINE_RELEASED , A.MERCHANDISE_AMT FROM %Table(CS_CT_ACT_PO1P) A , %Table(CNTRCT_LIN_RLVW) B WHERE A.CNTRCT_SETID = B.SETID(+) AND A.CNTRCT_ID = B.CNTRCT_ID (+) AND A.CNTRCT_LINE_NBR = B.CNTRCT_LINE_NBR (+) AND A.VERSION_NBR = B.VERSION_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 CAT_LINE_NBR Number(5,0) INTEGER NOT NULL Contract Category Line Number
5 CS_CNTRCT_ID_PR Character(30) VARCHAR2(30) NOT NULL Parent Contract ID
6 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
7 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
8 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
9 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
10 MERCHANDISE_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Merchandise Amt F_KDHIL_R87H8 062804 MLM: Added new Line Amount Received Label
11 MERCH_AMT_CNTRCT Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount In Contract Currency
12 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
13 CNTRCT_STATUS Character(1) VARCHAR2(1) NOT NULL Contract Status
A=Approved
C=Closed
H=On-Hold
O=Open
P=Pre-Approved
X=Canceled
14 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
15 QTY_LINE_RELEASED Number(15,2) DECIMAL(14,2) NOT NULL Total Line Qty Released
16 AMT_LINE_RELEASED Signed Number(28,3) DECIMAL(26,3) NOT NULL Total Line Amt Released