BUSINESS_UNITPrompt Table: SP_BU_RE_NONVW
LS_NBRPrompt Table: RE_RECV_REFUND
LS_KEYREFUND_KEYRE_REFUND_ADD(SQL View) |
Index Back |
|---|---|
RE_REFUNDSecurity Deposit refunds |
| SELECT B.BUSINESS_UNIT , B.LS_NBR , A.LS_KEY , 9999999999 FROM PS_RE_REFUND A , PS_RE_LS B WHERE A.LS_KEY = B.LS_KEY |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: SP_BU_RE_NONVW |
| 2 | LS_NBR |
Character(10) | VARCHAR2(10) NOT NULL |
Lease Number, User Enterable or Generated Sequence Number
Prompt Table: RE_RECV_REFUND |
| 3 | LS_KEY |
Number(15,0) | DECIMAL(15) NOT NULL | Lease Key, Unique Key |
| 4 | REFUND_KEY |
Number(15,0) | DECIMAL(15) NOT NULL | Refund_id |