MGCLatticeTradeAgreementEntity
The MGCLatticeTradeAgreementEntity exposes ALL trade-agreement price and discount rows from PriceDiscTable (root) as a single normalized, cross-type collection, replacing the need to union the eight split standard *AgreementEntity feeds (SalesPriceAgreement, PurchPriceAgreement, SalesLineDiscAgreement, PurchLineDiscAgreement, SalesMultiLineDiscAgreement, PurchMultiLineDiscAgreement, SalesEndDiscAgreement, PurchEndDiscAgreement). The PriceType (Relation) field is the price-type discriminator and ModuleType (Module) distinguishes customer vs. vendor; consumers select a slice with a $filter such as $filter=PriceType eq Microsoft.Dynamics.DataEntities.PriceType'PriceSales'. Read-only and DMF/OData enabled with a lean, explicitly projected field set for high-performance price-list extract and BYOD scenarios. Keyed on the PriceDiscTable surrogate RecId (export-oriented). PriceDiscTable can be large; consumers should constrain extracts with a $filter (for example by PriceType, ModuleType, ItemRelation or FromDate/ToDate). Change tracking is enabled at runtime in the Data management workspace (Enable change tracking), not via a metadata flag.
- Public collection name:
LatticeTradeAgreements
- Primary key:
SysRecId
Fields
| Name | Type | Mandatory | Description |
|---|
PriceType | PriceType | No | |
ModuleType | PriceDiscModule | No | |
AccountCode | PriceDiscPartyCode | No | |
AccountRelation | PriceDiscAccountRelation | No | |
ItemCode | PriceDiscProductCode | No | |
ItemRelation | PriceDiscItemRelation | No | |
InventoryDimensionId | InventDimId | No | |
UnitSymbol | UnitOfMeasureSymbol | No | |
CurrencyCode | CurrencyCode | No | |
QuantityFrom | AmountQty | No | |
QuantityTo | AmountQuantityTo | No | |
Amount | PriceDiscAmount | No | |
DiscountPercent1 | DiscPct | No | |
DiscountPercent2 | DiscPct | No | |
Markup | PriceMarkup | No | |
PriceUnit | PriceUnit | No | |
FromDate | FromDate | No | |
ToDate | ToDate | No | |
DeliveryLeadTime | LeadTimeDelivery | No | |
AgreementId | PriceAgreement | No | |
SysRecId | RefRecId | No | |
Mappings
| Entity field | Data source | Field |
|---|
PriceType | PriceDiscTable | relation |
ModuleType | PriceDiscTable | Module |
AccountCode | PriceDiscTable | AccountCode |
AccountRelation | PriceDiscTable | AccountRelation |
ItemCode | PriceDiscTable | ItemCode |
ItemRelation | PriceDiscTable | ItemRelation |
InventoryDimensionId | PriceDiscTable | InventDimId |
UnitSymbol | PriceDiscTable | UnitId |
CurrencyCode | PriceDiscTable | Currency |
QuantityFrom | PriceDiscTable | QuantityAmountFrom |
QuantityTo | PriceDiscTable | QuantityAmountTo |
Amount | PriceDiscTable | Amount |
DiscountPercent1 | PriceDiscTable | Percent1 |
DiscountPercent2 | PriceDiscTable | Percent2 |
Markup | PriceDiscTable | Markup |
PriceUnit | PriceDiscTable | PriceUnit |
FromDate | PriceDiscTable | FromDate |
ToDate | PriceDiscTable | ToDate |
DeliveryLeadTime | PriceDiscTable | DeliveryTime |
AgreementId | PriceDiscTable | Agreement |
SysRecId | PriceDiscTable | RecId |