SaleSaleLines
Retrieve a list of all sale's sale lines.
Columns
| Name | Type | References | |
| AccountId | Integer |
Account.Id | |
| SaleId | Integer |
Sales.Id | |
| Id [KEY] | Integer | ||
| AvgCost | Double | ||
| CalcLineDiscount | Double | ||
| CalcSubtotal | Double | ||
| CalcTax1 | Double | ||
| CalcTax2 | Double | ||
| CalcTotal | Double | ||
| CalcTransactionDiscount | Double | ||
| CreateTime | Datetime | ||
| CustomerId | Integer | ||
| DiscountArchived | Boolean | ||
| DiscountCreateTime | Datetime | ||
| DiscountDiscountAmount | String | ||
| DiscountDiscountID | Double | ||
| DiscountDiscountPercent | Double | ||
| DiscountName | String | ||
| DiscountRequireCustomer | String | ||
| DiscountSourceId | Integer | ||
| DiscountTimeStamp | Datetime | ||
| DiscountAmount | Double | ||
| DiscountID | Integer | ||
| DiscountPercent | Double | ||
| DisplayableSubtotal | Double | ||
| DisplayableUnitPrice | Double | ||
| EmployeeId | Integer | ||
| FifoCost | Double | ||
| IsLayaway | Boolean | ||
| IsSpecialOrder | Boolean | ||
| IsWorkorder | Boolean | ||
| ItemId | Integer | ||
| NormalUnitPrice | String | ||
| NoteId | Integer | ||
| ParentSaleLineId | Integer | ||
| ShopId | Integer | ||
| Tax | Double | ||
| Tax1Rate | Double | ||
| Tax2Rate | Double | ||
| TaxCategoryIsTaxInclusive | Boolean | ||
| TaxCategoryTax1Name | String | ||
| TaxCategoryTax1Rate | Double | ||
| TaxCategoryTax2Name | String | ||
| TaxCategoryTax2Rate | Double | ||
| TaxCategoryTaxCategoryId | Integer | ||
| TaxCategoryTimeStamp | Datetime | ||
| TaxCategoryId | Integer | ||
| TaxClassName | String | ||
| TaxClassTaxClassId | Integer | ||
| TaxClassTimeStamp | Datetime | ||
| TaxClassId | Integer | ||
| TimeStamp | Datetime | ||
| UnitPrice | Double | ||
| UnitQuantity | Integer |