BU_LED_FYPER_VW(SQL View) |
Index Back |
---|
SELECT a.business_unit , b.ledger , d.fiscal_year , d.accounting_period FROM PS_BU_LED_GRP_TBL a , ps_bu_led_tbl b , ps_set_cntrl_group c , ps_cal_detp_tbl d WHERE b.business_unit = a.business_unit AND a.ledger_group = b.ledger_group AND a.business_unit = c.setcntrlvalue AND c.rec_group_id = 'FS_02' AND c.setid = d.setid AND d.calendar_id = a.calendar_id |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
2 | LEDGER | Character(10) | VARCHAR2(10) NOT NULL | Ledger |
3 | FISCAL_YEAR | Number(4,0) | SMALLINT NOT NULL | Fiscal Year |
4 | ACCOUNTING_PERIOD | Number(3,0) | SMALLINT NOT NULL | Identifies a time period to which you post transactions. Typically, an accounting period represents a month, but it can also represent a week, a day, or any user-defined interval. An accounting period has a beginning date and an ending date, and is defined in the calendar table. |