RE_BU_SRCH(SQL View) |
Index Back |
|---|---|
Business Unit SearchThis record is the Search record for the Business Unit Setup for Lease Administration. |
| SELECT R.BUSINESS_UNIT ,R.BILL_TYPE_ID ,R.BILL_SOURCE_ID ,R.BILL_BY_ID ,R.AUTO_APRV_BILL ,R.AUTO_APRV_PMT ,R.SPACE_UOM ,R.BUSINESS_UNIT_AM ,R.BUSINESS_UNIT_AP ,R.BUSINESS_UNIT_CA ,R.BUSINESS_UNIT_GL ,R.OPEX_LIMIT ,R.PRENT_LIMIT ,R.CURRENCY_CD ,R.LEAD_BIL_TIME ,R.LEAD_PMT_TIME ,R.JRNL_ID_GL ,R.OPEX_AUTO_SL ,R.RENT_AUTO_SL ,R.CALENDAR_ID ,R.RT_TYPE ,R.LSE_EXPIRE_OPTION FROM PS_RE_BUS_UNIT R , PS_BUS_UNIT_TBL_FS B WHERE R.BUSINESS_UNIT = B.BUSINESS_UNIT |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT Prompt Table: SP_BU_RE_NONVW |
| 2 | BILL_TYPE_ID | Character(3) | VARCHAR2(3) NOT NULL |
Bill Type Identifier
Prompt Table: BI_TYPE |
| 3 | BILL_SOURCE_ID | Character(10) | VARCHAR2(10) NOT NULL |
Bill Source
Prompt Table: BI_SRC |
| 4 | BILL_BY_ID | Character(10) | VARCHAR2(10) NOT NULL |
Bill By Identifier
Prompt Table: BI_BILL_BY |
| 5 | AUTO_APRV_BILL | Character(1) | VARCHAR2(1) NOT NULL |
This field is checked for Auto approving Billing
Y/N Table Edit |
| 6 | AUTO_APRV_PMT | Character(1) | VARCHAR2(1) NOT NULL |
This field is checked to automatically approve Payables transactions
Y/N Table Edit |
| 7 | SPACE_UOM | Character(3) | VARCHAR2(3) NOT NULL |
Space Unit of measure (Sq Feet or Sq Meters)
Prompt Table: UNITS_TBL |
| 8 | BUSINESS_UNIT_AM | Character(5) | VARCHAR2(5) NOT NULL |
AM Business Unit
Prompt Table: SP_BU_AM_NONVW |
| 9 | BUSINESS_UNIT_AP | Character(5) | VARCHAR2(5) NOT NULL |
AP Business Unit
Prompt Table: SP_BU_AP_NONVW |
| 10 | BUSINESS_UNIT_CA | Character(5) | VARCHAR2(5) NOT NULL |
Contracts Business Unit
Prompt Table: SP_BU_CA_NONVW |
| 11 | BUSINESS_UNIT_GL | Character(5) | VARCHAR2(5) NOT NULL |
GL Business Unit
Prompt Table: SP_BU_GL_NONVW |
| 12 | OPEX_LIMIT | Number(3,0) | SMALLINT NOT NULL | Operating Expenses Limit |
| 13 | PRENT_LIMIT | Number(3,0) | SMALLINT NOT NULL | Percent Rent Tolerance |
| 14 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Base Currency Cd
Prompt Table: CURRENCY_CD_TBL |
| 15 | LEAD_BIL_TIME | Number(9,0) | DECIMAL(9) NOT NULL | Billables Transaction Lead Time |
| 16 | LEAD_PMT_TIME | Number(9,0) | DECIMAL(9) NOT NULL | Payables Transaction Lead Time |
| 17 | JRNL_ID_GL | Character(10) | VARCHAR2(10) NOT NULL | GL Journal Generator |
| 18 | OPEX_AUTO_SL | Character(1) | VARCHAR2(1) NOT NULL |
Auto Straightline Operating Expenses
Y/N Table Edit |
| 19 | RENT_AUTO_SL | Character(1) | VARCHAR2(1) NOT NULL |
Auto Straightline Rent and Miscellaneous Rent
Y/N Table Edit |
| 20 | CALENDAR_ID | Character(2) | VARCHAR2(2) NOT NULL |
Calendar ID
Prompt Table: CAL_DETL_VW |
| 21 | RT_TYPE | Character(5) | VARCHAR2(5) NOT NULL |
Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical.
Prompt Table: RT_TYPE_TBL |
| 22 | LSE_EXPIRE_OPTION | Character(2) | VARCHAR2(2) NOT NULL |
Lease Expiry Notification - This field sets the Options for the Lease Expiry Notification.
01=Notify Only 02=Update Only 03=Notify and Update |