CR
CROpportunityProducts
PX.Objects.CR59 of 59 fields
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
LineNbr | int | Line Nbr. | - | |
Description:No description available | ||||
QuoteID | uniqueidentifier | CROpportunity | ||
Description:No description available | ||||
Amount | decimal(19, 4) | - | ||
Description:No description available | ||||
BaseQuantity | decimal(25, 6) | Base Qty. | - | |
Description:No description available | ||||
CalculateDiscountsOnImportNonexistent in DB | bit | Calculate automatic discounts on import | - | |
Description:No description available | ||||
CostCodeID | int | Cost Code | - | |
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 | ||||
CuryAmount | decimal(19, 4) | Amount | - | |
Description:No description available | ||||
CuryDiscAmt | decimal(19, 4) | Discount Amount | - | |
Description:No description available | ||||
CuryExtCost | decimal(19, 4) | Ext. Cost | - | |
Description:No description available | ||||
CuryExtPrice | decimal(19, 4) | Ext. Price | - | |
Description:No description available | ||||
CuryInfoID | bigint | - | ||
Description:No description available | ||||
CuryUnitCost | decimal(19, 6) | Unit Cost | - | |
Description:No description available | ||||
CuryUnitPrice | decimal(19, 6) | Unit Price | - | |
Description:No description available | ||||
CustomerID | int | - | ||
Description:No description available | ||||
Descr | nvarchar(256) | Description | - | |
Description:No description available | ||||
DiscAmt | decimal(19, 4) | - | ||
Description:No description available | ||||
DiscountID | nvarchar(10) | Discount Code | ARDiscount | |
Description:No description available | ||||
DiscountsAppliedToLine | varbinary(MAX) | - | ||
Description:No description available | ||||
DiscountSequenceID | nvarchar(10) | Discount Sequence | - | |
Description:No description available | ||||
DiscPct | decimal(19, 6) | Discount, % | - | |
Description:No description available | ||||
DocumentDiscountRate | decimal(21, 18) | - | ||
Description:No description available | ||||
EmployeeID | int | Employee ID | EPEmployee | |
Description:No description available | ||||
ExpenseAccountGroupID | int | Cost Account Group | - | |
Description:No description available | ||||
ExtCost | decimal(19, 4) | - | ||
Description:No description available | ||||
ExtPrice | decimal(19, 4) | - | ||
Description:No description available | ||||
GroupDiscountRate | decimal(21, 18) | - | ||
Description:No description available | ||||
GroupLineNbr | int | Group Line Nbr. | - | |
Description:No description available | ||||
InventoryID | int | Inventory ID | InventoryItem | |
Description:No description available | ||||
IsFree | bit | Free Item | - | |
Description:No description available | ||||
IsGroup | bit | Group | - | |
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 | ||||
LineType | nvarchar(3) | Type | - | |
Description:No description available | ||||
ManualDisc | bit | Manual Discount | - | |
Description:No description available | ||||
ManualPrice | bit | Manual Price | - | |
Description:No description available | ||||
NoteID | uniqueidentifier | - | ||
Description:No description available | ||||
POCreate | bit | Mark for PO | - | |
Description:No description available | ||||
PreferredVendorIDNonexistent in DB | int | - | ||
Description:No description available | ||||
ProjectID | int | - | ||
Description:No description available | ||||
Quantity | decimal(25, 6) | Quantity | - | |
Description:No description available | ||||
RevenueAccountGroupID | int | Revenue Account Group | - | |
Description:No description available | ||||
SiteID | int | Warehouse | INSite | |
Description:No description available | ||||
SkipLineDiscounts | bit | Ignore Automatic Line Discounts | - | |
Description:Indicates (if selected) that the automatic line discounts are not applied to this line. | ||||
SortOrder | int | Sort Order | - | |
Description:No description available | ||||
StockItemTypeNonexistent in DB | nchar(1) | - | ||
Description:No description available | ||||
SubItemID | int | Subitem | INSubItem | |
Description:No description available | ||||
TaskCD | nvarchar(30) | Project Task | - | |
Description:No description available | ||||
TaskID | int | Project Task | PMTask | |
Description:No description available | ||||
TaxCategoryID | nvarchar(15) | Tax Category | TaxCategory | |
Description:No description available | ||||
TextForProductsGridNonexistent in DB | nvarchar(MAX) | Availability footer | - | |
Description:No description available | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||
UnitCost | decimal(19, 6) | - | ||
Description:No description available | ||||
UnitPrice | decimal(19, 6) | - | ||
Description:No description available | ||||
UOM | nvarchar(6) | UOM | INUnit | |
Description:No description available | ||||
VendorID | int | Vendor ID | BAccount | |
Description:No description available | ||||