RE_BU_LS_DET(SQL Table) |
Index Back |
|---|---|
Business Lease DetailsBusiness Lease Details - Used to store the individual Lease details for the Business Unit in the Minimum Lease Obligation report. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table:
RE_BU_SRCH
|
| 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 | FIRST_FY_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | First Fiscal Year Amount. Used for the Minimum Lease Obligation (Government) Report. |
| 5 | SECOND_FY_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Second Fiscal Year Amount. Used for the Minimum Lease Obligation (Government) Report. |
| 6 | THIRD_FY_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Third Fiscal Year Amount. Used for the Minimum Lease Obligation (Government) Report. |
| 7 | FOURTH_FY_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Fourth Fiscal Year Amount. Used for the Minimum Lease Obligation (Government) Report. |
| 8 | FIFTH_FY_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Fifth Fiscal Year Amount. Used for the Minimum Lease Obligation (Government) Report. |
| 9 | THEREAFTER_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | There After Amount. Used for the Minimum Lease Obligation (Government) Report. |
| 10 | TOTAL_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Total Amount |