DWH Web Services - KFS Sub Account (NO DATA)
- Adam Chang
- Wayne Fields
- vjones (Unlicensed)
isValidKFSSubAccounts(List of (kfsChartCode, kfsAcctNumber, kfsSubAcctNumber) )
Input Specifications
Index | Parameter | Description | Required? | Data Type (max length) | Example |
|---|---|---|---|---|---|
0 | kfsChartCode | KFS Chart Code | Yes | String(2) | IR |
1 | kfsAcctNumber | KFS Account Number | Yes | String(7) | 1234567 |
2 | kfsSubAcctNumber | KFS SubAccount Number | Yes | String(5) | 12345 |
DB Query
SELECT
a.FIN_COA_CD,
a.ACCOUNT_NBR,
a.SUB_ACCT_NBR,
a.SUB_ACCT_ACTV_CD
FROM ca_sub_acct_t a
WHERE
a.SUB_ACCT_ACTV_CD <> 'N' AND
(
(a.fin_coa_cd='IR' AND a.account_nbr='1001783' AND a.sub_acct_nbr='EXP01') OR
(a.fin_coa_cd='IR' AND a.account_nbr='1001783' AND a.sub_acct_nbr='EXP02') OR
(a.fin_coa_cd='IR' AND a.account_nbr='1001783' AND a.sub_acct_nbr='XXXX')
);Result Schema: A list of following elements (SubAccountValidation.java)
Parameter | Description | Data Type | Example |
|---|---|---|---|
kfsChartCode | KFS Chart Code | String (2) | IR |
kfsAcctNumber | KFS Account Number | String (7) | 1234567 |
kfsSubAcctNumber | KFS SubAccount Number | String (5) | 12345 |
isValid | Is the SubAccount Active | boolean | true |
WS Example
Request
Response
Java Client Example
getValidKFSSubAccounts(List of (kfsChartCode, kfsAcctNumber, kfsSubAcctNumber))
Input Specifications
Index | Parameter | Description | Required? | Data Type (max length) | Example |
|---|---|---|---|---|---|
0 | kfsChartCode | KFS Chart Code | Yes | String(2) | IR |
1 | kfsAcctNumber | KFS Account Number | Yes | String(7) | 1234567 |
2 | kfsSubAcctNumber | KFS SubAccount Number | Yes | String(5) | 1234567 |
DB Query
Result Schema: A list of following elements (KFSSubAccountDetails.java)
Parameter | Description | Data Type | Example |
|---|---|---|---|
kfsChartCode | KFS Chart Code | String (2) | IR |
kfsAcctNumber | KFS Account Number | String (7) | 1234567 |
kfsSubAcctNumber | KFS SubAccount Number | String (5) | 1234567 |
kfsSubAcctName | KFS SubAccount Name | String (40) |
|
kfsReportToChartCode | KFS Reports To Chart Code | String (2) |
|
kfsReportToAcctNumber | KFS Reports To Account Number | String (4) |
|
kfsReportCode | KFS Reports Code | String (10) |
|
WS Example
Request
Response
Java Client Example
getAllKFSSubAccounts()
No input parameter, ALL active KFS subaccount details will be returned in result set.