...
| Parameter | Description | Required? | Data Type (max length) |
|---|---|---|---|
| fsLocationCode | The FS location code | Yes | String (2) |
| fsAccountCode | The FS accounts code | Yes | String (6) |
| fsFundCode | The FS fund code | Yes | String (5) |
DB Query
| Code Block |
|---|
Old: SELECT a.fin_coa_cd, a.account_nbr, FROM KFSINT.UCI_CA_ACCOUNT_XW_T a WHERE a.ACTIVE_IND <> 'N' AND a.UC_LOC_CD = 'pLocationCode' AND a.UC_ACCT_NBR = 'pAccountCode' AND a.UC_FUND_NBR = 'pFundCode' New: SELECT a.UC_LOC_CD, UC_ACCT_NBR, a.UC_FUND_NBR, a.FIN_COA_CD, a.ACCOUNT_NBR FROM UCI_CA_ACCOUNT_XW_T a WHERE a.ACTIVE_IND <> 'N'AND ( (a.UC_LOC_CD = '9' AND a.UC_ACCT_NBR = '110001' AND a.UC_FUND_NBR = '18888') OR (a.UC_LOC_CD = '9' AND a.UC_ACCT_NBR = '111200' AND a.UC_FUND_NBR = '18213') OR (a.UC_LOC_CD = '9' AND a.UC_ACCT_NBR = '111200' AND a.UC_FUND_NBR = '182') ); |
...
| Code Block |
|---|
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:adc="http://www.adcom.uci.edu">
<soapenv:Header/>
<soapenv:Body>
<adc:translateFSAccountFunds>
<fsAccountList>
<item>9</item>
<item>110001</item>
<item>18888</item>
</fsAccountList>
<fsAccountList>
<item>9</item>
<item>111200</item>
<item>18213</item>
</fsAccountList>
<fsAccountList>
<item>9</item>
<item>111200</item>
<item>182</item>
</fsAccountList>
<fsAccountList>
<item></item>
<item></item>
<item></item>
</fsAccountList>
</adc:translateFSAccountFunds>
</soapenv:Body>
</soapenv:Envelope> |
...
Response
| Code Block |
|---|
<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
<soap:Body>
<ns2:translateFSAccountFundsResponse xmlns:ns2="http://www.adcom.uci.edu">
<return>
<fsAccountCode>110001</fsAccountCode>
<fsFundCode>18888</fsFundCode>
<fsLocationCode>9</fsLocationCode>
<kfsAcctNumber>1000766</kfsAcctNumber>
<kfsChartCode>IR</kfsChartCode>
</return>
<return>
<fsAccountCode>111200</fsAccountCode>
<fsFundCode>18213</fsFundCode>
<fsLocationCode>9</fsLocationCode>
<kfsAcctNumber>1000785</kfsAcctNumber>
<kfsChartCode>IR</kfsChartCode>
</return>
</ns2:translateFSAccountFundsResponse>
</soap:Body>
</soap:Envelope> |
...
Java Client Example
...