project QadFinancials > class BRegion > business logic query RegionPrim
Parameters
| iiRegionId | integer | |
| icRegionCode | character | |
| icCountryCode | character | |
query condition
each Region where
Region.Region_ID = iiRegionId AND
Region.RegionCode = icRegionCode
first Country (conditional-join) where
Country.Country_ID = Region.Country_ID AND
Country.CountryCode = icCountryCode
query resultset tqRegionPrim
| field name | data type | db field | description |
|---|
| tiCountry_ID | integer | Region.Country_ID | Country Code |
| tcCountryCode | character | Country.CountryCode | Country Code |
| tiRegion_ID | integer | Region.Region_ID | Record ID |
| tcRegionCode | character | Region.RegionCode | Region Code |
Internal usage
QadFinancials