DWH Web Services - KFS Vendor

Detail table: PK (vndr_hdr_gnrtd_id + vndr_dtl_asnd_id)

Address table: PK (vndr_addr_gnrtd_id)

Alias (old vendor) table: PK (vndr_alias_nm + 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)	1058
1	kfsVendorDetailId	Vendor Detail Assigned ID	Y	String (10)	0

DB Query

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 = '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 (VendorValidation.java)

DB Parameter	Java Parameter	Description	Data Type	Example
vndr_hdr_gnrtd_id	kfsVendorHeaderId	Vendor Header Generated ID	String	1058
vndr_dtl_asnd_id	kfsVendorDetailId	Vendor Detail Assigned ID	String	0
VALID	isValid	is Vendor valid	boolean	true

WS Example

Request

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:adc="http://www.adcom.uci.edu">
   <soapenv:Header/>
   <soapenv:Body>
      <adc:isValidKFSVendors>
         <kfsVendorList>
            <kfsVendorDetailId>0</kfsVendorDetailId>
            <kfsVendorHeaderId>1058</kfsVendorHeaderId>
         </kfsVendorList>
         <kfsVendorList>
            <kfsVendorDetailId>0</kfsVendorDetailId>
            <kfsVendorHeaderId>1059</kfsVendorHeaderId>
         </kfsVendorList>
         <kfsVendorList>
            <kfsVendorDetailId>1</kfsVendorDetailId>
            <kfsVendorHeaderId>0000</kfsVendorHeaderId>
         </kfsVendorList>
      </adc:isValidKFSVendors>
   </soapenv:Body>
</soapenv:Envelope>

Response

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

Java Client Example

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(10)	1058
1	kfsVendorDetailId	Vendor Detail Assigned ID	Y	String(10)	0

DB Query

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

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:adc="http://www.adcom.uci.edu">
   <soapenv:Header/>
   <soapenv:Body>
      <adc:getValidKFSVendors>
         <kfsVendorList>
            <kfsVendorDetailId>0</kfsVendorDetailId>
            <kfsVendorHeaderId>1058</kfsVendorHeaderId>
         </kfsVendorList>
         <kfsVendorList>
            <kfsVendorDetailId>0</kfsVendorDetailId>
            <kfsVendorHeaderId>1059</kfsVendorHeaderId>
         </kfsVendorList>
         <kfsVendorList>
            <kfsVendorDetailId>1</kfsVendorDetailId>
            <kfsVendorHeaderId>0000</kfsVendorHeaderId>
         </kfsVendorList>
      </adc:getValidKFSVendors>
   </soapenv:Body>
</soapenv:Envelope>

Response

<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
   <soap:Body>
      <ns2:getValidKFSVendorsResponse xmlns:ns2="http://www.adcom.uci.edu">
         <return>
            <kfsVendorDetailId>0</kfsVendorDetailId>
            <kfsVendorHeaderId>1058</kfsVendorHeaderId>
            <kfsVendorName>GEORGE G BOGHOSSIAN &amp; ASSOCIATES, INC</kfsVendorName>
         </return>
         <return>
            <kfsVendorDetailId>0</kfsVendorDetailId>
            <kfsVendorHeaderId>1059</kfsVendorHeaderId>
            <kfsVendorName>NATIONAL CONSUMER VOICE FOR QUALITY</kfsVendorName>
         </return>
      </ns2:getValidKFSVendorsResponse>
   </soap:Body>
</soap:Envelope>

Java Client Example

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

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

<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

<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

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	kfsVendorAddrId	Vendor Address Generated ID	Y	String(10)	4110

DB Query

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

<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

<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>4111</kfsVendorAddrId>
            <valid>true</valid>
         </return>
         <return>
            <kfsVendorAddrId>4110</kfsVendorAddrId>
            <valid>true</valid>
         </return>
      </ns2:isValidKFSVendorAddressesResponse>
   </soap:Body>
</soap:Envelope>

Java Client Example

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

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

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:adc="http://www.adcom.uci.edu">
   <soapenv:Header/>
   <soapenv:Body>
      <adc:getValidKFSVendorAddresses>
         <kfsVendorAddressList>
            <kfsVendorAddrType>PO</kfsVendorAddrType>
            <kfsVendorDetailId>0</kfsVendorDetailId>
            <kfsVendorHeaderId>1340</kfsVendorHeaderId>
         </kfsVendorAddressList>
         <kfsVendorAddressList>
            <kfsVendorAddrType>PO</kfsVendorAddrType>
            <kfsVendorDetailId>53</kfsVendorDetailId>
            <kfsVendorHeaderId>2325</kfsVendorHeaderId>
         </kfsVendorAddressList>
         <kfsVendorAddressList>
            <kfsVendorAddrType>XX</kfsVendorAddrType>
            <kfsVendorDetailId>0</kfsVendorDetailId>
            <kfsVendorHeaderId>00000</kfsVendorHeaderId>
         </kfsVendorAddressList>
      </adc:getValidKFSVendorAddresses>
   </soapenv:Body>
</soapenv:Envelope>

Response

<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
   <soap:Body>
      <ns2:getValidKFSVendorAddressesResponse xmlns:ns2="http://www.adcom.uci.edu">
         <return>
            <kfsVendorAddr1>49 RAILSIDE ROAD</kfsVendorAddr1>
            <kfsVendorAddr2/>
            <kfsVendorAddrId>4110</kfsVendorAddrId>
            <kfsVendorAddrType>PO</kfsVendorAddrType>
            <kfsVendorCity>TORONTO</kfsVendorCity>
            <kfsVendorCountry>CA</kfsVendorCountry>
            <kfsVendorDetailId>0</kfsVendorDetailId>
            <kfsVendorHeaderId>1340</kfsVendorHeaderId>
            <kfsVendorState>ON</kfsVendorState>
            <kfsVendorZip>M3A  -1B3</kfsVendorZip>
         </return>
         <return>
            <kfsVendorAddr1>757 W. IVY STREET</kfsVendorAddr1>
            <kfsVendorAddr2/>
            <kfsVendorAddrId>4111</kfsVendorAddrId>
            <kfsVendorAddrType>PO</kfsVendorAddrType>
            <kfsVendorCity>SAN DIEGO</kfsVendorCity>
            <kfsVendorCountry>US</kfsVendorCountry>
            <kfsVendorDetailId>53</kfsVendorDetailId>
            <kfsVendorHeaderId>2325</kfsVendorHeaderId>
            <kfsVendorState>CA</kfsVendorState>
            <kfsVendorZip>92101-1727</kfsVendorZip>
         </return>
      </ns2:getValidKFSVendorAddressesResponse>
   </soap:Body>
</soap:Envelope>

Java Client Example

DWHServerService 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 = 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

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