...
| 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 |
...
| Code Block |
|---|
SELECT a.vndr_hdr_gnrtd_id,
a.vndr_dtl_asnd_id,
a.vndr_nm,
a.vndr_duns_nbr
FROM PUR_VNDR_DTL_T a; |
...