CA_BP_EVT_CU_VW (SQL View)	Index Back
Contract Bill Plan Events Record will contain one row for each Billing event that is associated with a Contract Bill Plan.

CA_BP_EVT_CU_VW

(SQL View)

Contract Bill Plan Events

Record will contain one row for each Billing event that is associated with a Contract Bill Plan.

SELECT EVT.CONTRACT_NUM ,EVT.BILL_PLAN_ID ,EVT.EVENT_OCCURRENCE ,EVT.BILL_EVENT_TYPE ,EVT.EVENT_DT ,EVT.BP_EVENT_STATUS ,EVT.AMOUNT ,EVT.CA_PERCENTAGE ,CU.CURRENCY_CD ,CU.DECIMAL_POSITIONS FROM PS_CA_BP_EVENTS EVT , PS_CURRENCY_CD_TBL CU WHERE EVT.CURRENCY_CD = CU.CURRENCY_CD AND %EffdtCheck(CURRENCY_CD_TBL B, CU, %CurrentDateIn) AND CU.EFF_STATUS = 'A'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 BILL_PLAN_ID Character(10) VARCHAR2(10) NOT NULL Billing Plan ID
Prompt Table: CA_BILL_PLAN

3 EVENT_OCCURRENCE Number(3,0) SMALLINT NOT NULL Identifies a user-defined event on a schedule for automatically creating standard and recurring journal entries. Event Occurrence is a number associated with a date for creation of the journal.

4 BILL_EVENT_TYPE Character(2) VARCHAR2(2) NOT NULL Billing Event Types -- Date or Milestone
01=Date
02=Milestone
Default Value: 02

5 EVENT_DT Date(10) DATE The date upon which an accounting event is scheduled to be processed and converted into corresponding accounting

6 BP_EVENT_STATUS Character(3) VARCHAR2(3) NOT NULL Event Status
CAN=Cancelled
DON=Completed
HLD=Hold Event
NEW=New Event
PND=Pending
PRG=In Progress
RCL=Recycled
RDY=Ready
REC=Recycled
RIN=Reversal Initiated
RIP=Reversal In Progress
RRP=Recycled
RVS=Reversed
Default Value: NEW

7 AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount

8 CA_PERCENTAGE Signed Number(13,8) DECIMAL(11,8) NOT NULL Percentage

9 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
Prompt Table: CURRENCY_CD_TBL

10 DECIMAL_POSITIONS Number(2,0) SMALLINT NOT NULL Decimal Positions

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	CONTRACT_NUM	Character(25)	VARCHAR2(25) NOT NULL	Contract
2	BILL_PLAN_ID	Character(10)	VARCHAR2(10) NOT NULL	Billing Plan ID Prompt Table: CA_BILL_PLAN
3	EVENT_OCCURRENCE	Number(3,0)	SMALLINT NOT NULL	Identifies a user-defined event on a schedule for automatically creating standard and recurring journal entries. Event Occurrence is a number associated with a date for creation of the journal.
4	BILL_EVENT_TYPE	Character(2)	VARCHAR2(2) NOT NULL	Billing Event Types -- Date or Milestone 01=Date 02=Milestone Default Value: 02
5	EVENT_DT	Date(10)	DATE	The date upon which an accounting event is scheduled to be processed and converted into corresponding accounting
6	BP_EVENT_STATUS	Character(3)	VARCHAR2(3) NOT NULL	Event Status CAN=Cancelled DON=Completed HLD=Hold Event NEW=New Event PND=Pending PRG=In Progress RCL=Recycled RDY=Ready REC=Recycled RIN=Reversal Initiated RIP=Reversal In Progress RRP=Recycled RVS=Reversed Default Value: NEW
7	AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Amount
8	CA_PERCENTAGE	Signed Number(13,8)	DECIMAL(11,8) NOT NULL	Percentage
9	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Prompt Table: CURRENCY_CD_TBL
10	DECIMAL_POSITIONS	Number(2,0)	SMALLINT NOT NULL	Decimal Positions