RE_MISC_FEE_VW (SQL View)	Index Back
Miscellaneous/Manual Fee Types Holds the Setup data for the Charge Group Codes for the Miscellaneous Rent to be used by Lease Administration to separate each Miscellaneous Rent as a distinct bill line.

RE_MISC_FEE_VW

(SQL View)

Miscellaneous/Manual Fee Types

Holds the Setup data for the Charge Group Codes for the Miscellaneous Rent to be used by Lease Administration to separate each Miscellaneous Rent as a distinct bill line.

SELECT SETID , TXN_GRP , CHG_GRP_CD , EFFDT , EFF_STATUS , END_EFFDT , INSTANCE_NAME , INSTANCE_DESCR , TXN_ROUTE_CD , CAPITALIZE_SW , INTERIM_RENT_SW , RENT_TYPE FROM PS_RE_CHG_GROUP WHERE TXN_GRP = '6' AND RENT_TYPE = '3' AND INTERIM_RENT_SW = 'N'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
Default Value: OPR_DEF_TBL_FS.SETID
Prompt Table: SP_SETID_NONVW

2 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
Default Value: 6

3 CHG_GRP_CD Character(10) VARCHAR2(10) NOT NULL This field holds the Charge Group Code for the Transaction Groups.

4 EFFDT Date(10) DATE NOT NULL Effective Date
Default Value: %date

5 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive
Default Value: A

6 END_EFFDT Date(10) DATE Ending effective date established to be used by queries to improve effective-date processing performance.

7 INSTANCE_NAME Character(60) VARCHAR2(60) NOT NULL Miscellaneous Rent Name

8 INSTANCE_DESCR Character(150) VARCHAR2(150) NOT NULL Generic Description Field for Instances of Generic Entities

9 TXN_ROUTE_CD Character(20) VARCHAR2(20) NOT NULL This field holds the Transaction routing Codes used to configure the Billing, SUT and Withholding defaults.
Prompt Table: RE_TXN_RT_CD

10 CAPITALIZE_SW Character(1) VARCHAR2(1) NOT NULL Capitalized
Y/N Table Edit

11 INTERIM_RENT_SW Character(1) VARCHAR2(1) NOT NULL Interim Rent
Y/N Table Edit

12 RENT_TYPE Character(1) VARCHAR2(1) NOT NULL Rent Type
1=Initial Direct Cost
3=Other
Default Value: 3

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETID_NONVW
2	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 Default Value: 6
3	CHG_GRP_CD	Character(10)	VARCHAR2(10) NOT NULL	This field holds the Charge Group Code for the Transaction Groups.
4	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
5	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive Default Value: A
6	END_EFFDT	Date(10)	DATE	Ending effective date established to be used by queries to improve effective-date processing performance.
7	INSTANCE_NAME	Character(60)	VARCHAR2(60) NOT NULL	Miscellaneous Rent Name
8	INSTANCE_DESCR	Character(150)	VARCHAR2(150) NOT NULL	Generic Description Field for Instances of Generic Entities
9	TXN_ROUTE_CD	Character(20)	VARCHAR2(20) NOT NULL	This field holds the Transaction routing Codes used to configure the Billing, SUT and Withholding defaults. Prompt Table: RE_TXN_RT_CD
10	CAPITALIZE_SW	Character(1)	VARCHAR2(1) NOT NULL	Capitalized Y/N Table Edit
11	INTERIM_RENT_SW	Character(1)	VARCHAR2(1) NOT NULL	Interim Rent Y/N Table Edit
12	RENT_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Rent Type 1=Initial Direct Cost 3=Other Default Value: 3