BUSINESS_UNITLEDGER_GROUPFISCAL_YEARCNAO_AJPR_FY_VW(SQL View) |
Index Back |
|---|---|
CNAO Fiscal Year prompt viewCNAO Fiscal Year prompt view in CNAO Adjustment Period Setup. |
| SELECT DISTINCT BL.BUSINESS_UNIT , BL.LEDGER_GROUP , DP.FISCAL_YEAR FROM PS_BU_LED_GRP_TBL BL , PS_CAL_DETP_TBL DP , PS_SET_CNTRL_REC SC WHERE BL.LEDGER_TYPE='D' AND BL.CALENDAR_ID=DP.CALENDAR_ID AND BL.BUSINESS_UNIT=SC.SETCNTRLVALUE AND SC.RECNAME='CAL_DETP_TBL' 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 | LEDGER_GROUP |
Character(10) | VARCHAR2(10) NOT NULL | Ledger Group |
| 3 | FISCAL_YEAR |
Number(4,0) | SMALLINT NOT NULL | Fiscal Year |