MGCLatticeFreeTextInvoiceDocumentAttachmentEntity
The MGCLatticeFreeTextInvoiceDocumentAttachmentEntity exposes document attachments linked to free text invoice records (CustInvoiceTable), including file metadata and content. Uses DocuRefEntity as root data source for consistent attachment handling.
- Public collection name:
LatticeFreeTextInvoiceDocumentAttachments
- 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 | |
InvoiceId | CustInvoiceId | No | |
CustomerAccount | CustInvoiceAccount | No | |
ExternalSystem | MGCLatticeExternalSystemId | No | The external system, such as a CRM, a marketplace or a legacy ERP, whose key this is. |
InvoiceIdExternalKey | MGCLatticeExternalKey | No | The external system's key for the posted free text invoice. Send it instead of the invoice 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 |
InvoiceId | CustInvoiceTable | InvoiceId |
CustomerAccount | CustInvoiceTable | InvoiceAccount |