RE_BU_LS_OBL(SQL Table) |
Index Back |
---|---|
Business Lease ObligationBusiness Lease Obligation - Used for the Minimum Lease Obligations report (Government Reports). |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | 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 |