Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Table of Contents

Usage

WSDL location: http://localhost:8080/WebService/DWHServer?wsdl

...

ParameterDescriptionRequired?Data Type (max length)
kfsChartCodeThe KFS chart of accounts codeYesString (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');

...

ParameterDescriptionRequired?Data Type (max length)
kfsChartCodeListA list of KFS chart of accounts codeYesA 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' 

...