Page Comparison

...

WS Example

Request

Code Block

Response

Code Block

Java Client Example

Code Block

getValidKFSVendors(List of (kfsVendorHeaderId, kfsVendorDetailId) )

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,<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:adc="http://www.adcom.uci.edu">
   <soapenv:Header/>
   <soapenv:Body>
      <adc:isValidKFSVendors>
       CONVERT(varchar(10), a.vndr_dtl_asnd_id) AS vndr_dtl_asnd_id,   <kfsVendorList>
         a.vndr_nm,   <item>1126</item>
    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

Response

Code Block

Java Client Example

Code Block

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

Response

Code Block

Java Client Example

Code Block

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

Response

Code Block

Java Client Example

Code Block

getValidKFSVendorAddresses(List of (kfsVendorHeaderId, kfsVendorDetailId, kfsVendorAddrType))

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' 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
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

Response

Code Block

  <item>1</item>
         </kfsVendorList>
         <kfsVendorList>
            <item>1127</item>
            <item>1</item>
         </kfsVendorList>
         <kfsVendorList>
            <item>0000</item>
            <item>0</item>
         </kfsVendorList>
      </adc:isValidKFSVendors>
   </soapenv:Body>
</soapenv:Envelope>

Response

Code Block

<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
   <soap:Body>
      <ns2:isValidKFSVendorsResponse xmlns:ns2="http://www.adcom.uci.edu">
         <return>
            <kfsVendorDetailId>0</kfsVendorDetailId>
            <kfsVendorHeaderId>0000</kfsVendorHeaderId>
            <valid>false</valid>
         </return>
         <return>
            <kfsVendorDetailId>1</kfsVendorDetailId>
            <kfsVendorHeaderId>1126</kfsVendorHeaderId>
            <valid>true</valid>
         </return>
         <return>
            <kfsVendorDetailId>1</kfsVendorDetailId>
            <kfsVendorHeaderId>1127</kfsVendorHeaderId>
            <valid>true</valid>
         </return>
      </ns2:isValidKFSVendorsResponse>
   </soap:Body>
</soap:Envelope>

Java Client Example

Code Block

...

getValidKFSVendors(List of (kfsVendorHeaderId, kfsVendorDetailId) )

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)

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>1126</item>
            <item>1</item>
         </kfsVendorList>
         <kfsVendorList>
            <item>1127</item>
            <item>1</item>
         </kfsVendorList>
         <kfsVendorList>
            <item>0000</item>
            <item>0</item>
         </kfsVendorList>
      </adc:getValidKFSVendors>
   </soapenv:Body>
</soapenv:Envelope>

Response

Code Block

<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
   <soap:Body>
      <ns2:getValidKFSVendorsResponse xmlns:ns2="http://www.adcom.uci.edu">
         <return>
            <kfsVendorDUNSNumber>0</kfsVendorDUNSNumber>
            <kfsVendorDetailId>1</kfsVendorDetailId>
            <kfsVendorHeaderId>1126</kfsVendorHeaderId>
            <kfsVendorName>CORNELL UNIVERSITY-ILR</kfsVendorName>
         </return>
         <return>
            <kfsVendorDUNSNumber>0</kfsVendorDUNSNumber>
            <kfsVendorDetailId>1</kfsVendorDetailId>
            <kfsVendorHeaderId>1127</kfsVendorHeaderId>
            <kfsVendorName>THE CENTER QUICKPRINT</kfsVendorName>
         </return>
      </ns2:getValidKFSVendorsResponse>
   </soap:Body>
</soap:Envelope>

Java Client Example

Code Block

...

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:ns2="http://www.adcom.uci.edu">
         <return>
            <kfsVendorDUNSNumber>0</kfsVendorDUNSNumber>
            <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

Code Block

...

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="http://schemas.xmlsoap.org/soap/envelope/">
   <soap:Body>
      <ns2:isValidKFSVendorAddressesResponse xmlns:ns2="http://www.adcom.uci.edu">
         <return>
            <kfsVendorAddrId>0000</kfsVendorAddrId>
            <valid>false</valid>
         </return>
         <return>
            <kfsVendorAddrId>21626</kfsVendorAddrId>
            <valid>true</valid>
         </return>
         <return>
            <kfsVendorAddrId>21627</kfsVendorAddrId>
            <valid>true</valid>
         </return>
      </ns2:isValidKFSVendorAddressesResponse>
   </soap:Body>
</soap:Envelope>

Java Client Example

Code Block

...

getValidKFSVendorAddresses(List of (kfsVendorHeaderId, kfsVendorDetailId, kfsVendorAddrType))

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' 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
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>PO</item>
         </kfsVendorAddressList>
         <kfsVendorAddressList>
            <item>1007</item>
            <item>0</item>
            <item>RM</item>
         </kfsVendorAddressList>
         <kfsVendorAddressList>
            <item>13788</item>
            <item>3</item>
            <item>PO</item>
         </kfsVendorAddressList>
         <kfsVendorAddressList>
            <item>13788</item>
            <item>0</item>
            <item>RM</item>
         </kfsVendorAddressList>
         <kfsVendorAddressList>
            <item>00000</item>
            <item>0</item>
            <item>XX</item>
         </kfsVendorAddressList>
      </adc:getValidKFSVendorAddresses>
   </soapenv:Body>
</soapenv:Envelope>

Response

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

...

Version	Old Version 17	New Version 18
Changes made by	Adam Chang	Adam Chang
Saved on	Jul 31, 2012	Aug 01, 2012

Page Comparison

Versions Compared

Key

WS Example

Request

Response

Java Client Example

getValidKFSVendors(List of (kfsVendorHeaderId, kfsVendorDetailId) )

Input Specifications

DB Query

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

WS Example

Request

Response

Java Client Example

getAllKFSVendors( )

DB Query

Result Schema: Same as getValidKFSVendors()

WS Example

Request

Response

Java Client Example

isValidKFSVendorAddresses(List of (kfsVendorAddressId) )

Input Specifications

DB Query

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

WS Example

Request

Response

Java Client Example

getValidKFSVendorAddresses(List of (kfsVendorHeaderId, kfsVendorDetailId, kfsVendorAddrType))

Input Specifications

DB Query

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

WS Example

Request

Response

Response

Java Client Example

getValidKFSVendors(List of (kfsVendorHeaderId, kfsVendorDetailId) )

Input Specifications

DB Query

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

WS Example

Request

Response

Java Client Example

getAllKFSVendors( )

DB Query

Result Schema: Same as getValidKFSVendors()

WS Example

Request

Response

Java Client Example

isValidKFSVendorAddresses(List of (kfsVendorAddressId) )

Input Specifications

DB Query

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

WS Example

Request

Response

Java Client Example

getValidKFSVendorAddresses(List of (kfsVendorHeaderId, kfsVendorDetailId, kfsVendorAddrType))

Input Specifications

DB Query

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

WS Example

Request

Response

Java Client Example