Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

IndexParameterDescriptionRequired?Data Type (max length)Example
0fsLocationCodeFS Location CodeYesString(1)9
1fsOrganizationCodeFS Organization CodeNoString(4)9030

DB Query

Code Block
SELECTSELECT 
FIN_COA_CD, 
ORG_CD, 
UC_LOC_CD, 
UC_HIERARCHY_CD, 
UC_HIERARCHY_TYPE_CDCD 
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_TYPE_CD='9040') OR 
(UC_LOC_CD='0' AND UC_HIERARCHY_CD='O0000') 
); 

Result Schema: A list of following elements (OrganizationValidation.java)

...

IndexParameterDescriptionRequired?Data Type (max length)Example
0fsLocationCodeFS Location CodeYesString(1)9
1fsDivsionCodeFS Division CodeYesString(4)1003

DB Query

Code Block
SELECTSELECT 
FIN_COA_CD, 
ORG_CD, 
UC_LOC_CD, 
UC_HIERARCHY_CD, 
UC_HIERARCHY_TYPE_CDCD 
FROM UCI_CA_ORG_XW_T WHERE _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_TYPE_CD='1005') OR 
(UC_LOC_CD='0' AND UC_HIERARCHY_CD='V0000')
); 

Result Schema: A list of following elements (OrganizationValidation.java)

...

IndexParameterDescriptionRequired?Data Type (max length)Example
0fsLocationCodeFS Location CodeYesString(1)9
1fsSubDivisionCodeFS SubDivisionCodeNoString(4)1003

DB Query

Code Block
SELECTSELECT 
FIN_COA_CD, 
ORG_CD, 
UC_LOC_CD, 
UC_HIERARCHY_CD, 
UC_HIERARCHY_TYPE_CDCD 
FROM UCI_CA_ORG_XW_T WHERE _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_TYPE_CD='1005') OR
(UC_LOC_CD='0' AND UC_HIERARCHY_CD='S0000')
); 

Result Schema: A list of following elements (OrganizationValidation.java)

...

Code Block
 
Response
Code Block
 

 

Java Client Example

Code Block
 

...

IndexParameterDescriptionRequired?Data Type (max length)Example
0fsLocationCodeFS Location CodeYesString(1)9
1fsDepartmentCodeFS DepartmentCodeNoString(4)0302

DB Query

Code Block
SELECTSELECT 
FIN_COA_CD, 
ORG_CD, 
UC_LOC_CD, 
UC_HIERARCHY_CD, 
UC_HIERARCHY_TYPE_CDCD 
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_TYPE_CD='0003') OR
(UC_LOC_CD='0' AND UC_HIERARCHY_CD='D0000')
);

Result Schema: A list of following elements (FS2KFSOrganizationDetails.java)

...

Code Block
 
Response
 
Code Block
 

Java Client Example

Code Block
 

...