LS_KEYDEPOSIT_KEYAMND_NBRDefault Value: RE_LSA.AMND_NBR
0=No Modification
1=Add
2=Change
3=Delete
Default Value: 1
Default Value: RE_LS.CURRENCY_CD
Default Value: %DATE
Prompt Table: RE_SCRTY_TYPE
Prompt Table: RE_EXT_PTY_NAME
RE_DEPOSIT_AMND(SQL Table) |
Index Back |
|---|---|
RE_DEPOSIT_AMENDAmendments for Security Deposits |
| # | 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 | DEPOSIT_KEY |
Number(15,0) | DECIMAL(15) NOT NULL | Deposit Id |
| 3 | AMND_NBR |
Number(3,0) | SMALLINT NOT NULL |
Amendment Number
Default Value: RE_LSA.AMND_NBR |
| 4 | UPDATE_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Update Flag
0=No Modification 1=Add 2=Change 3=Delete Default Value: 1 |
| 5 | DEPOSIT_AMOUNT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Deposit Amount |
| 6 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Currency Code
Default Value: RE_LS.CURRENCY_CD |
| 7 | DEPOSIT_DATE | Date(10) | DATE |
Deposit Date
Default Value: %DATE |
| 8 | 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 |
| 9 | SEC_DEPOSIT_TYPE | Character(1) | VARCHAR2(1) NOT NULL | Deposit Type |
| 10 | GUARANTOR_ID | Number(10,0) | DECIMAL(10) NOT NULL |
Guarantor Id
Prompt Table: RE_EXT_PTY_NAME |
| 11 | SEC_DEP_REFERNCE | Character(150) | VARCHAR2(150) NOT NULL | Reference |