vendorpayment
Records vendor payments, including payment methods, amounts, and transaction details.
Columns
| Name | Type | References | Description |
| account | String | The general ledger account from which the vendor payment is made. This typically represents a cash or bank account used for outgoing payments. | |
| apacct | String | The accounts payable account associated with the vendor payment. This represents the liability account where payables are recorded. | |
| approvalstatus | String | The current approval status of the vendor payment. This indicates whether the payment is pending, approved, or rejected. | |
| availablebalance | Decimal | The available balance in the account from which the payment is made. This balance reflects funds that are not committed elsewhere. | |
| balance | Decimal | The total outstanding balance for the selected account, including all transactions that affect the balance. | |
| billpay | Boolean | Indicates whether the payment is designated for bill payments. If the value is 'true', the payment is linked to outstanding vendor bills. | |
| class | String | The classification associated with the vendor payment, often used for tracking purposes such as department, project, or cost center. | |
| cleared | Boolean | Indicates whether the payment has been cleared from the bank. If the value is 'true', the payment has been successfully processed. | |
| cleareddate | Date | The date when the payment was marked as cleared. This is typically the date the bank confirms the transaction. | |
| createddate | Datetime | The date and time when the vendor payment record was created in the system. | |
| currency | String | The currency in which the vendor payment is made. This ensures correct exchange rate application for foreign transactions. | |
| currencyname | String | The full name of the currency used for the payment, such as 'United States Dollar' or 'Euro'. | |
| currencysymbol | String | The symbol of the currency used in the payment, such as '$' for USD or '€' for EUR. | |
| customform | String | The custom form associated with the vendor payment, allowing customization of payment processing and reporting. | |
| department | String | The department associated with the payment, used for categorization and financial reporting. | |
| entity | String | The vendor receiving the payment. This references the vendor record in the system. | |
| entitynexus | String | The tax nexus associated with the vendor, defining the tax jurisdiction applicable to the transaction. | |
| exchangerate | Decimal | The exchange rate used for converting the transaction amount if the payment is made in a foreign currency. | |
| externalid | String | An external identifier used to reference the vendor payment in external systems or integrations. | |
| isbasecurrency | Boolean | Indicates whether the transaction is in the base currency of the company. If the value is 'true', no currency conversion is needed. | |
| isintransitpayment | Boolean | Indicates whether the payment is in transit, meaning it has been issued but not yet cleared by the bank. | |
| lastmodifieddate | Datetime | The date and time when the vendor payment record was last modified in the system. | |
| location | String | The location associated with the payment, often used for tracking transactions by branch, store, or warehouse. | |
| memo | String | A note or description included with the payment, typically used for reference or additional details. | |
| nextapprover | String | The next approver required in the approval workflow for the payment. | |
| nexus | String | The tax jurisdiction associated with the payment, used for regulatory compliance and tax reporting. | |
| payeeaddress | String | The mailing address of the payee receiving the payment, typically used for check payments. | |
| payeeaddresslist | String | A list of addresses associated with the payee, allowing selection of the appropriate payment destination. | |
| postingperiod | String | The financial period in which the payment is recorded. This affects financial reporting and period-end reconciliation. | |
| printvoucher | Boolean | Indicates whether a payment voucher should be printed for this transaction. | |
| status | String | The current status of the vendor payment, such as pending, paid, or voided. | |
| statusref | String | A reference value indicating the internal status code for the payment status. | |
| subsidiary | String | The subsidiary associated with the payment, relevant for multi-entity financial management. | |
| toach | Boolean | Indicates whether the payment is set up for Automated Clearing House (ACH) processing. | |
| tobeemailed | Boolean | Indicates whether the payment details should be sent via email to the vendor. | |
| tobeprinted | Boolean | Indicates whether a check or other payment document should be printed for this transaction. | |
| total | Decimal | The total amount of the vendor payment, including all applied invoices and adjustments. | |
| trandate | Date | The date of the vendor payment transaction, typically representing the payment issuance date. | |
| tranid | String | The unique transaction identifier assigned to the vendor payment. This is used for tracking and reconciliation. | |
| transactionnumber | String | The system-generated number assigned to the vendor payment transaction for reference. | |
| unapplied | Decimal | The portion of the payment amount that has not yet been applied to vendor bills or other charges. |