Page Comparison

Table of Contents

Usage

Dev WSDL location: https://thea.adcom.uci.edu/WebServices/DWHServer?wsdl

Dev Endpoint: https://thea.adcom.uci.edu/WebServices/DWHServer

Detail table: PK (vndr_hdr_gnrtd_id + vndr_dtl_asnd_id)

...

1 (vndr_hdr_gnrtd_id + vndr_dtl_asnd_id) has N (vndr_addr_gnrtd_id)

...

isValidKFSVendors(List of (kfsVendorHeaderId, kfsVendorDetailId) )

Input Specifications

Index	Parameter	Description	Required?	Data Type (max length)	Example
0	kfsVendorHeaderId	Vendor Header Generated ID	Y	String (10)	11261058
1	kfsVendorDetailId	Vendor Detail Assigned ID	Y	String (10)	10

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, 
       'true' AS VALID
FROM PUR_VNDR_DTL_T a
WHERE
(
(a.vndr_hdr_gnrtd_id = '11261058' AND a.vndr_dtl_asnd_id = '10') OR 
(a.vndr_hdr_gnrtd_id = '11271059' AND a.vndr_dtl_asnd_id = '10') OR
(a.vndr_hdr_gnrtd_id = '0000' AND a.vndr_dtl_asnd_id = '01')
);

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

DB Parameter	Java Parameter	Description	Data Type	Example
vndr_hdr_gnrtd_id	kfsVendorHeaderId	Vendor Header Generated ID	String	11261058
vndr_dtl_asnd_id	kfsVendorDetailId	Vendor Detail Assigned ID	String	10
VALID	isValid	is Vendor 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:isValidKFSVendors>
         <kfsVendorList>
            <item>1126<<kfsVendorDetailId>0</item>kfsVendorDetailId>
            <item>1<<kfsVendorHeaderId>1058</item>kfsVendorHeaderId>
         </kfsVendorList>
         <kfsVendorList>
            <item>1127<<kfsVendorDetailId>0</item>kfsVendorDetailId>
            <item>1<<kfsVendorHeaderId>1059</item>kfsVendorHeaderId>
         </kfsVendorList>
         <kfsVendorList>
            <item>0000<<kfsVendorDetailId>1</item>kfsVendorDetailId>
            <item>0<<kfsVendorHeaderId>0000</item>kfsVendorHeaderId>
         </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>1</kfsVendorDetailId>
            <kfsVendorHeaderId>0000</kfsVendorHeaderId>
            <valid>false</valid>
         </return>
         <return>
            <kfsVendorDetailId>1<<kfsVendorDetailId>0</kfsVendorDetailId>
            <kfsVendorHeaderId>1126<<kfsVendorHeaderId>1059</kfsVendorHeaderId>
            <valid>true</valid>
         </return>
         <return>
            <kfsVendorDetailId>1<<kfsVendorDetailId>0</kfsVendorDetailId>
            <kfsVendorHeaderId>1127<<kfsVendorHeaderId>1058</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)

...

DWHServerService dss = new DWHServerService();
DWHServer ds = dss.getDWHServerPort();

ArrayList<VendorParameters> pl30 = new ArrayList<VendorParameters>();
VendorParameters vp300 = new VendorParameters();
vp300.setKfsVendorHeaderId("1058");
vp300.setKfsVendorDetailId("0");
VendorParameters vp301 = new VendorParameters();
vp301.setKfsVendorHeaderId("1059");
vp301.setKfsVendorDetailId("0");
VendorParameters vp302 = new VendorParameters();
vp302.setKfsVendorHeaderId("0000");
vp302.setKfsVendorDetailId("1");
pl30.add(vp300);
pl30.add(vp301);
pl30.add(vp302);
List<VendorValidation> resultList30 = ds.isValidKFSVendors(pl30);
if (resultList30 != null) {
	for (Iterator i = resultList30.iterator(); i.hasNext();) {
		VendorValidation element = (VendorValidation) i.next();
		System.out.println("\t" + element.getKfsVendorHeaderId() + "/" + element.getKfsVendorDetailId() + " : " + element.isValid());
	}
} else {
	System.out.println("something bad happened...please check your query");
}

...

getValidKFSVendors(List of (kfsVendorHeaderId, kfsVendorDetailId) )

Input Specifications

Index	Parameter	Description	Required?	Data Type (max length)	Example
0	kfsVendorHeaderId	Vendor Header Generated ID	Y	String	1126	vndr_dtl_asnd_id	(10)	1058
1	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

...

Y

String(10)

0

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>    a.vndr_duns_nbr
FROM PUR_VNDR_DTL_T a 
WHERE 
(
 <item>1126</item>
            <item>1</item>
         </kfsVendorList>
         <kfsVendorList>
            <item>1127</item>
            <item>1</item>
         </kfsVendorList>
         (a.vndr_hdr_gnrtd_id = '1058' AND a.vndr_dtl_asnd_id = '0') OR 
(a.vndr_hdr_gnrtd_id = '1059' AND a.vndr_dtl_asnd_id = '0') OR
(a.vndr_hdr_gnrtd_id = '0000' AND a.vndr_dtl_asnd_id = '1')
);

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>0000<<kfsVendorDetailId>0</item>kfsVendorDetailId>
            <item>0<<kfsVendorHeaderId>1058</item>kfsVendorHeaderId>
         </kfsVendorList>
         <kfsVendorList>
 </adc:getValidKFSVendors>          </soapenv:Body> </soapenv:Envelope>

Response

Code Block

<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"><kfsVendorDetailId>0</kfsVendorDetailId>
    <soap:Body>       <ns2:getValidKFSVendorsResponse xmlns:ns2="http://www.adcom.uci.edu"> <kfsVendorHeaderId>1059</kfsVendorHeaderId>
         <return></kfsVendorList>
         <kfsVendorList>
  <kfsVendorDUNSNumber>0</kfsVendorDUNSNumber>
            <kfsVendorDetailId>1</kfsVendorDetailId>
            <kfsVendorHeaderId>1126<<kfsVendorHeaderId>0000</kfsVendorHeaderId>
            <kfsVendorName>CORNELL UNIVERSITY-ILR</kfsVendorName></kfsVendorList>
      </adc:getValidKFSVendors>
   </soapenv:Body>
</return>
soapenv:Envelope>

Response

Code Block

<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
   <soap:Body>
    <return>  <ns2:getValidKFSVendorsResponse xmlns:ns2="http://www.adcom.uci.edu">
         <kfsVendorDUNSNumber>0</kfsVendorDUNSNumber><return>
            <kfsVendorDetailId>1<<kfsVendorDetailId>0</kfsVendorDetailId>
            <kfsVendorHeaderId>1127<<kfsVendorHeaderId>1058</kfsVendorHeaderId>
            <kfsVendorName>THE CENTER QUICKPRINT<<kfsVendorName>GEORGE G BOGHOSSIAN &amp; ASSOCIATES, INC</kfsVendorName>
         </return>
      </ns2:getValidKFSVendorsResponse>   <return>
</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, <kfsVendorDetailId>0</kfsVendorDetailId>
            a.vndr_nm,<kfsVendorHeaderId>1059</kfsVendorHeaderId>
       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>  <kfsVendorName>NATIONAL CONSUMER VOICE FOR QUALITY</kfsVendorName>
         </return>
      <adc:getAllKFSVendors/></ns2:getValidKFSVendorsResponse>
   </soapenvsoap:Body>
</soapenvsoap:Envelope>

...

Java Client Example

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>
   DWHServerService dss = new DWHServerService();
DWHServer ds = dss.getDWHServerPort();

ArrayList<VendorParameters> pl30 = new ArrayList<VendorParameters>();
VendorParameters vp300 = new VendorParameters();
vp300.setKfsVendorHeaderId("1058");
vp300.setKfsVendorDetailId("0");
VendorParameters vp301 = new VendorParameters();
vp301.setKfsVendorHeaderId("1059");
vp301.setKfsVendorDetailId("0");
VendorParameters vp302 = new VendorParameters();
vp302.setKfsVendorHeaderId("0000");
vp302.setKfsVendorDetailId("1");
pl30.add(vp300);
pl30.add(vp301);
pl30.add(vp302);
List<VendorDetails> resultList31 = ds.getValidKFSVendors(pl30);
if (resultList31 != null) {
	for (Iterator i = resultList31.iterator(); i.hasNext();) {
		VendorDetails element = (VendorDetails) i.next();
		System.out.println("\t" + element.getKfsVendorHeaderId() + "/" + element.getKfsVendorDetailId() + " : " + element.getKfsVendorName() + "/" + element.getKfsVendorDUNSNumber());
	}
} 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,
        <kfsVendorDetailId>0</kfsVendorDetailId>
            <kfsVendorHeaderId>1125</kfsVendorHeaderId>
            <kfsVendorName>AJAX SIGN GRAPHICS, INC</kfsVendorName>
         </return>

         ...
         ...
      </ns2:getAllKFSVendorsResponse>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/>
   </soapsoapenv:Body>
</soapsoapenv: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

...

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>
         <kfsVendorAddressList>21626<</kfsVendorAddressList>return>
         <return>
<kfsVendorAddressList>21627</kfsVendorAddressList>            <kfsVendorAddressList>0000<<kfsVendorDUNSNumber>0</kfsVendorAddressList>kfsVendorDUNSNumber>
        </adc:isValidKFSVendorAddresses>    </soapenv:Body>
</soapenv:Envelope>

Response

Code Block

<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"><kfsVendorDetailId>0</kfsVendorDetailId>
       <soap:Body>     <kfsVendorHeaderId>1125</kfsVendorHeaderId>
 <ns2:isValidKFSVendorAddressesResponse xmlns:ns2="http://www.adcom.uci.edu">          <return><kfsVendorName>AJAX SIGN GRAPHICS, INC</kfsVendorName>
         <kfsVendorAddrId>0000<</kfsVendorAddrId>return>

         ...
 <valid>false</valid>          </return>...
      </ns2:getAllKFSVendorsResponse>
   <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

</soap:Body>
</soap:Envelope>

Java Client Example

Code Block

DWHServerService dss = new DWHServerService();
DWHServer ds = dss.getDWHServerPort();


System.out.println("\nWSClient--getAllKFSVendors()================================");
List<VendorDetails> resultList30 = ds.getAllKFSVendors();
if (resultList30 != null) {
	System.out.println("getAllVendor-total size: " + resultList30.size());
	System.out.println("getAllVendor-1st item HeaderId / DetailId : VendorName / DUNSNumber" + ((VendorDetails)resultList30.get(0)).getKfsVendorHeaderId() + "/" + ((VendorDetails)resultList30.get(0)).getKfsVendorDetailId() + " : " + ((VendorDetails)resultList30.get(0)).getKfsVendorName() + "/" + ((VendorDetails)resultList30.get(0)).getKfsVendorDUNSNumber());
} 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	kfsVendorHeaderIdkfsVendorAddrId	Vendor Header Address Generated ID	Y	String(10)	1007
1	kfsVendorDetailId	Vendor Detail Assigned ID	Y	String(10)	0
2	kfsVendorAddrType	Vendor Address Type	Y	String	PO
4110

DB Query

Code Block

SELECT 
CONVERT(varchar(10), VNDRa.vndr_HDRaddr_GNRTDgnrtd_IDid) AS VNDRvndr_HDRaddr_GNRTDgnrtd_IDid,
CONVERT(varchar(10), VNDR_DTL_ASND_ID) AS VNDR_DTL_ASND_ID,
'true' AS VALID
FROM PUR_VNDR_ADDR_TYP_CD, 
CONVERT(varchar(10), T a 
WHERE a.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>IN ('4100', '4111', '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	4100
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>
            <kfsVendorAddressId>4110</kfsVendorAddressId>
         </kfsVendorAddressList>
         <kfsVendorAddressList>
            <kfsVendorAddressId>4111</kfsVendorAddressId>
         </kfsVendorAddressList>
         <kfsVendorAddressList>
            <kfsVendorAddressId>0000</kfsVendorAddressId>
         </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>
<kfsVendorAddressList>             <item>1007<<kfsVendorAddrId>4111</item>kfsVendorAddrId>
            <item>0<<valid>true</item>valid>
         </return>
  <item>PO</item>       <return>
  </kfsVendorAddressList>          <kfsVendorAddressList><kfsVendorAddrId>4110</kfsVendorAddrId>
            <item>1007<<valid>true</item>valid>
         </return>
  <item>0</item>    </ns2:isValidKFSVendorAddressesResponse>
        <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</soap:Body> </soap:Envelope>

Java Client Example

Code Block

DWHServerService dss = new DWHServerService();
DWHServer ds = dss.getDWHServerPort();

ArrayList<VendorParameters> pl33 = new ArrayList<VendorParameters>();
VendorParameters vp330 = new VendorParameters();
vp330.setKfsVendorAddressId("4110");
VendorParameters vp331 = new VendorParameters();
vp331.setKfsVendorAddressId("4111");
VendorParameters vp332 = new VendorParameters();
vp332.setKfsVendorAddressId("0000");
pl33.add(vp330);
pl33.add(vp331);
pl33.add(vp332);
List<VendorAddressValidation> resultList33 = ds.isValidKFSVendorAddresses(pl33);
if (resultList33 != null) {
	for (Iterator i = resultList33.iterator(); i.hasNext();) {
		VendorAddressValidation element = (VendorAddressValidation) i.next();
		System.out.println("\t" + element.getKfsVendorAddrId() + " : " + element.isValid());
	}
} else {
	System.out.println("something bad happened...please check your query");
}

...

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)	1340
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 = '1340' AND VNDR_DTL_ASND_ID = '0' AND VNDR_ADDR_TYP_CD='PO') OR 
(VNDR_HDR_GNRTD_ID = '2325' AND VNDR_DTL_ASND_ID = '53' AND VNDR_ADDR_TYP_CD='PO') 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/">
   <soap:Body>
      <ns2:getValidKFSVendorAddressesResponse xmlns:ns2/envelope/" xmlns:adc="http://www.adcom.uci.edu">
   <soapenv:Header/>
   <soapenv:Body>
  <return>    <adc:getValidKFSVendorAddresses>
         <kfsVendorAddressList>
     <kfsVendorAddr1>338   SO. 4TH STREET</kfsVendorAddr1>  <kfsVendorAddrType>PO</kfsVendorAddrType>
          <kfsVendorAddr2>P.O. BOX 446<<kfsVendorDetailId>0</kfsVendorAddr2>kfsVendorDetailId>
            <kfsVendorAddrId>21633</kfsVendorAddrId><kfsVendorHeaderId>1340</kfsVendorHeaderId>
         </kfsVendorAddressList>
       <kfsVendorAddrType>PO</kfsVendorAddrType>  <kfsVendorAddressList>
          <kfsVendorCity>GROVER  CITY<<kfsVendorAddrType>PO</kfsVendorCity>kfsVendorAddrType>
            <kfsVendorCountry>US<<kfsVendorDetailId>53</kfsVendorCountry>kfsVendorDetailId>
            <kfsVendorDetailId>0<<kfsVendorHeaderId>2325</kfsVendorDetailId>kfsVendorHeaderId>
         </kfsVendorAddressList>
  <kfsVendorHeaderId>1007</kfsVendorHeaderId>       <kfsVendorAddressList>
     <kfsVendorState>CA</kfsVendorState>       <kfsVendorAddrType>XX</kfsVendorAddrType>
     <kfsVendorZip>93483-0446</kfsVendorZip>       <kfsVendorDetailId>0</kfsVendorDetailId>
  </return>          <return><kfsVendorHeaderId>00000</kfsVendorHeaderId>
         </kfsVendorAddressList>
  <kfsVendorAddr1>PO BOX 446</kfsVendorAddr1>  </adc:getValidKFSVendorAddresses>
   </soapenv:Body>
      <kfsVendorAddr2></kfsVendorAddr2></soapenv:Envelope>

Response

Code Block

<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
   <soap:Body>
        <kfsVendorAddrId>21634</kfsVendorAddrId><ns2:getValidKFSVendorAddressesResponse xmlns:ns2="http://www.adcom.uci.edu">
         <return>
  <kfsVendorAddrType>RM</kfsVendorAddrType>          <kfsVendorAddr1>49 RAILSIDE  <kfsVendorCity>GROVER BEACH</kfsVendorCity>ROAD</kfsVendorAddr1>
            <kfsVendorCountry>US<<kfsVendorAddr2/kfsVendorCountry>>
            <kfsVendorDetailId>0<<kfsVendorAddrId>4110</kfsVendorDetailId>kfsVendorAddrId>
            <kfsVendorHeaderId>1007<<kfsVendorAddrType>PO</kfsVendorHeaderId>kfsVendorAddrType>
            <kfsVendorState>CA</kfsVendorState>
         <kfsVendorCity>TORONTO</kfsVendorCity>
  <kfsVendorZip>93483-0446</kfsVendorZip>          <<kfsVendorCountry>CA</return>kfsVendorCountry>
          <return>  <kfsVendorDetailId>0</kfsVendorDetailId>
          <kfsVendorAddr1>ONE ZEISS DRIVE<<kfsVendorHeaderId>1340</kfsVendorAddr1>kfsVendorHeaderId>
            <kfsVendorAddr2><<kfsVendorState>ON</kfsVendorAddr2>kfsVendorState>
            <kfsVendorAddrId>21638</kfsVendorAddrId><kfsVendorZip>M3A  -1B3</kfsVendorZip>
          <kfsVendorAddrType>PO<</kfsVendorAddrType>return>
         <return>
  <kfsVendorCity>THORNWOOD</kfsVendorCity>          <kfsVendorAddr1>757 W. IVY <kfsVendorCountry>US<STREET</kfsVendorCountry>kfsVendorAddr1>
            <kfsVendorDetailId>3<<kfsVendorAddr2/kfsVendorDetailId>>
            <kfsVendorHeaderId>13788<<kfsVendorAddrId>4111</kfsVendorHeaderId>kfsVendorAddrId>
            <kfsVendorState>NY<<kfsVendorAddrType>PO</kfsVendorState>kfsVendorAddrType>
            <kfsVendorZip>10594-1939</kfsVendorZip><kfsVendorCity>SAN DIEGO</kfsVendorCity>
            <<kfsVendorCountry>US</return>kfsVendorCountry>
          <return>  <kfsVendorDetailId>53</kfsVendorDetailId>
          <kfsVendorAddr1>PO BOX 5943<<kfsVendorHeaderId>2325</kfsVendorAddr1>kfsVendorHeaderId>
            <kfsVendorAddr2><<kfsVendorState>CA</kfsVendorAddr2>kfsVendorState>
            <kfsVendorAddrId>21639</kfsVendorAddrId><kfsVendorZip>92101-1727</kfsVendorZip>
         </return>
      <kfsVendorAddrType>RM<</kfsVendorAddrType>ns2:getValidKFSVendorAddressesResponse>
   </soap:Body>
</soap:Envelope>

Java Client Example

Code Block

DWHServerService dss = new DWHServerService();
DWHServer ds = dss.getDWHServerPort();
<kfsVendorCity>NEW
YORK</kfsVendorCity>ArrayList<VendorParameters> pl34 = new ArrayList<VendorParameters>();
VendorParameters vp340 = new VendorParameters();
vp340.setKfsVendorHeaderId("1340");
vp340.setKfsVendorDetailId("0");
 <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

 vp340.setKfsVendorAddrType("PO");
VendorParameters vp341 = new VendorParameters();
vp341.setKfsVendorHeaderId("2325");
vp341.setKfsVendorDetailId("53");
vp341.setKfsVendorAddrType("PO");
VendorParameters vp342 = new VendorParameters();
vp342.setKfsVendorHeaderId("00000");
vp342.setKfsVendorDetailId("0");
vp342.setKfsVendorAddrType("XX");
pl34.add(vp340);
pl34.add(vp341);
pl34.add(vp342);
List<VendorAddressDetails> resultList34 = ds.getValidKFSVendorAddresses(pl34);
if (resultList34 != null) {
	for (Iterator i = resultList34.iterator(); i.hasNext();) {
		VendorAddressDetails element = (VendorAddressDetails) i.next();
		System.out.println("\t" + element.getKfsVendorHeaderId() + "/" + element.getKfsVendorDetailId() + "/" + element.getKfsVendorAddrType() + " : " + element.getKfsVendorAddrId() + "/" + element.getKfsVendorAddrId());
	}
} 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

translatePALVendors(PALVendorID)

Old Vendor Id is Alias Name (VNDR_ALIAS_NM) in Alias table (PUR_VNDR_ALIAS_T)

Input Specifications

Index	Parameter	Description	Required?	Data Type (max length)	Example
0	PALVendorID	Old PAL Vendor ID	Y	String(10)	0005923500

DB Query

Code Block

SELECT
/*a.VNDR_ALIAS_NM,*/
CONVERT(varchar(10), VNDR_HDR_GNRTD_ID) AS VNDR_HDR_GNRTD_ID,
CONVERT(varchar(10), VNDR_DTL_ASND_ID) AS VNDR_DTL_ASND_ID,
FROM PUR_VNDR_ALIAS_T 
WHERE 
DOBJ_MAINT_CD_ACTV_IND <> 'N' AND 
VNDR_ALIAS_NM = '0421835099';

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	20248
VNDR_DTL_ASND_ID	kfsVendorDetailId	Vendor Detail Assigned ID	String	0

WS Example

Request

Code Block

Response

Code Block

Java Client Example

Code Block

...

Version	Old Version 18	New Version Current
Changes made by	Adam Chang	Adam Chang
Saved on	Aug 01, 2012	Oct 24, 2012

Page Comparison

Versions Compared

Key

Usage

Dev WSDL location: https://thea.adcom.uci.edu/WebServices/DWHServer?wsdl

Dev Endpoint: https://thea.adcom.uci.edu/WebServices/DWHServer

isValidKFSVendors(List of (kfsVendorHeaderId, kfsVendorDetailId) )

Input Specifications

DB Query

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

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)

getValidKFSVendors(List of (kfsVendorHeaderId, kfsVendorDetailId) )

Input Specifications

WS Example

Request

DB Query

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

WS Example

Request

Response

Response

Java Client Example

getAllKFSVendors( )

DB Query

Result Schema: Same as getValidKFSVendors()

WS Example

Request

Java Client Example

getAllKFSVendors( )

DB Query

Result Schema: Same as getValidKFSVendors()

WS Example

Request

Java Client Example

isValidKFSVendorAddresses(List of (kfsVendorAddressId) )

Input Specifications

DB Query

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

WS Example

Request

Response

Response

Java Client Example

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

Java Client Example

isValidKFSVendorAddresses(List of (kfsVendorAddressId) )

Input Specifications

DB Query

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

WS Example

Request

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

WS Example

Request

Response

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

Java Client Example

translatePALVendors(PALVendorID)

Input Specifications

DB Query

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

WS Example

Request

Response