AR
ARSalesPrice
An accounts receivable sales price. Depending on the specified price type, a sales price record can define a base price, a price for a given customer, or a price for a certain customer price class. The entities of this type can be edited on the Sales Prices (AR202000) form, which corresponds to the ARSalesPriceMaint graph.
View API Entity: SalesPriceDetail
/entity/Default/25.200.001/SalesPriceDetail| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
AlternateID | nvarchar(50) | Alternate ID | - | |
Description:No description available | ||||
BreakQty API | decimal | Break Qty | - | |
Description:No description available | ||||
CreatedByID | uniqueidentifier | Created By | Users | |
Description:No description available | ||||
CreatedByScreenID | char(8) | - | ||
Description:No description available | ||||
CreatedDateTime API | datetime | - | ||
Description:No description available | ||||
CuryID API | nvarchar(5) | Currency | Currency | |
Description:No description available | ||||
CustPriceClassID | nvarchar(10) | Customer Price Class | ARPriceClass | |
Description:No description available | ||||
CustomerCDNonexistent in DB | string | - | ||
Description:No description available | ||||
CustomerID | int | Customer | Customer | |
Description:No description available | ||||
string | Description | - | ||
Description:No description available | ||||
Discountable | bit | Apply Discounts to Fair Value | - | |
Description:No description available | ||||
EffectiveDate API | datetime | Effective Date | - | |
Description:No description available | ||||
ExpirationDate API | datetime | Expiration Date | - | |
Description:No description available | ||||
InventoryCDNonexistent in DB | string | - | ||
Description:No description available | ||||
InventoryID API | int | Inventory ID | InventoryItem | |
Description:No description available | ||||
IsFairValue | bit | Fair Value | - | |
Description:No description available | ||||
IsPromotionalPrice API | bit | Promotion | - | |
Description:No description available | ||||
IsProrated | bit | Prorated | - | |
Description:No description available | ||||
ItemClassIDNonexistent in DB | int? | - | ||
Description:No description available | ||||
ItemStatusNonexistent in DB | string | - | ||
Description:No description available | ||||
LastModifiedByID | uniqueidentifier | Last Modified By | Users | |
Description:No description available | ||||
LastModifiedByScreenID | char(8) | - | ||
Description:No description available | ||||
LastModifiedDateTime API | datetime | - | ||
Description:No description available | ||||
NoteID API | uniqueidentifier | - | ||
Description:No description available | ||||
PriceClassIDNonexistent in DB | string | - | ||
Description:No description available | ||||
string | Price Code | PXBqlTable | ||
Description:No description available | ||||
PriceManagerIDNonexistent in DB | int? | - | ||
Description:No description available | ||||
PriceType API | char(1) | Price Type | - | |
Description:No description available | ||||
PriceWorkgroupIDNonexistent in DB | int? | - | ||
Description:No description available | ||||
RecordID API | int | - | ||
Description:No description available | ||||
SalesPrice API | decimal | Price | - | |
Description:No description available | ||||
SiteID API | int | Warehouse | INSite | |
Description:No description available | ||||
SkipLineDiscounts | bit | Ignore Automatic Line Discounts | - | |
Description:Determines whether price is excluded from line discount calculation. | ||||
TaxCalcMode API | char(1) | Tax Calculation Mode | - | |
Description:No description available | ||||
TaxCategoryIDNonexistent in DB | string | Tax Category | - | |
Description:Identifier of the TaxCategory associated with the item. Corresponds to the TaxCategory.TaxCategoryID field. | ||||
nvarchar(60) | Tax | Tax | ||
Description:No description available | ||||
UOM API | nvarchar(6) | UOM | INUnit | |
Description:No description available | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||