BUSINESS_UNITPrompt Table: SP_BU_RE_NONVW
LS_NBRPrompt Table: RE_REFUND_LS
REFUND_KEYREFUND_DATEPrompt Table:
RE_LESSEE_VW
Set Control Field: BUSINESS_UNIT
1=Pending
2=Processed
3=Cancelled
4=Refunded
5=Pending Process
RE_REFUND_SRCH(SQL View) |
Index Back |
|---|---|
RE_REFUND_SRCHRefund Search View |
| SELECT B.BUSINESS_UNIT , B.LS_NBR , A.REFUND_KEY , A.REFUND_DATE , B.LS_KEY , B.LEASE_NAME ,A.PRINCIPAL_ID , A.REFUND_AMOUNT ,B.CURRENCY_CD ,A.SEC_REFUND_STATUS 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_REFUND_LS |
| 3 | REFUND_KEY |
Number(15,0) | DECIMAL(15) NOT NULL | Refund_id |
| 4 | REFUND_DATE |
Date(10) | DATE | refund_date |
| 5 | LS_KEY | Number(15,0) | DECIMAL(15) NOT NULL | Lease Key, Unique Key |
| 6 | LEASE_NAME | Character(60) | VARCHAR2(60) NOT NULL | Lease Name |
| 7 | CUST_ID | Character(15) | VARCHAR2(15) NOT NULL |
Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.
Prompt Table:
RE_LESSEE_VW
|
| 8 | REFUND_AMOUNT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Refund Amount |
| 9 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 10 | SEC_REFUND_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Security Deposit Refund Status.
1=Pending 2=Processed 3=Cancelled 4=Refunded 5=Pending Process |