ReceivablesInvoicesattachments
Manages the supporting documents attached to a receivables invoice, ensuring compliance and clarity for invoice recipients.
Columns
Name | Type | Description |
ReceivablesInvoicesCustomerTransactionId [KEY] | Long | The unique identifier of the customer transaction associated with the invoice attachment. |
AttachedDocumentId [KEY] | Long | A unique identifier assigned to a document that is attached to the invoice, allowing for easier reference and retrieval. |
LastUpdateDate | Datetime | The most recent date and time when the invoice attachment was updated. This is useful for tracking changes over time. |
LastUpdatedBy | String | The username of the person who last updated the invoice attachment, helping to identify who made recent changes. |
DatatypeCode | String | A code representing the data type of the attachment. It indicates the format or structure of the file (for example, PDF, Word, etc.). |
FileName | String | The name of the attachment file, typically reflecting the contents or purpose of the document. |
DmFolderPath | String | The path where the attachment is stored within the document management system. This provides information on its location in the file system. |
DmDocumentId | String | The unique identifier for the attachment within the document management system, ensuring proper linkage to the document. |
DmVersionNumber | String | The version number of the document attached to the invoice, allowing for version control and ensuring the most recent version is accessed. |
Url | String | The URL to access the attachment, typically used for online viewing or retrieval from an external system. |
CategoryName | String | The category or type of the attachment (for example, 'Invoice', 'Contract', 'Payment Proof'), used for organizing documents. |
UserName | String | The username of the person who uploaded or is associated with the attachment, useful for tracking ownership. |
Uri | String | The Uniform Resource Identifier (URI) that uniquely identifies the attachment within the document management system. |
FileUrl | String | The direct URL to the attachment file itself, used for downloading or viewing the file in its original format. |
UploadedText | String | The text content of a newly uploaded attachment, useful for text-based attachments such as notes or messages. |
UploadedFileContentType | String | The content type of the uploaded attachment, specifying its format. |
UploadedFileLength | Long | The file size of the uploaded attachment, typically measured in bytes, helping to assess the file's impact on storage. |
UploadedFileName | String | The name assigned to the uploaded attachment file, which can be different from the original file name. |
ContentRepositoryFileShared | Bool | Indicates whether the attachment is shared within the document repository. A 'true' value means it is accessible by others. |
Title | String | The title of the attachment, which is typically a brief description or label used to summarize the document's content. |
Description | String | A more detailed description of the attachment, explaining its purpose, contents, or relevance to the invoice. |
ErrorStatusCode | String | A code indicating the error, if any, associated with the attachment. This is used for error tracking and resolution. |
ErrorStatusMessage | String | A message describing the error, providing more detail on why the attachment could not be processed or uploaded. |
CreatedBy | String | The username of the individual who created or uploaded the attachment, important for tracking the source of the document. |
CreationDate | Datetime | The date and time when the attachment was created or uploaded to the system, marking the beginning of its existence in the repository. |
FileContents | String | The actual contents of the file, typically represented as text or encoded data. This is important for text-based attachments. |
ExpirationDate | Datetime | The date when the contents of the attachment are set to expire, after which the attachment may no longer be accessible or valid. |
LastUpdatedByUserName | String | The username of the individual who last updated the attachment details, helping to track updates over time. |
CreatedByUserName | String | The username of the person who initially created the attachment, used for historical reference. |
AsyncTrackerId | String | An identifier used by the Attachment UI components to track the asynchronous upload process, ensuring uploads complete successfully. |
FileWebImage | String | An image representation of the attachment (if applicable), used for visual previews of the file within the web interface. |
DownloadInfo | String | A JSON object that contains information used to programmatically retrieve the file attachment, such as file location and access details. |
PostProcessingAction | String | The name of the action to be performed after the attachment is uploaded, such as indexing, validation, or notifying other systems. |
AccountingDate | Date | The date used for accounting purposes, typically indicating when the attachment (invoice) was recorded in the system. |
AllowCompletion | String | A flag indicating whether the attachment can be completed or finalized, useful for workflows requiring approval or review. |
BillingDate | Date | The date when the billing information related to the attachment was generated, typically matching the invoice date. |
BillToCustomerName | String | The name of the customer to whom the invoice (and associated attachment) is billed. |
BillToCustomerNumber | String | The customer number assigned to the bill-to customer, used for identifying the customer in the system. |
BillToSite | String | The site identifier for the bill-to customer, indicating the specific location or address where the invoice is being sent. |
BusinessUnit | String | The business unit associated with the attachment, typically representing the department or division handling the transaction. |
CrossReference | String | A reference identifier for tracking purposes, often used to link the attachment to another related document or system. |
CustomerTransactionId | Long | The identifier of the customer transaction associated with the attachment, used to track the specific transaction. |
DocumentNumber | Long | The document number assigned to the attachment, ensuring it is uniquely identified within the system. |
DueDate | Date | The date by which the payment or action related to the attachment is due, important for managing payment deadlines. |
Finder | String | A field used for searching and locating the attachment based on specific criteria or keywords. |
FirstPartyTaxRegistration | String | The tax registration number of the deploying company, used for tax reporting and compliance. |
InvoiceCurrencyCode | String | The currency code used for the invoice associated with the attachment, ensuring proper handling of currency conversions. |
InvoiceStatus | String | The status of the invoice, indicating whether it is 'Complete', 'Pending', or 'Overdue'. This field tracks the progress of invoice processing. |
LegalEntityIdentifier | String | The identifier for the legal entity under which the invoice and attachment were created, used for legal and tax purposes. |
PaymentTerms | String | The payment terms associated with the invoice, specifying the due date and conditions under which payment is expected. |
PurchaseOrder | String | The purchase order number linked to the invoice, used for reference and to ensure the invoice matches the original order. |
ShipToCustomerName | String | The name of the customer receiving the goods or services, which may differ from the bill-to customer. |
ShipToSite | String | The site number where the goods or services were delivered, indicating the shipping location of the invoice items. |
ThirdPartyTaxRegistration | String | The tax registration number of a third-party entity, often used for transactions involving external parties or resellers. |
TransactionDate | Date | The date the transaction associated with the attachment took place, marking when the goods or services were provided. |
TransactionNumber | String | The unique number assigned to the transaction associated with the attachment, used for identification and reference. |
TransactionSource | String | The source from which the transaction originated, such as a sales order, contract, or other business transaction. |
TransactionType | String | The type of transaction (for example, sale, return, adjustment) associated with the attachment, important for classification and reporting purposes. |