RE_BU_LS_OBL

(SQL Table)
Index Back

Business Lease Obligation

Business Lease Obligation - Used for the Minimum Lease Obligations report (Government Reports).

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Prompt Table: SP_BU_RE_NONVW

2 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
3 FIRST_FY_DT Number(4,0) SMALLINT NOT NULL First Fiscal Year End Date
4 SECOND_FY_DT Number(4,0) SMALLINT NOT NULL Second Fiscal Year End Date
5 THIRD_FY_DT Number(4,0) SMALLINT NOT NULL Third Fiscal Year End Date
6 FOURTH_FY_DT Number(4,0) SMALLINT NOT NULL Fourth Fiscal Year End Date
7 FIFTH_FY_DT Number(4,0) SMALLINT NOT NULL Fifth Fiscal Year End Date
8 BU_FY_AMT_1 Signed Number(28,3) DECIMAL(26,3) NOT NULL Business Unit Amount for the First Fiscal Year. Used for the Minimum Lease Obligation (Government) Report.
9 BU_FY_AMT_2 Signed Number(28,3) DECIMAL(26,3) NOT NULL Business Unit Amount for the Second Fiscal Year. Used for the Minimum Lease Obligation (Government) Report.
10 BU_FY_AMT_3 Signed Number(28,3) DECIMAL(26,3) NOT NULL Business Unit Amount for the Third Fiscal Year. Used for the Minimum Lease Obligation (Government) Report.
11 BU_FY_AMT_4 Signed Number(28,3) DECIMAL(26,3) NOT NULL Business Unit Amount for the Fourth Fiscal Year. Used for the Minimum Lease Obligation (Government) Report.
12 BU_FY_AMT_5 Signed Number(28,3) DECIMAL(26,3) NOT NULL Business Unit Amount for the Fifth Fiscal Year. Used for the Minimum Lease Obligation (Government) Report.
13 BU_THEREAFTER Signed Number(28,3) DECIMAL(26,3) NOT NULL Business Unit Amount for the Fiscal Years after Five (There after). Used for the Minimum Lease Obligation (Government) Report.
14 BU_TOTAL Signed Number(28,3) DECIMAL(26,3) NOT NULL Business Unit Total Amount. Used for the Minimum Lease Obligation (Government) Report.
15 TXN_GRP_CODE Number(4,0) SMALLINT NOT NULL Transaction Group
16 RE_UNPAID_TXN_FLG Character(1) VARCHAR2(1) NOT NULL Exclude Paid Transactions
N=Include Paid Transactions
Y=Exclude Paid Transactions

Default Value: N