CONTRACT_NUMPrompt Table: CA_CONTR_HDR
BILL_PLAN_IDCONTRACT_LINE_NUMCA_RECR_DTL_VW(SQL View) |
Index Back |
|---|---|
Ca Recurring Billing ViewThis view is to update the CA_DETAIL start/end Date as needed |
| SELECT CONTRACT_NUM ,BILL_PLAN_ID ,CONTRACT_LINE_NUM ,START_DT ,END_DT FROM PS_CA_DETAIL |
| # | 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 |
| 3 | CONTRACT_LINE_NUM |
Number(3,0) | SMALLINT NOT NULL | Contract Line Num |
| 4 | START_DT | Date(10) | DATE | Start Date |
| 5 | END_DT | Date(10) | DATE | End Date |