AM
AMConfigurationKeys
Projection to display Configuration Keys of most recent completed Keys (no duplicate KeyIDs displayed)
| 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 | bit | Completed | - | |
Description:No description available | ||||
ConfigResultsID | int | Config Results ID | - | |
Description:No description available | ||||
ConfigurationID | 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 | Fixed Price Total | - | |
Description:The total amount of the AMConfigResultsFixed lines of the document. 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 | BAccountR | |
Description:Identifier of the Customer, whom the document belongs. Corresponds to the BAccount.BAccountID field. | ||||
CustomerLocationID | int | Location | - | |
Description:Identifier of the CR.Location of the Customer. Defaults to the Default Location of the Customer if it is specified, or to the first found CR.Location, associated with the Customer. Corresponds to the Location.LocationID field. | ||||
DocDate | datetime | Date | - | |
Description:The date of the document. Defaults to the current Business Date. | ||||
FixedPriceTotal | decimal | - | ||
Description:The total amount of the AMConfigResultsFixed lines of the document. Given in the base currency of the company. | ||||
InventoryID | int | Inventory ID | - | |
Description:No description available | ||||
KeyDescription | nvarchar | Key Description | - | |
Description:No description available | ||||
KeyID | nvarchar(120) | Config. Key | - | |
Description:Configuration key ID which represents the key used/generated from the results of a finished configuration | ||||
OpportunityLineNbr | int | Opportunity Line Nbr | - | |
Description:No description available | ||||
OpportunityQuoteID | uniqueidentifier | Opportunity Quote ID | - | |
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 | int | SO Line Nbr. | - | |
Description:No description available | ||||
OrdNbrRef | nvarchar(15) | SO Order Nbr | SOOrder | |
Description:No description available | ||||
OrdTypeRef | char(2) | SO Order Type | - | |
Description:No description available | ||||
ProdOrderNbr | nvarchar(15) | Prod Order Nbr | - | |
Description:No description available | ||||
ProdOrderType | char(2) | Prod Order Type | - | |
Description:No description available | ||||
Qty | decimal | Qty | - | |
Description:No description available | ||||
Revision | nvarchar(10) | Conf. Revision | AMConfiguration | |
Description:No description available | ||||
SiteID | int | Warehouse | - | |
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 | ||||