AR
ARPriceWorksheetDetail
PX.Objects.AR29 of 29 fields
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
LineID | int | - | ||
Description:No description available | ||||
RefNbr | nvarchar(15) | Reference Nbr. | ARPriceWorksheet | |
Description:No description available | ||||
AlternateID | nvarchar(50) | Alternate ID | - | |
Description:No description available | ||||
BreakQty | decimal(19, 4) | 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 | decimal(19, 6) | Source Price | - | |
Description:No description available | ||||
CuryID | nvarchar(5) | Currency | Currency | |
Description:No description available | ||||
CustomerCD | nvarchar(30) | - | ||
Description:No description available | ||||
CustomerID | int | Customer | Customer | |
Description:No description available | ||||
CustPriceClassID | nvarchar(10) | ARPriceClass | ||
Description:No description available | ||||
Description | nvarchar(256) | Description | - | |
Description:No description available | ||||
InventoryCD | nvarchar(MAX) | - | ||
Description:No description available | ||||
InventoryID | 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 | ||||
PendingPrice | decimal(19, 6) | Pending Price | - | |
Description:No description available | ||||
PriceCode | nvarchar(30) | Price Code | - | |
Description:No description available | ||||
PriceType | char(1) | Price Type | - | |
Description:No description available | ||||
RestrictInventoryByAlternateIDNonexistent in DB | bit | - | ||
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 | nvarchar(15) | Tax Category | - | |
Description:Identifier of the TaxCategory associated with the item. Corresponds to the TaxCategory.TaxCategoryID field. | ||||
TaxIDObsolete | nvarchar(60) | Tax | Tax | |
Description:No description available | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||
UOM | nvarchar(6) | UOM | INUnit | |
Description:No description available | ||||