CA_WC_BILLPLNVW(SQL View) |
Index Back |
|---|---|
Billing Plan DetailsTo be used in Contracts Fluid WorkCenter Exception pages. |
| SELECT HDR.BUSINESS_UNIT , BP.CONTRACT_NUM , BILL_PLAN_ID , BP.DESCR , BILL_PLAN_TYPE , BP_STATUS , BP.BILL_TO_CUST_ID , CUST.NAME1 , BILLING_SPECIALIST , COALESCE(( SELECT NAME1 FROM PS_BI_SPECIALST_VW SP , PS_SET_CNTRL_GROUP GRP1 WHERE GRP1.SETCNTRLVALUE = BP.BUSINESS_UNIT_BI AND GRP1.REC_GROUP_ID = 'BI_03' AND SP.SETID = GRP1.SETID AND SP.BILLING_SPECIALIST = BP.BILLING_SPECIALIST),BILLING_SPECIALIST) AS BILLING_SPECIALIST_NAME , BILLING_AUTHORITY , BILL_CYCLE_ID , COALESCE(( SELECT BC.DESCR FROM PS_BI_CYCLE BC WHERE BC.BILL_CYCLE_ID = BP.BILL_CYCLE_ID),BP.BILL_CYCLE_ID) AS BILL_CYCLE_ID_DESCR , HOLD_FLAG , HOLD_DATE FROM PS_CA_BILL_PLAN BP , PS_CA_CONTR_HDR HDR , PS_CUSTOMER CUST , PS_SET_CNTRL_GROUP GRP WHERE BP.CONTRACT_NUM = HDR.CONTRACT_NUM AND HDR.BILL_TO_CUST_ID = CUST.CUST_ID AND HDR.BUSINESS_UNIT = GRP.SETCNTRLVALUE AND GRP.REC_GROUP_ID = 'FS_23' AND GRP.SETID = CUST.SETID AND (EXISTS( SELECT 'X' FROM PS_CA_DETAIL DTL WHERE DTL.CONTRACT_NUM = BP.CONTRACT_NUM AND DTL.BILL_PLAN_ID = BP.BILL_PLAN_ID) OR EXISTS( SELECT 'X' FROM PS_CA_PREPAID_TBL PPD WHERE PPD.CONTRACT_NUM = BP.CONTRACT_NUM AND PPD.BILL_PLAN_ID = BP.BILL_PLAN_ID)) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 |  CONTRACT_NUM |
Character(25) | VARCHAR2(25) NOT NULL | Contract |
| 3 | BILL_PLAN_ID |
Character(10) | VARCHAR2(10) NOT NULL | Billing Plan ID |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 5 | 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 |
| 6 | 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 |
| 7 | BILL_TO_CUST_ID | Character(15) | VARCHAR2(15) NOT NULL | Customer |
| 8 | NAME1 | Character(40) | VARCHAR2(40) NOT NULL | Name 1 |
| 9 | BILLING_SPECIALIST | Character(8) | VARCHAR2(8) NOT NULL | Billing Specialist |
| 10 | BI_SPECIALST_NM | Character(40) | VARCHAR2(40) NOT NULL | Billing Specialist Name |
| 11 | BILLING_AUTHORITY | Character(8) | VARCHAR2(8) NOT NULL | Billing Authority |
| 12 | BILL_CYCLE_ID | Character(10) | VARCHAR2(10) NOT NULL |
Billing Cycle Identifier
Prompt Table:
BI_CYCLE
|
| 13 | BILL_CYCLE_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Billing Cycle |
| 14 | CA_HOLD_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Hold Status
N=Not on Hold Y=On Hold |
| 15 | HOLD_DATE | Date(10) | DATE | Put On Hold Date |