project QadFinancials > class BDebtorReport > business logic query GetStateInfoByAddressId
Parameters
query condition
each Address where
Address.Address_ID = iiAddressId
first State (inner-join) where
State.State_ID = Address.State_ID AND
query resultset tqGetStateInfoByAddressId
| field name | data type | db field | description |
|---|
| tiAddressFormat | integer | Address.AddressFormat | Format. This field determines where postal codes display on printed addresses. |
| api annotation: | | PartialUpdate = yes - defaults to the value for the same field defined for the country. |
| tiState_ID | integer | State.State_ID | Record ID |
| tcStateCode | character | State.StateCode | State |
| tcStateDescription | character | State.StateDescription | Description |
Internal usage
QadFinancials