KFS Chart Web Services
isValidKFSCharts(
...
kfsChartCode)
This service is used to validate KFS chart codes. Returns an XML result set with a value of true or false (example isValidKFSCharts result) for each chart
...
| Parameter | Description | Required? | Data Type (max length) | fiscalYear | The fiscal year - defaults to current year if empty | No | String (4) |
|---|---|---|---|---|---|---|---|
| kfsChartCode | The KFS chart of accounts code | Yes | String (2) |
Logic:
SQL Statement
...
| Code Block |
|---|
select distinct
'IR',
case when not exists (select * FROM dwhs_ods..ca_chart_t a where a.fin_coa_cd= 'IR'
AND a.FIN_COA_ACTIVE_CD <> 'N' )
then 'false'
else 'true'
end |
Result Schema:
Returns the chart code and true or false
| Parameter | Description | Data Type | Example |
|---|---|---|---|
| kfsChartCode | KFS Chart Code | String (2) | 'IR' |
| isValid | Is the Chart Active for that Fiscal Period? | boolean | true |
getAllValidKFSCharts(fiscalYear)
...