RBT_BILL_ITEM

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	RBTBILLID	Character(15)	VARCHAR2(15) NOT NULL	Bill Id
2	RBTBILLITEMID	Character(15)	VARCHAR2(15) NOT NULL	Bill Item Id Default Value: NEXT
3	RBTACCTID	Character(15)	VARCHAR2(15) NOT NULL	Unique service account indentifier
4	RBTBILLSYSITEMID	Character(15)	VARCHAR2(15) NOT NULL	Billing System Id
5	RBTARACCTID	Character(15)	VARCHAR2(15) NOT NULL	RBTARACCTID
6	RBTARBILLID	Character(15)	VARCHAR2(15) NOT NULL	rbtarbillid
7	RBTBILLITEMNO	Number(3,0)	SMALLINT NOT NULL	Bill Item Number
8	RBTPRICURRENCY	Character(4)	VARCHAR2(4) NOT NULL	Primary Currency
9	RBTBILLITEMSTATUS	Character(4)	VARCHAR2(4) NOT NULL	Bill item Status DISP=Disputed PAID=Paid PEND=Pending
10	RBTAMTADJ	Number(9,2)	DECIMAL(8,2) NOT NULL	amt adj
11	RBTDISPUTEAMT	Number(9,2)	DECIMAL(8,2) NOT NULL	Dispute Amount
12	RBTTOTALAMTDUE	Number(10,2)	DECIMAL(9,2) NOT NULL	Total Amount Due
13	RBTTOTAMTRECEIVED	Number(9,2)	DECIMAL(8,2) NOT NULL	Total Amount Received
14	RBTAMTTRANSFERRED	Number(9,2)	DECIMAL(8,2) NOT NULL	Amount Transferred
15	RBTDATEOPENED	Date(10)	DATE	Date Opened
16	RBTDATECLOSED	Date(10)	DATE	Date Closed
17	MARKET	Character(3)	VARCHAR2(3) NOT NULL	Market
18	ROW_ADDED_DTTM	DateTime(26)	TIMESTAMP	This is a datetime field for record creation.
19	ROW_ADDED_OPRID	Character(30)	VARCHAR2(30) NOT NULL	ID of user who added the row.
20	ROW_LASTMANT_DTTM	DateTime(26)	TIMESTAMP	The date and time that the row was last updated.
21	ROW_LASTMANT_OPRID	Character(30)	VARCHAR2(30) NOT NULL	ID of user who last modified the row.
22	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.
23	SYNCDTTM	DateTime(26)	TIMESTAMP	Synchronization Last Update Date Time
24	DESCR80	Character(80)	VARCHAR2(80) NOT NULL	This generic field stores the description and used used on various tables.