MGCLatticeSetBasedTradeAgreementJournalLineEntity
Imports trade agreement journal lines (sales and purchase prices, line, multiline and total discounts) in bulk with set-based processing.
- Primary key:
JournalNumber, LineNumber
Fields
| Name | Type | Mandatory | Description |
|---|
JournalNumber | PriceDiscJournalNum | Yes | |
JournalNameId | PriceDiscJournalName | No | |
JournalDescription | Name | No | |
LineNumber | LineNum | Yes | |
TradeAgreementType | Name | Yes | |
ItemCode | PriceDiscProductCode | No | |
ItemRelation | PriceDiscItemRelation | No | |
AccountCode | PriceDiscPartyCode | No | |
AccountRelation | PriceDiscAccountRelation | No | |
CurrencyCode | CurrencyCode | No | |
UnitSymbol | UnitOfMeasureSymbol | No | |
FromQuantity | AmountQty | No | |
ToQuantity | AmountQuantityTo | No | |
FromDate | FromDate | No | |
ToDate | ToDate | No | |
Amount | PriceDiscAmount | No | |
Percent1 | DiscPct | No | |
Percent2 | DiscPct | No | |
PriceUnit | PriceUnit | No | |
Markup | PriceMarkup | No | |
LeadTimeDays | LeadTime | No | |
LeadTimeCalendarDays | CalendarDays | No | |
DisregardLeadTime | DisregardLeadTime | No | |
FindNext | NoYes | No | |
InventorySiteId | InventSiteId | No | |
InventoryWarehouseId | InventLocationId | No | |
ProductConfigurationId | EcoResItemConfigurationName | No | |
ProductSizeId | EcoResItemSizeName | No | |
ProductColorId | EcoResItemColorName | No | |
ProductStyleId | EcoResItemStyleName | No | |
ProductVersionId | EcoResItemVersionName | No | |
Mappings
| Entity field | Data source | Field |
|---|
JournalNumber | PriceDiscAdmTable | JournalNum |
JournalNameId | PriceDiscAdmTable | JournalName |
JournalDescription | PriceDiscAdmTable | Name |
LineNumber | PriceDiscAdmTrans | LineNum |
ItemCode | PriceDiscAdmTrans | ItemCode |
ItemRelation | PriceDiscAdmTrans | ItemRelation |
AccountCode | PriceDiscAdmTrans | AccountCode |
AccountRelation | PriceDiscAdmTrans | AccountRelation |
CurrencyCode | PriceDiscAdmTrans | Currency |
UnitSymbol | PriceDiscAdmTrans | UnitId |
FromQuantity | PriceDiscAdmTrans | QuantityAmountFrom |
ToQuantity | PriceDiscAdmTrans | QuantityAmountTo |
FromDate | PriceDiscAdmTrans | FromDate |
ToDate | PriceDiscAdmTrans | ToDate |
Amount | PriceDiscAdmTrans | Amount |
Percent1 | PriceDiscAdmTrans | Percent1 |
Percent2 | PriceDiscAdmTrans | Percent2 |
PriceUnit | PriceDiscAdmTrans | PriceUnit |
Markup | PriceDiscAdmTrans | Markup |
LeadTimeDays | PriceDiscAdmTrans | DeliveryTime |
LeadTimeCalendarDays | PriceDiscAdmTrans | CalendarDays |
DisregardLeadTime | PriceDiscAdmTrans | DisregardLeadTime |
FindNext | PriceDiscAdmTrans | SearchAgain |
InventorySiteId | InventDim | InventSiteId |
InventoryWarehouseId | InventDim | InventLocationId |
ProductConfigurationId | InventDim | configId |
ProductSizeId | InventDim | InventSizeId |
ProductColorId | InventDim | InventColorId |
ProductStyleId | InventDim | InventStyleId |
ProductVersionId | InventDim | InventVersionId |