RE_RECEIVABLE (SQL View)	Index Back
Pending Lease Receivable Record structure for the Pending Lease Receivable Inquiry report.

RE_RECEIVABLE

(SQL View)

Pending Lease Receivable

Record structure for the Pending Lease Receivable Inquiry report.

SELECT A.BUSINESS_UNIT , A.LS_NBR , C.TXN_GRP , A.LS_ADMIN , A.PRTFL_MGR , A.REGION_CD , B.TERM_ID , B.SCHED_DATE , B.AMOUNT , B.CURRENCY_CD ,B.PRINCIPAL_ID , B.SCHED_NUM , B.LS_TRM_SCHD_STATUS ,B.GENERATED_DATE FROM PS_RE_LS A , PS_RE_LS_TRM_SCHED B , PS_RE_LS_TRM C WHERE A.LS_KEY = B.LS_KEY AND A.LS_KEY=C.LS_KEY AND B.TERM_ID=C.TERM_ID AND A.LEASE_OBLG = '2' AND (A.LEASE_STATUS = '2' OR A.LEASE_STATUS = '6')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Default Value: OPR_DEF_TBL_FS.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_LS_NBR

3 TXN_GRP Character(1) VARCHAR2(1) NOT NULL Transaction Group
1=Base Rent
2=Security Deposit
3=Straightline Accounting
4=Operating Expense
5=Percent Rent
6=Miscellaneous Rent
7=Manual Fee
8=Lease Obligation
9=Lease Interest Expense
A=Prior Period Lease Obligation
B=Prior Period Lease Interest
C=Rent Expense
D=Lease Incentive

4 LS_ADMIN Number(10,0) DECIMAL(10) NOT NULL Lease Administrator
Prompt Table: RE_PARTY_LA

5 PRTFL_MGR Number(10,0) DECIMAL(10) NOT NULL Portfolio Manager
Prompt Table: RE_PARTY_PM

6 REGION_CD Character(10) VARCHAR2(10) NOT NULL Identifies the Sales Region. Populated on the Item Table to identify the Sales Region the Item is applied to.
Prompt Table: RE_REGION_NAME

7 TERM_ID Number(10,0) DECIMAL(10) NOT NULL Financial Term ID

8 SCHED_DATE Date(10) DATE Schedule Date

9 AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount

10 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

11 PRINCIPAL_ID Character(15) VARCHAR2(15) NOT NULL Landlord/Tenant

12 SCHED_NUM Number(5,0) INTEGER NOT NULL Team sequence number

13 LS_TRM_SCHD_STATUS Character(1) VARCHAR2(1) NOT NULL Lease Term Schedule Status
0=In Progress
1=Pending
2=Generated
3=Canceled

14 GENERATED_DATE Date(10) DATE Generated Date

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Default Value: OPR_DEF_TBL_FS.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_LS_NBR
3	TXN_GRP	Character(1)	VARCHAR2(1) NOT NULL	Transaction Group 1=Base Rent 2=Security Deposit 3=Straightline Accounting 4=Operating Expense 5=Percent Rent 6=Miscellaneous Rent 7=Manual Fee 8=Lease Obligation 9=Lease Interest Expense A=Prior Period Lease Obligation B=Prior Period Lease Interest C=Rent Expense D=Lease Incentive
4	LS_ADMIN	Number(10,0)	DECIMAL(10) NOT NULL	Lease Administrator Prompt Table: RE_PARTY_LA
5	PRTFL_MGR	Number(10,0)	DECIMAL(10) NOT NULL	Portfolio Manager Prompt Table: RE_PARTY_PM
6	REGION_CD	Character(10)	VARCHAR2(10) NOT NULL	Identifies the Sales Region. Populated on the Item Table to identify the Sales Region the Item is applied to. Prompt Table: RE_REGION_NAME
7	TERM_ID	Number(10,0)	DECIMAL(10) NOT NULL	Financial Term ID
8	SCHED_DATE	Date(10)	DATE	Schedule Date
9	AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Amount
10	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
11	PRINCIPAL_ID	Character(15)	VARCHAR2(15) NOT NULL	Landlord/Tenant
12	SCHED_NUM	Number(5,0)	INTEGER NOT NULL	Team sequence number
13	LS_TRM_SCHD_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Lease Term Schedule Status 0=In Progress 1=Pending 2=Generated 3=Canceled
14	GENERATED_DATE	Date(10)	DATE	Generated Date