MGCLatticeSalesLineDiscountAgreementEntity
The MGCLatticeSalesLineDiscountAgreementEntity exposes the sales line discount trade agreements in PriceDiscTable: the rows whose Module is Cust and whose Relation (price type) is LineDiscSales. It carries the same lean field set and SysRecId key as MGCLatticeTradeAgreementEntity, which holds every price and discount type in one collection; this entity is that collection pre-filtered for OData consumers. Read-only, and not enabled for Data management: export trade agreements through MGCLatticeTradeAgreementEntity.
- Public collection name:
LatticeSalesLineDiscountAgreements
- Primary key:
SysRecId
Fields
| Name | Type | Mandatory | Description |
|---|
PriceType | `` | No | |
ModuleType | `` | No | |
AccountCode | `` | No | |
AccountRelation | `` | No | |
ItemCode | `` | No | |
ItemRelation | `` | No | |
InventoryDimensionId | `` | No | |
UnitSymbol | `` | No | |
CurrencyCode | `` | No | |
QuantityFrom | `` | No | |
QuantityTo | `` | No | |
Amount | `` | No | |
DiscountPercent1 | `` | No | |
DiscountPercent2 | `` | No | |
Markup | `` | No | |
PriceUnit | `` | No | |
FromDate | `` | No | |
ToDate | `` | No | |
DeliveryLeadTime | `` | No | |
AgreementId | `` | No | |
SysRecId | `` | 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 |