RE_CHG_GROUP (SQL Table)	Index Back
Charge Group Codes This record is used to setup and configure the Charge group Codes and transaction routing Codes for Operating Expenses, Sales Categories, Miscellaneous/Manual fee Types and Sundry Charges. This record is populated through the views for the above categories.

RE_CHG_GROUP

(SQL Table)

Charge Group Codes

This record is used to setup and configure the Charge group Codes and transaction routing Codes for Operating Expenses, Sales Categories, Miscellaneous/Manual fee Types and Sundry Charges. This record is populated through the views for the above categories.

Related Language Record: RE_CHGGRP_LG

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL 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

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 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
Default Value: N

11 INTERIM_RENT_SW Character(1) VARCHAR2(1) NOT NULL Interim Rent
Default Value: N

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 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
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	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 Default Value: N
11	INTERIM_RENT_SW	Character(1)	VARCHAR2(1) NOT NULL	Interim Rent Default Value: N
12	RENT_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Rent Type 1=Initial Direct Cost 3=Other Default Value: 3