CA_AP_SRH_VW

(SQL View)
 Index Back

Revenue Plan Search Dialogue

Master contracts are excluded from this view.

SELECT HDR.BUSINESS_UNIT , AP.CONTRACT_NUM , AP.ACCT_PLAN_ID , AP.AP_STATUS , HDR.CONTRACT_ADMIN FROM PS_CA_ACCTPLAN AP , PS_CA_CONTR_HDR HDR WHERE AP.CONTRACT_NUM = HDR.CONTRACT_NUM AND HDR.CONTR_MSTR_FLG <> 'Y'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Default Value: OPR_DEF_TBL_CA.BUSINESS_UNIT

Prompt Table: SP_BU_CA_NONVW

2 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract

Prompt Table: CA_NO_MSTR_VW

3 ACCT_PLAN_ID Character(10) VARCHAR2(10) NOT NULL Revenue Recognition Plan

Default Value: NEXT

4 AP_STATUS Character(3) VARCHAR2(3) NOT NULL Rev Rec Plan Status
CAN=Cancelled
DON=Completed
NEW=Pending
PRG=In Progress
RDY=Ready
RIP=Reversal in Progress
RQD=Action Required
RVS=Reversed
5 CONTRACT_ADMIN Character(40) VARCHAR2(40) NOT NULL Contract Administrator defined on CABU.

Prompt Table: MEMBER_VW