Items
Returns all items.
Columns
| Name | Type | References | |
| Id [KEY] | Integer | ||
| ParentItemId | Integer | ||
| ItemType | String |
The allowed values are InventoryItemType, NonInventoryItemType, ChargeItemType, DiscountItemType, ServiceItemType, DescriptionOnlyItemType, SubtotalItemType, CategoryItemType. | |
| Name | String | ||
| Mpn | String | ||
| Barcode | String | ||
| Weight | Double | ||
| Active | Boolean | ||
| SalesMemo | String | ||
| PurchaseMemo | String | ||
| SalesPrice | Double | ||
| PurchasePrice | Double | ||
| AvailableQuantity | Double | ||
| UmSetBaseUnitAbbr | String | ||
| UmSetBaseUnitId | Integer | ||
| UmSetBaseUnitName | String | ||
| UmSetDefaultPurchaseUnitAbbr | String | ||
| UmSetDefaultPurchaseUnitId | Integer | ||
| UmSetDefaultPurchaseUnitName | String | ||
| UmSetDefaultSalesUnitAbbr | String | ||
| UmSetDefaultSalesUnitId | Integer | ||
| UmSetDefaultSalesUnitName | String | ||
| UmSetId | Integer | ||
| UmSetName | String | ||
| MinimumReorderPoint | Integer | ||
| MaximumReorderPoint | Integer | ||
| Tags | String | ||
| PreferredVendorAccountNr | String | ||
| PreferredVendorActive | Boolean | ||
| PreferredVendorAltPhone | String | ||
| PreferredVendorBalance | Double | ||
| PreferredVendorContact | String | ||
| PreferredVendorCreditLimit | Double | ||
| PreferredVendorEligibleFor1099 | Boolean | ||
| PreferredVendorEmails | String | ||
| PreferredVendorFax | String | ||
| PreferredVendorId | Integer | ||
| PreferredVendorMemo | String | ||
| PreferredVendorName | String | ||
| PreferredVendorPaymentMethodActive | Boolean | ||
| PreferredVendorPaymentMethodId | Integer | ||
| PreferredVendorPaymentMethodName | String | ||
| PreferredVendorPaymentMethodTypeId | String | ||
| PreferredVendorPaymentTermActive | Boolean | ||
| PreferredVendorPaymentTermDueDays | Integer | ||
| PreferredVendorPaymentTermFixedNumberOfDays | Boolean | ||
| PreferredVendorPaymentTermId | Integer | ||
| PreferredVendorPaymentTermName | String | ||
| PreferredVendorPhone | String | ||
| TaxTypeAbbr | String | ||
| TaxTypeActive | Boolean | ||
| TaxTypeId | Integer | ||
| TaxTypeName | String | ||
| TaxTypeTaxable | Boolean | ||
| CogsAccountAccountNr | String | ||
| CogsAccountAccountType | String | ||
| CogsAccountActive | Boolean | ||
| CogsAccountId | Integer | ||
| CogsAccountName | String | ||
| IncomeAccountAccountNr | String | ||
| IncomeAccountAccountType | String | ||
| IncomeAccountActive | Boolean | ||
| IncomeAccountId | Integer | ||
| IncomeAccountName | String | ||
| InventoryAccountAccountNr | String | ||
| InventoryAccountAccountType | String | ||
| InventoryAccountActive | Boolean | ||
| InventoryAccountId | Integer | ||
| InventoryAccountName | String | ||
| InitialQuantityOnHandQuantity | String | ||
| InitialQuantityOnHandaAOf | String | ||
| InitialQuantityOnHandaASiteId | String | ||
| AccountAccountNr | String | ||
| AccountAccountType | String | ||
| AccountActive | Boolean | ||
| AccountId | Integer | ||
| AccountName | String | ||
| Amount | Double | ||
| Percent | Boolean | ||
| Buy | Boolean | ||
| Sell | Boolean | ||
| ExpenseAccountAccountNr | String | ||
| ExpenseAccountAccountType | String | ||
| ExpenseAccountActive | Boolean | ||
| ExpenseAccountId | Integer | ||
| ExpenseAccountName | String |