...
| Code Block |
|---|
Old:
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
New:
SELECT FIN_COA_CD, FIN_COA_ACTIVE_CD FROM dwhs_ods..ca_chart_t WHERE fin_coa_cd IN ('IR', 'MC'); |
Result Schema: A list of following element
...
chart code and true or false
(ChartValidation.java)
| Parameter | Description | Data Type | Example |
|---|---|---|---|
| kfsChartCode | KFS Chart Code | String (2) | 'IR' |
| isValid | Is the Chart Active for that Fiscal Period? | boolean | true |
...
| Code Block |
|---|
SELECT FIN_COA_CD
,FIN_COA_DESC
,FIN_COA_ACTIVE_CD
,FIN_CASH_OBJ_CD
,FIN_AP_OBJ_CD
,INCBDGT_ELIMOBJ_CD
,EXPBDGT_ELIMOBJ_CD
,RPTS_TO_FIN_COA_CD
,FIN_AR_OBJ_CD
,FIN_INT_ENC_OBJ_CD
,FIN_EXT_ENC_OBJ_CD
,FIN_PRE_ENC_OBJ_CD
,ICR_INC_FIN_OBJ_CD
,ICR_EXP_FIN_OBJ_CD
,FND_BAL_OBJ_CD
FROM ca_chart_t
WHERE FIN_COA_ACTIVE_CD <> 'N'
AND FIN_COA_CD IN ('<kfsChartCode1>', '<kfsChartCode2>', etc) |
Result Schema: A list of following element (ChartDetails.java)
| Parameter | Description | Data Type | Example |
|---|---|---|---|
| kfsChartCode | KFS Chart Code | String (2) | 'IR' |
| kfsChartDescription | KFS Chart Description | String (40) | 'Irvine' |
| kfsChartActiveCode | KFS Chart Active Code ('Y' for yes, 'N' for no) | String (1) | 'Y' |
| kfsFinCashObjCode | KFS Cash Object Code | String (4) | '0000' |
| kfsFinAPObjCode | KFS Accounts Payable Object Code | String (4) | '0000' |
| kfsIncBdgtElimObjCode | KFS Income Budget Elimination Object Code | String (4) | '0000' |
| kfsExpBdgtElimObjCode | KFS Expense Budget Elimination Object Code | String (4) | '0000' |
| kfsRptsToChartCode | KFS Reports to Chart Code | String (2) | 'MC' |
| kfsARObjCode | KFS Accounts Receivable Object Code | String (4) | '0000' |
| kfsIntEncObjCode | KFS Internal Encumbrances Object Code | String (4) | '0000' |
kfsExtEncObjCode | KFS External Encumbrances Object Code | String (4) | '0000' |
| kfsPreEncObjCode | KFS Pre Encumbrances Object Code | String (4) | '0000' |
| kfsICRIncObjCode | KFS Indirect Cost Recovery Income Object Code | String (4) | '0000' |
| kfsICRExpObjCode | KFS Indirect Cost Recovery Expense Object Code | String (4) | '0000' |
| kfsFundBalObjCode | KFS Fund Balance Object Code | String (4) | '0000' |
...
| Code Block |
|---|
SELECT FIN_COA_CD
,FIN_COA_DESC
,FIN_COA_ACTIVE_CD
,FIN_CASH_OBJ_CD
,FIN_AP_OBJ_CD
,INCBDGT_ELIMOBJ_CD
,EXPBDGT_ELIMOBJ_CD
,RPTS_TO_FIN_COA_CD
,FIN_AR_OBJ_CD
,FIN_INT_ENC_OBJ_CD
,FIN_EXT_ENC_OBJ_CD
,FIN_PRE_ENC_OBJ_CD
,ICR_INC_FIN_OBJ_CD
,ICR_EXP_FIN_OBJ_CD
,FND_BAL_OBJ_CD
FROM ca_chart_t
WHERE FIN_COA_ACTIVE_CD <> 'N' |
Result Schema:
...
kfsExtEncObjCode
...
Same as getValidKFSCharts
WS Example
Request
| Code Block |
|---|
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:adc="http://www.adcom.uci.edu">
<soapenv:Header/>
<soapenv:Body>
<adc:getAllKFSCharts/>
</soapenv:Body>
</soapenv:Envelope> |
...