...
| Code Block |
|---|
SELECT FIN_COA_CD, ORG_CD, UC_LOC_CD, UC_HIERARCHY_CD, UC_HIERARCHY_TYPE_CD FROM UCI_CA_ORG_XW_T WHERE UC_HIERARCHY_TYPE_CD='O' AND ( (UC_LOC_CD='9' AND UC_HIERARCHY_CD='9030') OR (UC_LOC_CD='9' AND UC_HIERARCHY_CD='9040') OR (UC_LOC_CD='0' AND UC_HIERARCHY_CD='0000') ); |
Result Schema: A list of following elements (
...
FS2KFSOrganizationDetails.java)
| Parameter | Description | Data Type | Example |
|---|---|---|---|
| kfsChartCode | KFS Chart Code | String(2) | IR |
| kfsOrgCode | KFS Organization Code | String(4) | 9903 |
| fsHierarchyType | FS Hierarchy Type | String | O |
| fsLocationCode | FS Location Code | String | 9 |
| fsHierarchyCode | FS Hierarchy Code | String | 9030 |
...
| Code Block |
|---|
SELECT FIN_COA_CD, ORG_CD, UC_LOC_CD, UC_HIERARCHY_CD, UC_HIERARCHY_TYPE_CD FROM UCI_CA_ORG_XW_T WHERE UC_HIERARCHY_TYPE_CD='V' AND ( (UC_LOC_CD='9' AND UC_HIERARCHY_CD='1003') OR (UC_LOC_CD='9' AND UC_HIERARCHY_CD='1005') OR (UC_LOC_CD='0' AND UC_HIERARCHY_CD='0000') ); |
Result Schema: A list of following elements (
...
FS2KFSOrganizationDetails.java)
| Parameter | Description | Data Type | Example |
|---|---|---|---|
| kfsChartCode | KFS Chart Code | String(2) | IR |
| kfsOrgCode | KFS Organization Code | String(4) | 9801 |
| fsHierarchyType | FS Hierarchy Type | String | V |
| fsLocationCode | FS Location Code | String | 9 |
| fsHierarchyCode | FS Hierarchy Code | String | 1003 |
...
| Code Block |
|---|
SELECT FIN_COA_CD, ORG_CD, UC_LOC_CD, UC_HIERARCHY_CD, UC_HIERARCHY_TYPE_CD FROM UCI_CA_ORG_XW_T WHERE UC_HIERARCHY_TYPE_CD='S' AND ( (UC_LOC_CD='9' AND UC_HIERARCHY_CD='1003') OR (UC_LOC_CD='9' AND UC_HIERARCHY_CD='1005') OR (UC_LOC_CD='0' AND UC_HIERARCHY_CD='0000') ); |
Result Schema: A list of following elements (
...
FS2KFSOrganizationDetails.java)
| Parameter | Description | Data Type | Example |
|---|---|---|---|
| kfsChartCode | KFS Chart Code | String(2) | IR |
| kfsOrgCode | KFS Organization Code | String(4) | 9001 |
| fsHierarchyType | FS Hierarchy Type | String | S |
| fsLocationCode | FS Location Code | String | 9 |
| fsHierarchyCode | FS Hierarchy Code | String | 1003 |
...
| Code Block |
|---|
SELECT FIN_COA_CD, ORG_CD, UC_LOC_CD, UC_HIERARCHY_CD, UC_HIERARCHY_TYPE_CD FROM UCI_CA_ORG_XW_T WHERE UC_HIERARCHY_TYPE_CD='D' AND ( (UC_LOC_CD='9' AND UC_HIERARCHY_CD='0302') OR (UC_LOC_CD='9' AND UC_HIERARCHY_CD='0003') OR (UC_LOC_CD='0' AND UC_HIERARCHY_CD='0000') ); |
Result Schema: A list of following elements (FS2KFSOrganizationDetails.java)
| Parameter | Description | Data Type | Example |
|---|---|---|---|
| kfsChartCode | KFS Chart Code | String(2) | IR |
| kfsOrgCode | KFS Organization Code | String(4) | 0302 |
| fsHierarchyType | FS Hierarchy Type | String | D |
| fsLocationCode | FS Location Code | String | 9 |
| fsHierarchyCode | FS Hierarchy Code | String | 0302 |
...