Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Java Client Example

Code Block
 

 

getValidKFSVendors(List of (kfsVendorHeaderId, kfsVendorDetailId) )

Input Specifications

IndexParameterDescriptionRequired?Data Type (max length)Example
0kfsVendorHeaderIdVendor Header Generated IDYString(10)1126
1kfsVendorDetailIdVendor Detail Assigned IDYString(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)

...

vndr_hdr_gnrtd_id 

...

		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();) {
		VendorValidation element = (VendorValidation)i.next();
		System.out.println("SERVER UNIT TEST-Result List28: " + element.toString());
	}
} else {
	System.out.println("something bad happened...please check your query");
}

 

...

getValidKFSVendors(List of (kfsVendorHeaderId, kfsVendorDetailId) )

Input Specifications

IndexParameterDescriptionRequired?Data Type (max length)Example
0kfsVendorHeaderIdVendor Header Generated IDYString(10)1126
1kfsVendorDetailIdVendor Detail Assigned IDYString(10)1
vndr_nm
kfsVendorNameVendor NameStringCORNELL UNIVERSITY-ILR
vndr_duns_nbr
kfsVendorDUNSNumberVendor DUNS NumberString0

WS Example

Request

...

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>
            <item>1126</item>
            <item>1</item>
         </kfsVendorList>
          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 ParameterJava ParameterDescriptionData TypeExample
vndr_hdr_gnrtd_id 
kfsVendorHeaderIdVendor Header Generated IDString1126
vndr_dtl_asnd_id
kfsVendorDetailIdVendor Detail Assigned IDString1
vndr_nm
kfsVendorNameVendor NameStringCORNELL UNIVERSITY-ILR
vndr_duns_nbr
kfsVendorDUNSNumberVendor DUNS NumberString0

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>1127<<item>1126</item>
            <item>1</item>
         </kfsVendorList>
         <kfsVendorList>
            <item>0000<<item>1127</item>
            <item>0<<item>1</item>
         </kfsVendorList>
      </adc:getValidKFSVendors>   <kfsVendorList>
            <item>0000</item>
            <item>0</item>
         </kfsVendorList>
      </adc:getValidKFSVendors>
   </soapenv:Body>
</soapenv: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:ns2System.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>
 <return>     <adc:getAllKFSVendors/>
       <kfsVendorDUNSNumber>0</kfsVendorDUNSNumber></soapenv:Body>
</soapenv:Envelope>
Response
Code Block
<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
   <soap:Body>
      <ns2:getAllKFSVendorsResponse  <kfsVendorDetailId>0</kfsVendorDetailId>xmlns:ns2="http://www.adcom.uci.edu">
         <return>
   <kfsVendorHeaderId>1124</kfsVendorHeaderId>         <kfsVendorDUNSNumber>0</kfsVendorDUNSNumber>
   <kfsVendorName>AJAX SIGN GRAPHICS, INC</       <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

IndexParameterDescriptionRequired?Data Type (max length)Example
0kfsVendorAddrIdVendor Address Generated IDYString(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 ParameterJava ParameterDescriptionData TypeExample
vndr_addr_gnrtd_id
kfsVendorAddrIdVendor Address Generated IDString21626
VALIDisValidis Vendor Address ID validbooleantrue

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="httpSystem.out.println("\n=======================================getAllKFSVendors()================================");
List<VendorDetails> resultList30 = myBean.getAllKFSVendors();
if (resultList30 != null) {
	//for (Iterator i = resultList26.iterator(); i.hasNext();) {
	//	VendorDetails element = (VendorDetails)i.next();
	//	System.out.println("SERVER UNIT TEST-Result List30: " + element.toString());
	//}
	System.out.println("SERVER UNIT TEST-getAllKFSVendors() total size: " + resultList30.size());
	System.out.println("SERVER UNIT TEST-getAllKFSVendors() 1st element: " + resultList30.get(0).toString());
} else {
	System.out.println("something bad happened...please check your query");
}

 

...

isValidKFSVendorAddresses(List of (kfsVendorAddressId) )

Input Specifications

IndexParameterDescriptionRequired?Data Type (max length)Example
0kfsVendorAddrIdVendor Address Generated IDYString(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 ParameterJava ParameterDescriptionData TypeExample
vndr_addr_gnrtd_id
kfsVendorAddrIdVendor Address Generated IDString21626
VALIDisValidis Vendor Address ID validbooleantrue

WS Example

Request
Code Block
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/">    <soap:Body>
      <ns2:isValidKFSVendorAddressesResponse xmlns:ns2adc="http://www.adcom.uci.edu">
    <soapenv:Header/>
   <soapenv:Body>
<return>      <adc:isValidKFSVendorAddresses>
      <kfsVendorAddrId>0000</kfsVendorAddrId>   <kfsVendorAddressList>21626</kfsVendorAddressList>
         <valid>false<<kfsVendorAddressList>21627</valid>kfsVendorAddressList>
         <<kfsVendorAddressList>0000</return>kfsVendorAddressList>
      </adc:isValidKFSVendorAddresses>
  <return> </soapenv:Body>
</soapenv:Envelope>
Response
Code Block
<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
   <soap:Body>
     <kfsVendorAddrId>21626</kfsVendorAddrId> <ns2:isValidKFSVendorAddressesResponse xmlns:ns2="http://www.adcom.uci.edu">
         <return>
            <kfsVendorAddrId>0000</kfsVendorAddrId>
    <valid>true<        <valid>false</valid>
         </return>
         <return>
            <kfsVendorAddrId>21627<<kfsVendorAddrId>21626</kfsVendorAddrId>
            <valid>true</valid>
         </return>
         <return>
  </ns2:isValidKFSVendorAddressesResponse>          </soap:Body>
</soap:<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

IndexParameterDescriptionRequired?Data Type (max length)Example
0kfsVendorHeaderIdVendor Header Generated IDYString(10)1007
1kfsVendorDetailIdVendor Detail Assigned IDYString(10)0
2kfsVendorAddrTypeVendor Address TypeYStringPO

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' ANDSystem.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))

Relationship between Vendor and Address is 1:Many, but only get the default one

Input Specifications

IndexParameterDescriptionRequired?Data Type (max length)Example
0kfsVendorHeaderIdVendor Header Generated IDYString(10)1007
1kfsVendorDetailIdVendor Detail Assigned IDYString(10)0
2kfsVendorAddrTypeVendor Address TypeYStringPO

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='PO'), OR
CONVERT(varchar(10), (VNDR_HDRADDR_GNRTD_ID = '13788' AND) AS VNDR_DTLADDR_ASNDGNRTD_ID = '0' AND VNDR_ADDR_TYP_CD='RM') OR 
(VNDR_,
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 = '000001007' AND VNDR_DTL_ASND_ID = '0' AND VNDR_ADDR_TYP_CD='XXPO')
);

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

...

 OR 
(VNDR_HDR_GNRTD_ID

...

 = '1007' AND VNDR_DTL_ASND_ID

...

 = '0' AND VNDR_ADDR_TYP_CD

...

vndr_addr_gnrtd_id 

...

vndr_ln1_addr

...

vndr_ln2_addr

...

vndr_cty_nm

...

vndr_st_cd

...

vndr_zip_cd

...

vndr_cntry_cd

...

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>='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 ParameterJava ParameterDescriptionData TypeExample
VNDR_HDR_GNRTD_ID
kfsVendorHeaderIdVendor Header Generated IdString 
VNDR_DTL_ASND_ID
kfsVendorDetailIdVendor Detailed Assigned IdString 
VNDR_ADDR_TYP_CD
kfsVendorAddrTypeVendor Address TypeString 
vndr_addr_gnrtd_id 
kfsVendorAddrIdVendor Address IdString 
vndr_ln1_addr
kfsVendorAddr1Vendor Address Line 1String 
vndr_ln2_addr
kfsVendorAddr2Vendor Address Line 2String 
vndr_cty_nm
kfsVendorCityVendor CityString 
vndr_st_cd
kfsVendorStateVendor StateString 
vndr_zip_cd
kfsVendorZipVendor ZipString 
vndr_cntry_cd
kfsVendorCountryVendor CountryString 

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

...

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
System.out.println("\n=======================================getValidKFSVendorAddresses()================================");
List<VendorAddressDetails> resultList32 =        <kfsVendorHeaderId>13788</kfsVendorHeaderId>
            <kfsVendorState>NY</kfsVendorState>
            <kfsVendorZip>10087-5943</kfsVendorZip>
         </return>
      </ns2:getValidKFSVendorAddressesResponse>
   </soap:Body>
</soap:Envelope>

Java Client Example

Code Block
 myBean.getValidKFSVendorAddresses(new String[][]{{"1007","0","PO"},{"1007","0","RM"},{"13788","3","PO"},{"13788","0","RM"},{"00000","0","XX"}});
if (resultList32 != null) {
	for (Iterator i = resultList32.iterator(); i.hasNext();) {
		VendorAddressDetails element = (VendorAddressDetails)i.next();
		System.out.println("SERVER UNIT TEST-Result List32: " + element.toString());
	}
} 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

...