CR
LocationExtAddress
No summary is documented for this DAC in the release source.
| 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 line of the street address. | ||||
AddressLine2 | nvarchar(70) | Address Line 2 | - | |
Description:The second line of the street address. | ||||
AddressLine3 | nvarchar(70) | Address Line 3 | - | |
Description:The third line of the street address. | ||||
AddressType | char(2) | AddressType | - | |
Description:The type of the address. The field can have one of the values described in the AddressTypes class. The default value is AddressTypes.BusinessAddress. | ||||
BAccountBAccountID | int | - | ||
Description:No description available | ||||
BAccountID | int | Business Account ID | BAccount | |
Description:The identifier of the BAccount record that is specified in the business account to which the address belongs. Corresponds to the BAccount.BAccountID field. | ||||
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). | ||||
CARAccountID | int | AR Account | Account | |
Description:No description available | ||||
CARAccountLocationID | int | - | ||
Description:No description available | ||||
CARSubID | int | AR Sub. | Sub | |
Description:No description available | ||||
CAdditionalHandling | bit | Additional Handling | - | |
Description:No description available | ||||
CAvalaraCustomerUsageType | char(1) | Tax Exemption Type | - | |
Description:No description available | ||||
CBranchID | int | Shipping Branch | - | |
Description:No description available | ||||
CCarrierID | nvarchar | Ship Via | Carrier | |
Description:No description available | ||||
CDiscountAcctID | int | Discount Account | Account | |
Description:No description available | ||||
CDiscountSubID | int | Discount Sub. | Sub | |
Description:No description available | ||||
CFOBPointID | nvarchar | FOB Point | FOBPoint | |
Description:No description available | ||||
CFreightAcctID | int | Freight Account | Account | |
Description:No description available | ||||
CFreightSubID | int | Freight Sub. | Sub | |
Description:No description available | ||||
CGroundCollect | bit | Ground Collect | - | |
Description:No description available | ||||
CInsideDelivery | bit | Inside Delivery | - | |
Description:No description available | ||||
CInsurance | bit | Insurance | - | |
Description:No description available | ||||
CLeadTime | smallint | Lead Time (Days) | - | |
Description:No description available | ||||
CLiftGate | bit | Lift Gate | - | |
Description:No description available | ||||
CLimitedAccess | bit | Limited Access | - | |
Description:No description available | ||||
CMPDiscountSubID | int | Discount Sub. | Sub | |
Description:No description available | ||||
CMPExpenseSubID | int | Expense Sub. | Sub | |
Description:No description available | ||||
CMPFreightSubID | int | Freight Sub. | Sub | |
Description:No description available | ||||
CMPGainLossSubID | int | Currency Gain/Loss Sub. | Sub | |
Description:No description available | ||||
CMPPayrollSubID | int | Payroll Sub. | Sub | |
Description:No description available | ||||
CMPSalesSubID | int | Sales Sub. | Sub | |
Description:No description available | ||||
CMPSiteID | int | Warehouse | INSite | |
Description:No description available | ||||
COrderPriority | smallint | Order Priority | - | |
Description:No description available | ||||
CPriceClassID | nvarchar | Price Class ID | ARPriceClass | |
Description:No description available | ||||
CResedential | bit | Residential Delivery | - | |
Description:No description available | ||||
CRetainageAcctID | int | Retainage Receivable Account | Account | |
Description:No description available | ||||
CRetainageSubID | int | Retainage Receivable Sub. | Sub | |
Description:No description available | ||||
CSalesAcctID | int | Sales Account | Account | |
Description:No description available | ||||
CSalesSubID | int | Sales Sub. | Sub | |
Description:No description available | ||||
CSaturdayDelivery | bit | Saturday Delivery | - | |
Description:No description available | ||||
CShipComplete | char(1) | Shipping Rule | - | |
Description:No description available | ||||
CShipTermsID | nvarchar | Shipping Terms | ShipTerms | |
Description:No description available | ||||
CShipZoneID | nvarchar(15) | Shipping Zone ID | ShippingZone | |
Description:No description available | ||||
CSiteID | int | Warehouse | INSite | |
Description:No description available | ||||
CTaxCalcMode | nvarchar | Tax Calculation Mode | - | |
Description:No description available | ||||
CTaxZoneID | nvarchar(10) | Tax Zone | TaxZone | |
Description:No description available | ||||
City | nvarchar(50) | City | - | |
Description:The name of the city or inhabited locality. | ||||
CountryID | nvarchar(100) | Country | Country | |
Description:The identifier of the Country record. Corresponds to the Country.CountryID field. | ||||
County | nvarchar(255) | County | - | |
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 | ||||
DefAddressID | int | Default Address | Address | |
Description:No description available | ||||
DefContactID | int | - | ||
Description:No description available | ||||
Department | nvarchar(70) | Department | - | |
Description:Identification of a division of a large organization or building (ISO 20022). | ||||
Descr | nvarchar(60) | Location Name | - | |
Description:No description available | ||||
DisplayNameNonexistent in DB | string | Address | - | |
Description:The display name of the address as a concatenation of address lines (AddressLine1, AddressLine2 and AddressLine2 fields). | ||||
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). | ||||
IsAPAccountSameAsMainNonexistent in DB | bool? | - | ||
Description:No description available | ||||
IsARAccountSameAsMainNonexistent in DB | bool? | - | ||
Description:No description available | ||||
IsActive | bit | Active | - | |
Description:No description available | ||||
IsAddressSameAsMainNonexistent in DB | bool? | Same as Main | - | |
Description:No description available | ||||
IsContactSameAsMainNonexistent in DB | bool? | Same as Main | - | |
Description:No description available | ||||
IsValidated | bit | Validated | - | |
Description:If set to true, this field indicates that the address has been successfully validated by Acumatica ERP. | ||||
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 coordinates that are entered for a location if the location does not contain the postal address or the postal address cannot be validated. The field value is filled using the Google or Bing lookup. | ||||
LocType | nvarchar | Location Type | - | |
Description:No description available | ||||
LocationBAccountID | int | Business Account ID | - | |
Description:No description available | ||||
LocationCD | nvarchar | Location ID | - | |
Description:No description available | ||||
LocationCreatedByID | uniqueidentifier | Created By | Users | |
Description:No description available | ||||
LocationCreatedByScreenID | char(8) | - | ||
Description:No description available | ||||
LocationCreatedDateTime | datetime | - | ||
Description:No description available | ||||
LocationID | int | LocationID | - | |
Description:No description available | ||||
LocationLastModifiedByID | uniqueidentifier | Last Modified By | Users | |
Description:No description available | ||||
LocationLastModifiedByScreenID | char(8) | - | ||
Description:No description available | ||||
LocationLastModifiedDateTime | datetime | - | ||
Description:No description available | ||||
Longitude | decimal | Longitude | - | |
Description:The longitude coordinates that are entered for a location if the location does not contain the postal address or the postal address cannot be validated. The field value is filled using the Google or Bing lookup. | ||||
NoteID | uniqueidentifier | - | ||
Description:No description available | ||||
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 part of the address. | ||||
PsdCode | nvarchar(30) | PSD Code | - | |
Description:No description available | ||||
PseudonymizationStatus | int | Pseudonymized | - | |
Description:No description available | ||||
RevisionID | int | - | ||
Description:The revision ID of the original record. | ||||
Room | nvarchar(70) | Room | - | |
Description:Floor or storey within a building (ISO 20022). | ||||
SelectedNonexistent in DB | bool? | Selected | - | |
Description:No description available | ||||
State | nvarchar(50) | State | State | |
Description:The string identifier of the state or province part of the address. Corresponds to the State.StateID field. | ||||
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). | ||||
TaxLocationCode | nvarchar(30) | Tax Location Code | - | |
Description:The code of the location tax that is used in reports. | ||||
TaxLocationCodeFull | nvarchar(70) | Full Tax Location Code | - | |
Description:The tax location code according to Symmetry Location Service specifications. | ||||
TaxMunicipalCode | nvarchar(30) | Tax Municipal Code | - | |
Description:The code of the municipal tax that is used in reports. | ||||
TaxRegistrationID | nvarchar(50) | Tax Registration ID | - | |
Description:No description available | ||||
TaxSchoolCode | nvarchar(30) | Tax School Code | - | |
Description:The code of the school tax that is used in reports. | ||||
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). | ||||
VAPAccountID | int | AP Account | Account | |
Description:No description available | ||||
VAPAccountLocationID | int | - | ||
Description:No description available | ||||
VAPSubID | int | AP Sub. | Sub | |
Description:No description available | ||||
VAllowAPBillBeforeReceipt | bit | Allow AP Bill Before Receipt | - | |
Description:No description available | ||||
VBranchID | int | Receiving Branch | - | |
Description:No description available | ||||
VCarrierID | nvarchar | Ship Via | Carrier | |
Description:No description available | ||||
VCashAccountID | int | Cash Account | - | |
Description:No description available | ||||
VDefAddressID | int | - | ||
Description:No description available | ||||
VDefContactID | int | - | ||
Description:No description available | ||||
VDiscountAcctID | int | Discount Account | Account | |
Description:No description available | ||||
VDiscountSubID | int | Discount Sub. | Sub | |
Description:No description available | ||||
VEmailOrder | bit | Send Orders by Email | - | |
Description:No description available | ||||
VExpenseAcctID | int | Expense Account | Account | |
Description:No description available | ||||
VExpenseSubID | int | Expense Sub. | Sub | |
Description:No description available | ||||
VFOBPointID | nvarchar | FOB Point | FOBPoint | |
Description:No description available | ||||
VFreightAcctID | int | Freight Account | Account | |
Description:No description available | ||||
VFreightSubID | int | Freight Sub. | Sub | |
Description:No description available | ||||
VLeadTime | smallint | Lead Time (Days) | - | |
Description:No description available | ||||
VPaymentByType | int | Payment By | - | |
Description:No description available | ||||
VPaymentInfoLocationID | int | - | ||
Description:No description available | ||||
VPaymentLeadTime | smallint | Payment Lead Time (Days) | - | |
Description:No description available | ||||
VPaymentMethodID | nvarchar(10) | Payment Method | PaymentMethod | |
Description:No description available | ||||
VPrepaymentPct | decimal | Prepayment Percent | - | |
Description:No description available | ||||
VPrintOrder | bit | Print Orders | - | |
Description:No description available | ||||
VRcptQtyAction | char(1) | Receipt Action | - | |
Description:No description available | ||||
VRcptQtyMax | decimal | Max. Receipt (%) | - | |
Description:No description available | ||||
VRcptQtyMin | decimal | Min. Receipt (%) | - | |
Description:No description available | ||||
VRcptQtyThreshold | decimal | Threshold Receipt (%) | - | |
Description:No description available | ||||
VRemitAddressID | int | Address | ||
Description:No description available | ||||
VRemitContactID | int | Contact | ||
Description:No description available | ||||
VRetainageAcctID | int | Retainage Payable Account | Account | |
Description:No description available | ||||
VRetainageSubID | int | Retainage Payable Sub. | Sub | |
Description:No description available | ||||
VSeparateCheck | bit | Pay Separately | - | |
Description:No description available | ||||
VShipTermsID | nvarchar | Shipping Terms | ShipTerms | |
Description:No description available | ||||
VSiteID | int | Warehouse | INSite | |
Description:No description available | ||||
VTaxCalcMode | nvarchar | Tax Calculation Mode | - | |
Description:No description available | ||||
VTaxZoneID | nvarchar(10) | Tax Zone ID | TaxZone | |
Description:No description available | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||