RE_CHG_ITEM(SQL Table) |
Index Back |
---|---|
Charge ItemThis 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 |