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
Input Specifications:
| Parameter | Description | Required? | Data Type (max length) |
|---|---|---|---|
| kfsChartCode | The KFS chart of accounts code | Yes | String (2) |
Logic:
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)
This service is used retrieve all valid KFS chart codes. Returns an XML result set with a list of charts (example getAllValidKFSCharts result)
Input Specifications:
| Parameter | Description | Required? | Data Type (max length) |
|---|---|---|---|
| fiscalYear | The KFS fiscal year - defaults to current year if empty | No | String (YYYY) |