RE_CHG_ITEM

(SQL Table)
Index Back

Charge Item

This record is used in setup and configuration of the Transaction Routing Code defaults for the Transaction Group and Transaction Items.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
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 TXN_ITEM Character(2) VARCHAR2(2) NOT NULL Transaction Item
01=Base Rent
02=Security Deposit Issue
03=Security Deposit Deductions
04=Security Deposit Interest
05=Security Deposit Refund
06=Receivables St. Line Accrual
07=Receivables St. Line Deferral
08=Receivables St.Line Adjustment
09=Operating Expense
10=Percent Rent
11=Miscellaneous Rent
12=Manual Fee
13=Payables St. Line Accrual
14=Payables St. Line Deferral
15=Payables St. Line Adjustment
16=Lease Obligation
17=Interest Expense
18=Prior Period Obligation
19=Prior Period Interest Expense
20=Rent Expense
21=Lease Incentive
4 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