CONTRACT_NUMPrompt Table: CA_NO_MSTR_VW
ACCT_PLAN_IDCAN=Cancelled
DON=Completed
NEW=Pending
PRG=In Progress
RDY=Ready
RIP=Reversal in Progress
RQD=Action Required
RVS=Reversed
Prompt Table: MEMBER_VW
CA_AP_AI_VW(SQL View) |
Index Back |
|---|
| SELECT 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' AND AP.REV_RECOG_METHOD = '1' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | CONTRACT_NUM |
Character(25) | VARCHAR2(25) NOT NULL |
Contract
Prompt Table: CA_NO_MSTR_VW |
| 2 | ACCT_PLAN_ID |
Character(10) | VARCHAR2(10) NOT NULL | Revenue Recognition Plan |
| 3 | 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 |
| 4 | CONTRACT_ADMIN | Character(40) | VARCHAR2(40) NOT NULL |
Contract Administrator defined on CABU.
Prompt Table: MEMBER_VW |