CA_BP_1_AI_VW

(SQL View)
Index Back

Billing Management As Incurred


SELECT DISTINCT BILL_TO_CUST_ID , CONTRACT_NUM FROM PS_CA_BILL_PLAN WHERE BILL_PLAN_TYPE = '01'

# 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