BillsLineItems
Bill lines are used to determine the amount of a bill.
Columns
Name | Type | Description |
LineId [KEY] | Integer | Line Id unique to this bill. |
CategoryId | String | Id of related expense category. |
BillId | Integer | Id of related bill. |
CategoryName | String | Name of related expense category. |
ListIndex | Integer | Line number on the Bill |
Description | String | Description of line item. |
Amount | Decimal | Amount calculated from quantity and unit_cost. |
Code | String | Three-letter currency code. |
TotalAmount | Decimal | Total amount calculated from quantity and unit_cost. |
TotalAmountCode | String | Three letter currency code. |
Quantity | Integer | Quantity of the line unit. |
UnitCostAmount | Decimal | unit cost amount of the line item. |
UnitCostCode | String | Three-letter currency code. |
TaxName1 | String | Name for the first tax on the bill line. |
TaxName2 | String | Name for the second tax on the bill line. |
TaxPercent1 | Integer | Percentage of first tax to 2 decimal places. |
TaxPercent2 | Integer | Percentage of second tax to 2 decimal places. |
TaxAuthorityId1 | String | Tax Authority 1. |
TaxAuthorityId2 | String | Tax Authority 2. |
TaxAmount1Amount | Decimal | First tax amount, in percentage. (up to three decimal places) |
TaxAmount1Code | String | Three letter currency code |
TaxAmount2Amount | Decimal | Second tax amount, in percentage. (up to three decimal places) |
TaxAmount2Code | String | Three letter currency code |