| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
STLINE_KEY |
Number(15,0) |
DECIMAL(15) NOT NULL |
Straightline Key - Number (15)
|
| 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 |
FISCAL_YEAR |
Number(4,0) |
SMALLINT NOT NULL |
Fiscal Year
|
| 6 |
ACCOUNTING_PERIOD |
Number(3,0) |
SMALLINT NOT NULL |
Identifies a time period to which you post transactions. Typically, an accounting period represents a month, but it can also represent a week, a day, or any user-defined interval. An accounting period has a beginning date and an ending date, and is defined in the calendar table.
|
| 7 |
ACTUAL_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Actual Amount field for the Actual V Budgeted Pagelet
|
| 8 |
STLINE_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Straightline Amount - Signed Number (23.3)
|
| 9 |
ADJUSTMENT_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Adjustment Amount
|
| 10 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
|
| 11 |
PERIOD_RATIO |
Number(6,4) |
DECIMAL(5,4) NOT NULL |
Schedule Period Ratio - Number (1.4)
|
| 12 |
STLINE_SCH_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Straightline Schedule Status - Character (1)
1=Pending
2=Processed
3=Errors
4=Processed prior to Transfer
5=Reversed
6=Schedule Reverted
|