RBT_BILL_EVENT

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	RBTBILLID	Character(15)	VARCHAR2(15) NOT NULL	Bill Id Prompt Table: RBT_BILL Set Control Field: RBTBILLID
2	RBTBILLITEMID	Character(15)	VARCHAR2(15) NOT NULL	Bill Item Id Prompt Table: RBT_BILL_ITEM Set Control Field: RBTBILLITEMID
3	RBTEVENTID	Character(15)	VARCHAR2(15) NOT NULL	Event Id
4	RBTEVENTNO	Number(6,0)	INTEGER NOT NULL	Event Number
5	RBTBILLSYSEVENTID	Character(15)	VARCHAR2(15) NOT NULL	Bill System Event Id
6	RBTUNITYPE	Character(4)	VARCHAR2(4) NOT NULL	Unit Type KW=Kilowatt Demand KWH=Kilowatt per hour MINS=Minutes PNTS=Points
7	RBTBILLEVENTSTAT	Character(4)	VARCHAR2(4) NOT NULL	Bill Event Status DISP=Disputed PAID=Paid PEND=Pending
8	RBTTIMERATECODE	Character(4)	VARCHAR2(4) NOT NULL	Time Rate Code KWH=Kilowatt-hours OFPK=Off Peak PEAK=Peak
9	RBTEVENTNAME	Character(4)	VARCHAR2(4) NOT NULL	Event Name
10	RBTORIGINNO	Character(15)	VARCHAR2(15) NOT NULL	Origin number
11	RBTORIGINPLACE	Character(20)	VARCHAR2(20) NOT NULL	Origin Place
12	RBTDESTNO	Character(15)	VARCHAR2(15) NOT NULL	Destination Number
13	RBTDESTPLACE	Character(20)	VARCHAR2(20) NOT NULL	Destination Place
14	RBTUNITAMT	Number(6,0)	INTEGER NOT NULL	Unit Amount
15	RBTRATE	Number(9,2)	DECIMAL(8,2) NOT NULL	Rate
16	RBTTOTAL	Number(10,2)	DECIMAL(9,2) NOT NULL	Total
17	RBTTAX	Number(9,2)	DECIMAL(8,2) NOT NULL	Tax
18	RBTENDDATETIME	DateTime(26)	TIMESTAMP	End DateTime field
19	RBTSTDATETIME	DateTime(26)	TIMESTAMP	Start Datetime
20	MARKET	Character(3)	VARCHAR2(3) NOT NULL	Market
21	ROW_ADDED_DTTM	DateTime(26)	TIMESTAMP	This is a datetime field for record creation.
22	ROW_ADDED_OPRID	Character(30)	VARCHAR2(30) NOT NULL	ID of user who added the row.
23	ROW_LASTMANT_DTTM	DateTime(26)	TIMESTAMP	The date and time that the row was last updated.
24	ROW_LASTMANT_OPRID	Character(30)	VARCHAR2(30) NOT NULL	ID of user who last modified the row.
25	SYNCID	Number(10,0)	DECIMAL(10) NOT NULL	The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.
26	SYNCDTTM	DateTime(26)	TIMESTAMP	Synchronization Last Update Date Time