CA_TXN_FRE_VW

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	CA_TXN_ID	Number(12,0)	DECIMAL(12) NOT NULL	Transaction ID
2	LS_TXN_ID	Number(25,0)	DECIMAL(25) NOT NULL	Lease Transaction ID
3	LS_TXN_DTL_SEQ	Number(15,0)	DECIMAL(15) NOT NULL	Lease Transaction Detail ID
4	TXN_DEST	Character(1)	VARCHAR2(1) NOT NULL	This field indicates the Destination for Transaction Billing processor is 'Billing' or 'Payables' 1=Accounts Payable 2=Billing 3=General Ledger
5	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
6	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.
7	LS_KEY	Number(15,0)	DECIMAL(15) NOT NULL	Lease Key, Unique Key
8	TERM_ID	Number(10,0)	DECIMAL(10) NOT NULL	Financial Term ID
9	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
10	LS_TXN_SRC_ID	Number(30,0)	DECIMAL(30) NOT NULL	Lease Transaction Source ID
11	CHG_GRP_CD	Character(10)	VARCHAR2(10) NOT NULL	This field holds the Charge Group Code for the Transaction Groups.