CA_BP_MI_VW

(SQL View)
Index Back

Billing Management Milestone


SELECT BILL_TO_CUST_ID , CONTRACT_NUM , BILL_PLAN_ID FROM PS_CA_BILL_PLAN WHERE BILL_PLAN_TYPE = '04'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BILL_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Customer
2 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract
3 BILL_PLAN_ID Character(10) VARCHAR2(10) NOT NULL Billing Plan ID