| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 STLINE_KEY |
Number(15,0) |
DECIMAL(15) NOT NULL |
Straightline Key - Number (15)
|
| 2 |
LS_KEY |
Number(15,0) |
DECIMAL(15) NOT NULL |
Lease Key, Unique Key
|
| 3 |
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
|
| 4 |
TERM_RENT_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
List of Rent Type for Transaction Group
00=Residual Value
01=Base Rent
02=Operating Expense
03=Miscellaneous Rent
04=Initial Direct Cost
05=Prepaid Rent
06=Purchase Option
07=Renewal Option
08=Penality Option
09=Lease Incentives
10=Prepaid Rent
|
| 5 |
CALENDAR_ID |
Character(2) |
VARCHAR2(2) NOT NULL |
Calendar ID
|
| 6 |
TOT_PERIODS |
Number(9,4) |
DECIMAL(8,4) NOT NULL |
Total Schedule Periods - Number (4.4)
|
| 7 |
TOTAL_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Total Amount
|
| 8 |
TERMADJ_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Termination Adjustment Amount - Signed Number (23.3)
|
| 9 |
TOT_RET_PAY_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
LO Retire Amount
|
| 10 |
REGENERATE |
Character(1) |
VARCHAR2(1) NOT NULL |
Regenerate - Character (1) - XLAT
Y/N Table Edit
Default Value: N
|
| 11 |
DST_ALLOC_METHOD |
Character(1) |
VARCHAR2(1) NOT NULL |
Distribution Allocation Method
1=Percentage
2=Amount
3=Area
4=None
5=Quantity
Default Value: 4
|
| 12 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
|
| 13 |
FMS_DTTM_STAMP |
DateTime(26) |
TIMESTAMP |
Specifies the date and time of the original entry.
|
| 14 |
FMS_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Specifies the User ID which made the original entry.
|
| 15 |
FMS_LASTUPDDTTM |
DateTime(26) |
TIMESTAMP |
Specifies the date and time of the last update to an entry.
|
| 16 |
FMS_LASTUPDOPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Specifies the User ID which made the last update to an entry.
|