Skip to main content

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​

NameTypeMandatoryDescription
JournalNumberPriceDiscJournalNumYes
JournalNameIdPriceDiscJournalNameNo
JournalDescriptionNameNo
LineNumberLineNumYes
TradeAgreementTypeNameYes
ItemCodePriceDiscProductCodeNo
ItemRelationPriceDiscItemRelationNo
AccountCodePriceDiscPartyCodeNo
AccountRelationPriceDiscAccountRelationNo
CurrencyCodeCurrencyCodeNo
UnitSymbolUnitOfMeasureSymbolNo
FromQuantityAmountQtyNo
ToQuantityAmountQuantityToNo
FromDateFromDateNo
ToDateToDateNo
AmountPriceDiscAmountNo
Percent1DiscPctNo
Percent2DiscPctNo
PriceUnitPriceUnitNo
MarkupPriceMarkupNo
LeadTimeDaysLeadTimeNo
LeadTimeCalendarDaysCalendarDaysNo
DisregardLeadTimeDisregardLeadTimeNo
FindNextNoYesNo
InventorySiteIdInventSiteIdNo
InventoryWarehouseIdInventLocationIdNo
ProductConfigurationIdEcoResItemConfigurationNameNo
ProductSizeIdEcoResItemSizeNameNo
ProductColorIdEcoResItemColorNameNo
ProductStyleIdEcoResItemStyleNameNo
ProductVersionIdEcoResItemVersionNameNo

Mappings​

Entity fieldData sourceField
JournalNumberPriceDiscAdmTableJournalNum
JournalNameIdPriceDiscAdmTableJournalName
JournalDescriptionPriceDiscAdmTableName
LineNumberPriceDiscAdmTransLineNum
ItemCodePriceDiscAdmTransItemCode
ItemRelationPriceDiscAdmTransItemRelation
AccountCodePriceDiscAdmTransAccountCode
AccountRelationPriceDiscAdmTransAccountRelation
CurrencyCodePriceDiscAdmTransCurrency
UnitSymbolPriceDiscAdmTransUnitId
FromQuantityPriceDiscAdmTransQuantityAmountFrom
ToQuantityPriceDiscAdmTransQuantityAmountTo
FromDatePriceDiscAdmTransFromDate
ToDatePriceDiscAdmTransToDate
AmountPriceDiscAdmTransAmount
Percent1PriceDiscAdmTransPercent1
Percent2PriceDiscAdmTransPercent2
PriceUnitPriceDiscAdmTransPriceUnit
MarkupPriceDiscAdmTransMarkup
LeadTimeDaysPriceDiscAdmTransDeliveryTime
LeadTimeCalendarDaysPriceDiscAdmTransCalendarDays
DisregardLeadTimePriceDiscAdmTransDisregardLeadTime
FindNextPriceDiscAdmTransSearchAgain
InventorySiteIdInventDimInventSiteId
InventoryWarehouseIdInventDimInventLocationId
ProductConfigurationIdInventDimconfigId
ProductSizeIdInventDimInventSizeId
ProductColorIdInventDimInventColorId
ProductStyleIdInventDimInventStyleId
ProductVersionIdInventDimInventVersionId