| Name | Description | Type | Additional Information |
|---|---|---|---|
| DepartmentID |
Department ID of the product. |
string |
Required Max length: 6 |
| ProductID |
Product ID. |
string |
Required Max length: 10 |
| AverageCost |
Average cost of the product. Calculated as the product is purchased, using a weighted average calculation. |
string |
Max length: 10 |
| EstimatedAverageCost |
Used when the inventory department is set up as an estimated average cost department and is automatically updated by purchase receipts when the appropriate cost is populated. |
decimal number | |
| LastPurchaseCost |
Cost on the last purchase invoice entered for the product. This is automatically updated with each new purchase. |
string |
Max length: 10 |
| List |
Price that will automatically be used on invoices where no other price overrides or other contributing factors are present. |
decimal number |
Max of 4 decimal places |
| PriceLevel1 |
Price Level 1 of the current product. |
decimal number |
Max of 4 decimal places |
| PriceLevel2 |
Price Level 2 of the current product. |
decimal number |
Max of 4 decimal places |
| PriceLevel3 |
Price Level 3 of the current product. |
decimal number |
Max of 4 decimal places |
| PriceLevel4 |
Price Level 4 of the current product. |
decimal number |
Max of 4 decimal places |
| PriceLevel5 |
Price Level 5 of the current product. |
decimal number |
Max of 4 decimal places |
| PriceLevel6 |
Price Level 6 of the current product. |
decimal number |
Max of 4 decimal places |
| PriceLevel7 |
Price Level 7 of the current product. |
decimal number |
Max of 4 decimal places |
| PriceLevel8 |
Price Level 8 of the current product. |
decimal number |
Max of 4 decimal places |
| PriceLevel9 |
Price Level 9 of the current product. |
decimal number |
Max of 4 decimal places |
| PriceLevel10 |
Price Level 10 of the current product. |
decimal number |
Max of 4 decimal places |
| PriceLevel11 |
Price Level 11 of the current product. |
decimal number |
Max of 4 decimal places |
| PriceLevel12 |
Price Level 12 of the current product. |
decimal number |
Max of 4 decimal places |
| PriceLevel13 |
Price Level 13 of the current product. |
decimal number |
Max of 4 decimal places |
| PriceLevel14 |
Price Level 14 of the current product. |
decimal number |
Max of 4 decimal places |
| PriceLevel15 |
Price Level 15 of the current product. |
decimal number |
Max of 4 decimal places |
| PriceLevel16 |
Price Level 16 of the current product. |
decimal number |
Max of 4 decimal places |
| PriceLevel17 |
Price Level 17 of the current product. |
decimal number |
Max of 4 decimal places |
| PriceLevel18 |
Price Level 18 of the current product. |
decimal number |
Max of 4 decimal places |
| PriceLevel19 |
Price Level 19 of the current product. |
decimal number |
Max of 4 decimal places |
| PriceLevel20 |
Price Level 20 of the current product. |
decimal number |
Max of 4 decimal places |
| PriceLevel21 |
Price Level 21 of the current product. |
decimal number |
Max of 4 decimal places |
| PriceLevel22 |
Price Level 22 of the current product. |
decimal number |
Max of 4 decimal places |
| PriceLevel23 |
Price Level 23 of the current product. |
decimal number |
Max of 4 decimal places |
| PriceLevel24 |
Price Level 24 of the current product. |
decimal number |
Max of 4 decimal places |