AR
ARPriceWorksheetDetail
A pending sales price record belonging to a sales price worksheet. The actual sales prices are updated upon the worksheet release. The entities of this type can be edited on the Sales Price Worksheets (AR202010) form, which corresponds to the ARPriceWorksheetMaint graph.
View API Entity: SalesPricesWorksheetDetail
/entity/Default/25.200.001/SalesPricesWorksheetDetail| 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 | datetime | - | ||
Description:No description available | ||||
CurrentPrice API | decimal | Source Price | - | |
Description:No description available | ||||
CuryID API | nvarchar(5) | Currency | Currency | |
Description:No description available | ||||
CustPriceClassID | nvarchar(10) | ARPriceClass | ||
Description:No description available | ||||
CustomerCD | nvarchar(30) | - | ||
Description:No description available | ||||
CustomerID | int | Customer | Customer | |
Description:No description available | ||||
Description | nvarchar(256) | Description | - | |
Description:No description available | ||||
InventoryCD API | nvarchar | - | ||
Description:No description available | ||||
InventoryID API | int | Inventory ID | InventoryItem | |
Description:No description available | ||||
LastModifiedByID | uniqueidentifier | Last Modified By | Users | |
Description:No description available | ||||
LastModifiedByScreenID | char(8) | - | ||
Description:No description available | ||||
LastModifiedDateTime | datetime | - | ||
Description:No description available | ||||
LineID API | int | - | ||
Description:No description available | ||||
PendingPrice API | decimal | Pending Price | - | |
Description:No description available | ||||
string | Price Code | PXBqlTable | ||
Description:No description available | ||||
PriceType API | char(1) | Price Type | - | |
Description:No description available | ||||
RefNbr API | nvarchar(15) | Reference Nbr. | ARPriceWorksheet | |
Description:No description available | ||||
RestrictInventoryByAlternateIDNonexistent in DB | bool? | - | ||
Description:No description available | ||||
SiteID | int | Warehouse | INSite | |
Description:No description available | ||||
SkipLineDiscounts | bit | Ignore Automatic Line Discounts | - | |
Description:Value to be transferred to the ARSalesPrice.SkipLineDiscounts on release of worksheet. | ||||
SubItemID | int | Subitem | INSubItem | |
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 | ||||