CA_PPD_UTL_VW

(SQL View)
 Index Back

Prepaid Utilization Search


SELECT HDR.BUSINESS_UNIT , PPD.CONTRACT_NUM , PPD.CONTRACT_PPD_SEQ , PPD.CA_PPD_STATUS , PPD.HOLD_FLAG , PPD.CA_PPD_UTL_DESCR , PPD.PURCHASED_AMOUNT , PPD.REMAINING_AMOUNT , PPD.COMMITTED_AMT , PPD.CURRENCY_CD , HDR.CONTRACT_ADMIN FROM PS_CA_CONTR_HDR HDR , PS_CA_PREPAID_TBL PPD WHERE HDR.CONTRACT_NUM = PPD.CONTRACT_NUM

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Default Value: OPR_DEF_TBL_CA.BUSINESS_UNIT

Prompt Table: SP_BU_CA_NONVW

2 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract

Prompt Table: CA_CNTR_SRCH_VW

3 CONTRACT_PPD_SEQ Number(5,0) INTEGER NOT NULL Prepaid Add Sequence
4 CA_PPD_STATUS Character(1) VARCHAR2(1) NOT NULL Prepaid Balance Status
A=Ready
C=Completed
I=Inactive
P=Pending
X=Cancelled
5 HOLD_FLAG Character(1) VARCHAR2(1) NOT NULL Hold
N=Hold
Y=Hold
6 CA_PPD_UTL_DESCR Character(30) VARCHAR2(30) NOT NULL Utilization Descr for Billing
7 PURCHASED_AMOUNT Number(27,3) DECIMAL(26,3) NOT NULL Purchased Amount
8 REMAINING_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Remaining Amount
9 COMMITTED_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Committed Assets
10 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
11 CONTRACT_ADMIN Character(40) VARCHAR2(40) NOT NULL Contract Administrator defined on CABU.

Prompt Table: MEMBER_VW