...
Table of Contents |
---|
Usage
WSDL location: http://localhost:8080/WebService/DWHServer?wsdl
...
Parameter | Description | Required? | Data Type (max length) |
---|---|---|---|
kfsChartCode | The KFS chart of accounts code | Yes | String (2) |
DB Query
...
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 SELECT FIN_COA_CD, FIN_COA_ACTIVE_CD FROM dwhs_ods..ca_chart_t WHERE fin_coa_cd IN ('IR', 'MC'); |
...
Parameter | Description | Required? | Data Type (max length) |
---|---|---|---|
kfsChartCodeList | A list of KFS chart of accounts code | Yes | A List of String (2) |
DB Query
...
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) |
...
No input parameter, ALL charts will return in result set.
DB Query
...
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' |
...