The ADDRESSGROUP table links a contact to an address and contains rules specific for using that address.
This table is used by the following domain.
|Name||Comment||Datatype||Null Option||Is PK|
|LOCATION_GROUP_ID||A unique, system-generated key that identifies a location group in the system.||BIGINT||Not Null||Yes|
|ADDRESS_ID||A unique, system-generated key that identifies an address in the system.||BIGINT||Not Null||No|
|CARE_OF_DESC||In Care of Description is placed above the recipient line. It contains information such as a specific person or department to provide additional information, facilitating delivery.||VARCHAR(50)||Null||No|
|ADDR_USAGE_TP_CD||Identifies the usage of an address provided by a party. Examples include residence address, business address, and so forth.||BIGINT||Not Null||No|
|LAST_UPDATE_DT||When a record is added or updated, this field is updated with the date and time. On subsequent updates, the system uses this information to ensure that the update request includes a matching date and time on this field; if it does not, the update fails.||TIMESTAMP||Not Null||No|
|LAST_UPDATE_USER||The ID of the user who last updated the data.||VARCHAR(20)||Null||No|
|LAST_UPDATE_TX_ID||A unique, system-generated key that identifies the specific transaction within the log system that either created, updated, or deleted the data row.||BIGINT||Null||No|