Location

PX.Objects.CR

View API Entity: Location/entity/Default/24.200.001/Location

131 of 131 fields

	Field Name	Type	Display Name	Foreign Key
	`BAccountID`Default Navigation	`int`	Account ID	BAccount
Description:No description available
	`LocationCD`Default Navigation	`nvarchar(30)`	Location ID	-
Description:The human-readable identifier of the location that is specified by the user when they create a location. This field is a natural key as opposed to the LocationID surrogate key.
	`APAccountID`Default Navigation	`int`	AP Account	-
Description:No description available
	`APRetainageAcctID`Default Navigation	`int`	Retainage Payable Account	-
Description:No description available
	`APRetainageSubID`Default Navigation	`int`	Retainage Payable Sub.	-
Description:No description available
	`APSubID`Default Navigation	`int`	AP Sub.	-
Description:The identifier of the AP subaccount. The value of this field corresponds to the value of the Sub.subID field.
	`ARAccountID`Default Navigation	`int`	AR Account	-
Description:No description available
	`ARRetainageAcctID`Default Navigation	`int`	Retainage Receivable Account	-
Description:The identifier of the AR retainage account. The value of this field corresponds to the value of the LocationARAccountSub.cRetainageAcctID field.
	`ARRetainageSubID`Default Navigation	`int`	Retainage Receivable Sub.	-
Description:The identifier of the AR retainage subaccount. The value of this field corresponds to the value of the LocationARAccountSub.CRetainageSubID field.
	`ARSubID`Default Navigation	`int`	AR Sub.	-
Description:The identifier of the AR account. The value of this field corresponds to the value of the LocationARAccountSub.CARSubID field.
	`BAccountBAccountID`	`int`		-
Description:No description available
	`CAdditionalHandling`	`bit`	Additional Handling	-
Description:No description available
	`CARAccountID`Default Navigation	`int`	AR Account	Account
Description:No description available
	`CARAccountLocationID`	`int`		-
Description:The identifier of the AR account location of the customer location. The value of this field corresponds to the Location.LocationID field.
	`CARSubID`Default Navigation	`int`	AR Sub.	Sub
Description:The identifier of the AR subaccount of the customer location. The value of this field corresponds to the value of the Sub.SubID field.
	`CashAccountID`Default Navigation	`int`	Cash Account	-
Description:No description available
	`CAvalaraCustomerUsageType`	`char(1)`	Tax Exemption Type	-
Description:The customer's entity type for reporting purposes. This field is used if the system is integrated with External Tax Calculation and the External Tax Calculation Integration feature is enabled. The field can have one of the values listed in the TXAvalaraCustomerUsageType.ListAttribute class. The default value is TXAvalaraCustomerUsageType.Default.
	`CAvalaraExemptionNumber`	`nvarchar(30)`	Tax Exemption Number	-
Description:The Avalara Exemption number of the customer location.
	`CBranchID`Default Navigation	`int`	Shipping Branch	Branch
Description:The identifier of the default branch of the customer location. The value of this field corresponds to the value of the Branch.BranchID field.
	`CCalendarID`Default Navigation	`nvarchar(10)`	Calendar	CSCalendar
Description:The type of the work calendar in the customer location. Corresponds to the value of the CSCalendar.CalendarID field.
	`CCarrierID`Default Navigation	`nvarchar(15)`	Ship Via	Carrier
Description:No description available
	`CDefProjectID`Default Navigation	`int`	Default Project	PMProject
Description:The identifier of the default project of the customer location. The value of this field corresponds to the value of the PMProject.ContractID field.
	`CDiscountAcctID`Default Navigation	`int`	Discount Account	Account
Description:The identifier of the discount account of the customer location. The value of this field corresponds to the value of the Account.AccountID field.
	`CDiscountSubID`Default Navigation	`int`	Discount Sub.	Sub
Description:The identifier of the discount subaccount of the customer's location. The value of this field corresponds to the value of the Sub.SubID field.
	`CFOBPointID`Default Navigation	`nvarchar(15)`	FOB Point	FOBPoint
Description:The customer's FOB (free on board) shipping point. The value of this field corresponds to the value of the FOBPoint.FOBPointID field.
	`CFreightAcctID`Default Navigation	`int`	Freight Account	Account
Description:The identifier of the freight account of the customer's location. The value of this field corresponds to the value of the Account.AccountID field.
	`CFreightSubID`Default Navigation	`int`	Freight Sub.	Sub
Description:The identifier of the freight subaccount of the customer location. The value of this field corresponds to the value of the Sub.SubID field.
	`CGroundCollect`	`bit`	Ground Collect	-
Description:This field indicates whether the FedEx Ground Collect program is available in this location. The default value is .
	`CInsideDelivery`	`bit`	Inside Delivery	-
Description:No description available
	`CInsurance`	`bit`	Insurance	-
Description:This field indicates whether the delivery insurance is available in this location. The default value is .
	`CLeadTime`	`smallint`	Lead Time (Days)	-
Description:The amount of lead days (the time in days from the moment when the production was finished to the moment when the customer's order was delivered).
	`CLiftGate`	`bit`	Lift Gate	-
Description:No description available
	`CLimitedAccess`	`bit`	Limited Access	-
Description:No description available
	`CMPDiscountSubID`Default Navigation	`int`	Discount Sub.	Sub
Description:The identifier of the discount subaccount of the company location. The value of this field corresponds to the value of the Sub.SubID field.
	`CMPExpenseSubID`Default Navigation	`int`	Expense Sub.	Sub
Description:The identifier of the expense subaccount of the company location. The value of this field corresponds to the value of the Sub.SubID field.
	`CMPFreightSubID`Default Navigation	`int`	Freight Sub.	Sub
Description:The identifier of the freight subaccount of the company location. The value of this field corresponds to the value of the Sub.SubID field.
	`CMPGainLossSubID`Default Navigation	`int`	Currency Gain/Loss Sub.	Sub
Description:The identifier of the currency gain and loss subaccount of the company location. The value of this field corresponds to the value of the Sub.SubID field.
	`CMPSalesSubID`Default Navigation	`int`	Sales Sub.	Sub
Description:The identifier of the sales subacount of the company location. The value of this field corresponds to the value of the Sub.SubID field.
	`CMPSiteID`Default Navigation	`int`	Warehouse	INSite
Description:The warehouse of the company location. The value of this field corresponds to the value of the INSite.siteID field.
	`COrderPriority`	`smallint`	Order Priority	-
Description:The order priority of the customer's location.
	`CPriceClassID`Default Navigation	`nvarchar(10)`	Price Class	ARPriceClass
Description:The price class of the customer. The value of this field corresponds to the value of the ARPriceClass.PriceClassID field.
	`CreatedByID`Default Navigation	`uniqueidentifier`	Created By	Users
Description:No description available
	`CreatedByScreenID`	`char(8)`		-
Description:No description available
	`CreatedDateTime`	`datetime`	Created On	-
Description:No description available
	`CResedential`	`bit`	Residential Delivery	-
Description:This field indicates whether the residential delivery is available in this location. The default value is .
	`CRetainageAcctID`Default Navigation	`int`	Retainage Receivable Account	Account
Description:The identifier of the retainage account of the customer's location. The value of this field corresponds to the value of the Account.AccountID field.
	`CRetainageSubID`Default Navigation	`int`	Retainage Receivable Sub.	Sub
Description:The identifier of the retainage subaccount of the customer's location. The value of this field corresponds to the value of the Sub.SubID field.
	`CSalesAcctID`Default Navigation	`int`	Sales Account	Account
Description:The identifier of the customer's sales account. The value of this field corresponds to the value of the Account.AccountID field.
	`CSalesSubID`Default Navigation	`int`	Sales Sub.	Sub
Description:The identifier of the customer's sales subaccount. The value of this field corresponds to the value of the Sub.SubID field.
	`CSaturdayDelivery`	`bit`	Saturday Delivery	-
Description:This field indicates whether the Saturday delivery is available in this location. The default value is .
	`CShipComplete`	`char(1)`	Shipping Rule	-
Description:The shipping rule of the customer location. The field can have one of the values listed in the SOShipComplete.ListAttribute class. The default value is SOShipComplete.CancelRemainder.
	`CShipTermsID`Default Navigation	`nvarchar(10)`	Shipping Terms	ShipTerms
Description:The customer's shipping terms. The value of this field corresponds to the value of the ShipTerms.ShipTermsID field.
	`CShipZoneID`Default Navigation	`nvarchar(15)`	Shipping Zone	ShippingZone
Description:The customer's shipping zone. The value of this field corresponds to the value of the ShippingZone.ZoneID field.
	`CSiteID`Default Navigation	`int`	Warehouse	INSite
Description:The warehouse identifier of the customer location. The value of this field corresponds to the value of the INSite.SiteID field.
	`CTaxCalcMode`	`char(1)`	Tax Calculation Mode	-
Description:The tax calculation mode of the customer. The field can have one of the values listed in the TaxCalculationMode.ListAttribute class. The default value is TaxCalculationMode.TaxSetting.
	`CTaxZoneID`Default Navigation	`nvarchar(10)`	Tax Zone	TaxZone
Description:The customer's tax zone. The value of this field corresponds to the value of the TaxZone.TaxZoneID field.
	`DefAddressID`Default Navigation	`int`	Default Address	Address
Description:The identifier of the address for this location. The value of this field corresponds to the value of the Address.AddressID field.
	`DefContactID`Default Navigation	`int`	Default Contact	Contact
Description:The identifier of the bisuness account contact of the location. The value of this field corresponds to the value of the Contact.ContactID field.
	`Descr`	`nvarchar(60)`	Location Name	-
Description:The name of the location.
	`ExtRefNbr`	`nvarchar(64)`	External ID	-
Description:The external reference number
	`IsActive`	`bit`	Active	-
Description:This field indicates whether the location is active. The default value is .
	`IsAddressSameAsMain`Nonexistent in DBObsolete	`bit`	Same as Main	-
Description:No description available
	`IsAPAccountSameAsMain`Nonexistent in DB	`bit`	Same As Default Location's	-
Description:This field indicates that the vendor AP location is not the same as this location.
	`IsAPPaymentInfoSameAsMain`Nonexistent in DB	`bit`	Same As Default Location's	-
Description:This field indicates tha the AP payment info in the default location is not the same as the one specified in this location.
	`IsARAccountSameAsMain`Nonexistent in DB	`bit`	Same As Default Location's	-
Description:This field indicates that the AR account location is the same in the customer location.
	`IsContactSameAsMain`Nonexistent in DBObsolete	`bit`	Same as Main	-
Description:No description available
	`IsDefault`	`bit`	Default	-
Description:This field indicates whether the location is default for the corresponding business account. The field value is when this location is the default location of the corresponding business account, and otherwise.
	`IsRemitAddressSameAsMain`Nonexistent in DBObsolete	`bit`	Same as Main	-
Description:No description available
	`IsRemitContactSameAsMain`Nonexistent in DBObsolete	`bit`	Same as Main	-
Description:No description available
	`LastModifiedByID`Default Navigation	`uniqueidentifier`	Last Modified By	Users
Description:No description available
	`LastModifiedByScreenID`	`char(8)`		-
Description:No description available
	`LastModifiedDateTime`	`datetime`	Last Modified On	-
Description:No description available
	`LocationAPAccountSubBAccountID`	`int`		-
Description:The identifier of the AP subaccount of the business account. The value of this field corresponds to the value of the LocationARAccountSub.BAccountID field.
	`LocationAPPaymentInfoBAccountID`	`int`		-
Description:The identifier of AP payment info of the business account. The value of this field corresponds to the value of the LocationAPPaymentInfo.bAccountID field.
	`LocationARAccountSubBAccountID`	`int`		-
Description:The identifier of the AR subaccount of the business account. The value of this field corresponds to the value of the LocationARAccountSub.BAccountID field.
	`LocationID`	`int`	LocationID	-
Description:The unique identifier assigned to the location. This field is the primary key field.
	`LocType`	`char(2)`	Location Type	-
Description:The type of the location. The field can have one of the values listed in the LocTypeList.ListAttribute class. The default value depends on the form where the location was created.
	`NoteID`	`uniqueidentifier`		-
Description:No description available
	`OverrideAddress`Nonexistent in DB	`bit`	Override	-
Description:If set to "true", indicates that the address overrides the default Address record, which is referenced by DefAddressID.
	`OverrideContact`Nonexistent in DB	`bit`	Override	-
Description:If set to "true", indicates that the address overrides the default Contact record, which is referenced by DefContactID.
	`OverrideRemitAddress`Nonexistent in DB	`bit`	Override	-
Description:This field indicates whether the remit address is not the same as the default address for this location.
	`OverrideRemitContact`Nonexistent in DB	`bit`	Override	-
Description:This field indicates whether the remit contact is not the same as the default contact for this location.
	`PaymentByType`	`int`	Payment By	-
Description:The option that defines when the customer should be paid at this location. The field can have one of the values listed in the APPaymentBy.List class. The default value is APPaymentBy.DueDate.
	`PaymentLeadTime`	`smallint`	Payment Lead Time (Days)	-
Description:The amount of payment lead days.
	`PaymentMethodID`	`nvarchar(10)`	Payment Method	-
Description:The identifier of the payment method. The value of this field corresponds to the value of the LocationAPPaymentInfo.VPaymentMethodID field.
	`PseudonymizationStatus`	`int`	Pseudonymized	-
Description:No description available
	`RemitAddressID`Nonexistent in DBObsolete	`int`		-
Description:No description available
	`RemitContactID`Nonexistent in DBObsolete	`int`		-
Description:No description available
	`SeparateCheck`	`bit`	Pay Separately	-
Description:This field indicates whether the vendor should pay separately. The default value is .
	`Status`	`char(1)`	Status	-
Description:The current status of the location. The field can have one of the values listed in the LocationStatus.ListAttribute class. The default value is LocationStatus.Active.
	`TaxRegistrationID`	`nvarchar(50)`	Tax Registration ID	-
Description:The registration ID of the company in the state tax authority.
	`tstamp`	`timestamp`		-
Description:No description available
	`VAllowAPBillBeforeReceipt`	`bit`	Allow AP Bill Before Receipt	-
Description:This field indicates that, in this location, a vendor can create a bill before creating a receipt.
	`VAPAccountID`Default Navigation	`int`	AP Account	Account
Description:No description available
	`VAPAccountLocationID`	`int`		-
Description:The identifier of the AP location of the vendor location. The value of this field corresponds to the value of the Location.LocationID field.
	`VAPSubID`Default Navigation	`int`	AP Sub.	Sub
Description:The identifier of the AP subaccount of the vendor location. The value of this field corresponds to the value of the Sub.subID field.
	`VBranchID`Default Navigation	`int`	Receiving Branch	Branch
Description:The identifier of the default branch of the vendor location. The value of this field corresponds to the value of the Branch.branchID field.
	`VCarrierID`Default Navigation	`nvarchar(15)`	Ship Via	Carrier
Description:No description available
	`VCashAccountID`Default Navigation	`int`	Cash Account	CashAccount
Description:No description available
	`VDefAddressID`	`int`		-
Description:The identifier of the vendor's default address of the location. The value of this field corresponds to the value of the Address.AddressID field.
	`VDefContactID`	`int`		-
Description:The identifier of the vendor's default contact of the location. The value of this field corresponds to the value of the Contact.ContactID field.
	`VDefProjectID`Default NavigationObsolete	`int`	Default Project	PMProject
Description:The identifier of the default project for the vendor location. The value of this field corresponds to the value of the PMProject.ContractID field.
	`VDiscountAcctID`Default Navigation	`int`	Discount Account	Account
Description:No description available
	`VDiscountSubID`Default Navigation	`int`	Discount Sub.	Sub
Description:No description available
	`VEmailOrder`	`bit`	Email Order	-
Description:This field indicates whether the order should be sent by email in the vendor location. The default value is .
	`VExpenseAcctID`Default Navigation	`int`	Expense Account	Account
Description:The identifier of the expense account of the vendor location. The value of this field corresponds to the Account.AccountID field.
	`VExpenseSubID`Default Navigation	`int`	Expense Sub.	Sub
Description:The identifier of the expense subaccount of the vendor location. The value of this field corresponds to the value of the Sub.SubID field.
	`VFOBPointID`Default Navigation	`nvarchar(15)`	FOB Point	FOBPoint
Description:The vendor's FOB (free on board) shipping point. The value of this field corresponds to the value of the FOBPoint.fOBPointID field.
	`VFreightAcctID`Default Navigation	`int`	Freight Account	Account
Description:The identidier of the freight account of the vendor location. The value of this field corresponds to the value of the Account.AccountID field.
	`VFreightSubID`Default Navigation	`int`	Freight Sub.	Sub
Description:The identifier of the freight subaccount of the vendor location. The value of this field corresponds to the value of the Sub.SubID field.
	`VLeadTime`	`smallint`	Lead Time (Days)	-
Description:The amount of lead days (the time in days from the moment when the production was finished to the moment when the vendor's order was delivered).
	`VPaymentByType`	`int`	Payment By	-
Description:An option that defines when a vendor should be paid at this location. The field can have one of the values listed in the APPaymentBy.List class. The default value is APPaymentBy.DueDate.
	`VPaymentInfoLocationID`	`int`		-
Description:The indentifier of the vendor payment info in the vendor location. The value of this field corresponds to the value of the Location.LocationID field.
	`VPaymentLeadTime`	`smallint`	Payment Lead Time (Days)	-
Description:The amount of the payment lead days for the vendor location.
	`VPaymentMethodID`Default Navigation	`nvarchar(10)`	Payment Method	PaymentMethod
Description:No description available
	`VPrepaymentPct`	`decimal(9, 6)`	Prepayment Percent	-
Description:The amount of prepayment percentage for the vendor location. The default value is 100.
	`VPrintOrder`	`bit`	Print Order	-
Description:This field indicates whether the order an order should be printed in the vendor location. The default value is .
	`VRcptQtyAction`	`char(1)`	Receipt Action	-
Description:The type of the receipt action for the vendor location. The field can have one of the values listed in the POReceiptQtyAction.ListAttribute class. The default value is POReceiptQtyAction.AcceptButWarn.
	`VRcptQtyMax`	`decimal(9, 6)`	Max. Receipt (%)	-
Description:The maximum receipt amount for the vendor location in percentages.
	`VRcptQtyMin`	`decimal(9, 6)`	Min. Receipt (%)	-
Description:The minimal receipt amount for the vendor location in percentages.
	`VRcptQtyThreshold`	`decimal(9, 6)`	Threshold Receipt (%)	-
Description:The threshold receipt amount for the vendor location in percentages.
	`VRemitAddressID`	`int`		Address
Description:The identifier of the remit address of the vendor location. The value of this field corresponds to the value of the Address.AddressID field.
	`VRemitContactID`	`int`		Contact
Description:The identifier of the remit contact identifier of the vendor location. The value of this field corresponds to the value of the Contact.ContactID field.
	`VRetainageAcctID`Default Navigation	`int`	Retainage Payable Account	Account
Description:The identifier of the retainage account of the vendor location. The value of this field corresponds to the value of the Account.AccountID field.
	`VRetainageSubID`Default Navigation	`int`	Retainage Payable Sub.	Sub
Description:The identifier of the retainage subaccount of the vendor location. The value of this field corresponds to the value of the Sub.SubID field.
	`VSeparateCheck`	`bit`	Pay Separately	-
Description:This field indicates whether a vendor should pay separately in this location. The default value is .
	`VShipTermsID`Default Navigation	`nvarchar(10)`	Shipping Terms	ShipTerms
Description:The vendor's shipping terms. Corresponds to the value of the ShipTerms.shipTermsID field.
	`VSiteID`Default Navigation	`int`	Warehouse	INSite
Description:The warehouse identifier of the vendor location. The value of this field corresponds to the value of the INSite.siteID field.
	`VSiteIDIsNull`	`smallint`		-
Description:No description available
	`VTaxCalcMode`	`char(1)`	Tax Calculation Mode	-
Description:The vendor's tax calculation mode. The field can have one of the values listed in the TaxCalculationMode.ListAttribute class. The default value is TaxCalculationMode.TaxSetting.
	`VTaxZoneID`Default Navigation	`nvarchar(10)`	Tax Zone	TaxZone
Description:The vendor's tax zone. The value of this field corresponds to the value of the TaxZone.taxZoneID field.