CR
LocationExtAddress
PX.Objects.CR135 of 135 fields
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
LocationBAccountID | int | Business Account ID | - | |
Description:No description available | ||||
LocationCD | nvarchar(MAX) | Location ID | - | |
Description:No description available | ||||
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 | ||||
BAccountBAccountID | int | - | ||
Description:No description available | ||||
BAccountID | int | Business Account ID | - | |
Description:No description available | ||||
BuildingName | nvarchar(35) | Building Name | - | |
Description:No description available | ||||
BuildingNumber | nvarchar(16) | Building Number | - | |
Description:No description available | ||||
CAdditionalHandling | bit | Additional Handling | - | |
Description:No description available | ||||
CARAccountID | int | AR Account | - | |
Description:No description available | ||||
CARAccountLocationID | int | - | ||
Description:No description available | ||||
CARSubID | int | AR Sub. | - | |
Description:No description available | ||||
CAvalaraCustomerUsageType | char(1) | Tax Exemption Type | - | |
Description:No description available | ||||
CBranchID | int | Shipping Branch | - | |
Description:No description available | ||||
CCarrierID | nvarchar(MAX) | Ship Via | Carrier | |
Description:No description available | ||||
CDiscountAcctID | int | Discount Account | - | |
Description:No description available | ||||
CDiscountSubID | int | Discount Sub. | - | |
Description:No description available | ||||
CFOBPointID | nvarchar(MAX) | FOB Point | FOBPoint | |
Description:No description available | ||||
CFreightAcctID | int | Freight Account | - | |
Description:No description available | ||||
CFreightSubID | int | Freight 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 | ||||
City | nvarchar(50) | City | - | |
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. | - | |
Description:No description available | ||||
CMPExpenseSubID | int | Expense Sub. | - | |
Description:No description available | ||||
CMPFreightSubID | int | Freight Sub. | - | |
Description:No description available | ||||
CMPGainLossSubID | int | Currency Gain/Loss Sub. | - | |
Description:No description available | ||||
CMPSalesSubID | int | Sales Sub. | - | |
Description:No description available | ||||
CMPSiteID | int | Warehouse | INSite | |
Description:No description available | ||||
COrderPriority | smallint | Order Priority | - | |
Description:No description available | ||||
CountryID | nvarchar(2) | Country | Country | |
Description:No description available | ||||
CPriceClassID | nvarchar(MAX) | Price Class ID | ARPriceClass | |
Description:No description available | ||||
CreatedByID | uniqueidentifier | Created By | Users | |
Description:No description available | ||||
CreatedByScreenID | varchar(8) | - | ||
Description:No description available | ||||
CreatedDateTime | datetime | - | ||
Description:No description available | ||||
CResedential | bit | Residential Delivery | - | |
Description:No description available | ||||
CRetainageAcctID | int | Retainage Receivable Account | - | |
Description:No description available | ||||
CRetainageSubID | int | Retainage Receivable Sub. | - | |
Description:No description available | ||||
CSalesAcctID | int | Sales Account | - | |
Description:No description available | ||||
CSalesSubID | int | Sales Sub. | - | |
Description:No description available | ||||
CSaturdayDelivery | bit | Saturday Delivery | - | |
Description:No description available | ||||
CShipComplete | char(1) | Shipping Rule | - | |
Description:No description available | ||||
CShipTermsID | nvarchar(MAX) | 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 | varchar(MAX) | Tax Calculation Mode | - | |
Description:No description available | ||||
CTaxZoneID | nvarchar(10) | Tax Zone | TaxZone | |
Description:No description available | ||||
DefAddressID | int | Default Address | Address | |
Description:No description available | ||||
DefContactID | int | Contact | ||
Description:No description available | ||||
Department | nvarchar(70) | Department | - | |
Description:No description available | ||||
Descr | nvarchar(60) | Location Name | - | |
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 | ||||
IsActive | bit | Active | - | |
Description:No description available | ||||
IsAddressSameAsMainNonexistent in DB | bit | Same as Main | - | |
Description:No description available | ||||
IsAPAccountSameAsMainNonexistent in DB | bit | - | ||
Description:No description available | ||||
IsARAccountSameAsMainNonexistent in DB | bit | - | ||
Description:No description available | ||||
IsContactSameAsMainNonexistent in DB | bit | Same as Main | - | |
Description:No description available | ||||
IsValidated | bit | Validated | - | |
Description:No description available | ||||
LastModifiedByID | uniqueidentifier | Last Modified By | Users | |
Description:No description available | ||||
LastModifiedByScreenID | varchar(8) | - | ||
Description:No description available | ||||
LastModifiedDateTime | datetime | - | ||
Description:No description available | ||||
Latitude | decimal | Latitude | - | |
Description:No description available | ||||
LocationCreatedByID | uniqueidentifier | Created By | - | |
Description:No description available | ||||
LocationCreatedByScreenID | varchar(8) | - | ||
Description:No description available | ||||
LocationCreatedDateTime | datetime | - | ||
Description:No description available | ||||
LocationID | int | LocationID | - | |
Description:No description available | ||||
LocationLastModifiedByID | uniqueidentifier | Last Modified By | - | |
Description:No description available | ||||
LocationLastModifiedByScreenID | varchar(8) | - | ||
Description:No description available | ||||
LocationLastModifiedDateTime | datetime | - | ||
Description:No description available | ||||
LocType | varchar(MAX) | Location Type | - | |
Description:No description available | ||||
Longitude | decimal | 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 | - | |
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 | ||||
TaxRegistrationID | nvarchar(50) | Tax Registration ID | - | |
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 | ||||
VAllowAPBillBeforeReceipt | bit | Allow AP Bill Before Receipt | - | |
Description:No description available | ||||
VAPAccountID | int | AP Account | - | |
Description:No description available | ||||
VAPAccountLocationID | int | - | ||
Description:No description available | ||||
VAPSubID | int | AP Sub. | - | |
Description:No description available | ||||
VBranchID | int | Receiving Branch | - | |
Description:No description available | ||||
VCarrierID | nvarchar(MAX) | 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 | - | |
Description:No description available | ||||
VDiscountSubID | int | Discount Sub. | - | |
Description:No description available | ||||
VEmailOrder | bit | Send Orders by Email | - | |
Description:No description available | ||||
VExpenseAcctID | int | Expense Account | - | |
Description:No description available | ||||
VExpenseSubID | int | Expense Sub. | - | |
Description:No description available | ||||
VFOBPointID | nvarchar(MAX) | FOB Point | FOBPoint | |
Description:No description available | ||||
VFreightAcctID | int | Freight Account | - | |
Description:No description available | ||||
VFreightSubID | int | Freight 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 | - | |
Description:No description available | ||||
VRetainageSubID | int | Retainage Payable Sub. | - | |
Description:No description available | ||||
VSeparateCheck | bit | Pay Separately | - | |
Description:No description available | ||||
VShipTermsID | nvarchar(MAX) | Shipping Terms | ShipTerms | |
Description:No description available | ||||
VSiteID | int | Warehouse | INSite | |
Description:No description available | ||||
VTaxCalcMode | varchar(MAX) | Tax Calculation Mode | - | |
Description:No description available | ||||
VTaxZoneID | nvarchar(10) | Tax Zone ID | TaxZone | |
Description:No description available | ||||