Data entity reference

Every data entity in the Lattice model: 149 entities. Each entry gives the OData entity set, whether it is read-only, whether Data management (DMF) can import and export it, its key, its fields and the privileges that grant it.

Calling an entity. GET https://<environment>/data/<entity set>. For company-specific entities, add ?cross-company=true and filter on dataAreaId to read another legal entity than the caller's default company.

Summary

Entity	OData entity set	Category	Access	DMF
Customer summary update parameters	LatticeCustomerSummaryUpdateParameters	Configuration	Read/write	Yes
Free text invoice template	LatticeFreeTextInvoiceTemplates	Configuration	Read/write	Yes
Free text invoice template line	LatticeFreeTextInvoiceTemplateLines	Configuration	Read/write	Yes
Mobile Device Step Texts	LatticeMobileDeviceStepTexts	Configuration	Read/write	Yes
Mobile Device Steps	LatticeMobileDeviceSteps	Configuration	Read/write	Yes
Period close closing calendar	LatticePeriodCloseCalendars	Configuration	Read/write	Yes
Period close closing role	LatticePeriodCloseRoles	Configuration	Read/write	Yes
Period close resource	LatticePeriodCloseResources	Configuration	Read/write	Yes
Period close task area	LatticePeriodCloseTaskAreas	Configuration	Read/write	Yes
Print Management Settings	LatticePrintManagementSettings	Configuration	Read/write	Yes
Recurring data job	LatticeRecurringDataJobs	Configuration	Read/write	Yes
Recurring data job client	LatticeRecurringDataJobClients	Configuration	Read/write	Yes
Recurring data job health	LatticeRecurringJobHealths	Configuration	Read/write	Yes
Transport calendar setup	LatticeTransportCalendarSetups	Configuration	Read/write	Yes
Vendor summary update parameters	LatticeVendorSummaryUpdateParameters	Configuration	Read/write	Yes
Bank statement lines (set-based)	(not public)	Document	Read/write	Yes
Customer Contact Information	LatticeCustomerContactInfos	Document	Read/write	Yes
Customer Contact Persons	LatticeCustomerContactPersons	Document	Read/write	Yes
Customer Document Attachments	LatticeCustomerDocumentAttachments	Document	Read/write	Yes
Customer invoice journal lines (set-based)	(not public)	Document	Read/write	Yes
Customer Packing Slip Journal Headers	LatticeCustomerPackingSlipJournalHeaders	Document	Read-only	Yes
Customer Packing Slip Journal Lines	LatticeCustomerPackingSlipJournalLines	Document	Read-only	Yes
Customer payment journal lines (set-based)	(not public)	Document	Read/write	Yes
Demand forecast lines (set-based)	(not public)	Document	Read/write	Yes
Free text invoice cross references	LatticeFreeTextInvoiceCrossReferences	Document	Read/write	Yes
Free Text Invoice Document Attachments	LatticeFreeTextInvoiceDocumentAttachments	Document	Read/write	Yes
Free text invoice line cross references	LatticeFreeTextInvoiceLineCrossReferences	Document	Read/write	Yes
Intercompany order line	LatticeIntercompanyOrderLines	Document	Read-only	No
Intercompany purchase order line	LatticeIntercompanyPurchaseOrderLines	Document	Read-only	No
Intercompany Purchase Orders	LatticeIntercompanyPurchaseOrders	Document	Read-only	Yes
Intercompany Sales Orders	LatticeIntercompanyOrders	Document	Read-only	Yes
Inventory journal lines (set-based)	(not public)	Document	Read/write	Yes
Journal cross references	LatticeLedgerJournalCrossReferences	Document	Read/write	Yes
Journal line cross references	LatticeLedgerJournalLineCrossReferences	Document	Read/write	Yes
Lattice document attachments	(not public)	Document	Read/write	No
Production Journal Header	LatticeProductionJournalHeaders	Document	Read-only	Yes
Production order cross references	LatticeProductionOrderCrossReferences	Document	Read/write	Yes
Production Order Document Attachments	LatticeProductionOrderDocumentAttachments	Document	Read/write	Yes
Production picking list lines (set-based)	(not public)	Document	Read/write	Yes
Production report as finished lines (set-based)	(not public)	Document	Read/write	Yes
Production route card lines (set-based)	(not public)	Document	Read/write	Yes
Project Document Attachments	LatticeProjectDocumentAttachments	Document	Read/write	Yes
Project expense journal lines (set-based)	(not public)	Document	Read/write	Yes
Project journal lines (set-based)	(not public)	Document	Read/write	Yes
Purchase agreement cross references	LatticePurchaseAgreementCrossReferences	Document	Read/write	Yes
Purchase agreement line cross references	LatticePurchaseAgreementLineCrossReferences	Document	Read/write	Yes
Purchase Invoice Document Attachments	LatticePurchaseInvoiceDocumentAttachments	Document	Read/write	Yes
Purchase Order Confirmation Document Attachments	LatticePurchaseOrderConfirmationDocumentAttachments	Document	Read/write	Yes
Purchase order cross references	LatticePurchaseOrderCrossReferences	Document	Read/write	Yes
Purchase order line cross references	LatticePurchaseOrderLineCrossReferences	Document	Read/write	Yes
Purchase Order Line Document Attachments	LatticePurchaseOrderLineDocumentAttachments	Document	Read/write	Yes
Purchase Order Lines	LatticePurchaseOrderLines	Document	Read/write	Yes
Purchase Packing Slip Document Attachments	LatticePurchasePackingSlipDocumentAttachments	Document	Read/write	Yes
Purchase Receipts List Document Attachments	LatticePurchaseReceiptsListDocumentAttachments	Document	Read/write	Yes
Purchase requisition cross references	LatticePurchaseRequisitionCrossReferences	Document	Read/write	Yes
Purchase requisition line cross references	LatticePurchaseRequisitionLineCrossReferences	Document	Read/write	Yes
Quality Order Document Attachments	LatticeQualityOrderDocumentAttachments	Document	Read/write	Yes
Return order cross references	LatticeReturnOrderCrossReferences	Document	Read/write	Yes
Return order line cross references	LatticeReturnOrderLineCrossReferences	Document	Read/write	Yes
Sales agreement cross references	LatticeSalesAgreementCrossReferences	Document	Read/write	Yes
Sales agreement line cross references	LatticeSalesAgreementLineCrossReferences	Document	Read/write	Yes
Sales Confirmation Document Attachments	LatticeSalesConfirmationDocumentAttachments	Document	Read/write	Yes
Sales Invoice Document Attachments	LatticeSalesInvoiceDocumentAttachments	Document	Read/write	Yes
Sales order cross references	LatticeSalesOrderCrossReferences	Document	Read/write	Yes
Sales Order Line Charges	LatticeSalesOrderLineCharges	Document	Read/write	Yes
Sales order line cross references	LatticeSalesOrderLineCrossReferences	Document	Read/write	Yes
Sales Order Lines	LatticeSalesOrderLines	Document	Read/write	Yes
Sales Packing Slip Document Attachments	LatticeSalesPackingSlipDocumentAttachments	Document	Read/write	Yes
Sales quotation cross references	LatticeSalesQuotationCrossReferences	Document	Read/write	Yes
Sales quotation line cross references	LatticeSalesQuotationLineCrossReferences	Document	Read/write	Yes
Trade agreement journal lines (set-based)	(not public)	Document	Read/write	Yes
Transfer order cross references	LatticeTransferOrderCrossReferences	Document	Read/write	Yes
Transfer Order Document Attachments	LatticeTransferOrderDocumentAttachments	Document	Read/write	Yes
Transfer order line cross references	LatticeTransferOrderLineCrossReferences	Document	Read/write	Yes
Transfer Order Line Document Attachments	LatticeTransferOrderLineDocumentAttachments	Document	Read/write	Yes
Vendor Contact Information	LatticeVendorContactInfos	Document	Read/write	Yes
Vendor Contact Persons	LatticeVendorContactPersons	Document	Read/write	Yes
Vendor document attachment	LatticeVendorDocumentAttachments	Document	Read/write	Yes
Vendor invoice journal lines (set-based)	(not public)	Document	Read/write	Yes
Vendor payment journal lines (set-based)	(not public)	Document	Read/write	Yes
Batch cross references	LatticeBatchCrossReferences	Master	Read/write	Yes
Bill of materials cross references	LatticeBOMCrossReferences	Master	Read/write	Yes
Bill of materials version cross references	LatticeBOMVersionCrossReferences	Master	Read/write	Yes
BOM lines (set-based)	(not public)	Master	Read/write	Yes
Customer cross references	LatticeCustomerCrossReferences	Master	Read/write	Yes
Estimate Projects	LatticeEstimateProjects	Master	Read/write	Yes
Fixed asset books (set-based)	(not public)	Master	Read/write	Yes
Fixed asset cross references	LatticeFixedAssetCrossReferences	Master	Read/write	Yes
Inventory Status	LatticeInventoryStatuses	Master	Read/write	Yes
Item Purchase Order Setup	LatticeItemPurchaseOrderSetups	Master	Read/write	Yes
Item Sales Order Setup	LatticeItemSalesOrderSetups	Master	Read/write	Yes
Product variant cross references	LatticeProductVariantCrossReferences	Master	Read/write	Yes
Project contract cross references	LatticeProjectContractCrossReferences	Master	Read/write	Yes
Project cross references	LatticeProjectCrossReferences	Master	Read/write	Yes
Released Product	LatticeReleasedProducts	Master	Read-only	Yes
Released product cross references	LatticeReleasedProductCrossReferences	Master	Read/write	Yes
Route cross references	LatticeRouteCrossReferences	Master	Read/write	Yes
Route version cross references	LatticeRouteVersionCrossReferences	Master	Read/write	Yes
Vendor cross references	LatticeVendorCrossReferences	Master	Read/write	Yes
General Ledger Parameters	LatticeGeneralLedgerParameters	Parameters	Read/write	Yes
Inventory Parameters	LatticeInventoryParameters	Parameters	Read/write	Yes
Procurement Parameters	LatticeProcurementParameters	Parameters	Read/write	Yes
Sales Parameters	LatticeSalesParameters	Parameters	Read/write	Yes
External systems	LatticeExternalSystems	Reference	Read/write	Yes
Item Group Assignment	LatticeItemGroupAssignments	Reference	Read/write	Yes
Item Model Group Assignment	LatticeItemModelGroupAssignments	Reference	Read/write	Yes
Item Sales Tax Group Tax Code	LatticeItemSalesTaxGroupTaxCodes	Reference	Read/write	Yes
Warehouse Location Type	LatticeWarehouseLocationTypes	Reference	Read/write	Yes
Async Operation Tracking Entity	LatticeAsyncOperationTrackingRecords	Transaction	Read-only	No
Bank account transactions	LatticeBankAccountTransactions	Transaction	Read-only	Yes
Customer settlements	LatticeCustomerSettlements	Transaction	Read-only	Yes
Customer transactions	LatticeCustomerTransactions	Transaction	Read-only	Yes
File Ingestion Log Entity	LatticeFileIngestLogs	Transaction	Read-only	No
Fixed asset transactions	LatticeFixedAssetTransactions	Transaction	Read-only	Yes
General ledger entry	LatticeGeneralLedgerEntries	Transaction	Read-only	Yes
Integration Dead Letter Entity	LatticeIntegrationDeadLetters	Transaction	Read-only	No
Inventory On-Hand	LatticeInventoryOnHands	Transaction	Read-only	Yes
Inventory Transaction	LatticeInventoryTransactions	Transaction	Read-only	Yes
Open purchase order line	LatticeOpenPurchaseOrderLines	Transaction	Read-only	Yes
Open sales order line	LatticeOpenSalesOrderLines	Transaction	Read-only	Yes
Opportunity	LatticeOpportunities	Transaction	Read/write	Yes
Payment request	LatticePaymentRequests	Transaction	Read/write	Yes
Payment request line	LatticePaymentRequestLines	Transaction	Read/write	Yes
Planned Order Requirement	LatticePlannedOrderRequirements	Transaction	Read-only	Yes
Project Posted Transaction	LatticeProjectPostedTransactions	Transaction	Read-only	Yes
Purchase line discount trade agreements	LatticePurchaseLineDiscountAgreements	Transaction	Read-only	No
Purchase multiline discount trade agreements	LatticePurchaseMultilineDiscountAgreements	Transaction	Read-only	No
Purchase price trade agreements	LatticePurchasePriceAgreements	Transaction	Read-only	No
Purchase total discount trade agreements	LatticePurchaseTotalDiscountAgreements	Transaction	Read-only	No
Recurring data job message	LatticeRecurringJobMessages	Transaction	Read-only	No
Retail transactions	LatticeRetailTransactions	Transaction	Read-only	Yes
Sales line discount trade agreements	LatticeSalesLineDiscountAgreements	Transaction	Read-only	No
Sales multiline discount trade agreements	LatticeSalesMultilineDiscountAgreements	Transaction	Read-only	No
Sales price trade agreements	LatticeSalesPriceAgreements	Transaction	Read-only	No
Sales total discount trade agreements	LatticeSalesTotalDiscountAgreements	Transaction	Read-only	No
Service Call Log Entity	LatticeServiceCallLogs	Transaction	Read-only	No
Service Call Statistics Entity	LatticeServiceCallStatistics	Transaction	Read-only	No
Service Idempotency Log Entity	LatticeServiceIdempotencyLogs	Transaction	Read-only	No
Table data and entity coverage snapshot	LatticeTableEntityCoverages	Transaction	Read-only	Yes
Tax Transaction	LatticeTaxTransactions	Transaction	Read-only	Yes
Trade Agreement	LatticeTradeAgreements	Transaction	Read-only	Yes
Trial balance (snapshot)	LatticeTrialBalances	Transaction	Read-only	Yes
Vendor settlements	LatticeVendorSettlements	Transaction	Read-only	Yes
Vendor Transaction	LatticeVendorTransactions	Transaction	Read-only	Yes
Warehouse Reservation	LatticeWarehouseReservations	Transaction	Read-only	Yes
Warehouse Work	LatticeWarehouseWorks	Transaction	Read-only	Yes
Warehouse Work Lines	LatticeWarehouseWorkLines	Transaction	Read-only	Yes
Withholding Tax Transaction	LatticeWithholdingTaxTransactions	Transaction	Read-only	Yes
Worker action	LatticeWorkerActions	Transaction	Read-only	Yes

Configuration entities

MGCLatticeCustomerSummaryUpdateParametersEntity

Customer summary update parameters

Property	Value
OData entity set	LatticeCustomerSummaryUpdateParameters (single: LatticeCustomerSummaryUpdateParameter)
Access	Read/write
Data management	Enabled (staging table MGCLatticeCustomerSummaryUpdateParametersStaging)
Company	Company-specific (DataAreaId)
Key	CustomerAccount, ModuleType, SalesOrderNumber, DocumentType
Data sources	SalesJournalAutoSummary
Configuration key	LogisticsBasic
Granted by	MGCLatticeCustomerSummaryUpdateParametersEntityMaintain (full CRUD); MGCLatticeCustomerSummaryUpdateParametersEntityView (read)

Field	Label	Type	Source	Mandatory
CustomerAccount (key)	Customer account	String (CustAccount)	SalesJournalAutoSummary.CustAccount
ModuleType (key)	Module	Enum ModuleCustSales	SalesJournalAutoSummary.ModuleType
SalesOrderNumber (key)	Sales order	String (SalesIdBase)	SalesJournalAutoSummary.SalesId
DocumentType (key)	Form	Enum DocumentStatus	SalesJournalAutoSummary.DocumentStatus
SummaryUpdate	Automatic summary	Enum NoYes	SalesJournalAutoSummary.AutoSummary

MGCLatticeFreeTextInvoiceTemplateEntity

Free text invoice template

Property	Value
OData entity set	LatticeFreeTextInvoiceTemplates (single: LatticeFreeTextInvoiceTemplate)
Access	Read/write
Data management	Enabled (staging table MGCLatticeFreeTextInvoiceTemplateStaging)
Company	Company-specific (DataAreaId)
Key	TemplateName
Data sources	DimensionSetEntity, CustInvoiceTemplate
Configuration key	LedgerBasic
Granted by	MGCLatticeFreeTextInvoiceTemplateEntityMaintain (full CRUD); MGCLatticeFreeTextInvoiceTemplateEntityView (read)

Field	Label	Type	Source	Mandatory
TemplateName (key)	Template name	String (CustInvoiceTemplateName)	CustInvoiceTemplate.TemplateName	Yes
TemplateDescription	Description	String (Description)	CustInvoiceTemplate.TemplateDescription
CurrencyCode	Currency	String (CustCurrencyCode)	CustInvoiceTemplate.CurrencyCode	Yes
LanguageId	Language	String (CustLanguageId)	CustInvoiceTemplate.LanguageId	Yes
PostingProfile	Posting profile	String (CustPostingProfile)	CustInvoiceTemplate.PostingProfile
SalesTaxGroup	Sales tax group	String (TaxGroup)	CustInvoiceTemplate.TaxGroup
ItemSalesTaxGroup	Item sales tax group	String (TaxItemGroup)	CustInvoiceTemplate.TaxItemGroup
OverrideSalesTax	Override sales tax	Enum NoYes	CustInvoiceTemplate.OverrideSalesTax
PaymentTerms	Terms of payment	String (CustPaymTermId)	CustInvoiceTemplate.Payment
PaymentMode	Method of payment	String (CustPaymMode)	CustInvoiceTemplate.PaymMode
PaymentSpecification	Payment specification	String (PaymSpec)	CustInvoiceTemplate.PaymSpec
PaymentSchedule	Payment schedule	String (PaymSchedId)	CustInvoiceTemplate.PaymentSched
CashDiscountCode	Cash discount	String (CustCashDiscCode)	CustInvoiceTemplate.CashDiscCode
CashDiscountPercent	Discount percentage	Real (DiscPct)	CustInvoiceTemplate.CashDiscPercent
DeliveryTerms	Delivery terms	String (CustDlvTermId)	CustInvoiceTemplate.DlvTerm
PaymentStubType	Associated payment attachment on free text invoice	Enum PaymentStub	CustInvoiceTemplate.GiroType
InclTax	Prices include sales tax	Enum NoYes	CustInvoiceTemplate.InclTax
ListCode	List code	Enum Listcode	CustInvoiceTemplate.Listcode
DisplayValue	Default dimension display value	String (DimensionDisplayValue)	DimensionSetEntity.DisplayValue
MainAccount			DimensionSetEntity.MainAccount

MGCLatticeFreeTextInvoiceTemplateLineEntity

Free text invoice template line

Property	Value
OData entity set	LatticeFreeTextInvoiceTemplateLines (single: LatticeFreeTextInvoiceTemplateLine)
Access	Read/write
Data management	Enabled (staging table MGCLatticeFreeTextInvoiceTemplateLineStaging)
Company	Company-specific (DataAreaId)
Key	TemplateName, LineNumber
Data sources	DimensionSetEntity, DimensionAttributeValueCombination, CustInvoiceStandardLineTemplate, CustInvoiceTemplate
Configuration key	LedgerBasic
Granted by	MGCLatticeFreeTextInvoiceTemplateLineEntityMaintain (full CRUD); MGCLatticeFreeTextInvoiceTemplateLineEntityView (read)

Field	Label	Type	Source	Mandatory
TemplateName (key)	Template name	String (CustInvoiceTemplateName)	CustInvoiceTemplate.TemplateName	Yes
LineNumber (key)	Line number	Real (LineNum)	CustInvoiceStandardLineTemplate.LineNum
Description	Description	String (Description)	CustInvoiceStandardLineTemplate.Description
InvoiceText	Invoice text	String (Notes)	CustInvoiceStandardLineTemplate.LineTxt
LineAmount	Amount in transaction currency	Real (AmountCur)	CustInvoiceStandardLineTemplate.AmountCur
Quantity	Quantity	Real (InvoiceQuantity)	CustInvoiceStandardLineTemplate.Quantity
UnitPrice	Unit price	Real (InvoiceUnitPrice)	CustInvoiceStandardLineTemplate.UnitPrice
SalesTaxGroup	Sales tax group	String (TaxGroup)	CustInvoiceStandardLineTemplate.TaxGroup
ItemSalesTaxGroup	Item sales tax group	String (TaxItemGroup)	CustInvoiceStandardLineTemplate.TaxItemGroup
OverrideSalesTax	Override sales tax	Enum NoYes	CustInvoiceStandardLineTemplate.OverrideSalesTax
ProjectId	Project ID	String (ProjId)	CustInvoiceStandardLineTemplate.ProjId
ProjectCategoryId	Category	String (ProjCategoryId)	CustInvoiceStandardLineTemplate.ProjCategoryId
LedgerAccountDisplayValue	Combination display	String (DimensionDisplayValue)	DimensionAttributeValueCombination.DisplayValue	Yes
DefaultDimensionDisplayValue	Default dimension display value	String (DimensionDisplayValue)	DimensionSetEntity.DisplayValue
ExternalSystem	External system	String (MGCLatticeExternalSystemId)	Unmapped (virtual)
ProjectIdExternalKey	Project external key	String (MGCLatticeExternalKey)	Unmapped (virtual)

MGCLatticeMobileDeviceStepTextEntity

Mobile Device Step Texts

Property	Value
OData entity set	LatticeMobileDeviceStepTexts (single: LatticeMobileDeviceStepText)
Access	Read/write
Data management	Enabled (staging table MGCLatticeMobileDeviceStepTextStaging)
Company	Company-specific (DataAreaId)
Key	MenuItemName, StepId, TextType, LanguageId
Data sources	WHSMobileAppFlowStep, WHSMobileAppText
Configuration key	WHSandTMS
Granted by	MGCLatticeMobileDeviceStepTextEntityMaintain (full CRUD); MGCLatticeMobileDeviceStepTextEntityView (read)

Field	Label	Type	Source	Mandatory
MenuItemName (key)	Menu item name	String (WHSMenuItemName)	WHSMobileAppFlowStep.MenuItemName
StepId (key)	Name	String (WHSMobileAppStepId)	WHSMobileAppFlowStep.StepId	Yes
TextType (key)	Text type	Enum WHSMobileAppTextType	WHSMobileAppText.Type	Yes
LanguageId (key)	Language code	String (LanguageId)	WHSMobileAppText.LanguageId	Yes
Text	Text	String	WHSMobileAppText.Text

MGCLatticeMobileDeviceStepEntity

Mobile Device Steps

Property	Value
OData entity set	LatticeMobileDeviceSteps (single: LatticeMobileDeviceStep)
Access	Read/write
Data management	Enabled (staging table MGCLatticeMobileDeviceStepStaging)
Company	Company-specific (DataAreaId)
Key	MenuItemName, StepId
Data sources	WHSMobileAppFlowStep
Configuration key	WHSandTMS
Granted by	MGCLatticeMobileDeviceStepEntityMaintain (full CRUD); MGCLatticeMobileDeviceStepEntityView (read)

Field	Label	Type	Source	Mandatory
MenuItemName (key)	Menu item name	String (WHSMenuItemName)	WHSMobileAppFlowStep.MenuItemName
StepId (key)	Name	String (WHSMobileAppStepId)	WHSMobileAppFlowStep.StepId	Yes
StepIcon	Icon	String (WHSMobileAppStepIcon)	WHSMobileAppFlowStep.StepIcon

MGCLatticePeriodCloseCalendarEntity

Period close closing calendar

Property	Value
OData entity set	LatticePeriodCloseCalendars (single: LatticePeriodCloseCalendar)
Access	Read/write
Data management	Enabled (staging table MGCLatticePeriodCloseCalendarStaging)
Company	Shared across companies
Key	Calendar
Data sources	LedgerPeriodCloseCalendar
Configuration key	LedgerBasic
Granted by	MGCLatticePeriodCloseCalendarEntityMaintain (full CRUD); MGCLatticePeriodCloseCalendarEntityView (read)

Field	Label	Type	Source	Mandatory
Calendar (key)	Calendar	String (CalendarId)	LedgerPeriodCloseCalendar.Calendar	Yes
Name	Name	String (CalendarName)	LedgerPeriodCloseCalendar.Name	Yes
StartDate	Start date	Date	LedgerPeriodCloseCalendar.StartDate	Yes
EndDate	End date	Date	LedgerPeriodCloseCalendar.EndDate	Yes

MGCLatticePeriodCloseRoleEntity

Period close closing role

Property	Value
OData entity set	LatticePeriodCloseRoles (single: LatticePeriodCloseRole)
Access	Read/write
Data management	Enabled (staging table MGCLatticePeriodCloseRoleStaging)
Company	Shared across companies
Key	ClosingRoleName
Data sources	LedgerPeriodCloseRole
Configuration key	LedgerBasic
Granted by	MGCLatticePeriodCloseRoleEntityMaintain (full CRUD); MGCLatticePeriodCloseRoleEntityView (read)

Field	Label	Type	Source	Mandatory
ClosingRoleName (key)	Closing role	String (LedgerPeriodCloseRoleName)	LedgerPeriodCloseRole.Name
Description	Description	String (LedgerPeriodCloseRoleDescription)	LedgerPeriodCloseRole.Description

MGCLatticePeriodCloseResourceEntity

Period close resource

Property	Value
OData entity set	LatticePeriodCloseResources (single: LatticePeriodCloseResource)
Access	Read/write
Data management	Enabled (staging table MGCLatticePeriodCloseResourceStaging)
Company	Shared across companies
Key	WorkerPersonnelNumber
Data sources	HcmWorker, LedgerPeriodCloseWorker
Configuration key	LedgerBasic
Granted by	MGCLatticePeriodCloseResourceEntityMaintain (full CRUD); MGCLatticePeriodCloseResourceEntityView (read)

Field	Label	Type	Source	Mandatory
WorkerPersonnelNumber (key)	Personnel number	String (HcmPersonnelNumberId)	HcmWorker.PersonnelNumber
TaskVisibility	View	Enum LedgerPeriodCloseWorkerTaskVisibility	LedgerPeriodCloseWorker.TaskVisibility

MGCLatticePeriodCloseTaskAreaEntity

Period close task area

Property	Value
OData entity set	LatticePeriodCloseTaskAreas (single: LatticePeriodCloseTaskArea)
Access	Read/write
Data management	Enabled (staging table MGCLatticePeriodCloseTaskAreaStaging)
Company	Shared across companies
Key	TaskAreaName
Data sources	LedgerPeriodCloseArea
Configuration key	LedgerBasic
Granted by	MGCLatticePeriodCloseTaskAreaEntityMaintain (full CRUD); MGCLatticePeriodCloseTaskAreaEntityView (read)

Field	Label	Type	Source	Mandatory
TaskAreaName (key)	Area	String (LedgerPeriodCloseAreaName)	LedgerPeriodCloseArea.Name
Description	Description	String (LedgerPeriodCloseAreaDescription)	LedgerPeriodCloseArea.Description

MGCLatticePrintManagementSettingEntity

Print Management Settings

Print management settings for module-level defaults and customer- or vendor-account overrides; order-level settings are not included. Maps PrintMgmtSettings with its PrintMgmtDocInstance node. The account override is exposed as AccountTableName and AccountNum (both blank for module-level settings), computed in SQL so that rows can be read, updated and deleted by key, and resolved to the account in the target company on import. The print destination is exposed as DestinationType, FileFormat and FileName.

Property	Value
OData entity set	LatticePrintManagementSettings (single: LatticePrintManagementSetting)
Access	Read/write
Data management	Enabled (staging table MGCLatticePrintManagementSettingStaging)
Company	Company-specific (DataAreaId)
Key	NodeType, DocumentType, PrintType, AccountTableName, AccountNum, DocInstancePriorityId, SettingPriorityId
Data sources	PrintMgmtSettings, PrintMgmtDocInstance
Granted by	MGCLatticePrintManagementSettingEntityMaintain (full CRUD); MGCLatticePrintManagementSettingEntityView (read)

Field	Label	Type	Source	Mandatory
NodeType (key)	Print management node type	Enum PrintMgmtNodeType	PrintMgmtDocInstance.NodeType	Yes
DocumentType (key)	Document type	Enum PrintMgmtDocumentType	PrintMgmtDocInstance.DocumentType	Yes
PrintType (key)	Original / copy	Enum PrintMgmtDocInstanceType	PrintMgmtDocInstance.PrintType
SetupName	Name	String (PrintMgmtSetupName)	PrintMgmtDocInstance.Name
DocInstancePriorityId (key)	Priority	Real (PrintMgmtPriorityId)	PrintMgmtDocInstance.PriorityId	Yes
AccountTableName (key)	Table name	String (TableName)	Computed
AccountNum (key)	Account number	String (CustVendAC)	Computed
Description	Description of print management setting	String (Description)	PrintMgmtSettings.Description	Yes
NumberOfCopies	Number of copies	Int (PrintMgmtSetupCopies)	PrintMgmtSettings.NumberOfCopies
SettingPriorityId (key)	Priority	Real (PrintMgmtPriorityId)	PrintMgmtSettings.PriorityId	Yes
Suppress	Do not print	Enum NoYes	PrintMgmtSettings.Suppress
DestinationType	Print medium	Enum SRSPrintMediumType	Computed
FileFormat	File format	Enum SRSReportFileFormat	Computed
FileName	Directory	String (FilePath)	Computed

MGCLatticeRecurringDataJobEntity

Recurring data job

A data management recurring data job: the schedule that moves messages into or out of a data project. Maps IntegrationActivityTable, with the packed recurrence containers projected into scalar fields and activation routed through the platform scheduler.

Property	Value
OData entity set	LatticeRecurringDataJobs (single: LatticeRecurringDataJob)
Access	Read/write
Data management	Enabled (staging table MGCLatticeRecurringDataJobStaging)
Company	Shared across companies
Key	Name
Data sources	IntegrationActivityTable
Granted by	MGCLatticeRecurringDataJobEntityMaintain (full CRUD); MGCLatticeRecurringDataJobEntityView (read)

Field	Label	Type	Source	Mandatory
Name (key)	Name	String (IntegrationName)	IntegrationActivityTable.Name	Yes
Description	Description	String (IntegrationDescription)	IntegrationActivityTable.Description
DataProjectName	Processing group	String (DMFDefinitionGroupName)	IntegrationActivityTable.DefinitionGroupName	Yes
Direction	Direction	Enum IntegrationDirection	IntegrationActivityTable.Direction
State	Enabled	Enum IntegrationActivityState	IntegrationActivityTable.State
ActivityId	ID	Guid (IntegrationActivityId)	IntegrationActivityTable.ActivityId
DataSourceType	Supported data source type	Enum IntegrationActivityDataSource	IntegrationActivityTable.DataSource
ProcessMessagesSerially	Process messages only in the order received	Enum NoYes	IntegrationActivityTable.ProcessMessagesSerially
UseDataAreaIdFromMessage	Specify if the legal entity for processing would be picked from the submitted job. If no, messages would be processed in the company context in which this job is scheduled to run.	Enum NoYes	IntegrationActivityTable.UseDataAreaIdFromMessage
PreventUpload	Prevent upload when zero records	Enum NoYes	IntegrationActivityTable.PreventUpload
RecurrenceUnit	Recurrence unit	Enum SysRecurrenceUnit	Computed
RecurrenceInterval	Recurrence interval	Int (MGCLatticeRecurrenceInterval)	Computed
RecurrenceStartDateTime	Recurrence starts	UtcDateTime (StartDateTime)	Computed
RecurrenceEndType	Recurrence ends	Enum MGCLatticeRecurrenceEndType	Computed
RecurrenceEndAfterCount	Number of runs	Int (MGCLatticeRecurrenceEndAfterCount)	Computed
RecurrenceEndDate	Recurrence end date	Date (EndDate)	Computed
RecurrenceTimeZone	Recurrence time zone	Enum Timezone	Computed
MonitoringRecurrenceUnit	Monitoring recurrence unit	Enum SysRecurrenceUnit	Computed
MonitoringRecurrenceInterval	Monitoring recurrence interval	Int (MGCLatticeRecurrenceInterval)	Computed
BatchGroupId	Batch group	String (BatchGroupId)	Computed
RecurrenceDescription	Recurrence	String (SysRecurrenceText)	Computed

MGCLatticeRecurringDataJobClientEntity

Recurring data job client

A client application authorized to submit messages to a recurring data job. Maps IntegrationClientMapTable, exchanging the job by name rather than by the record id the row stores.

Property	Value
OData entity set	LatticeRecurringDataJobClients (single: LatticeRecurringDataJobClient)
Access	Read/write
Data management	Enabled (staging table MGCLatticeRecurringDataJobClientStaging)
Company	Shared across companies
Key	JobName, ClientId
Data sources	IntegrationClientMapTable
Granted by	MGCLatticeRecurringDataJobClientEntityMaintain (full CRUD); MGCLatticeRecurringDataJobClientEntityView (read)

Field	Label	Type	Source	Mandatory
JobName (key)	Recurring data job	String (IntegrationName)	Computed	Yes
ClientId (key)	Client id	String (IntegrationClientId)	IntegrationClientMapTable.ClientId	Yes
IsEnabled	Enabled	Enum NoYes	IntegrationClientMapTable.IsEnabled

MGCLatticeRecurringJobHealthEntity

Recurring data job health

The health of each recurring data job: state, reasons, signal values and the job's health thresholds. Keyed by job name; only the thresholds and the alert flag can be written.

Property	Value
OData entity set	LatticeRecurringJobHealths (single: LatticeRecurringJobHealth)
Access	Read/write
Data management	Enabled (staging table MGCLatticeRecurringJobHealthStaging)
Company	Shared across companies
Key	JobName
Data sources	MGCLatticeRecurringJobHealth, IntegrationActivityTable
Granted by	MGCLatticeRecurringJobHealthEntityMaintain (full CRUD); MGCLatticeRecurringJobHealthEntityView (read)

Field	Label	Type	Source	Mandatory
JobName (key)	Recurring data job	String (IntegrationName)	IntegrationActivityTable.Name	Yes
ActivityId	Recurring data job ID	Guid (IntegrationActivityId)	MGCLatticeRecurringJobHealth.ActivityId	Yes
JobDescription	Description	String (IntegrationDescription)	IntegrationActivityTable.Description
Direction	Direction	Enum IntegrationDirection	IntegrationActivityTable.Direction
JobState	Job state	Enum IntegrationActivityState	IntegrationActivityTable.State
DataProjectName	Processing group	String (DMFDefinitionGroupName)	IntegrationActivityTable.DefinitionGroupName
WindowHours	Failure window (hours)	Int (MGCLatticeDurationHours)	MGCLatticeRecurringJobHealth.WindowHours
BacklogAgeMinutes	Backlog age (minutes)	Int (MGCLatticeDurationMinutes)	MGCLatticeRecurringJobHealth.BacklogAgeMinutes
SilenceMinutes	Silence period (minutes)	Int (MGCLatticeDurationMinutes)	MGCLatticeRecurringJobHealth.SilenceMinutes
StuckMinutes	Stuck after (minutes)	Int (MGCLatticeDurationMinutes)	MGCLatticeRecurringJobHealth.StuckMinutes
FailureThreshold	Failure threshold	Int (MGCLatticeRecordCount)	MGCLatticeRecurringJobHealth.FailureThreshold
AlertsEnabled	Alerts enabled	Enum NoYes	MGCLatticeRecurringJobHealth.AlertsEnabled
HealthState	Health	Enum MGCLatticeRecurringJobHealthState	MGCLatticeRecurringJobHealth.HealthState
PreviousHealthState	Previous health	Enum MGCLatticeRecurringJobHealthState	MGCLatticeRecurringJobHealth.PreviousHealthState
StateChangedDateTime	Health changed	UtcDateTime (TransDateTime)	MGCLatticeRecurringJobHealth.StateChangedDateTime
EvaluatedDateTime	Evaluated	UtcDateTime (TransDateTime)	MGCLatticeRecurringJobHealth.EvaluatedDateTime
Reasons	Reasons	String (Notes)	MGCLatticeRecurringJobHealth.Reasons
BacklogCount	Waiting messages	Int (MGCLatticeRecordCount)	MGCLatticeRecurringJobHealth.BacklogCount
OldestBacklogDateTime	Oldest waiting since	UtcDateTime (TransDateTime)	MGCLatticeRecurringJobHealth.OldestBacklogDateTime
FailedMessageCount	Failed messages	Int (MGCLatticeRecordCount)	MGCLatticeRecurringJobHealth.FailedMessageCount
PartialExecutionCount	Partially processed messages	Int (MGCLatticeRecordCount)	MGCLatticeRecurringJobHealth.PartialExecutionCount
LastMessageDateTime	Last message	UtcDateTime (TransDateTime)	MGCLatticeRecurringJobHealth.LastMessageDateTime
StuckMessageCount	Stuck messages	Int (MGCLatticeRecordCount)	MGCLatticeRecurringJobHealth.StuckMessageCount
EnabledClientCount	Enabled clients	Int (MGCLatticeRecordCount)	MGCLatticeRecurringJobHealth.EnabledClientCount
MappingErrorCount	Mapping errors	Int (MGCLatticeRecordCount)	MGCLatticeRecurringJobHealth.MappingErrorCount
ProcessingBatchJobId	Processing batch job	Int64 (RefRecId)	MGCLatticeRecurringJobHealth.ProcessingBatchJobId
ProcessingBatchJobStatus	Processing batch job status	Enum BatchStatus	MGCLatticeRecurringJobHealth.ProcessingBatchJobStatus
MonitoringBatchJobId	Monitoring batch job	Int64 (RefRecId)	MGCLatticeRecurringJobHealth.MonitoringBatchJobId
MonitoringBatchJobStatus	Monitoring batch job status	Enum BatchStatus	MGCLatticeRecurringJobHealth.MonitoringBatchJobStatus

MGCLatticeTransportCalendarSetupEntity

Transport calendar setup

Property	Value
OData entity set	LatticeTransportCalendarSetups (single: LatticeTransportCalendarSetup)
Access	Read/write
Data management	Enabled (staging table MGCLatticeTransportCalendarSetupStaging)
Company	Company-specific (DataAreaId)
Key	ModeOfDeliveryId, InventoryWarehouseId
Data sources	CustVendTransportCalendarSetup
Configuration key	LogisticsBasic
Granted by	MGCLatticeTransportCalendarSetupEntityMaintain (full CRUD); MGCLatticeTransportCalendarSetupEntityView (read)

Field	Label	Type	Source	Mandatory
ModeOfDeliveryId (key)	Mode of delivery	String (DlvModeId)	CustVendTransportCalendarSetup.DlvMode	Yes
InventoryWarehouseId (key)	Warehouse	String (InventLocationId)	CustVendTransportCalendarSetup.InventLocation
TransportCalendarId	Transport calendar	String (CustVendTransportCalendarId)	CustVendTransportCalendarSetup.Calendar

MGCLatticeVendorSummaryUpdateParametersEntity

Vendor summary update parameters

Property	Value
OData entity set	LatticeVendorSummaryUpdateParameters (single: LatticeVendorSummaryUpdateParameter)
Access	Read/write
Data management	Enabled (staging table MGCLatticeVendorSummaryUpdateParametersStaging)
Company	Company-specific (DataAreaId)
Key	VendorAccountNumber, ModuleType, PurchaseOrderNumber, DocumentType
Data sources	PurchJournalAutoSummary
Configuration key	LogisticsBasic
Granted by	MGCLatticeVendorSummaryUpdateParametersEntityMaintain (full CRUD); MGCLatticeVendorSummaryUpdateParametersEntityView (read)

Field	Label	Type	Source	Mandatory
VendorAccountNumber (key)	Vendor account	String (VendAccount)	PurchJournalAutoSummary.VendAccount
ModuleType (key)	Module	Enum ModuleVendPurch	PurchJournalAutoSummary.ModuleType
PurchaseOrderNumber (key)	Purchase order	String (PurchIdBase)	PurchJournalAutoSummary.PurchId
DocumentType (key)	Form	Enum DocumentStatus	PurchJournalAutoSummary.DocumentStatus
SummaryUpdate	Automatic summary	Enum NoYes	PurchJournalAutoSummary.AutoSummary

Document entities

MGCLatticeSetBasedBankStatementLineEntity

Bank statement lines (set-based)

Imports bank statement lines (advanced bank reconciliation) in bulk with set-based processing. Lines are added to an existing open bank statement identified by bank account and statement ID; the statement's number of entries and net amount are recalculated.

Property	Value
OData entity set	Not exposed over OData
Access	Read/write
Data management	Enabled (staging table MGCLatticeSetBasedBankStatementLineStaging)
Company	Company-specific (DataAreaId)
Key	BankAccountId, StatementId, LineNumber
Data sources	BankStmtISOAccountStatement, BankStmtISOReportEntry, BankStmtISOPartyIdentification
Configuration key	BankElectronicBanking
Granted by	MGCLatticeSetBasedBankStatementLineEntityMaintain (full CRUD); MGCLatticeSetBasedBankStatementLineEntityView (read)

Field	Label	Type	Source	Mandatory
BankAccountId (key)	Bank account	String (CompanyBankAccountId)	BankStmtISOAccountStatement.BankAccountTable	Yes
StatementId (key)	Statement ID	String (BankStatementId)	BankStmtISOAccountStatement.Identification	Yes
LineNumber (key)	Line number	Real (LineNum)	Unmapped (virtual)	Yes
BookingDate	Booking date	UtcDateTime (BankStatementBookingDate)	BankStmtISOReportEntry.BookingDateTime
DebitAmount	Debit amount	Real (AmountCur)	Unmapped (virtual)
CreditAmount	Credit amount	Real (AmountCur)	Unmapped (virtual)
LineStatus	Status	Enum BankStatementLineStatus	BankStmtISOReportEntry.BankStatementLineStatus
ReversalIndicator	Reversal	Enum NoYes	BankStmtISOReportEntry.ReversalIndicator
EntryReference	Entry reference	String (BankStmtISOMax500Text)	BankStmtISOReportEntry.EntryReference
AccountServicerReference	Text	String (BankStmtISOMax500Text)	BankStmtISOReportEntry.AccountServicerReference
ReferenceNumber	Reference No.	String (BankStmtISOMax500Text)	BankStmtISOReportEntry.ReferenceNumber
BankDocumentNumber	Document number	String (BankStatementIdentificationText)	BankStmtISOReportEntry.BankDocumentNumber
BankTransactionCode	Bank statement transaction code	String (BankStatementIdentificationText)	BankStmtISOReportEntry.ProprietaryBankTransactionCode
Description	Description	String (BankStmtISOMax500Text)	BankStmtISOReportEntry.AdditionalEntryInformation
CreditorReference	Creditor reference information	String (BankStmtCreditorReferenceInformation)	BankStmtISOReportEntry.CreditorReferenceInformation
CounterpartyName	Name	String (BankStatementNameText)	BankStmtISOPartyIdentification.Name
CounterpartyId	Text	String (BankStatementIdentificationText)	BankStmtISOPartyIdentification.PartyIdOrganisationGenericOrgId
CounterpartyBankAccount	Related bank account	String (BankStatementIdentificationText)	BankStmtISOReportEntry.RelatedBankAccount
CounterpartyBankName	Related bank	String (BankStatementNameText)	BankStmtISOReportEntry.RelatedBankName
CounterCurrencyCode	Counter currency	String (BankStmtISOCurrencyCode)	BankStmtISOReportEntry.BankStatementCounterCurrency
CounterCurrencyAmount	Counter amount	Real (AmountCur)	BankStmtISOReportEntry.BankStatementCounterCurrencyAmount
CounterExchangeRate	Counter exchange rate	Real (ExchRate)	BankStmtISOReportEntry.BankStatementCounterExchangeRate

MGCLatticeCustomerContactInfoEntity

Customer Contact Information

Property	Value
OData entity set	LatticeCustomerContactInfos (single: LatticeCustomerContactInfo)
Access	Read/write
Data management	Enabled (staging table MGCLatticeCustomerContactInfoStaging)
Company	Company-specific (CustomerDataAreaId)
Key	CustomerAccount, CustomerDataAreaId, Type, Locator, Description
Data sources	DirPartyContactEntity, CustTable, DirPartyTable
Configuration key	LogisticsBasic
Granted by	MGCLatticeCustomerContactInfoEntityMaintain (full CRUD); MGCLatticeCustomerContactInfoEntityView (read)

Field	Label	Type	Source	Mandatory
Type (key)	Type	Enum LogisticsElectronicAddressMethodType	DirPartyContactEntity.Type	Yes
Locator (key)	Contact number/address	String (LogisticsElectronicAddressLocator)	DirPartyContactEntity.Locator
Description (key)	Description	String (Description)	DirPartyContactEntity.Description
Purpose	Purpose	String (DirPartyContactLocationRoleNames)	DirPartyContactEntity.Purpose
LocatorExtension	Extension	String (PhoneLocal)	DirPartyContactEntity.LocatorExtension
CountryRegionCode	International calling code	String (LogisticsCountryRegionCode)	DirPartyContactEntity.CountryRegionCode
IsPrimary	Primary	Enum NoYes	DirPartyContactEntity.IsPrimary
IsMobilePhone	Mobile	Enum NoYes	DirPartyContactEntity.IsMobilePhone
IsPrivate	Private	Enum NoYes	DirPartyContactEntity.IsPrivate
LocationId	Location ID	String (LogisticsLocationId)	DirPartyContactEntity.LocationId	Yes
PartyNumber	Party ID	String (DirPartyNumber)	DirPartyContactEntity.PartyNumber	Yes
CustomerAccount (key)	Customer account	String (CustAccount)	CustTable.AccountNum	Yes
CustomerDataAreaId (key)	Company	String (DataAreaId)	CustTable.DataAreaId

MGCLatticeCustomerContactPersonEntity

Customer Contact Persons

Property	Value
OData entity set	LatticeCustomerContactPersons (single: LatticeCustomerContactPerson)
Access	Read/write
Data management	Enabled (staging table MGCLatticeCustomerContactPersonStaging)
Company	Company-specific (CustomerDataAreaId)
Key	CustomerAccount, CustomerDataAreaId, ContactPersonId
Data sources	smmContactPersonV2Entity, CustTable, DirPartyTable
Configuration key	LogisticsBasic
Granted by	MGCLatticeCustomerContactPersonsEntityMaintain (full CRUD); MGCLatticeCustomerContactPersonsEntityView (read)

Field	Label	Type	Source	Mandatory
AddressBookNames	Address books	String (DirAddressBookNames)	smmContactPersonV2Entity.AddressBookNames
AlternateComplimentaryClosingPhrase			smmContactPersonV2Entity.AlternateComplimentaryClosingPhrase
AlternateSalutationPhrase			smmContactPersonV2Entity.AlternateSalutationPhrase
AnniversaryDay			smmContactPersonV2Entity.AnniversaryDay
AnniversaryMonth			smmContactPersonV2Entity.AnniversaryMonth
AnniversaryYear			smmContactPersonV2Entity.AnniversaryYear
AssistantName	Name	String (smmAssistantName)	smmContactPersonV2Entity.AssistantName
AssistantPhoneNumber	Phone number	String (smmAssistantPhone)	smmContactPersonV2Entity.AssistantPhoneNumber
AssociatedPartyNumber	Associated party number	String (DirPartyNumber)	smmContactPersonV2Entity.AssociatedPartyNumber	Yes
AvailableFromTime			smmContactPersonV2Entity.AvailableFromTime
AvailableToTime			smmContactPersonV2Entity.AvailableToTime
BillingInformation			smmContactPersonV2Entity.BillingInformation
BirthDay			smmContactPersonV2Entity.BirthDay
BirthMonth			smmContactPersonV2Entity.BirthMonth
BirthYear			smmContactPersonV2Entity.BirthYear
ChildrenNames			smmContactPersonV2Entity.ChildrenNames
ContactActivitySensitivityLevel	Sensitivity	Enum smmSensitivity	smmContactPersonV2Entity.ContactActivitySensitivityLevel
ContactInformationLanguageId	Language	String (LanguageId)	smmContactPersonV2Entity.ContactInformationLanguageId
ContactPersonId (key)	Contact ID	String (ContactPersonId)	smmContactPersonV2Entity.ContactPersonId	Yes
ContactPersonName	Name	String (DirPartyName)	smmContactPersonV2Entity.ContactPersonName	Yes
ContactPersonPartyNumber	Party ID	String (DirPartyNumber)	smmContactPersonV2Entity.ContactPersonPartyNumber	Yes
ContactPersonPartyType	Contact person party type	String (DirPartyInstanceRelationTypeName)	smmContactPersonV2Entity.ContactPersonPartyType
ContactPersonResponsiblePersonnelNumber	Personnel number	String (HcmPersonnelNumberId)	smmContactPersonV2Entity.ContactPersonResponsiblePersonnelNumber
DecisionMakingRoleCode			smmContactPersonV2Entity.DecisionMakingRoleCode
DisplayNameSequencePatternName	Display as	String (DirNameSequenceDisplayAs)	smmContactPersonV2Entity.DisplayNameSequencePatternName	Yes
ElectronicLocationId	Location ID	String (LogisticsLocationId)	smmContactPersonV2Entity.ElectronicLocationId
EmploymentComputerNetworkName	Computer network name	String (smmComputerNetworkName)	smmContactPersonV2Entity.EmploymentComputerNetworkName
EmploymentDepartment	Department	String (smmDepartment)	smmContactPersonV2Entity.EmploymentDepartment
EmploymentJobFunctionName			smmContactPersonV2Entity.EmploymentJobFunctionName
EmploymentJobTitle	Job title	String (PersonTitle)	smmContactPersonV2Entity.EmploymentJobTitle
EmploymentOfficeLocation	Office location	String (smmOfficeLocation)	smmContactPersonV2Entity.EmploymentOfficeLocation
EmploymentProfession	Profession	String (smmProfession)	smmContactPersonV2Entity.EmploymentProfession
FirstName	First name	String (FirstName)	smmContactPersonV2Entity.FirstName
FormattedPrimaryAddress	Address	String (LogisticsAddressing)	smmContactPersonV2Entity.FormattedPrimaryAddress
Gender			smmContactPersonV2Entity.Gender
GovernmentIdentificationNumber	Government ID	String (smmGovernmentIDNumber)	smmContactPersonV2Entity.GovernmentIdentificationNumber
HasRequestedInternetAccess	Request internet access	Enum NoYes	smmContactPersonV2Entity.HasRequestedInternetAccess
Hobbies			smmContactPersonV2Entity.Hobbies
IdentityCardNumber			smmContactPersonV2Entity.IdentityCardNumber
Initials			smmContactPersonV2Entity.Initials
IsContactPersonExternallyMaintained			smmContactPersonV2Entity.IsContactPersonExternallyMaintained
IsDefaultContactPerson			smmContactPersonV2Entity.IsDefaultContactPerson
IsImported	Imported	Enum NoYes	smmContactPersonV2Entity.IsImported
IsInactive	Inactive	Enum NoYes	smmContactPersonV2Entity.IsInactive
LastName	Last name	String (LastName)	smmContactPersonV2Entity.LastName
MiddleName	Middle name	String (MiddleName)	smmContactPersonV2Entity.MiddleName
PrimaryAddressCity	City	String (LogisticsAddressCityName)	smmContactPersonV2Entity.PrimaryAddressCity
PrimaryAddressCountryRegionId	Country/region	String (LogisticsAddressCountryRegionId)	smmContactPersonV2Entity.PrimaryAddressCountryRegionId	Yes
PrimaryAddressCountryRegionISOCode	Country/region ISO	String (LogisticsAddressCountryRegionISOCode)	smmContactPersonV2Entity.PrimaryAddressCountryRegionISOCode
PrimaryAddressStateId	State	String (LogisticsAddressStateId)	smmContactPersonV2Entity.PrimaryAddressStateId
PrimaryAddressStreet	Street	String (LogisticsAddressStreet)	smmContactPersonV2Entity.PrimaryAddressStreet
PrimaryAddressZipCode	ZIP/postal code	String (LogisticsAddressZipCodeId)	smmContactPersonV2Entity.PrimaryAddressZipCode
PrimaryEmailAddress	Contact number/address	String (LogisticsElectronicAddressLocator)	smmContactPersonV2Entity.PrimaryEmailAddress
PrimaryPhoneNumber	Contact number/address	String (LogisticsElectronicAddressLocator)	smmContactPersonV2Entity.PrimaryPhoneNumber
PrimaryFaxNumber	Contact number/address	String (LogisticsElectronicAddressLocator)	smmContactPersonV2Entity.PrimaryFaxNumber
PrimaryURL	Contact number/address	String (LogisticsElectronicAddressLocator)	smmContactPersonV2Entity.PrimaryURL
SearchName	Search name	String (NameAlias)	smmContactPersonV2Entity.SearchName
CustomerAccount (key)	Customer account	String (CustAccount)	CustTable.AccountNum	Yes
CustomerDataAreaId (key)	Company	String (DataAreaId)	CustTable.DataAreaId

MGCLatticeCustomerDocumentAttachmentEntity

Customer Document Attachments

Property	Value
OData entity set	LatticeCustomerDocumentAttachments (single: LatticeCustomerDocumentAttachment)
Access	Read/write
Data management	Enabled (staging table MGCLatticeCustomerDocumentAttachmentStaging)
Company	Company-specific (ActualCompanyId)
Key	DocumentId
Data sources	CustTable, DocuRefEntity
Configuration key	LedgerBasic
Granted by	MGCLatticeCustDocAttachmentEntityMaintain (full CRUD); MGCLatticeCustDocAttachmentEntityView (read)

Field	Label	Type	Source	Mandatory
DocumentId (key)	Document ID	Guid (DocuDocumentId)	DocuRefEntity.DocumentId
ActualCompanyId	Company accounts	String (SelectableDataArea)	DocuRefEntity.ActualCompanyId
DocumentAttachmentTypeCode	Type	String (DocuTypeId)	DocuRefEntity.TypeId	Yes
AttachmentDescription	Description	String (Description)	DocuRefEntity.Name
Notes	Note	String (Notes)	DocuRefEntity.Notes
AccessRestriction	Restriction	Enum DocuRestriction	DocuRefEntity.Restriction
Attachment	Archive file	Container (BitMap)	DocuRefEntity.FileContents
FileName	File name	String (Filename)	DocuRefEntity.FileName
FileType	File type	String (FilenameType)	DocuRefEntity.FileType
IsDefaultAttachment	Is default attachment	Enum NoYes	DocuRefEntity.DefaultAttachment
CustomerAccount	Customer account	String (CustAccount)	CustTable.AccountNum	Yes
ExternalSystem	External system	String (MGCLatticeExternalSystemId)	Unmapped (virtual)
CustomerAccountExternalKey	Customer external key	String (MGCLatticeExternalKey)	Unmapped (virtual)

MGCLatticeSetBasedCustomerInvoiceJournalLineEntity

Customer invoice journal lines (set-based)

Imports customer invoices in bulk with set-based processing into general journals, which post the invoices to the customers: one new journal per journal key, or lines added to an open journal.

Property	Value
OData entity set	Not exposed over OData
Access	Read/write
Data management	Enabled (staging table MGCLatticeSetBasedCustomerInvoiceJournalLineStaging)
Company	Company-specific (DataAreaId)
Key	JournalNumber, LineNumber
Data sources	LedgerJournalTable, LedgerJournalTrans
Configuration key	LedgerBasic
Granted by	MGCLatticeSetBasedCustomerInvoiceJournalLineEntityMaintain (full CRUD); MGCLatticeSetBasedCustomerInvoiceJournalLineEntityView (read)

Field	Label	Type	Source	Mandatory
JournalNumber (key)	Journal batch number	String (LedgerJournalId)	LedgerJournalTable.JournalNum	Yes
JournalNameId	Name	String (LedgerJournalNameId)	LedgerJournalTable.JournalName	Yes
LineNumber (key)	Line number	Real (LineNum)	LedgerJournalTrans.LineNum	Yes
TransactionDate	Date	Date (TransDate)	LedgerJournalTrans.TransDate
Voucher	Voucher	String (Voucher)	LedgerJournalTrans.Voucher
CustomerAccount	Customer account	String (CustAccount)	Unmapped (virtual)	Yes
InvoiceNumber	Invoice	String (InvoiceId)	LedgerJournalTrans.Invoice	Yes
DocumentNumber	Document	String (DocumentNum)	LedgerJournalTrans.DocumentNum
DocumentDate	Document date	Date (DocumentDate)	LedgerJournalTrans.DocumentDate
DueDate	Due date	Date (DueDate)	LedgerJournalTrans.Due
TermsOfPayment	Terms of payment	String (PaymTermId)	LedgerJournalTrans.Payment
Description	Description	String (LedgerJournalTransTxt)	LedgerJournalTrans.Txt
CurrencyCode	Currency	String (CurrencyCode)	LedgerJournalTrans.CurrencyCode	Yes
ExchangeRate	Exchange rate	Real (ExchRate)	LedgerJournalTrans.ExchRate
DebitAmount	Debit	Real (AmountCurDebit)	LedgerJournalTrans.AmountCurDebit
CreditAmount	Credit	Real (AmountCurCredit)	LedgerJournalTrans.AmountCurCredit
MethodOfPayment	Method of payment	String (PaymMode)	LedgerJournalTrans.PaymMode
BankTransactionType	Bank transaction type	String (BankTransactionType)	LedgerJournalTrans.BankTransType
PaymentReference	Payment reference	String (PaymReference)	LedgerJournalTrans.PaymReference
SalesTaxGroup	Sales tax group	String (TaxGroupJournal)	LedgerJournalTrans.TaxGroup
ItemSalesTaxGroup	Item sales tax group	String (TaxGroupJournal)	LedgerJournalTrans.TaxItemGroup
PostingProfile	Posting profile	String (PostingProfile)	LedgerJournalTrans.PostingProfile
OffsetAccountType	Offset account type	Enum LedgerJournalACType	LedgerJournalTrans.OffsetAccountType
OffsetAccountDisplayValue	Offset account	String (DimensionDisplayValue)	Unmapped (virtual)
DefaultDimensionDisplayValue	Financial dimensions	String (DimensionDisplayValue)	Unmapped (virtual)

MGCLatticeCustomerPackingSlipJournalHeaderEntity

Customer Packing Slip Journal Headers

Property	Value
OData entity set	LatticeCustomerPackingSlipJournalHeaders (single: LatticeCustomerPackingSlipJournalHeader)
Access	Read-only
Data management	Enabled (staging table MGCLatticeCustomerPackingSlipJournalHeaderStaging)
Company	Company-specific (DataAreaId)
Key	PackingSlipId, SalesOrderNumber
Data sources	DimensionSetEntity, LogisticsPostalAddressBaseEntity, HcmWorker, CustPackingSlipJour
Configuration key	LedgerBasic
Granted by	MGCLatticeCustomerPackingSlipJournalHeaderEntityMaintain (read); MGCLatticeCustomerPackingSlipJournalHeaderEntityView (read)

Field	Label	Type	Source	Mandatory
Weight	Weight	Real (Weight)	CustPackingSlipJour.Weight
BillOfLadingId	Bill of lading	String (WMSBillOfLadingId)	CustPackingSlipJour.BillOfLadingId
BOLAddress	Address	String (Addressing)	CustPackingSlipJour.BOLAddress
BOLCarrierName	Carrier name	String (WMSCarrierName)	CustPackingSlipJour.BOLCarrierName
BOLFreightedBy	Freighted by	Enum WMSFreightedBy	CustPackingSlipJour.BOLFreightedBy
BOLPackageAppearance	Package appearance	String (WMSPackageAppearance)	CustPackingSlipJour.BOLPackageAppearance
ContactPersonId	Contact ID	String (ContactPersonId)	CustPackingSlipJour.ContactPersonId
CustomerRef	Your ref.	String (CustRef)	CustPackingSlipJour.CustomerRef
DeliveryDate	Ship date	Date (SalesShippingDate)	CustPackingSlipJour.DeliveryDate
DeliveryName	Delivery name	String (CustName)	CustPackingSlipJour.DeliveryName
DeliveryModeCode	Mode of delivery	String (CustDlvModeId)	CustPackingSlipJour.DlvMode
DeliveryReasonId	Delivery reason	String (DlvReasonId)	CustPackingSlipJour.DlvReason
DeliveryTermsId	Terms	String (CustDlvTermId)	CustPackingSlipJour.DlvTerm
DocumentDate	Document date	Date (DocumentDate)	CustPackingSlipJour.DocumentDate
ExportReason	Reason for export	String (SalesExportReason)	CustPackingSlipJour.ExportReason
FreightSlipNumber	Call tag number	String (FreightSlipNum)	CustPackingSlipJour.FreightSlipNum
FreightSlipType	Call tag type	Enum FreightSlipType	CustPackingSlipJour.FreightSlipType
IntercompanyLegalEntityId	Intercompany company	String (InterCompanyCompanyId)	CustPackingSlipJour.InterCompanyCompanyId
IntercompanyPosted	Posted via intercompany	Enum NoYes	CustPackingSlipJour.InterCompanyPosted
IntercompanyPurchaseOrderNumber	Intercompany purchase order	String (InterCompanyPurchId)	CustPackingSlipJour.InterCompanyPurchId
IntrastatDispatch	Shipment batch	String (IntrastatDispatchId)	CustPackingSlipJour.IntrastatDispatch
InventoryWarehouseId	Warehouse	String (SalesInventLocationId)	CustPackingSlipJour.InventLocationId
InvoiceAccount	Invoice account	String (CustInvoiceAccount)	CustPackingSlipJour.InvoiceAccount	Yes
InvoicingName	Invoicing name	String (CustName)	CustPackingSlipJour.InvoicingName
LanguageId	Language	String (CustLanguageId)	CustPackingSlipJour.LanguageId	Yes
LedgerVoucher	Voucher	String (Voucher)	CustPackingSlipJour.LedgerVoucher
CustomerAccount	Order account	String (CustAccount)	CustPackingSlipJour.OrderAccount	Yes
PackingSlipId (key)	Packing slip	String (PackingSlipId)	CustPackingSlipJour.PackingSlipId
PurchaseOrder	Customer requisition	String (CustPurchaseOrder)	CustPackingSlipJour.PurchaseOrder
Quantity	Sales quantity	Real (SalesQty)	CustPackingSlipJour.Qty
ReturnItemNumber	RMA number	String (ReturnItemNum)	CustPackingSlipJour.ReturnItemNum
ReturnPackingSlipId	Customer packing slip number	String (ReturnPackingSlipId)	CustPackingSlipJour.ReturnPackingSlipId
SalesOrderNumber (key)	Sales order	String (SalesIdBase)	CustPackingSlipJour.SalesId	Yes
SalesOrderType	Order type	Enum SalesType	CustPackingSlipJour.SalesType
ShipCarrierAccount	Carrier account number	String (ShipCarrierAccount)	CustPackingSlipJour.ShipCarrierAccount
ShipCarrierBlindShipment	Blind shipment	Enum NoYes	CustPackingSlipJour.ShipCarrierBlindShipment
ShipCarrierDeliveryContact	Name	String (Name)	CustPackingSlipJour.ShipCarrierDeliveryContact
ShipCarrierEmail	Email	String (Email)	CustPackingSlipJour.ShipCarrierEmail
ShipCarrierId	Carrier ID	String (ShipCarrierId)	CustPackingSlipJour.ShipCarrierId
ShipCarrierPhone	Telephone	String (Phone)	CustPackingSlipJour.ShipCarrierPhone
Volume	Volume	Real (Volume)	CustPackingSlipJour.Volume
PersonnelNumber	Personnel number	String (HcmPersonnelNumberId)	HcmWorker.PersonnelNumber
DefaultDimensionDisplayValue	Default dimension display value	String (DimensionDisplayValue)	DimensionSetEntity.DisplayValue
DeliveryAddressCity	City	String (LogisticsAddressCityName)	LogisticsPostalAddressBaseEntity.City
DeliveryAddressCountryRegionId	Country/region	String (LogisticsAddressCountryRegionId)	LogisticsPostalAddressBaseEntity.CountryRegionId	Yes
DeliveryAddressCountryRegionISOCode	Country/region ISO	String (LogisticsAddressCountryRegionISOCode)	LogisticsPostalAddressBaseEntity.CountryRegionISOCode
DeliveryAddressCountyId	County	String (LogisticsAddressCountyId)	LogisticsPostalAddressBaseEntity.County
DeliveryAddressDescription	Name or description	String (LogisticsDescription)	LogisticsPostalAddressBaseEntity.Description
DeliveryAddressDistrictName	District	String (LogisticsAddressDistrictName)	LogisticsPostalAddressBaseEntity.DistrictName
DeliveryAddressDunsNumber	DUNS number	String (LogisticsDunsNumber)	LogisticsPostalAddressBaseEntity.DunsNumber
IsDeliveryAddressPrivate	Is delivery address private	Enum NoYes	LogisticsPostalAddressBaseEntity.IsPrivate
DeliveryAddressLatitude	Latitude	Real (LogisticsAddressLatitude)	LogisticsPostalAddressBaseEntity.Latitude
DeliveryAddressLocationId	Location ID	String (LogisticsLocationId)	LogisticsPostalAddressBaseEntity.LocationId	Yes
DeliveryAddressLongitude	Longitude	Real (LogisticsAddressLongitude)	LogisticsPostalAddressBaseEntity.Longitude
DeliveryAddressPostBox	Post box	String (LogisticsAddressPostBox)	LogisticsPostalAddressBaseEntity.PostBox
DeliveryAddressStateId	State	String (LogisticsAddressStateId)	LogisticsPostalAddressBaseEntity.State
DeliveryAddressStreet	Street	String (LogisticsAddressStreet)	LogisticsPostalAddressBaseEntity.Street
DeliveryAddressStreetNumber	Street number	String (LogisticsAddressStreetNumber)	LogisticsPostalAddressBaseEntity.StreetNumber
DeliveryAddressTimeZone	Time zone	Enum Timezone	LogisticsPostalAddressBaseEntity.TimeZone
DeliveryAddressZipCode	ZIP/postal code	String (LogisticsAddressZipCodeId)	LogisticsPostalAddressBaseEntity.ZipCode
DeliveryAddressCityInKana	City in Kana	String (AssetCityKana_JP)	LogisticsPostalAddressBaseEntity.CityInKana
DeliveryAddressStreetInKana	Street in Kana	String (AssetStreetKana_JP)	LogisticsPostalAddressBaseEntity.StreetInKana
ValidTo	Expiration	UtcDateTime (ExpirationDateTime)	LogisticsPostalAddressBaseEntity.ValidTo
ValidFrom	Effective	UtcDateTime (EffectiveDateTime)	LogisticsPostalAddressBaseEntity.ValidFrom

MGCLatticeCustomerPackingSlipJournalLinesEntity

Customer Packing Slip Journal Lines

Property	Value
OData entity set	LatticeCustomerPackingSlipJournalLines (single: LatticeCustomerPackingSlipJournalLine)
Access	Read-only
Data management	Enabled (staging table MGCLatticeCustomerPackingSlipJournalLinesStaging)
Company	Company-specific (DataAreaId)
Key	SalesOrderNumber, DeliveryDate, PackingSlipId, LineNumber, InventoryLotId
Data sources	DimensionSetEntity, LogisticsPostalAddressBaseEntity, CustPackingSlipTrans, InventDim
Configuration key	LedgerBasic
Granted by	MGCLatticeCustomerPackingSlipJournalLinesEntityMaintain (read); MGCLatticeCustomerPackingSlipJournalLinesEntityView (read)

Field	Label	Type	Source	Mandatory
Amount	Amount in transaction currency	Real (AmountCur)	CustPackingSlipTrans.AmountCur
CountryRegionOfShipment	Country/region of shipment	String (AddressCountryRegionId)	CustPackingSlipTrans.CountryRegionOfShipment
CurrencyCode	Currency	String (CurrencyCode)	CustPackingSlipTrans.CurrencyCode
DeliveryDate (key)	Ship date	Date (SalesShippingDate)	CustPackingSlipTrans.DeliveryDate	Yes
DeliveryType	Delivery type	Enum TradeLineDlvType	CustPackingSlipTrans.DeliveryType
DeliveryTermsId	Delivery terms	String (SalesDlvTermId)	CustPackingSlipTrans.DlvTerm
ExternalItemId	External	String (SalesExternalItemId)	CustPackingSlipTrans.ExternalItemId
FullyMatched	Fully matched	Enum NoYes	CustPackingSlipTrans.FullyMatched
IntercompanyInventoryLotId	Lot ID	String (InventTransIdBase)	CustPackingSlipTrans.InterCompanyInventTransId
IntrastatDispatchId	Shipment batch	String (IntrastatDispatchId)	CustPackingSlipTrans.IntrastatDispatchId
InventoryQuantity	Quantity	Real (InventQty)	CustPackingSlipTrans.inventQty
InventoryRefId	Reference number	String (InventRefId)	CustPackingSlipTrans.InventRefId
InventoryRefTransId	Reference lot	String (InventRefTransId)	CustPackingSlipTrans.InventRefTransId
InventoryRefType	Reference type	Enum InventRefType	CustPackingSlipTrans.InventRefType
InventoryLotId (key)	Lot ID	String (TradeInventTransId)	CustPackingSlipTrans.InventTransId
ItemNumber	Item	String (ItemId)	CustPackingSlipTrans.ItemId
LineHeader	Line heading	String (LineHeader)	CustPackingSlipTrans.LineHeader
LineNumber (key)	Line number	Real (LineNum)	CustPackingSlipTrans.LineNum
ItemName	Description	String (ItemFreeTxt)	CustPackingSlipTrans.Name
OrderedQuantity	Ordered	Real (SalesQty)	CustPackingSlipTrans.Ordered
OriginalCountryRegionId	Country/region	String (ItemOrigCountryRegionId)	CustPackingSlipTrans.OrigCountryRegionId
OriginalSalesOrderNumber	Sales order	String (SalesIdOrig)	CustPackingSlipTrans.OrigSalesId
OriginalStateId	State/province	String (ItemOrigStateId)	CustPackingSlipTrans.OrigStateId
PackingSlipId (key)	Packing slip	String (PackingSlipId)	CustPackingSlipTrans.PackingSlipId	Yes
Quantity	Delivered	Real (SalesQty)	CustPackingSlipTrans.Qty
RemainingQuantity	Remaining quantity	Real (SalesQty)	CustPackingSlipTrans.Remain
RemainingInventoryQuantity	Quantity	Real (InventQty)	CustPackingSlipTrans.RemainInvent
SalesGroup	Sales group	String (CommissSalesGroup)	CustPackingSlipTrans.SalesGroup
SalesOrderNumber (key)	Sales order	String (SalesId)	CustPackingSlipTrans.SalesId
SalesLineShippingDateConfirmed	Confirmed ship date	Date (SalesShippingDateConfirmed)	CustPackingSlipTrans.SalesLineShippingDateConfirmed
SalesLineShippingDateRequested	Requested ship date	Date (SalesShippingDateRequested)	CustPackingSlipTrans.SalesLineShippingDateRequested
SalesUnitSymbol	Unit	String (SalesUnit)	CustPackingSlipTrans.SalesUnit
Scrap	Scrap	Enum NoYes	CustPackingSlipTrans.Scrap
IntrastatProcId	Statistics procedure	String (IntrastatProcId)	CustPackingSlipTrans.StatProcId
IntrastatValueMST	Statistics amount	Real (IntrastatLineAmountMST)	CustPackingSlipTrans.StatValueMST
StockedProduct	Stocked	Enum NoYes	CustPackingSlipTrans.StockedProduct
IntrastatTransactionCode	Trade	String (IntrastatTransactionCodeId)	CustPackingSlipTrans.TransactionCode
IntrastatTransport	Transport	String (IntrastatTransport)	CustPackingSlipTrans.Transport
ValueMST	Value	Real (AmountMST)	CustPackingSlipTrans.ValueMST
Weight	Weight	Real (Weight)	CustPackingSlipTrans.Weight
DefaultDimensionDisplayValue	Default dimension display value	String (DimensionDisplayValue)	DimensionSetEntity.DisplayValue
DeliveryAddressCountryRegionId	Country/region	String (LogisticsAddressCountryRegionId)	LogisticsPostalAddressBaseEntity.CountryRegionId	Yes
DeliveryAddressStreetNumber	Street number	String (LogisticsAddressStreetNumber)	LogisticsPostalAddressBaseEntity.StreetNumber
DeliveryAddressZipCode	ZIP/postal code	String (LogisticsAddressZipCodeId)	LogisticsPostalAddressBaseEntity.ZipCode
DeliveryAddressCityInKana	City in Kana	String (AssetCityKana_JP)	LogisticsPostalAddressBaseEntity.CityInKana
DeliveryAddressLongitude	Longitude	Real (LogisticsAddressLongitude)	LogisticsPostalAddressBaseEntity.Longitude
DeliveryAddressDescription	Name or description	String (LogisticsDescription)	LogisticsPostalAddressBaseEntity.Description
DeliveryAddressDunsNumber	DUNS number	String (LogisticsDunsNumber)	LogisticsPostalAddressBaseEntity.DunsNumber
DeliveryAddressLocationId	Location ID	String (LogisticsLocationId)	LogisticsPostalAddressBaseEntity.LocationId	Yes
DeliveryAddressStateId	State	String (LogisticsAddressStateId)	LogisticsPostalAddressBaseEntity.State
DeliveryAddressLatitude	Latitude	Real (LogisticsAddressLatitude)	LogisticsPostalAddressBaseEntity.Latitude
DeliveryAddressCountryRegionISOCode	Country/region ISO	String (LogisticsAddressCountryRegionISOCode)	LogisticsPostalAddressBaseEntity.CountryRegionISOCode
DeliveryAddressStreet	Street	String (LogisticsAddressStreet)	LogisticsPostalAddressBaseEntity.Street
DeliveryAddressTimeZone	Time zone	Enum Timezone	LogisticsPostalAddressBaseEntity.TimeZone
DeliveryAddressCountyId	County	String (LogisticsAddressCountyId)	LogisticsPostalAddressBaseEntity.County
DeliveryAddressPostBox	Post box	String (LogisticsAddressPostBox)	LogisticsPostalAddressBaseEntity.PostBox
IsDeliveryAddressPrivate	Is delivery address private	Enum NoYes	LogisticsPostalAddressBaseEntity.IsPrivate
DeliveryAddressCity	City	String (LogisticsAddressCityName)	LogisticsPostalAddressBaseEntity.City
DeliveryAddressStreetInKana	Street in Kana	String (AssetStreetKana_JP)	LogisticsPostalAddressBaseEntity.StreetInKana
DeliveryAddressDistrictName	District	String (LogisticsAddressDistrictName)	LogisticsPostalAddressBaseEntity.DistrictName
ValidTo	Expiration	UtcDateTime (ExpirationDateTime)	LogisticsPostalAddressBaseEntity.ValidTo
ValidFrom	Effective	UtcDateTime (EffectiveDateTime)	LogisticsPostalAddressBaseEntity.ValidFrom
ItemBatchNumber	Batch number	String (InventBatchId)	InventDim.inventBatchId
ItemSerialNumber	Serial number	String (InventSerialId)	InventDim.inventSerialId
OrderedInventoryStatusId	Inventory status	String (WHSInventStatusId)	InventDim.InventStatusId
ProductColorId	Color	String (EcoResItemColorName)	InventDim.InventColorId
ProductConfigurationId	Configuration	String (EcoResItemConfigurationName)	InventDim.configId
ProductSizeId	Size	String (EcoResItemSizeName)	InventDim.InventSizeId
ProductStyleId	Style	String (EcoResItemStyleName)	InventDim.InventStyleId
ProductVersionId	Version	String (EcoResItemVersionName)	InventDim.InventVersionId
ShippingSiteId	Site	String (InventSiteId)	InventDim.InventSiteId
ShippingWarehouseId	Warehouse	String (InventLocationId)	InventDim.InventLocationId
ShippingWarehouseLocationId	Location	String (WMSLocationId)	InventDim.wMSLocationId

MGCLatticeSetBasedCustomerPaymentJournalLineEntity

Customer payment journal lines (set-based)

Imports customer payment journal lines in bulk with set-based processing: one new journal per journal key, or lines added to an open journal.

Property	Value
OData entity set	Not exposed over OData
Access	Read/write
Data management	Enabled (staging table MGCLatticeSetBasedCustomerPaymentJournalLineStaging)
Company	Company-specific (DataAreaId)
Key	JournalNumber, LineNumber
Data sources	LedgerJournalTable, LedgerJournalTrans
Configuration key	LedgerBasic
Granted by	MGCLatticeSetBasedCustomerPaymentJournalLineEntityMaintain (full CRUD); MGCLatticeSetBasedCustomerPaymentJournalLineEntityView (read)

Field	Label	Type	Source	Mandatory
JournalNumber (key)	Journal batch number	String (LedgerJournalId)	LedgerJournalTable.JournalNum	Yes
JournalNameId	Name	String (LedgerJournalNameId)	LedgerJournalTable.JournalName	Yes
LineNumber (key)	Line number	Real (LineNum)	LedgerJournalTrans.LineNum	Yes
TransactionDate	Date	Date (TransDate)	LedgerJournalTrans.TransDate
Voucher	Voucher	String (Voucher)	LedgerJournalTrans.Voucher
CustomerAccount	Customer account	String (CustAccount)	Unmapped (virtual)	Yes
Description	Description	String (LedgerJournalTransTxt)	LedgerJournalTrans.Txt
CurrencyCode	Currency	String (CurrencyCode)	LedgerJournalTrans.CurrencyCode	Yes
ExchangeRate	Exchange rate	Real (ExchRate)	LedgerJournalTrans.ExchRate
DebitAmount	Debit	Real (AmountCurDebit)	LedgerJournalTrans.AmountCurDebit
CreditAmount	Credit	Real (AmountCurCredit)	LedgerJournalTrans.AmountCurCredit
MethodOfPayment	Method of payment	String (PaymMode)	LedgerJournalTrans.PaymMode
BankTransactionType	Bank transaction type	String (BankTransactionType)	LedgerJournalTrans.BankTransType
PaymentReference	Payment reference	String (PaymReference)	LedgerJournalTrans.PaymReference
InvoiceId	Invoice	String (InvoiceId)	LedgerJournalTrans.Invoice
PostingProfile	Posting profile	String (PostingProfile)	LedgerJournalTrans.PostingProfile
OffsetAccountType	Offset account type	Enum LedgerJournalACType	LedgerJournalTrans.OffsetAccountType
OffsetAccountDisplayValue	Offset account	String (DimensionDisplayValue)	Unmapped (virtual)
DefaultDimensionDisplayValue	Financial dimensions	String (DimensionDisplayValue)	Unmapped (virtual)
OffsetDefaultDimensionDisplayValue	Offset financial dimensions	String (DimensionDisplayValue)	Unmapped (virtual)

MGCLatticeSetBasedDemandForecastLineEntity

Demand forecast lines (set-based)

Imports demand forecast lines (item forecasts of the sales forecast) in bulk with set-based processing. A row naming an existing forecast entry updates it; other rows become new lines numbered from the demand forecast number sequence, each with its inventory forecast.

Property	Value
OData entity set	Not exposed over OData
Access	Read/write
Data management	Enabled (staging table MGCLatticeSetBasedDemandForecastLineStaging)
Company	Company-specific (DataAreaId)
Key	ForecastEntryNumber
Data sources	InventDim, ForecastSales
Configuration key	Forecast
Granted by	MGCLatticeSetBasedDemandForecastLineEntityMaintain (full CRUD); MGCLatticeSetBasedDemandForecastLineEntityView (read)

Field	Label	Type	Source	Mandatory
ForecastEntryNumber (key)	Demand forecast sequence number	String (ForecastDemandForecastNumSeq)	ForecastSales.ForecastEntryNumber	Yes
ForecastModelId	Model	String (ForecastModelHeadId)	ForecastSales.ModelId	Yes
ItemNumber	Item number	String (ItemId)	ForecastSales.ItemId	Yes
ForecastStartDate	Date	Date (StartDate)	ForecastSales.StartDate	Yes
ForecastEndDate	End	Date (EndDate)	ForecastSales.EndDate
ForecastedQuantity	Sales quantity	Real (SalesQty)	ForecastSales.SalesQty
QuantityUnitSymbol	Unit	String (UnitOfMeasureSymbol)	ForecastSales.SalesUnitId
ForecastedUnitPrice	Unit price	Real (SalesPrice)	ForecastSales.SalesPrice
ForecastedRevenue	Amount	Real (AmountCur)	ForecastSales.Amount
PricingCurrencyCode	Currency	String (CurrencyCode)	ForecastSales.Currency	Yes
CustomerAccountNumber	Customer account	String (CustAccount)	ForecastSales.CustAccountId
CustomerGroupId	Customer group	String (CustGroupId)	ForecastSales.CustGroupId
ProductAllocationKeyId	Item allocation key	String (ForecastItemAllocationId)	ForecastSales.ItemAllocateId
ForecastAllocationMethod	Method	Enum BudgetAllocateMethod	ForecastSales.AllocateMethod
PeriodAllocationKeyId	Period key	String (LedgerAllocateKeyId)	ForecastSales.KeyId
AllocationPeriods	Per	Int (Periods)	ForecastSales.Freq
AllocationPeriodUnit	Unit	Enum PeriodUnit	ForecastSales.FreqCode
DeliveringSiteId	Site	String (InventSiteId)	InventDim.InventSiteId
DeliveringWarehouseId	Warehouse	String (InventLocationId)	InventDim.InventLocationId
InventoryStatusId	Inventory status	String (WHSInventStatusId)	InventDim.InventStatusId
ProductConfigurationId	Configuration	String (EcoResItemConfigurationName)	InventDim.configId
ProductColorId	Color	String (EcoResItemColorName)	InventDim.InventColorId
ProductSizeId	Size	String (EcoResItemSizeName)	InventDim.InventSizeId
ProductStyleId	Style	String (EcoResItemStyleName)	InventDim.InventStyleId
ProductVersionId	Version	String (EcoResItemVersionName)	InventDim.InventVersionId
Inactive	Inactive	Enum NoYes	Unmapped (virtual)
DefaultDimensionDisplayValue	Financial dimensions	String (DimensionDisplayValue)	Unmapped (virtual)

MGCLatticeFreeTextInvoiceCrossReferenceEntity

Free text invoice cross references

Property	Value
OData entity set	LatticeFreeTextInvoiceCrossReferences (single: LatticeFreeTextInvoiceCrossReference)
Access	Read/write
Data management	Enabled (staging table MGCLatticeFreeTextInvoiceCrossReferenceStaging)
Company	Company-specific (DataAreaId)
Key	InvoiceIdentifier, ExternalSystem
Data sources	CustInvoiceTable, MGCLatticeCrossReference
Granted by	MGCLatticeCrossReferenceAccountsReceivableMaintain (full CRUD); MGCLatticeCrossReferenceAccountsReceivableView (read)

Field	Label	Type	Source	Mandatory
InvoiceIdentifier (key)	Record ID	Int64 (RecId)	CustInvoiceTable.RecId	Yes
ExternalSystem (key)	External system	String (MGCLatticeExternalSystemId)	MGCLatticeCrossReference.ExternalSystemId	Yes
ExternalKey	External key	String (MGCLatticeExternalKey)	MGCLatticeCrossReference.ExternalKey	Yes

MGCLatticeFreeTextInvoiceDocumentAttachmentEntity

Free Text Invoice Document Attachments

Property	Value
OData entity set	LatticeFreeTextInvoiceDocumentAttachments (single: LatticeFreeTextInvoiceDocumentAttachment)
Access	Read/write
Data management	Enabled (staging table MGCLatticeFreeTextInvoiceDocumentAttachmentStaging)
Company	Company-specific (ActualCompanyId)
Key	DocumentId
Data sources	CustInvoiceTable, DocuRefEntity
Configuration key	LedgerBasic
Granted by	MGCLatticeFreeTextInvDocAttachmentEntityMaintain (full CRUD); MGCLatticeFreeTextInvDocAttachmentEntityView (read)

Field	Label	Type	Source	Mandatory
DocumentId (key)	Document ID	Guid (DocuDocumentId)	DocuRefEntity.DocumentId
ActualCompanyId	Company accounts	String (SelectableDataArea)	DocuRefEntity.ActualCompanyId
DocumentAttachmentTypeCode	Type	String (DocuTypeId)	DocuRefEntity.TypeId	Yes
AttachmentDescription	Description	String (Description)	DocuRefEntity.Name
Notes	Note	String (Notes)	DocuRefEntity.Notes
AccessRestriction	Restriction	Enum DocuRestriction	DocuRefEntity.Restriction
Attachment	Archive file	Container (BitMap)	DocuRefEntity.FileContents
FileName	File name	String (Filename)	DocuRefEntity.FileName
FileType	File type	String (FilenameType)	DocuRefEntity.FileType
IsDefaultAttachment	Is default attachment	Enum NoYes	DocuRefEntity.DefaultAttachment
InvoiceId	Invoice	String (CustInvoiceId)	CustInvoiceTable.InvoiceId
CustomerAccount	Invoice account	String (CustInvoiceAccount)	CustInvoiceTable.InvoiceAccount	Yes
ExternalSystem	External system	String (MGCLatticeExternalSystemId)	Unmapped (virtual)
InvoiceIdExternalKey	Free text invoice external key	String (MGCLatticeExternalKey)	Unmapped (virtual)

MGCLatticeFreeTextInvoiceLineCrossReferenceEntity

Free text invoice line cross references

Property	Value
OData entity set	LatticeFreeTextInvoiceLineCrossReferences (single: LatticeFreeTextInvoiceLineCrossReference)
Access	Read/write
Data management	Enabled (staging table MGCLatticeFreeTextInvoiceLineCrossReferenceStaging)
Company	Company-specific (DataAreaId)
Key	InvoiceIdentifier, LineNumber, ExternalSystem
Data sources	CustInvoiceLine, MGCLatticeCrossReference
Granted by	MGCLatticeCrossReferenceAccountsReceivableMaintain (full CRUD); MGCLatticeCrossReferenceAccountsReceivableView (read)

Field	Label	Type	Source	Mandatory
InvoiceIdentifier (key)	Reference	Int64 (CustInvoiceTableRefRecId)	CustInvoiceLine.ParentRecId	Yes
LineNumber (key)	Line number	Real (LineNum)	CustInvoiceLine.LineNum	Yes
ExternalSystem (key)	External system	String (MGCLatticeExternalSystemId)	MGCLatticeCrossReference.ExternalSystemId	Yes
ExternalKey	External key	String (MGCLatticeExternalKey)	MGCLatticeCrossReference.ExternalKey	Yes

MGCLatticeIntercompanyOrderLineEntity

Intercompany order line

Property	Value
OData entity set	LatticeIntercompanyOrderLines (single: LatticeIntercompanyOrderLine)
Access	Read-only
Data management	Not enabled
Company	Company-specific (DataAreaId)
Key	InventoryLotId
Data sources	SalesLine, SalesTable
Configuration key	LedgerBasic
Granted by	MGCLatticeIntercompanyOrderLineEntityView (read)

Field	Label	Type	Source	Mandatory
SalesOrderNumber	Sales order	String (SalesIdBase)	SalesLine.SalesId
LineNumber	Line number	Real (LineNum)	SalesLine.LineNum
InventoryLotId (key)	Lot ID	String (TradeInventTransId)	SalesLine.InventTransId
ItemNumber	Item number	String (ItemIdSmall)	SalesLine.ItemId
LineDescription	Text	String (ItemFreeTxt)	SalesLine.Name
OrderedSalesQuantity	Quantity	Real (SalesOrderedQty)	SalesLine.SalesQty
SalesUnitSymbol	Unit	String (SalesUnit)	SalesLine.SalesUnit
SalesPrice	Unit price	Real (SalesPrice)	SalesLine.SalesPrice
LineAmount	Net amount	Real (SalesLineAmount)	SalesLine.LineAmount
RemainingSalesPhysicalQuantity	Deliver remainder	Real (SalesQty)	SalesLine.RemainSalesPhysical
CustomerAccount	Customer account	String (CustAccount)	SalesTable.CustAccount	Yes
IntercompanyLegalEntityId	Company	String (InterCompanyCompanyId)	SalesTable.InterCompanyCompanyId
IntercompanyPurchaseOrderNumber	Purchase order	String (InterCompanyPurchId)	SalesTable.InterCompanyPurchId

MGCLatticeIntercompanyPurchaseOrderLineEntity

Intercompany purchase order line

Property	Value
OData entity set	LatticeIntercompanyPurchaseOrderLines (single: LatticeIntercompanyPurchaseOrderLine)
Access	Read-only
Data management	Not enabled
Company	Company-specific (DataAreaId)
Key	PurchaseOrderNumber, LineNumber
Data sources	PurchTable, PurchLine
Configuration key	LedgerBasic
Granted by	MGCLatticeIntercompanyOrderLineEntityView (read)

Field	Label	Type	Source	Mandatory
PurchaseOrderNumber (key)	Purchase order	String (PurchIdBase)	PurchLine.PurchId	Yes
LineNumber (key)	Line number	Int64 (TradeLineNumber)	PurchLine.LineNumber
InventoryLotId	Lot ID	String (TradeInventTransId)	PurchLine.InventTransId
ItemNumber	Item number	String (ItemIdSmall)	PurchLine.ItemId
LineDescription	Text	String (ItemFreeTxt)	PurchLine.Name
OrderedPurchaseQuantity	Quantity	Real (PurchOrderedQty)	PurchLine.PurchQty
PurchaseUnitSymbol	Unit	String (PurchUnit)	PurchLine.PurchUnit
PurchPrice	Unit price	Real (PurchPrice)	PurchLine.PurchPrice
LineAmount	Net amount	Real (PurchLineAmount)	PurchLine.LineAmount
RemainingPurchasePhysicalQuantity	Deliver remainder	Real (PurchQty)	PurchLine.RemainPurchPhysical
VendorAccountNumber	Vendor account	String (VendAccount)	PurchTable.OrderAccount	Yes
IntercompanyLegalEntityId	Company	String (InterCompanyCompanyId)	PurchTable.InterCompanyCompanyId
IntercompanySalesOrderNumber	Sales order	String (InterCompanySalesId)	PurchTable.InterCompanySalesId

MGCLatticeIntercompanyPurchaseOrderEntity

Intercompany Purchase Orders

Property	Value
OData entity set	LatticeIntercompanyPurchaseOrders (single: LatticeIntercompanyPurchaseOrder)
Access	Read-only
Data management	Enabled (staging table MGCLatticeIntercompanyPurchaseOrderStaging)
Company	Company-specific (DataAreaId)
Key	PurchaseOrderNumber
Data sources	PurchTable
Configuration key	LedgerBasic
Granted by	MGCLatticeIntercompanyPurchaseOrderEntityMaintain (read); MGCLatticeIntercompanyPurchaseOrderEntityView (read)

Field	Label	Type	Source	Mandatory
PurchaseOrderNumber (key)	Purchase order	String (PurchIdBase)	PurchTable.PurchId	Yes
VendorAccountNumber	Vendor account	String (VendAccount)	PurchTable.OrderAccount	Yes
InvoiceAccount	Invoice account	String (VendInvoiceAccount)	PurchTable.InvoiceAccount	Yes
PurchaseOrderStatus	Purchase order status	Enum PurchStatus	PurchTable.PurchStatus
CurrencyCode	Currency	String (VendCurrencyCode)	PurchTable.CurrencyCode	Yes
IntercompanyOrder	Intercompany	Enum NoYes	PurchTable.InterCompanyOrder
IntercompanyLegalEntityId	Company	String (InterCompanyCompanyId)	PurchTable.InterCompanyCompanyId
IntercompanySalesOrderNumber	Sales order	String (InterCompanySalesId)	PurchTable.InterCompanySalesId
IntercompanyDirectDelivery	Intercompany direct delivery	Enum NoYes	PurchTable.InterCompanyDirectDelivery
CreatedDate	Created date and time	UtcDateTime	PurchTable.CreatedDateTime
DeliveryMode	Mode of delivery	String (VendDlvModeId)	PurchTable.DlvMode

MGCLatticeIntercompanyOrderEntity

Intercompany Sales Orders

Property	Value
OData entity set	LatticeIntercompanyOrders (single: LatticeIntercompanyOrder)
Access	Read-only
Data management	Enabled (staging table MGCLatticeIntercompanyOrderStaging)
Company	Company-specific (DataAreaId)
Key	SalesOrderNumber
Data sources	SalesTable
Configuration key	LedgerBasic
Granted by	MGCLatticeIntercompanyOrderEntityMaintain (read); MGCLatticeIntercompanyOrderEntityView (read)

Field	Label	Type	Source	Mandatory
SalesOrderNumber (key)	Sales order	String (SalesIdBase)	SalesTable.SalesId	Yes
CustomerAccount	Customer account	String (CustAccount)	SalesTable.CustAccount	Yes
InvoiceAccount	Invoice account	String (CustInvoiceAccount)	SalesTable.InvoiceAccount	Yes
SalesOrderStatus	Status	Enum SalesStatus	SalesTable.SalesStatus
CurrencyCode	Currency	String (CustCurrencyCode)	SalesTable.CurrencyCode	Yes
IntercompanyOrder	Intercompany	Enum NoYes	SalesTable.InterCompanyOrder
IntercompanyLegalEntityId	Company	String (InterCompanyCompanyId)	SalesTable.InterCompanyCompanyId
IntercompanyPurchaseOrderNumber	Purchase order	String (InterCompanyPurchId)	SalesTable.InterCompanyPurchId
IntercompanyOriginalSalesOrderNumber	Original sales order	String (InterCompanyOriginalSalesId)	SalesTable.InterCompanyOriginalSalesId
IntercompanyDirectDelivery	Direct delivery	Enum NoYes	SalesTable.InterCompanyDirectDelivery
CreatedDate	Created date and time	UtcDateTime	SalesTable.CreatedDateTime
DeliveryMode	Mode of delivery	String (CustDlvModeId)	SalesTable.DlvMode

MGCLatticeSetBasedInventoryJournalLineEntity

Inventory journal lines (set-based)

Imports inventory journal lines of the movement, adjustment, transfer, counting, project and ownership change journal types in bulk with set-based processing.

Property	Value
OData entity set	Not exposed over OData
Access	Read/write
Data management	Enabled (staging table MGCLatticeSetBasedInventoryJournalLineStaging)
Company	Company-specific (DataAreaId)
Key	JournalNumber, LineNumber
Data sources	InventJournalTrans, InventDim, InventJournalTable
Configuration key	LogisticsBasic
Granted by	MGCLatticeSetBasedInventoryJournalLineEntityMaintain (full CRUD); MGCLatticeSetBasedInventoryJournalLineEntityView (read)

Field	Label	Type	Source	Mandatory
JournalNumber (key)	Journal	String (InventJournalId)	InventJournalTable.JournalId	Yes
JournalNameId	Name	String (InventJournalNameId)	InventJournalTable.JournalNameId	Yes
LineNumber (key)	Line number	Real (LineNum)	InventJournalTrans.LineNum	Yes
TransactionDate	Date	Date (JournalTransDate)	InventJournalTrans.TransDate	Yes
ItemNumber	Item number	String (ItemIdInventoried)	InventJournalTrans.ItemId	Yes
InventoryQuantity	Quantity	Real (InventQtyJournal)	InventJournalTrans.Qty
CountedQuantity	Counted	Real (InventQtyCounted)	InventJournalTrans.Counted
UnitCost	Cost price	Real (ItemCostPrice)	InventJournalTrans.CostPrice
UnitCostQuantity	Price quantity	Real (InventPriceUnitQty)	InventJournalTrans.PriceUnit
CostAmount	Cost amount	Real (CostAmount)	InventJournalTrans.CostAmount
FixedCostCharges	Charges on cost	Real (CostMarkup)	InventJournalTrans.CostMarkup
ProjectId	Project ID	String (ProjId)	InventJournalTrans.ProjId
ProjectCategoryId	Category	String (ProjCategoryId)	InventJournalTrans.ProjCategoryId
ProjectLinePropertyId	Line property	String (ProjLinePropertyId)	InventJournalTrans.ProjLinePropertyId
ProjectSalesPrice	Sales price	Real (ProjSalesPriceCost)	InventJournalTrans.ProjSalesPrice
ProjectSalesCurrencyCode	Sales currency	String (ProjSalesCurrencyCode)	InventJournalTrans.ProjSalesCurrencyId
InventorySiteId	Site	String (InventSiteId)	InventDim.InventSiteId
InventoryWarehouseId	Warehouse	String (InventLocationId)	InventDim.InventLocationId
WarehouseLocationId	Location	String (WMSLocationId)	InventDim.wMSLocationId
ItemBatchNumber	Batch number	String (InventBatchId)	InventDim.inventBatchId
ItemSerialNumber	Serial number	String (InventSerialId)	InventDim.inventSerialId
InventoryStatusId	Inventory status	String (WHSInventStatusId)	InventDim.InventStatusId
LicensePlateNumber	License plate	String (WHSLicensePlateId)	InventDim.LicensePlateId
ProductConfigurationId	Configuration	String (EcoResItemConfigurationName)	InventDim.configId
ProductSizeId	Size	String (EcoResItemSizeName)	InventDim.InventSizeId
ProductColorId	Color	String (EcoResItemColorName)	InventDim.InventColorId
ProductStyleId	Style	String (EcoResItemStyleName)	InventDim.InventStyleId
ProductVersionId	Version	String (EcoResItemVersionName)	InventDim.InventVersionId
InventoryOwnerId	Owner	String (InventOwnerId)	InventDim.InventOwnerId_RU
ToInventorySiteId	Site	String (InventSiteId)	InventDim.InventSiteId
ToInventoryWarehouseId	Warehouse	String (InventLocationId)	InventDim.InventLocationId
ToWarehouseLocationId	Location	String (WMSLocationId)	InventDim.wMSLocationId
ToItemBatchNumber	Batch number	String (InventBatchId)	InventDim.inventBatchId
ToItemSerialNumber	Serial number	String (InventSerialId)	InventDim.inventSerialId
ToInventoryStatusId	Inventory status	String (WHSInventStatusId)	InventDim.InventStatusId
ToLicensePlateNumber	License plate	String (WHSLicensePlateId)	InventDim.LicensePlateId
ToInventoryOwnerId	Owner	String (InventOwnerId)	InventDim.InventOwnerId_RU
OffsetMainAccountId	Offset main account	String (MainAccountNum)	Unmapped (virtual)
DefaultDimensionDisplayValue	Financial dimensions	String (DimensionDisplayValue)	Unmapped (virtual)

MGCLatticeLedgerJournalCrossReferenceEntity

Journal cross references

Property	Value
OData entity set	LatticeLedgerJournalCrossReferences (single: LatticeLedgerJournalCrossReference)
Access	Read/write
Data management	Enabled (staging table MGCLatticeLedgerJournalCrossReferenceStaging)
Company	Company-specific (DataAreaId)
Key	JournalBatchNumber, ExternalSystem
Data sources	LedgerJournalTable, MGCLatticeCrossReference
Granted by	MGCLatticeCrossReferenceGeneralLedgerMaintain (full CRUD); MGCLatticeCrossReferenceGeneralLedgerView (read)

Field	Label	Type	Source	Mandatory
JournalBatchNumber (key)	Journal batch number	String (LedgerJournalId)	LedgerJournalTable.JournalNum	Yes
ExternalSystem (key)	External system	String (MGCLatticeExternalSystemId)	MGCLatticeCrossReference.ExternalSystemId	Yes
ExternalKey	External key	String (MGCLatticeExternalKey)	MGCLatticeCrossReference.ExternalKey	Yes

MGCLatticeLedgerJournalLineCrossReferenceEntity

Journal line cross references

Property	Value
OData entity set	LatticeLedgerJournalLineCrossReferences (single: LatticeLedgerJournalLineCrossReference)
Access	Read/write
Data management	Enabled (staging table MGCLatticeLedgerJournalLineCrossReferenceStaging)
Company	Company-specific (DataAreaId)
Key	JournalBatchNumber, LineNumber, ExternalSystem
Data sources	LedgerJournalTrans, MGCLatticeCrossReference
Granted by	MGCLatticeCrossReferenceGeneralLedgerMaintain (full CRUD); MGCLatticeCrossReferenceGeneralLedgerView (read)

Field	Label	Type	Source	Mandatory
JournalBatchNumber (key)	Journal batch number	String (LedgerJournalId)	LedgerJournalTrans.JournalNum	Yes
LineNumber (key)	Line number	Real (LineNum)	LedgerJournalTrans.LineNum	Yes
ExternalSystem (key)	External system	String (MGCLatticeExternalSystemId)	MGCLatticeCrossReference.ExternalSystemId	Yes
ExternalKey	External key	String (MGCLatticeExternalKey)	MGCLatticeCrossReference.ExternalKey	Yes

MGCLatticeDocuRefEntity

Lattice document attachments

Property	Value
OData entity set	Not exposed over OData
Access	Read/write
Data management	Not enabled
Company	Company-specific (ActualCompanyId)
Key	DocumentId
Data sources	DocuValue, DocuRef
Configuration key	LedgerBasic
Granted by	MGCLatticeDocuRefEntityMaintain (full CRUD); MGCLatticeDocuRefEntityView (read)

Field	Label	Type	Source	Mandatory
DocumentId (key)	Document ID	Guid (DocuDocumentId)	DocuRef.DocumentId
ActualCompanyId	Company accounts	String (SelectableDataArea)	DocuRef.ActualCompanyId
TypeId	Type	String (DocuTypeId)	DocuRef.TypeId	Yes
RefCompanyId	Company account	String (SelectableDataArea)	DocuRef.RefCompanyId	Yes
RefRecId	Reference record ID	Int64 (RefRecId)	DocuRef.RefRecId	Yes
RefTableId	Reference table ID	Int (RefTableId)	DocuRef.RefTableId	Yes
Name	Description	String (Description)	DocuRef.Name
Restriction	Restriction	Enum DocuRestriction	DocuRef.Restriction
Notes	Note	String (Notes)	DocuRef.Notes
ValueRecId		Int64	Computed
DocuValueType	Document value type	Enum DocuValueType	DocuValue.Type
FileName	File name	String (Filename)	Computed
FileType	File type	String (FilenameType)	Computed
FileContents	File contents	Container (BitMap)	Computed
DefaultAttachment	Is default attachment	Enum NoYes	DocuRef.DefaultAttachment
StorageProviderId	Document Storage Provider Type	Enum DocuStorageProviderType	DocuValue.StorageProviderId

MGCLatticeProductionJournalHeaderEntity

Production Journal Header

Property	Value
OData entity set	LatticeProductionJournalHeaders (single: LatticeProductionJournalHeader)
Access	Read-only
Data management	Enabled (staging table MGCLatticeProductionJournalHeaderStaging)
Company	Company-specific (DataAreaId)
Key	ProductionJournalNumber
Data sources	ProdJournalTable
Granted by	MGCLatticeProductionJournalHeaderEntityMaintain (read); MGCLatticeProductionJournalHeaderEntityView (read)

Field	Label	Type	Source	Mandatory
ProductionJournalNumber (key)	Journal	String (ProdJournalId)	ProdJournalTable.JournalId	Yes
JournalNameId	Name	String (ProdJournalNameId)	ProdJournalTable.JournalNameId	Yes
JournalType	Journal type	Enum ProdJournalType	ProdJournalTable.JournalType
Description	Description	String (JournalDescription)	ProdJournalTable.Description
IsPosted	Posted	Enum NoYes	ProdJournalTable.Posted
PostedDateTime	Posted on	UtcDateTime (JournalPostedDateTime)	ProdJournalTable.PostedDateTime
PostedByUserId	Posted by	String (JournalPostedUserId)	ProdJournalTable.PostedUserId
NumberOfLines	Lines	Int (JournalNumOfLines)	ProdJournalTable.NumOfLines

MGCLatticeProductionOrderCrossReferenceEntity

Production order cross references

Property	Value
OData entity set	LatticeProductionOrderCrossReferences (single: LatticeProductionOrderCrossReference)
Access	Read/write
Data management	Enabled (staging table MGCLatticeProductionOrderCrossReferenceStaging)
Company	Company-specific (DataAreaId)
Key	ProductionOrderNumber, ExternalSystem
Data sources	ProdTable, MGCLatticeCrossReference
Granted by	MGCLatticeCrossReferenceProductionMaintain (full CRUD); MGCLatticeCrossReferenceProductionView (read)

Field	Label	Type	Source	Mandatory
ProductionOrderNumber (key)	Production	String (ProdId)	ProdTable.ProdId	Yes
ExternalSystem (key)	External system	String (MGCLatticeExternalSystemId)	MGCLatticeCrossReference.ExternalSystemId	Yes
ExternalKey	External key	String (MGCLatticeExternalKey)	MGCLatticeCrossReference.ExternalKey	Yes

MGCLatticeProductionOrderDocumentAttachmentEntity

Production Order Document Attachments

Property	Value
OData entity set	LatticeProductionOrderDocumentAttachments (single: LatticeProductionOrderDocumentAttachment)
Access	Read/write
Data management	Enabled (staging table MGCLatticeProductionOrderDocumentAttachmentStaging)
Company	Company-specific (ActualCompanyId)
Key	DocumentId
Data sources	ProdTable, DocuRefEntity
Configuration key	LedgerBasic
Granted by	MGCLatticeProdOrderDocAttachmentEntityMaintain (full CRUD); MGCLatticeProdOrderDocAttachmentEntityView (read)

Field	Label	Type	Source	Mandatory
DocumentId (key)	Document ID	Guid (DocuDocumentId)	DocuRefEntity.DocumentId
ActualCompanyId	Company accounts	String (SelectableDataArea)	DocuRefEntity.ActualCompanyId
DocumentAttachmentTypeCode	Type	String (DocuTypeId)	DocuRefEntity.TypeId	Yes
AttachmentDescription	Description	String (Description)	DocuRefEntity.Name
Notes	Note	String (Notes)	DocuRefEntity.Notes
AccessRestriction	Restriction	Enum DocuRestriction	DocuRefEntity.Restriction
Attachment	Archive file	Container (BitMap)	DocuRefEntity.FileContents
FileName	File name	String (Filename)	DocuRefEntity.FileName
FileType	File type	String (FilenameType)	DocuRefEntity.FileType
IsDefaultAttachment	Is default attachment	Enum NoYes	DocuRefEntity.DefaultAttachment
ProductionOrderNumber	Production	String (ProdId)	ProdTable.ProdId	Yes
ItemNumber	Item number	String (ItemIdProduction)	ProdTable.ItemId
ExternalSystem	External system	String (MGCLatticeExternalSystemId)	Unmapped (virtual)
ProductionOrderNumberExternalKey	Production order external key	String (MGCLatticeExternalKey)	Unmapped (virtual)

MGCLatticeSetBasedProductionPickingListLineEntity

Production picking list lines (set-based)

Imports production picking list journal lines (material consumption against the BOM lines of started production orders) in bulk with set-based processing.

Property	Value
OData entity set	Not exposed over OData
Access	Read/write
Data management	Enabled (staging table MGCLatticeSetBasedProductionPickingListLineStaging)
Company	Company-specific (DataAreaId)
Key	JournalNumber, LineNumber
Data sources	InventDim, ProdJournalBOM, ProdJournalTable
Configuration key	Prod
Granted by	MGCLatticeSetBasedProductionPickingListLineEntityMaintain (full CRUD); MGCLatticeSetBasedProductionPickingListLineEntityView (read)

Field	Label	Type	Source	Mandatory
JournalNumber (key)	Journal	String (ProdJournalId)	ProdJournalTable.JournalId	Yes
JournalNameId	Name	String (ProdJournalNameId)	ProdJournalTable.JournalNameId	Yes
ProductionOrderNumber	Production	String (ProdId)	ProdJournalBOM.ProdId	Yes
LineNumber (key)	Line number	Real (LineNum)	ProdJournalBOM.LineNum	Yes
TransactionDate	Date	Date (TransDate)	ProdJournalBOM.TransDate	Yes
InventoryLotId	Lot ID	String (InventTransIdBase)	ProdJournalBOM.InventTransId
BOMLineNumber	BOM line number	Real (LineNum)	Unmapped (virtual)
ItemNumber	Item number	String (ItemIdInventoried)	ProdJournalBOM.ItemId	Yes
ConsumptionBOMQuantity	Consumption	Real (UnitQty)	ProdJournalBOM.BOMConsump
ProposalBOMQuantity	Unit quantity	Real (UnitQty)	Unmapped (virtual)
BOMUnitSymbol	Unit	String (UnitOfMeasureSymbol)	ProdJournalBOM.BOMUnitId	Yes
IsConsumptionEnded	End	Enum NoYes	ProdJournalBOM.EndConsump
ErrorCause	Cause	Enum ProdErrorCause	ProdJournalBOM.ErrorCause
InventorySiteId	Site	String (InventSiteId)	InventDim.InventSiteId
InventoryWarehouseId	Warehouse	String (InventLocationId)	InventDim.InventLocationId
WarehouseLocationId	Location	String (WMSLocationId)	InventDim.wMSLocationId
ItemBatchNumber	Batch number	String (InventBatchId)	InventDim.inventBatchId
ItemSerialNumber	Serial number	String (InventSerialId)	InventDim.inventSerialId
InventoryStatusId	Inventory status	String (WHSInventStatusId)	InventDim.InventStatusId
LicensePlateNumber	License plate	String (WHSLicensePlateId)	InventDim.LicensePlateId
ProductConfigurationId	Configuration	String (EcoResItemConfigurationName)	InventDim.configId
ProductSizeId	Size	String (EcoResItemSizeName)	InventDim.InventSizeId
ProductColorId	Color	String (EcoResItemColorName)	InventDim.InventColorId
ProductStyleId	Style	String (EcoResItemStyleName)	InventDim.InventStyleId
ProductVersionId	Version	String (EcoResItemVersionName)	InventDim.InventVersionId

MGCLatticeSetBasedProductionReportAsFinishedLineEntity

Production report as finished lines (set-based)

Imports production report as finished journal lines (good and error quantities of started production orders) in bulk with set-based processing.

Property	Value
OData entity set	Not exposed over OData
Access	Read/write
Data management	Enabled (staging table MGCLatticeSetBasedProductionReportAsFinishedLineStagingV2)
Company	Company-specific (DataAreaId)
Key	JournalNumber, LineNumber
Data sources	InventDim, ProdJournalProd, ProdJournalTable
Configuration key	Prod
Granted by	MGCLatticeSetBasedProductionReportAsFinishedLineEntityMaintain (full CRUD); MGCLatticeSetBasedProductionReportAsFinishedLineEntityView (read)

Field	Label	Type	Source	Mandatory
JournalNumber (key)	Journal	String (ProdJournalId)	ProdJournalTable.JournalId	Yes
JournalNameId	Name	String (ProdJournalNameId)	ProdJournalTable.JournalNameId	Yes
ProductionOrderNumber	Production	String (ProdId)	ProdJournalProd.ProdId	Yes
LineNumber (key)	Line number	Real (LineNum)	ProdJournalProd.LineNum	Yes
TransactionDate	Date	Date (JournalTransDate)	ProdJournalProd.TransDate	Yes
ItemNumber	Item number	String (ItemId)	ProdJournalProd.ItemId
GoodQuantity	Good quantity	Real (ProdReportedGood)	ProdJournalProd.QtyGood
ErrorQuantity	Error quantity	Real (ProdReportedError)	ProdJournalProd.QtyError
ErrorCause	Error cause	Enum ProdErrorCause	ProdJournalProd.ErrorCause
IsLastReportAsFinished	Report as finished	Enum NoYes	ProdJournalProd.ProdFinished
AcceptError	Accept error	Enum NoYes	ProdJournalProd.PmfAcceptError
PostPickingList	Post picking list	String (Name)	Unmapped (virtual)
InventorySiteId	Site	String (InventSiteId)	InventDim.InventSiteId
InventoryWarehouseId	Warehouse	String (InventLocationId)	InventDim.InventLocationId
WarehouseLocationId	Location	String (WMSLocationId)	InventDim.wMSLocationId
ItemBatchNumber	Batch number	String (InventBatchId)	InventDim.inventBatchId
ItemSerialNumber	Serial number	String (InventSerialId)	InventDim.inventSerialId
InventoryStatusId	Inventory status	String (WHSInventStatusId)	InventDim.InventStatusId
LicensePlateNumber	License plate	String (WHSLicensePlateId)	InventDim.LicensePlateId
ProductConfigurationId	Configuration	String (EcoResItemConfigurationName)	InventDim.configId
ProductSizeId	Size	String (EcoResItemSizeName)	InventDim.InventSizeId
ProductColorId	Color	String (EcoResItemColorName)	InventDim.InventColorId
ProductStyleId	Style	String (EcoResItemStyleName)	InventDim.InventStyleId
ProductVersionId	Version	String (EcoResItemVersionName)	InventDim.InventVersionId

MGCLatticeSetBasedProductionRouteCardLineEntity

Production route card lines (set-based)

Imports production route card and job card journal lines (hours and quantities reported on the operations and jobs of started production orders) in bulk with set-based processing.

Property	Value
OData entity set	Not exposed over OData
Access	Read/write
Data management	Enabled (staging table MGCLatticeSetBasedProductionRouteCardLineStaging)
Company	Company-specific (DataAreaId)
Key	JournalNumber, LineNumber
Data sources	ProdJournalRoute, ProdJournalTable
Configuration key	ProdRouting
Granted by	MGCLatticeSetBasedProductionRouteCardLineEntityMaintain (full CRUD); MGCLatticeSetBasedProductionRouteCardLineEntityView (read)

Field	Label	Type	Source	Mandatory
JournalNumber (key)	Journal	String (ProdJournalId)	ProdJournalTable.JournalId	Yes
JournalNameId	Name	String (ProdJournalNameId)	ProdJournalTable.JournalNameId	Yes
ProductionOrderNumber	Production	String (ProdId)	ProdJournalRoute.ProdId	Yes
LineNumber (key)	Line number	Real (LineNum)	ProdJournalRoute.LineNum	Yes
TransactionDate	Date	Date (JournalTransDate)	ProdJournalRoute.TransDate	Yes
OperationNumber	Oper. No.	Int (OprNum)	ProdJournalRoute.OprNum
OperationPriority	Priority	Enum RouteOprPriority	ProdJournalRoute.OprPriority
OperationId	Operation	String (RouteOprId)	ProdJournalRoute.OprId
JobId	Job identification	String (ProdJobId)	ProdJournalRoute.JobId
JobType	Task type	Enum RouteJobType	ProdJournalRoute.JobType
ResourceId	Resource	String (WrkCtrIdBase)	ProdJournalRoute.WrkCtrId
WorkerPersonnelNumber	Worker	String (HcmPersonnelNumberId)	Unmapped (virtual)
Hours	Hours	Real (ProdReportedHours)	ProdJournalRoute.Hours
GoodQuantity	Good quantity	Real (ProdReportedGood)	ProdJournalRoute.QtyGood
ErrorQuantity	Error quantity	Real (ProdReportedError)	ProdJournalRoute.QtyError
ErrorCause	Cause	Enum ProdErrorCause	ProdJournalRoute.ErrorCause
HourCostCategoryId	Category hours	String (RouteCostCategoryId)	ProdJournalRoute.CategoryHoursId
HourPrice	Hourly rate	Real (ProdHourPrice)	ProdJournalRoute.HourPrice
QuantityCostCategoryId	Category quantity	String (RouteCostCategoryId)	ProdJournalRoute.CategoryQtyId
QuantityPrice	Quantity price	Real (ProdQtyPrice)	ProdJournalRoute.QtyPrice
OperationFinished	Operation completed	Enum NoYes	ProdJournalRoute.OprFinished
JobFinished	Job is finished	Enum NoYes	ProdJournalRoute.JobFinished
ExecutedPercentage	Processing percentage	Real (ProdExecutedPct)	ProdJournalRoute.ExecutedPct

MGCLatticeProjectDocumentAttachmentEntity

Project Document Attachments

Property	Value
OData entity set	LatticeProjectDocumentAttachments (single: LatticeProjectDocumentAttachment)
Access	Read/write
Data management	Enabled (staging table MGCLatticeProjectDocumentAttachmentStaging)
Company	Company-specific (ActualCompanyId)
Key	DocumentId
Data sources	ProjTable, DocuRefEntity
Configuration key	LedgerBasic
Granted by	MGCLatticeProjectDocAttachmentEntityMaintain (full CRUD); MGCLatticeProjectDocAttachmentEntityView (read)

Field	Label	Type	Source	Mandatory
DocumentId (key)	Document ID	Guid (DocuDocumentId)	DocuRefEntity.DocumentId
ActualCompanyId	Company accounts	String (SelectableDataArea)	DocuRefEntity.ActualCompanyId
DocumentAttachmentTypeCode	Type	String (DocuTypeId)	DocuRefEntity.TypeId	Yes
AttachmentDescription	Description	String (Description)	DocuRefEntity.Name
Notes	Note	String (Notes)	DocuRefEntity.Notes
AccessRestriction	Restriction	Enum DocuRestriction	DocuRefEntity.Restriction
Attachment	Archive file	Container (BitMap)	DocuRefEntity.FileContents
FileName	File name	String (Filename)	DocuRefEntity.FileName
FileType	File type	String (FilenameType)	DocuRefEntity.FileType
IsDefaultAttachment	Is default attachment	Enum NoYes	DocuRefEntity.DefaultAttachment
ProjectId	Project ID	String (ProjId)	ProjTable.ProjId	Yes
ProjectName	Project name	String (ProjName)	ProjTable.Name
ExternalSystem	External system	String (MGCLatticeExternalSystemId)	Unmapped (virtual)
ProjectIdExternalKey	Project external key	String (MGCLatticeExternalKey)	Unmapped (virtual)

MGCLatticeSetBasedProjectExpenseJournalLineEntity

Project expense journal lines (set-based)

Imports project expense journal lines (ledger journals of type Cost) in bulk with set-based processing: one new journal per journal key, or lines added to an open journal.

Property	Value
OData entity set	Not exposed over OData
Access	Read/write
Data management	Enabled (staging table MGCLatticeSetBasedProjectExpenseJournalLineStaging)
Company	Company-specific (DataAreaId)
Key	JournalNumber, LineNumber
Data sources	LedgerJournalTable, LedgerJournalTrans, LedgerJournalTrans_Project
Configuration key	LedgerBasic
Granted by	MGCLatticeSetBasedProjectExpenseJournalLineEntityMaintain (full CRUD); MGCLatticeSetBasedProjectExpenseJournalLineEntityView (read)

Field	Label	Type	Source	Mandatory
JournalNumber (key)	Journal batch number	String (LedgerJournalId)	LedgerJournalTable.JournalNum	Yes
JournalNameId	Name	String (LedgerJournalNameId)	LedgerJournalTable.JournalName	Yes
LineNumber (key)	Line number	Real (LineNum)	LedgerJournalTrans.LineNum	Yes
TransactionDate	Date	Date (TransDate)	LedgerJournalTrans.TransDate
Voucher	Voucher	String (Voucher)	LedgerJournalTrans.Voucher
ProjectId	Project ID	String (ProjId)	Unmapped (virtual)	Yes
ProjectCategoryId	Category	String (ProjCategoryCostId)	LedgerJournalTrans_Project.CategoryId	Yes
ProjectLinePropertyId	Line property	String (ProjLinePropertyId)	LedgerJournalTrans_Project.LinePropertyId
ProjectDate	Project date	Date (ProjTransDate)	LedgerJournalTrans_Project.ProjTransDate	Yes
Quantity	Quantity	Real (Qty)	LedgerJournalTrans_Project.Qty
CostPrice	Cost price	Real (CostPrice)	LedgerJournalTrans_Project.CostPrice
SalesPrice	Sales price	Real (SalesPrice)	LedgerJournalTrans_Project.SalesPrice
SalesCurrencyCode	Sales currency	String (ProjSalesCurrencyCode)	LedgerJournalTrans_Project.SalesCurrencyId
Description	Description	String (LedgerJournalTransTxt)	LedgerJournalTrans.Txt
CurrencyCode	Currency	String (CurrencyCode)	LedgerJournalTrans.CurrencyCode	Yes
ExchangeRate	Exchange rate	Real (ExchRate)	LedgerJournalTrans.ExchRate
DebitAmount	Debit	Real (AmountCurDebit)	LedgerJournalTrans.AmountCurDebit
CreditAmount	Credit	Real (AmountCurCredit)	LedgerJournalTrans.AmountCurCredit
OffsetAccountType	Offset account type	Enum LedgerJournalACType	LedgerJournalTrans.OffsetAccountType
OffsetAccountDisplayValue	Offset account	String (DimensionDisplayValue)	Unmapped (virtual)
DefaultDimensionDisplayValue	Financial dimensions	String (DimensionDisplayValue)	Unmapped (virtual)
OffsetDefaultDimensionDisplayValue	Offset financial dimensions	String (DimensionDisplayValue)	Unmapped (virtual)

MGCLatticeSetBasedProjectJournalLineEntity

Project journal lines (set-based)

Imports project hour and fee journal lines in bulk with set-based processing.

Property	Value
OData entity set	Not exposed over OData
Access	Read/write
Data management	Enabled (staging table MGCLatticeSetBasedProjectJournalLineStaging)
Company	Company-specific (DataAreaId)
Key	JournalNumber, LineNumber
Data sources	ProjJournalTrans, ProjJournalTable
Configuration key	Project
Granted by	MGCLatticeSetBasedProjectJournalLineEntityMaintain (full CRUD); MGCLatticeSetBasedProjectJournalLineEntityView (read)

Field	Label	Type	Source	Mandatory
JournalNumber (key)	Journal	String (ProjJournalId)	ProjJournalTable.JournalId	Yes
JournalNameId	Name	String (ProjJournalNameId)	ProjJournalTable.JournalNameId	Yes
JournalDescription	Description	String (JournalDescription)	ProjJournalTable.Description
LineNumber (key)	Line number	Real (LineNum)	ProjJournalTrans.LineNum	Yes
ProjectDate	Project date	Date (ProjTransDate)	ProjJournalTrans.ProjTransDate	Yes
VoucherDate	Voucher date	Date (JournalTransDate)	ProjJournalTrans.TransDate
ProjectId	Project ID	String (ProjId)	ProjJournalTrans.ProjId	Yes
CategoryId	Category	String (ProjCategoryId)	ProjJournalTrans.CategoryId	Yes
LinePropertyId	Line property	String (ProjLinePropertyId)	ProjJournalTrans.LinePropertyId	Yes
WorkerPersonnelNumber	Worker	String (HcmPersonnelNumberId)	Unmapped (virtual)
Quantity	Hours	Real (ProjQtyEmpl)	ProjJournalTrans.Qty
CostPrice	Cost price	Real (ProjCostPriceCost)	ProjJournalTrans.CostPrice
SalesPrice	Sales price	Real (ProjSalesPriceCost)	ProjJournalTrans.SalesPrice
SalesCurrencyCode	Sales currency	String (ProjSalesCurrencyCode)	ProjJournalTrans.CurrencyId	Yes
ActivityNumber	Activity number	String (ProjActivityNumber)	ProjJournalTrans.ActivityNumber
Text	Description	String (Description255)	ProjJournalTrans.Txt
DefaultDimensionDisplayValue	Financial dimensions	String (DimensionDisplayValue)	Unmapped (virtual)

MGCLatticePurchaseAgreementCrossReferenceEntity

Purchase agreement cross references

Property	Value
OData entity set	LatticePurchaseAgreementCrossReferences (single: LatticePurchaseAgreementCrossReference)
Access	Read/write
Data management	Enabled (staging table MGCLatticePurchaseAgreementCrossReferenceStaging)
Company	Company-specific (DataAreaId)
Key	PurchaseAgreementId, ExternalSystem
Data sources	PurchAgreementHeader, MGCLatticeCrossReference
Granted by	MGCLatticeCrossReferenceProcurementMaintain (full CRUD); MGCLatticeCrossReferenceProcurementView (read)

Field	Label	Type	Source	Mandatory
PurchaseAgreementId (key)	Purchase agreement	String (PurchAgreementId)	PurchAgreementHeader.PurchNumberSequence	Yes
ExternalSystem (key)	External system	String (MGCLatticeExternalSystemId)	MGCLatticeCrossReference.ExternalSystemId	Yes
ExternalKey	External key	String (MGCLatticeExternalKey)	MGCLatticeCrossReference.ExternalKey	Yes

MGCLatticePurchaseAgreementLineCrossReferenceEntity

Purchase agreement line cross references

Property	Value
OData entity set	LatticePurchaseAgreementLineCrossReferences (single: LatticePurchaseAgreementLineCrossReference)
Access	Read/write
Data management	Enabled (staging table MGCLatticePurchaseAgreementLineCrossReferenceStaging)
Company	Company-specific (DataAreaId)
Key	PurchaseAgreementId, LineNumber, ExternalSystem
Data sources	MGCLatticeCrossReference, AgreementLine, PurchAgreementHeader
Granted by	MGCLatticeCrossReferenceProcurementMaintain (full CRUD); MGCLatticeCrossReferenceProcurementView (read)

Field	Label	Type	Source	Mandatory
PurchaseAgreementId (key)	Purchase agreement	String (PurchAgreementId)	PurchAgreementHeader.PurchNumberSequence	Yes
LineNumber (key)	Line number	Real (AgreementLineNum_PSN)	AgreementLine.LineNumber	Yes
ExternalSystem (key)	External system	String (MGCLatticeExternalSystemId)	MGCLatticeCrossReference.ExternalSystemId	Yes
ExternalKey	External key	String (MGCLatticeExternalKey)	MGCLatticeCrossReference.ExternalKey	Yes

MGCLatticePurchaseInvoiceDocumentAttachmentEntity

Purchase Invoice Document Attachments

Property	Value
OData entity set	LatticePurchaseInvoiceDocumentAttachments (single: LatticePurchaseInvoiceDocumentAttachment)
Access	Read/write
Data management	Enabled (staging table MGCLatticePurchaseInvoiceDocumentAttachmentStaging)
Company	Company-specific (ActualCompanyId)
Key	DocumentId
Data sources	VendInvoiceJour, DocuRefEntity
Configuration key	LedgerBasic
Granted by	MGCLatticePurchInvoiceDocAttachmentEntityMaintain (full CRUD); MGCLatticePurchInvoiceDocAttachmentEntityView (read)

Field	Label	Type	Source	Mandatory
DocumentId (key)	Document ID	Guid (DocuDocumentId)	DocuRefEntity.DocumentId
ActualCompanyId	Company accounts	String (SelectableDataArea)	DocuRefEntity.ActualCompanyId
DocumentAttachmentTypeCode	Type	String (DocuTypeId)	DocuRefEntity.TypeId	Yes
AttachmentDescription	Description	String (Description)	DocuRefEntity.Name
Notes	Note	String (Notes)	DocuRefEntity.Notes
AccessRestriction	Restriction	Enum DocuRestriction	DocuRefEntity.Restriction
Attachment	Archive file	Container (BitMap)	DocuRefEntity.FileContents
FileName	File name	String (Filename)	DocuRefEntity.FileName
FileType	File type	String (FilenameType)	DocuRefEntity.FileType
IsDefaultAttachment	Is default attachment	Enum NoYes	DocuRefEntity.DefaultAttachment
PurchaseOrderNumber	Purchase order	String (PurchIdBase)	VendInvoiceJour.PurchId
InvoiceId	Invoice	String (VendInvoiceId)	VendInvoiceJour.InvoiceId	Yes
InvoiceDate	Date	Date (TransDate)	VendInvoiceJour.InvoiceDate	Yes
VendorAccountNumber	Vendor account	String (VendAccount)	VendInvoiceJour.OrderAccount
InvoiceAccount	Invoice account	String (VendInvoiceAccount)	VendInvoiceJour.InvoiceAccount
ExternalSystem	External system	String (MGCLatticeExternalSystemId)	Unmapped (virtual)
PurchaseOrderNumberExternalKey	Purchase order external key	String (MGCLatticeExternalKey)	Unmapped (virtual)

MGCLatticePurchaseOrderConfirmationDocumentAttachmentEntity

Purchase Order Confirmation Document Attachments

Property	Value
OData entity set	LatticePurchaseOrderConfirmationDocumentAttachments (single: LatticePurchaseOrderConfirmationDocumentAttachment)
Access	Read/write
Data management	Enabled (staging table MGCLatticePurchaseOrderConfirmationDocumentAttachmentStaging)
Company	Company-specific (ActualCompanyId)
Key	DocumentId
Data sources	VendPurchOrderJour, DocuRefEntity
Configuration key	LedgerBasic
Granted by	MGCLatticePurchOrderConfirmDocAttachmentEntityMaintain (full CRUD); MGCLatticePurchOrderConfirmDocAttachmentEntityView (read)

Field	Label	Type	Source	Mandatory
DocumentId (key)	Document ID	Guid (DocuDocumentId)	DocuRefEntity.DocumentId
ActualCompanyId	Company accounts	String (SelectableDataArea)	DocuRefEntity.ActualCompanyId
DocumentAttachmentTypeCode	Type	String (DocuTypeId)	DocuRefEntity.TypeId	Yes
AttachmentDescription	Description	String (Description)	DocuRefEntity.Name
Notes	Note	String (Notes)	DocuRefEntity.Notes
AccessRestriction	Restriction	Enum DocuRestriction	DocuRefEntity.Restriction
Attachment	Archive file	Container (BitMap)	DocuRefEntity.FileContents
FileName	File name	String (Filename)	DocuRefEntity.FileName
FileType	File type	String (FilenameType)	DocuRefEntity.FileType
IsDefaultAttachment	Is default attachment	Enum NoYes	DocuRefEntity.DefaultAttachment
StorageProviderId	Document Storage Provider Type	Enum DocuStorageProviderType	DocuRefEntity.StorageProviderId
PurchaseOrderNumber	Purchase order	String (PurchIdBase)	VendPurchOrderJour.PurchId	Yes
ConfirmationNumber	Purchase journal	String (PurchaseOrderId)	VendPurchOrderJour.PurchOrderDocNum
ConfirmationDate	Date	Date (TransDate)	VendPurchOrderJour.PurchOrderDate	Yes
VendorAccountNumber	Vendor account	String (VendAccount)	VendPurchOrderJour.OrderAccount	Yes
ExternalSystem	External system	String (MGCLatticeExternalSystemId)	Unmapped (virtual)
PurchaseOrderNumberExternalKey	Purchase order external key	String (MGCLatticeExternalKey)	Unmapped (virtual)

MGCLatticePurchaseOrderCrossReferenceEntity

Purchase order cross references

Property	Value
OData entity set	LatticePurchaseOrderCrossReferences (single: LatticePurchaseOrderCrossReference)
Access	Read/write
Data management	Enabled (staging table MGCLatticePurchaseOrderCrossReferenceStaging)
Company	Company-specific (DataAreaId)
Key	PurchaseOrderNumber, ExternalSystem
Data sources	PurchTable, MGCLatticeCrossReference
Granted by	MGCLatticeCrossReferenceProcurementMaintain (full CRUD); MGCLatticeCrossReferenceProcurementView (read)

Field	Label	Type	Source	Mandatory
PurchaseOrderNumber (key)	Purchase order	String (PurchIdBase)	PurchTable.PurchId	Yes
ExternalSystem (key)	External system	String (MGCLatticeExternalSystemId)	MGCLatticeCrossReference.ExternalSystemId	Yes
ExternalKey	External key	String (MGCLatticeExternalKey)	MGCLatticeCrossReference.ExternalKey	Yes

MGCLatticePurchaseOrderLineCrossReferenceEntity

Purchase order line cross references

Property	Value
OData entity set	LatticePurchaseOrderLineCrossReferences (single: LatticePurchaseOrderLineCrossReference)
Access	Read/write
Data management	Enabled (staging table MGCLatticePurchaseOrderLineCrossReferenceStaging)
Company	Company-specific (DataAreaId)
Key	PurchaseOrderNumber, LineNumber, ExternalSystem
Data sources	PurchLine, MGCLatticeCrossReference
Granted by	MGCLatticeCrossReferenceProcurementMaintain (full CRUD); MGCLatticeCrossReferenceProcurementView (read)

Field	Label	Type	Source	Mandatory
PurchaseOrderNumber (key)	Purchase order	String (PurchIdBase)	PurchLine.PurchId	Yes
LineNumber (key)	Line number	Int64 (TradeLineNumber)	PurchLine.LineNumber	Yes
ExternalSystem (key)	External system	String (MGCLatticeExternalSystemId)	MGCLatticeCrossReference.ExternalSystemId	Yes
ExternalKey	External key	String (MGCLatticeExternalKey)	MGCLatticeCrossReference.ExternalKey	Yes

MGCLatticePurchaseOrderLineDocumentAttachmentEntity

Purchase Order Line Document Attachments

Property	Value
OData entity set	LatticePurchaseOrderLineDocumentAttachments (single: LatticePurchaseOrderLineDocumentAttachment)
Access	Read/write
Data management	Enabled (staging table MGCLatticePurchaseOrderLineDocumentAttachmentStaging)
Company	Company-specific (ActualCompanyId)
Key	DocumentId
Data sources	PurchLine, DocuRefEntity
Configuration key	LedgerBasic
Granted by	MGCLatticePurchOrderLineDocAttachmentEntityMaintain (full CRUD); MGCLatticePurchOrderLineDocAttachmentEntityView (read)

Field	Label	Type	Source	Mandatory
DocumentId (key)	Document ID	Guid (DocuDocumentId)	DocuRefEntity.DocumentId
ActualCompanyId	Company accounts	String (SelectableDataArea)	DocuRefEntity.ActualCompanyId
DocumentAttachmentTypeCode	Type	String (DocuTypeId)	DocuRefEntity.TypeId	Yes
AttachmentDescription	Description	String (Description)	DocuRefEntity.Name
Notes	Note	String (Notes)	DocuRefEntity.Notes
AccessRestriction	Restriction	Enum DocuRestriction	DocuRefEntity.Restriction
Attachment	Archive file	Container (BitMap)	DocuRefEntity.FileContents
FileName	File name	String (Filename)	DocuRefEntity.FileName
FileType	File type	String (FilenameType)	DocuRefEntity.FileType
IsDefaultAttachment	Is default attachment	Enum NoYes	DocuRefEntity.DefaultAttachment
PurchaseOrderNumber	Purchase order	String (PurchIdBase)	PurchLine.PurchId	Yes
LineNumber	Line number	Int64 (TradeLineNumber)	PurchLine.LineNumber
ItemNumber	Item number	String (ItemIdSmall)	PurchLine.ItemId
ExternalSystem	External system	String (MGCLatticeExternalSystemId)	Unmapped (virtual)
PurchaseOrderNumberExternalKey	Purchase order external key	String (MGCLatticeExternalKey)	Unmapped (virtual)
LineNumberExternalKey	Purchase order line external key	String (MGCLatticeExternalKey)	Unmapped (virtual)

MGCLatticePurchaseOrderLineEntity

Purchase Order Lines

Property	Value
OData entity set	LatticePurchaseOrderLines (single: LatticePurchaseOrderLine)
Access	Read/write
Data management	Enabled (staging table MGCLatticePurchaseOrderLineStaging)
Company	Company-specific (DataAreaId)
Key	InventoryLotId
Data sources	InventDim, PurchLine
Configuration key	LedgerBasic
Granted by	MGCLatticePurchaseOrderLineEntityMaintain (full CRUD); MGCLatticePurchaseOrderLineEntityView (read)

Field	Label	Type	Source	Mandatory
PurchaseOrderNumber	Purchase order	String (PurchIdBase)	PurchLine.PurchId	Yes
LineNumber	Line number	Int64 (TradeLineNumber)	PurchLine.LineNumber
ItemNumber	Item number	String (ItemIdSmall)	PurchLine.ItemId
OrderedPurchaseQuantity	Quantity	Real (PurchOrderedQty)	PurchLine.PurchQty
PurchasePrice	Unit price	Real (PurchPrice)	PurchLine.PurchPrice
LineAmount	Net amount	Real (PurchLineAmount)	PurchLine.LineAmount
CurrencyCode	Currency	String (VendCurrencyCode)	PurchLine.CurrencyCode	Yes
PurchaseUnitSymbol	Unit	String (PurchUnit)	PurchLine.PurchUnit
PurchaseStatus	Line status	Enum PurchStatus	PurchLine.PurchStatus
RequestedDeliveryDate	Requested receipt date	Date (PurchLineRequestedReceiptDate)	PurchLine.DeliveryDate
ReceivingSiteId	Site	String (InventSiteId)	InventDim.InventSiteId
ReceivingWarehouseId	Warehouse	String (InventLocationId)	InventDim.InventLocationId
InventoryLotId (key)	Lot ID	String (TradeInventTransId)	PurchLine.InventTransId
ExternalSystem	External system	String (MGCLatticeExternalSystemId)	Unmapped (virtual)
PurchaseOrderNumberExternalKey	Purchase order external key	String (MGCLatticeExternalKey)	Unmapped (virtual)
ItemNumberExternalKey	Item external key	String (MGCLatticeExternalKey)	Unmapped (virtual)

MGCLatticePurchasePackingSlipDocumentAttachmentEntity

Purchase Packing Slip Document Attachments

Property	Value
OData entity set	LatticePurchasePackingSlipDocumentAttachments (single: LatticePurchasePackingSlipDocumentAttachment)
Access	Read/write
Data management	Enabled (staging table MGCLatticePurchasePackingSlipDocumentAttachmentStaging)
Company	Company-specific (ActualCompanyId)
Key	DocumentId
Data sources	VendPackingSlipJour, DocuRefEntity
Configuration key	LedgerBasic
Granted by	MGCLatticePurchPackingSlipDocAttachmentEntityMaintain (full CRUD); MGCLatticePurchPackingSlipDocAttachmentEntityView (read)

Field	Label	Type	Source	Mandatory
DocumentId (key)	Document ID	Guid (DocuDocumentId)	DocuRefEntity.DocumentId
ActualCompanyId	Company accounts	String (SelectableDataArea)	DocuRefEntity.ActualCompanyId
DocumentAttachmentTypeCode	Type	String (DocuTypeId)	DocuRefEntity.TypeId	Yes
AttachmentDescription	Description	String (Description)	DocuRefEntity.Name
Notes	Note	String (Notes)	DocuRefEntity.Notes
AccessRestriction	Restriction	Enum DocuRestriction	DocuRefEntity.Restriction
Attachment	Attachment	Container (BitMap)	DocuRefEntity.FileContents
FileName	File name	String (Filename)	DocuRefEntity.FileName
FileType	File type	String (FilenameType)	DocuRefEntity.FileType
IsDefaultAttachment	Is default attachment	Enum NoYes	DocuRefEntity.DefaultAttachment
StorageProviderId	Document Storage Provider Type	Enum DocuStorageProviderType	DocuRefEntity.StorageProviderId
PurchaseOrderNumber	Purchase order	String (PurchIdBase)	VendPackingSlipJour.PurchId	Yes
PackingSlipId	Product receipt	String (ProductReceiptId)	VendPackingSlipJour.PackingSlipId	Yes
DeliveryDate	Date	Date (TransDate)	VendPackingSlipJour.DeliveryDate	Yes
VendorAccountNumber	Order account	String (VendAccount)	VendPackingSlipJour.OrderAccount	Yes
ExternalSystem	External system	String (MGCLatticeExternalSystemId)	Unmapped (virtual)
PurchaseOrderNumberExternalKey	Purchase order external key	String (MGCLatticeExternalKey)	Unmapped (virtual)

MGCLatticePurchaseReceiptsListDocumentAttachmentEntity

Purchase Receipts List Document Attachments

Property	Value
OData entity set	LatticePurchaseReceiptsListDocumentAttachments (single: LatticePurchaseReceiptsListDocumentAttachment)
Access	Read/write
Data management	Enabled (staging table MGCLatticePurchaseReceiptsListDocumentAttachmentStaging)
Company	Company-specific (ActualCompanyId)
Key	DocumentId
Data sources	VendReceiptsListJour, DocuRefEntity
Configuration key	LedgerBasic
Granted by	MGCLatticePurchReceiptsListDocAttachmentEntityMaintain (full CRUD); MGCLatticePurchReceiptsListDocAttachmentEntityView (read)

Field	Label	Type	Source	Mandatory
DocumentId (key)	Document ID	Guid (DocuDocumentId)	DocuRefEntity.DocumentId
ActualCompanyId	Company accounts	String (SelectableDataArea)	DocuRefEntity.ActualCompanyId
DocumentAttachmentTypeCode	Type	String (DocuTypeId)	DocuRefEntity.TypeId	Yes
AttachmentDescription	Description	String (Description)	DocuRefEntity.Name
Notes	Note	String (Notes)	DocuRefEntity.Notes
AccessRestriction	Restriction	Enum DocuRestriction	DocuRefEntity.Restriction
Attachment	Attachment	Container (BitMap)	DocuRefEntity.FileContents
FileName	File name	String (Filename)	DocuRefEntity.FileName
FileType	File type	String (FilenameType)	DocuRefEntity.FileType
IsDefaultAttachment	Is default attachment	Enum NoYes	DocuRefEntity.DefaultAttachment
StorageProviderId	Document Storage Provider Type	Enum DocuStorageProviderType	DocuRefEntity.StorageProviderId
PurchaseOrderNumber	Purchase order	String (PurchIdBase)	VendReceiptsListJour.PurchId
ReceiptsListId	Receipts list	String (ReceiptsListId)	VendReceiptsListJour.ReceiptsListId
VendorAccountNumber	Vendor account	String (VendAccount)	VendReceiptsListJour.VendAccount
ExternalSystem	External system	String (MGCLatticeExternalSystemId)	Unmapped (virtual)
PurchaseOrderNumberExternalKey	Purchase order external key	String (MGCLatticeExternalKey)	Unmapped (virtual)

MGCLatticePurchaseRequisitionCrossReferenceEntity

Purchase requisition cross references

Property	Value
OData entity set	LatticePurchaseRequisitionCrossReferences (single: LatticePurchaseRequisitionCrossReference)
Access	Read/write
Data management	Enabled (staging table MGCLatticePurchaseRequisitionCrossReferenceStaging)
Company	Company-specific (DataAreaId)
Key	RequisitionNumber, ExternalSystem
Data sources	PurchReqTable, MGCLatticeCrossReference
Granted by	MGCLatticeCrossReferenceProcurementMaintain (full CRUD); MGCLatticeCrossReferenceProcurementView (read)

Field	Label	Type	Source	Mandatory
RequisitionNumber (key)	Purchase requisition	String (PurchReqId)	PurchReqTable.PurchReqId	Yes
ExternalSystem (key)	External system	String (MGCLatticeExternalSystemId)	MGCLatticeCrossReference.ExternalSystemId	Yes
ExternalKey	External key	String (MGCLatticeExternalKey)	MGCLatticeCrossReference.ExternalKey	Yes

MGCLatticePurchaseRequisitionLineCrossReferenceEntity

Purchase requisition line cross references

Property	Value
OData entity set	LatticePurchaseRequisitionLineCrossReferences (single: LatticePurchaseRequisitionLineCrossReference)
Access	Read/write
Data management	Enabled (staging table MGCLatticePurchaseRequisitionLineCrossReferenceStaging)
Company	Company-specific (DataAreaId)
Key	RequisitionNumber, RequisitionLineNumber, ExternalSystem
Data sources	PurchReqTable, MGCLatticeCrossReference, PurchReqLine
Granted by	MGCLatticeCrossReferenceProcurementMaintain (full CRUD); MGCLatticeCrossReferenceProcurementView (read)

Field	Label	Type	Source	Mandatory
RequisitionNumber (key)	Purchase requisition	String (PurchReqId)	PurchReqTable.PurchReqId	Yes
RequisitionLineNumber (key)	Line	Int (SequenceNumber)	PurchReqLine.SequenceNumber	Yes
ExternalSystem (key)	External system	String (MGCLatticeExternalSystemId)	MGCLatticeCrossReference.ExternalSystemId	Yes
ExternalKey	External key	String (MGCLatticeExternalKey)	MGCLatticeCrossReference.ExternalKey	Yes

MGCLatticeQualityOrderDocumentAttachmentEntity

Quality Order Document Attachments

Property	Value
OData entity set	LatticeQualityOrderDocumentAttachments (single: LatticeQualityOrderDocumentAttachment)
Access	Read/write
Data management	Enabled (staging table MGCLatticeQualityOrderDocumentAttachmentStaging)
Company	Company-specific (ActualCompanyId)
Key	DocumentId
Data sources	InventQualityOrderTable, DocuRefEntity
Configuration key	LedgerBasic
Granted by	MGCLatticeQualityOrderDocAttachmentEntityMaintain (full CRUD); MGCLatticeQualityOrderDocAttachmentEntityView (read)

Field	Label	Type	Source	Mandatory
DocumentId (key)	Document ID	Guid (DocuDocumentId)	DocuRefEntity.DocumentId
ActualCompanyId	Company accounts	String (SelectableDataArea)	DocuRefEntity.ActualCompanyId
DocumentAttachmentTypeCode	Type	String (DocuTypeId)	DocuRefEntity.TypeId	Yes
AttachmentDescription	Description	String (Description)	DocuRefEntity.Name
Notes	Note	String (Notes)	DocuRefEntity.Notes
AccessRestriction	Restriction	Enum DocuRestriction	DocuRefEntity.Restriction
Attachment	Archive file	Container (BitMap)	DocuRefEntity.FileContents
FileName	File name	String (Filename)	DocuRefEntity.FileName
FileType	File type	String (FilenameType)	DocuRefEntity.FileType
IsDefaultAttachment	Is default attachment	Enum NoYes	DocuRefEntity.DefaultAttachment
QualityOrderId	Quality order	String (InventQualityOrderId)	InventQualityOrderTable.QualityOrderId	Yes
ItemNumber	Item number	String (ItemIdInventoried)	InventQualityOrderTable.ItemId	Yes
InventoryLotId	Lot ID	String (InventTransId)	InventQualityOrderTable.InventTransId

MGCLatticeReturnOrderCrossReferenceEntity

Return order cross references

Property	Value
OData entity set	LatticeReturnOrderCrossReferences (single: LatticeReturnOrderCrossReference)
Access	Read/write
Data management	Enabled (staging table MGCLatticeReturnOrderCrossReferenceStaging)
Company	Company-specific (DataAreaId)
Key	ReturnOrderNumber, ExternalSystem
Data sources	SalesTable, MGCLatticeCrossReference
Granted by	MGCLatticeCrossReferenceAccountsReceivableMaintain (full CRUD); MGCLatticeCrossReferenceAccountsReceivableView (read)

Field	Label	Type	Source	Mandatory
ReturnOrderNumber (key)	Sales order	String (SalesIdBase)	SalesTable.SalesId	Yes
ExternalSystem (key)	External system	String (MGCLatticeExternalSystemId)	MGCLatticeCrossReference.ExternalSystemId	Yes
ExternalKey	External key	String (MGCLatticeExternalKey)	MGCLatticeCrossReference.ExternalKey	Yes

MGCLatticeReturnOrderLineCrossReferenceEntity

Return order line cross references

Property	Value
OData entity set	LatticeReturnOrderLineCrossReferences (single: LatticeReturnOrderLineCrossReference)
Access	Read/write
Data management	Enabled (staging table MGCLatticeReturnOrderLineCrossReferenceStaging)
Company	Company-specific (DataAreaId)
Key	InventoryLotId, ExternalSystem
Data sources	SalesLine, MGCLatticeCrossReference
Granted by	MGCLatticeCrossReferenceAccountsReceivableMaintain (full CRUD); MGCLatticeCrossReferenceAccountsReceivableView (read)

Field	Label	Type	Source	Mandatory
ReturnOrderNumber	Sales order	String (SalesIdBase)	SalesLine.SalesId
LineNumber	Line number	Real (LineNum)	SalesLine.LineNum
InventoryLotId (key)	Lot ID	String (TradeInventTransId)	SalesLine.InventTransId	Yes
ExternalSystem (key)	External system	String (MGCLatticeExternalSystemId)	MGCLatticeCrossReference.ExternalSystemId	Yes
ExternalKey	External key	String (MGCLatticeExternalKey)	MGCLatticeCrossReference.ExternalKey	Yes

MGCLatticeSalesAgreementCrossReferenceEntity

Sales agreement cross references

Property	Value
OData entity set	LatticeSalesAgreementCrossReferences (single: LatticeSalesAgreementCrossReference)
Access	Read/write
Data management	Enabled (staging table MGCLatticeSalesAgreementCrossReferenceStaging)
Company	Company-specific (DataAreaId)
Key	SalesAgreementId, ExternalSystem
Data sources	SalesAgreementHeader, MGCLatticeCrossReference
Granted by	MGCLatticeCrossReferenceAccountsReceivableMaintain (full CRUD); MGCLatticeCrossReferenceAccountsReceivableView (read)

Field	Label	Type	Source	Mandatory
SalesAgreementId (key)	Sales agreement ID	String (SalesAgreementId)	SalesAgreementHeader.SalesNumberSequence	Yes
ExternalSystem (key)	External system	String (MGCLatticeExternalSystemId)	MGCLatticeCrossReference.ExternalSystemId	Yes
ExternalKey	External key	String (MGCLatticeExternalKey)	MGCLatticeCrossReference.ExternalKey	Yes

MGCLatticeSalesAgreementLineCrossReferenceEntity

Sales agreement line cross references

Property	Value
OData entity set	LatticeSalesAgreementLineCrossReferences (single: LatticeSalesAgreementLineCrossReference)
Access	Read/write
Data management	Enabled (staging table MGCLatticeSalesAgreementLineCrossReferenceStaging)
Company	Company-specific (DataAreaId)
Key	SalesAgreementId, LineNumber, ExternalSystem
Data sources	MGCLatticeCrossReference, AgreementLine, SalesAgreementHeader
Granted by	MGCLatticeCrossReferenceAccountsReceivableMaintain (full CRUD); MGCLatticeCrossReferenceAccountsReceivableView (read)

Field	Label	Type	Source	Mandatory
SalesAgreementId (key)	Sales agreement ID	String (SalesAgreementId)	SalesAgreementHeader.SalesNumberSequence	Yes
LineNumber (key)	Line number	Real (AgreementLineNum_PSN)	AgreementLine.LineNumber	Yes
ExternalSystem (key)	External system	String (MGCLatticeExternalSystemId)	MGCLatticeCrossReference.ExternalSystemId	Yes
ExternalKey	External key	String (MGCLatticeExternalKey)	MGCLatticeCrossReference.ExternalKey	Yes

MGCLatticeSalesConfirmationDocumentAttachmentEntity

Sales Confirmation Document Attachments

Property	Value
OData entity set	LatticeSalesConfirmationDocumentAttachments (single: LatticeSalesConfirmationDocumentAttachment)
Access	Read/write
Data management	Enabled (staging table MGCLatticeSalesConfirmationDocumentAttachmentStaging)
Company	Company-specific (ActualCompanyId)
Key	DocumentId
Data sources	CustConfirmJour, DocuRefEntity
Configuration key	LedgerBasic
Granted by	MGCLatticeSalesConfirmDocAttachmentEntityMaintain (full CRUD); MGCLatticeSalesConfirmDocAttachmentEntityView (read)

Field	Label	Type	Source	Mandatory
DocumentId (key)	Document ID	Guid (DocuDocumentId)	DocuRefEntity.DocumentId
ActualCompanyId	Company accounts	String (SelectableDataArea)	DocuRefEntity.ActualCompanyId
DocumentAttachmentTypeCode	Type	String (DocuTypeId)	DocuRefEntity.TypeId	Yes
AttachmentDescription	Description	String (Description)	DocuRefEntity.Name
Notes	Note	String (Notes)	DocuRefEntity.Notes
AccessRestriction	Restriction	Enum DocuRestriction	DocuRefEntity.Restriction
Attachment	Archive file	Container (BitMap)	DocuRefEntity.FileContents
FileName	File name	String (Filename)	DocuRefEntity.FileName
FileType	File type	String (FilenameType)	DocuRefEntity.FileType
IsDefaultAttachment	Is default attachment	Enum NoYes	DocuRefEntity.DefaultAttachment
SalesOrderNumber	Sales order	String (SalesIdBase)	CustConfirmJour.SalesId	Yes
ConfirmationId	Confirmation	String (ConfirmId)	CustConfirmJour.ConfirmId	Yes
ConfirmationDate	Date	Date (TransDate)	CustConfirmJour.ConfirmDate	Yes
CustomerAccount	Order account	String (CustAccount)	CustConfirmJour.OrderAccount	Yes
InvoiceAccount	Invoice account	String (CustInvoiceAccount)	CustConfirmJour.InvoiceAccount	Yes
ExternalSystem	External system	String (MGCLatticeExternalSystemId)	Unmapped (virtual)
SalesOrderNumberExternalKey	Sales order external key	String (MGCLatticeExternalKey)	Unmapped (virtual)

MGCLatticeSalesInvoiceDocumentAttachmentEntity

Sales Invoice Document Attachments

Property	Value
OData entity set	LatticeSalesInvoiceDocumentAttachments (single: LatticeSalesInvoiceDocumentAttachment)
Access	Read/write
Data management	Enabled (staging table MGCLatticeSalesInvoiceDocumentAttachmentStaging)
Company	Company-specific (ActualCompanyId)
Key	DocumentId
Data sources	CustInvoiceJour, DocuRefEntity
Configuration key	LedgerBasic
Granted by	MGCLatticeSalesInvoiceDocAttachmentEntityMaintain (full CRUD); MGCLatticeSalesInvoiceDocAttachmentEntityView (read)

Field	Label	Type	Source	Mandatory
DocumentId (key)	Document ID	Guid (DocuDocumentId)	DocuRefEntity.DocumentId
ActualCompanyId	Company accounts	String (SelectableDataArea)	DocuRefEntity.ActualCompanyId
DocumentAttachmentTypeCode	Type	String (DocuTypeId)	DocuRefEntity.TypeId	Yes
AttachmentDescription	Description	String (Description)	DocuRefEntity.Name
Notes	Note	String (Notes)	DocuRefEntity.Notes
AccessRestriction	Restriction	Enum DocuRestriction	DocuRefEntity.Restriction
Attachment	Archive file	Container (BitMap)	DocuRefEntity.FileContents
FileName	File name	String (Filename)	DocuRefEntity.FileName
FileType	File type	String (FilenameType)	DocuRefEntity.FileType
IsDefaultAttachment	Is default attachment	Enum NoYes	DocuRefEntity.DefaultAttachment
SalesOrderNumber	Sales order	String (SalesIdBase)	CustInvoiceJour.SalesId
InvoiceId	Invoice	String (CustInvoiceId)	CustInvoiceJour.InvoiceId
InvoiceDate	Date	Date (TransDate)	CustInvoiceJour.InvoiceDate	Yes
CustomerAccount	Customer account	String (CustAccount)	CustInvoiceJour.OrderAccount	Yes
InvoiceAccount	Invoice account	String (CustInvoiceAccount)	CustInvoiceJour.InvoiceAccount	Yes
ExternalSystem	External system	String (MGCLatticeExternalSystemId)	Unmapped (virtual)
SalesOrderNumberExternalKey	Sales order external key	String (MGCLatticeExternalKey)	Unmapped (virtual)

MGCLatticeSalesOrderCrossReferenceEntity

Sales order cross references

Property	Value
OData entity set	LatticeSalesOrderCrossReferences (single: LatticeSalesOrderCrossReference)
Access	Read/write
Data management	Enabled (staging table MGCLatticeSalesOrderCrossReferenceStaging)
Company	Company-specific (DataAreaId)
Key	SalesOrderNumber, ExternalSystem
Data sources	SalesTable, MGCLatticeCrossReference
Granted by	MGCLatticeCrossReferenceAccountsReceivableMaintain (full CRUD); MGCLatticeCrossReferenceAccountsReceivableView (read)

Field	Label	Type	Source	Mandatory
SalesOrderNumber (key)	Sales order	String (SalesIdBase)	SalesTable.SalesId	Yes
ExternalSystem (key)	External system	String (MGCLatticeExternalSystemId)	MGCLatticeCrossReference.ExternalSystemId	Yes
ExternalKey	External key	String (MGCLatticeExternalKey)	MGCLatticeCrossReference.ExternalKey	Yes

MGCLatticeSalesOrderLineChargeEntity

Sales Order Line Charges

Property	Value
OData entity set	LatticeSalesOrderLineCharges (single: LatticeSalesOrderLineCharge)
Access	Read/write
Data management	Enabled (staging table MGCLatticeSalesOrderLineChargeStaging)
Company	Company-specific (DataAreaId)
Key	SalesOrderNumber, SalesOrderLineInventoryLotId, ChargeLineNumber
Data sources	MarkupDocumentChargeEntity, SalesLine
Configuration key	Markup
Granted by	MGCLatticeSalesOrderLineChargeEntityMaintain (full CRUD); MGCLatticeSalesOrderLineChargeEntityView (read)

Field	Label	Type	Source	Mandatory
ChargeCategory	Category	Enum MarkupCategory	MarkupDocumentChargeEntity.ChargeCategory
SalesChargeCode	Charges code	String (MarkupCode)	MarkupDocumentChargeEntity.ChargeCode	Yes
ChargeDescription	Description	String (TransactionTextLarge)	MarkupDocumentChargeEntity.ChargeDescription
ChargeAccountingCurrencyCode	Currency	String (CurrencyCode)	MarkupDocumentChargeEntity.ChargeAccountingCurrencyCode	Yes
ChargePercentage	Charges percentage	Real (MarkupPercent)	MarkupDocumentChargeEntity.ChargePercentage
ExternalChargeAmount	External charges amount	Real (MarkupExternalAmount)	MarkupDocumentChargeEntity.ExternalChargeAmount
FixedChargeAmount	Fixed charges amount	Real (MarkupFixedAmount)	MarkupDocumentChargeEntity.FixedChargeAmount
IntercompanyChargePercentage	Intercompany charges percentage	Real (MarkupIntercompanyPercent)	MarkupDocumentChargeEntity.IntercompanyChargePercentage
ChargeLineNumber (key)	Line number	Real (LineNum)	MarkupDocumentChargeEntity.ChargeLineNumber	Yes
SalesOrderNumber (key)	Sales order	String (SalesIdBase)	SalesLine.SalesId	Yes
SalesOrderLineInventoryLotId (key)	Sales order line lot ID	String (TradeInventTransId)	SalesLine.InventTransId	Yes
SalesTaxGroupCode	Sales tax group	String (TaxGroup)	MarkupDocumentChargeEntity.SalesTaxGroupCode
SalesTaxItemGroupCode	Item sales tax group	String (TaxItemGroup)	MarkupDocumentChargeEntity.SalesTaxItemGroupCode
UnitChargeAmount	Charges per unit	Real (MarkupUnitAmount)	MarkupDocumentChargeEntity.UnitChargeAmount
WillInvoiceProcessingKeepCharge	Keep	Enum NoYes	MarkupDocumentChargeEntity.WillInvoiceProcessingKeepCharge
DocumentTableId	Reference table ID	Int (MarkupTransRefTableId)	MarkupDocumentChargeEntity.DocumentTableId
DocumentRecId	Reference	Int64 (MarkupTransRefRecId)	MarkupDocumentChargeEntity.DocumentRecId
DocumentStatus	Document status	Enum DocumentStatus	MarkupDocumentChargeEntity.DocumentStatus
IsIntercompanyCharge	Intercompany charge	Enum NoYes	MarkupDocumentChargeEntity.IsIntercompanyCharge
IsBrokerContractCharge	Broker contract fee	Enum NoYes	MarkupDocumentChargeEntity.IsBrokerContractCharge
OverrideSalesTax	Override sales tax	Enum NoYes	MarkupDocumentChargeEntity.OverrideSalesTax
SpecificUnitSymbol	Unit	String (MarkupSpecificUnitSymbol)	MarkupDocumentChargeEntity.SpecificUnitSymbol
Position	Position	Int (MarkupPosition)	MarkupDocumentChargeEntity.Position

MGCLatticeSalesOrderLineCrossReferenceEntity

Sales order line cross references

Property	Value
OData entity set	LatticeSalesOrderLineCrossReferences (single: LatticeSalesOrderLineCrossReference)
Access	Read/write
Data management	Enabled (staging table MGCLatticeSalesOrderLineCrossReferenceStaging)
Company	Company-specific (DataAreaId)
Key	InventoryLotId, ExternalSystem
Data sources	SalesLine, MGCLatticeCrossReference
Granted by	MGCLatticeCrossReferenceAccountsReceivableMaintain (full CRUD); MGCLatticeCrossReferenceAccountsReceivableView (read)

Field	Label	Type	Source	Mandatory
SalesOrderNumber	Sales order	String (SalesIdBase)	SalesLine.SalesId
LineNumber	Line number	Real (LineNum)	SalesLine.LineNum
InventoryLotId (key)	Lot ID	String (TradeInventTransId)	SalesLine.InventTransId	Yes
ExternalSystem (key)	External system	String (MGCLatticeExternalSystemId)	MGCLatticeCrossReference.ExternalSystemId	Yes
ExternalKey	External key	String (MGCLatticeExternalKey)	MGCLatticeCrossReference.ExternalKey	Yes

MGCLatticeSalesOrderLineEntity

Sales Order Lines

Property	Value
OData entity set	LatticeSalesOrderLines (single: LatticeSalesOrderLine)
Access	Read/write
Data management	Enabled (staging table MGCLatticeSalesOrderLineStaging)
Company	Company-specific (DataAreaId)
Key	InventoryLotId
Data sources	InventDim, SalesLine
Configuration key	LedgerBasic
Granted by	MGCLatticeSalesOrderLineEntityMaintain (full CRUD); MGCLatticeSalesOrderLineEntityView (read)

Field	Label	Type	Source	Mandatory
SalesOrderNumber	Sales order	String (SalesIdBase)	SalesLine.SalesId
LineNumber	Line number	Real (LineNum)	SalesLine.LineNum
ItemNumber	Item number	String (ItemIdSmall)	SalesLine.ItemId
OrderedSalesQuantity	Ordered quantity	Real (InventQty)	SalesLine.QtyOrdered
SalesPrice	Unit price	Real (SalesPrice)	SalesLine.SalesPrice
LineAmount	Net amount	Real (SalesLineAmount)	SalesLine.LineAmount
CurrencyCode	Currency	String (CustCurrencyCode)	SalesLine.CurrencyCode	Yes
SalesUnitSymbol	Unit	String (SalesUnit)	SalesLine.SalesUnit
SalesStatus	Line status	Enum SalesStatus	SalesLine.SalesStatus
RequestedReceiptDate	Requested ship date	Date (SalesShippingDateRequested)	SalesLine.ShippingDateRequested	Yes
ShippingSiteId	Site	String (InventSiteId)	InventDim.InventSiteId
ShippingWarehouseId	Warehouse	String (InventLocationId)	InventDim.InventLocationId
InventoryLotId (key)	Lot ID	String (TradeInventTransId)	SalesLine.InventTransId
ExternalSystem	External system	String (MGCLatticeExternalSystemId)	Unmapped (virtual)
SalesOrderNumberExternalKey	Sales order external key	String (MGCLatticeExternalKey)	Unmapped (virtual)
ItemNumberExternalKey	Item external key	String (MGCLatticeExternalKey)	Unmapped (virtual)

MGCLatticeSalesPackingSlipDocumentAttachmentEntity

Sales Packing Slip Document Attachments

Property	Value
OData entity set	LatticeSalesPackingSlipDocumentAttachments (single: LatticeSalesPackingSlipDocumentAttachment)
Access	Read/write
Data management	Enabled (staging table MGCLatticeSalesPackingSlipDocumentAttachmentStaging)
Company	Company-specific (ActualCompanyId)
Key	DocumentId
Data sources	CustPackingSlipJour, DocuRefEntity
Configuration key	LedgerBasic
Granted by	MGCLatticeSalesPackingSlipDocAttachmentEntityMaintain (full CRUD); MGCLatticeSalesPackingSlipDocAttachmentEntityView (read)

Field	Label	Type	Source	Mandatory
DocumentId (key)	Document ID	Guid (DocuDocumentId)	DocuRefEntity.DocumentId
ActualCompanyId	Company accounts	String (SelectableDataArea)	DocuRefEntity.ActualCompanyId
DocumentAttachmentTypeCode	Type	String (DocuTypeId)	DocuRefEntity.TypeId	Yes
AttachmentDescription	Description	String (Description)	DocuRefEntity.Name
Notes	Note	String (Notes)	DocuRefEntity.Notes
AccessRestriction	Restriction	Enum DocuRestriction	DocuRefEntity.Restriction
Attachment	Attachment	Container (BitMap)	DocuRefEntity.FileContents
FileName	File name	String (Filename)	DocuRefEntity.FileName
FileType	File type	String (FilenameType)	DocuRefEntity.FileType
IsDefaultAttachment	Is default attachment	Enum NoYes	DocuRefEntity.DefaultAttachment
SalesOrderNumber	Sales order	String (SalesIdBase)	CustPackingSlipJour.SalesId	Yes
PackingSlipId	Packing slip	String (PackingSlipId)	CustPackingSlipJour.PackingSlipId
DeliveryDate	Ship date	Date (SalesShippingDate)	CustPackingSlipJour.DeliveryDate
CustomerAccount	Order account	String (CustAccount)	CustPackingSlipJour.OrderAccount	Yes
InvoiceAccount	Invoice account	String (CustInvoiceAccount)	CustPackingSlipJour.InvoiceAccount	Yes
ExternalSystem	External system	String (MGCLatticeExternalSystemId)	Unmapped (virtual)
SalesOrderNumberExternalKey	Sales order external key	String (MGCLatticeExternalKey)	Unmapped (virtual)

MGCLatticeSalesQuotationCrossReferenceEntity

Sales quotation cross references

Property	Value
OData entity set	LatticeSalesQuotationCrossReferences (single: LatticeSalesQuotationCrossReference)
Access	Read/write
Data management	Enabled (staging table MGCLatticeSalesQuotationCrossReferenceStaging)
Company	Company-specific (DataAreaId)
Key	SalesQuotationNumber, ExternalSystem
Data sources	SalesQuotationTable, MGCLatticeCrossReference
Granted by	MGCLatticeCrossReferenceAccountsReceivableMaintain (full CRUD); MGCLatticeCrossReferenceAccountsReceivableView (read)

Field	Label	Type	Source	Mandatory
SalesQuotationNumber (key)	Quotation	String (QuotationIdBase)	SalesQuotationTable.QuotationId	Yes
ExternalSystem (key)	External system	String (MGCLatticeExternalSystemId)	MGCLatticeCrossReference.ExternalSystemId	Yes
ExternalKey	External key	String (MGCLatticeExternalKey)	MGCLatticeCrossReference.ExternalKey	Yes

MGCLatticeSalesQuotationLineCrossReferenceEntity

Sales quotation line cross references

Property	Value
OData entity set	LatticeSalesQuotationLineCrossReferences (single: LatticeSalesQuotationLineCrossReference)
Access	Read/write
Data management	Enabled (staging table MGCLatticeSalesQuotationLineCrossReferenceStaging)
Company	Company-specific (DataAreaId)
Key	InventoryLotId, ExternalSystem
Data sources	SalesQuotationLine, MGCLatticeCrossReference
Granted by	MGCLatticeCrossReferenceAccountsReceivableMaintain (full CRUD); MGCLatticeCrossReferenceAccountsReceivableView (read)

Field	Label	Type	Source	Mandatory
SalesQuotationNumber	Quotation	String (QuotationIdBase)	SalesQuotationLine.QuotationId
LineNumber	Line number	Real (LineNum)	SalesQuotationLine.LineNum
InventoryLotId (key)	Lot ID	String (TradeInventTransId)	SalesQuotationLine.InventTransId	Yes
ExternalSystem (key)	External system	String (MGCLatticeExternalSystemId)	MGCLatticeCrossReference.ExternalSystemId	Yes
ExternalKey	External key	String (MGCLatticeExternalKey)	MGCLatticeCrossReference.ExternalKey	Yes

MGCLatticeSetBasedTradeAgreementJournalLineEntity

Trade agreement journal lines (set-based)

Imports trade agreement journal lines (sales and purchase prices, line, multiline and total discounts) in bulk with set-based processing.

Property	Value
OData entity set	Not exposed over OData
Access	Read/write
Data management	Enabled (staging table MGCLatticeSetBasedTradeAgreementJournalLineStagingV2)
Company	Company-specific (DataAreaId)
Key	JournalNumber, LineNumber
Data sources	PriceDiscAdmTrans, InventDim, PriceDiscAdmTable
Configuration key	PriceDisc
Granted by	MGCLatticeSetBasedTradeAgreementJournalLineEntityMaintain (full CRUD); MGCLatticeSetBasedTradeAgreementJournalLineEntityView (read)

Field	Label	Type	Source	Mandatory
JournalNumber (key)	Price/discount journal number	String (PriceDiscJournalNum)	PriceDiscAdmTable.JournalNum	Yes
JournalNameId	Name	String (PriceDiscJournalName)	PriceDiscAdmTable.JournalName	Yes
JournalDescription	Description	String (Name)	PriceDiscAdmTable.Name
LineNumber (key)	Line number	Real (LineNum)	PriceDiscAdmTrans.LineNum	Yes
TradeAgreementType	Trade agreement type	String (Name)	Unmapped (virtual)	Yes
ItemCode	Product code type	Enum PriceDiscProductCodeType	PriceDiscAdmTrans.ItemCode
ItemRelation	Item relation	String (PriceDiscItemRelation)	PriceDiscAdmTrans.ItemRelation
AccountCode	Party code type	Enum PriceDiscPartyCodeType	PriceDiscAdmTrans.AccountCode
AccountRelation	Account selection	String (PriceDiscAccountRelation)	PriceDiscAdmTrans.AccountRelation
CurrencyCode	Currency	String (CurrencyCode)	PriceDiscAdmTrans.Currency	Yes
UnitSymbol	Unit	String (UnitOfMeasureSymbol)	PriceDiscAdmTrans.UnitId
FromQuantity	From	Real (AmountQty)	PriceDiscAdmTrans.QuantityAmountFrom
ToQuantity	To	Real (AmountQuantityTo)	PriceDiscAdmTrans.QuantityAmountTo
FromDate	From date	Date (FromDate)	PriceDiscAdmTrans.FromDate
ToDate	To date	Date (ToDate)	PriceDiscAdmTrans.ToDate
Amount	Amount in currency	Real (PriceDiscAmount)	PriceDiscAdmTrans.Amount
Percent1	Discount percentage 1	Real (DiscPct)	PriceDiscAdmTrans.Percent1
Percent2	Discount percentage 2	Real (DiscPct)	PriceDiscAdmTrans.Percent2
PriceUnit	Price unit	Real (PriceUnit)	PriceDiscAdmTrans.PriceUnit
Markup	Price charges	Real (PriceMarkup)	PriceDiscAdmTrans.Markup
LeadTimeDays	Lead time	Int (LeadTime)	PriceDiscAdmTrans.DeliveryTime
LeadTimeCalendarDays	Working days	Enum NoYes	PriceDiscAdmTrans.CalendarDays
DisregardLeadTime	Disregard lead time	Enum NoYes	PriceDiscAdmTrans.DisregardLeadTime
FindNext	Find next	Enum NoYes	PriceDiscAdmTrans.SearchAgain
InventorySiteId	Site	String (InventSiteId)	InventDim.InventSiteId
InventoryWarehouseId	Warehouse	String (InventLocationId)	InventDim.InventLocationId
ProductConfigurationId	Configuration	String (EcoResItemConfigurationName)	InventDim.configId
ProductSizeId	Size	String (EcoResItemSizeName)	InventDim.InventSizeId
ProductColorId	Color	String (EcoResItemColorName)	InventDim.InventColorId
ProductStyleId	Style	String (EcoResItemStyleName)	InventDim.InventStyleId
ProductVersionId	Version	String (EcoResItemVersionName)	InventDim.InventVersionId

MGCLatticeTransferOrderCrossReferenceEntity

Transfer order cross references

Property	Value
OData entity set	LatticeTransferOrderCrossReferences (single: LatticeTransferOrderCrossReference)
Access	Read/write
Data management	Enabled (staging table MGCLatticeTransferOrderCrossReferenceStaging)
Company	Company-specific (DataAreaId)
Key	TransferOrderNumber, ExternalSystem
Data sources	InventTransferTable, MGCLatticeCrossReference
Granted by	MGCLatticeCrossReferenceInventoryMaintain (full CRUD); MGCLatticeCrossReferenceInventoryView (read)

Field	Label	Type	Source	Mandatory
TransferOrderNumber (key)	Transfer number	String (InventTransferId)	InventTransferTable.TransferId	Yes
ExternalSystem (key)	External system	String (MGCLatticeExternalSystemId)	MGCLatticeCrossReference.ExternalSystemId	Yes
ExternalKey	External key	String (MGCLatticeExternalKey)	MGCLatticeCrossReference.ExternalKey	Yes

MGCLatticeTransferOrderDocumentAttachmentEntity

Transfer Order Document Attachments

Property	Value
OData entity set	LatticeTransferOrderDocumentAttachments (single: LatticeTransferOrderDocumentAttachment)
Access	Read/write
Data management	Enabled (staging table MGCLatticeTransferOrderDocumentAttachmentStaging)
Company	Company-specific (ActualCompanyId)
Key	DocumentId
Data sources	InventTransferTable, DocuRefEntity
Configuration key	LedgerBasic
Granted by	MGCLatticeTransferOrderDocAttachmentEntityMaintain (full CRUD); MGCLatticeTransferOrderDocAttachmentEntityView (read)

Field	Label	Type	Source	Mandatory
DocumentId (key)	Document ID	Guid (DocuDocumentId)	DocuRefEntity.DocumentId
ActualCompanyId	Company accounts	String (SelectableDataArea)	DocuRefEntity.ActualCompanyId
DocumentAttachmentTypeCode	Type	String (DocuTypeId)	DocuRefEntity.TypeId	Yes
AttachmentDescription	Description	String (Description)	DocuRefEntity.Name
Notes	Note	String (Notes)	DocuRefEntity.Notes
AccessRestriction	Restriction	Enum DocuRestriction	DocuRefEntity.Restriction
Attachment	Archive file	Container (BitMap)	DocuRefEntity.FileContents
FileName	File name	String (Filename)	DocuRefEntity.FileName
FileType	File type	String (FilenameType)	DocuRefEntity.FileType
IsDefaultAttachment	Is default attachment	Enum NoYes	DocuRefEntity.DefaultAttachment
TransferOrderNumber	Transfer number	String (InventTransferId)	InventTransferTable.TransferId	Yes
ExternalSystem	External system	String (MGCLatticeExternalSystemId)	Unmapped (virtual)
TransferOrderNumberExternalKey	Transfer order external key	String (MGCLatticeExternalKey)	Unmapped (virtual)

MGCLatticeTransferOrderLineCrossReferenceEntity

Transfer order line cross references

Property	Value
OData entity set	LatticeTransferOrderLineCrossReferences (single: LatticeTransferOrderLineCrossReference)
Access	Read/write
Data management	Enabled (staging table MGCLatticeTransferOrderLineCrossReferenceStaging)
Company	Company-specific (DataAreaId)
Key	TransferOrderNumber, LineNumber, ExternalSystem
Data sources	InventTransferLine, MGCLatticeCrossReference
Granted by	MGCLatticeCrossReferenceInventoryMaintain (full CRUD); MGCLatticeCrossReferenceInventoryView (read)

Field	Label	Type	Source	Mandatory
TransferOrderNumber (key)	Transfer number	String (InventTransferId)	InventTransferLine.TransferId	Yes
LineNumber (key)	Line number	Real (LineNum)	InventTransferLine.LineNum	Yes
ExternalSystem (key)	External system	String (MGCLatticeExternalSystemId)	MGCLatticeCrossReference.ExternalSystemId	Yes
ExternalKey	External key	String (MGCLatticeExternalKey)	MGCLatticeCrossReference.ExternalKey	Yes

MGCLatticeTransferOrderLineDocumentAttachmentEntity

Transfer Order Line Document Attachments

Property	Value
OData entity set	LatticeTransferOrderLineDocumentAttachments (single: LatticeTransferOrderLineDocumentAttachment)
Access	Read/write
Data management	Enabled (staging table MGCLatticeTransferOrderLineDocumentAttachmentStaging)
Company	Company-specific (ActualCompanyId)
Key	DocumentId
Data sources	InventTransferLine, DocuRefEntity
Configuration key	LedgerBasic
Granted by	MGCLatticeTransferOrderLineDocAttachEntityMaintain (full CRUD); MGCLatticeTransferOrderLineDocAttachEntityView (read)

Field	Label	Type	Source	Mandatory
DocumentId (key)	Document ID	Guid (DocuDocumentId)	DocuRefEntity.DocumentId
ActualCompanyId	Company accounts	String (SelectableDataArea)	DocuRefEntity.ActualCompanyId
DocumentAttachmentTypeCode	Type	String (DocuTypeId)	DocuRefEntity.TypeId	Yes
AttachmentDescription	Description	String (Description)	DocuRefEntity.Name
Notes	Note	String (Notes)	DocuRefEntity.Notes
AccessRestriction	Restriction	Enum DocuRestriction	DocuRefEntity.Restriction
Attachment	Archive file	Container (BitMap)	DocuRefEntity.FileContents
FileName	File name	String (Filename)	DocuRefEntity.FileName
FileType	File type	String (FilenameType)	DocuRefEntity.FileType
IsDefaultAttachment	Is default attachment	Enum NoYes	DocuRefEntity.DefaultAttachment
TransferOrderNumber	Transfer number	String (InventTransferId)	InventTransferLine.TransferId	Yes
ItemNumber	Item number	String (ItemIdInventoried)	InventTransferLine.ItemId	Yes
LineNumber	Line number	Real (LineNum)	InventTransferLine.LineNum
ExternalSystem	External system	String (MGCLatticeExternalSystemId)	Unmapped (virtual)
TransferOrderNumberExternalKey	Transfer order external key	String (MGCLatticeExternalKey)	Unmapped (virtual)
LineNumberExternalKey	Transfer order line external key	String (MGCLatticeExternalKey)	Unmapped (virtual)

MGCLatticeVendorContactInfoEntity

Vendor Contact Information

Property	Value
OData entity set	LatticeVendorContactInfos (single: LatticeVendorContactInfo)
Access	Read/write
Data management	Enabled (staging table MGCLatticeVendorContactInfoStaging)
Company	Company-specific (VendorDataAreaId)
Key	VendorAccountNumber, VendorDataAreaId, Type, Locator, Description
Data sources	DirPartyContactEntity, DirPartyTable, VendTable
Configuration key	LogisticsBasic
Granted by	MGCLatticeVendorContactInfoEntityMaintain (full CRUD); MGCLatticeVendorContactInfoEntityView (read)

Field	Label	Type	Source	Mandatory
VendorAccountNumber (key)	Vendor account	String (VendAccount)	VendTable.AccountNum	Yes
VendorDataAreaId (key)	Company	String (DataAreaId)	VendTable.DataAreaId
Type (key)	Type	Enum LogisticsElectronicAddressMethodType	DirPartyContactEntity.Type	Yes
Locator (key)	Contact number/address	String (LogisticsElectronicAddressLocator)	DirPartyContactEntity.Locator
Description (key)	Description	String (Description)	DirPartyContactEntity.Description
Purpose	Purpose	String (DirPartyContactLocationRoleNames)	DirPartyContactEntity.Purpose
LocatorExtension	Extension	String (PhoneLocal)	DirPartyContactEntity.LocatorExtension
CountryRegionCode	International calling code	String (LogisticsCountryRegionCode)	DirPartyContactEntity.CountryRegionCode
IsPrimary	Primary	Enum NoYes	DirPartyContactEntity.IsPrimary
IsMobilePhone	Mobile	Enum NoYes	DirPartyContactEntity.IsMobilePhone
IsPrivate	Private	Enum NoYes	DirPartyContactEntity.IsPrivate
LocationId	Location ID	String (LogisticsLocationId)	DirPartyContactEntity.LocationId	Yes
PartyNumber	Party ID	String (DirPartyNumber)	DirPartyContactEntity.PartyNumber	Yes

MGCLatticeVendorContactPersonEntity

Vendor Contact Persons

Property	Value
OData entity set	LatticeVendorContactPersons (single: LatticeVendorContactPerson)
Access	Read/write
Data management	Enabled (staging table MGCLatticeVendorContactPersonStaging)
Company	Company-specific (VendorDataAreaId)
Key	VendorAccountNumber, VendorDataAreaId, ContactPersonId
Data sources	smmContactPersonV2Entity, DirPartyTable, VendTable
Configuration key	LogisticsBasic
Granted by	MGCLatticeVendorContactPersonsEntityMaintain (full CRUD); MGCLatticeVendorContactPersonsEntityView (read)

Field	Label	Type	Source	Mandatory
VendorAccountNumber (key)	Vendor account	String (VendAccount)	VendTable.AccountNum	Yes
VendorDataAreaId (key)	Company	String (DataAreaId)	VendTable.DataAreaId
AddressBookNames	Address books	String (DirAddressBookNames)	smmContactPersonV2Entity.AddressBookNames
AlternateComplimentaryClosingPhrase			smmContactPersonV2Entity.AlternateComplimentaryClosingPhrase
AlternateSalutationPhrase			smmContactPersonV2Entity.AlternateSalutationPhrase
AnniversaryDay			smmContactPersonV2Entity.AnniversaryDay
AnniversaryMonth			smmContactPersonV2Entity.AnniversaryMonth
AnniversaryYear			smmContactPersonV2Entity.AnniversaryYear
AssistantName	Name	String (smmAssistantName)	smmContactPersonV2Entity.AssistantName
AssistantPhoneNumber	Phone number	String (smmAssistantPhone)	smmContactPersonV2Entity.AssistantPhoneNumber
AssociatedPartyNumber	Associated party number	String (DirPartyNumber)	smmContactPersonV2Entity.AssociatedPartyNumber	Yes
AvailableFromTime			smmContactPersonV2Entity.AvailableFromTime
AvailableToTime			smmContactPersonV2Entity.AvailableToTime
BillingInformation			smmContactPersonV2Entity.BillingInformation
BirthDay			smmContactPersonV2Entity.BirthDay
BirthMonth			smmContactPersonV2Entity.BirthMonth
BirthYear			smmContactPersonV2Entity.BirthYear
ChildrenNames			smmContactPersonV2Entity.ChildrenNames
ContactActivitySensitivityLevel	Sensitivity	Enum smmSensitivity	smmContactPersonV2Entity.ContactActivitySensitivityLevel
ContactInformationLanguageId	Language	String (LanguageId)	smmContactPersonV2Entity.ContactInformationLanguageId
ContactPersonId (key)	Contact ID	String (ContactPersonId)	smmContactPersonV2Entity.ContactPersonId	Yes
ContactPersonName	Name	String (DirPartyName)	smmContactPersonV2Entity.ContactPersonName	Yes
ContactPersonPartyNumber	Party ID	String (DirPartyNumber)	smmContactPersonV2Entity.ContactPersonPartyNumber	Yes
ContactPersonPartyType	Contact person party type	String (DirPartyInstanceRelationTypeName)	smmContactPersonV2Entity.ContactPersonPartyType
ContactPersonResponsiblePersonnelNumber	Personnel number	String (HcmPersonnelNumberId)	smmContactPersonV2Entity.ContactPersonResponsiblePersonnelNumber
DecisionMakingRoleCode			smmContactPersonV2Entity.DecisionMakingRoleCode
DisplayNameSequencePatternName	Display as	String (DirNameSequenceDisplayAs)	smmContactPersonV2Entity.DisplayNameSequencePatternName	Yes
ElectronicLocationId	Location ID	String (LogisticsLocationId)	smmContactPersonV2Entity.ElectronicLocationId
EmploymentComputerNetworkName	Computer network name	String (smmComputerNetworkName)	smmContactPersonV2Entity.EmploymentComputerNetworkName
EmploymentDepartment	Department	String (smmDepartment)	smmContactPersonV2Entity.EmploymentDepartment
EmploymentJobFunctionName			smmContactPersonV2Entity.EmploymentJobFunctionName
EmploymentJobTitle	Job title	String (PersonTitle)	smmContactPersonV2Entity.EmploymentJobTitle
EmploymentOfficeLocation	Office location	String (smmOfficeLocation)	smmContactPersonV2Entity.EmploymentOfficeLocation
EmploymentProfession	Profession	String (smmProfession)	smmContactPersonV2Entity.EmploymentProfession
FirstName	First name	String (FirstName)	smmContactPersonV2Entity.FirstName
FormattedPrimaryAddress	Address	String (LogisticsAddressing)	smmContactPersonV2Entity.FormattedPrimaryAddress
Gender			smmContactPersonV2Entity.Gender
GovernmentIdentificationNumber	Government ID	String (smmGovernmentIDNumber)	smmContactPersonV2Entity.GovernmentIdentificationNumber
HasRequestedInternetAccess	Request internet access	Enum NoYes	smmContactPersonV2Entity.HasRequestedInternetAccess
Hobbies			smmContactPersonV2Entity.Hobbies
IdentityCardNumber			smmContactPersonV2Entity.IdentityCardNumber
Initials			smmContactPersonV2Entity.Initials
IsContactPersonExternallyMaintained			smmContactPersonV2Entity.IsContactPersonExternallyMaintained
IsDefaultContactPerson			smmContactPersonV2Entity.IsDefaultContactPerson
IsImported	Imported	Enum NoYes	smmContactPersonV2Entity.IsImported
IsInactive	Inactive	Enum NoYes	smmContactPersonV2Entity.IsInactive
LastName	Last name	String (LastName)	smmContactPersonV2Entity.LastName
MiddleName	Middle name	String (MiddleName)	smmContactPersonV2Entity.MiddleName
PrimaryAddressCity	City	String (LogisticsAddressCityName)	smmContactPersonV2Entity.PrimaryAddressCity
PrimaryAddressCountryRegionId	Country/region	String (LogisticsAddressCountryRegionId)	smmContactPersonV2Entity.PrimaryAddressCountryRegionId	Yes
PrimaryAddressCountryRegionISOCode	Country/region ISO	String (LogisticsAddressCountryRegionISOCode)	smmContactPersonV2Entity.PrimaryAddressCountryRegionISOCode
PrimaryAddressStateId	State	String (LogisticsAddressStateId)	smmContactPersonV2Entity.PrimaryAddressStateId
PrimaryAddressStreet	Street	String (LogisticsAddressStreet)	smmContactPersonV2Entity.PrimaryAddressStreet
PrimaryAddressZipCode	ZIP/postal code	String (LogisticsAddressZipCodeId)	smmContactPersonV2Entity.PrimaryAddressZipCode
PrimaryEmailAddress	Contact number/address	String (LogisticsElectronicAddressLocator)	smmContactPersonV2Entity.PrimaryEmailAddress
PrimaryPhoneNumber	Contact number/address	String (LogisticsElectronicAddressLocator)	smmContactPersonV2Entity.PrimaryPhoneNumber
PrimaryFaxNumber	Contact number/address	String (LogisticsElectronicAddressLocator)	smmContactPersonV2Entity.PrimaryFaxNumber
PrimaryURL	Contact number/address	String (LogisticsElectronicAddressLocator)	smmContactPersonV2Entity.PrimaryURL
SearchName	Search name	String (NameAlias)	smmContactPersonV2Entity.SearchName
ExternalSystem	External system	String (MGCLatticeExternalSystemId)	Unmapped (virtual)
VendorAccountNumberExternalKey	Vendor external key	String (MGCLatticeExternalKey)	Unmapped (virtual)

MGCLatticeVendorDocumentAttachmentEntity

Vendor document attachment

Property	Value
OData entity set	LatticeVendorDocumentAttachments (single: LatticeVendorDocumentAttachment)
Access	Read/write
Data management	Enabled (staging table MGCLatticeVendorDocumentAttachmentStaging)
Company	Company-specific (ActualCompanyId)
Key	DocumentId
Data sources	VendTable, DocuRefEntity
Configuration key	LedgerBasic
Granted by	MGCLatticeVendorDocumentAttachmentEntityView (read); MGCLatticeVendorDocumentAttachmentMaintain (full CRUD)

Field	Label	Type	Source	Mandatory
DocumentId (key)	Document ID	Guid (DocuDocumentId)	DocuRefEntity.DocumentId
ActualCompanyId	Company accounts	String (SelectableDataArea)	DocuRefEntity.ActualCompanyId
DocumentAttachmentTypeCode	Type	String (DocuTypeId)	DocuRefEntity.TypeId	Yes
AttachmentDescription	Description	String (Description)	DocuRefEntity.Name
Notes	Note	String (Notes)	DocuRefEntity.Notes
AccessRestriction	Restriction	Enum DocuRestriction	DocuRefEntity.Restriction
Attachment	Archive file	Container (BitMap)	DocuRefEntity.FileContents
FileName	File name	String (Filename)	DocuRefEntity.FileName
FileType	File type	String (FilenameType)	DocuRefEntity.FileType
IsDefaultAttachment	Is default attachment	Enum NoYes	DocuRefEntity.DefaultAttachment
VendorAccountNumber	Vendor account	String (VendAccount)	VendTable.AccountNum	Yes
ExternalSystem	External system	String (MGCLatticeExternalSystemId)	Unmapped (virtual)
VendorAccountNumberExternalKey	Vendor external key	String (MGCLatticeExternalKey)	Unmapped (virtual)

MGCLatticeSetBasedVendorInvoiceJournalLineEntity

Vendor invoice journal lines (set-based)

Imports vendor invoices in bulk with set-based processing into vendor invoice journals, which post the invoices, or invoice registers, which park them for approval.

Property	Value
OData entity set	Not exposed over OData
Access	Read/write
Data management	Enabled (staging table MGCLatticeSetBasedVendorInvoiceJournalLineStaging)
Company	Company-specific (DataAreaId)
Key	JournalNumber, LineNumber
Data sources	LedgerJournalTable, LedgerJournalTrans
Configuration key	LedgerBasic
Granted by	MGCLatticeSetBasedVendorInvoiceJournalLineEntityMaintain (full CRUD); MGCLatticeSetBasedVendorInvoiceJournalLineEntityView (read)

Field	Label	Type	Source	Mandatory
JournalNumber (key)	Journal batch number	String (LedgerJournalId)	LedgerJournalTable.JournalNum	Yes
JournalNameId	Name	String (LedgerJournalNameId)	LedgerJournalTable.JournalName	Yes
LineNumber (key)	Line number	Real (LineNum)	LedgerJournalTrans.LineNum	Yes
TransactionDate	Date	Date (TransDate)	LedgerJournalTrans.TransDate
Voucher	Voucher	String (Voucher)	LedgerJournalTrans.Voucher
VendorAccount	Vendor account	String (VendAccount)	Unmapped (virtual)	Yes
InvoiceNumber	Invoice	String (InvoiceId)	LedgerJournalTrans.Invoice	Yes
DocumentDate	Document date	Date (DocumentDate)	LedgerJournalTrans.DocumentDate
DueDate	Due date	Date (DueDate)	LedgerJournalTrans.Due
TermsOfPayment	Terms of payment	String (PaymTermId)	LedgerJournalTrans.Payment
Description	Description	String (LedgerJournalTransTxt)	LedgerJournalTrans.Txt
CurrencyCode	Currency	String (CurrencyCode)	LedgerJournalTrans.CurrencyCode	Yes
ExchangeRate	Exchange rate	Real (ExchRate)	LedgerJournalTrans.ExchRate
DebitAmount	Debit	Real (AmountCurDebit)	LedgerJournalTrans.AmountCurDebit
CreditAmount	Credit	Real (AmountCurCredit)	LedgerJournalTrans.AmountCurCredit
MethodOfPayment	Method of payment	String (PaymMode)	LedgerJournalTrans.PaymMode
BankTransactionType	Bank transaction type	String (BankTransactionType)	LedgerJournalTrans.BankTransType
SalesTaxGroup	Sales tax group	String (TaxGroupJournal)	LedgerJournalTrans.TaxGroup
ItemSalesTaxGroup	Item sales tax group	String (TaxGroupJournal)	LedgerJournalTrans.TaxItemGroup
PostingProfile	Posting profile	String (PostingProfile)	LedgerJournalTrans.PostingProfile
ApproverPersonnelNumber	Approver personnel number	String (HcmPersonnelNumberId)	Unmapped (virtual)
OffsetAccountType	Offset account type	Enum LedgerJournalACType	LedgerJournalTrans.OffsetAccountType
OffsetAccountDisplayValue	Offset account	String (DimensionDisplayValue)	Unmapped (virtual)
DefaultDimensionDisplayValue	Financial dimensions	String (DimensionDisplayValue)	Unmapped (virtual)
OffsetDefaultDimensionDisplayValue	Offset financial dimensions	String (DimensionDisplayValue)	Unmapped (virtual)

MGCLatticeSetBasedVendorPaymentJournalLineEntity

Vendor payment journal lines (set-based)

Imports vendor payment journal lines in bulk with set-based processing: one new journal per journal key, or lines added to an open journal.

Property	Value
OData entity set	Not exposed over OData
Access	Read/write
Data management	Enabled (staging table MGCLatticeSetBasedVendorPaymentJournalLineStaging)
Company	Company-specific (DataAreaId)
Key	JournalNumber, LineNumber
Data sources	LedgerJournalTable, LedgerJournalTrans
Configuration key	LedgerBasic
Granted by	MGCLatticeSetBasedVendorPaymentJournalLineEntityMaintain (full CRUD); MGCLatticeSetBasedVendorPaymentJournalLineEntityView (read)

Field	Label	Type	Source	Mandatory
JournalNumber (key)	Journal batch number	String (LedgerJournalId)	LedgerJournalTable.JournalNum	Yes
JournalNameId	Name	String (LedgerJournalNameId)	LedgerJournalTable.JournalName	Yes
LineNumber (key)	Line number	Real (LineNum)	LedgerJournalTrans.LineNum	Yes
TransactionDate	Date	Date (TransDate)	LedgerJournalTrans.TransDate
Voucher	Voucher	String (Voucher)	LedgerJournalTrans.Voucher
VendorAccount	Vendor account	String (VendAccount)	Unmapped (virtual)	Yes
Description	Description	String (LedgerJournalTransTxt)	LedgerJournalTrans.Txt
CurrencyCode	Currency	String (CurrencyCode)	LedgerJournalTrans.CurrencyCode	Yes
ExchangeRate	Exchange rate	Real (ExchRate)	LedgerJournalTrans.ExchRate
DebitAmount	Debit	Real (AmountCurDebit)	LedgerJournalTrans.AmountCurDebit
CreditAmount	Credit	Real (AmountCurCredit)	LedgerJournalTrans.AmountCurCredit
MethodOfPayment	Method of payment	String (PaymMode)	LedgerJournalTrans.PaymMode
BankTransactionType	Bank transaction type	String (BankTransactionType)	LedgerJournalTrans.BankTransType
PaymentReference	Payment reference	String (PaymReference)	LedgerJournalTrans.PaymReference
PostingProfile	Posting profile	String (PostingProfile)	LedgerJournalTrans.PostingProfile
OffsetAccountType	Offset account type	Enum LedgerJournalACType	LedgerJournalTrans.OffsetAccountType
OffsetAccountDisplayValue	Offset account	String (DimensionDisplayValue)	Unmapped (virtual)
DefaultDimensionDisplayValue	Financial dimensions	String (DimensionDisplayValue)	Unmapped (virtual)
OffsetDefaultDimensionDisplayValue	Offset financial dimensions	String (DimensionDisplayValue)	Unmapped (virtual)

Master entities

MGCLatticeBatchCrossReferenceEntity

Batch cross references

Property	Value
OData entity set	LatticeBatchCrossReferences (single: LatticeBatchCrossReference)
Access	Read/write
Data management	Enabled (staging table MGCLatticeBatchCrossReferenceStaging)
Company	Company-specific (DataAreaId)
Key	ItemNumber, BatchNumber, ExternalSystem
Data sources	InventBatch, MGCLatticeCrossReference
Granted by	MGCLatticeCrossReferenceInventoryMaintain (full CRUD); MGCLatticeCrossReferenceInventoryView (read)

Field	Label	Type	Source	Mandatory
ItemNumber (key)	Item number	String (ItemId)	InventBatch.itemId	Yes
BatchNumber (key)	Batch number	String (InventBatchId)	InventBatch.inventBatchId	Yes
ExternalSystem (key)	External system	String (MGCLatticeExternalSystemId)	MGCLatticeCrossReference.ExternalSystemId	Yes
ExternalKey	External key	String (MGCLatticeExternalKey)	MGCLatticeCrossReference.ExternalKey	Yes

MGCLatticeBOMCrossReferenceEntity

Bill of materials cross references

Property	Value
OData entity set	LatticeBOMCrossReferences (single: LatticeBOMCrossReference)
Access	Read/write
Data management	Enabled (staging table MGCLatticeBOMCrossReferenceStaging)
Company	Company-specific (DataAreaId)
Key	BOMId, ExternalSystem
Data sources	BOMTable, MGCLatticeCrossReference
Granted by	MGCLatticeCrossReferenceProductionMaintain (full CRUD); MGCLatticeCrossReferenceProductionView (read)

Field	Label	Type	Source	Mandatory
BOMId (key)	BOM	String (BOMId)	BOMTable.BOMId	Yes
ExternalSystem (key)	External system	String (MGCLatticeExternalSystemId)	MGCLatticeCrossReference.ExternalSystemId	Yes
ExternalKey	External key	String (MGCLatticeExternalKey)	MGCLatticeCrossReference.ExternalKey	Yes

MGCLatticeBOMVersionCrossReferenceEntity

Bill of materials version cross references

Property	Value
OData entity set	LatticeBOMVersionCrossReferences (single: LatticeBOMVersionCrossReference)
Access	Read/write
Data management	Enabled (staging table MGCLatticeBOMVersionCrossReferenceStaging)
Company	Company-specific (DataAreaId)
Key	ManufacturedItemNumber, BOMId, SequenceId, ExternalSystem
Data sources	BOMVersion, MGCLatticeCrossReference
Granted by	MGCLatticeCrossReferenceProductionMaintain (full CRUD); MGCLatticeCrossReferenceProductionView (read)

Field	Label	Type	Source	Mandatory
ManufacturedItemNumber (key)	Item number	String (ItemIdProduction)	BOMVersion.ItemId	Yes
BOMId (key)	BOM	String (BOMId)	BOMVersion.BOMId	Yes
SequenceId (key)	BOM version sequence number	Int (BOMVersionCreationSequenceNumber)	BOMVersion.SequenceId	Yes
ExternalSystem (key)	External system	String (MGCLatticeExternalSystemId)	MGCLatticeCrossReference.ExternalSystemId	Yes
ExternalKey	External key	String (MGCLatticeExternalKey)	MGCLatticeCrossReference.ExternalKey	Yes

MGCLatticeSetBasedBomLineEntity

BOM lines (set-based)

Imports bill of materials lines into existing BOMs in bulk with set-based processing. Lines are added only; a line number the BOM already has is refused.

Property	Value
OData entity set	Not exposed over OData
Access	Read/write
Data management	Enabled (staging table MGCLatticeSetBasedBomLineStaging)
Company	Company-specific (DataAreaId)
Key	BOMId, LineNumber
Data sources	BOM, InventDim
Configuration key	BOM
Granted by	MGCLatticeSetBasedBomLineEntityMaintain (full CRUD); MGCLatticeSetBasedBomLineEntityView (read)

Field	Label	Type	Source	Mandatory
BOMId (key)	BOM	String (BOMId)	BOM.BOMId	Yes
LineNumber (key)	Line number	Real (LineNum)	BOM.LineNum	Yes
ItemNumber	Item number	String (ItemIdInventoried)	BOM.ItemId	Yes
LineType	Line type	Enum BOMType	BOM.BOMType
Quantity	Quantity	Real (BOMQty)	BOM.BOMQty
QuantityDenominator	Per series	Real (BOMQtySerie)	BOM.BOMQtySerie
ProductUnitSymbol	Unit	String (UnitOfMeasureSymbol)	BOM.UnitId	Yes
ConsumptionSiteId	Site	String (InventSiteId)	InventDim.InventSiteId
ConsumptionWarehouseId	Warehouse	String (InventLocationId)	InventDim.InventLocationId
ProductConfigurationId	Configuration	String (EcoResItemConfigurationName)	InventDim.configId
ProductColorId	Color	String (EcoResItemColorName)	InventDim.InventColorId
ProductSizeId	Size	String (EcoResItemSizeName)	InventDim.InventSizeId
ProductStyleId	Style	String (EcoResItemStyleName)	InventDim.InventStyleId
ProductVersionId	Version	String (EcoResItemVersionName)	InventDim.InventVersionId
PositionNumber	Position	String (BOMPosition)	BOM.Position
ValidFromDate	From date	Date (StartDate)	BOM.FromDate
ValidToDate	To date	Date (EndDate)	BOM.ToDate
VariableScrapPercentage	Variable scrap	Real (ScrapVar)	BOM.ScrapVar
ConstantScrapQuantity	Constant scrap	Real (ScrapConst)	BOM.ScrapConst
RouteOperationNumber	Oper. No.	Int (OprNumBOMLine)	BOM.OprNum
ConsumptionCalculationMethod	Formula	Enum BOMFormula	BOM.Formula
ConsumptionCalculationConstant	Constant	Real (BOMMeasureConstant)	BOM.Constant
ConsumptionType	Consumption is	Enum BOMConsumpType	BOM.BOMConsump
FlushingPrinciple	Flushing principle	Enum ProdFlushingPrincipBOM	BOM.ProdFlushingPrincip
IsResourceConsumptionUsed	Resource consumption	Enum boolean	BOM.WrkCtrConsumption
VendorAccountNumber	Vendor account	String (VendAccount)	BOM.VendId
SubBOMId	Sub-BOM	String (ItemBOMId)	BOM.ItemBOMId
SubRouteId	Subroute	String (ItemRouteId)	BOM.ItemRouteId

MGCLatticeCustomerCrossReferenceEntity

Customer cross references

Property	Value
OData entity set	LatticeCustomerCrossReferences (single: LatticeCustomerCrossReference)
Access	Read/write
Data management	Enabled (staging table MGCLatticeCustomerCrossReferenceStaging)
Company	Company-specific (DataAreaId)
Key	CustomerAccount, ExternalSystem
Data sources	CustTable, MGCLatticeCrossReference
Granted by	MGCLatticeCrossReferenceAccountsReceivableMaintain (full CRUD); MGCLatticeCrossReferenceAccountsReceivableView (read)

Field	Label	Type	Source	Mandatory
CustomerAccount (key)	Customer account	String (CustAccount)	CustTable.AccountNum	Yes
ExternalSystem (key)	External system	String (MGCLatticeExternalSystemId)	MGCLatticeCrossReference.ExternalSystemId	Yes
ExternalKey	External key	String (MGCLatticeExternalKey)	MGCLatticeCrossReference.ExternalKey	Yes

MGCLatticeEstimateProjectEntity

Estimate Projects

Property	Value
OData entity set	LatticeEstimateProjects (single: LatticeEstimateProject)
Access	Read/write
Data management	Enabled (staging table MGCLatticeEstimateProjectStaging)
Company	Company-specific (DataAreaId)
Key	EstimateProjectId
Data sources	ProjWIPTable
Configuration key	Project
Granted by	MGCLatticeEstimateProjectEntityMaintain (full CRUD); MGCLatticeEstimateProjectEntityView (read)

Field	Label	Type	Source	Mandatory
EstimateProjectId (key)	Estimate project ID	String (ProjWipId)	ProjWIPTable.ProjId	Yes
Description	Description	String (Description)	ProjWIPTable.Description
CostTemplateId	Cost template	String (ProjControlId)	ProjWIPTable.ControlId
PeriodCode	Period code	String (ProjPeriodId)	ProjWIPTable.PeriodId
RevenueProfileId	Project cost and revenue profile ID	String (ProjRevenueProfileId)	ProjWIPTable.ProjRevenueProfileId
WIPEliminated	Eliminated	Enum NoYes	ProjWIPTable.WIPEliminated

MGCLatticeSetBasedAssetBookEntity

Fixed asset books (set-based)

Imports fixed asset books in bulk with set-based processing: new books for existing assets, defaulted from the asset group's book setup, and changes to books that are not acquired yet.

Property	Value
OData entity set	Not exposed over OData
Access	Read/write
Data management	Enabled (staging table MGCLatticeSetBasedAssetBookStaging)
Company	Company-specific (DataAreaId)
Key	FixedAssetNumber, BookId
Data sources	AssetBook
Configuration key	Asset
Granted by	MGCLatticeSetBasedAssetBookEntityMaintain (full CRUD); MGCLatticeSetBasedAssetBookEntityView (read)

Field	Label	Type	Source	Mandatory
FixedAssetNumber (key)	Fixed asset number	String (AssetId)	AssetBook.AssetId	Yes
BookId (key)	Book	String (AssetBookId)	AssetBook.BookId	Yes
Status	Status	Enum AssetStatus	AssetBook.Status
AcquisitionDate	Acquisition date	Date (AssetAcquisitionDate)	AssetBook.AcquisitionDate
AcquisitionPrice	Acquisition price	Real (AssetAcquisitionPrice)	AssetBook.AcquisitionPrice
ExpectedScrapValue	Expected scrap value	Real (AssetScrapValue)	AssetBook.ScrapValue
PlacedInService	Placed in service	Date (AssetUsedFromDate)	AssetBook.UsedFromDate
DepreciationStartDate	Depreciation run date	Date (AssetDepreciationStartDate)	AssetBook.DepreciationStartDate
ServiceLife	Service life	Real (AssetServiceLife)	AssetBook.ServiceLife
DepreciationProfileId	Depreciation profile	String (AssetDepreciationProfileId)	AssetBook.DepreciationProfile
AlternativeDepreciationProfileId	Alternative depreciation profile	String (AssetDepreciationAltProfileId)	AssetBook.DepreciationAltProfile
ExtraordinaryDepreciationProfileId	Extraordinary depreciation profile	String (AssetDepreciationExtProfileId)	AssetBook.DepreciationExtProfile
PostingProfileId	Posting profile	String (AssetPostingProfile)	AssetBook.PostingProfile
DepreciationConvention	Depreciation convention	Enum AssetDepreciationConvention	AssetBook.DepreciationConvention

MGCLatticeFixedAssetCrossReferenceEntity

Fixed asset cross references

Property	Value
OData entity set	LatticeFixedAssetCrossReferences (single: LatticeFixedAssetCrossReference)
Access	Read/write
Data management	Enabled (staging table MGCLatticeFixedAssetCrossReferenceStaging)
Company	Company-specific (DataAreaId)
Key	FixedAssetNumber, ExternalSystem
Data sources	AssetTable, MGCLatticeCrossReference
Granted by	MGCLatticeCrossReferenceFixedAssetsMaintain (full CRUD); MGCLatticeCrossReferenceFixedAssetsView (read)

Field	Label	Type	Source	Mandatory
FixedAssetNumber (key)	Fixed asset number	String (AssetId)	AssetTable.AssetId	Yes
ExternalSystem (key)	External system	String (MGCLatticeExternalSystemId)	MGCLatticeCrossReference.ExternalSystemId	Yes
ExternalKey	External key	String (MGCLatticeExternalKey)	MGCLatticeCrossReference.ExternalKey	Yes

MGCLatticeInventoryStatusEntity

Inventory Status

Property	Value
OData entity set	LatticeInventoryStatuses (single: LatticeInventoryStatus)
Access	Read/write
Data management	Enabled (staging table MGCLatticeInventoryStatusStaging)
Company	Company-specific (DataAreaId)
Key	InventoryStatusId
Data sources	WHSInventStatus
Configuration key	WHSandTMS
Granted by	MGCLatticeInventoryStatusEntityMaintain (full CRUD); MGCLatticeInventoryStatusEntityView (read)

Field	Label	Type	Source	Mandatory
InventoryStatusId (key)	Inventory status	String (WHSInventStatusId)	WHSInventStatus.InventStatusId	Yes
Name	Name	String (Name)	WHSInventStatus.Name
IsBlocking	Inventory blocking	Enum NoYes	WHSInventStatus.InventStatusBlocking

MGCLatticeItemPurchOrderSetupEntity

Item Purchase Order Setup

Property	Value
OData entity set	LatticeItemPurchaseOrderSetups (single: LatticeItemPurchaseOrderSetup)
Access	Read/write
Data management	Enabled (staging table MGCLatticeItemPurchOrderSetupStaging)
Company	Company-specific (DataAreaId)
Key	ItemNumber, InventoryDimensionId
Data sources	InventItemPurchSetup
Configuration key	LogisticsBasic
Granted by	MGCLatticeItemPurchOrderSetupEntityMaintain (full CRUD); MGCLatticeItemPurchOrderSetupEntityView (read)

Field	Label	Type	Source	Mandatory
ItemNumber (key)	Item number	String (ItemId)	InventItemPurchSetup.ItemId	Yes
InventoryDimensionId (key)	Dimension number	String (InventDimId)	InventItemPurchSetup.InventDimId	Yes
PurchaseLeadTime	Purchase lead time	Int (LeadTimePurchDefault)	InventItemPurchSetup.LeadTime
LeadTimeInCalendarDays	Working days	Enum NoYes	InventItemPurchSetup.CalendarDays
MultipleQuantity	Multiple	Real (QtyMultiples)	InventItemPurchSetup.MultipleQty
StandardQuantity	Standard order quantity	Real (QtyStandard)	InventItemPurchSetup.StandardQty
MaximumQuantity	Max. order quantity	Real (QtyHighest)	InventItemPurchSetup.HighestQty
MinimumQuantity	Min. order quantity	Real (QtyLowest)	InventItemPurchSetup.LowestQty
IsSiteMandatory	Mandatory site	Enum NoYes	InventItemPurchSetup.MandatoryInventSite
IsWarehouseMandatory	Mandatory warehouse	Enum NoYes	InventItemPurchSetup.MandatoryInventLocation
IsOverride	Override default settings	Enum NoYes	InventItemPurchSetup.Override
IsStopped	Stopped	Enum NoYes	InventItemPurchSetup.Stopped

MGCLatticeItemSalesOrderSetupEntity

Item Sales Order Setup

Property	Value
OData entity set	LatticeItemSalesOrderSetups (single: LatticeItemSalesOrderSetup)
Access	Read/write
Data management	Enabled (staging table MGCLatticeItemSalesOrderSetupStaging)
Company	Company-specific (DataAreaId)
Key	ItemNumber, InventoryDimensionId
Data sources	InventItemSalesSetup
Granted by	MGCLatticeItemSalesOrderSetupEntityMaintain (full CRUD); MGCLatticeItemSalesOrderSetupEntityView (read)

Field	Label	Type	Source	Mandatory
ItemNumber (key)	Item number	String (ItemId)	InventItemSalesSetup.ItemId	Yes
InventoryDimensionId (key)	Dimension number	String (InventDimId)	InventItemSalesSetup.InventDimId	Yes
SalesLeadTime	Sales lead time	Int (LeadTimeSalesDefault)	InventItemSalesSetup.LeadTime
OverrideSalesLeadTime	Override sales lead time	Enum NoYes	InventItemSalesSetup.OverrideSalesLeadTime
DeliveryDateControlType	Delivery date control	Enum SalesDeliveryDateControlType	InventItemSalesSetup.DeliveryDateControlType
ATPTimeFence	ATP time fence	Int (SalesATPTimeFence)	InventItemSalesSetup.ATPTimeFence
ATPIncludePlannedOrders	ATP incl. planned orders	Enum boolean	InventItemSalesSetup.ATPInclPlannedOrders
MultipleQuantity	Multiple	Real (QtyMultiples)	InventItemSalesSetup.MultipleQty
StandardQuantity	Standard order quantity	Real (QtyStandard)	InventItemSalesSetup.StandardQty
IsSiteMandatory	Mandatory site	Enum NoYes	InventItemSalesSetup.MandatoryInventSite
IsWarehouseMandatory	Mandatory warehouse	Enum NoYes	InventItemSalesSetup.MandatoryInventLocation
IsStopped	Stopped	Enum NoYes	InventItemSalesSetup.Stopped

MGCLatticeProductVariantCrossReferenceEntity

Product variant cross references

Property	Value
OData entity set	LatticeProductVariantCrossReferences (single: LatticeProductVariantCrossReference)
Access	Read/write
Data management	Enabled (staging table MGCLatticeProductVariantCrossReferenceStaging)
Company	Company-specific (DataAreaId)
Key	ItemNumber, ProductConfigurationId, ProductSizeId, ProductColorId, ProductStyleId, ProductVersionId, ExternalSystem
Data sources	InventDim, MGCLatticeCrossReference, InventDimCombination
Granted by	MGCLatticeCrossReferenceInventoryMaintain (full CRUD); MGCLatticeCrossReferenceInventoryView (read)

Field	Label	Type	Source	Mandatory
ItemNumber (key)	Item number	String (ItemId)	InventDimCombination.ItemId	Yes
ProductConfigurationId (key)	Configuration	String (EcoResItemConfigurationName)	InventDim.configId
ProductSizeId (key)	Size	String (EcoResItemSizeName)	InventDim.InventSizeId
ProductColorId (key)	Color	String (EcoResItemColorName)	InventDim.InventColorId
ProductStyleId (key)	Style	String (EcoResItemStyleName)	InventDim.InventStyleId
ProductVersionId (key)	Version	String (EcoResItemVersionName)	InventDim.InventVersionId
ExternalSystem (key)	External system	String (MGCLatticeExternalSystemId)	MGCLatticeCrossReference.ExternalSystemId	Yes
ExternalKey	External key	String (MGCLatticeExternalKey)	MGCLatticeCrossReference.ExternalKey	Yes

MGCLatticeProjectContractCrossReferenceEntity

Project contract cross references

Property	Value
OData entity set	LatticeProjectContractCrossReferences (single: LatticeProjectContractCrossReference)
Access	Read/write
Data management	Enabled (staging table MGCLatticeProjectContractCrossReferenceStaging)
Company	Company-specific (DataAreaId)
Key	ProjectContractId, ExternalSystem
Data sources	ProjInvoiceTable, MGCLatticeCrossReference
Granted by	MGCLatticeCrossReferenceProjectsMaintain (full CRUD); MGCLatticeCrossReferenceProjectsView (read)

Field	Label	Type	Source	Mandatory
ProjectContractId (key)	Project contract ID	String (ProjInvoiceProjId)	ProjInvoiceTable.ProjInvoiceProjId	Yes
ExternalSystem (key)	External system	String (MGCLatticeExternalSystemId)	MGCLatticeCrossReference.ExternalSystemId	Yes
ExternalKey	External key	String (MGCLatticeExternalKey)	MGCLatticeCrossReference.ExternalKey	Yes

MGCLatticeProjectCrossReferenceEntity

Project cross references

Property	Value
OData entity set	LatticeProjectCrossReferences (single: LatticeProjectCrossReference)
Access	Read/write
Data management	Enabled (staging table MGCLatticeProjectCrossReferenceStaging)
Company	Company-specific (DataAreaId)
Key	ProjectId, ExternalSystem
Data sources	ProjTable, MGCLatticeCrossReference
Granted by	MGCLatticeCrossReferenceProjectsMaintain (full CRUD); MGCLatticeCrossReferenceProjectsView (read)

Field	Label	Type	Source	Mandatory
ProjectId (key)	Project ID	String (ProjId)	ProjTable.ProjId	Yes
ExternalSystem (key)	External system	String (MGCLatticeExternalSystemId)	MGCLatticeCrossReference.ExternalSystemId	Yes
ExternalKey	External key	String (MGCLatticeExternalKey)	MGCLatticeCrossReference.ExternalKey	Yes

MGCLatticeReleasedProductEntity

Released Product

Property	Value
OData entity set	LatticeReleasedProducts (single: LatticeReleasedProduct)
Access	Read-only
Data management	Enabled (staging table MGCLatticeReleasedProductStaging)
Company	Company-specific (DataAreaId)
Key	ItemNumber
Data sources	EcoResProductTranslation, InventTable, InventTableModule
Granted by	MGCLatticeReleasedProductEntityMaintain (read); MGCLatticeReleasedProductEntityView (read)

Field	Label	Type	Source	Mandatory
ItemNumber (key)	Item number	String (ItemId)	InventTable.ItemId	Yes
SearchName	Search name	String (ItemNameAlias)	InventTable.NameAlias
ProductType	Item type	Enum ItemType	InventTable.ItemType
InventoryUnitSymbol	Unit	String (UnitOfMeasureSymbol)	InventTableModule.UnitId
ProductName	Product name	String (EcoResProductName)	EcoResProductTranslation.Name
ProductDescription	Description	String (EcoResDescription)	EcoResProductTranslation.Description

MGCLatticeReleasedProductCrossReferenceEntity

Released product cross references

Property	Value
OData entity set	LatticeReleasedProductCrossReferences (single: LatticeReleasedProductCrossReference)
Access	Read/write
Data management	Enabled (staging table MGCLatticeReleasedProductCrossReferenceStaging)
Company	Company-specific (DataAreaId)
Key	ItemNumber, ExternalSystem
Data sources	InventTable, MGCLatticeCrossReference
Granted by	MGCLatticeCrossReferenceInventoryMaintain (full CRUD); MGCLatticeCrossReferenceInventoryView (read)

Field	Label	Type	Source	Mandatory
ItemNumber (key)	Item number	String (ItemId)	InventTable.ItemId	Yes
ExternalSystem (key)	External system	String (MGCLatticeExternalSystemId)	MGCLatticeCrossReference.ExternalSystemId	Yes
ExternalKey	External key	String (MGCLatticeExternalKey)	MGCLatticeCrossReference.ExternalKey	Yes

MGCLatticeRouteCrossReferenceEntity

Route cross references

Property	Value
OData entity set	LatticeRouteCrossReferences (single: LatticeRouteCrossReference)
Access	Read/write
Data management	Enabled (staging table MGCLatticeRouteCrossReferenceStaging)
Company	Company-specific (DataAreaId)
Key	RouteId, ExternalSystem
Data sources	RouteTable, MGCLatticeCrossReference
Granted by	MGCLatticeCrossReferenceProductionMaintain (full CRUD); MGCLatticeCrossReferenceProductionView (read)

Field	Label	Type	Source	Mandatory
RouteId (key)	Route number	String (RouteId)	RouteTable.RouteId	Yes
ExternalSystem (key)	External system	String (MGCLatticeExternalSystemId)	MGCLatticeCrossReference.ExternalSystemId	Yes
ExternalKey	External key	String (MGCLatticeExternalKey)	MGCLatticeCrossReference.ExternalKey	Yes

MGCLatticeRouteVersionCrossReferenceEntity

Route version cross references

Property	Value
OData entity set	LatticeRouteVersionCrossReferences (single: LatticeRouteVersionCrossReference)
Access	Read/write
Data management	Enabled (staging table MGCLatticeRouteVersionCrossReferenceStaging)
Company	Company-specific (DataAreaId)
Key	ItemNumber, RouteId, ProductionSiteId, ProductConfigurationId, ProductColorId, ProductSizeId, ProductStyleId, ProductVersionId, IsActive, ValidFromDate, ValidFromQuantity, ExternalSystem
Data sources	InventDim, MGCLatticeCrossReference, RouteVersion
Granted by	MGCLatticeCrossReferenceProductionMaintain (full CRUD); MGCLatticeCrossReferenceProductionView (read)

Field	Label	Type	Source	Mandatory
ItemNumber (key)	Item number	String (ItemIdProduction)	RouteVersion.ItemId	Yes
RouteId (key)	Route number	String (RouteId)	RouteVersion.RouteId	Yes
ProductionSiteId (key)	Site	String (InventSiteId)	InventDim.InventSiteId	Yes
ProductConfigurationId (key)	Configuration	String (EcoResItemConfigurationName)	InventDim.configId
ProductColorId (key)	Color	String (EcoResItemColorName)	InventDim.InventColorId
ProductSizeId (key)	Size	String (EcoResItemSizeName)	InventDim.InventSizeId
ProductStyleId (key)	Style	String (EcoResItemStyleName)	InventDim.InventStyleId
ProductVersionId (key)	Version	String (EcoResItemVersionName)	InventDim.InventVersionId
IsActive (key)	Active	Enum NoYes	RouteVersion.Active
ValidFromDate (key)	From date	Date (FromDate)	RouteVersion.FromDate
ValidFromQuantity (key)	From qty.	Real (ProductFromQuantity)	RouteVersion.FromQty
ExternalSystem (key)	External system	String (MGCLatticeExternalSystemId)	MGCLatticeCrossReference.ExternalSystemId	Yes
ExternalKey	External key	String (MGCLatticeExternalKey)	MGCLatticeCrossReference.ExternalKey	Yes

MGCLatticeVendorCrossReferenceEntity

Vendor cross references

Property	Value
OData entity set	LatticeVendorCrossReferences (single: LatticeVendorCrossReference)
Access	Read/write
Data management	Enabled (staging table MGCLatticeVendorCrossReferenceStaging)
Company	Company-specific (DataAreaId)
Key	VendorAccountNumber, ExternalSystem
Data sources	VendTable, MGCLatticeCrossReference
Granted by	MGCLatticeCrossReferenceProcurementMaintain (full CRUD); MGCLatticeCrossReferenceProcurementView (read)

Field	Label	Type	Source	Mandatory
VendorAccountNumber (key)	Vendor account	String (VendAccount)	VendTable.AccountNum	Yes
ExternalSystem (key)	External system	String (MGCLatticeExternalSystemId)	MGCLatticeCrossReference.ExternalSystemId	Yes
ExternalKey	External key	String (MGCLatticeExternalKey)	MGCLatticeCrossReference.ExternalKey	Yes

Parameters entities

MGCLatticeGeneralLedgerParametersEntity

General Ledger Parameters

Property	Value
OData entity set	LatticeGeneralLedgerParameters (single: LatticeGeneralLedgerParameter)
Access	Read/write
Data management	Enabled (staging table MGCLatticeGeneralLedgerParametersStaging)
Company	Company-specific (DataAreaId)
Key	GeneralLedgerParametersKey
Data sources	LedgerParameters
Configuration key	LedgerBasic
Granted by	MGCLatticeGeneralLedgerParametersEntityMaintain (full CRUD); MGCLatticeGeneralLedgerParametersEntityView (read)

Field	Label	Type	Source	Mandatory
GeneralLedgerParametersKey (key)	ID	Int (ParametersKey)	LedgerParameters.Key
CheckVoucher	Check for voucher used	Enum ReuseVoucher	LedgerParameters.CheckVoucher
CheckContinuous	Check continuous numbers	Enum NoYes	LedgerParameters.CheckContinuous
CheckJournalizing	Check journalizing	Enum NoYes	LedgerParameters.CheckJournalizing
DeleteOpening	Delete close-of-year transactions during transfer	Enum NoYes	LedgerParameters.DeleteOpening
DimensionValuesUsedForSummaryAccount	Values used for summary account	Enum DimensionValuesToUseForSummaryAccount	LedgerParameters.DimensionValuesUsedForSummaryAccount
AbortErrorAccount	Interrupt in case of error account	Enum NoYes	LedgerParameters.AbortErrorAccount
MaxRoundingDifferenceMST	Maximum penny difference	Real (AmountMST)	LedgerParameters.MaxRoundingDifferenceMST
MaxRoundingDifferenceMSTSecond	Maximum penny-rounding in the reporting currency	Real (AmountMSTSecondary)	LedgerParameters.MaxRoundingDifferenceMSTSecond
JournalizeSortorder	Extended ledger journal	Enum NoYes	LedgerParameters.JournalizeSortorder
JournalizePageOrder	Start journalizing report at page one	Enum NoYes	LedgerParameters.JournalizePageOrder
PeriodClosingPosting	Create closing transactions during transfer	Enum NoYes	LedgerParameters.PeriodClosingPosting
JournalizingDefinitionEnableValue	Use posting definitions	Enum NoYes	LedgerParameters.JournalizingDefinitionEnableValue
ReverseOppositeSignAmounts	Reverse opposite sign amounts	Enum NoYes	LedgerParameters.ReverseOppositeSignAmounts
OpeningVoucher	Voucher number must be filled in	Enum NoYes	LedgerParameters.OpeningVoucher
JournalSortingDirection	Journal sorting direction	Enum AscendingDescending	LedgerParameters.JournalSortingDirection

MGCLatticeInventoryParametersEntity

Inventory Parameters

Property	Value
OData entity set	LatticeInventoryParameters (single: LatticeInventoryParameter)
Access	Read/write
Data management	Enabled (staging table MGCLatticeInventoryParametersStaging)
Company	Company-specific (DataAreaId)
Key	InventoryParametersKey
Data sources	InventParameters
Configuration key	LogisticsBasic
Granted by	MGCLatticeInventoryParametersEntityMaintain (full CRUD); MGCLatticeInventoryParametersEntityView (read)

Field	Label	Type	Source	Mandatory
InventoryParametersKey (key)	ID	Int (ParametersKey)	InventParameters.Key
DefaultUnitId	Unit	String (UnitOfMeasureSymbol)	InventParameters.DefaultUnitId
MultiSiteDefaultInventLocationId	Warehouse	String (InventLocationId)	InventParameters.MultiSiteDefaultInventLocationId
FallbackInventLocationId	Fallback warehouse	String (InventFallbackInventLocationId)	InventParameters.FallbackInventLocationId
CountJournalNameId	Counting	String (InventJournalNameCount)	InventParameters.CountJournalNameId
EnableLedgerAcctSites	Separate ledger accounts of inventory value by sites	Enum NoYes	InventParameters.EnableLedgerAcctSites
AutoEndOrderPick	End output inventory order	Enum NoYes	InventParameters.AutoEndOrderPick
CostBreakdown	Cost breakdown	Enum CostBreakdown	InventParameters.CostBreakdown

MGCLatticeProcurementParametersEntity

Procurement Parameters

Property	Value
OData entity set	LatticeProcurementParameters (single: LatticeProcurementParameter)
Access	Read/write
Data management	Enabled (staging table MGCLatticeProcurementParametersStaging)
Company	Company-specific (DataAreaId)
Key	ProcurementParametersKey
Data sources	PurchParameters
Configuration key	LogisticsBasic
Granted by	MGCLatticeProcurementParametersEntityMaintain (full CRUD); MGCLatticeProcurementParametersEntityView (read)

Field	Label	Type	Source	Mandatory
ProcurementParametersKey (key)	ID	Int (ParametersKey)	PurchParameters.Key
PurchaseType	Purchase type	Enum PurchaseType	PurchParameters.PurchaseType
PurchasePoolId	Purchase pool	String (PurchPoolId)	PurchParameters.PurchPoolId
ReturnActionDefault	Return action default	String (PurchReturnActionId)	PurchParameters.ReturnActionDefault
PrintAmountOnPurchaseOrder	Purchase order prices/amount	Enum NoYes	PurchParameters.PrintAmountOnPurchaseOrder
ChangeRequestEnabled	Activate change management	Enum NoYes	PurchParameters.ChangeRequestEnabled
ChangeRequestAllowOverride	Allow override of settings per vendor	Enum NoYes	PurchParameters.ChangeRequestAllowOverride
PricesDiscount	Discount	Enum LineMultiLn	PurchParameters.Disc
MarkupHeading	Find auto charges for header	Enum NoYes	PurchParameters.MarkupHeading
MarkupLine	Find auto charges for line	Enum NoYes	PurchParameters.MarkupLine
PriceDateType	Date type	Enum PurchPriceDateType	PurchParameters.PriceDateType
PurchaseCycle	Purchase cycle	Enum NoYes	PurchParameters.PurchaseCycle
IntercompanyAgreementAutoSearch	Find purchase agreements	Enum NoYes	PurchParameters.IntercompanyAgreementAutoSearch
CheckPackingSlip	Check for product receipt number used	Enum ReuseVoucher	PurchParameters.CheckPackingSlip
OverDelivery	Accept overdelivery	Enum NoYes	PurchParameters.OverDelivery
UnderDelivery	Accept underdelivery	Enum NoYes	PurchParameters.SubDelivery
ProductReceiptCharges	Generate charges on product receipt	Enum NoYes	PurchParameters.ProductReceiptCharges
SummaryUpdateBy	Default values for summary update	Enum AccountOrder	PurchParameters.SummaryUpdateBy
SummaryErrorTolerance	Order error tolerance	Enum ErrorTolerance	PurchParameters.SummaryErrorTolerance
Include3WayMatch	Include three-way match	Enum NoYes	PurchParameters.Include3wayMatch
AutomaticTotalDiscount	Calculate total discount on posting	Enum NoYes	PurchParameters.AutomaticTotalDiscount
EnableMarginAlert	Enable margin alert	Enum NoYes	PurchParameters.MCREnableMarginAlert

MGCLatticeSalesParametersEntity

Sales Parameters

Property	Value
OData entity set	LatticeSalesParameters (single: LatticeSalesParameter)
Access	Read/write
Data management	Enabled (staging table MGCLatticeSalesParametersStaging)
Company	Company-specific (DataAreaId)
Key	SalesParametersKey
Data sources	SalesParameters
Configuration key	LogisticsBasic
Granted by	MGCLatticeSalesParametersEntityMaintain (full CRUD); MGCLatticeSalesParametersEntityView (read)

Field	Label	Type	Source	Mandatory
SalesParametersKey (key)	ID	Int (ParametersKey)	SalesParameters.Key
CancelSales	Mark order as voided	Enum NoYes	SalesParameters.CancelSales
DeleteLine	Delete order line invoiced in total	Enum NoYes	SalesParameters.DeleteLine
DeleteHeading	Delete order after invoicing	Enum NoYes	SalesParameters.DeleteHeading
Delivery2Invoice	Time between shipping date and invoice date	String (Delivery2Invoice)	SalesParameters.Delivery2Invoice
CustQuotationTypeId	Quotation type customer	String (SalesQuotationTypeId)	SalesParameters.CustQuotationTypeId
ATPTimeFence	ATP time fence	Int (SalesATPTimeFence)	SalesParameters.ATPTimeFence
ATPIncludePlannedOrders	ATP incl. planned orders	Enum boolean	SalesParameters.ATPInclPlannedOrders
BillOfLading	Bill of lading	Enum SalesShipping	SalesParameters.BillOfLading

Reference entities

MGCLatticeExternalSystemEntity

External systems

Property	Value
OData entity set	LatticeExternalSystems (single: LatticeExternalSystem)
Access	Read/write
Data management	Enabled (staging table MGCLatticeExternalSystemStaging)
Company	Shared across companies
Key	ExternalSystemId
Data sources	MGCLatticeExternalSystem
Granted by	MGCLatticeExternalSystemMaintain (full CRUD); MGCLatticeExternalSystemView (read)

Field	Label	Type	Source	Mandatory
ExternalSystemId (key)	External system	String (MGCLatticeExternalSystemId)	MGCLatticeExternalSystem.ExternalSystemId	Yes
Description	Description	String (Description)	MGCLatticeExternalSystem.Description
Active	Active	Enum NoYes	MGCLatticeExternalSystem.Active

MGCLatticeItemGroupAssignmentEntity

Item Group Assignment

Property	Value
OData entity set	LatticeItemGroupAssignments (single: LatticeItemGroupAssignment)
Access	Read/write
Data management	Enabled (staging table MGCLatticeItemGroupAssignmentStaging)
Company	Company-specific (ItemDataAreaId)
Key	ItemNumber, ItemDataAreaId
Data sources	InventItemGroupItem
Configuration key	LogisticsBasic
Granted by	MGCLatticeItemGroupAssignmentEntityMaintain (full CRUD); MGCLatticeItemGroupAssignmentEntityView (read)

Field	Label	Type	Source	Mandatory
ItemNumber (key)	Item number	String (ItemId)	InventItemGroupItem.ItemId	Yes
ItemDataAreaId (key)	Company for item	String (DataAreaId)	InventItemGroupItem.ItemDataAreaId	Yes
ItemGroupId	Item group	String (ItemGroupId)	InventItemGroupItem.ItemGroupId
ItemGroupDataAreaId	Company for item group	String (DataAreaId)	InventItemGroupItem.ItemGroupDataAreaId

MGCLatticeItemModelGroupAssignmentEntity

Item Model Group Assignment

Property	Value
OData entity set	LatticeItemModelGroupAssignments (single: LatticeItemModelGroupAssignment)
Access	Read/write
Data management	Enabled (staging table MGCLatticeItemModelGroupAssignmentStaging)
Company	Company-specific (ItemDataAreaId)
Key	ItemNumber, ItemDataAreaId
Data sources	InventModelGroupItem
Granted by	MGCLatticeItemModelGroupAssignmentEntityMaintain (full CRUD); MGCLatticeItemModelGroupAssignmentEntityView (read)

Field	Label	Type	Source	Mandatory
ItemNumber (key)	Item number	String (ItemId)	InventModelGroupItem.ItemId	Yes
ItemDataAreaId (key)	Company for item	String (DataAreaId)	InventModelGroupItem.ItemDataAreaId	Yes
ModelGroupId	Item model group	String (InventModelGroupId)	InventModelGroupItem.ModelGroupId
ModelGroupDataAreaId	Company for item model group	String (DataAreaId)	InventModelGroupItem.ModelGroupDataAreaId

MGCLatticeItemSalesTaxGroupTaxCodeEntity

Item Sales Tax Group Tax Code

Property	Value
OData entity set	LatticeItemSalesTaxGroupTaxCodes (single: LatticeItemSalesTaxGroupTaxCode)
Access	Read/write
Data management	Enabled (staging table MGCLatticeItemSalesTaxGroupTaxCodeStaging)
Company	Company-specific (DataAreaId)
Key	ItemSalesTaxGroup, TaxCode
Data sources	TaxOnItem
Granted by	MGCLatticeItemSalesTaxGroupTaxCodeEntityMaintain (full CRUD); MGCLatticeItemSalesTaxGroupTaxCodeEntityView (read)

Field	Label	Type	Source	Mandatory
ItemSalesTaxGroup (key)	Item sales tax group	String (TaxItemGroup)	TaxOnItem.TaxItemGroup	Yes
TaxCode (key)	Sales tax code	String (TaxCode)	TaxOnItem.TaxCode	Yes
TaxExemptCode	Exempt code	String (TaxExemptCode_BR)	TaxOnItem.TaxExemptCode

MGCLatticeWarehouseLocationTypeEntity

Warehouse Location Type

Property	Value
OData entity set	LatticeWarehouseLocationTypes (single: LatticeWarehouseLocationType)
Access	Read/write
Data management	Enabled (staging table MGCLatticeWarehouseLocationTypeStaging)
Company	Company-specific (DataAreaId)
Key	LocationType
Data sources	WHSLocationType
Granted by	MGCLatticeWarehouseLocationTypeEntityMaintain (full CRUD); MGCLatticeWarehouseLocationTypeEntityView (read)

Field	Label	Type	Source	Mandatory
LocationType (key)	Location type	String (WHSLocType)	WHSLocationType.LocType	Yes
Description	Description	String (Description)	WHSLocationType.Description

Transaction entities

MGCLatticeAsyncOperationTrackingEntity

Async Operation Tracking Entity

Read-only OData entity exposing the MGCLatticeAsyncOperationTracking table for monitoring asynchronous operation status and results.

Property	Value
OData entity set	LatticeAsyncOperationTrackingRecords (single: LatticeAsyncOperationTracking)
Access	Read-only
Data management	Not enabled
Company	Shared across companies
Key	TrackingId
Data sources	MGCLatticeAsyncOperationTracking
Granted by	MGCLatticeAsyncOperationTrackingEntityView (read)

Field	Label	Type	Source	Mandatory
TrackingId (key)	Tracking ID	Guid (MGCLatticeTrackingId)	MGCLatticeAsyncOperationTracking.TrackingId
RequestId	Request ID	Guid (MGCLatticeRequestId)	MGCLatticeAsyncOperationTracking.RequestId
CorrelationId	Correlation ID	Guid (MGCLatticeCorrelationId)	MGCLatticeAsyncOperationTracking.CorrelationId
ServiceName	Service	String (MGCLatticeServiceName)	MGCLatticeAsyncOperationTracking.ServiceName
OperationName	Operation	String (MGCLatticeOperationName)	MGCLatticeAsyncOperationTracking.OperationName
LegalEntityId	Legal entity	String (DataAreaId)	MGCLatticeAsyncOperationTracking.LegalEntityId
UserContext	User context	String (UserId)	MGCLatticeAsyncOperationTracking.UserContext
SubmittedBy	Created by	String (CreatedBy)	MGCLatticeAsyncOperationTracking.CreatedBy
Status	Status	Enum MGCLatticeAsyncOperationStatus	MGCLatticeAsyncOperationTracking.Status
SubmittedDateTimeUtc	Submitted time	UtcDateTime (TransDateTime)	MGCLatticeAsyncOperationTracking.SubmittedDateTimeUtc
CompletedDateTimeUtc	Completed time	UtcDateTime (TransDateTime)	MGCLatticeAsyncOperationTracking.CompletedDateTimeUtc
DocumentId	Document ID	String (MGCLatticeDocumentId)	MGCLatticeAsyncOperationTracking.DocumentId
PostedDocumentId	Posted document	String (MGCLatticeDocumentId)	MGCLatticeAsyncOperationTracking.PostedDocumentId
ErrorCode	Error code	Enum MGCLatticeServiceErrorCode	MGCLatticeAsyncOperationTracking.ErrorCode
Message	Message	String (MGCLatticeLogMessageShort)	MGCLatticeAsyncOperationTracking.Message
ErrorDetails	Error details	String (MGCLatticeSamplePayload)	MGCLatticeAsyncOperationTracking.ErrorDetails
RequestPayload	Request payload	String (MGCLatticeSamplePayload)	MGCLatticeAsyncOperationTracking.RequestPayload
BatchJobId	Batch job ID	Int64 (MGCLatticeBatchJobId)	MGCLatticeAsyncOperationTracking.BatchJobId

MGCLatticeBankAccountTransactionEntity

Bank account transactions

Property	Value
OData entity set	LatticeBankAccountTransactions (single: LatticeBankAccountTransaction)
Access	Read-only
Data management	Enabled (staging table MGCLatticeBankAccountTransactionStaging)
Company	Company-specific (DataAreaId)
Key	SysRecId
Data sources	BankAccountTrans, BankAccountTable
Granted by	MGCLatticeBankAccountTransactionEntityMaintain (read); MGCLatticeBankAccountTransactionEntityView (read)

Field	Label	Type	Source	Mandatory
BankAccountId	Bank account	String (CompanyBankAccountId)	BankAccountTrans.AccountId	Yes
TransactionDate	Date	Date (TransDate)	BankAccountTrans.TransDate
Voucher	Voucher number	String (Voucher)	BankAccountTrans.Voucher
BankTransactionType	Bank transaction type	String (BankTransactionType)	BankAccountTrans.BankTransType
TransactionText	Description	String (TransactionTextLarge)	BankAccountTrans.Txt
Reconciled	Reconciled	Enum NoYes	BankAccountTrans.Reconciled
AccountingCurrencyAmount	Amount	Real (AmountMST)	BankAccountTrans.AmountMST
AmountCurrency	Amount in transaction currency	Real (AmountCur)	BankAccountTrans.AmountCur
CurrencyCode	Currency	String (CurrencyCode)	BankAccountTrans.CurrencyCode	Yes
BankAccountName	Name	String (Name)	BankAccountTable.Name
SysRecId (key)	Record ID	Int64 (RecId)	BankAccountTrans.RecId

MGCLatticeCustomerSettlementEntity

Customer settlements

Property	Value
OData entity set	LatticeCustomerSettlements (single: LatticeCustomerSettlement)
Access	Read-only
Data management	Enabled (staging table MGCLatticeCustomerSettlementStaging)
Company	Company-specific (DataAreaId)
Key	SysRecId
Data sources	CustSettlement
Granted by	MGCLatticeCustomerSettlementEntityMaintain (read); MGCLatticeCustomerSettlementEntityView (read)

Field	Label	Type	Source	Mandatory
CustomerAccount	Account number	String (CustAccount)	CustSettlement.AccountNum
TransRecId	Reference	Int64 (CustSettleParentRecID)	CustSettlement.TransRecId
TransactionType	Transaction type	Enum LedgerTransType	CustSettlement.TransType
TransactionDate	Date of settlement	Date (TransDate)	CustSettlement.TransDate
DueDate	Due date	Date (DueDate)	CustSettlement.DueDate
ClosedDate	Closed date	Date (TransDate)	CustSettlement.ClosedDate
OffsetRecId	Reference	Int64 (CustTransRefRecId)	CustSettlement.OffsetRecid
OffsetVoucher	Offset voucher	String (Voucher)	CustSettlement.OffsetTransVoucher
OffsetAccountNum	Account	String (CustAccount)	CustSettlement.OffsetAccountNum
OffsetLegalEntityId	Company accounts	String (CompanyId)	CustSettlement.OffsetCompany
SettlementVoucher	Voucher	String (Voucher)	CustSettlement.SettlementVoucher
SettledAccountingCurrencyAmount	Amount settled	Real (AmountMST)	CustSettlement.SettleAmountMST
SettledTransactionCurrencyAmount	Settled currency	Real (AmountCur)	CustSettlement.SettleAmountCur
CanBeReversed		Enum NoYes	CustSettlement.CanBeReversed
TransactionLegalEntityId	Company accounts	String (CompanyId)	CustSettlement.TransCompany
SysRecId (key)	Record ID	Int64 (RecId)	CustSettlement.RecId

MGCLatticeCustomerTransactionEntity

Customer transactions

Property	Value
OData entity set	LatticeCustomerTransactions (single: LatticeCustomerTransaction)
Access	Read-only
Data management	Enabled (staging table MGCLatticeCustomerTransactionStaging)
Company	Company-specific (DataAreaId)
Key	SysRecId
Data sources	CustTrans
Granted by	MGCLatticeCustomerTransactionEntityMaintain (read); MGCLatticeCustomerTransactionEntityView (read)

Field	Label	Type	Source	Mandatory
CustomerAccount	Customer account	String (CustAccount)	CustTrans.AccountNum	Yes
Voucher	Voucher	String (Voucher)	CustTrans.Voucher	Yes
TransactionType	Transaction type	Enum LedgerTransType	CustTrans.TransType
TransactionDate	Date	Date (TransDate)	CustTrans.TransDate	Yes
DueDate	Due date	Date (DueDate)	CustTrans.DueDate
InvoiceId	Invoice	String (InvoiceId)	CustTrans.Invoice
DocumentNumber	Document	String (DocumentNum)	CustTrans.DocumentNum
PaymReference	Payment reference	String (CustPaymReference)	CustTrans.PaymReference
ClosedDate	Closed date	Date (TransDate)	CustTrans.Closed
AccountingCurrencyAmount	Amount	Real (AmountMSTDebCred)	CustTrans.AmountMST
TransactionCurrencyAmount	Amount in transaction currency	Real (AmountCurDebCred)	CustTrans.AmountCur
CurrencyCode	Currency	String (CustCurrencyCode)	CustTrans.CurrencyCode	Yes
SettledAccountingCurrencyAmount	Amount settled	Real (AmountMST)	CustTrans.SettleAmountMST
SettledTransactionCurrencyAmount	Settled currency	Real (AmountCur)	CustTrans.SettleAmountCur
RemainingAccountingCurrencyAmount	Remaining amount in accounting currency	Real (AmountMST)	Computed
RemainingTransactionCurrencyAmount	Remaining amount in transaction currency	Real (AmountCur)	Computed
SysRecId (key)	Record ID	Int64 (RecId)	CustTrans.RecId

MGCLatticeFileIngestLogEntity

File Ingestion Log Entity

Read-only OData entity exposing MGCLatticeFileIngestLog (file-ingestion log entries) for observability.

Property	Value
OData entity set	LatticeFileIngestLogs (single: LatticeFileIngestLog)
Access	Read-only
Data management	Not enabled
Company	Shared across companies
Key	FileIngestLogRecId
Data sources	MGCLatticeFileIngestLog
Granted by	MGCLatticeIntegrationObservabilityView (read)

Field	Label	Type	Source	Mandatory
FileIngestLogRecId (key)	Record ID	Int64 (RecId)	MGCLatticeFileIngestLog.RecId
LogLevel	Level	Enum MGCLatticeLogLevel	MGCLatticeFileIngestLog.LogLevel
ConnectionId	Connection ID	String (MGCLatticeConnectionId)	MGCLatticeFileIngestLog.ConnectionId
BundleId	Bundle ID	String (MGCLatticeBundleId)	MGCLatticeFileIngestLog.BundleId
SegmentId	Segment ID	Int64 (MGCLatticeSegmentId)	MGCLatticeFileIngestLog.SegmentId
Message	Message	String (DirMemo)	MGCLatticeFileIngestLog.Message
Details	Details	String (DirMemo)	MGCLatticeFileIngestLog.Details
LoggedDateTime	Created date and time	UtcDateTime	MGCLatticeFileIngestLog.CreatedDateTime

MGCLatticeFixedAssetTransactionEntity

Fixed asset transactions

Property	Value
OData entity set	LatticeFixedAssetTransactions (single: LatticeFixedAssetTransaction)
Access	Read-only
Data management	Enabled (staging table MGCLatticeFixedAssetTransactionStaging)
Company	Company-specific (DataAreaId)
Key	SysRecId
Data sources	AssetBookTable, AssetTrans
Granted by	MGCLatticeFixedAssetTransactionEntityMaintain (read); MGCLatticeFixedAssetTransactionEntityView (read)

Field	Label	Type	Source	Mandatory
AssetId	Fixed asset number	String (AssetId)	AssetTrans.AssetId
BookId	Book	String (AssetBookId)	AssetTrans.BookId
AssetTransType	Transaction type	Enum AssetTransType	AssetTrans.TransType
TransactionDate	Transaction date	Date (AssetTransDate)	AssetTrans.TransDate
Voucher	Voucher	String (Voucher)	AssetTrans.Voucher
PostingLayer	Posting layer	Enum CurrentOperationsTax	AssetBookTable.CurrentOperationsTax
TransactionText	Description	String (LedgerJournalTransTxt)	AssetTrans.Txt
AccountingCurrencyAmount	Amount	Real (AssetAmount)	AssetTrans.AmountMST
AmountCurrency	Amount in transaction currency	Real (AmountCur)	AssetTrans.AmountCur
CurrencyCode	Currency	String (CurrencyCode)	AssetTrans.CurrencyCode
Quantity	Consumption units	Real (AssetConsumption)	AssetTrans.ConsumptionQty
SysRecId (key)	Record ID	Int64 (RecId)	AssetTrans.RecId

MGCLatticeGeneralLedgerEntryEntity

General ledger entry

Property	Value
OData entity set	LatticeGeneralLedgerEntries (single: LatticeGeneralLedgerEntry)
Access	Read-only
Data management	Enabled (staging table MGCLatticeGeneralLedgerEntryStaging)
Company	Shared across companies
Key	SysRecId
Data sources	MainAccount, Ledger, GeneralJournalEntry, GeneralJournalAccountEntry, CompanyInfo, DimensionAttributeValueCombination
Granted by	MGCLatticeGeneralLedgerEntryEntityMaintain (read); MGCLatticeGeneralLedgerEntryEntityView (read)

Field	Label	Type	Source	Mandatory
SubledgerVoucher	Voucher	String (Voucher)	GeneralJournalEntry.SubledgerVoucher
AccountingDate	Date	Date (TransDate)	GeneralJournalEntry.AccountingDate	Yes
JournalNumber	Journal number	String (GeneralJournalEntryJournalNumber)	GeneralJournalEntry.JournalNumber	Yes
LegalEntityId	Legal entity	String (SelectableDataArea)	CompanyInfo.DataArea	Yes
PostingType	Posting type	Enum LedgerPostingType	GeneralJournalAccountEntry.PostingType
MainAccountId	Main account	String (MainAccountNum)	MainAccount.MainAccountId	Yes
LedgerDimensionDisplayValue	Ledger dimension display value	String (DimensionDisplayValue)	DimensionAttributeValueCombination.DisplayValue	Yes
Text	Description	String (TransactionTextLarge)	GeneralJournalAccountEntry.Text
TransactionCurrencyCode	Currency	String (CurrencyCode)	GeneralJournalAccountEntry.TransactionCurrencyCode
TransactionCurrencyAmount	Amount in transaction currency	Real (AmountCur)	GeneralJournalAccountEntry.TransactionCurrencyAmount
AccountingCurrencyAmount	Amount	Real (AmountMSTDebCred)	GeneralJournalAccountEntry.AccountingCurrencyAmount
ReportingCurrencyAmount	Amount in reporting currency	Real (AmountMSTSecondary)	GeneralJournalAccountEntry.ReportingCurrencyAmount
SysRecId (key)	Record ID	Int64 (RecId)	GeneralJournalAccountEntry.RecId

MGCLatticeIntegrationDeadLetterEntity

Integration Dead Letter Entity

Read-only OData entity exposing MGCLatticeIntegrationDeadLetter (the integration DLQ) for observability.

Property	Value
OData entity set	LatticeIntegrationDeadLetters (single: LatticeIntegrationDeadLetter)
Access	Read-only
Data management	Not enabled
Company	Shared across companies
Key	DeadLetterId
Data sources	MGCLatticeIntegrationDeadLetter
Granted by	MGCLatticeIntegrationObservabilityView (read)

Field	Label	Type	Source	Mandatory
DeadLetterId (key)	Dead-letter ID	Guid (MGCLatticeDeadLetterId)	MGCLatticeIntegrationDeadLetter.DeadLetterId	Yes
SourceType	Source	Enum MGCLatticeIntegrationDlqSource	MGCLatticeIntegrationDeadLetter.SourceType
SourceRefId	Source reference	String (MGCLatticeSourceReference)	MGCLatticeIntegrationDeadLetter.SourceRefId
ServiceName	Service	String (MGCLatticeServiceName)	MGCLatticeIntegrationDeadLetter.ServiceName
OperationName	Operation	String (MGCLatticeOperationName)	MGCLatticeIntegrationDeadLetter.OperationName
RequestId	Original request ID	Guid (MGCLatticeRequestId)	MGCLatticeIntegrationDeadLetter.RequestId
LegalEntityId	Legal Entity	String (DataAreaId)	MGCLatticeIntegrationDeadLetter.LegalEntityId
OriginalPayload	Original payload	String (DirMemo)	MGCLatticeIntegrationDeadLetter.OriginalPayload
EditedPayload	Edited payload	String (DirMemo)	MGCLatticeIntegrationDeadLetter.EditedPayload
ErrorCode	Error code	Enum MGCLatticeServiceErrorCode	MGCLatticeIntegrationDeadLetter.ErrorCode
ErrorCategory	Error category	Enum MGCLatticeServiceErrorCategory	MGCLatticeIntegrationDeadLetter.ErrorCategory
FailureMessage	Failure message	String (DirMemo)	MGCLatticeIntegrationDeadLetter.FailureMessage
IsRetryable	Retryable	Enum NoYes	MGCLatticeIntegrationDeadLetter.IsRetryable
AttemptCount	Attempts	Int (MGCLatticeAttemptCount)	MGCLatticeIntegrationDeadLetter.AttemptCount
MaxAttempts	Max attempts	Int (MGCLatticeAttemptCount)	MGCLatticeIntegrationDeadLetter.MaxAttempts
NextRetryDateTimeUtc	Next retry	UtcDateTime (UTCTimestamp)	MGCLatticeIntegrationDeadLetter.NextRetryDateTimeUtc
FirstFailedDateTimeUtc	First failed	UtcDateTime (UTCTimestamp)	MGCLatticeIntegrationDeadLetter.FirstFailedDateTimeUtc
LastAttemptDateTimeUtc	Last attempt	UtcDateTime (UTCTimestamp)	MGCLatticeIntegrationDeadLetter.LastAttemptDateTimeUtc
Status	Status	Enum MGCLatticeIntegrationDlqStatus	MGCLatticeIntegrationDeadLetter.Status
LastActionedBy	Last actioned by	String (UserId)	MGCLatticeIntegrationDeadLetter.LastActionedBy

MGCLatticeInventOnHandEntity

Inventory On-Hand

Property	Value
OData entity set	LatticeInventoryOnHands (single: LatticeInventoryOnHand)
Access	Read-only
Data management	Enabled (staging table MGCLatticeInventOnHandStaging)
Company	Company-specific (DataAreaId)
Key	ItemNumber, InventoryDimensionId
Data sources	InventDim, InventSum
Granted by	MGCLatticeInventOnHandEntityMaintain (read); MGCLatticeInventOnHandEntityView (read)

Field	Label	Type	Source	Mandatory
ItemNumber (key)	Item number	String (ItemId)	InventSum.ItemId	Yes
InventoryDimensionId (key)	Dimension number	String (InventDimId)	InventSum.InventDimId	Yes
PhysicalInventoryQuantity	Physical inventory	Real (InventQtyPhysicalOnhand)	InventSum.PhysicalInvent
PhysicalReservedQuantity	Physical reserved	Real (InventQtyReservPhysical)	InventSum.ReservPhysical
PickedQuantity	Picked	Real (InventQtyPicked)	InventSum.Picked
ReceivedQuantity	Received	Real (InventQtyReceived)	InventSum.Received
DeductedQuantity	Deducted	Real (InventQtyDeducted)	InventSum.Deducted
OnOrderQuantity	On order	Real (InventQtyOnOrder)	InventSum.OnOrder
OrderedQuantity	Ordered	Real (InventQtyOrdered)	InventSum.Ordered
InventorySiteId	Site	String (InventSiteId)	InventDim.InventSiteId
InventoryWarehouseId	Warehouse	String (InventLocationId)	InventDim.InventLocationId
WarehouseLocationId	Location	String (WMSLocationId)	InventDim.wMSLocationId
InventoryBatchId	Batch number	String (InventBatchId)	InventDim.InventBatchId
InventoryStatusId	Inventory status	String (WHSInventStatusId)	InventDim.InventStatusId
LicensePlateId	License plate	String (WHSLicensePlateId)	InventDim.LicensePlateId

MGCLatticeInventTransactionEntity

Inventory Transaction

Property	Value
OData entity set	LatticeInventoryTransactions (single: LatticeInventoryTransaction)
Access	Read-only
Data management	Enabled (staging table MGCLatticeInventTransactionStaging)
Company	Company-specific (DataAreaId)
Key	SysRecId
Data sources	InventDim, InventTransOrigin, InventTrans
Granted by	MGCLatticeInventTransactionEntityMaintain (read); MGCLatticeInventTransactionEntityView (read)

Field	Label	Type	Source	Mandatory
ItemNumber	Item number	String (ItemId)	InventTransOrigin.ItemId	Yes
InventoryLotId	Lot ID	String (InventTransId)	InventTransOrigin.InventTransId	Yes
ReferenceCategory	Reference	Enum InventTransType	InventTransOrigin.ReferenceCategory
StatusIssue	Issue status	Enum StatusIssue	InventTrans.StatusIssue
StatusReceipt	Receipt status	Enum StatusReceipt	InventTrans.StatusReceipt
DatePhysical	Physical date	Date (DatePhysical)	InventTrans.DatePhysical
DateFinancial	Financial date	Date (DateFinancial)	InventTrans.DateFinancial
PackingSlipId	Packing slip	String (PackingSlipId)	InventTrans.PackingSlipId
InvoiceId	Invoice	String (InvoiceId)	InventTrans.InvoiceId
Quantity	Quantity	Real (InventQty)	InventTrans.Qty
CostAmountPosted	Financial cost amount	Real (CostAmountPosted)	InventTrans.CostAmountPosted
CostAmountPhysical	Physical cost amount	Real (CostAmountPhysical)	InventTrans.CostAmountPhysical
InventoryDimensionId	Dimension number	String (InventDimId)	InventTrans.inventDimId	Yes
InventorySiteId	Site	String (InventSiteId)	InventDim.InventSiteId
InventoryWarehouseId	Warehouse	String (InventLocationId)	InventDim.InventLocationId
WarehouseLocationId	Location	String (WMSLocationId)	InventDim.wMSLocationId
InventoryBatchId	Batch number	String (InventBatchId)	InventDim.InventBatchId
InventorySerialId	Serial number	String (InventSerialId)	InventDim.inventSerialId
InventoryStatusId	Inventory status	String (WHSInventStatusId)	InventDim.InventStatusId
LicensePlateId	License plate	String (WHSLicensePlateId)	InventDim.LicensePlateId
SysRecId (key)	Record ID	Int64 (RecId)	InventTrans.RecId

MGCLatticeOpenPurchaseOrderLineEntity

Open purchase order line

Property	Value
OData entity set	LatticeOpenPurchaseOrderLines (single: LatticeOpenPurchaseOrderLine)
Access	Read-only
Data management	Enabled (staging table MGCLatticeOpenPurchaseOrderLineStaging)
Company	Company-specific (DataAreaId)
Key	PurchaseOrderNumber, LineNumber
Data sources	InventDim, PurchLine
Granted by	MGCLatticeOpenOrderLineEntityView (read)

Field	Label	Type	Source	Mandatory
PurchaseOrderNumber (key)	Purchase order	String (PurchIdBase)	PurchLine.PurchId	Yes
LineNumber (key)	Line number	Int64 (TradeLineNumber)	PurchLine.LineNumber
ItemNumber	Item number	String (ItemIdSmall)	PurchLine.ItemId
RemainingPurchaseQuantity	Deliver remainder	Real (PurchQty)	PurchLine.RemainPurchPhysical
PurchaseUnitSymbol	Unit	String (PurchUnit)	PurchLine.PurchUnit
RequestedReceiptDate	Requested receipt date	Date (PurchLineRequestedReceiptDate)	PurchLine.DeliveryDate
PurchaseStatus	Line status	Enum PurchStatus	PurchLine.PurchStatus
VendorAccountNumber	Vendor account	String (VendAccount)	PurchLine.VendAccount	Yes
ReceivingSiteId	Site	String (InventSiteId)	InventDim.InventSiteId
ReceivingWarehouseId	Warehouse	String (InventLocationId)	InventDim.InventLocationId

MGCLatticeOpenSalesOrderLineEntity

Open sales order line

Property	Value
OData entity set	LatticeOpenSalesOrderLines (single: LatticeOpenSalesOrderLine)
Access	Read-only
Data management	Enabled (staging table MGCLatticeOpenSalesOrderLineStaging)
Company	Company-specific (DataAreaId)
Key	InventoryLotId
Data sources	InventDim, SalesLine
Granted by	MGCLatticeOpenOrderLineEntityView (read)

Field	Label	Type	Source	Mandatory
SalesOrderNumber	Sales order	String (SalesIdBase)	SalesLine.SalesId
LineNumber	Line number	Real (LineNum)	SalesLine.LineNum
InventoryLotId (key)	Lot ID	String (TradeInventTransId)	SalesLine.InventTransId
ItemNumber	Item number	String (ItemIdSmall)	SalesLine.ItemId
RemainingSalesQuantity	Deliver remainder	Real (SalesQty)	SalesLine.RemainSalesPhysical
SalesUnitSymbol	Unit	String (SalesUnit)	SalesLine.SalesUnit
RequestedShippingDate	Requested ship date	Date (SalesShippingDateRequested)	SalesLine.ShippingDateRequested	Yes
SalesStatus	Line status	Enum SalesStatus	SalesLine.SalesStatus
CustomerAccount	Customer	String (CustAccount)	SalesLine.CustAccount	Yes
ShippingSiteId	Site	String (InventSiteId)	InventDim.InventSiteId
ShippingWarehouseId	Warehouse	String (InventLocationId)	InventDim.InventLocationId

MGCLatticeOpportunityEntity

Opportunity

Property	Value
OData entity set	LatticeOpportunities (single: LatticeOpportunity)
Access	Read/write
Data management	Enabled (staging table MGCLatticeOpportunityStaging)
Company	Company-specific (DataAreaId)
Key	OpportunityId
Data sources	smmOpportunityTable, DirPartyTable, HcmWorker
Configuration key	SmmCRM
Granted by	MGCLatticeOpportunityEntityMaintain (full CRUD); MGCLatticeOpportunityEntityView (read)

Field	Label	Type	Source	Mandatory
OpportunityId (key)	Opportunity ID	String (smmOpportunityId)	smmOpportunityTable.OpportunityId	Yes
Subject	Subject	String (smmOpportunitySubject)	smmOpportunityTable.Subject	Yes
PartyNumber	Party ID	String (DirPartyNumber)	DirPartyTable.PartyNumber	Yes
Status	Status	Enum smmOpportunityStatus	smmOpportunityTable.Status
SalesProcessName	Sales process	String (smmOpportunitySalesProcess)	smmOpportunityTable.ProcessName
ProbabilityId	Probability	Int (smmQuotationProbabilityId)	smmOpportunityTable.ProbabilityId
EstimatedRevenue	Estimated revenue	Real (smmOpportunityEstimatedRevenue)	smmOpportunityTable.EstimatedRevenue
OwnerPersonnelNumber	Personnel number	String (HcmPersonnelNumberId)	HcmWorker.PersonnelNumber
OpenedDate	Date opened	Date (smmOpportunityOpenedDate)	smmOpportunityTable.OpenedDate
PrognosisId	Prognosis	String (smmQuotationPrognosisId)	smmOpportunityTable.PrognosisId
SalesUnitId	Sales unit	String (smmSalesUnitId)	smmOpportunityTable.SalesUnitId
ClosedDate	Date closed	Date (smmOpportunityClosedDate)	smmOpportunityTable.ClosedDate

MGCLatticePaymentRequestEntity

Payment request

Property	Value
OData entity set	LatticePaymentRequests (single: LatticePaymentRequest)
Access	Read/write
Data management	Enabled (staging table MGCLatticePaymentRequestStaging)
Company	Company-specific (SourceDataAreaId)
Key	PaymentRequestId
Data sources	CFMPaymentRequestTable
Configuration key	CFMPaymentRequests
Granted by	MGCLatticePaymentRequestEntityMaintain (full CRUD); MGCLatticePaymentRequestEntityView (read)

Field	Label	Type	Source	Mandatory
PaymentRequestId (key)	Payment request	String (CFMPaymentRequestId)	CFMPaymentRequestTable.PaymentRequestId	Yes
DueDate	Due date	Date (DueDate)	CFMPaymentRequestTable.DueDate	Yes
PaymentDate	Payment date	Date (TransDate)	CFMPaymentRequestTable.PaymentDate
Status	Payment request status	Enum CFMPaymentRequestStatus	CFMPaymentRequestTable.Status
WorkflowStatus	Workflow status	Enum CFMPaymentRequestWorkflowStatus	CFMPaymentRequestTable.WorkflowStatus
AccountType	Account type	Enum CFMAccountType	CFMPaymentRequestTable.AccountType
AccountNumber	Account	String (CFMAccountNum)	CFMPaymentRequestTable.AccountNum	Yes
CurrencyCode	Currency	String (CurrencyCode)	CFMPaymentRequestTable.CurrencyCode	Yes
PaymentCurrency	Payment currency	String (CurrencyCode)	CFMPaymentRequestTable.PaymentCurrency
SourceDataAreaId	Payment request company	String (SelectableDataArea)	CFMPaymentRequestTable.SourceDataAreaId	Yes
PaymentDataAreaId	Treasury company	String (SelectableDataArea)	CFMPaymentRequestTable.PaymentDataAreaId	Yes
ExternalSystem	External system	String (MGCLatticeExternalSystemId)	Unmapped (virtual)
AccountNumberExternalKey	Account external key	String (MGCLatticeExternalKey)	Unmapped (virtual)

MGCLatticePaymentRequestLineEntity

Payment request line

Property	Value
OData entity set	LatticePaymentRequestLines (single: LatticePaymentRequestLine)
Access	Read/write
Data management	Enabled (staging table MGCLatticePaymentRequestLineStaging)
Company	Company-specific (SourceDataAreaId)
Key	PaymentRequestId, LineNumber
Data sources	CFMPaymentRequestTable, CFMPaymentRequestLine
Configuration key	CFMPaymentRequests
Granted by	MGCLatticePaymentRequestLineEntityMaintain (full CRUD); MGCLatticePaymentRequestLineEntityView (read)

Field	Label	Type	Source	Mandatory
PaymentRequestId (key)	Payment request	String (CFMPaymentRequestId)	CFMPaymentRequestTable.PaymentRequestId	Yes
LineNumber (key)	Line number	Real (LineNum)	CFMPaymentRequestLine.LineNumber
Amount	Original amount	Real (CFMPaymentRequestAmountCurOriginal)	CFMPaymentRequestLine.AmountCur
BalanceAmount	Amount to pay	Real (CFMPaymentRequestAmountCurPayment)	CFMPaymentRequestLine.BalanceAmountCur
TaxGroup	Sales tax group	String (TaxGroup)	CFMPaymentRequestLine.TaxGroup
TaxItemGroup	Item sales tax group	String (TaxItemGroup)	CFMPaymentRequestLine.TaxItemGroup
SourceDataAreaId	Company	String (SelectableDataArea)	CFMPaymentRequestLine.SourceDataAreaId	Yes

MGCLatticePlannedOrderRequirementEntity

Planned Order Requirement

Property	Value
OData entity set	LatticePlannedOrderRequirements (single: LatticePlannedOrderRequirement)
Access	Read-only
Data management	Enabled (staging table MGCLatticePlannedOrderRequirementStaging)
Company	Company-specific (DataAreaId)
Key	SysRecId
Data sources	ReqTrans
Granted by	MGCLatticePlannedOrderRequirementEntityMaintain (read); MGCLatticePlannedOrderRequirementEntityView (read)

Field	Label	Type	Source	Mandatory
SysRecId (key)	Record ID	Int64 (RecId)	ReqTrans.RecId
PlanVersion	Reference	Int64 (RefRecId)	ReqTrans.PlanVersion	Yes
ItemNumber	Item number	String (ItemId)	ReqTrans.ItemId	Yes
CoverageInventoryDimensionId	Dimension number	String (ReqCovInventDimId)	ReqTrans.CovInventDimId	Yes
Direction	In/Out	Enum InventDirection	ReqTrans.Direction
CoverageQuantity	Coverage planned	Real (ReqQtyCoverage)	ReqTrans.CovQty
ActionDate	Action date	Date (ActionDate)	ReqTrans.ActionDate
ActionType	Action	Enum ActionType	ReqTrans.ActionType
FuturesDate	Delayed to date	Date (FuturesDate)	ReqTrans.FuturesDate
ReferenceType	Reference	Enum ReqRefType	ReqTrans.RefType
ReferenceId	Number	String (InventTransRefId)	ReqTrans.RefId
IsDelayed	Is the requirement transaction delayed?	Enum NoYes	ReqTrans.IsDelayed

MGCLatticeProjectPostedTransactionEntity

Project Posted Transaction

Property	Value
OData entity set	LatticeProjectPostedTransactions (single: LatticeProjectPostedTransaction)
Access	Read-only
Data management	Enabled (staging table MGCLatticeProjectPostedTransactionStaging)
Company	Company-specific (DataAreaId)
Key	SysRecId
Data sources	ProjTransPosting
Granted by	MGCLatticeProjectPostedTransactionEntityMaintain (read); MGCLatticeProjectPostedTransactionEntityView (read)

Field	Label	Type	Source	Mandatory
TransactionId	Transaction ID	String (Num)	ProjTransPosting.TransId
ProjectId	Project ID	String (ProjId)	ProjTransPosting.ProjId	Yes
ProjectTransactionType	Transaction type	Enum ProjTransType	ProjTransPosting.ProjTransType
TransactionDate	Project date	Date (ProjTransDate)	ProjTransPosting.ProjTransDate	Yes
CategoryId	Category	String (ProjCategoryId)	ProjTransPosting.CategoryId
PostingType	Posting type	Enum LedgerPostingType	ProjTransPosting.PostingType
AccountingCurrencyAmount	Amount	Real (AmountMSTDebCred)	ProjTransPosting.AmountMst
Quantity	Hours	Real (ProjQtyEmpl)	ProjTransPosting.Qty
InventoryLotId	Lot ID	String (InventTransId)	ProjTransPosting.InventTransId
ProjectFundingSourceRecId	Funding source	Int64 (ProjFundingSourceRefId)	ProjTransPosting.ProjFundingSource
SysRecId (key)	Record ID	Int64 (RecId)	ProjTransPosting.RecId

MGCLatticePurchLineDiscountAgreementEntity

Purchase line discount trade agreements

Property	Value
OData entity set	LatticePurchaseLineDiscountAgreements (single: LatticePurchaseLineDiscountAgreement)
Access	Read-only
Data management	Not enabled
Company	Company-specific (DataAreaId)
Key	SysRecId
Data sources	PriceDiscTable
Granted by	MGCLatticeTradeAgreementEntityView (read)

Field	Label	Type	Source	Mandatory
PriceType	Relation	Enum PriceType	PriceDiscTable.relation
ModuleType	Module	Enum ModuleInventCustVend	PriceDiscTable.Module
AccountCode	Party code type	Enum PriceDiscPartyCodeType	PriceDiscTable.AccountCode
AccountRelation	Account selection	String (PriceDiscAccountRelation)	PriceDiscTable.AccountRelation
ItemCode	Product code type	Enum PriceDiscProductCodeType	PriceDiscTable.ItemCode
ItemRelation	Item relation	String (PriceDiscItemRelation)	PriceDiscTable.ItemRelation
InventoryDimensionId	Dimension number	String (InventDimId)	PriceDiscTable.InventDimId
UnitSymbol	Unit	String (UnitOfMeasureSymbol)	PriceDiscTable.UnitId
CurrencyCode	Currency	String (CurrencyCode)	PriceDiscTable.Currency	Yes
QuantityFrom	From	Real (AmountQty)	PriceDiscTable.QuantityAmountFrom
QuantityTo	To	Real (AmountQuantityTo)	PriceDiscTable.QuantityAmountTo
Amount	Amount in transaction currency	Real (PriceDiscAmount)	PriceDiscTable.Amount
DiscountPercent1	Discount percentage 1	Real (DiscPct)	PriceDiscTable.Percent1
DiscountPercent2	Discount percentage 2	Real (DiscPct)	PriceDiscTable.Percent2
Markup	Price charges	Real (PriceMarkup)	PriceDiscTable.Markup
PriceUnit	Price unit	Real (PriceUnit)	PriceDiscTable.PriceUnit
FromDate	From date	Date (FromDate)	PriceDiscTable.FromDate
ToDate	To date	Date (ToDate)	PriceDiscTable.ToDate
DeliveryLeadTime	Lead time	Int (LeadTimeDelivery)	PriceDiscTable.DeliveryTime
AgreementId	Price agreements	String (PriceAgreement)	PriceDiscTable.Agreement
SysRecId (key)	Record ID	Int64 (RecId)	PriceDiscTable.RecId

MGCLatticePurchMultilineDiscountAgreementEntity

Purchase multiline discount trade agreements

Property	Value
OData entity set	LatticePurchaseMultilineDiscountAgreements (single: LatticePurchaseMultilineDiscountAgreement)
Access	Read-only
Data management	Not enabled
Company	Company-specific (DataAreaId)
Key	SysRecId
Data sources	PriceDiscTable
Granted by	MGCLatticeTradeAgreementEntityView (read)

Field	Label	Type	Source	Mandatory
PriceType	Relation	Enum PriceType	PriceDiscTable.relation
ModuleType	Module	Enum ModuleInventCustVend	PriceDiscTable.Module
AccountCode	Party code type	Enum PriceDiscPartyCodeType	PriceDiscTable.AccountCode
AccountRelation	Account selection	String (PriceDiscAccountRelation)	PriceDiscTable.AccountRelation
ItemCode	Product code type	Enum PriceDiscProductCodeType	PriceDiscTable.ItemCode
ItemRelation	Item relation	String (PriceDiscItemRelation)	PriceDiscTable.ItemRelation
InventoryDimensionId	Dimension number	String (InventDimId)	PriceDiscTable.InventDimId
UnitSymbol	Unit	String (UnitOfMeasureSymbol)	PriceDiscTable.UnitId
CurrencyCode	Currency	String (CurrencyCode)	PriceDiscTable.Currency	Yes
QuantityFrom	From	Real (AmountQty)	PriceDiscTable.QuantityAmountFrom
QuantityTo	To	Real (AmountQuantityTo)	PriceDiscTable.QuantityAmountTo
Amount	Amount in transaction currency	Real (PriceDiscAmount)	PriceDiscTable.Amount
DiscountPercent1	Discount percentage 1	Real (DiscPct)	PriceDiscTable.Percent1
DiscountPercent2	Discount percentage 2	Real (DiscPct)	PriceDiscTable.Percent2
Markup	Price charges	Real (PriceMarkup)	PriceDiscTable.Markup
PriceUnit	Price unit	Real (PriceUnit)	PriceDiscTable.PriceUnit
FromDate	From date	Date (FromDate)	PriceDiscTable.FromDate
ToDate	To date	Date (ToDate)	PriceDiscTable.ToDate
DeliveryLeadTime	Lead time	Int (LeadTimeDelivery)	PriceDiscTable.DeliveryTime
AgreementId	Price agreements	String (PriceAgreement)	PriceDiscTable.Agreement
SysRecId (key)	Record ID	Int64 (RecId)	PriceDiscTable.RecId

MGCLatticePurchPriceAgreementEntity

Purchase price trade agreements

Property	Value
OData entity set	LatticePurchasePriceAgreements (single: LatticePurchasePriceAgreement)
Access	Read-only
Data management	Not enabled
Company	Company-specific (DataAreaId)
Key	SysRecId
Data sources	PriceDiscTable
Granted by	MGCLatticeTradeAgreementEntityView (read)

Field	Label	Type	Source	Mandatory
PriceType	Relation	Enum PriceType	PriceDiscTable.relation
ModuleType	Module	Enum ModuleInventCustVend	PriceDiscTable.Module
AccountCode	Party code type	Enum PriceDiscPartyCodeType	PriceDiscTable.AccountCode
AccountRelation	Account selection	String (PriceDiscAccountRelation)	PriceDiscTable.AccountRelation
ItemCode	Product code type	Enum PriceDiscProductCodeType	PriceDiscTable.ItemCode
ItemRelation	Item relation	String (PriceDiscItemRelation)	PriceDiscTable.ItemRelation
InventoryDimensionId	Dimension number	String (InventDimId)	PriceDiscTable.InventDimId
UnitSymbol	Unit	String (UnitOfMeasureSymbol)	PriceDiscTable.UnitId
CurrencyCode	Currency	String (CurrencyCode)	PriceDiscTable.Currency	Yes
QuantityFrom	From	Real (AmountQty)	PriceDiscTable.QuantityAmountFrom
QuantityTo	To	Real (AmountQuantityTo)	PriceDiscTable.QuantityAmountTo
Amount	Amount in transaction currency	Real (PriceDiscAmount)	PriceDiscTable.Amount
DiscountPercent1	Discount percentage 1	Real (DiscPct)	PriceDiscTable.Percent1
DiscountPercent2	Discount percentage 2	Real (DiscPct)	PriceDiscTable.Percent2
Markup	Price charges	Real (PriceMarkup)	PriceDiscTable.Markup
PriceUnit	Price unit	Real (PriceUnit)	PriceDiscTable.PriceUnit
FromDate	From date	Date (FromDate)	PriceDiscTable.FromDate
ToDate	To date	Date (ToDate)	PriceDiscTable.ToDate
DeliveryLeadTime	Lead time	Int (LeadTimeDelivery)	PriceDiscTable.DeliveryTime
AgreementId	Price agreements	String (PriceAgreement)	PriceDiscTable.Agreement
SysRecId (key)	Record ID	Int64 (RecId)	PriceDiscTable.RecId

MGCLatticePurchTotalDiscountAgreementEntity

Purchase total discount trade agreements

Property	Value
OData entity set	LatticePurchaseTotalDiscountAgreements (single: LatticePurchaseTotalDiscountAgreement)
Access	Read-only
Data management	Not enabled
Company	Company-specific (DataAreaId)
Key	SysRecId
Data sources	PriceDiscTable
Granted by	MGCLatticeTradeAgreementEntityView (read)

Field	Label	Type	Source	Mandatory
PriceType	Relation	Enum PriceType	PriceDiscTable.relation
ModuleType	Module	Enum ModuleInventCustVend	PriceDiscTable.Module
AccountCode	Party code type	Enum PriceDiscPartyCodeType	PriceDiscTable.AccountCode
AccountRelation	Account selection	String (PriceDiscAccountRelation)	PriceDiscTable.AccountRelation
ItemCode	Product code type	Enum PriceDiscProductCodeType	PriceDiscTable.ItemCode
ItemRelation	Item relation	String (PriceDiscItemRelation)	PriceDiscTable.ItemRelation
InventoryDimensionId	Dimension number	String (InventDimId)	PriceDiscTable.InventDimId
UnitSymbol	Unit	String (UnitOfMeasureSymbol)	PriceDiscTable.UnitId
CurrencyCode	Currency	String (CurrencyCode)	PriceDiscTable.Currency	Yes
QuantityFrom	From	Real (AmountQty)	PriceDiscTable.QuantityAmountFrom
QuantityTo	To	Real (AmountQuantityTo)	PriceDiscTable.QuantityAmountTo
Amount	Amount in transaction currency	Real (PriceDiscAmount)	PriceDiscTable.Amount
DiscountPercent1	Discount percentage 1	Real (DiscPct)	PriceDiscTable.Percent1
DiscountPercent2	Discount percentage 2	Real (DiscPct)	PriceDiscTable.Percent2
Markup	Price charges	Real (PriceMarkup)	PriceDiscTable.Markup
PriceUnit	Price unit	Real (PriceUnit)	PriceDiscTable.PriceUnit
FromDate	From date	Date (FromDate)	PriceDiscTable.FromDate
ToDate	To date	Date (ToDate)	PriceDiscTable.ToDate
DeliveryLeadTime	Lead time	Int (LeadTimeDelivery)	PriceDiscTable.DeliveryTime
AgreementId	Price agreements	String (PriceAgreement)	PriceDiscTable.Agreement
SysRecId (key)	Record ID	Int64 (RecId)	PriceDiscTable.RecId

MGCLatticeRecurringJobMessageEntity

Recurring data job message

A message of a recurring data job (read-only): status, timestamps, company, retries, error details and the data management execution that processed it, with its staging and target error counts.

Property	Value
OData entity set	LatticeRecurringJobMessages (single: LatticeRecurringJobMessage)
Access	Read-only
Data management	Not enabled
Company	Shared across companies
Key	MessageId
Data sources	IntegrationActivityMessageTable, IntegrationActivityTable, IntegrationActivityRuntimeExecutionTable
Granted by	MGCLatticeRecurringJobMessageEntityView (read)

Field	Label	Type	Source	Mandatory
MessageId (key)	Message ID	Guid	IntegrationActivityMessageTable.MessageId
JobName	Recurring data job	String (IntegrationName)	IntegrationActivityTable.Name	Yes
JobActivityId	Recurring data job ID	Guid	IntegrationActivityMessageTable.ActivityCorrelationId
Direction	Direction	Enum IntegrationDirection	IntegrationActivityTable.Direction
EntityName	Entity	String (DMFEntityName)	IntegrationActivityMessageTable.EntityName
Status	Activity message status	Enum IntegrationActivityMessageStatus	IntegrationActivityMessageTable.Status
EnqueuedDateTime	Enqueued	UtcDateTime	IntegrationActivityMessageTable.EnqueueDateTime
EnqueuedBy	Enqueued by	String (UserId)	IntegrationActivityMessageTable.EnqueueUser
ProcessingStartedDateTime	Processing started	UtcDateTime	IntegrationActivityMessageTable.ProcessingStartedDateTime
ProcessingCompletedDateTime	Processing completed	UtcDateTime	IntegrationActivityMessageTable.ProcessingCompletedDateTime
Company	Company	String (CompanyId)	IntegrationActivityMessageTable.ContextDataAreaId
RetryCount	Retries	Int	IntegrationActivityMessageTable.RetryCount
ErrorDetails	Error Details	String (DMFErrorMessage)	IntegrationActivityMessageTable.ErrorDetails
ExternalCorrelationId	External correlation ID	String (String255)	IntegrationActivityMessageTable.ExternalCorrelationId
ExecutionId	Job ID	String (DMFExecutionId)	IntegrationActivityRuntimeExecutionTable.ExecutionId
ExecutionStatus	Execution status	Enum DMFBatchJobStatus	IntegrationActivityRuntimeExecutionTable.Status
StagingErrorCount	Staging errors	Int (MGCLatticeRecordCount)	Computed
TargetErrorCount	Target errors	Int (MGCLatticeRecordCount)	Computed

MGCLatticeRetailTransactionEntity

Retail transactions

Property	Value
OData entity set	LatticeRetailTransactions (single: LatticeRetailTransaction)
Access	Read-only
Data management	Enabled (staging table MGCLatticeRetailTransactionStaging)
Company	Company-specific (DataAreaId)
Key	SysRecId
Data sources	RetailTransactionTable
Granted by	MGCLatticeRetailTransactionEntityMaintain (read); MGCLatticeRetailTransactionEntityView (read)

Field	Label	Type	Source	Mandatory
Store	Store number	String (RetailStoreId)	RetailTransactionTable.store
Terminal	Register number	String (RetailTerminalId)	RetailTransactionTable.terminal
ReceiptId	Receipt number	String (RetailReceiptId)	RetailTransactionTable.receiptId
Channel	Reference	Int64 (RefRecId)	RetailTransactionTable.Channel
TransactionDate	Date	Date (TransDate)	RetailTransactionTable.transDate
TransactionTime	Transaction time	Time (RetailTransTime)	RetailTransactionTable.transTime
Staff	Operator ID	String (RetailStaffId)	RetailTransactionTable.staff
CustomerAccount	Customer account	String (RetailAsyncCustAccount)	RetailTransactionTable.custAccount
TransactionStatus	Entry status	Enum RetailEntryStatus	RetailTransactionTable.entryStatus
TransactionType	Type	Enum RetailTransactionType	RetailTransactionTable.type
GrossAmount	Gross amount	Real (RetailGrossAmount)	RetailTransactionTable.grossAmount
NetAmount	Net amount exclusive of tax	Real (RetailNetAmount)	RetailTransactionTable.netAmount
CostAmount	Cost amount	Real (RetailCostAmount)	RetailTransactionTable.costAmount
PaymentAmount	Payment amount	Real (RetailPaymentAmount)	RetailTransactionTable.paymentAmount
CurrencyCode	Currency	String (CurrencyCode)	RetailTransactionTable.currency
SysRecId (key)	Record ID	Int64 (RecId)	RetailTransactionTable.RecId

MGCLatticeSalesLineDiscountAgreementEntity

Sales line discount trade agreements

Property	Value
OData entity set	LatticeSalesLineDiscountAgreements (single: LatticeSalesLineDiscountAgreement)
Access	Read-only
Data management	Not enabled
Company	Company-specific (DataAreaId)
Key	SysRecId
Data sources	PriceDiscTable
Granted by	MGCLatticeTradeAgreementEntityView (read)

Field	Label	Type	Source	Mandatory
PriceType	Relation	Enum PriceType	PriceDiscTable.relation
ModuleType	Module	Enum ModuleInventCustVend	PriceDiscTable.Module
AccountCode	Party code type	Enum PriceDiscPartyCodeType	PriceDiscTable.AccountCode
AccountRelation	Account selection	String (PriceDiscAccountRelation)	PriceDiscTable.AccountRelation
ItemCode	Product code type	Enum PriceDiscProductCodeType	PriceDiscTable.ItemCode
ItemRelation	Item relation	String (PriceDiscItemRelation)	PriceDiscTable.ItemRelation
InventoryDimensionId	Dimension number	String (InventDimId)	PriceDiscTable.InventDimId
UnitSymbol	Unit	String (UnitOfMeasureSymbol)	PriceDiscTable.UnitId
CurrencyCode	Currency	String (CurrencyCode)	PriceDiscTable.Currency	Yes
QuantityFrom	From	Real (AmountQty)	PriceDiscTable.QuantityAmountFrom
QuantityTo	To	Real (AmountQuantityTo)	PriceDiscTable.QuantityAmountTo
Amount	Amount in transaction currency	Real (PriceDiscAmount)	PriceDiscTable.Amount
DiscountPercent1	Discount percentage 1	Real (DiscPct)	PriceDiscTable.Percent1
DiscountPercent2	Discount percentage 2	Real (DiscPct)	PriceDiscTable.Percent2
Markup	Price charges	Real (PriceMarkup)	PriceDiscTable.Markup
PriceUnit	Price unit	Real (PriceUnit)	PriceDiscTable.PriceUnit
FromDate	From date	Date (FromDate)	PriceDiscTable.FromDate
ToDate	To date	Date (ToDate)	PriceDiscTable.ToDate
DeliveryLeadTime	Lead time	Int (LeadTimeDelivery)	PriceDiscTable.DeliveryTime
AgreementId	Price agreements	String (PriceAgreement)	PriceDiscTable.Agreement
SysRecId (key)	Record ID	Int64 (RecId)	PriceDiscTable.RecId

MGCLatticeSalesMultilineDiscountAgreementEntity

Sales multiline discount trade agreements

Property	Value
OData entity set	LatticeSalesMultilineDiscountAgreements (single: LatticeSalesMultilineDiscountAgreement)
Access	Read-only
Data management	Not enabled
Company	Company-specific (DataAreaId)
Key	SysRecId
Data sources	PriceDiscTable
Granted by	MGCLatticeTradeAgreementEntityView (read)

Field	Label	Type	Source	Mandatory
PriceType	Relation	Enum PriceType	PriceDiscTable.relation
ModuleType	Module	Enum ModuleInventCustVend	PriceDiscTable.Module
AccountCode	Party code type	Enum PriceDiscPartyCodeType	PriceDiscTable.AccountCode
AccountRelation	Account selection	String (PriceDiscAccountRelation)	PriceDiscTable.AccountRelation
ItemCode	Product code type	Enum PriceDiscProductCodeType	PriceDiscTable.ItemCode
ItemRelation	Item relation	String (PriceDiscItemRelation)	PriceDiscTable.ItemRelation
InventoryDimensionId	Dimension number	String (InventDimId)	PriceDiscTable.InventDimId
UnitSymbol	Unit	String (UnitOfMeasureSymbol)	PriceDiscTable.UnitId
CurrencyCode	Currency	String (CurrencyCode)	PriceDiscTable.Currency	Yes
QuantityFrom	From	Real (AmountQty)	PriceDiscTable.QuantityAmountFrom
QuantityTo	To	Real (AmountQuantityTo)	PriceDiscTable.QuantityAmountTo
Amount	Amount in transaction currency	Real (PriceDiscAmount)	PriceDiscTable.Amount
DiscountPercent1	Discount percentage 1	Real (DiscPct)	PriceDiscTable.Percent1
DiscountPercent2	Discount percentage 2	Real (DiscPct)	PriceDiscTable.Percent2
Markup	Price charges	Real (PriceMarkup)	PriceDiscTable.Markup
PriceUnit	Price unit	Real (PriceUnit)	PriceDiscTable.PriceUnit
FromDate	From date	Date (FromDate)	PriceDiscTable.FromDate
ToDate	To date	Date (ToDate)	PriceDiscTable.ToDate
DeliveryLeadTime	Lead time	Int (LeadTimeDelivery)	PriceDiscTable.DeliveryTime
AgreementId	Price agreements	String (PriceAgreement)	PriceDiscTable.Agreement
SysRecId (key)	Record ID	Int64 (RecId)	PriceDiscTable.RecId

MGCLatticeSalesPriceAgreementEntity

Sales price trade agreements

Property	Value
OData entity set	LatticeSalesPriceAgreements (single: LatticeSalesPriceAgreement)
Access	Read-only
Data management	Not enabled
Company	Company-specific (DataAreaId)
Key	SysRecId
Data sources	PriceDiscTable
Granted by	MGCLatticeTradeAgreementEntityView (read)

Field	Label	Type	Source	Mandatory
PriceType	Relation	Enum PriceType	PriceDiscTable.relation
ModuleType	Module	Enum ModuleInventCustVend	PriceDiscTable.Module
AccountCode	Party code type	Enum PriceDiscPartyCodeType	PriceDiscTable.AccountCode
AccountRelation	Account selection	String (PriceDiscAccountRelation)	PriceDiscTable.AccountRelation
ItemCode	Product code type	Enum PriceDiscProductCodeType	PriceDiscTable.ItemCode
ItemRelation	Item relation	String (PriceDiscItemRelation)	PriceDiscTable.ItemRelation
InventoryDimensionId	Dimension number	String (InventDimId)	PriceDiscTable.InventDimId
UnitSymbol	Unit	String (UnitOfMeasureSymbol)	PriceDiscTable.UnitId
CurrencyCode	Currency	String (CurrencyCode)	PriceDiscTable.Currency	Yes
QuantityFrom	From	Real (AmountQty)	PriceDiscTable.QuantityAmountFrom
QuantityTo	To	Real (AmountQuantityTo)	PriceDiscTable.QuantityAmountTo
Amount	Amount in transaction currency	Real (PriceDiscAmount)	PriceDiscTable.Amount
DiscountPercent1	Discount percentage 1	Real (DiscPct)	PriceDiscTable.Percent1
DiscountPercent2	Discount percentage 2	Real (DiscPct)	PriceDiscTable.Percent2
Markup	Price charges	Real (PriceMarkup)	PriceDiscTable.Markup
PriceUnit	Price unit	Real (PriceUnit)	PriceDiscTable.PriceUnit
FromDate	From date	Date (FromDate)	PriceDiscTable.FromDate
ToDate	To date	Date (ToDate)	PriceDiscTable.ToDate
DeliveryLeadTime	Lead time	Int (LeadTimeDelivery)	PriceDiscTable.DeliveryTime
AgreementId	Price agreements	String (PriceAgreement)	PriceDiscTable.Agreement
SysRecId (key)	Record ID	Int64 (RecId)	PriceDiscTable.RecId

MGCLatticeSalesTotalDiscountAgreementEntity

Sales total discount trade agreements

Property	Value
OData entity set	LatticeSalesTotalDiscountAgreements (single: LatticeSalesTotalDiscountAgreement)
Access	Read-only
Data management	Not enabled
Company	Company-specific (DataAreaId)
Key	SysRecId
Data sources	PriceDiscTable
Granted by	MGCLatticeTradeAgreementEntityView (read)

Field	Label	Type	Source	Mandatory
PriceType	Relation	Enum PriceType	PriceDiscTable.relation
ModuleType	Module	Enum ModuleInventCustVend	PriceDiscTable.Module
AccountCode	Party code type	Enum PriceDiscPartyCodeType	PriceDiscTable.AccountCode
AccountRelation	Account selection	String (PriceDiscAccountRelation)	PriceDiscTable.AccountRelation
ItemCode	Product code type	Enum PriceDiscProductCodeType	PriceDiscTable.ItemCode
ItemRelation	Item relation	String (PriceDiscItemRelation)	PriceDiscTable.ItemRelation
InventoryDimensionId	Dimension number	String (InventDimId)	PriceDiscTable.InventDimId
UnitSymbol	Unit	String (UnitOfMeasureSymbol)	PriceDiscTable.UnitId
CurrencyCode	Currency	String (CurrencyCode)	PriceDiscTable.Currency	Yes
QuantityFrom	From	Real (AmountQty)	PriceDiscTable.QuantityAmountFrom
QuantityTo	To	Real (AmountQuantityTo)	PriceDiscTable.QuantityAmountTo
Amount	Amount in transaction currency	Real (PriceDiscAmount)	PriceDiscTable.Amount
DiscountPercent1	Discount percentage 1	Real (DiscPct)	PriceDiscTable.Percent1
DiscountPercent2	Discount percentage 2	Real (DiscPct)	PriceDiscTable.Percent2
Markup	Price charges	Real (PriceMarkup)	PriceDiscTable.Markup
PriceUnit	Price unit	Real (PriceUnit)	PriceDiscTable.PriceUnit
FromDate	From date	Date (FromDate)	PriceDiscTable.FromDate
ToDate	To date	Date (ToDate)	PriceDiscTable.ToDate
DeliveryLeadTime	Lead time	Int (LeadTimeDelivery)	PriceDiscTable.DeliveryTime
AgreementId	Price agreements	String (PriceAgreement)	PriceDiscTable.Agreement
SysRecId (key)	Record ID	Int64 (RecId)	PriceDiscTable.RecId

MGCLatticeServiceCallLogEntity

Service Call Log Entity

Read-only OData entity exposing the MGCLatticeServiceCallLog table for operational monitoring and SLA reporting.

Property	Value
OData entity set	LatticeServiceCallLogs (single: LatticeServiceCallLog)
Access	Read-only
Data management	Not enabled
Company	Shared across companies
Key	RequestId, ExecutionId
Data sources	MGCLatticeServiceCallLog
Granted by	MGCLatticeServiceCallLogEntityView (read)

Field	Label	Type	Source	Mandatory
ServiceName	Service	String (MGCLatticeServiceName)	MGCLatticeServiceCallLog.ServiceName
OperationName	Operation	String (MGCLatticeOperationName)	MGCLatticeServiceCallLog.OperationName
LegalEntityId	Legal Entity	String (DataAreaId)	MGCLatticeServiceCallLog.LegalEntityId
UserContext	User Context	String (UserId)	MGCLatticeServiceCallLog.UserContext
CalledBy	Created by	String (CreatedBy)	MGCLatticeServiceCallLog.CreatedBy
StartDateTimeUtc	Start date/time	UtcDateTime (StartDateTime)	MGCLatticeServiceCallLog.StartDateTimeUtc
EndDateTimeUtc	End date/time	UtcDateTime (EndDateTime)	MGCLatticeServiceCallLog.EndDateTimeUtc
DurationMs	Duration (ms)	Int64 (MGCLatticeDurationMs)	MGCLatticeServiceCallLog.DurationMs
Success	Success	Enum NoYes	MGCLatticeServiceCallLog.Success
Status	Status	Enum MGCLatticeServiceCallStatus	MGCLatticeServiceCallLog.Status
Message	Message	String (MGCLatticeLogMessageShort)	MGCLatticeServiceCallLog.Message
ErrorDetails	Error details	String (MGCLatticeServiceCallErrorDetails)	MGCLatticeServiceCallLog.ErrorDetails
DocumentId	Document ID	String (MGCLatticeDocumentId)	MGCLatticeServiceCallLog.DocumentId
PostedDocumentId	Posted document	String (MGCLatticeDocumentId)	MGCLatticeServiceCallLog.PostedDocumentId
RequestId (key)	Request ID	Guid (MGCLatticeRequestId)	MGCLatticeServiceCallLog.RequestId
CorrelationId	Correlation ID	Guid (MGCLatticeCorrelationId)	MGCLatticeServiceCallLog.CorrelationId
ExecutionId (key)	Execution ID	Guid (MGCLatticeExecutionId)	MGCLatticeServiceCallLog.ExecutionId
ErrorCode	Error code	Enum MGCLatticeServiceErrorCode	MGCLatticeServiceCallLog.ErrorCode
IsPreview	Preview	Enum NoYes	MGCLatticeServiceCallLog.IsPreview

MGCLatticeServiceCallStatisticsEntity

Service Call Statistics Entity

Read-only OData entity exposing MGCLatticeServiceCallStatistics (per-operation call rollups) for integration observability.

Property	Value
OData entity set	LatticeServiceCallStatistics (single: LatticeServiceCallStatistic)
Access	Read-only
Data management	Not enabled
Company	Shared across companies
Key	ServiceName, OperationName, StatisticsDate
Data sources	MGCLatticeServiceCallStatistics
Granted by	MGCLatticeIntegrationObservabilityView (read)

Field	Label	Type	Source	Mandatory
ServiceName (key)	Service	String (MGCLatticeServiceName)	MGCLatticeServiceCallStatistics.ServiceName	Yes
OperationName (key)	Operation	String (MGCLatticeOperationName)	MGCLatticeServiceCallStatistics.OperationName	Yes
StatisticsDate (key)	Date	Date (TransDate)	MGCLatticeServiceCallStatistics.StatisticsDate
CallCount	Calls	Int64 (MGCLatticeCallCount)	MGCLatticeServiceCallStatistics.CallCount
SuccessCount	Successes	Int64 (MGCLatticeCallCount)	MGCLatticeServiceCallStatistics.SuccessCount
FailureCount	Failures	Int64 (MGCLatticeCallCount)	MGCLatticeServiceCallStatistics.FailureCount
TotalDurationMs	Total duration (ms)	Int64 (MGCLatticeDurationMs)	MGCLatticeServiceCallStatistics.TotalDurationMs
MinDurationMs	Minimum duration (ms)	Int64 (MGCLatticeDurationMs)	MGCLatticeServiceCallStatistics.MinDurationMs
MaxDurationMs	Maximum duration (ms)	Int64 (MGCLatticeDurationMs)	MGCLatticeServiceCallStatistics.MaxDurationMs
AvgDurationMs	Average duration (ms)	Int64 (MGCLatticeDurationMs)	MGCLatticeServiceCallStatistics.AvgDurationMs
LastCallDateTimeUtc	Last call	UtcDateTime (TransDateTime)	MGCLatticeServiceCallStatistics.LastCallDateTimeUtc

MGCLatticeServiceIdempotencyLogEntity

Service Idempotency Log Entity

Read-only OData entity exposing the MGCLatticeServiceIdempotencyLog table for tracking processed service requests and preventing duplicate execution.

Property	Value
OData entity set	LatticeServiceIdempotencyLogs (single: LatticeServiceIdempotencyLog)
Access	Read-only
Data management	Not enabled
Company	Shared across companies
Key	RequestId
Data sources	MGCLatticeServiceIdempotencyLog
Granted by	MGCLatticeServiceIdempotencyLogEntityView (read)

Field	Label	Type	Source	Mandatory
RequestId (key)	Request ID	Guid (MGCLatticeRequestId)	MGCLatticeServiceIdempotencyLog.RequestId	Yes
CorrelationId	Correlation ID	Guid (MGCLatticeCorrelationId)	MGCLatticeServiceIdempotencyLog.CorrelationId
ServiceName	Service	String (MGCLatticeServiceName)	MGCLatticeServiceIdempotencyLog.ServiceName
OperationName	Operation	String (MGCLatticeOperationName)	MGCLatticeServiceIdempotencyLog.OperationName
Success	Success	Enum NoYes	MGCLatticeServiceIdempotencyLog.Success
DocumentId	Document ID	String (MGCLatticeDocumentId)	MGCLatticeServiceIdempotencyLog.DocumentId
PostedDocumentId	Posted document	String (MGCLatticeDocumentId)	MGCLatticeServiceIdempotencyLog.PostedDocumentId
CompletedDateTimeUtc	Completed time	UtcDateTime (TransDateTime)	MGCLatticeServiceIdempotencyLog.CompletedDateTimeUtc
Status	Status	Enum MGCLatticeServiceCallStatus	MGCLatticeServiceIdempotencyLog.Status
ClaimedDateTimeUtc	Claimed date/time	UtcDateTime (TransDateTime)	MGCLatticeServiceIdempotencyLog.ClaimedDateTimeUtc
LegalEntityId	Legal Entity	String (DataAreaId)	MGCLatticeServiceIdempotencyLog.LegalEntityId
DocumentTable	Document table	String (TableName)	MGCLatticeServiceIdempotencyLog.DocumentTable
ReconcileState	Reconciliation state	Enum MGCLatticeIdempotencyReconcileState	MGCLatticeServiceIdempotencyLog.ReconcileState

MGCLatticeTableEntityCoverageEntity

Table data and entity coverage snapshot

Property	Value
OData entity set	LatticeTableEntityCoverages (single: LatticeTableEntityCoverage)
Access	Read-only
Data management	Enabled (staging table MGCLatticeTableEntityCoverageStaging)
Company	Shared across companies
Key	SnapshotId, TableName, CompanyId
Data sources	MGCLatticeTableEntityCoverageSnapshot
Granted by	MGCLatticeTableEntityCoverageEntityView (read)

Field	Label	Type	Source	Mandatory
SnapshotId (key)	Snapshot run ID	Int64 (MGCLatticeSnapshotId)	MGCLatticeTableEntityCoverageSnapshot.SnapshotId	Yes
SnapshotDateTime	Snapshot date and time	UtcDateTime (TransDateTime)	MGCLatticeTableEntityCoverageSnapshot.SnapshotDateTime
TableName (key)	Table name	String (TableName)	MGCLatticeTableEntityCoverageSnapshot.TableName	Yes
SourceTableId	Table ID	Int (RefTableId)	MGCLatticeTableEntityCoverageSnapshot.SourceTableId
CompanyId (key)	Company	String (DataAreaId)	MGCLatticeTableEntityCoverageSnapshot.CompanyId
RowCount	Row count	Int64 (MGCLatticeRowCount)	MGCLatticeTableEntityCoverageSnapshot.RowCount
IsSharedTable	Shared table	Enum NoYes	MGCLatticeTableEntityCoverageSnapshot.IsSharedTable
TableGroup	Table group	String (MGCLatticeTableGroupName)	MGCLatticeTableEntityCoverageSnapshot.TableGroup
ModelName	Model or module	String (MGCLatticeModelName)	MGCLatticeTableEntityCoverageSnapshot.ModelName
HasEntity	Has data entity	Enum NoYes	MGCLatticeTableEntityCoverageSnapshot.HasEntity
CoveringEntityCount	Covering entity count	Int (MGCLatticeRecordCount)	MGCLatticeTableEntityCoverageSnapshot.CoveringEntityCount
CoveringEntities	Covering entities	String (MGCLatticeEntityNameList)	MGCLatticeTableEntityCoverageSnapshot.CoveringEntities

MGCLatticeTaxTransactionEntity

Tax Transaction

Property	Value
OData entity set	LatticeTaxTransactions (single: LatticeTaxTransaction)
Access	Read-only
Data management	Enabled (staging table MGCLatticeTaxTransactionStaging)
Company	Company-specific (DataAreaId)
Key	SysRecId
Data sources	TaxTrans
Granted by	MGCLatticeTaxTransactionEntityMaintain (read); MGCLatticeTaxTransactionEntityView (read)

Field	Label	Type	Source	Mandatory
SysRecId (key)	Record ID	Int64 (RecId)	TaxTrans.RecId
TaxCode	Sales tax code	String (TaxCode)	TaxTrans.TaxCode	Yes
TaxDirection	Sales tax direction	Enum TaxDirection	TaxTrans.TaxDirection
TransactionDate	Date	Date (TransDate)	TaxTrans.TransDate	Yes
Voucher	Voucher	String (Voucher)	TaxTrans.Voucher	Yes
TaxGroup	Sales tax group	String (TaxGroup)	TaxTrans.TaxGroup
TaxItemGroup	Item sales tax group	String (TaxItemGroup)	TaxTrans.TaxItemGroup
TaxAmount	Sales tax amount in accounting currency	Real (TaxAmount)	TaxTrans.TaxAmount
TaxBaseAmount	Base amount in accounting currency	Real (TaxBase)	TaxTrans.TaxBaseAmount
SourceTaxAmountCur	Sales tax amount in transaction currency	Real (TaxAmountCur)	TaxTrans.SourceTaxAmountCur
TaxRate	Value	Real (TaxValue)	TaxTrans.TaxValue
CurrencyCode	Sales tax - currency	String (CurrencyCode)	TaxTrans.CurrencyCode

MGCLatticeTradeAgreementEntity

Trade Agreement

Property	Value
OData entity set	LatticeTradeAgreements (single: LatticeTradeAgreement)
Access	Read-only
Data management	Enabled (staging table MGCLatticeTradeAgreementStaging)
Company	Company-specific (DataAreaId)
Key	SysRecId
Data sources	PriceDiscTable
Granted by	MGCLatticeTradeAgreementEntityMaintain (read); MGCLatticeTradeAgreementEntityView (read)

Field	Label	Type	Source	Mandatory
PriceType	Relation	Enum PriceType	PriceDiscTable.relation
ModuleType	Module	Enum ModuleInventCustVend	PriceDiscTable.Module
AccountCode	Party code type	Enum PriceDiscPartyCodeType	PriceDiscTable.AccountCode
AccountRelation	Account selection	String (PriceDiscAccountRelation)	PriceDiscTable.AccountRelation
ItemCode	Product code type	Enum PriceDiscProductCodeType	PriceDiscTable.ItemCode
ItemRelation	Item relation	String (PriceDiscItemRelation)	PriceDiscTable.ItemRelation
InventoryDimensionId	Dimension number	String (InventDimId)	PriceDiscTable.InventDimId
UnitSymbol	Unit	String (UnitOfMeasureSymbol)	PriceDiscTable.UnitId
CurrencyCode	Currency	String (CurrencyCode)	PriceDiscTable.Currency	Yes
QuantityFrom	From	Real (AmountQty)	PriceDiscTable.QuantityAmountFrom
QuantityTo	To	Real (AmountQuantityTo)	PriceDiscTable.QuantityAmountTo
Amount	Amount in transaction currency	Real (PriceDiscAmount)	PriceDiscTable.Amount
DiscountPercent1	Discount percentage 1	Real (DiscPct)	PriceDiscTable.Percent1
DiscountPercent2	Discount percentage 2	Real (DiscPct)	PriceDiscTable.Percent2
Markup	Price charges	Real (PriceMarkup)	PriceDiscTable.Markup
PriceUnit	Price unit	Real (PriceUnit)	PriceDiscTable.PriceUnit
FromDate	From date	Date (FromDate)	PriceDiscTable.FromDate
ToDate	To date	Date (ToDate)	PriceDiscTable.ToDate
DeliveryLeadTime	Lead time	Int (LeadTimeDelivery)	PriceDiscTable.DeliveryTime
AgreementId	Price agreements	String (PriceAgreement)	PriceDiscTable.Agreement
SysRecId (key)	Record ID	Int64 (RecId)	PriceDiscTable.RecId

MGCLatticeTrialBalanceEntity

Trial balance (snapshot)

Property	Value
OData entity set	LatticeTrialBalances (single: LatticeTrialBalance)
Access	Read-only
Data management	Enabled (staging table MGCLatticeTrialBalanceStaging)
Company	Shared across companies
Key	SysRecId
Data sources	FiscalCalendarPeriod, LedgerTrialBalanceSnapshotHeader, LedgerTrialBalanceSnapshotData, Ledger, FiscalCalendarYear
Configuration key	LedgerBasic
Granted by	MGCLatticeTrialBalanceEntityMaintain (read); MGCLatticeTrialBalanceEntityView (read)

Field	Label	Type	Source	Mandatory
SysRecId (key)	Record ID	Int64 (RecId)	LedgerTrialBalanceSnapshotData.RecId
SnapshotHeaderRecId	Header table for trial balance snapshots	Int64 (LedgerTrialBalanceSnapshotHeaderRecId)	LedgerTrialBalanceSnapshotData.SnapshotHeader	Yes
AccountingDate	Date	Date (TransDate)	LedgerTrialBalanceSnapshotData.AccountingDate	Yes
FiscalPeriodRecId	Reference	Int64 (FiscalCalendarPeriodRecId)	LedgerTrialBalanceSnapshotData.FiscalCalendarPeriodRecId
PostingLayer	Posting layer	Enum CurrentOperationsTax	LedgerTrialBalanceSnapshotData.PostingLayer
PeriodTransactionType	Type	Enum FiscalPeriodType	LedgerTrialBalanceSnapshotData.TransactionType
LedgerDimensionDisplayValue	Name	String (DimensionDisplayValue)	LedgerTrialBalanceSnapshotData.PrimaryFocusDescription
DimensionSortValue	Compound dimension/account value	String (DimensionSortValue)	LedgerTrialBalanceSnapshotData.PrimaryFocus
MainAccountCategory	Ledger account category	String (AccountCategory)	LedgerTrialBalanceSnapshotData.MainAccountCategory
OpeningBalance	Opening balance	Real (AmountMSTLong)	LedgerTrialBalanceSnapshotData.OpeningBalance
DebitAmount	Debit	Real (AmountMSTLong)	LedgerTrialBalanceSnapshotData.AmountDebit
CreditAmount	Credit	Real (AmountMSTLong)	LedgerTrialBalanceSnapshotData.AmountCredit
ClosingBalance	Closing balance	Real (AmountMSTLong)	LedgerTrialBalanceSnapshotData.EndingBalance
NetChange	Amount	Real (AmountMSTLong)	LedgerTrialBalanceSnapshotData.NetChange
ClosingAdjustments	Closing period adjustments	Real (AmountMSTLong)	LedgerTrialBalanceSnapshotData.ClosingAdjustments
DimensionDisplayValue1	Dimension value 1	String (DimensionValue)	LedgerTrialBalanceSnapshotData.DimValue1
DimensionDisplayValue2	Dimension value 2	String (DimensionValue)	LedgerTrialBalanceSnapshotData.DimValue2
DimensionDisplayValue3	Dimension value 3	String (DimensionValue)	LedgerTrialBalanceSnapshotData.DimValue3
DimensionDisplayValue4	Dimension value 4	String (DimensionValue)	LedgerTrialBalanceSnapshotData.DimValue4
DimensionDisplayValue5	Dimension value 5	String (DimensionValue)	LedgerTrialBalanceSnapshotData.DimValue5
DimensionDisplayValue6	Dimension value 6	String (DimensionValue)	LedgerTrialBalanceSnapshotData.DimValue6
DimensionDisplayValue7	Dimension value 7	String (DimensionValue)	LedgerTrialBalanceSnapshotData.DimValue7
DimensionDisplayValue8	Dimension value 8	String (DimensionValue)	LedgerTrialBalanceSnapshotData.DimValue8
DimensionDisplayValue9	Dimension value 9	String (DimensionValue)	LedgerTrialBalanceSnapshotData.DimValue9
DimensionDisplayValue10	Dimension value 10	String (DimensionValue)	LedgerTrialBalanceSnapshotData.DimValue10
DimensionDisplayValue11	Dimension value 11	String (DimensionValue)	LedgerTrialBalanceSnapshotData.DimValue11
LedgerRecId	Ledger	Int64 (LedgerRecId)	LedgerTrialBalanceSnapshotHeader.LedgerRecId
FiscalCalendarYearRecId	Reference	Int64 (FiscalCalendarYearRecId)	LedgerTrialBalanceSnapshotHeader.FiscalCalendarYearRecId
DimensionHierarchyId	Dimension set	Int64 (DimensionHierarchyId)	LedgerTrialBalanceSnapshotHeader.DimensionHierarchyId
ExternalTrackingId	External tracking Id	Guid	LedgerTrialBalanceSnapshotHeader.ExternalTrackingId
SnapshotStatus	Snapshot status	Enum LedgerTrialBalanceSnapshotStatus	LedgerTrialBalanceSnapshotHeader.Status
LedgerName	Ledger name	String (LedgerName)	Ledger.Name	Yes
FiscalYearName	Fiscal year	String (FiscalYearName)	FiscalCalendarYear.Name	Yes
FiscalPeriodName	Period name	String (PeriodName)	FiscalCalendarPeriod.Name	Yes
FiscalPeriodType	Type	Enum FiscalPeriodType	FiscalCalendarPeriod.Type
FiscalPeriodStartDate	Period start	Date (FiscalPeriodStart)	FiscalCalendarPeriod.StartDate	Yes
FiscalPeriodEndDate	End date	Date (FiscalPeriodEnd)	FiscalCalendarPeriod.EndDate	Yes

MGCLatticeVendorSettlementEntity

Vendor settlements

Property	Value
OData entity set	LatticeVendorSettlements (single: LatticeVendorSettlement)
Access	Read-only
Data management	Enabled (staging table MGCLatticeVendorSettlementStaging)
Company	Company-specific (DataAreaId)
Key	SysRecId
Data sources	VendSettlement
Granted by	MGCLatticeVendorSettlementEntityMaintain (read); MGCLatticeVendorSettlementEntityView (read)

Field	Label	Type	Source	Mandatory
VendorAccountNumber	Account number	String (VendAccount)	VendSettlement.AccountNum
TransRecId	Reference record ID	Int64 (VendSettleParentRecId)	VendSettlement.TransRecId	Yes
TransactionType	Transaction type	Enum LedgerTransType	VendSettlement.TransType
TransactionDate	Date of settlement	Date (TransDate)	VendSettlement.TransDate	Yes
DueDate	Due date	Date (DueDate)	VendSettlement.DueDate
ClosedDate	Closed date	Date (TransDate)	VendSettlement.ClosedDate
OffsetRecId	Reference	Int64 (VendTransRefRecId)	VendSettlement.OffsetRecid
OffsetVoucher	Offset voucher	String (Voucher)	VendSettlement.OffsetTransVoucher
OffsetAccountNum	Account	String (VendAccount)	VendSettlement.OffsetAccountNum
OffsetLegalEntityId	Company accounts	String (CompanyId)	VendSettlement.OffsetCompany
SettlementVoucher	Voucher	String (Voucher)	VendSettlement.SettlementVoucher
SettledAccountingCurrencyAmount	Amount settled	Real (AmountMST)	VendSettlement.SettleAmountMST
SettledTransactionCurrencyAmount	Settled currency	Real (AmountCur)	VendSettlement.SettleAmountCur
CanBeReversed		Enum NoYes	VendSettlement.CanBeReversed
TransactionLegalEntityId	Company accounts	String (CompanyId)	VendSettlement.TransCompany
SysRecId (key)	Record ID	Int64 (RecId)	VendSettlement.RecId

MGCLatticeVendorTransactionEntity

Vendor Transaction

Property	Value
OData entity set	LatticeVendorTransactions (single: LatticeVendorTransaction)
Access	Read-only
Data management	Enabled (staging table MGCLatticeVendorTransactionStaging)
Company	Company-specific (DataAreaId)
Key	SysRecId
Data sources	VendTrans
Granted by	MGCLatticeVendorTransactionEntityMaintain (read); MGCLatticeVendorTransactionEntityView (read)

Field	Label	Type	Source	Mandatory
VendorAccountNumber	Vendor account	String (VendAccount)	VendTrans.AccountNum	Yes
Voucher	Voucher	String (Voucher)	VendTrans.Voucher
TransactionType	Transaction type	Enum LedgerTransType	VendTrans.TransType
TransactionDate	Date	Date (TransDate)	VendTrans.TransDate
DueDate	Due date	Date (DueDate)	VendTrans.DueDate
InvoiceId	Invoice	String (VendInvoiceId)	VendTrans.Invoice
DocumentNumber	Document	String (DocumentNum)	VendTrans.DocumentNum
ClosedDate	Closed date	Date (TransDate)	VendTrans.Closed
AccountingCurrencyAmount	Amount	Real (AmountMSTDebCred)	VendTrans.AmountMST
TransactionCurrencyAmount	Amount in transaction currency	Real (AmountCurDebCred)	VendTrans.AmountCur
CurrencyCode	Currency	String (VendCurrencyCode)	VendTrans.CurrencyCode	Yes
SettledAccountingCurrencyAmount	Settled amount in standard currency	Real (AmountMST)	VendTrans.SettleAmountMST
SettledTransactionCurrencyAmount	Settled currency	Real (AmountCur)	VendTrans.SettleAmountCur
RemainingAccountingCurrencyAmount	Remaining amount in accounting currency	Real (AmountMST)	Computed
RemainingTransactionCurrencyAmount	Remaining amount in transaction currency	Real (AmountCur)	Computed
SysRecId (key)	Record ID	Int64 (RecId)	VendTrans.RecId

MGCLatticeWarehouseReservationEntity

Warehouse Reservation

Property	Value
OData entity set	LatticeWarehouseReservations (single: LatticeWarehouseReservation)
Access	Read-only
Data management	Enabled (staging table MGCLatticeWarehouseReservationStaging)
Company	Company-specific (DataAreaId)
Key	ItemNumber, InventoryDimensionId
Data sources	WHSInventReserve
Granted by	MGCLatticeWarehouseReservationEntityMaintain (read); MGCLatticeWarehouseReservationEntityView (read)

Field	Label	Type	Source	Mandatory
ItemNumber (key)	Item number	String (ItemId)	WHSInventReserve.ItemId	Yes
InventoryDimensionId (key)	Dimension number	String (InventDimId)	WHSInventReserve.InventDimId	Yes
AvailablePhysicalQuantity	Available physical	Real (InventQtyAvailPhysical)	WHSInventReserve.AvailPhysical
AvailableOrderedQuantity	Total available	Real (InventQtyAvailOrdered)	WHSInventReserve.AvailOrdered
ReservedPhysicalQuantity	Physical reserved	Real (InventQtyReservPhysical)	WHSInventReserve.ReservPhysical
ReservedOrderedQuantity	Ordered reserved	Real (InventQtyReservOrdered)	WHSInventReserve.ReservOrdered
ReservationHierarchyLevel	Reservation hierarchy level	Int (WHSReservationHierarchyLevel)	WHSInventReserve.HierarchyLevel
InventorySiteId	Site	String (InventSiteId)	WHSInventReserve.InventSiteId
InventoryWarehouseId	Warehouse	String (InventLocationId)	WHSInventReserve.InventLocationId

MGCLatticeWarehouseWorkEntity

Warehouse Work

Property	Value
OData entity set	LatticeWarehouseWorks (single: LatticeWarehouseWork)
Access	Read-only
Data management	Enabled (staging table MGCLatticeWarehouseWorkStaging)
Company	Company-specific (DataAreaId)
Key	WorkId
Data sources	WHSWorkTable
Granted by	MGCLatticeWarehouseWorkEntityView (read)

Field	Label	Type	Source	Mandatory
WorkId (key)	Work ID	String (WHSWorkId)	WHSWorkTable.WorkId	Yes
WorkStatus	Work status	Enum WHSWorkStatus	WHSWorkTable.WorkStatus
WorkTransactionType	Work order type	Enum WHSWorkTransType	WHSWorkTable.WorkTransType	Yes
OrderNumber	Order number	String (WHSOrderNum)	WHSWorkTable.OrderNum
ShipmentId	Shipment ID	String (WHSShipmentId)	WHSWorkTable.ShipmentId
LoadId	Load ID	String (WHSLoadId)	WHSWorkTable.LoadId
WaveId	Wave ID	String (WHSWaveId)	WHSWorkTable.WaveId
WorkPoolId	Work pool ID	String (WHSWorkPoolId)	WHSWorkTable.WorkPoolId
TargetLicensePlateId	Target license plate ID	String (WHSTargetLicensePlateId)	WHSWorkTable.TargetLicensePlateId
ContainerId	Container ID	String (WHSContainerId)	WHSWorkTable.ContainerId
InventorySiteId	Site	String (InventSiteId)	WHSWorkTable.InventSiteId	Yes
InventoryWarehouseId	Warehouse	String (InventLocationId)	WHSWorkTable.InventLocationId	Yes
WorkTemplateCode	Work template	String (WHSWorkTemplateCode)	WHSWorkTable.WorkTemplateCode
WorkPriority	Work priority	Int (WHSWorkPriority)	WHSWorkTable.WorkPriority
WorkCreatedBy	User ID	String (UserId)	WHSWorkTable.WorkCreatedBy
WorkStartedDateTime	Work in process	UtcDateTime (WHSWorkInProcessUTCDateTime)	WHSWorkTable.WorkInProcessUTCDateTime
WorkClosedDateTime	Closed work	UtcDateTime (WHSWorkClosedUTCDateTime)	WHSWorkTable.WorkClosedUTCDateTime
WorkCancelledDateTime	Canceled work	UtcDateTime (WHSWorkCancelledUTCDateTime)	WHSWorkTable.WorkCancelledUTCDateTime

MGCLatticeWarehouseWorkLineEntity

Warehouse Work Lines

Property	Value
OData entity set	LatticeWarehouseWorkLines (single: LatticeWarehouseWorkLine)
Access	Read-only
Data management	Enabled (staging table MGCLatticeWarehouseWorkLineStaging)
Company	Company-specific (DataAreaId)
Key	WorkId, LineNumber
Data sources	WHSWorkLine, InventDim
Granted by	MGCLatticeWarehouseWorkLineEntityView (read)

Field	Label	Type	Source	Mandatory
WorkId (key)	Work ID	String (WHSWorkId)	WHSWorkLine.WorkId	Yes
LineNumber (key)	Line number	Real (LineNum)	WHSWorkLine.LineNum	Yes
WorkType	Work type	Enum WHSWorkType	WHSWorkLine.WorkType	Yes
WorkStatus	Work status	Enum WHSWorkStatus	WHSWorkLine.WorkStatus
WarehouseLocationId	Location	String (WMSLocationId)	WHSWorkLine.WMSLocationId
AllocatedWarehouseLocationId	Proposed location	String (WMSLocationId)	WHSWorkLine.AllocatedWMSLocationId
ItemNumber	Item number	String (ItemId)	WHSWorkLine.ItemId
InventoryDimensionId	Dimension number	String (InventDimId)	WHSWorkLine.InventDimId
WorkQuantity	Work quantity	Real (WHSQtyWork)	WHSWorkLine.QtyWork
RemainingQuantity	Remaining quantity	Real (WHSQtyRemain)	WHSWorkLine.QtyRemain
InventoryWorkQuantity	Inventory work quantity	Real (WHSInventQtyWork)	WHSWorkLine.InventQtyWork
InventoryRemainingQuantity	Inventory quantity remaining	Real (WHSInventQtyRemain)	WHSWorkLine.InventQtyRemain
UnitSymbol	Unit	String (UnitOfMeasureSymbol)	WHSWorkLine.UnitId
InventoryLotId	Lot ID	String (InventTransId)	WHSWorkLine.InventTransId
LoadId	Load ID	String (WHSLoadId)	WHSWorkLine.LoadId
ShipmentId	Shipment ID	String (WHSShipmentId)	WHSWorkLine.ShipmentId
WorkClassId	Work class ID	String (WHSWorkClassId)	WHSWorkLine.WorkClassId
ZoneId	Zone ID	String (WHSZoneId)	WHSWorkLine.ZoneId
WorkStartedDateTime	Work in process	UtcDateTime (WHSWorkInProcessUTCDateTime)	WHSWorkLine.WorkInProcessUTCDateTime
WorkClosedDateTime	Closed work	UtcDateTime (WHSWorkClosedUTCDateTime)	WHSWorkLine.WorkClosedUTCDateTime
ItemBatchNumber	Batch number	String (InventBatchId)	InventDim.inventBatchId
ItemSerialNumber	Serial number	String (InventSerialId)	InventDim.inventSerialId
InventoryStatusId	Inventory status	String (WHSInventStatusId)	InventDim.InventStatusId
LicensePlateId	License plate	String (WHSLicensePlateId)	InventDim.LicensePlateId

MGCLatticeWithholdingTaxTransactionEntity

Withholding Tax Transaction

Property	Value
OData entity set	LatticeWithholdingTaxTransactions (single: LatticeWithholdingTaxTransaction)
Access	Read-only
Data management	Enabled (staging table MGCLatticeWithholdingTaxTransactionStaging)
Company	Company-specific (DataAreaId)
Key	SysRecId
Data sources	TaxWithholdTrans
Granted by	MGCLatticeWithholdingTaxTransactionEntityMaintain (read); MGCLatticeWithholdingTaxTransactionEntityView (read)

Field	Label	Type	Source	Mandatory
SysRecId (key)	Record ID	Int64 (RecId)	TaxWithholdTrans.RecId
VendorAccountNumber	Vendor account	String (VendAccount)	TaxWithholdTrans.VendAccount
CustomerAccount	Customer account	String (CustAccount)	TaxWithholdTrans.CustAccount
InvoiceId	Invoice	String (InvoiceId)	TaxWithholdTrans.Invoice	Yes
InvoiceAmount	Invoice amount to be paid in invoice currency	Real (AmountCur)	TaxWithholdTrans.InvoiceAmount
InvoiceBaseAmount	Base amount in invoice currency	Real (AmountCur)	TaxWithholdTrans.InvoiceBaseAmount
InvoiceTaxWithholdAmount	Withholding tax in invoice currency	Real (TaxWithholdAmountCur)	TaxWithholdTrans.InvoiceTaxWithholdAmount
JournalNumber	Journal batch number	String (LedgerJournalId)	TaxWithholdTrans.JournalNum
CompetenceDate	Competence date	Date (TransDate)	TaxWithholdTrans.CompetenceDate	Yes
WithholdingTaxCode	Withholding tax code	String (TaxWithholdCode)	TaxWithholdTrans.TaxWithholdCode	Yes

MGCLatticeWorkerActionEntity

Worker action

Property	Value
OData entity set	LatticeWorkerActions (single: LatticeWorkerAction)
Access	Read-only
Data management	Enabled (staging table MGCLatticeWorkerActionStaging)
Company	Shared across companies
Key	PersonnelActionNumber
Data sources	HcmWorker, HcmActionState, HcmWorkerAction
Configuration key	HRMAdministration
Granted by	MGCLatticeWorkerActionEntityMaintain (read); MGCLatticeWorkerActionEntityView (read)

Field	Label	Type	Source	Mandatory
PersonnelActionNumber (key)	Personnel action number	String (HcmActionId)	HcmActionState.ActionId	Yes
PersonnelNumber	Personnel number	String (HcmPersonnelNumberId)	HcmWorker.PersonnelNumber
EffectiveOn	Effective on	UtcDateTime (EffectiveDateTime)	HcmWorkerAction.EffectiveOn
PersonnelActionOriginationPoint	Origination point	Enum HcmPersonnelActionOriginationPoint	HcmWorkerAction.PersonnelActionOriginationPoint
RecordCreatedBy	Created by	String (CreatedBy)	HcmWorkerAction.CreatedBy
RecordCreatedDateTime	Created date and time	UtcDateTime	HcmWorkerAction.CreatedDateTime
RecordModifiedBy	Modified by	String (ModifiedBy)	HcmWorkerAction.ModifiedBy