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

		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();) {
	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("SERVER UNIT TEST-Result List28\t" + element.getKfsVendorHeaderId() + "/" + element.getKfsVendorDetailId() + " : " + element.toStringisValid());
	}
} 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(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, 
       a.vndr_nm,
       a.vndr_duns_nbr
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 (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<<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: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<<kfsVendorDetailId>0</kfsVendorDUNSNumber>kfsVendorDetailId>
            <kfsVendorDetailId>1<<kfsVendorHeaderId>1058</kfsVendorDetailId>kfsVendorHeaderId>
            <kfsVendorHeaderId>1126</kfsVendorHeaderId><kfsVendorName>GEORGE G BOGHOSSIAN &amp;          <kfsVendorName>CORNELL UNIVERSITY-ILR<ASSOCIATES, INC</kfsVendorName>
         </return>
         <return>
            <kfsVendorDUNSNumber>0<<kfsVendorDetailId>0</kfsVendorDUNSNumber>kfsVendorDetailId>
            <kfsVendorDetailId>1<<kfsVendorHeaderId>1059</kfsVendorDetailId>kfsVendorHeaderId>
            <kfsVendorHeaderId>1127</kfsVendorHeaderId><kfsVendorName>NATIONAL CONSUMER VOICE           <kfsVendorName>THE CENTER QUICKPRINT<FOR QUALITY</kfsVendorName>
         </return>
      </ns2:getValidKFSVendorsResponse>
   </soap:Body>
</soap:Envelope>

Java Client Example

Code Block

System.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>
      <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>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, 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>1125<<kfsVendorHeaderId>1124</kfsVendorHeaderId>
            <kfsVendorName>AJAX SIGN GRAPHICS, INC</kfsVendorName>
         </return>
         <return>
      ...      <kfsVendorDUNSNumber>0</kfsVendorDUNSNumber>
   ...         </ns2:getAllKFSVendorsResponse><kfsVendorDetailId>0</kfsVendorDetailId>
            </soap:Body>
</soap:Envelope>

Java Client Example

Code Block

System.out.println("\n============<kfsVendorHeaderId>1125</kfsVendorHeaderId>
            <kfsVendorName>AJAX SIGN GRAPHICS, INC</kfsVendorName>
         </return>

         ...
         ...
      </ns2:getAllKFSVendorsResponse>
   </soap:Body>
</soap:Envelope>

Java Client Example

Code Block

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


System.out.println("\nWSClient--getAllKFSVendors()===========================getAllKFSVendors()================================");");
List<VendorDetails> resultList30 = myBeands.getAllKFSVendors();
if (resultList30 != null) {
	//for (Iterator i = resultList26.iterator(); i.hasNext();) {
	//	VendorDetails element = (VendorDetails)i.next();
	//	System.out.println("getAllVendor-total size: " + resultList30.size());
	System.out.println("SERVER UNIT TEST-Result List30: getAllVendor-1st item HeaderId / DetailId : VendorName / DUNSNumber" + element.toString());
	//}
	System.out.println("SERVER UNIT TEST-getAllKFSVendors() total size((VendorDetails)resultList30.get(0)).getKfsVendorHeaderId() + "/" + ((VendorDetails)resultList30.get(0)).getKfsVendorDetailId() + " : " + ((VendorDetails)resultList30.sizeget(0));
	System.out.println("SERVER UNIT TEST-getAllKFSVendors() 1st element: .getKfsVendorName() + "/" + ((VendorDetails)resultList30.get(0)).toStringgetKfsVendorDUNSNumber());
} 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)	216264110

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 ('216264100', '216274111', '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	216264100
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>
      <kfsVendorAddressList>21626</kfsVendorAddressList>      <kfsVendorAddressId>4110</kfsVendorAddressId>
         <kfsVendorAddressList>21627<</kfsVendorAddressList>
         <kfsVendorAddressList>0000</kfsVendorAddressList><kfsVendorAddressList>
            </adc:isValidKFSVendorAddresses><kfsVendorAddressId>4111</kfsVendorAddressId>
         </soapenv: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>
            <kfsVendorAddrId>21626<<kfsVendorAddrId>4111</kfsVendorAddrId>
            <valid>true</valid>
         </return>
         <return>
            <kfsVendorAddrId>21627<<kfsVendorAddrId>4110</kfsVendorAddrId>
            <valid>true</valid>
         </return>
      </ns2:isValidKFSVendorAddressesResponse>
   </soap:Body>
</soap:Envelope>

Java Client Example

Code Block

System.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");
}

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

...

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)	10071340
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 = '10071340' AND VNDR_DTL_ASND_ID = '0' AND VNDR_ADDR_TYP_CD='PO') OR 
(VNDR_HDR_GNRTD_ID = '10072325' AND VNDR_DTL_ASND_ID = '053' AND VNDR_ADDR_TYP_CD='RMPO') OR 
(VNDR_HDR_GNRTD_ID = '1378800000' AND VNDR_DTL_ASND_ID = '30' AND VNDR_ADDR_TYP_CD='POXX')
OR 
();

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

...

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

...

	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">
         <return>
            <kfsVendorAddr1>338 SO. 4TH STREET</kfsVendorAddr1>
            <kfsVendorAddr2>P.O. BOX 446</kfsVendorAddr2>
            <kfsVendorAddrId>21633</kfsVendorAddrId>
   .adcom.uci.edu">
   <soapenv:Header/>
   <soapenv:Body>
      <adc:getValidKFSVendorAddresses>
 <kfsVendorAddrType>PO</kfsVendorAddrType>         <kfsVendorAddressList>
   <kfsVendorCity>GROVER CITY</kfsVendorCity>             <kfsVendorCountry>US</kfsVendorCountry><kfsVendorAddrType>PO</kfsVendorAddrType>
            <kfsVendorDetailId>0</kfsVendorDetailId>
            <kfsVendorHeaderId>1007<<kfsVendorHeaderId>1340</kfsVendorHeaderId>
            <kfsVendorState>CA</kfsVendorState></kfsVendorAddressList>
         <kfsVendorAddressList>
  <kfsVendorZip>93483-0446</kfsVendorZip>          <<kfsVendorAddrType>PO</return>kfsVendorAddrType>
         <return>
            <kfsVendorAddr1>PO BOX 446</kfsVendorAddr1>       <kfsVendorDetailId>53</kfsVendorDetailId>
     <kfsVendorAddr2></kfsVendorAddr2>       <kfsVendorHeaderId>2325</kfsVendorHeaderId>
     <kfsVendorAddrId>21634</kfsVendorAddrId>    </kfsVendorAddressList>
        <kfsVendorAddrType>RM</kfsVendorAddrType> <kfsVendorAddressList>
           <kfsVendorCity>GROVER BEACH<<kfsVendorAddrType>XX</kfsVendorCity>kfsVendorAddrType>
            <kfsVendorCountry>US<<kfsVendorDetailId>0</kfsVendorCountry>kfsVendorDetailId>
            <kfsVendorDetailId>0<<kfsVendorHeaderId>00000</kfsVendorDetailId>kfsVendorHeaderId>
            <kfsVendorHeaderId>1007</kfsVendorHeaderId></kfsVendorAddressList>
      </adc:getValidKFSVendorAddresses>
   </soapenv:Body>
 <kfsVendorState>CA</kfsVendorState></soapenv:Envelope>

Response

Code Block

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

Java Client Example

Code Block

System.out.println("\n=======================================getValidKFSVendorAddresses()================================");
List<VendorAddressDetails> resultList32 = myBean.getValidKFSVendorAddresses(new String[][]{{"1007","0","PO"},{"1007","0","RM"},{"13788","3","PO"},{"13788","0","RM"},{"00000","0","XX"}});
if (resultList32DWHServerService dss = new DWHServerService();
DWHServer ds = dss.getDWHServerPort();

ArrayList<VendorParameters> pl34 = new ArrayList<VendorParameters>();
VendorParameters vp340 = new VendorParameters();
vp340.setKfsVendorHeaderId("1340");
vp340.setKfsVendorDetailId("0");
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 = resultList32resultList34.iterator(); i.hasNext();) {
		VendorAddressDetails element = (VendorAddressDetails) i.next();
		System.out.println("\t" + element.getKfsVendorHeaderId() + "/" + element.getKfsVendorDetailId("SERVER UNIT TEST-Result List32: ") + "/" + element.getKfsVendorAddrType() + " : " + element.getKfsVendorAddrId() + "/" + element.toStringgetKfsVendorAddrId());
	}
} 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 19	New Version Current
Changes made by	Adam Chang	Adam Chang
Saved on	Aug 03, 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)

WS Example

Request

Response

Java Client Example

getAllKFSVendors( )

DB Query

Result Schema: Same as getValidKFSVendors()

WS Example

Request

Response

getAllKFSVendors( )

DB Query

Result Schema: Same as getValidKFSVendors()

WS Example

Request

Response

Java Client Example

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

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

Input Specifications

DB Query

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

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

WS Example

Request

Response

WS Example

Request

Response

Java Client Example

translatePALVendors(PALVendorID)

Input Specifications

DB Query

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

WS Example

Request

Response

Java Client Example