AM
AMConfigurationResults
Master table with the product configurator results. The data is based on the configuration maintenance data from the AMConfiguration class with the configuration totals and order references. New data is stored for each new configuration result.
View API Entity: ConfigurationEntry
/entity/MANUFACTURING/25.100.001/ConfigurationEntry| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
BOMPriceTotal | decimal | - | ||
Description:The total amount of the lines of the related Bill of Material. Given in the base currency of the company. | ||||
Closed | bit | Closed | - | |
Description:Indicates if the configuration is closed - no more edit. Most likely related to linked sales order/opportunity is closed/canceled | ||||
Completed API | bit | Completed | - | |
Description:No description available | ||||
ConfigResultsID API | int | Config Results ID | - | |
Description:No description available | ||||
ConfigurationID API | nvarchar(15) | Configuration ID | AMConfiguration | |
Description:No description available | ||||
CreatedByID | uniqueidentifier | Created By | Users | |
Description:No description available | ||||
CreatedByScreenID | char(8) | - | ||
Description:No description available | ||||
CreatedDateTime | datetime | Config. Date | - | |
Description:No description available | ||||
CuryBOMPriceTotal | decimal | BOM Price Total | - | |
Description:The total amount of the lines of the related Bill of Material. Given in the currency of the document. | ||||
CuryFixedPriceTotal | decimal | Parent Price | - | |
Description:Parent configured price. Given in the currency of the document. | ||||
CuryID | nvarchar(5) | Currency | Currency | |
Description:The code of the CM.Currency of the document. Defaults to the base currency of the company. Corresponds to the Currency.CuryID field. | ||||
CuryInfoID | bigint | - | ||
Description:Identifier of the CurrencyInfo object associated with the document. Corresponds to the CurrencyInfo.CuryInfoID field. | ||||
CuryOptionPriceTotal | decimal | Option price Total | - | |
Description:The total amount of the non supplemental lines of the document. Given in the currency of the document. | ||||
CurySupplementalPriceTotal | decimal | Option price Total | - | |
Description:The total amount of the supplemental lines of the document. Given in the currency of the document. | ||||
CustomerID | int | Customer | Customer | |
Description:Identifier of the Customer, whom the document belongs. Corresponds to the BAccount.BAccountID field. | ||||
CustomerLocationID | int | Location | - | |
Description:Identifier of the Location of the Customer. Defaults to the Default Location of the Customer if it is specified, or to the first found Location, associated with the Customer. Corresponds to the Location.LocationID field. | ||||
DisplayPriceNonexistent in DB | decimal? | Price | - | |
Description:No description available | ||||
DocDate | datetime | Date | - | |
Description:The date of the document. Defaults to the current Business Date. | ||||
FixedPriceTotal | decimal | - | ||
Description:Parent configured price. Given in the base currency of the company. | ||||
InventoryID API | int | Inventory ID | InventoryItem | |
Description:No description available | ||||
bool? | Test Configuration | - | ||
Description:Indicates the configuration is running in test mode (no persist to the database) | ||||
IsOpportunityReferencedNonexistent in DB | bool? | - | ||
Description:Contains CR Opportunity references | ||||
IsProductionReferencedNonexistent in DB | bool? | - | ||
Description:Contains Production references | ||||
IsSalesReferencedNonexistent in DB | bool? | - | ||
Description:Contains sales order references | ||||
KeyDescription | nvarchar | Key Description | - | |
Description:No description available | ||||
KeyID | nvarchar(120) | Config. Key | AMConfigurationKeys | |
Description:Configuration key ID which represents the key used/generated from the results of a finished configuration | ||||
LastModifiedByID | uniqueidentifier | Last Modified By | Users | |
Description:No description available | ||||
LastModifiedByScreenID | char(8) | - | ||
Description:No description available | ||||
LastModifiedDateTime | datetime | - | ||
Description:No description available | ||||
OpportunityLineNbr API | int | Opportunity Line Nbr | CROpportunityProducts | |
Description:No description available | ||||
OpportunityQuoteID API | uniqueidentifier | Opportunity Quote ID | CROpportunityProducts | |
Description:No description available | ||||
OptionPriceTotal | decimal | - | ||
Description:The total amount of the non supplemental lines of the document. Given in the base currency of the company. | ||||
OrdLineRef API | int | SO Line Nbr. | SOLine | |
Description:No description available | ||||
OrdNbrRef API | nvarchar(15) | SO Order Nbr | SOOrder | |
Description:No description available | ||||
OrdTypeRef API | char(2) | SO Order Type | SOOrder | |
Description:No description available | ||||
ProdOrderNbr API | nvarchar(15) | Prod Order Nbr | AMProdItem | |
Description:No description available | ||||
ProdOrderType API | char(2) | Prod Order Type | AMProdItem | |
Description:No description available | ||||
Qty | decimal | Qty | - | |
Description:No description available | ||||
Revision API | nvarchar(10) | Conf. Revision | AMConfiguration | |
Description:No description available | ||||
SiteID API | int | Warehouse | INSite | |
Description:No description available | ||||
SupplementalPriceTotal | decimal | - | ||
Description:The total amount of the supplemental lines of the document. Given in the base currency of the company. | ||||
TranDescription | nvarchar(256) | Tran Description | - | |
Description:No description available | ||||
UOM | nvarchar(6) | UOM | - | |
Description:No description available | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||