Skip to main content
AR

ARSalesPrice

PX.Objects.AR
Field NameTypeDisplay NameForeign Key
RecordID
int-
Description:No description available
AlternateID
nvarchar(50)Alternate ID-
Description:No description available
BreakQty
decimal(19, 4)Break Qty-
Description:No description available
CreatedByIDDefault Navigation
uniqueidentifierCreated ByUsers
Description:No description available
CreatedByScreenID
char(8)-
Description:No description available
CreatedDateTime
datetime-
Description:No description available
CuryIDDefault Navigation
nvarchar(5)CurrencyCurrency
Description:No description available
CustomerCDNonexistent in DB
nvarchar(30)-
Description:No description available
CustomerIDDefault Navigation
intCustomerCustomer
Description:No description available
CustPriceClassIDDefault Navigation
nvarchar(10)Customer Price ClassARPriceClass
Description:No description available
DescriptionNonexistent in DB
nvarchar(256)Description-
Description:No description available
Discountable
bitApply Discounts to Fair Value-
Description:No description available
EffectiveDate
datetime2Effective Date-
Description:No description available
ExpirationDate
datetime2Expiration Date-
Description:No description available
InventoryCDNonexistent in DB
nvarchar(MAX)-
Description:No description available
InventoryIDDefault Navigation
intInventory IDInventoryItem
Description:No description available
IsFairValue
bitFair Value-
Description:No description available
IsPromotionalPrice
bitPromotion-
Description:No description available
IsProrated
bitProrated-
Description:No description available
ItemClassIDNonexistent in DB
int-
Description:No description available
ItemStatusNonexistent in DB
nchar(2)-
Description:No description available
LastModifiedByIDDefault Navigation
uniqueidentifierLast Modified ByUsers
Description:No description available
LastModifiedByScreenID
char(8)-
Description:No description available
LastModifiedDateTime
datetime-
Description:No description available
NoteID
uniqueidentifier-
Description:No description available
PriceClassIDNonexistent in DB
nvarchar(30)-
Description:No description available
PriceCodeDefault NavigationNonexistent in DB
nvarchar(30)Price Code-
Description:No description available
PriceManagerIDNonexistent in DB
int-
Description:No description available
PriceType
char(1)Price Type-
Description:No description available
PriceWorkgroupIDNonexistent in DB
int-
Description:No description available
SalesPrice
decimal(19, 6)Price-
Description:No description available
SiteIDDefault Navigation
intWarehouseINSite
Description:No description available
SkipLineDiscounts
bitIgnore Automatic Line Discounts-
Description:Determines whether price is excluded from line discount calculation.
TaxCalcMode
char(1)Tax Calculation Mode-
Description:No description available
TaxCategoryIDNonexistent in DB
nvarchar(15)Tax Category-
Description:Identifier of the TaxCategory associated with the item. Corresponds to the TaxCategory.TaxCategoryID field.
TaxIDDefault NavigationObsolete
nvarchar(60)TaxTax
Description:No description available
tstamp
timestamp-
Description:No description available
UOMDefault Navigation
nvarchar(6)UOMINUnit
Description:No description available