ARInvoiceItem
Details line items in accounts receivable invoices, providing financial and dimensional insights.
Columns
| Name | Type | Description |
| Recordno [KEY] | String | Unique identifier for the AR invoice item. |
| Recordkey | Int64 | Unique record key in the database. |
| Accountkey | Int64 | Key identifying the account associated with the item. |
| Accountno | String | Account number related to the invoice item. |
| Offsetglaccountno | String | Offset GL account number. |
| Offsetglaccounttitle | String | Title of the offset GL account. |
| Accounttitle | String | Title of the account. |
| Accountlabelkey | Int64 | Key for the associated account label. |
| Accountlabel | String | Label for the account. |
| Entry_date | Datetime | Date the entry was created. |
| Amount | Double | Monetary amount of the item. |
| Trx_amount | Double | Transaction amount of the item. |
| Departmentid | String | Identifier for the department. |
| Departmentname | String | Name of the department. |
| Locationid | String | Identifier for the location. |
| Locationname | String | Name of the location. |
| Entrydescription | String | Description of the invoice entry. |
| Exch_rate_date | Datetime | Date the exchange rate was applied. |
| Exch_rate_type_id | Int64 | Type ID for the exchange rate. |
| Exchange_rate | Double | Exchange rate used for the transaction. |
| Allocationkey | Int64 | Key identifying the allocation for the item. |
| Allocation | String | Allocation details for the item. |
| Lineitem | String | Line item identifier. |
| Line_no | String | Line number within the invoice. |
| Currency | String | Currency of the transaction. |
| Basecurr | String | Base currency of the transaction. |
| Totalpaid | Double | Total amount paid for this line item. |
| Trx_totalpaid | Double | Transaction currency total paid. |
| Totalselected | Double | Total amount selected for payment. |
| Trx_totalselected | Double | Transaction currency total selected. |
| Subtotal | String | Subtotal for this line item. |
| Parententry | Int64 | Identifier for the parent entry. |
| Deferrevenue | Boolean | Indicates whether revenue is deferred. |
| Revrectemplatekey | Int64 | Key for the revenue recognition template. |
| Revrectemplate | String | Revenue recognition template. |
| Deferredrevacctkey | Int64 | Key for the deferred revenue account. |
| Deferredrevacctno | String | Account number for deferred revenue. |
| Deferredrevaccttitle | String | Title of the deferred revenue account. |
| Revrecstartdate | Datetime | Start date for revenue recognition. |
| Revrecenddate | Datetime | End date for revenue recognition. |
| Baselocation | Int64 | Base location identifier for the invoice item. |
| State | String | Current state of the line item. |
| Recordtype | String | Type of record for the AR invoice item. |
| Whencreated | Datetime | Timestamp when this record was created. |
| Whenmodified | Datetime | Timestamp when this record was last modified. |
| Createdby | Int64 | User ID of the record creator. |
| Modifiedby | Int64 | User ID of the last modifier. |
| Projectdimkey | Int64 | Key for the associated project dimension. |
| Projectid | String | Project identifier. |
| Projectname | String | Name of the associated project. |
| Customerdimkey | Int64 | Key for the associated customer dimension. |
| Customerid | String | Customer identifier. |
| Customername | String | Name of the customer. |
| Vendordimkey | Int64 | Key for the associated vendor dimension. |
| Vendorid | String | Vendor identifier. |
| Vendorname | String | Name of the vendor. |
| Employeedimkey | Int64 | Key for the associated employee dimension. |
| Employeeid | String | Employee identifier. |
| Employeename | String | Name of the employee. |
| Itemdimkey | Int64 | Key for the associated item dimension. |
| Itemid | String | Item identifier. |
| Itemname | String | Name of the item. |
| Classdimkey | Int64 | Key for the associated class dimension. |
| Classid | String | Class identifier. |
| Classname | String | Name of the class. |
| Record_url | String | URL for viewing the record. |