CR
CROpportunityProducts
No summary is documented for this DAC in the release source.
View API Entity: OpportunityProduct
/entity/Default/25.200.001/OpportunityProduct| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
AMConfigKeyID | nvarchar(120) | Config. Key | AMConfigurationKeys | |
Description:Configuration key ID which represents the key used/generated from the results of a finished configuration | ||||
AMConfigurationID | nvarchar | Configuration ID | - | |
Description:No description available | ||||
AMIsSupplemental | bit | Is Supplemental | - | |
Description:No description available | ||||
AMParentLineNbr | int | Parent Line Nbr. | - | |
Description:No description available | ||||
AMSelectedNonexistent in DB | bool? | Selected | - | |
Description:No description available | ||||
Amount | decimal | - | ||
Description:No description available | ||||
BaseQuantity | decimal | Base 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 | ||||
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 API | decimal | Amount | - | |
Description:No description available | ||||
CuryDiscAmt API | decimal | Discount Amount | - | |
Description:No description available | ||||
CuryExtCost | decimal | Ext. Cost | - | |
Description:No description available | ||||
CuryExtPrice API | decimal | Ext. Price | - | |
Description:No description available | ||||
CuryInfoID | bigint | - | ||
Description:No description available | ||||
CuryMarginAmt | decimal | Est. Margin Amount | - | |
Description:The line's estimated margin amount (in the currency of the document). The value is empty for the line with zero extended cost. | ||||
CuryNetSales | decimal | - | ||
Description:The line amount without the tax and with the applied group and document discounts (in the currency of the document). The value has the negative sign for the receipt lines. | ||||
CuryUnitCost | decimal | Unit Cost | - | |
Description:No description available | ||||
CuryUnitPrice API | decimal | Unit 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 | decimal | Discount, % | - | |
Description:No description available | ||||
DiscountID API | nvarchar(10) | Discount Code | ARDiscount | |
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 | ||||
EmployeeID | int | Employee ID | EPEmployee | |
Description:No description available | ||||
EstimatedDuration | int | Estimated Duration | - | |
Description:No description available | ||||
ExpenseAccountGroupID | int | Cost 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 | int | Group Line Nbr. | - | |
Description:No description available | ||||
InventoryID API | int | Inventory ID | InventoryItem | |
Description:No description available | ||||
IsConfigurableNonexistent in DB | bool? | Configurable | - | |
Description:No description available | ||||
IsFree API | 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 | ||||
LineNbr API | int | Line Nbr. | - | |
Description:No description available | ||||
LineType | nvarchar(3) | Type | - | |
Description:No description available | ||||
ManualDisc API | bit | Manual Discount | - | |
Description:No description available | ||||
ManualPrice | bit | Manual Price | - | |
Description:No description available | ||||
MarginAmt | decimal | - | ||
Description:The line's estimated margin amount. The value is empty for the line with zero extended cost. | ||||
MarginPct | decimal | Est. Margin (%) | - | |
Description:The line's estimated margin percent. The value is empty for the line with zero extended cost. | ||||
NetSales | decimal | - | ||
Description:The line amount without the tax and with the applied group and document discounts. | ||||
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 API | decimal | Quantity | - | |
Description:No description available | ||||
QuoteID | uniqueidentifier | CROpportunity | ||
Description:No description available | ||||
RevenueAccountGroupID | int | Revenue Account Group | - | |
Description:The identifier of the revenue account group. | ||||
SiteID API | int | Warehouse | INSite | |
Description:No description available | ||||
SkipLineDiscounts API | 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 | string | - | ||
Description:No description available | ||||
SubItemID API | int | Subitem | INSubItem | |
Description:No description available | ||||
TaskCD | nvarchar | Project Task | - | |
Description:No description available | ||||
TaskID API | int | Project Task | - | |
Description:No description available | ||||
TaxCategoryID API | nvarchar(15) | Tax Category | TaxCategory | |
Description:No description available | ||||
TextForProductsGridNonexistent in DB | string | Availability footer | - | |
Description:The text for display subtotals on products grid | ||||
UOM API | nvarchar(6) | UOM | INUnit | |
Description:No description available | ||||
UnitCost | decimal | - | ||
Description:No description available | ||||
UnitPrice | decimal | - | ||
Description:No description available | ||||
VendorID | int | Vendor ID | BAccountR | |
Description:No description available | ||||
VendorLocationID | int | Vendor Location ID | - | |
Description:No description available | ||||
chkServiceManagementNonexistent in DB | bool? | - | ||
Description:No description available | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||