ARAdjustmentItem
Details line items associated with accounts receivable adjustments for in-depth reporting and tracking.
Columns
| Name | Type | Description |
| Recordno [KEY] | String | Unique identifier for the AR adjustment Item. |
| Recordkey | Int64 | Unique key for this line item. |
| Accountkey | Int64 | Key representing the GL account associated with this item. |
| Accountno | String | General Ledger account number. |
| Offsetglaccountno | String | Offsetting GL account number, if applicable. |
| Offsetglaccounttitle | String | Title of the offset GL account. |
| Accounttitle | String | Title of the associated GL account. |
| Accountlabelkey | Int64 | Key representing the account label. |
| Accountlabel | String | Label assigned to the account for classification. |
| Entry_date | Datetime | The date of entry for this adjustment item. |
| Amount | Double | Monetary value of this line item. |
| Trx_amount | Double | Transaction amount in the item's currency. |
| Departmentid | String | Identifier for the department associated with this item. |
| Departmentname | String | Name of the department associated with this item. |
| Locationid | String | Identifier for the location associated with this item. |
| Locationname | String | Name of the location associated with this item. |
| Entrydescription | String | Description of this adjustment entry. |
| Exch_rate_date | Datetime | Date for the applicable exchange rate. |
| Exch_rate_type_id | Int64 | Identifier for the type of exchange rate used. |
| Exchange_rate | Double | Exchange rate applied to this item. |
| Lineitem | String | Identifier for the line item. |
| Line_no | String | Line number of the adjustment item. |
| Currency | String | Currency used for this adjustment item. |
| Basecurr | String | Base currency for this adjustment item. |
| Totalpaid | Double | Total amount paid for this line item. |
| Trx_totalpaid | Double | Transaction amount paid in the item's currency. |
| Totalselected | Double | Total amount selected for this line item. |
| Trx_totalselected | Double | Transaction amount selected in the item's currency. |
| Parententry | Int64 | Parent entry key for this adjustment item. |
| Baselocation | Int64 | Base location identifier for this item. |
| State | String | State of the item, for example, Open or Closed. |
| Recordtype | String | Type of record associated with this item. |
| Whencreated | Datetime | Timestamp for when this item was created. |
| Whenmodified | Datetime | Timestamp for when this item was last modified. |
| Createdby | Int64 | User ID of the person who created this item. |
| Modifiedby | Int64 | User ID of the person who last modified this item. |
| Projectdimkey | Int64 | Project dimension key for this item. |
| Projectid | String | ID of the project associated with this item. |
| Projectname | String | Name of the project associated with this item. |
| Customerdimkey | Int64 | Customer dimension key for this item. |
| Customerid | String | Customer ID linked to this item. |
| Customername | String | Customer name linked to this item. |
| Vendordimkey | Int64 | Key representing the vendor dimension linked to this adjustment item. |
| Vendorid | String | Unique identifier for the vendor related to this adjustment item. |
| Vendorname | String | Name of the vendor associated with this adjustment item. |
| Employeedimkey | Int64 | Key representing the employee dimension associated with this adjustment item. |
| Employeeid | String | Unique identifier for the employee related to this adjustment item. |
| Employeename | String | Name of the employee associated with this adjustment item. |
| Itemdimkey | Int64 | Key representing the item dimension linked to this adjustment item. |
| Itemid | String | Unique identifier for the item related to this adjustment item. |
| Itemname | String | Name of the item associated with this adjustment item. |
| Classdimkey | Int64 | Key representing the class dimension linked to this adjustment item. |
| Classid | String | Unique identifier for the class associated with this adjustment item. |
| Classname | String | Name of the class associated with this adjustment item. |
| Record_url | String | URL to view this adjustment item in the system. |