CONTRACT_NUMACCT_PLAN_IDCAN=Cancelled
DON=Completed
NEW=Pending
PRG=In Progress
RDY=Ready
RIP=Reversal in Progress
RQD=Action Required
RVS=Reversed
1=As Incurred
2=Apportionment
3=Percent Complete
4=Milestone
5=Billing Manages Revenue
CA_ACCTPLNID_VW(SQL View) |
Index Back |
|---|
| SELECT DISTINCT CONTRACT_NUM , ACCT_PLAN_ID , DESCR , AP_STATUS , REV_RECOG_METHOD FROM PS_CA_ACCTPLAN WHERE (AP_STATUS = 'NEW' OR AP_STATUS = 'RDY') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | CONTRACT_NUM |
Character(25) | VARCHAR2(25) NOT NULL | Contract |
| 2 | ACCT_PLAN_ID |
Character(10) | VARCHAR2(10) NOT NULL | Revenue Recognition Plan |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 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 | 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 |