CONTRACT_NUMCONTRACT_LINE_NUMEFFDTDefault Value: %date
DST_SEQ_NUMDefault Value: 1
Default Value: CA_DETAIL.CURRENCY_CD
CA_BPSCHDST_VW2(SQL View) |
Index Back |
|---|---|
View for BP Schedule.This view is to generate the UAR lines when Billing Manage Revenue for Immediate Bill Plan. It retrieves the DST lines. |
| SELECT DST.CONTRACT_NUM , DST.CONTRACT_LINE_NUM , DST.EFFDT , DST.DST_SEQ_NUM , DST.AMOUNT , DST.CURRENCY_CD , DST.EFFDT , DET.BILL_PLAN_ID , DET.BPLAN_LN_NBR FROM PS_CA_DETAIL_DST DST , PS_CA_DETAIL DET WHERE DST.CONTRACT_NUM = DET.CONTRACT_NUM AND DST.CONTRACT_LINE_NUM = DET.CONTRACT_LINE_NUM AND DET.REV_RECOG_METHOD = '5' AND DET.CA_LINE_STATUS IN ('A', 'R') AND DET.CHG_STATUS = 'C' AND %EffdtCheck(CA_DETAIL_DST E, DST,%CURRENTDATEIN) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | CONTRACT_NUM |
Character(25) | VARCHAR2(25) NOT NULL | Contract |
| 2 | CONTRACT_LINE_NUM |
Number(3,0) | SMALLINT NOT NULL | Contract Line Num |
| 3 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 4 | DST_SEQ_NUM |
Number(6,0) | INTEGER NOT NULL |
Distribution Sequence
Default Value: 1 |
| 5 | AMOUNT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Amount |
| 6 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Currency Code
Default Value: CA_DETAIL.CURRENCY_CD |
| 7 | EFFDT_USED | Date(10) | DATE | Effective Date |
| 8 | BILL_PLAN_ID | Character(10) | VARCHAR2(10) NOT NULL | Billing Plan ID |
| 9 | BPLAN_LN_NBR | Number(3,0) | SMALLINT NOT NULL | Bill Plan Line Number |