ReceivablesCreditMemosnotes
Holds note objects for credit memos, capturing additional instructions, clarifications, or comments.
Columns
| Name | Type | Description |
| ReceivablesCreditMemosCustomerTransactionId [KEY] | Long | The unique identifier of the customer transaction associated with the credit memo, linking the note to a specific transaction in Receivables Credit Memos. |
| NoteId [KEY] | Long | The unique identifier for the note within the ReceivablesCreditMemosnotes table, allowing individual tracking of each note. |
| SourceObjectCode | String | The source object code, used to identify the origin or category of the object associated with the note, based on the OBJECTS Metadata. |
| SourceObjectId | String | The unique identifier for the parent source object related to the note, providing a link to the associated parent entity in the database. |
| PartyName | String | The name of the party (for example, customer, supplier) associated with the note in the Receivables Credit Memos system. |
| NoteTxt | String | The actual content of the note, typically in text format, used to capture details or comments regarding the credit memo or associated transaction. |
| NoteTypeCode | String | A code used to categorize the note type, enabling classification of notes into various types such as internal or external notes. |
| VisibilityCode | String | Indicates the visibility level of the note. This code determines whether the note is visible internally, externally, or is restricted to specific users. |
| CreatorPartyId | Long | The unique identifier of the party responsible for creating the note, ensuring traceability of the note's origin. |
| CreatedBy | String | The username or ID of the person who created the note, ensuring accountability for the creation of each note. |
| CreationDate | Datetime | The date and time when the note was created, providing context for its relevance and timeliness. |
| LastUpdateDate | Datetime | The date and time when the note was last updated, helping to track the latest modifications. |
| PartyId | Long | The unique identifier of the party related to the note, typically linking it to the customer or supplier in the Receivables Credit Memos system. |
| CorpCurrencyCode | String | The corporate currency code used for extensibility, providing the currency in which the credit memo or transaction is handled. |
| CurcyConvRateType | String | The type of currency conversion rate applied to the credit memo or transaction, which influences how foreign currency amounts are converted. |
| CurrencyCode | String | The specific currency code used for the credit memo or transaction, facilitating currency handling and conversion in multi-currency environments. |
| ContactRelationshipId | Long | The ID of the relationship populated when the note is associated with a contact, enabling direct links to the related contact. |
| ParentNoteId | Long | The unique identifier of the parent note, used to create a hierarchical structure of notes, where one note can reference another. |
| LastUpdatedBy | String | The username or ID of the person who last updated the note, ensuring proper tracking of changes. |
| LastUpdateLogin | String | The login session or identifier that corresponds to the last update of the note, providing security context. |
| EmailAddress | String | The email address associated with the note, typically used for sending notifications or reminders related to the credit memo. |
| FormattedAddress | String | The address associated with the note, formatted for clarity and presentation, typically used for mailing or notification purposes. |
| FormattedPhoneNumber | String | The phone number related to the note, formatted for easy reading, often used for contact purposes. |
| UpdateFlag | Bool | Indicates whether the note is marked for update, helping identify if the note is in an editable state. |
| DeleteFlag | Bool | Indicates whether the note is flagged for deletion, typically used to mark notes for removal from the system. |
| NoteNumber | String | An alternate unique identifier for the note, which can be system-generated or come from an external system, providing another way to reference the note. |
| NoteTitle | String | The title of the note, entered by the user, used to provide a brief description or label for the note. |
| BindAccountingDate | Date | The accounting date associated with the note, used for financial reporting and reconciliation purposes. |
| BindAllowCompletion | String | Indicates whether the transaction associated with the note is allowed to complete. A 'Y' value typically indicates that the note-related transaction can be finished. |
| BindBillToCustomer | String | The bill-to customer associated with the note, ensuring the note is linked to the correct billing party. |
| BindBillToCustomerNumber | String | The bill-to customer number, providing a unique identifier for the customer in the billing system. |
| BindBillToSite | String | The site number of the bill-to customer, used to link the note to the specific site within the billing customer organization. |
| BindBusinessUnit | String | The business unit associated with the note, identifying the unit responsible for the credit memo or transaction. |
| BindCreditMemoCurrency | String | The currency used for the credit memo, ensuring the note is linked to the correct currency context. |
| BindCreditMemoStatus | String | The current status of the credit memo linked to the note, indicating whether it is complete, pending, or in any other state. |
| BindCrossReference | String | The cross-reference used to relate the note to other transactions or documents in the system, typically used for reconciliations. |
| BindDeliveryMethod | String | The method of delivery associated with the note, such as email, fax, or physical mail. |
| BindDocumentNumber | Long | The document number associated with the note, helping to link it to a specific document in the Receivables Credit Memos system. |
| BindIntercompany | String | Indicates whether the note is related to an intercompany transaction, marked as 'Y' if applicable. |
| BindPrimarySalesperson | String | The primary salesperson associated with the transaction or credit memo related to the note. |
| BindPrintStatus | String | The print status of the note, indicating whether the associated transaction has been printed. |
| BindPurchaseOrder | String | The purchase order linked to the note, ensuring it is connected to the correct order for reference. |
| BindShipToCustomerName | String | The name of the customer receiving the shipment, linked to the note. |
| BindShipToSite | String | The site number of the customer receiving the shipment, associated with the note. |
| BindTransactionDate | Date | The transaction date associated with the note, used for record-keeping and reporting. |
| BindTransactionNumber | String | The transaction number linked to the note, used for identifying the specific transaction. |
| BindTransactionSource | String | The source system of the transaction related to the note, helping to trace the origin of the transaction. |
| BindTransactionType | String | The type of the transaction, such as a sale, return, or other types of transactions, associated with the note. |
| CustomerTransactionId | Long | The customer transaction ID linked to the note, ensuring it references the correct customer transaction. |
| Finder | String | A search term or reference used to locate the note within the system. |