CNT_CHG_REC_VW

(SQL View)
 Index Back

Contract ChangeTmplt Record VW

10/01/07 SK F-AHAYT-S60K7

SELECT RECNAME , RECDESCR FROM PSRECDEFN WHERE RECNAME IN ('CNTRCT_HDR','CNTRCT_LINE','CNTRCT_LINE_UOM','CNTRCT_DSTPO_VW','CNTRCT_DSTAP_VW', 'CNTRCT_ADJ_SET', 'CNTRCT_ADJ_RULE', 'CNTRCT_ADJ_DTL','CNTRCT_CAT_EXC','CNTRCT_CATEGORY','CNTRCT_DEFAULTS', 'CNTRCT_DFLT_DIS','CS_CNT_AG_VW','CS_CNT_AG_LN_VW','CS_CNT_AG_CATVW', 'CS_CNT_AG_VFYVW','CS_CNT_AG_VFLVW' ,'CS_CNT_AG_VFCVW', 'CS_CNT_AG_WF_VW' ,'CS_CNT_AG_WFLVW' ,'CS_CNT_AG_WFCVW', 'CS_CNT_AGHTXEVW' ,'CS_CNT_AGLTXEVW' ,'CS_CNT_AGCTXEVW', 'CS_CNT_AG_CLSVW','CS_CNT_AG_CLNVW','CS_CNT_AG_CLCVW','CNTRCT_NTFYUSER', 'CNTRCT_RELTN', 'CNT_RELTNLOC_VW','CNT_CTRL_BU_VW','CNT_CTRL_DOM_VW','CNT_CTRL_SHP_VW','CNTRCT_MFG_DST','MFG_DST_MARKUP')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
2 DESCR Character(30) VARCHAR2(30) NOT NULL Description