RE_REFUND

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	LS_KEY	Number(15,0)	DECIMAL(15) NOT NULL	Lease Key, Unique Key
2	REFUND_KEY	Number(15,0)	DECIMAL(15) NOT NULL	Refund_id
3	REFUND_DATE	Date(10)	DATE NOT NULL	refund_date Default Value: %DATE
4	REFUND_AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Refund Amount
5	PROCESSED_AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Processed Amount
6	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Default Value: RE_LS.CURRENCY_CD
7	SEC_REFUND_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Security Deposit Refund Status. 1=Pending 2=Processed 3=Cancelled 4=Refunded 5=Pending Process Default Value: 1
8	PRINCIPAL_ID	Character(15)	VARCHAR2(15) NOT NULL	Landlord/Tenant
9	DST_ALLOC_METHOD	Character(1)	VARCHAR2(1) NOT NULL	Distribution Allocation Method 1=Percentage 2=Amount 3=Area 4=None 5=Quantity Default Value: 4
10	FMS_DTTM_STAMP	DateTime(26)	TIMESTAMP	Specifies the date and time of the original entry.
11	FMS_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Specifies the User ID which made the original entry.
12	FMS_LASTUPDDTTM	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry.
13	FMS_LASTUPDOPRID	Character(30)	VARCHAR2(30) NOT NULL	Specifies the User ID which made the last update to an entry.
14	SUBMIT_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Report Submitted By - Character (30)
15	SUBMIT_DTTM	DateTime(26)	TIMESTAMP	Report Submitted On - DateTime