...
Java Client Example
Input Specifications
Index | Parameter | Description | Required? | Data Type (max length) | Example |
---|
0 | kfsVendorHeaderId | Vendor Header Generated ID | Y | String(10) | 1126 |
1 | kfsVendorDetailId | Vendor Detail Assigned ID | Y | String(10) | 1 |
DB Query
Code Block |
---|
SELECT CONVERT(varchar(10), a.vndr_hdr_gnrtd_id) AS vndr_hdr_gnrtd_id,
CONVERT(varchar(10), a.vndr_dtl_asnd_id) AS vndr_dtl_asnd_id,
a.vndr_nm,
a.vndr_duns_nbr
FROM PUR_VNDR_DTL_T a
WHERE
(
(a.vndr_hdr_gnrtd_id = '1126' AND a.vndr_dtl_asnd_id = '1') OR
(a.vndr_hdr_gnrtd_id = '1127' AND a.vndr_dtl_asnd_id = '1') OR
(a.vndr_hdr_gnrtd_id = '0000' AND a.vndr_dtl_asnd_id = '0')
); |
Result Schema: A list of following elements (VendorDetails.java)
...
vndr_hdr_gnrtd_id
...
System.out.println("\n=======================================isValidKFSVendors()================================");
List<VendorValidation> resultList28 = myBean.isValidKFSVendors(new String[][]{{"1126","1"},{"1127","1"},{"0000","0"}});
if (resultList28 != null) {
for (Iterator i = resultList28.iterator(); i.hasNext();) {
VendorValidation element = (VendorValidation)i.next();
System.out.println("SERVER UNIT TEST-Result List28: " + element.toString());
}
} else {
System.out.println("something bad happened...please check your query");
} |
...
Input Specifications
Index | Parameter | Description | Required? | Data Type (max length) | Example |
---|
0 | kfsVendorHeaderId | Vendor Header Generated ID | Y | String(10) | 1126 |
1 | kfsVendorDetailId | Vendor Detail Assigned ID | Y | String(10) | 1 |
vndr_nm | kfsVendorName | Vendor Name | String | CORNELL UNIVERSITY-ILR |
vndr_duns_nbr | kfsVendorDUNSNumber | Vendor DUNS Number | String | 0 |
WS Example
Request
...
DB Query
Code Block |
---|
SELECT CONVERT(varchar(10), a.vndr_hdr_gnrtd_id) AS vndr_hdr_gnrtd_id,
CONVERT(varchar(10), a.vndr_dtl_asnd_id) AS vndr_dtl_asnd_id,
a.vndr_nm,
<kfsVendorList>
<item>1126</item>
<item>1</item>
</kfsVendorList>
a.vndr_duns_nbr
FROM PUR_VNDR_DTL_T a
WHERE
(
(a.vndr_hdr_gnrtd_id = '1126' AND a.vndr_dtl_asnd_id = '1') OR
(a.vndr_hdr_gnrtd_id = '1127' AND a.vndr_dtl_asnd_id = '1') OR
(a.vndr_hdr_gnrtd_id = '0000' AND a.vndr_dtl_asnd_id = '0')
); |
Result Schema: A list of following elements (VendorDetails.java)
DB Parameter | Java Parameter | Description | Data Type | Example |
---|
vndr_hdr_gnrtd_id | kfsVendorHeaderId | Vendor Header Generated ID | String | 1126 |
vndr_dtl_asnd_id | kfsVendorDetailId | Vendor Detail Assigned ID | String | 1 |
vndr_nm | kfsVendorName | Vendor Name | String | CORNELL UNIVERSITY-ILR |
vndr_duns_nbr | kfsVendorDUNSNumber | Vendor DUNS Number | String | 0 |
WS Example
Request
Code Block |
---|
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:adc="http://www.adcom.uci.edu">
<soapenv:Header/>
<soapenv:Body>
<adc:getValidKFSVendors>
<kfsVendorList>
<item>1127<<item>1126</item>
<item>1</item>
</kfsVendorList>
<kfsVendorList>
<item>0000<<item>1127</item>
<item>0<<item>1</item>
</kfsVendorList>
</adc:getValidKFSVendors> <kfsVendorList>
<item>0000</item>
<item>0</item>
</kfsVendorList>
</adc:getValidKFSVendors>
</soapenv:Body>
</soapenv:Envelope> |
...
Java Client Example
getAllKFSVendors( )
DB Query
Code Block |
---|
SELECT CONVERT(varchar(10), a.vndr_hdr_gnrtd_id) AS vndr_hdr_gnrtd_id,
CONVERT(varchar(10), a.vndr_dtl_asnd_id) AS vndr_dtl_asnd_id,
a.vndr_nm,
a.vndr_duns_nbr
FROM PUR_VNDR_DTL_T a; |
Result Schema: Same as getValidKFSVendors()
WS Example
Request
Code Block |
---|
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:adc="http://www.adcom.uci.edu">
<soapenv:Header/>
<soapenv:Body>
<adc:getAllKFSVendors/>
</soapenv:Body>
</soapenv:Envelope> |
Response
Code Block |
---|
<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
<soap:Body>
<ns2:getAllKFSVendorsResponse xmlns:ns2System.out.println("\n=======================================getValidKFSVendors()================================");
List<VendorDetails> resultList29 = myBean.getValidKFSVendors(new String[][]{{"1126","1"},{"1127","1"},{"0000","0"}});
if (resultList29 != null) {
for (Iterator i = resultList29.iterator(); i.hasNext();) {
VendorDetails element = (VendorDetails)i.next();
System.out.println("SERVER UNIT TEST-Result List29: " + element.toString());
}
} else {
System.out.println("something bad happened...please check your query");
} |
...
getAllKFSVendors( )
DB Query
Code Block |
---|
SELECT CONVERT(varchar(10), a.vndr_hdr_gnrtd_id) AS vndr_hdr_gnrtd_id,
CONVERT(varchar(10), a.vndr_dtl_asnd_id) AS vndr_dtl_asnd_id,
a.vndr_nm,
a.vndr_duns_nbr
FROM PUR_VNDR_DTL_T a; |
Result Schema: Same as getValidKFSVendors()
WS Example
Request
Code Block |
---|
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:adc="http://www.adcom.uci.edu">
<soapenv:Header/>
<soapenv:Body>
<return> <adc:getAllKFSVendors/>
<kfsVendorDUNSNumber>0</kfsVendorDUNSNumber></soapenv:Body>
</soapenv:Envelope> |
Response
Code Block |
---|
<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
<soap:Body>
<ns2:getAllKFSVendorsResponse <kfsVendorDetailId>0</kfsVendorDetailId>xmlns:ns2="http://www.adcom.uci.edu">
<return>
<kfsVendorHeaderId>1124</kfsVendorHeaderId> <kfsVendorDUNSNumber>0</kfsVendorDUNSNumber>
<kfsVendorName>AJAX SIGN GRAPHICS, INC</ <kfsVendorDetailId>0</kfsVendorDetailId>
<kfsVendorHeaderId>1124</kfsVendorHeaderId>
<kfsVendorName>AJAX SIGN GRAPHICS, INC</kfsVendorName>
</return>
<return>
<kfsVendorDUNSNumber>0</kfsVendorDUNSNumber>
<kfsVendorDetailId>0</kfsVendorDetailId>
<kfsVendorHeaderId>1125</kfsVendorHeaderId>
<kfsVendorName>AJAX SIGN GRAPHICS, INC</kfsVendorName>
</return>
...
...
</ns2:getAllKFSVendorsResponse>
</soap:Body>
</soap:Envelope> |
Java Client Example
isValidKFSVendorAddresses(List of (kfsVendorAddressId) )
Input Specifications
Index | Parameter | Description | Required? | Data Type (max length) | Example |
---|
0 | kfsVendorAddrId | Vendor Address Generated ID | Y | String(10) | 21626 |
DB Query
Code Block |
---|
SELECT
CONVERT(varchar(10), a.vndr_addr_gnrtd_id) AS vndr_addr_gnrtd_id,
'true' AS VALID
FROM PUR_VNDR_ADDR_T a
WHERE a.VNDR_ADDR_GNRTD_ID IN ('21626', '21627', '0000'); |
Result Schema: A list of following elements (VendorAddressValidation.java)
DB Parameter | Java Parameter | Description | Data Type | Example |
---|
vndr_addr_gnrtd_id | kfsVendorAddrId | Vendor Address Generated ID | String | 21626 |
VALID | isValid | is Vendor Address ID valid | boolean | true |
WS Example
Request
Code Block |
---|
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:adc="http://www.adcom.uci.edu">
<soapenv:Header/>
<soapenv:Body>
<adc:isValidKFSVendorAddresses>
<kfsVendorAddressList>21626</kfsVendorAddressList>
<kfsVendorAddressList>21627</kfsVendorAddressList>
<kfsVendorAddressList>0000</kfsVendorAddressList>
</adc:isValidKFSVendorAddresses>
</soapenv:Body>
</soapenv:Envelope> |
Response
Code Block |
---|
<soap:Envelope xmlns:soap="httpSystem.out.println("\n=======================================getAllKFSVendors()================================");
List<VendorDetails> resultList30 = myBean.getAllKFSVendors();
if (resultList30 != null) {
//for (Iterator i = resultList26.iterator(); i.hasNext();) {
// VendorDetails element = (VendorDetails)i.next();
// System.out.println("SERVER UNIT TEST-Result List30: " + element.toString());
//}
System.out.println("SERVER UNIT TEST-getAllKFSVendors() total size: " + resultList30.size());
System.out.println("SERVER UNIT TEST-getAllKFSVendors() 1st element: " + resultList30.get(0).toString());
} else {
System.out.println("something bad happened...please check your query");
} |
...
isValidKFSVendorAddresses(List of (kfsVendorAddressId) )
Input Specifications
Index | Parameter | Description | Required? | Data Type (max length) | Example |
---|
0 | kfsVendorAddrId | Vendor Address Generated ID | Y | String(10) | 21626 |
DB Query
Code Block |
---|
SELECT
CONVERT(varchar(10), a.vndr_addr_gnrtd_id) AS vndr_addr_gnrtd_id,
'true' AS VALID
FROM PUR_VNDR_ADDR_T a
WHERE a.VNDR_ADDR_GNRTD_ID IN ('21626', '21627', '0000'); |
Result Schema: A list of following elements (VendorAddressValidation.java)
DB Parameter | Java Parameter | Description | Data Type | Example |
---|
vndr_addr_gnrtd_id | kfsVendorAddrId | Vendor Address Generated ID | String | 21626 |
VALID | isValid | is Vendor Address ID valid | boolean | true |
WS Example
Request
Code Block |
---|
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/"> <soap:Body>
<ns2:isValidKFSVendorAddressesResponse xmlns:ns2adc="http://www.adcom.uci.edu">
<soapenv:Header/>
<soapenv:Body>
<return> <adc:isValidKFSVendorAddresses>
<kfsVendorAddrId>0000</kfsVendorAddrId> <kfsVendorAddressList>21626</kfsVendorAddressList>
<valid>false<<kfsVendorAddressList>21627</valid>kfsVendorAddressList>
<<kfsVendorAddressList>0000</return>kfsVendorAddressList>
</adc:isValidKFSVendorAddresses>
<return> </soapenv:Body>
</soapenv:Envelope> |
Response
Code Block |
---|
<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
<soap:Body>
<kfsVendorAddrId>21626</kfsVendorAddrId> <ns2:isValidKFSVendorAddressesResponse xmlns:ns2="http://www.adcom.uci.edu">
<return>
<kfsVendorAddrId>0000</kfsVendorAddrId>
<valid>true< <valid>false</valid>
</return>
<return>
<kfsVendorAddrId>21627<<kfsVendorAddrId>21626</kfsVendorAddrId>
<valid>true</valid>
</return>
<return>
</ns2:isValidKFSVendorAddressesResponse> </soap:Body>
</soap:<kfsVendorAddrId>21627</kfsVendorAddrId>
<valid>true</valid>
</return>
</ns2:isValidKFSVendorAddressesResponse>
</soap:Body>
</soap:Envelope> |
Java Client Example
Relationship between Vendor and Address is 1:Many, but only get the default one
Input Specifications
Index | Parameter | Description | Required? | Data Type (max length) | Example |
---|
0 | kfsVendorHeaderId | Vendor Header Generated ID | Y | String(10) | 1007 |
1 | kfsVendorDetailId | Vendor Detail Assigned ID | Y | String(10) | 0 |
2 | kfsVendorAddrType | Vendor Address Type | Y | String | PO |
DB Query
Code Block |
---|
SELECT
CONVERT(varchar(10), VNDR_HDR_GNRTD_ID) AS VNDR_HDR_GNRTD_ID,
CONVERT(varchar(10), VNDR_DTL_ASND_ID) AS VNDR_DTL_ASND_ID,
VNDR_ADDR_TYP_CD,
CONVERT(varchar(10), VNDR_ADDR_GNRTD_ID) AS VNDR_ADDR_GNRTD_ID,
VNDR_LN1_ADDR,
VNDR_LN2_ADDR,
VNDR_CTY_NM,
VNDR_ST_CD,
VNDR_ZIP_CD,
VNDR_CNTRY_CD
FROM pur_vndr_addr_t
WHERE VNDR_DFLT_ADDR_IND <> 'N' AND
(
(VNDR_HDR_GNRTD_ID = '1007' AND VNDR_DTL_ASND_ID = '0' AND VNDR_ADDR_TYP_CD='PO') OR
(VNDR_HDR_GNRTD_ID = '1007' AND VNDR_DTL_ASND_ID = '0' AND VNDR_ADDR_TYP_CD='RM') OR
(VNDR_HDR_GNRTD_ID = '13788' AND VNDR_DTL_ASND_ID = '3' ANDSystem.out.println("\n=======================================isValidKFSVendorAddresses()================================");
List<VendorAddressValidation> resultList31 = myBean.isValidKFSVendorAddresses(new String[]{"21626","21627","0000"});
if (resultList31 != null) {
for (Iterator i = resultList31.iterator(); i.hasNext();) {
VendorAddressValidation element = (VendorAddressValidation)i.next();
System.out.println("SERVER UNIT TEST-Result List31: " + element.toString());
}
} else {
System.out.println("something bad happened...please check your query");
}
|
...
Relationship between Vendor and Address is 1:Many, but only get the default one
Input Specifications
Index | Parameter | Description | Required? | Data Type (max length) | Example |
---|
0 | kfsVendorHeaderId | Vendor Header Generated ID | Y | String(10) | 1007 |
1 | kfsVendorDetailId | Vendor Detail Assigned ID | Y | String(10) | 0 |
2 | kfsVendorAddrType | Vendor Address Type | Y | String | PO |
DB Query
Code Block |
---|
SELECT
CONVERT(varchar(10), VNDR_HDR_GNRTD_ID) AS VNDR_HDR_GNRTD_ID,
CONVERT(varchar(10), VNDR_DTL_ASND_ID) AS VNDR_DTL_ASND_ID,
VNDR_ADDR_TYP_CD='PO'), OR
CONVERT(varchar(10), (VNDR_HDRADDR_GNRTD_ID = '13788' AND) AS VNDR_DTLADDR_ASNDGNRTD_ID = '0' AND VNDR_ADDR_TYP_CD='RM') OR
(VNDR_,
VNDR_LN1_ADDR,
VNDR_LN2_ADDR,
VNDR_CTY_NM,
VNDR_ST_CD,
VNDR_ZIP_CD,
VNDR_CNTRY_CD
FROM pur_vndr_addr_t
WHERE VNDR_DFLT_ADDR_IND <> 'N' AND
(
(VNDR_HDR_GNRTD_ID = '000001007' AND VNDR_DTL_ASND_ID = '0' AND VNDR_ADDR_TYP_CD='XXPO')
); |
Result Schema: A list of following elements (VendorAddressDetails.java)
...
...
= '1007' AND VNDR_DTL_ASND_ID |
...
= '0' AND VNDR_ADDR_TYP_CD |
...
vndr_addr_gnrtd_id
...
vndr_ln1_addr
...
vndr_ln2_addr
...
vndr_cty_nm
...
vndr_st_cd
...
vndr_zip_cd
...
vndr_cntry_cd
...
WS Example
Request
Code Block |
---|
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:adc="http://www.adcom.uci.edu">
<soapenv:Header/>
<soapenv:Body>
<adc:getValidKFSVendorAddresses>
<kfsVendorAddressList>
<item>1007</item>
<item>0</item>
<item>PO</item>
</kfsVendorAddressList>='RM') OR
(VNDR_HDR_GNRTD_ID = '13788' AND VNDR_DTL_ASND_ID = '3' AND VNDR_ADDR_TYP_CD='PO') OR
(VNDR_HDR_GNRTD_ID = '13788' AND VNDR_DTL_ASND_ID = '0' AND VNDR_ADDR_TYP_CD='RM') OR
(VNDR_HDR_GNRTD_ID = '00000' AND VNDR_DTL_ASND_ID = '0' AND VNDR_ADDR_TYP_CD='XX')
); |
Result Schema: A list of following elements (VendorAddressDetails.java)
DB Parameter | Java Parameter | Description | Data Type | Example |
---|
VNDR_HDR_GNRTD_ID | kfsVendorHeaderId | Vendor Header Generated Id | String | |
VNDR_DTL_ASND_ID | kfsVendorDetailId | Vendor Detailed Assigned Id | String | |
VNDR_ADDR_TYP_CD | kfsVendorAddrType | Vendor Address Type | String | |
vndr_addr_gnrtd_id | kfsVendorAddrId | Vendor Address Id | String | |
vndr_ln1_addr | kfsVendorAddr1 | Vendor Address Line 1 | String | |
vndr_ln2_addr | kfsVendorAddr2 | Vendor Address Line 2 | String | |
vndr_cty_nm | kfsVendorCity | Vendor City | String | |
vndr_st_cd | kfsVendorState | Vendor State | String | |
vndr_zip_cd | kfsVendorZip | Vendor Zip | String | |
vndr_cntry_cd | kfsVendorCountry | Vendor Country | String | |
WS Example
Request
Code Block |
---|
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:adc="http://www.adcom.uci.edu">
<soapenv:Header/>
<soapenv:Body>
<adc:getValidKFSVendorAddresses>
<kfsVendorAddressList>
<item>1007</item>
<item>0</item>
<item>RM<<item>PO</item>
</kfsVendorAddressList>
<kfsVendorAddressList>
<item>13788<<item>1007</item>
<item>3<<item>0</item>
<item>PO<<item>RM</item>
</kfsVendorAddressList>
<kfsVendorAddressList>
<item>13788</item>
<item>0<<item>3</item>
<item>RM<<item>PO</item>
</kfsVendorAddressList>
<kfsVendorAddressList>
<item>00000<<item>13788</item>
<item>0</item>
<item>XX<<item>RM</item>
</kfsVendorAddressList>
</ <kfsVendorAddressList>
<item>00000</item>
<item>0</item>
<item>XX</item>
</kfsVendorAddressList>
</adc:getValidKFSVendorAddresses>
</soapenv:Body>
</soapenv:Envelope> |
...
Code Block |
---|
<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
<soap:Body>
<ns2:getValidKFSVendorAddressesResponse xmlns:ns2="http://www.adcom.uci.edu">
<return>
<kfsVendorAddr1>338 SO. 4TH STREET</kfsVendorAddr1>
<kfsVendorAddr2>P.O. BOX 446</kfsVendorAddr2>
<kfsVendorAddrId>21633</kfsVendorAddrId>
<kfsVendorAddrType>PO</kfsVendorAddrType>
<kfsVendorCity>GROVER CITY</kfsVendorCity>
<kfsVendorCountry>US</kfsVendorCountry>
<kfsVendorDetailId>0</kfsVendorDetailId>
<kfsVendorHeaderId>1007</kfsVendorHeaderId>
<kfsVendorState>CA</kfsVendorState>
<kfsVendorZip>93483-0446</kfsVendorZip>
</return>
<return>
<kfsVendorAddr1>PO BOX 446</kfsVendorAddr1>
<kfsVendorAddr2></kfsVendorAddr2>
<kfsVendorAddrId>21634</kfsVendorAddrId>
<kfsVendorAddrType>RM</kfsVendorAddrType>
<kfsVendorCity>GROVER BEACH</kfsVendorCity>
<kfsVendorCountry>US</kfsVendorCountry>
<kfsVendorDetailId>0</kfsVendorDetailId>
<kfsVendorHeaderId>1007</kfsVendorHeaderId>
<kfsVendorState>CA</kfsVendorState>
<kfsVendorZip>93483-0446</kfsVendorZip>
</return>
<return>
<kfsVendorAddr1>ONE ZEISS DRIVE</kfsVendorAddr1>
<kfsVendorAddr2></kfsVendorAddr2>
<kfsVendorAddrId>21638</kfsVendorAddrId>
<kfsVendorAddrType>PO</kfsVendorAddrType>
<kfsVendorCity>THORNWOOD</kfsVendorCity>
<kfsVendorCountry>US</kfsVendorCountry>
<kfsVendorDetailId>3</kfsVendorDetailId>
<kfsVendorHeaderId>13788</kfsVendorHeaderId>
<kfsVendorState>NY</kfsVendorState>
<kfsVendorZip>10594-1939</kfsVendorZip>
</return>
<return>
<kfsVendorAddr1>PO BOX 5943</kfsVendorAddr1>
<kfsVendorAddr2></kfsVendorAddr2>
<kfsVendorAddrId>21639</kfsVendorAddrId>
<kfsVendorAddrType>RM</kfsVendorAddrType>
<kfsVendorCity>NEW YORK</kfsVendorCity>
<kfsVendorCountry>US</kfsVendorCountry>
<kfsVendorDetailId>0</kfsVendorDetailId>
<kfsVendorHeaderId>13788</kfsVendorHeaderId>
<kfsVendorState>NY</kfsVendorState>
<kfsVendorZip>10087-5943</kfsVendorZip>
</return>
</ns2:getValidKFSVendorAddressesResponse>
</soap:Body>
</soap:Envelope> |
Java Client Example
Code Block |
---|
System.out.println("\n=======================================getValidKFSVendorAddresses()================================");
List<VendorAddressDetails> resultList32 = <kfsVendorHeaderId>13788</kfsVendorHeaderId>
<kfsVendorState>NY</kfsVendorState>
<kfsVendorZip>10087-5943</kfsVendorZip>
</return>
</ns2:getValidKFSVendorAddressesResponse>
</soap:Body>
</soap:Envelope> |
Java Client Example
Code Block |
---|
myBean.getValidKFSVendorAddresses(new String[][]{{"1007","0","PO"},{"1007","0","RM"},{"13788","3","PO"},{"13788","0","RM"},{"00000","0","XX"}});
if (resultList32 != null) {
for (Iterator i = resultList32.iterator(); i.hasNext();) {
VendorAddressDetails element = (VendorAddressDetails)i.next();
System.out.println("SERVER UNIT TEST-Result List32: " + element.toString());
}
} else {
System.out.println("something bad happened...please check your query");
} |
...
ON HOLD...need to find out the link between old VendorID and new VendorID, right now the vendorAliasNm to (headerId + detailId) are many to many
...