CR
Location
No summary is documented for this DAC in the release source.
View API Entity: Vendor
/entity/Default/25.200.001/Vendor| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
BAccountID | int | Account ID | - | |
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 | - | |
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. | - | |
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 | - | |
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 | - | |
Description:The shipping carrier for the vendor location. The value of this field corresponds to the Carrier.carrierID field. | ||||
CDefProjectID | int | Default Project | - | |
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 | - | |
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. | - | |
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 | - | |
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 | - | |
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. | - | |
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:No description available | ||||
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:No description available | ||||
CMPDiscountSubID | int | Discount 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. | - | |
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. | - | |
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. | - | |
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. | - | |
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 | - | |
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 | - | |
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 | - | |
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. | - | |
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 | - | |
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. | - | |
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 | - | |
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 | - | |
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 | - | |
Description:The customer's tax zone. The value of this field corresponds to the value of the TaxZone.TaxZoneID 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 API | 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. | ||||
LocationCD | nvarchar | - | ||
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 | ||||
bool? | Override | - | ||
Description:If set to "true", indicates that the address overrides the default Address record, which is referenced by DefAddressID. | ||||
bool? | Override | - | ||
Description:If set to "true", indicates that the address overrides the default Contact record, which is referenced by DefContactID. | ||||
bool? | Override | - | ||
Description:This field indicates whether the remit address is not the same as the default address for this location. | ||||
bool? | Override | - | ||
Description:This field indicates whether the remit contact is not the same as the default contact for this location. | ||||
PseudonymizationStatus | int | Pseudonymized | - | |
Description:No description available | ||||
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 API | nvarchar(50) | Tax Registration ID | - | |
Description:The registration ID of the company in the state tax authority. | ||||
VAPAccountID API | int | AP 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 API | int | AP 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 API | 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 API | nvarchar(15) | Ship Via | - | |
Description:The shipping carrier for the customer location. The value of this field corresponds to the value of the Carrier.CarrierID field. | ||||
VCashAccountID API | 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. | ||||
VDefProjectIDObsolete | int | Default Project | - | |
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 | - | |
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. | - | |
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 API | 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 | - | |
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. | - | |
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 API | nvarchar(15) | FOB Point | - | |
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 | - | |
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. | - | |
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 API | 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 API | 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 API | smallint | Payment Lead Time (Days) | - | |
Description:The amount of the payment lead days for the vendor location. | ||||
VPaymentMethodID API | nvarchar(10) | Payment Method | - | |
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 API | 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 API | 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 API | decimal | Max. Receipt (%) | - | |
Description:The maximum receipt amount for the vendor location in percentages. | ||||
VRcptQtyMin API | decimal | Min. Receipt (%) | - | |
Description:The minimal receipt amount for the vendor location in percentages. | ||||
VRcptQtyThreshold API | 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 | - | |
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. | - | |
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 API | bit | Pay Separately | - | |
Description:This field indicates whether a vendor should pay separately in this location. The default value is false. | ||||
VShipTermsID API | nvarchar(10) | Shipping Terms | - | |
Description:The vendor's shipping terms. Corresponds to the value of the ShipTerms.shipTermsID field. | ||||
VSiteID API | 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 API | 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 API | nvarchar(10) | Tax Zone | - | |
Description:The vendor's tax zone. The value of this field corresponds to the value of the TaxZone.taxZoneID field. | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||