APBillItem
Provides line-level details for items in accounts payable bills, including allocation and cost specifics.
Columns
| Name | Type | Description |
| Recordno [KEY] | String | A unique identifier for the accounts payable bill item record. |
| Recordkey | Int64 | The unique key identifying the adjustment record to which this item belongs. |
| Accountkey | Int64 | The unique key of the account associated with this bill item. |
| Accountno | String | The account number linked to this bill item. |
| Offsetglaccountno | String | The offset general ledger account number associated with this bill item. |
| Offsetglaccounttitle | String | The title of the offset general ledger account. |
| Accounttitle | String | The title of the account associated with this bill item. |
| Accountlabelkey | Int64 | The unique key of the account label linked to this bill item. |
| Accountlabel | String | The account label associated with this bill item. |
| Entry_date | Datetime | The date when this bill item was entered. |
| Amount | Double | The amount for this bill item. |
| Trx_amount | Double | The transaction amount for this bill item. |
| Departmentid | String | The identifier of the department associated with this bill item. |
| Departmentname | String | The name of the department associated with this bill item. |
| Locationid | String | The identifier of the location associated with this bill item. |
| Locationname | String | The name of the location associated with this bill item. |
| Entrydescription | String | A description of this bill item. |
| Exch_rate_date | Datetime | The date of the exchange rate applied to this bill item. |
| Exch_rate_type_id | String | The identifier of the exchange rate type used for this bill item. |
| Exchange_rate | Double | The exchange rate applied to this bill item. |
| Allocation | String | The allocation associated with this bill item. |
| Allocationkey | Int64 | The unique key for the allocation linked to this bill item. |
| Form1099 | String | The 1099 form type associated with this bill item, if applicable. |
| Lineitem | String | The line item number associated with this bill item. |
| Line_no | String | The line number associated with this bill item. |
| Currency | String | The currency used for this bill item. |
| Basecurr | String | The base currency for this bill item. |
| Totalpaid | Double | The total amount paid for this bill item. |
| Trx_totalpaid | Double | The total transaction amount paid for this bill item. |
| Totalselected | Double | The total amount selected for payment for this bill item. |
| Trx_totalselected | Double | The total transaction amount selected for payment for this bill item. |
| Billable | Boolean | Indicates whether this bill item is billable. |
| Billed | Boolean | Indicates whether this bill item has been billed. |
| Releasetopay | Boolean | Indicates whether this bill item is released for payment. |
| Parententry | Int64 | The unique key of the parent entry to which this bill item belongs. |
| Baselocation | Int64 | The base location associated with this bill item. |
| State | String | The current state of this bill item. |
| Recordtype | String | The type of record associated with this bill item. |
| Whencreated | Datetime | The timestamp indicating when this bill item was created. |
| Whenmodified | Datetime | The timestamp indicating when this bill item was last modified. |
| Createdby | Int64 | The identifier of the user or process that created this bill item. |
| Modifiedby | Int64 | The identifier of the user or process that last modified this bill item. |
| Projectdimkey | Int64 | The unique key for the project dimension linked to this bill item. |
| Projectid | String | The project identifier associated with this bill item. |
| Projectname | String | The name of the project associated with this bill item. |
| Customerdimkey | Int64 | The unique key for the customer dimension linked to this bill item. |
| Customerid | String | The customer identifier associated with this bill item. |
| Customername | String | The name of the customer associated with this bill item. |
| Vendordimkey | Int64 | The unique key for the vendor dimension linked to this bill item. |
| Vendorid | String | The vendor identifier associated with this bill item. |
| Vendorname | String | The name of the vendor associated with this bill item. |
| Employeedimkey | Int64 | The unique key for the employee dimension linked to this bill item. |
| Employeeid | String | The employee identifier associated with this bill item. |
| Employeename | String | The name of the employee associated with this bill item. |
| Itemdimkey | Int64 | The unique key for the item dimension linked to this bill item. |
| Itemid | String | The item identifier associated with this bill item. |
| Itemname | String | The name of the item associated with this bill item. |
| Classdimkey | Int64 | The unique key for the class dimension linked to this bill item. |
| Classid | String | The class identifier associated with this bill item. |
| Classname | String | The name of the class associated with this bill item. |
| Record_url | String | The URL linking to the detailed record of this bill item. |