| iiBusinessRelationId | integer | |
| iiVatNumberIDToSkip | integer | If you pass as value for this parameter, then the vat-number with this ID will be not in the result-set |
| iiIdentityCountryID | integer | IdentityCountryID |
| icVatNumberIdentity | character | VatNumberIdentity |
| iiBusinessRelationIDToSkip | integer | BusinessRelationIDToSkip; If you pass as value for this parameter, then the BusinessRelations with this ID will be not in the result-set |
each VatNumber where
first BusinessRelation (inner-join) where
| field name | data type | db field | description |
|---|---|---|---|
| tiBusinessRelation_ID | integer | VatNumber.BusinessRelation_ID | Link to BusinessRelation |
| 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. |
| tcCustomCombo0 | character | VatNumber.CustomCombo0 | Custom Combo Field |
| tcCustomCombo1 | character | VatNumber.CustomCombo1 | Custom Combo Field |
| tcCustomCombo2 | character | VatNumber.CustomCombo2 | Custom Combo Field |
| tcCustomCombo3 | character | VatNumber.CustomCombo3 | Custom Combo Field |
| tcCustomCombo4 | character | VatNumber.CustomCombo4 | Custom Combo Field |
| tcCustomCombo5 | character | VatNumber.CustomCombo5 | Custom Combo Field |
| tcCustomCombo6 | character | VatNumber.CustomCombo6 | Custom Combo Field |
| tcCustomCombo7 | character | VatNumber.CustomCombo7 | Custom Combo Field |
| tcCustomCombo8 | character | VatNumber.CustomCombo8 | Custom Combo Field |
| tcCustomCombo9 | character | VatNumber.CustomCombo9 | Custom Combo Field |
| ttCustomDate0 | date | VatNumber.CustomDate0 | Custom Date Field |
| ttCustomDate1 | date | VatNumber.CustomDate1 | Custom Date Field |
| ttCustomDate2 | date | VatNumber.CustomDate2 | Custom Date Field |
| ttCustomDate3 | date | VatNumber.CustomDate3 | Custom Date Field |
| ttCustomDate4 | date | VatNumber.CustomDate4 | Custom Date Field |
| tdCustomDecimal0 | decimal | VatNumber.CustomDecimal0 | Custom Decimal Field |
| tdCustomDecimal1 | decimal | VatNumber.CustomDecimal1 | Custom Decimal Field |
| tdCustomDecimal2 | decimal | VatNumber.CustomDecimal2 | Custom Decimal Field |
| tdCustomDecimal3 | decimal | VatNumber.CustomDecimal3 | Custom Decimal Field |
| tdCustomDecimal4 | decimal | VatNumber.CustomDecimal4 | Custom Decimal Field |
| tiCustomInteger0 | integer | VatNumber.CustomInteger0 | Custom Integer Field |
| tiCustomInteger1 | integer | VatNumber.CustomInteger1 | Custom Integer Field |
| tiCustomInteger2 | integer | VatNumber.CustomInteger2 | Custom Integer Field |
| tiCustomInteger3 | integer | VatNumber.CustomInteger3 | Custom Integer Field |
| tiCustomInteger4 | integer | VatNumber.CustomInteger4 | Custom Integer Field |
| tcCustomLong0 | character | VatNumber.CustomLong0 | Custom Long Field |
| tcCustomLong1 | character | VatNumber.CustomLong1 | Custom Long Field |
| tcCustomNote | character | VatNumber.CustomNote | Custom Note Field |
| tcCustomShort0 | character | VatNumber.CustomShort0 | Custom Short Field |
| tcCustomShort1 | character | VatNumber.CustomShort1 | Custom Short Field |
| tcCustomShort2 | character | VatNumber.CustomShort2 | Custom Short Field |
| tcCustomShort3 | character | VatNumber.CustomShort3 | Custom Short Field |
| tcCustomShort4 | character | VatNumber.CustomShort4 | Custom Short Field |
| tcCustomShort5 | character | VatNumber.CustomShort5 | Custom Short Field |
| tcCustomShort6 | character | VatNumber.CustomShort6 | Custom Short Field |
| tcCustomShort7 | character | VatNumber.CustomShort7 | Custom Short Field |
| tcCustomShort8 | character | VatNumber.CustomShort8 | Custom Short Field |
| tcCustomShort9 | character | VatNumber.CustomShort9 | Custom Short Field |
| tiDeclarationCountry_ID | integer | VatNumber.DeclarationCountry_ID | Country Tax Declaration |
| tiIdentityCountry_ID | integer | VatNumber.IdentityCountry_ID | Country Tax Identification |
| ttLastModifiedDate | date | VatNumber.LastModifiedDate | Last Modified Date |
| tiLastModifiedTime | integer | VatNumber.LastModifiedTime | Last Modified Time |
| tcLastModifiedUser | character | VatNumber.LastModifiedUser | Last Modified User |
| tiVatNumber_ID | integer | VatNumber.VatNumber_ID | Record ID |
| tcVatNumberDeclaration | character | VatNumber.VatNumberDeclaration | Obsolete field |
| tcVatNumberIdentity | character | VatNumber.VatNumberIdentity | Obsolete field |
| tlVatNumberIsActive | logical | VatNumber.VatNumberIsActive | Obsolete field |
| ti_sequence | integer | calculated | primary index |
| tc_rowid | character | calculated | = rowid(VatNumber),rowid(BusinessRelation) |
QadFinancials