...
This service is used retrieve valid KFS chart codes and related attributes. Returns an XML result set with a list of charts (example getAllValidKFSCharts result). If input parameter is blank, ALL charts will return in result set.
Input Specifications:
| Parameter | Description | Required? | Data Type (max length) |
|---|---|---|---|
| kfsChartCodekfsChartCodeList | The A list of KFS chart of accounts code, service will return ALL valid charts if blank | Yes | A List of String (2) |
Logic:
| 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 = '<kfsChartCode>' --leave out if kfsChartCode input parameter is blank |
...
IN ('<kfsChartCode1>', '<kfsChartCode2>', etc) |
Result Schema: A list of following element
| Parameter | Description | Data Type | Example |
|---|---|---|---|
| kfsChartCode | KFS Chart Code | String (2) | 'IR' |
| kfsChartDescription | KFS Chart Description | String (40) | 'Irvine' |
| kfsChartActiveCode | KFS Chart Active Code ('Y' for yes, 'N' for no) | String (1) | 'Y' |
| kfsFinCashObjCode | KFS Cash Object Code | String (4) | '0000' |
| kfsFinAPObjCode | KFS Accounts Payable Object Code | String (4) | '0000' |
| kfsIncBdgtElimObjCode | KFS Income Budget Elimination Object Code | String (4) | '0000' |
| kfsExpBdgtElimObjCode | KFS Expense Budget Elimination Object Code | String (4) | '0000' |
| kfsRptsToChartCode | KFS Reports to Chart Code | String (2) | 'MC' |
| kfsARObjCode | KFS Accounts Receivable Object Code | String (4) | '0000' |
| kfsIntEncObjCode | KFS Internal Encumbrances Object Code | String (4) | '0000' |
kfsExtEncObjCode | KFS External Encumbrances Object Code | String (4) | '0000' |
| kfsPreEncObjCode | KFS Pre Encumbrances Object Code | String (4) | '0000' |
| kfsICRIncObjCode | KFS Indirect Cost Recovery Income Object Code | String (4) | '0000' |
| kfsICRExpObjCode | KFS Indirect Cost Recovery Expense Object Code | String (4) | '0000' |
| kfsFundBalObjCode | KFS Fund Balance Object Code | String (4) | '0000' |
getAllKFSCharts()
No input parameter, ALL charts will return in result set.
Logic:
| 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' |
Result Schema: A list of following element
| Parameter | Description | Data Type | Example |
|---|---|---|---|
| kfsChartCode | KFS Chart Code | String (2) | 'IR' |
| kfsChartDescription | KFS Chart Description | String (40) | 'Irvine' |
| kfsChartActiveCode | KFS Chart Active Code ('Y' for yes, 'N' for no) | String (1) | 'Y' |
| kfsFinCashObjCode | KFS Cash Object Code | String (4) | '0000' |
| kfsFinAPObjCode | KFS Accounts Payable Object Code | String (4) | '0000' |
| kfsIncBdgtElimObjCode | KFS Income Budget Elimination Object Code | String (4) | '0000' |
| kfsExpBdgtElimObjCode | KFS Expense Budget Elimination Object Code | String (4) | '0000' |
| kfsRptsToChartCode | KFS Reports to Chart Code | String (2) | 'MC' |
| kfsARObjCode | KFS Accounts Receivable Object Code | String (4) | '0000' |
| kfsIntEncObjCode | KFS Internal Encumbrances Object Code | String (4) | '0000' |
kfsExtEncObjCode | KFS External Encumbrances Object Code | String (4) | '0000' |
| kfsPreEncObjCode | KFS Pre Encumbrances Object Code | String (4) | '0000' |
| kfsICRIncObjCode | KFS Indirect Cost Recovery Income Object Code | String (4) | '0000' |
| kfsICRExpObjCode | KFS Indirect Cost Recovery Expense Object Code | String (4) | '0000' |
| kfsFundBalObjCode | KFS Fund Balance Object Code | String (4) | '0000' |
...