RE_SLS_CAT (SQL View)	Index Back
Sales Category Charge Group Holds the setup data for the Charge Group Codes for the Sales Reporting Categories to be used by Lease Administration to classify the sales reported and to separate each Sales Category as a separate bill line.

RE_SLS_CAT

(SQL View)

Sales Category Charge Group

Holds the setup data for the Charge Group Codes for the Sales Reporting Categories to be used by Lease Administration to classify the sales reported and to separate each Sales Category as a separate 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 = '5'

Related Language Record: RE_SLSCAT_LG

# 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: 5

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 Sales Category 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

11 INTERIM_RENT_SW Character(1) VARCHAR2(1) NOT NULL Interim Rent

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

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