Usage
isValidKFSSubObjects
Input Specifications
| Index | Parameter | Description | Required? | Data Type (max length) | Example |
|---|
| 0 | kfsFiscalYear | KFS Fiscal Year (e.g. 2013) | Yes | String (4) | |
| 1 | kfsChartCode | KFS Chart Code | Yes | String (2) | |
| 2 | kfsAcctNumber | KFS Account Number | Yes | String (7) | '1234567' |
| 3 | kfsObjectCode | KFS Object Code | Yes | String (4) | |
| 4 | kfsSubObjectCode | KFS SubObject Code | Yes | String (4) | |
DB Query
| Code Block |
|---|
SELECT
CONVERT(varchar(4),UNIV_FISCAL_YR) AS UNIV_FISCAL_YR,
FIN_COA_CD,
ACCOUNT_NBR,
FIN_OBJECT_CD,
FIN_SUB_OBJ_CD,
FIN_SUBOBJ_ACTV_CD
FROM CA_SUB_OBJECT_CD_T
WHERE FIN_SUBOBJ_ACTV_CD <> 'N' AND
(
(univ_fiscal_yr = '2012' AND
fin_coa_cd='IR' AND
account_nbr='1000766' AND
fin_object_cd = 'CASH' AND
fin_sub_obj_cd = 'CASH') OR
(univ_fiscal_yr = '2012' AND
fin_coa_cd='IR' AND
account_nbr='1000766' AND
fin_object_cd = 'CASH' AND
fin_sub_obj_cd = 'XXXX')
) |
Result Schema: A list of following elements (SubObjectValidation.java)
| Parameter | Description | Data Type | Example |
|---|
| kfsFiscalYear | The KFS Fiscal Year | String (4) | '2013' |
| kfsChartCode | The KFS chart of accounts code | String (2) | 'IR' |
| kfsAcctNumber | KFS Account Number | String(7) | '1234567' |
| kfsObjCode | KFS Object Code | String (4) | 'CASH' |
| kfsSubObjCode | KFS SubObject Code | String (4) | 'CASH' |
| isValid | Is the SubObject Active? | boolean | true |
WS Example
Request
Response
Java Client Example
...
getValidKFSSubObjects
Input Specifications
| Index | Parameter | Description | Required? | Data Type (max length) | Example |
|---|
| 0 | kfsFiscalYear | KFS Fiscal Year (e.g. 2013) | Yes | String (4) | |
| 1 | kfsChartCode | KFS Chart Code | Yes | String (2) | |
| 2 | kfsAcctNumber | KFS Account Number | Yes | String (7) | '1234567' |
| 3 | kfsObjectCode | KFS Object Code | Yes | String (4) | |
| 4 | kfsSubObjectCode | KFS SubObject Code | Yes | String (4) | |
DB Query
| Code Block |
|---|
SELECT
CONVERT(varchar(4), a.univ_fiscal_yr) AS UNIV_FISCAL_YR,
a.fin_coa_cd,
a.account_nbr,
a.fin_object_cd,
b.fin_obj_cd_nm,
a.fin_sub_obj_cd,
a.fin_sub_obj_cd_nm
FROM CA_SUB_OBJECT_CD_T a, CA_OBJECT_CODE_T b
WHERE a.fin_object_cd = b.fin_object_cd AND a.FIN_SUBOBJ_ACTV_CD <> 'N' AND
(
(a.univ_fiscal_yr = '2012' AND
a.fin_coa_cd = 'IR' AND
a.account_nbr= '1000766' AND
a.fin_object_cd = 'CASH' AND
a.fin_sub_obj_cd = 'CASH') OR
(a.univ_fiscal_yr = '2012' AND
a.fin_coa_cd='IR' AND
a.account_nbr='1000766' AND
a.fin_object_cd = 'CASH' AND
a.fin_sub_obj_cd = 'XXXX')
) |
Result Schema: A list of following elements (SubObjectDetails.java)
| DB Parameter | Java Parameter | Description | Data Type | |
|---|
UNIV_FISCAL_YR | kfsFiscalYear | KFS Fiscal Year | String (4) | 2012 |
FIN_COA_CD | kfsChartCode | KFS Chart Code | String (2) | 'IR' |
ACCOUNT_NBM | kfsAcctNumber | KFS Account Number | String (7) | '1234567' |
FIN_OBJECT_CD | kfsObjCode | KFS Object Code | String (4) | 'CASH' |
FIN_OBJ_CD_NM | kfsObjCodeName | KFS Object Code Name | String (40) | |
FIN_SUB_OBJ_CD | kfsSubObjCode | KFS SubObject Code | String (4) | 'CASH' |
FIN_SUB_OBJ_CD_NM | kfsSubObjCodeName | KFS SubObject Code Name | String (40) | |
WS Example
Request
Response
Java Client Example
...
getAllKFSSubObjects
No input parameter, ALL active KFS sub object details will be returned in result set.
DB Query
| Code Block |
|---|
SELECT
CONVERT(varchar(4), a.univ_fiscal_yr) AS UNIV_FISCAL_YR,
a.fin_coa_cd,
a.account_nbr,
a.fin_object_cd,
b.fin_obj_cd_nm,
a.fin_sub_obj_cd,
a.fin_sub_obj_cd_nm
FROM CA_SUB_OBJECT_CD_T a, CA_OBJECT_CODE_T b
WHERE a.fin_object_cd = b.fin_object_cd AND a.FIN_SUBOBJ_ACTV_CD <> 'N' |
Result Schema: Same as getValidKFSSubObjects()
WS Example
Request
Response
Java Client Example
...