Description
Query that can be used to convert the ID into the Code and vice-versa (Code is also a related-key-business-field in this query).
Parameters
| iiVatNumberId | integer | Vat Number ID |
| iiBusinessRelationId | integer | |
| iiIdentityCountryID | integer | Country ID of the VAT Identification Number |
| icVatNumberIdentity | character | Tax Identification Number |
| icBusinessRelationCode | character | |
| icIdentityCountryCode | character | |
query condition
each VatNumber where
VatNumber.VatNumber_ID = iiVatNumberId AND
VatNumber.BusinessRelation_ID = iiBusinessRelationId AND
VatNumber.IdentityCountry_ID = iiIdentityCountryID AND
VatNumber.VatNumberIdentity = icVatNumberIdentity
first BusinessRelation (inner-join) where
BusinessRelation.BusinessRelation_ID = VatNumber.BusinessRelation_ID AND
BusinessRelation.BusinessRelationCode = icBusinessRelationCode
first Country (inner-join) where
Country.Country_ID = VatNumber.IdentityCountry_ID AND
Country.CountryCode = icIdentityCountryCode
query resultset tqVatNumberPrim
| field name | data type | db field | description |
|---|
| tcBusinessRelationCode | character | BusinessRelation.BusinessRelationCode | Business Relation. A code to identify the business relation.
If this field does not have a input from the user, the system automatically generates a number for the record based on the sequence defined in Business Relation Autonumber Create. |
| tcCountryCode | character | Country.CountryCode | Country Code |
| tiVatNumber_ID | integer | VatNumber.VatNumber_ID | Record ID |
| tiBusinessRelation_ID | integer | VatNumber.BusinessRelation_ID | Link to BusinessRelation |
| tiIdentityCountry_ID | integer | VatNumber.IdentityCountry_ID | Country Tax Identification |
| tcVatNumberIdentity | character | VatNumber.VatNumberIdentity | Obsolete field |
Internal usage
QadFinancials