ReceivablesInvoicesreceivablesInvoiceLinesattachments
Facilitates attaching supporting files at the line level, clarifying charges or providing proof of delivery.
Columns
| Name | Type | Description |
| ReceivablesInvoicesCustomerTransactionId [KEY] | Long | The unique identifier of the customer transaction associated with the invoice line attachment, linking the attachment to a specific invoice. |
| ReceivablesinvoicelinesCustomerTransactionLineId [KEY] | Long | The unique identifier of the invoice line related to the attachment, connecting the file to a particular line item. |
| AttachedDocumentId [KEY] | Long | The unique identifier of the document attached to the invoice line, used to track the attachment's metadata. |
| LastUpdateDate | Datetime | The date and time when the attachment was last updated, helping with audit tracking and version control. |
| LastUpdatedBy | String | The user who last updated the attachment details, ensuring accountability for changes. |
| DatatypeCode | String | The data type code that indicates the format of the attachment, such as PDF, Word, or Image. |
| FileName | String | The name of the attached file, useful for identification and retrieval purposes. |
| DmFolderPath | String | The folder path within the document management system where the attachment is stored, enabling easy file location. |
| DmDocumentId | String | The unique identifier assigned to the attachment within the document management system, helping to manage and retrieve the document. |
| DmVersionNumber | String | The version number of the attachment, allowing for version control and tracking of document revisions. |
| Url | String | The URL link to access the attachment online, enabling easy sharing and access. |
| CategoryName | String | The category of the attachment, such as 'Invoice', 'Contract', or 'Shipping Documents', for organization. |
| UserName | String | The user name associated with the attachment, typically the user who uploaded the file. |
| Uri | String | The URI (Uniform Resource Identifier) for accessing the attachment, often used in programmatic access. |
| FileUrl | String | The full URL where the attachment file is hosted, allowing for direct access to the file. |
| UploadedText | String | The text content of the attachment, stored for reference or search purposes. |
| UploadedFileContentType | String | The content type of the uploaded file. |
| UploadedFileLength | Long | The size of the attachment file in bytes, used to manage file storage and bandwidth. |
| UploadedFileName | String | The name of the uploaded attachment file, which may differ from the original file name. |
| ContentRepositoryFileShared | Bool | Indicates whether the attachment is shared with other users or systems, facilitating collaborative access. |
| Title | String | The title of the attachment, providing a brief description of the document's content. |
| Description | String | A more detailed description of the attachment, offering context for its content and purpose. |
| ErrorStatusCode | String | The error code associated with the attachment, if any, used for troubleshooting issues during upload or retrieval. |
| ErrorStatusMessage | String | The error message associated with the attachment, providing more detail on the nature of any issues encountered. |
| CreatedBy | String | The user who created the attachment record in the system, providing a traceable point of origin. |
| CreationDate | Datetime | The date and time when the attachment was first created in the system. |
| FileContents | String | The contents of the attachment file, stored as text for quick access or reference. |
| ExpirationDate | Datetime | The expiration date of the attachment content, after which the attachment may no longer be accessible. |
| LastUpdatedByUserName | String | The username of the person who last updated the attachment's details, providing accountability. |
| CreatedByUserName | String | The username of the person who initially created the attachment record in the system. |
| AsyncTrackerId | String | A tracking identifier used by the Attachment UI components during the upload process, useful for monitoring asynchronous operations. |
| FileWebImage | String | A web image representation of the file, typically used for visual previews of the attachment. |
| DownloadInfo | String | A JSON object containing information needed to programmatically retrieve the attachment file, used by API calls. |
| PostProcessingAction | String | The name of an action to be performed after the attachment is uploaded, such as 'Generate PDF' or 'Send Notification'. |
| AccountingDate | Date | The accounting date related to the attachment, ensuring that the document is tied to the correct financial period. |
| AllowCompletion | String | Indicates whether the attachment process can be completed, ensuring that all necessary steps are performed before finalizing. |
| BillingDate | Date | The date when the billing related to the attachment occurred, relevant for financial reporting. |
| BillToCustomerName | String | The name of the customer being billed, helping to identify the recipient of the invoice or associated document. |
| BillToCustomerNumber | String | The customer number assigned to the bill-to customer, used for tracking and customer relationship management. |
| BillToSite | String | The physical site or address of the bill-to customer, important for shipping and invoicing purposes. |
| BusinessUnit | String | The business unit associated with the invoice line and attachment, ensuring accurate financial reporting within an organization. |
| CrossReference | String | A reference code used to link the attachment to other documents or transactions, helping with document relationships. |
| CustomerTransactionId | Long | The customer transaction ID associated with the attachment, allowing for traceability and linkage to a specific customer transaction. |
| DocumentNumber | Long | The document number of the invoice line or associated transaction, facilitating identification and retrieval. |
| DueDate | Date | The due date for the payment or action associated with the attachment, important for managing deadlines. |
| Finder | String | A reference field for quickly searching and locating the attachment within the system. |
| FirstPartyTaxRegistration | String | The tax registration number of the first party involved in the transaction, required for tax compliance. |
| InvoiceCurrencyCode | String | The currency code used for the invoice associated with the attachment, ensuring correct financial reporting. |
| InvoiceStatus | String | The current status of the invoice related to the attachment, such as 'Paid', 'Unpaid', or 'Pending'. |
| LegalEntityIdentifier | String | The unique identifier for the legal entity responsible for the transaction, ensuring proper accounting and compliance. |
| PaymentTerms | String | The agreed payment terms for the invoice associated with the attachment, such as 'Net 30' or 'Due on Receipt'. |
| PurchaseOrder | String | The purchase order number linked to the invoice line, used for matching invoices to purchase orders. |
| ShipToCustomerName | String | The name of the customer receiving the goods or services, relevant for shipping purposes. |
| ShipToSite | String | The address or location where the goods or services are being shipped, ensuring accurate delivery. |
| ThirdPartyTaxRegistration | String | The tax registration number of a third-party involved in the transaction, needed for third-party tax compliance. |
| TransactionDate | Date | The date when the transaction generating the invoice line and attachment occurred. |
| TransactionNumber | String | The unique transaction number associated with the invoice line, used to track the transaction across systems. |
| TransactionSource | String | The origin or source of the transaction, such as 'Sales Order' or 'Credit Memo', helping to classify the attachment. |
| TransactionType | String | The type of transaction linked to the attachment, such as 'Sale', 'Refund', or 'Adjustment', which helps categorize the document. |