| icAddressCity | character | |
| icAddressStreet1 | character | |
| icAddressStreet2 | character | |
| icAddressZip | character | |
| icAddressTypeCode | character | |
| iiAddressID | integer | |
| iiBusinessRelationID | integer | |
| icBusinessRelationCode | character | |
| iiAddressTypeID | integer | AddressTypeID |
| icAddressStreet3 | character |
each Address where
first AddressType (inner-join) where
first BusinessRelation (inner-join) where
first Country (inner-join) where
| field name | data type | db field | description |
|---|---|---|---|
| tiAddress_ID | integer | Address.Address_ID | Record ID |
| tcAddressCity | character | Address.AddressCity | City. The city for this address. This field can be used to decide the tax zone of the address. |
| tcAddressState | character | Address.AddressState | Obsolete field |
| tcAddressStreet1 | character | Address.AddressStreet1 | Address: Line one of address details. This field can be blank. |
| tcAddressStreet2 | character | Address.AddressStreet2 | Address.Line two of address details. This field can be blank. |
| tcAddressStreet3 | character | Address.AddressStreet3 | Address.Line three of address details. This field can be blank. |
| tiAddressType_ID | integer | Address.AddressType_ID | Address Type |
| tcAddressTypeCode | character | AddressType.AddressTypeCode | Address Type |
| tcAddressZip | character | Address.AddressZip | Zip. The postal code or US zip code associated with this address. This field is used to decide the tax zone for the address. This field can be blank. |
| tiBusinessRelation_ID | integer | Address.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. |
| tiCountry_ID | integer | Address.Country_ID | Country Format |
| tcCountryCode | character | Country.CountryCode | Country Code |
| ti_sequence | integer | calculated | primary index |
| tc_rowid | character | calculated | = rowid(Address),rowid(AddressType),rowid(BusinessRelation),rowid(Country) |
QadFinancials