PersonAddresses Table

Applies to QAComplete 12.80 SaaS, last modified on April 20, 2021

Description

Stores user addresses.

Columns

The table contains the following columns:

Seq  :  int, primary key, allows null: no, default: (1)

The ordinal number of the address related to the item.

UserId  :  int, primary key, allows null: no

The ID of the related user.

Address1  :  varchar (max 50 chars), allows null: yes

The first address line.

Address2  :  varchar (max 50 chars), allows null: yes

The second address line.

Address3  :  varchar (max 50 chars), allows null: yes

The third address line.

AddressTypeCode  :  varchar (max 100 chars), allows null: no

The address type (Bill-To, Home, Ship-To, or Work).

City  :  varchar (max 50 chars), allows null: yes

The city of the address.

Country  :  varchar (max 50 chars), allows null: yes

The country of the address.

DateCreated  :  datetime, allows null: no, default: Current date and time

The date and time the item was created.

The stored date and time are based on the server’s time zone. For more information, see Date and Time Fields.

DateUpdated  :  datetime, allows null: no, default: Current date and time

The date and time the item was last updated.

The stored date and time are based on the server’s time zone. For more information, see Date and Time Fields.

PostalCode  :  varchar (max 100 chars), allows null: yes

The postal code of the address.

State  :  varchar (max 15 chars), allows null: yes

The state of the address.

UpdateUserId  :  int, allows null: no

The ID of the user who last updated the item.

See Also

PersonAddresses View
PersonSecurityGroups Table
Setup

Highlight search results