CR
LocationAlias
No summary is documented for this DAC in the release source.
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
APAccountID | int | AP Account | Account | |
Description:The identifier of the AP account. The value of this field corresponds to the value of the Account.AccountID field. | ||||
APRetainageAcctID | int | Retainage Payable Account | Account | |
Description:The identifier of the AP retainage account. The value of this field corresponds to the value of the LocationAPAccountSub.VRetainageAcctID field. | ||||
APRetainageSubID | int | Retainage Payable Sub. | Sub | |
Description:The identifier of the AP retainage subaccount. The value of this field corresponds to the value of the LocationAPAccountSub.VRetainageSubID field. | ||||
APSubID | int | AP Sub. | Sub | |
Description:The identifier of the AP subaccount. The value of this field corresponds to the value of the Sub.subID field. | ||||
ARAccountID | int | AR Account | Account | |
Description:The identifier of the AR account. The value of this field corresponds to the value of the Account.AccountID field. | ||||
ARRetainageAcctID | int | Retainage Receivable Account | Account | |
Description:The identifier of the AR retainage account. The value of this field corresponds to the value of the LocationARAccountSub.cRetainageAcctID field. | ||||
ARRetainageSubID | int | Retainage Receivable Sub. | Sub | |
Description:The identifier of the AR retainage subaccount. The value of this field corresponds to the value of the LocationARAccountSub.CRetainageSubID field. | ||||
ARSubID | int | AR Sub. | 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 | ||||
BAccountID | int | Account ID | BAccount | |
Description:The identifier of the BAccount record that is specified in the document to which the location belongs. The value of this field corresponds to the value of the BAccount.BAccountID field. | ||||
CARAccountID | int | AR Account | Account | |
Description:The identifier of the AR account of the customer location. The value of this field corresponds to the value of the Location.LocationID field. | ||||
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 | 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. | ||||
CAdditionalHandling | bit | Additional Handling | - | |
Description:A Boolean value that enables the additional handling shipping option (if set to true). | ||||
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 | int | Shipping 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 | 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 | nvarchar(15) | Ship Via | Carrier | |
Description:The shipping carrier for the vendor location. The value of this field corresponds to the Carrier.carrierID field. | ||||
CDefProjectID | 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 | 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 | 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 | 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 | 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 | 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 false. | ||||
CInsideDelivery | bit | Inside Delivery | - | |
Description:A Boolean value that enables the inside delivery shipping option (if set to true). | ||||
CInsurance | bit | Insurance | - | |
Description:This field indicates whether the delivery insurance is available in this location. The default value is false. | ||||
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:A Boolean value that enables the lift gate shipping option (if set to true). | ||||
CLimitedAccess | bit | Limited Access | - | |
Description:A Boolean value that enables the limited access shipping option (if set to true). | ||||
CMPDiscountSubID | 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 | 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 | 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 | 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. | ||||
CMPPayrollSubID | int | Payroll Sub. | Sub | |
Description:No description available | ||||
CMPSalesSubID | 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 | 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 | 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. | ||||
CResedential | bit | Residential Delivery | - | |
Description:This field indicates whether the residential delivery is available in this location. The default value is false. | ||||
CRetainageAcctID | 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 | 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 | 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 | 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 false. | ||||
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 | 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 | 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 | 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 | 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. | ||||
CashAccountID | int | Cash Account | - | |
Description:The identifier of the cash account. The value of this field corresponds to the value of the LocationAPPaymentInfo.VCashAccountID field. | ||||
CreatedByID | uniqueidentifier | Created By | Users | |
Description:No description available | ||||
CreatedByScreenID | char(8) | - | ||
Description:No description available | ||||
CreatedDateTime | datetime | Created On | - | |
Description:No description available | ||||
DefAddressID | 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 | 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 | ||||
IsAPAccountSameAsMainNonexistent in DB | bool? | Same As Default Location's | - | |
Description:This field indicates that the vendor AP location is not the same as this location. | ||||
IsAPPaymentInfoSameAsMainNonexistent in DB | bool? | 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. | ||||
IsARAccountSameAsMainNonexistent in DB | bool? | Same As Default Location's | - | |
Description:This field indicates that the AR account location is the same in the customer location. | ||||
IsActive | bit | Active | - | |
Description:This field indicates whether the location is active. The default value is true. | ||||
IsAddressSameAsMainNonexistent in DBObsolete | bool? | Same as Main | - | |
Description:No description available | ||||
IsContactSameAsMainNonexistent in DBObsolete | bool? | Same as Main | - | |
Description:No description available | ||||
IsDefaultNonexistent in DB | bool? | Default | - | |
Description:This field indicates whether the location is default for the corresponding business account. The field value is true when this location is the default location of the corresponding business account, and false otherwise. | ||||
IsRemitAddressSameAsMainNonexistent in DBObsolete | bool? | Same as Main | - | |
Description:No description available | ||||
IsRemitContactSameAsMainNonexistent in DBObsolete | bool? | Same as Main | - | |
Description:No description available | ||||
LastModifiedByID | 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 | ||||
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. | ||||
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. | ||||
LocationCD | nvarchar | 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. | ||||
LocationID | int | - | ||
Description:The unique identifier assigned to the location. This field is the primary key field. | ||||
NoteID | uniqueidentifier | - | ||
Description:No description available | ||||
OverrideAddressNonexistent in DB | bool? | Override | - | |
Description:If set to "true", indicates that the address overrides the default Address record, which is referenced by DefAddressID. | ||||
OverrideContactNonexistent in DB | bool? | Override | - | |
Description:If set to "true", indicates that the address overrides the default Contact record, which is referenced by DefContactID. | ||||
OverrideRemitAddressNonexistent in DB | bool? | Override | - | |
Description:This field indicates whether the remit address is not the same as the default address for this location. | ||||
OverrideRemitContactNonexistent in DB | bool? | 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. | ||||
PaymentSettingsHashNonexistent in DB | string | - | ||
Description:No description available | ||||
PaymentSettingsWasAlteredNonexistent in DB | string | Payment Settings Was Altered | - | |
Description:No description available | ||||
PseudonymizationStatus | int | Pseudonymized | - | |
Description:No description available | ||||
RemitAddressIDNonexistent in DBObsolete | int? | - | ||
Description:No description available | ||||
RemitContactIDNonexistent 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 false. | ||||
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. | ||||
VAPAccountID | int | AP Account | Account | |
Description:The identifier of the AP account of the vendor location. The value of this field corresponds to the value of the Account.accountID field. | ||||
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 | 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. | ||||
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. | ||||
VBranchID | int | Receiving 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 | nvarchar(15) | Ship Via | Carrier | |
Description:The shipping carrier for the customer location. The value of this field corresponds to the value of the Carrier.CarrierID field. | ||||
VCashAccountID | int | Cash Account | - | |
Description:The cash account indentifier of the vendor location. The value of this field corresponds to the value of the CashAccount.CashAccountID field. | ||||
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. | ||||
VDefProjectIDObsolete | 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 | int | Discount Account | Account | |
Description:The identifier of the discount account of the vendor location. The value of this field corresponds to the value of the Account.AccountID field. | ||||
VDiscountSubID | int | Discount Sub. | Sub | |
Description:The identifier of the discount subaccount of the vendor location. The value of this field corresponds to the value of the Sub.SubID field. | ||||
VEmailOrder | bit | Email Order | - | |
Description:This field indicates whether the order should be sent by email in the vendor location. The default value is false. | ||||
VExpenseAcctID | 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 | 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 | 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 | 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 | 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 | nvarchar(10) | Payment Method | PaymentMethod | |
Description:The payment method indentifier of the vendor location. The value of this field corresponds to the value of the PaymentMethod.PaymentMethodID field. | ||||
VPrepaymentPct | decimal | 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 false. | ||||
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 | Max. Receipt (%) | - | |
Description:The maximum receipt amount for the vendor location in percentages. | ||||
VRcptQtyMin | decimal | Min. Receipt (%) | - | |
Description:The minimal receipt amount for the vendor location in percentages. | ||||
VRcptQtyThreshold | decimal | 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 | 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 | 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 false. | ||||
VShipTermsID | nvarchar(10) | Shipping Terms | ShipTerms | |
Description:The vendor's shipping terms. Corresponds to the value of the ShipTerms.shipTermsID field. | ||||
VSiteID | 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. | ||||
VSiteIDIsNullNonexistent in DB | short? | - | ||
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 | 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. | ||||
VendorNameNonexistent in DB | string | Vendor Name | - | |
Description:No description available | ||||
WageAccountID | int | Pay Clearing Account | Account | |
Description:No description available | ||||
WageSubAccountID | int | Pay Clearing Sub Account | Sub | |
Description:No description available | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||