RE_FASBADJ_SRCH (SQL View)	Index Back
FASB Review and Adjustmt Srch FASB Review and Adjustment Search record

RE_FASBADJ_SRCH

(SQL View)

FASB Review and Adjustmt Srch

FASB Review and Adjustment Search record

SELECT A.BUSINESS_UNIT , A.LS_NBR , CASE WHEN B.TERM_RENT_TYPE = '10' THEN 'P' WHEN B.TERM_RENT_TYPE = '04' THEN 'I' WHEN B.TERM_RENT_TYPE = '09' THEN 'L' ELSE B.TXN_GRP END , B.STLINE_KEY FROM PS_RE_LS A , PS_RE_STLINE 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_LS_SRCH2

3 TXN_GRP_FAS Character(1) VARCHAR2(1) NOT NULL Straightline (FASB 13) applicable Transaction Groups. This field is a copy of TXN_GRP with the non - FASB translate values excluded.
1=Base Rent
4=Operating Expense
6=Miscellaneous Rent
I=Initial Direct Cost
L=Lease Incentive
P=Prepaid Rent

4 STLINE_KEY Number(15,0) DECIMAL(15) NOT NULL Straightline Key - Number (15)

#	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_LS_SRCH2
3	TXN_GRP_FAS	Character(1)	VARCHAR2(1) NOT NULL	Straightline (FASB 13) applicable Transaction Groups. This field is a copy of TXN_GRP with the non - FASB translate values excluded. 1=Base Rent 4=Operating Expense 6=Miscellaneous Rent I=Initial Direct Cost L=Lease Incentive P=Prepaid Rent
4	STLINE_KEY	Number(15,0)	DECIMAL(15) NOT NULL	Straightline Key - Number (15)