ARPaymentItem
Tracks individual items within AR payments, offering insights into payment allocation and transaction details.
Columns
| Name | Type | Description |
| Recordno [KEY] | String | Unique identifier for the AR payment item record. |
| Recordtype | String | Type of the record. |
| Entry_date | Datetime | Date of the payment entry. |
| Recordkey | Int64 | Key of the record. |
| Vendoracctnokeyversion | Int64 | Version key of the vendor account. |
| Entrydescription | String | Description of the entry. |
| Accountkey | Int64 | Key of the associated account. |
| Glaccountno | String | General ledger account number. |
| Glaccounttitle | String | Title of the general ledger account. |
| Amount | Double | Amount of the payment item. |
| Locationid | String | Identifier of the location. |
| Locationname | String | Name of the location. |
| Departmentid | String | Identifier of the department. |
| Departmentname | String | Name of the department. |
| Line_no | String | Line number associated with the payment item. |
| Form1099 | String | Form 1099 associated information. |
| Accountlabel | String | Label of the account. |
| Totalselected | Double | Total amount selected. |
| Totalpaid | Double | Total amount paid. |
| Parententry | Int64 | Key of the parent entry. |
| Lineitem | String | Item associated with the line. |
| Gloffset | Int64 | Offset for the general ledger. |
| Baselocation | Int64 | Base location identifier. |
| Allocationkey | Int64 | Allocation key for the payment item. |
| Allocation | String | Allocation information. |
| Subtotal | String | Subtotal amount for the payment item. |
| Deferrevenue | Boolean | Indicates if the revenue is deferred. |
| Revrectemplatekey | Int64 | Revenue recognition template key. |
| Revrectemplate | String | Revenue recognition template name. |
| Deferredrevacctkey | Int64 | Deferred revenue account key. |
| Deferredrevacctno | String | Deferred revenue account number. |
| Deferredrevaccttitle | String | Deferred revenue account title. |
| Revrecstartdate | Datetime | Revenue recognition start date. |
| Revrecenddate | Datetime | Revenue recognition end date. |
| Entrycurrency | String | Currency of the entry. |
| Entryexchratedate | Datetime | Exchange rate date for the entry. |
| Entryexchratetype | Int64 | Exchange rate type for the entry. |
| Entryexchrate | Double | Exchange rate for the entry. |
| Trx_amount | Double | Transaction amount. |
| Trx_totalselected | Double | Total amount selected in the transaction. |
| Trx_totalpaid | Double | Total amount paid in the transaction. |
| Billable | Boolean | Indicates if the item is billable. |
| Billed | Boolean | Indicates if the item has been billed. |
| State | String | Current state of the payment item. |
| Releasetopay | Boolean | Indicates if the item is released for payment. |
| Whencreated | Datetime | Timestamp when the item was created. |
| Whenmodified | Datetime | Timestamp when the item was last modified. |
| Createdby | Int64 | Key of the user who created the item. |
| Modifiedby | Int64 | Key of the user who last modified the item. |
| Locationkey | Int64 | Key for the location associated with this payment item. |
| Departmentkey | Int64 | Key for the department associated with this payment item. |
| Currency | String | Currency used for this payment item. |
| Accountno | String | Account number associated with this payment item. |
| Accounttitle | String | Title or name of the account linked to this payment item. |
| Exch_rate_date | Datetime | Date of the exchange rate applied to this payment item. |
| Exch_rate_type_id | Int64 | Identifier for the type of exchange rate used for this payment item. |
| Exchange_rate | Double | Exchange rate applied to this payment item. |
| Projectdimkey | Int64 | Key representing the project dimension linked to this payment item. |
| Projectid | String | Unique identifier for the project associated with this payment item. |
| Projectname | String | Name of the project linked to this payment item. |
| Vendordimkey | Int64 | Key representing the vendor dimension linked to this payment item. |
| Vendorid | String | Unique identifier for the vendor associated with this payment item. |
| Vendorname | String | Name of the vendor linked to this payment item. |
| Employeedimkey | Int64 | Key representing the employee dimension linked to this payment item. |
| Employeeid | String | Unique identifier for the employee associated with this payment item. |
| Employeename | String | Name of the employee linked to this payment item. |
| Itemdimkey | Int64 | Key representing the item dimension linked to this payment item. |
| Itemid | String | Unique identifier for the item associated with this payment item. |
| Itemname | String | Name of the item linked to this payment item. |
| Record_url | String | URL for accessing the AR payment item record. |