APPymt
Provides detailed information about accounts payable payments, including vendor details, payment amounts, and transaction statuses.
Table Specific Information
Insert
Insert is only supported when UseLegacy=False.
The following example illustrates how to insert into Appymt table:
INSERT INTO Appymt (Financialentity, Paymentmethod, Vendorid, Whencreated, Itemaggregate) VALUES('CHK-WFB0004', 'Printed Check', '874321', '09/20/2024', '<APPYMTDETAIL><RECORDKEY>21331</RECORDKEY><TRX_PAYMENTAMOUNT>10.00</TRX_PAYMENTAMOUNT></APPYMTDETAIL>');
Note: Inserts are not supported with the Legacy API.
Columns
| Name | Type | ReadOnly | Description |
| Recordno [KEY] | String | False |
A unique identifier for the accounts payable payment record. |
| Recordtype | String | False |
The type of record associated with this payment. |
| Recordid | String | False |
The unique identifier for this payment record. |
| Financialentity | String | False |
The financial entity associated with this payment. |
| State | String | False |
The current state or status of the payment. |
| Paymentmethod | String | False |
The payment method used for this transaction. |
| Paymentmethodkey | Int64 | False |
The key for the payment method used in this transaction. |
| Entity | String | False |
The entity associated with this payment. |
| Vendorid | String | False |
The vendor ID associated with this payment. |
| Vendorname | String | False |
The name of the vendor receiving the payment. |
| Docnumber | String | False |
The document number associated with this payment. |
| Description | String | False |
A description of the payment transaction. |
| Description2 | String | False |
An additional description of the payment transaction. |
| Whencreated | Datetime | False |
The date and time when this payment was created. |
| Whenpaid | Datetime | False |
The date and time when the payment was completed. |
| Basecurr | String | False |
The base currency used for this payment. |
| Currency | String | False |
The currency in which the payment was made. |
| Exch_rate_date | Datetime | False |
The date of the exchange rate applied to this payment. |
| Exch_rate_type_id | String | False |
The type of exchange rate applied to this payment. |
| Exchange_rate | Double | False |
The exchange rate applied to this payment. |
| Totalentered | Double | False |
The total amount entered for this payment transaction. |
| Totalselected | Double | False |
The total amount selected for payment. |
| Totalpaid | Double | False |
The total amount paid in this transaction. |
| Totaldue | String | False |
The total amount due for this payment. |
| Trx_totalentered | Double | False |
The total transaction amount entered for this payment. |
| Trx_totalselected | Double | False |
The total transaction amount selected for payment. |
| Trx_totalpaid | Double | False |
The total transaction amount paid. |
| Trx_totaldue | Double | False |
The total transaction amount due. |
| Billtopaytocontactname | String | False |
The contact name associated with the payment recipient. |
| Prbatch | String | False |
The payment batch associated with this transaction. |
| Auwhencreated | Datetime | False |
The audit timestamp of when this payment was created. |
| Whenmodified | Datetime | False |
The date and time when this payment was last modified. |
| Createdby | Int64 | False |
The user ID of the person who created this payment. |
| Modifiedby | Int64 | False |
The user ID of the person who last modified this payment. |
| Megaentitykey | Int64 | False |
The key of the mega entity associated with this payment. |
| Megaentityid | String | False |
The identifier of the mega entity associated with this payment. |
| Record_url | String | False |
A URL to access details of this payment record. |