DEPOSIT_KEYPROPERTY_IDPrompt Table: RE_UNLEASE_PPTY
LS_KEYDefault Value: RE_LS_SLS_CTG.LS_KEY
EXPLODE_LEASE(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | DEPOSIT_KEY |
Number(15,0) | DECIMAL(15) NOT NULL | Deposit Id |
| 2 | PROPERTY_ID |
Number(10,0) | DECIMAL(10) NOT NULL |
Property ID
Prompt Table: RE_UNLEASE_PPTY |
| 3 | LS_KEY |
Number(15,0) | DECIMAL(15) NOT NULL |
Lease Key, Unique Key
Default Value: RE_LS_SLS_CTG.LS_KEY |
| 4 | NUM_OLD_VAL | Number(18,0) | DECIMAL(18) NOT NULL | Numeric Old Val |
| 5 | NUM_NEW_VAL | Number(18,0) | DECIMAL(18) NOT NULL | Numeric New Val |
| 6 | LS_NBR | Character(10) | VARCHAR2(10) NOT NULL | Lease Number, User Enterable or Generated Sequence Number |