| # |
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.
|