AM
AMConfigurationResults
PX.Objects.AM40 of 40 fields
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
ConfigResultsID | int | Config Results ID | - | |
Description:No description available | ||||
BOMPriceTotal | decimal(19, 4) | - | ||
Description:No description available | ||||
Closed | bit | Closed | - | |
Description:No description available | ||||
Completed | bit | Completed | - | |
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(19, 4) | BOM Price Total | - | |
Description:No description available | ||||
CuryFixedPriceTotal | decimal(19, 4) | Parent Price | - | |
Description:No description available | ||||
CuryID | nvarchar(5) | Currency | Currency | |
Description:No description available | ||||
CuryInfoID | bigint | - | ||
Description:No description available | ||||
CuryOptionPriceTotal | decimal(19, 4) | Option price Total | - | |
Description:No description available | ||||
CurySupplementalPriceTotal | decimal(19, 4) | Option price Total | - | |
Description:No description available | ||||
CustomerID | int | Customer | Customer | |
Description:No description available | ||||
CustomerLocationID | int | Location | Location | |
Description:No description available | ||||
DisplayPriceNonexistent in DB | decimal | Price | - | |
Description:No description available | ||||
DocDate | datetime2 | Date | - | |
Description:No description available | ||||
FixedPriceTotal | decimal(19, 4) | - | ||
Description:No description available | ||||
InventoryID | int | Inventory ID | InventoryItem | |
Description:No description available | ||||
IsConfigurationTestingNonexistent in DB | bit | Test Configuration | - | |
Description:No description available | ||||
KeyDescription | nvarchar(MAX) | Key Description | - | |
Description:No description available | ||||
KeyID | nvarchar(120) | Config. Key | AMConfigurationKeys | |
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 | ||||
OpportunityLineNbr | int | Opportunity Line Nbr | CROpportunityProducts | |
Description:No description available | ||||
OpportunityQuoteID | uniqueidentifier | Opportunity Quote ID | CROpportunity | |
Description:No description available | ||||
OptionPriceTotal | decimal(19, 4) | - | ||
Description:No description available | ||||
OrdLineRef | int | SO Line Nbr. | - | |
Description:No description available | ||||
OrdNbrRef | nvarchar(15) | SO Order Nbr | SOLine | |
Description:No description available | ||||
OrdTypeRef | char(2) | SO Order Type | - | |
Description:No description available | ||||
ProdOrderNbr | nvarchar(15) | Prod Order Nbr | AMProdItem | |
Description:No description available | ||||
ProdOrderType | char(2) | Prod Order Type | - | |
Description:No description available | ||||
Qty | decimal(25, 6) | Qty | - | |
Description:No description available | ||||
Revision | nvarchar(10) | Conf. Revision | AMConfiguration | |
Description:No description available | ||||
SiteID | int | Warehouse | INSite | |
Description:No description available | ||||
TranDescription | nvarchar(256) | Tran Description | - | |
Description:No description available | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||
UOM | nvarchar(6) | UOM | - | |
Description:No description available | ||||