paymentitem
The table storing payment item details, used to track different types of payment items in the system for billing and accounting purposes.
Columns
| Name | Type | References | Description |
| account | String | The account associated with the record, used for tracking and managing financial transactions or customer accounts. | |
| availabletopartners | Boolean | Indicates whether the record is available for use by partners, often used to control access or visibility in partner relationships. | |
| class | String | The classification or grouping of the record, used to categorize the item or entity for organizational purposes, such as project or department. | |
| createddate | Datetime | The date and time when the record was created, used for tracking the origin and history of the record. | |
| customform | String | The custom form associated with the record, used to personalize the layout or fields for specific transactions or entities. | |
| department | String | The department within the organization associated with the record, used for tracking, reporting, and categorizing by business unit. | |
| description | String | A detailed description of the record, used to provide additional context or information about the entity or item. | |
| displayname | String | The display name of the record, typically used in user interfaces to identify the record in lists, reports, or search results. | |
| externalid | String | A unique identifier assigned to the record by an external system, used for synchronization and integration with other platforms. | |
| includechildren | Boolean | Indicates whether related or child records should be included when processing or retrieving data for the parent record. | |
| isinactive | Boolean | Indicates whether the record is inactive, often used to flag records that are no longer in use or should be excluded from certain processes. | |
| issueproduct | String | The product or item issued by the record, often used to identify what is being provided or transacted in the context of the record. | |
| itemid | String | The unique identifier or code for the item, used for tracking and referencing the specific product or service. | |
| itemtype | String | The type of item (such as product, service, or resource), used to classify the record based on the nature of the item. | |
| lastmodifieddate | Datetime | The date and time when the record was last modified, used for tracking updates and changes to the record over time. | |
| location | String | The physical or virtual location associated with the record, often used for logistics, inventory, or regional reporting. | |
| paymentmethod | String | The method of payment associated with the record (such as credit card, bank transfer, or PayPal), used for processing transactions. | |
| subsidiary | String | The subsidiary or branch of the parent organization associated with the record, often used in multi-entity financial systems. | |
| undepfunds | String | The funds that are undeposited or pending deposit, typically used in accounting and finance for tracking transactions not yet processed. |