project QadFinancials > class BDebtor > dataset tAddressRefDebtor
copy of query resultset tqAddressByAddressType
table tAddressRefDebtor
Description
AddressRef like tqAddressByAddressType
| field name | data type | description |
|---|
| tiAddress_ID | integer | |
| tcAddressCity | character | |
| tcAddressEMail | character | |
| tcAddressFax | character | |
| tiAddressFormat | integer | |
| tlAddressIsSendToPostal | logical | |
| tlAddressIsTaxable | logical | |
| tlAddressIsTemporary | logical | |
| tcAddressName | character | |
| tcAddressPostalAddress1 | character | |
| tcAddressPostalAddress2 | character | |
| tcAddressPostalCity | character | |
| tcAddressPostalZip | character | |
| tcAddressSearchName | character | |
| tcAddressState | character | |
| tcAddressStreet1 | character | |
| tcAddressStreet2 | character | |
| tcAddressStreet3 | character | |
| tcAddressTelephone | character | |
| tiAddressType_ID | integer | |
| tcAddressTypeCode | character | |
| tcAddressWebSite | character | |
| tcAddressZip | character | |
| tiBusinessRelation_ID | integer | |
| tcBusinessRelationCode | character | |
| tcBusinessRelationName1 | character | |
| tcBusinessRelationName2 | character | |
| tiCountry_ID | integer | |
| tcCountryCode | character | |
| tcCountryDescription | character | |
| tlCountryIsEUCountry | logical | |
| tiCounty_ID | integer | |
| tcCountyCode | character | |
| tcCountyDescription | character | |
| tiLng_ID | integer | |
| tcLngCode | character | |
| tiState_ID | integer | |
| tcStateCode | character | |
| tcStateDescription | character | |
| ti_sequence | integer | |
| tc_rowid | character | |
Internal usage
QadFinancials