CONTRACT_NUMPrompt Table: CA_CONTR_HDR
BILL_PLAN_IDPrompt Table: CA_BILL_PLAN
01=As Incurred
02=Installment
03=Recurring
04=Milestone
05=Percent Complete
06=Immediate
07=Value Based
Default Value: 01
CA_BPLAN_LNK_VW(SQL View) |
Index Back |
|---|---|
Pending Bill Plans |
| SELECT CONTRACT_NUM , BILL_PLAN_ID , BILL_PLAN_TYPE , DESCR FROM PS_CA_BILL_PLAN WHERE BP_STATUS = 'PND' |
| # | 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 Default Value: 01 |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |