CA_ACCTPLAN_VW

(SQL View)
 Index Back

Revenue Plans


SELECT HDR.BUSINESS_UNIT , AP.CONTRACT_NUM , AP.ACCT_PLAN_ID , AP.DESCR , AP.REV_RECOG_METHOD , AP.AP_STATUS , HOLD_FLAG , HOLD_DATE FROM PS_CA_ACCTPLAN AP , PS_CA_CONTR_HDR HDR WHERE AP.CONTRACT_NUM = HDR.CONTRACT_NUM AND EXISTS ( SELECT 'X' FROM PS_CA_DETAIL DTL WHERE DTL.CONTRACT_NUM = AP.CONTRACT_NUM AND DTL.ACCT_PLAN_ID = AP.ACCT_PLAN_ID)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract
3 ACCT_PLAN_ID Character(10) VARCHAR2(10) NOT NULL Revenue Recognition Plan
4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
5 REV_RECOG_METHOD Character(4) VARCHAR2(4) NOT NULL Revenue Recognition Method
1=As Incurred
2=Apportionment
3=Percent Complete
4=Milestone
5=Billing Manages Revenue
6 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
7 HOLD_FLAG Character(1) VARCHAR2(1) NOT NULL Hold
N=Hold
Y=Hold
8 HOLD_DATE Date(10) DATE Put On Hold Date