...
This service is used to determine the active fiscal period periods for a given date. Returns an XML result set with a list of (kfsFiscalYear, kfsFiscalPeriod).
...
| Index | Parameter | Description | Required? | Data Type (max length) | Example |
|---|---|---|---|---|---|
| 0 | date | The date to search for active fiscal period | No (default is today's date) | String(8) YYYYMMDD | '20120701' |
DB Query
| Code Block |
|---|
SELECT TOP 1 univ_fiscal_yr, univ_fiscal_prd_cd FROM sh_acct_period_t WHERE row_actv_ind <> 'N' AND univ_fiscal_prd_cd <= '1213' AND univ_fscpd_end_dt >= convert(DATETIME, '20130625'?, 112) ORDER BY univ_fiscal_yr, univ_fiscal_prd_cd |
...