vendorAchAcct
Maintains vendor ACH (Automated Clearing House) account details for electronic payments, streamlining financial transactions.
Columns
| Name | Type | References | Description |
| id [KEY] | Integer | Unique identifier for the vendor's Automated Clearing House (ACH) account, serving as a primary key for tracking specific account details. | |
| accountnumber | String | Represents the bank account number linked to a vendor's ACH payment information, essential for accurate electronic fund transfers and ensuring correct payment deposits. | |
| addenda | String | Information on payments related to ACH transactions, useful for transmitting structured or unstructured remittance details or notes included with the payment. | |
| bankname | String | Specifies the name of the financial institution linked to a vendor's ACH account, which is crucial for processing electronic payments to vendors. | |
| banknumber | String | The bank's transit number identifies the institution, essential for processing electronic payments and routing transactions correctly. | |
| idnumber | String | The vendor's identification number assigned by the bank, which is used for electronic payments and direct deposits. | |
| includetransaction | Boolean | Indicates whether transactions related to a specific vendor ACH account should be included in payment processing and reporting workflow. | |
| isinactive | Boolean | Indicates whether this vendor ACH account is active or inactive, typically used for account management. | |
| issavings | Boolean | Specifies whether the account is a savings account 'true' or a checking account 'false', distinguishing between different types of vendor bank accounts used for ACH transactions. | |
| limit | Decimal | The maximum allowable amount that can be processed for a single ACH transaction or over a specified period, such as daily, weekly, or monthly limits for a given vendor. | |
| routingnumber | String | The routing number associated with the vendor's bank account, ensuring payments are sent to the correct financial institution. | |
| sendaddenda | Boolean | Specifies whether addenda records should be included when processing ACH payments for a vendor's bank account. |