CNTRCT_LN_MFG

(SQL View)
 Index Back

Contract Line View

PO002 Manufacturer Contract. Contract Line view for manufacturer contract.

SELECT A.SETID , A.CNTRCT_ID , A.VERSION_NBR , B.CNTRCT_LINE_NBR , A.SETID_MFG , A.MFG_ID , A.CNTRCT_BEGIN_DT , A.CNTRCT_TYPE , A.CNTRCT_CORP_FLG , B.INV_ITEM_ID , B.DESCR254_MIXED , B.CATEGORY_ID , B.CNTR_LN_TYPE_ID FROM PS_CNTRCT_HDR A , PS_CNTRCT_LINE B WHERE A.SETID = B.SETID AND A.CNTRCT_ID = B.CNTRCT_ID AND A.VERSION_NBR = B.VERSION_NBR AND A.CNTRCT_STATUS = 'A' AND A.VERSION_STATUS = 'C' AND A.CNTRCT_AUTO_DFLT = 'Y' AND A.CNTRCT_TYPE <> 'AP' AND B.AMT_ONLY_FLG = 'N' AND B.CATEGORY_ID <> ' ' AND B.UNIT_OF_MEASURE <> ' ' AND B.DESCR254_MIXED <> ' ' AND B.LINE_STATUS = 'O'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

Default Value: OPR_DEF_TBL_FS.SETID

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

Default Value: NEXT

3 VERSION_NBR Number(5,0) INTEGER NOT NULL Contract Version number
4 CNTRCT_LINE_NBR Number(5,0) INTEGER NOT NULL Buying Agreement Line Nbr
5 SETID_MFG Character(5) VARCHAR2(5) NOT NULL Used in IT_LOAD_PROC AppEngine
6 MFG_ID Character(50) VARCHAR2(50) NOT NULL Manufacturer ID

Prompt Table: CNT_MFG_VW

7 CNTRCT_BEGIN_DT Date(10) DATE Contract Begin Date
8 CNTRCT_TYPE Character(2) VARCHAR2(2) NOT NULL Contract Type
AP=Recurring Voucher
GN=General Contract
MS=Master Contract
PO=Purchase Order
9 CNTRCT_CORP_FLG Character(1) VARCHAR2(1) NOT NULL Corporate Contract Flag
N=No
Y=Yes
10 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
11 DESCR254_MIXED Character(254) VARCHAR2(254) NOT NULL Description
12 CATEGORY_ID Character(5) VARCHAR2(5) NOT NULL Category ID
13 CNTR_LN_TYPE_ID Character(30) VARCHAR2(30) NOT NULL Contract Line Type ID