APPaymentItem
Details specific items within accounts payable payments, highlighting allocation, amounts, and associated entities.
Columns
| Name | Type | Description |
| Recordno [KEY] | String | A unique identifier for the accounts payable payment item record. |
| Recordtype | String | The type of record associated with this payment item. |
| Entry_date | Datetime | The date the entry for this payment item was created. |
| Recordkey | Int64 | The unique key identifying the record associated with this payment item. |
| Vendoracctnokeyversion | Int64 | The version of the vendor account number key associated with this payment item. |
| Entrydescription | String | A description of the payment item entry. |
| Accountkey | Int64 | The unique key identifying the account associated with this payment item. |
| Glaccountno | String | The general ledger account number associated with this payment item. |
| Glaccounttitle | String | The title of the general ledger account associated with this payment item. |
| Amount | Double | The amount for this payment item. |
| Locationid | String | The identifier of the location associated with this payment item. |
| Locationname | String | The name of the location associated with this payment item. |
| Departmentid | String | The identifier of the department associated with this payment item. |
| Departmentname | String | The name of the department associated with this payment item. |
| Line_no | String | The line number within the payment record associated with this item. |
| Form1099 | String | Indicates if this payment item is subject to Form 1099 reporting. |
| Accountlabel | String | The account label associated with this payment item. |
| Totalselected | Double | The total amount selected for this payment item. |
| Totalpaid | Double | The total amount paid for this payment item. |
| Parententry | Int64 | The unique key of the parent entry to which this payment item belongs. |
| Lineitem | String | The line item associated with this payment item. |
| Gloffset | Int64 | The general ledger offset associated with this payment item. |
| Baselocation | Int64 | The base location key associated with this payment item. |
| Allocationkey | Int64 | The allocation key associated with this payment item. |
| Allocation | String | The allocation information associated with this payment item. |
| Subtotal | String | The subtotal for this payment item. |
| Deferrevenue | Boolean | Indicates if revenue is deferred for this payment item. |
| Revrectemplatekey | Int64 | The revenue recognition template key associated with this payment item. |
| Revrectemplate | String | The revenue recognition template associated with this payment item. |
| Deferredrevacctkey | Int64 | The key of the deferred revenue account associated with this payment item. |
| Deferredrevacctno | String | The number of the deferred revenue account associated with this payment item. |
| Deferredrevaccttitle | String | The title of the deferred revenue account associated with this payment item. |
| Revrecstartdate | Datetime | The start date for revenue recognition associated with this payment item. |
| Revrecenddate | Datetime | The end date for revenue recognition associated with this payment item. |
| Entrycurrency | String | The currency used for this payment item. |
| Entryexchratedate | Datetime | The exchange rate date for this payment item. |
| Entryexchratetype | Int64 | The exchange rate type for this payment item. |
| Entryexchrate | Double | The exchange rate for this payment item. |
| Trx_amount | Double | The transaction amount for this payment item. |
| Trx_totalselected | Double | The total transaction amount selected for this payment item. |
| Trx_totalpaid | Double | The total transaction amount paid for this payment item. |
| Billable | Boolean | Indicates whether this payment item is billable. |
| Billed | Boolean | Indicates whether this payment item has been billed. |
| State | String | The current state or status of the payment item. |
| Releasetopay | Boolean | Indicates whether this payment item is released for payment. |
| Whencreated | Datetime | The date and time when this payment item was created. |
| Whenmodified | Datetime | The date and time when this payment item was last modified. |
| Createdby | Int64 | The identifier of the user who created this payment item. |
| Modifiedby | Int64 | The identifier of the user who last modified this payment item. |
| Locationkey | Int64 | The location key associated with this payment item. |
| Departmentkey | Int64 | The department key associated with this payment item. |
| Currency | String | The currency used for the payment associated with this item. |
| Accountno | String | The account number associated with this payment item. |
| Accounttitle | String | The title of the account associated with this payment item. |
| Exch_rate_date | Datetime | The exchange rate date for the payment item. |
| Exch_rate_type_id | Int64 | The exchange rate type identifier for the payment item. |
| Exchange_rate | Double | The exchange rate applied to this payment item. |
| Projectdimkey | Int64 | The project dimension key associated with this payment item. |
| Projectid | String | The project identifier associated with this payment item. |
| Projectname | String | The name of the project associated with this payment item. |
| Customerdimkey | Int64 | The customer dimension key associated with this payment item. |
| Customerid | String | The customer identifier associated with this payment item. |
| Customername | String | The name of the customer associated with this payment item. |
| Employeedimkey | Int64 | The employee dimension key associated with this payment item. |
| Employeeid | String | The employee identifier associated with this payment item. |
| Employeename | String | The name of the employee associated with this payment item. |
| Itemdimkey | Int64 | The item dimension key associated with this payment item. |
| Itemid | String | The item identifier associated with this payment item. |
| Itemname | String | The name of the item associated with this payment item. |
| Record_url | String | A URL link to view details of this payment item record. |