Skip to main content
CR

CROpportunityProducts

PX.Objects.CRRelease 2025.2

No summary is documented for this DAC in the release source.

Field NameTypeDisplay NameForeign Key
AMConfigKeyIDDefault Navigation
nvarchar(120)Config. KeyAMConfigurationKeys
Description:Configuration key ID which represents the key used/generated from the results of a finished configuration
AMConfigurationID
nvarcharConfiguration ID-
Description:No description available
AMIsSupplemental
bitIs Supplemental-
Description:No description available
AMParentLineNbr
intParent Line Nbr.-
Description:No description available
AMSelectedNonexistent in DB
bool?Selected-
Description:No description available
Amount
decimal-
Description:No description available
BaseQuantity
decimalBase Qty.-
Description:No description available
BillingRule
char(4)Billing Rule-
Description:No description available
CalculateDiscountsOnImportNonexistent in DB
bool?Calculate automatic discounts on import-
Description:No description available
CostCodeIDDefault Navigation
intCost Code-
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
CuryAmount API
decimalAmount-
Description:No description available
CuryDiscAmt API
decimalDiscount Amount-
Description:No description available
CuryExtCost
decimalExt. Cost-
Description:No description available
CuryExtPrice API
decimalExt. Price-
Description:No description available
CuryInfoID
bigint-
Description:No description available
CuryUnitCost
decimalUnit Cost-
Description:No description available
CuryUnitPrice API
decimalUnit Price-
Description:No description available
CustomerID
int-
Description:No description available
Descr API
nvarchar(256)Description-
Description:No description available
DiscAmt
decimal-
Description:No description available
DiscPct API
decimalDiscount, %-
Description:No description available
DiscountID API Default Navigation
nvarchar(10)Discount CodeARDiscount
Description:No description available
DiscountSequenceID API
nvarchar(10)Discount Sequence-
Description:No description available
DiscountsAppliedToLine
varbinary-
Description:No description available
DocumentDiscountRate
decimal-
Description:No description available
EmployeeIDDefault Navigation
intEmployee IDEPEmployee
Description:No description available
EstimatedDuration
intEstimated Duration-
Description:No description available
ExpenseAccountGroupID
intCost Account Group-
Description:The identifier of the cost account group.
ExtCost
decimal-
Description:No description available
ExtPrice
decimal-
Description:No description available
GroupDiscountRate
decimal-
Description:No description available
GroupLineNbr
intGroup Line Nbr.-
Description:No description available
InventoryID API Default Navigation
intInventory IDInventoryItem
Description:No description available
IsConfigurableNonexistent in DB
bool?Configurable-
Description:No description available
IsFree API
bitFree Item-
Description:No description available
IsGroup
bitGroup-
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
LineNbr API
intLine Nbr.-
Description:No description available
LineType
nvarchar(3)Type-
Description:No description available
ManualDisc API
bitManual Discount-
Description:No description available
ManualPrice
bitManual Price-
Description:No description available
NoteID
uniqueidentifier-
Description:No description available
POCreate
bitMark for PO-
Description:No description available
PreferredVendorIDNonexistent in DB
int?-
Description:No description available
ProjectID
int-
Description:No description available
Quantity API
decimalQuantity-
Description:No description available
QuoteID
uniqueidentifierCROpportunity
Description:No description available
RevenueAccountGroupID
intRevenue Account Group-
Description:The identifier of the revenue account group.
SiteID API Default Navigation
intWarehouseINSite
Description:No description available
SkipLineDiscounts API
bitIgnore Automatic Line Discounts-
Description:Indicates (if selected) that the automatic line discounts are not applied to this line.
SortOrder
intSort Order-
Description:No description available
StockItemTypeNonexistent in DB
string-
Description:No description available
SubItemID API Default Navigation
intSubitemINSubItem
Description:No description available
TaskCD
nvarcharProject Task-
Description:No description available
TaskID API Default Navigation
intProject Task-
Description:No description available
TaxCategoryID API Default Navigation
nvarchar(15)Tax CategoryTaxCategory
Description:No description available
TextForProductsGridNonexistent in DB
stringAvailability footer-
Description:The text for display subtotals on products grid
UOM API Default Navigation
nvarchar(6)UOMINUnit
Description:No description available
UnitCost
decimal-
Description:No description available
UnitPrice
decimal-
Description:No description available
VendorIDDefault Navigation
intVendor IDBAccountR
Description:No description available
VendorLocationIDDefault Navigation
intVendor Location ID-
Description:No description available
chkServiceManagementNonexistent in DB
bool?-
Description:No description available
tstamp
timestamp-
Description:No description available