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

UPGCA_BP_EV_TA0

(SQL Table)

Contract Bill Plan Events

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

# 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.
Default Value: 1

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

5 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
Default Value: CA_CONTR_HDR.CURRENCY_CD
Prompt Table: CURRENCY_CD_TBL

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

7 MILESTONE_ORIGIN Character(1) VARCHAR2(1) NOT NULL Milestone Origin
A=Project
C=Contract
Default Value: C

8 EVENT_DT Date(10) DATE The date upon which an accounting event is scheduled to be processed and converted into corresponding accounting
Default Value: %DATE

9 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: PND

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

11 MS_SEQNUM Number(3,0) SMALLINT NOT NULL Milestone Number
Prompt Table: CA_MILESTONE

12 BUSINESS_UNIT_PC Character(5) VARCHAR2(5) NOT NULL PC Business Unit
Prompt Table: BUS_UNIT_PC_VW

13 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField
Prompt Table: CA_PROJ_MS_VW

14 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID
Prompt Table: CA_ACT_MS_VW

15 ACTIVITY_STATUS Character(1) VARCHAR2(1) NOT NULL Activity Status
Prompt Table: PROJ_STATUS_TBL

16 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

17 DAYS_LAG Number(3,0) SMALLINT NOT NULL A number of days lag before an activity/event occurs.

18 TEXT254 Character(254) VARCHAR2(254) NOT NULL Text

19 CA_PER_COMPLETE Number(12,8) DECIMAL(11,8) NOT NULL Percent Complete

20 CA_SOURCE Character(1) VARCHAR2(1) NOT NULL Percent Source
1=Manual
2=Auto

21 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

22 LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

#	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. Default Value: 1
4	AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Amount
5	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Default Value: CA_CONTR_HDR.CURRENCY_CD Prompt Table: CURRENCY_CD_TBL
6	BILL_EVENT_TYPE	Character(2)	VARCHAR2(2) NOT NULL	Billing Event Types -- Date or Milestone 01=Date 02=Milestone Default Value: 01
7	MILESTONE_ORIGIN	Character(1)	VARCHAR2(1) NOT NULL	Milestone Origin A=Project C=Contract Default Value: C
8	EVENT_DT	Date(10)	DATE	The date upon which an accounting event is scheduled to be processed and converted into corresponding accounting Default Value: %DATE
9	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: PND
10	CA_PERCENTAGE	Signed Number(13,8)	DECIMAL(11,8) NOT NULL	Percentage
11	MS_SEQNUM	Number(3,0)	SMALLINT NOT NULL	Milestone Number Prompt Table: CA_MILESTONE
12	BUSINESS_UNIT_PC	Character(5)	VARCHAR2(5) NOT NULL	PC Business Unit Prompt Table: BUS_UNIT_PC_VW
13	PROJECT_ID	Character(15)	VARCHAR2(15) NOT NULL	Project Id ChartField Prompt Table: CA_PROJ_MS_VW
14	ACTIVITY_ID	Character(15)	VARCHAR2(15) NOT NULL	Activity ID Prompt Table: CA_ACT_MS_VW
15	ACTIVITY_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Activity Status Prompt Table: PROJ_STATUS_TBL
16	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
17	DAYS_LAG	Number(3,0)	SMALLINT NOT NULL	A number of days lag before an activity/event occurs.
18	TEXT254	Character(254)	VARCHAR2(254) NOT NULL	Text
19	CA_PER_COMPLETE	Number(12,8)	DECIMAL(11,8) NOT NULL	Percent Complete
20	CA_SOURCE	Character(1)	VARCHAR2(1) NOT NULL	Percent Source 1=Manual 2=Auto
21	LASTUPDDTTM	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
22	LASTUPDOPRID	Character(30)	VARCHAR2(30) NOT NULL	Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.