CR
Address2
PX.Objects.CR40 of 40 fields
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
AddressID | int | Address ID | - | |
Description:No description available | ||||
AddressLine1 | nvarchar(70) | Address Line 1 | - | |
Description:No description available | ||||
AddressLine2 | nvarchar(70) | Address Line 2 | - | |
Description:No description available | ||||
AddressLine3 | nvarchar(70) | Address Line 3 | - | |
Description:No description available | ||||
AddressType | char(2) | AddressType | - | |
Description:No description available | ||||
BAccountID | int | Business Account ID | BAccount | |
Description:No description available | ||||
BuildingName | nvarchar(35) | Building Name | - | |
Description:No description available | ||||
BuildingNumber | nvarchar(16) | Building Number | - | |
Description:No description available | ||||
City | nvarchar(50) | City | - | |
Description:No description available | ||||
CountryID | nvarchar(2) | Country | Country | |
Description:No description available | ||||
CreatedByID | uniqueidentifier | Created By | Users | |
Description:No description available | ||||
CreatedByScreenID | char(8) | - | ||
Description:No description available | ||||
CreatedDateTime | datetime | - | ||
Description:No description available | ||||
Department | nvarchar(70) | Department | - | |
Description:No description available | ||||
DisplayName | nvarchar(MAX) | Address | - | |
Description:No description available | ||||
DistrictName | nvarchar(35) | District Name | - | |
Description:No description available | ||||
Floor | nvarchar(70) | Floor | - | |
Description:No description available | ||||
IsValidated | bit | Validated | - | |
Description:No description available | ||||
LastModifiedByID | uniqueidentifier | Last Modified By | Users | |
Description:No description available | ||||
LastModifiedByScreenID | char(8) | - | ||
Description:No description available | ||||
LastModifiedDateTime | datetime | - | ||
Description:No description available | ||||
Latitude | decimal(10, 6) | Latitude | - | |
Description:No description available | ||||
Longitude | decimal(10, 6) | Longitude | - | |
Description:No description available | ||||
NoteID | uniqueidentifier | - | ||
Description:No description available | ||||
PostalCode | varchar(20) | Postal Code | - | |
Description:No description available | ||||
PostBox | nvarchar(16) | Post Box | - | |
Description:No description available | ||||
PseudonymizationStatus | int | Pseudonymized | - | |
Description:No description available | ||||
RevisionID | int | - | ||
Description:No description available | ||||
Room | nvarchar(70) | Room | - | |
Description:No description available | ||||
SelectedNonexistent in DB | bit | Selected | - | |
Description:No description available | ||||
State | nvarchar(50) | State | State | |
Description:No description available | ||||
StreetName | nvarchar(70) | Street Name | - | |
Description:No description available | ||||
SubDepartment | nvarchar(70) | Subdepartment | - | |
Description:No description available | ||||
TaxLocationCode | nvarchar(30) | Tax Location Code | - | |
Description:No description available | ||||
TaxLocationCodeFull | nvarchar(70) | Full Tax Location Code | - | |
Description:No description available | ||||
TaxMunicipalCode | nvarchar(30) | Tax Municipal Code | - | |
Description:No description available | ||||
TaxSchoolCode | nvarchar(30) | Tax School Code | - | |
Description:No description available | ||||
TownLocationName | nvarchar(35) | Town Location Name | - | |
Description:No description available | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||
UnitNumber | nvarchar(16) | Unit Number | - | |
Description:No description available | ||||