CA_BP_EVT_PC_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.

SELECT CONTRACT_NUM ,BILL_PLAN_ID ,EVENT_OCCURRENCE ,BILL_EVENT_TYPE ,MILESTONE_ORIGIN ,BP_EVENT_STATUS ,AMOUNT ,CA_PERCENTAGE ,BUSINESS_UNIT_PC ,PROJECT_ID ,ACTIVITY_ID ,ACTIVITY_STATUS FROM PS_CA_BP_EVENTS WHERE BILL_EVENT_TYPE = '02' AND MILESTONE_ORIGIN = '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 MILESTONE_ORIGIN Character(1) VARCHAR2(1) NOT NULL Milestone Origin
A=Project
C=Contract

Default Value: C

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 BUSINESS_UNIT_PC Character(5) VARCHAR2(5) NOT NULL PC Business Unit

Prompt Table: BUS_UNIT_PC_VW

10 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField

Prompt Table: CA_PROJ_MS_VW

11 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID

Prompt Table: CA_ACT_MS_VW

12 ACTIVITY_STATUS Character(1) VARCHAR2(1) NOT NULL Activity Status

Prompt Table: PROJ_STATUS_TBL