Skip to main content

MGCLatticePurchaseOrderConfirmationDocumentAttachmentEntity

The MGCLatticePurchaseOrderConfirmationDocumentAttachmentEntity exposes document attachments linked to purchase order confirmation journal records (VendPurchOrderJour), including file metadata and content.

Public collection name: LatticePurchaseOrderConfirmationDocumentAttachments
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
`StorageProviderId`	``	No
`PurchaseOrderNumber`	`PurchIdBase`	No
`ConfirmationNumber`	`PurchaseOrderId`	No
`ConfirmationDate`	`TransDate`	No
`VendorAccountNumber`	`VendAccount`	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`
`StorageProviderId`	`DocuRefEntity`	`StorageProviderId`
`PurchaseOrderNumber`	`VendPurchOrderJour`	`PurchId`
`ConfirmationNumber`	`VendPurchOrderJour`	`PurchOrderDocNum`
`ConfirmationDate`	`VendPurchOrderJour`	`PurchOrderDate`
`VendorAccountNumber`	`VendPurchOrderJour`	`OrderAccount`

Fields
Mappings