PM
PMShippingAddress
Represents a pro forma shipping address. The records of this type are created and edited on the Pro Forma Invoices (PM307000) form (which corresponds to the ProformaEntry graph). The DAC is based on the PMAddress DAC.
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
AddressID | int | Address ID | - | |
Description:The unique integer identifier of the record. This field is the key field. | ||||
AddressLine1 | nvarchar(70) | Address Line 1 | - | |
Description:The first address line. | ||||
AddressLine2 | nvarchar(70) | Address Line 2 | - | |
Description:The second address line. | ||||
AddressLine3 | nvarchar(70) | Address Line 3 | - | |
Description:The third address line. | ||||
BuildingName | nvarchar(35) | Building Name | - | |
Description:Name of the building or house (ISO 20022). | ||||
BuildingNumber | nvarchar(16) | Building Number | - | |
Description:Number that identifies the position of a building on a street (ISO 20022). | ||||
City | nvarchar(50) | City | - | |
Description:The name of the city or inhabited locality. | ||||
CountryID | char(2) | Country | Country | |
Description:The identifier of the Country record. Corresponds to the Country.CountryID field. | ||||
CreatedByID | uniqueidentifier | Created By | Users | |
Description:No description available | ||||
CreatedByScreenID | char(8) | - | ||
Description:No description available | ||||
CreatedDateTime | datetime | - | ||
Description:No description available | ||||
CustomerAddressID | int | - | ||
Description:The identifier of the Address record from which the address was originally created. Corresponds to the Address.AddressID field. | ||||
CustomerID | int | - | ||
Description:The identifier of the Customer record, which is specified in the document to which the address belongs. Corresponds to the Customer.BAccountID field. | ||||
Department | nvarchar(70) | Department | - | |
Description:Identification of a division of a large organization or building (ISO 20022). | ||||
DistrictName | nvarchar(35) | District Name | - | |
Description:Identifies a subdivision within a country sub-division (ISO 20022). | ||||
Floor | nvarchar(70) | Floor | - | |
Description:Floor or storey within a building (ISO 20022). | ||||
IsDefaultBillAddress | bit | Customer Default | - | |
Description:If set to "true", indicates that the address record is identical to the original Address record, which is referenced by CustomerAddressID. | ||||
IsValidated | bit | Validated | - | |
Description:If set to "true", indicates that the address has been successfully validated by Acumatica. | ||||
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 | Latitude | - | |
Description:The latitude of the address. | ||||
Longitude | decimal | Longitude | - | |
Description:The longitude of the address. | ||||
NoteID | uniqueidentifier | - | ||
Description:No description available | ||||
OverrideAddressNonexistent in DB | bool? | Override Address | - | |
Description:If set to "true", indicates that the address overrides the default Address record, which is referenced by CustomerAddressID. This field is the inverse of IsDefaultBillAddress. | ||||
PostBox | nvarchar(16) | Post Box | - | |
Description:Numbered box in a post office, assigned to a person or organisation, where letters are kept until called for (ISO 20022). | ||||
PostalCode | nvarchar(20) | Postal Code | - | |
Description:The postal code. | ||||
PseudonymizationStatus | int | Pseudonymized | - | |
Description:No description available | ||||
RevisionID | int | - | ||
Description:The revision ID of the original Address record from which the record originates. Corresponds to the Address.RevisionID field. | ||||
Room | nvarchar(70) | Room | - | |
Description:Floor or storey within a building (ISO 20022). | ||||
State | nvarchar(50) | State | PMAddress | |
Description:The name of the state. | ||||
StreetName | nvarchar(70) | Street Name | - | |
Description:Name of a street or thoroughfare (ISO 20022). | ||||
SubDepartment | nvarchar(70) | Subdepartment | - | |
Description:Identification of a sub-division of a large organization or building (ISO 20022). | ||||
TownLocationName | nvarchar(35) | Town Location Name | - | |
Description:Specific location name within the town (ISO 20022). | ||||
UnitNumber | nvarchar(16) | Unit Number | - | |
Description:Identifies a flat or dwelling within the building (ISO 20022). | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||