BUSINESS_UNITFISCAL_YEARCNAO_BU_FY_VW(SQL View) |
Index Back |
|---|
| SELECT DISTINCT BL.Business_unit ,DP.FISCAL_YEAR FROM PS_BU_LED_GRP_TBL BL , ps_cal_detp_tbl DP , PS_SET_CNTRL_GROUP SC WHERE BL.LEDGER_TYPE='D' AND BL.calendar_id=DP.calendar_id AND BL.business_unit=SC.Setcntrlvalue AND SC.rec_group_id='FS_02' AND DP.setid=SC.setid |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | FISCAL_YEAR |
Number(4,0) | SMALLINT NOT NULL | Fiscal Year |