Web Services - KFS Vendor

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)

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

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 = '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 (VendorValidation.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
VALID	isValid	is Vendor valid	boolean	true

WS Example

Request

Response

Java Client Example

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

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

Response

Java Client Example

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

Response

Java Client Example

isValidKFSVendorAddresses(List of (kfsVendorAddressId) )

Input Specifications

Index	Parameter	Description	Required?	Data Type (max length)	Example
0	kfsVendorAddrId	Vendor Address Generated ID	Y	String(10)	21626

DB Query

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

Java Client Example

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

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

Response

Java Client Example

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