...
| 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, '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') ); |
...
| 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, a. 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') ); |
...
getAllKFSVendors( )
DB Query
| Code Block |
|---|
SELECT CONVERT(varchar(10), a.vndr_hdr_gnrtd_id) AS vndr_hdr_gnrtd_id, a. 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; |
...
| 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'); |
...
| 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
| 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' 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') ); |
...
| Code Block |
|---|
SELECT /*a.VNDR_ALIAS_NM,*/ a. CONVERT(varchar(10), VNDR_HDR_GNRTD_ID) AS VNDR_HDR_GNRTD_ID, a., CONVERT(varchar(10), VNDR_DTL_ASND_ID) AS VNDR_DTL_ASND_ID, FROM PUR_VNDR_ALIAS_T a WHERE a.DOBJ_MAINT_CD_ACTV_IND <> 'N' AND a.VNDR_ALIAS_NM = '0421835099'; |
...