LS_KEYDefault Value: RE_LS.LS_KEY
DEPOSIT_KEY1=Pending
2=Processed
3=Cancelled
4=Refunded
5=Pending Process
Default Value: RE_LS.CURRENCY_CD
Default Value: %DATE
Prompt Table: RE_SCRTY_TYPE
Prompt Table: RE_EXT_PTY_NAME
RE_DEPOSIT_SUM(SQL View) |
Index Back |
|---|---|
RE_DEPOSIT_SUMSecurity Deposits View for the Lease Abstract Summary. |
| SELECT LS_KEY , DEPOSIT_KEY , SEC_DEPOSIT_STATUS , DEPOSIT_AMOUNT , CURRENCY_CD , DEPOSIT_DATE , SCRTY_CD , SEC_DEPOSIT_TYPE , GUARANTOR_ID , SEC_DEP_REFERNCE FROM PS_RE_DEPOSIT |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | LS_KEY |
Number(15,0) | DECIMAL(15) NOT NULL |
Lease Key, Unique Key
Default Value: RE_LS.LS_KEY |
| 2 | DEPOSIT_KEY |
Number(15,0) | DECIMAL(15) NOT NULL | Deposit Id |
| 3 | SEC_DEPOSIT_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Security Deposit Status.
1=Pending 2=Processed 3=Cancelled 4=Refunded 5=Pending Process |
| 4 | DEPOSIT_AMOUNT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Deposit Amount |
| 5 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Currency Code
Default Value: RE_LS.CURRENCY_CD |
| 6 | DEPOSIT_DATE | Date(10) | DATE |
Deposit Date
Default Value: %DATE |
| 7 | SCRTY_CD | Character(10) | VARCHAR2(10) NOT NULL |
This field holds the Code for the Security Deposit Type to be used by Lease Administration.
Prompt Table: RE_SCRTY_TYPE |
| 8 | SEC_DEPOSIT_TYPE | Character(1) | VARCHAR2(1) NOT NULL | Deposit Type |
| 9 | GUARANTOR_ID | Number(10,0) | DECIMAL(10) NOT NULL |
Guarantor Id
Prompt Table: RE_EXT_PTY_NAME |
| 10 | SEC_DEP_REFERNCE | Character(150) | VARCHAR2(150) NOT NULL | Reference |