CA_BP_AMT_TP_VW(SQL View) |
Index Back |
|---|
| SELECT CONTRACT_NUM , BILL_PLAN_ID , BILL_PLAN_TYPE , DESCR , BP_STATUS FROM PS_CA_BILL_PLAN WHERE BILL_PLAN_TYPE <> '01' AND BP_STATUS = 'NEW' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  CONTRACT_NUM |
Character(25) | VARCHAR2(25) NOT NULL |
Contract
Prompt Table: CA_CONTR_HDR |
| 2 | BILL_PLAN_ID |
Character(10) | VARCHAR2(10) NOT NULL |
Billing Plan ID
Prompt Table: CA_BILL_PLAN |
| 3 | BILL_PLAN_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
Billing Method
01=As Incurred 02=Installment 03=Recurring 04=Milestone 05=Percent Complete 06=Immediate 07=Value Based |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 5 | BP_STATUS | Character(3) | VARCHAR2(3) NOT NULL |
Billing Plan Status
CAN=Cancelled DON=Completed PND=Pending PRG=In Progress RCL=Recycled RDY=Ready RIP=Reversal In Progress RQD=Action Required RRP=Recycled RVS=Reversed |