Skip to main content

MGCLatticePurchaseInvoiceDocumentAttachmentEntity

The MGCLatticePurchaseInvoiceDocumentAttachmentEntity exposes document attachments linked to purchase invoice journal records (VendInvoiceJour), including file metadata and content. Uses DocuRefEntity as root data source for consistent attachment handling.

  • Public collection name: LatticePurchaseInvoiceDocumentAttachments
  • Primary key: DocumentId

Fields​

NameTypeMandatoryDescription
DocumentIdDocuDocumentIdNo
ActualCompanyId``No
DocumentAttachmentTypeCodeDocuTypeIdNo
AttachmentDescriptionDescriptionNo
NotesNotesNo
AccessRestrictionDocuRestrictionNo
AttachmentBitMapNo
FileNameFilenameNo
FileTypeFilenameTypeNo
IsDefaultAttachmentDocuDefaultAttachmentNo
PurchaseOrderNumberPurchIdBaseNo
InvoiceIdVendInvoiceIdNo
InvoiceDateTransDateNo
VendorAccountNumberVendAccountNo
InvoiceAccountVendInvoiceAccountNo
ExternalSystemMGCLatticeExternalSystemIdNoThe external system, such as a CRM, a marketplace or a legacy ERP, whose key this is.
PurchaseOrderNumberExternalKeyMGCLatticeExternalKeyNoThe external system's key for the purchase order. Send it instead of the purchase order number.

Mappings​

Entity fieldData sourceField
DocumentIdDocuRefEntityDocumentId
ActualCompanyIdDocuRefEntityActualCompanyId
DocumentAttachmentTypeCodeDocuRefEntityTypeId
AttachmentDescriptionDocuRefEntityName
NotesDocuRefEntityNotes
AccessRestrictionDocuRefEntityRestriction
AttachmentDocuRefEntityFileContents
FileNameDocuRefEntityFileName
FileTypeDocuRefEntityFileType
IsDefaultAttachmentDocuRefEntityDefaultAttachment
PurchaseOrderNumberVendInvoiceJourPurchId
InvoiceIdVendInvoiceJourInvoiceId
InvoiceDateVendInvoiceJourInvoiceDate
VendorAccountNumberVendInvoiceJourOrderAccount
InvoiceAccountVendInvoiceJourInvoiceAccount