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
| Name | Type | Mandatory | Description |
|---|
DocumentId | DocuDocumentId | No | |
ActualCompanyId | `` | No | |
DocumentAttachmentTypeCode | DocuTypeId | No | |
AttachmentDescription | Description | No | |
Notes | Notes | No | |
AccessRestriction | DocuRestriction | No | |
Attachment | BitMap | No | |
FileName | Filename | No | |
FileType | FilenameType | No | |
IsDefaultAttachment | DocuDefaultAttachment | No | |
PurchaseOrderNumber | PurchIdBase | No | |
InvoiceId | VendInvoiceId | No | |
InvoiceDate | TransDate | No | |
VendorAccountNumber | VendAccount | No | |
InvoiceAccount | VendInvoiceAccount | No | |
ExternalSystem | MGCLatticeExternalSystemId | No | The external system, such as a CRM, a marketplace or a legacy ERP, whose key this is. |
PurchaseOrderNumberExternalKey | MGCLatticeExternalKey | No | The external system's key for the purchase order. Send it instead of the purchase order number. |
Mappings
| Entity field | Data source | Field |
|---|
DocumentId | DocuRefEntity | DocumentId |
ActualCompanyId | DocuRefEntity | ActualCompanyId |
DocumentAttachmentTypeCode | DocuRefEntity | TypeId |
AttachmentDescription | DocuRefEntity | Name |
Notes | DocuRefEntity | Notes |
AccessRestriction | DocuRefEntity | Restriction |
Attachment | DocuRefEntity | FileContents |
FileName | DocuRefEntity | FileName |
FileType | DocuRefEntity | FileType |
IsDefaultAttachment | DocuRefEntity | DefaultAttachment |
PurchaseOrderNumber | VendInvoiceJour | PurchId |
InvoiceId | VendInvoiceJour | InvoiceId |
InvoiceDate | VendInvoiceJour | InvoiceDate |
VendorAccountNumber | VendInvoiceJour | OrderAccount |
InvoiceAccount | VendInvoiceJour | InvoiceAccount |