project QadFinancials > class BBox1099Report > business logic query CompanyWithTaxRep
Parameters
| iiCompanyId | integer | Company id |
query condition
each Company where
Company.Company_Id = iiCompanyId AND
each CompanyProperty (inner-join) where
CompanyProperty.Company_Id = iiCompanyId AND
CompanyProperty.Company_ID = Company.Company_ID AND
first BusinessRelation (inner-join) where
BusinessRelation.BusinessRelation_ID = CompanyProperty.BusinessRelation_ID AND
BusinessRelation.BusinessRelationIsTaxRep = YES
each Address (inner-join) where
Address.BusinessRelation_ID = BusinessRelation.BusinessRelation_ID AND
first AddressType (inner-join) where
AddressType.AddressType_ID = Address.AddressType_ID AND
query resultset tqCompanyWithTaxRep
| field name | data type | db field | description |
|---|
| tcAddressTaxIDFederal | character | Address.AddressTaxIDFederal | Federal Tax. The value of this filed is the tax ID assigned to this address by the federal or national government.
If Tax Report is true, the Federal tax ID must be unique; otherwise, related business relations can share an ID. |
| tiCompany_ID | integer | Company.Company_ID | Record ID |
| tcCompanyCode | character | Company.CompanyCode | Entity Code |
| tcAddressTypeCode | character | AddressType.AddressTypeCode | Address Type |
Internal usage
QadFinancials