| Name | Description | Type | Additional Information |
|---|---|---|---|
| DepartmentID |
Department ID for the product. |
string |
Required Max length: 6 |
| ProductID |
User assigned ID of the product. |
string |
Required Max length: 10 |
| BillingUnits |
Unit of measure in which the product will be sold. |
string |
Required Max length: 4 |
| BillingDivisor |
Number of inventory units per billing unit. |
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 |
| List |
Price that will automatically be used on invoices where no other price overrides or other contributing factors are present. |
string |
Max length: 10 |
| LastPurchaseCost |
Cost on the last purchase invoice entered for the product. This is automatically updated with each new purchase. |
string |
Max length: 10 |
| PriceLevel1 |
Can be set if the corresponding price level label on the department is populated. |
string |
Max length: 10 |
| PriceLevel2 |
Can be set if the corresponding price level label on the department is populated. |
string |
Max length: 10 |
| PriceLevel3 |
Can be set if the corresponding price level label on the department is populated. |
string |
Max length: 10 |
| PriceLevel4 |
Can be set if the corresponding price level label on the department is populated. |
string |
Max length: 10 |
| PriceLevel5 |
Can be set if the corresponding price level label on the department is populated. |
string |
Max length: 10 |
| PriceLevel6 |
Can be set if the corresponding price level label on the department is populated. |
string |
Max length: 10 |
| PriceLevel7 |
Can be set if the corresponding price level label on the department is populated. |
string |
Max length: 10 |
| PriceLevel8 |
Can be set if the corresponding price level label on the department is populated. |
string |
Max length: 10 |
| ProfitMargin |
Used if inventory department is set as a profit margin department. Determines pricing for the product based on the cost. |
decimal number | |
| PriceLevel9 |
Can be set if the corresponding price level label on the department is populated. |
string |
Max length: 10 |
| PriceLevel10 |
Can be set if the corresponding price level label on the department is populated. |
string |
Max length: 10 |
| PriceLevel11 |
Can be set if the corresponding price level label on the department is populated. |
string |
Max length: 10 |
| PriceLevel12 |
Can be set if the corresponding price level label on the department is populated. |
string |
Max length: 10 |
| PriceLevel13 |
Can be set if the corresponding price level label on the department is populated. |
string |
Max length: 10 |
| PriceLevel14 |
Can be set if the corresponding price level label on the department is populated. |
string |
Max length: 10 |
| PriceLevel15 |
Can be set if the corresponding price level label on the department is populated. |
string |
Max length: 10 |
| PriceLevel16 |
Can be set if the corresponding price level label on the department is populated. |
string |
Max length: 10 |
| PriceLevel17 |
Can be set if the corresponding price level label on the department is populated. |
string |
Max length: 10 |
| PriceLevel18 |
Can be set if the corresponding price level label on the department is populated. |
string |
Max length: 10 |
| PriceLevel19 |
Can be set if the corresponding price level label on the department is populated. |
string |
Max length: 10 |
| PriceLevel20 |
Can be set if the corresponding price level label on the department is populated. |
string |
Max length: 10 |
| PriceLevel21 |
Can be set if the corresponding price level label on the department is populated. |
string |
Max length: 10 |
| PriceLevel22 |
Can be set if the corresponding price level label on the department is populated. |
string |
Max length: 10 |
| PriceLevel23 |
Can be set if the corresponding price level label on the department is populated. |
string |
Max length: 10 |
| PriceLevel24 |
Can be set if the corresponding price level label on the department is populated. |
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 | |
| FormulaSource0 |
Used in price formulation. |
integer | |
| FormulaSource1 |
Used in price formulation. |
integer | |
| FormulaSource2 |
Used in price formulation. |
integer | |
| FormulaSource3 |
Used in price formulation. |
integer | |
| FormulaSource4 |
Used in price formulation. |
integer | |
| FormulaSource5 |
Used in price formulation. |
integer | |
| FormulaSource6 |
Used in price formulation. |
integer | |
| FormulaSource7 |
Used in price formulation. |
integer | |
| FormulaSource8 |
Used in price formulation. |
integer | |
| FormulaSource9 |
Used in price formulation. |
integer | |
| FormulaSource10 |
Used in price formulation. |
integer | |
| FormulaSource11 |
Used in price formulation. |
integer | |
| FormulaSource12 |
Used in price formulation. |
integer | |
| FormulaSource13 |
Used in price formulation. |
integer | |
| FormulaSource14 |
Used in price formulation. |
integer | |
| FormulaSource15 |
Used in price formulation. |
integer | |
| FormulaSource16 |
Used in price formulation. |
integer | |
| FormulaSource17 |
Used in price formulation. |
integer | |
| FormulaSource18 |
Used in price formulation. |
integer | |
| FormulaSource19 |
Used in price formulation. |
integer | |
| FormulaSource20 |
Used in price formulation. |
integer | |
| FormulaSource21 |
Used in price formulation. |
integer | |
| FormulaSource22 |
Used in price formulation. |
integer | |
| FormulaSource23 |
Used in price formulation. |
integer | |
| FormulaSource24 |
Used in price formulation. |
integer | |
| FormulaType0 |
Used in price formulation. |
string |
Max length: 1 |
| FormulaType1 |
Used in price formulation. |
string |
Max length: 1 |
| FormulaType2 |
Used in price formulation. |
string |
Max length: 1 |
| FormulaType3 |
Used in price formulation. |
string |
Max length: 1 |
| FormulaType4 |
Used in price formulation. |
string |
Max length: 1 |
| FormulaType5 |
Used in price formulation. |
string |
Max length: 1 |
| FormulaType6 |
Used in price formulation. |
string |
Max length: 1 |
| FormulaType7 |
Used in price formulation. |
string |
Max length: 1 |
| FormulaType8 |
Used in price formulation. |
string |
Max length: 1 |
| FormulaType9 |
Used in price formulation. |
string |
Max length: 1 |
| FormulaType10 |
Used in price formulation. |
string |
Max length: 1 |
| FormulaType11 |
Used in price formulation. |
string |
Max length: 1 |
| FormulaType12 |
Used in price formulation. |
string |
Max length: 1 |
| FormulaType13 |
Used in price formulation. |
string |
Max length: 1 |
| FormulaType14 |
Used in price formulation. |
string |
Max length: 1 |
| FormulaType15 |
Used in price formulation. |
string |
Max length: 1 |
| FormulaType16 |
Used in price formulation. |
string |
Max length: 1 |
| FormulaType17 |
Used in price formulation. |
string |
Max length: 1 |
| FormulaType18 |
Used in price formulation. |
string |
Max length: 1 |
| FormulaType19 |
Used in price formulation. |
string |
Max length: 1 |
| FormulaType20 |
Used in price formulation. |
string |
Max length: 1 |
| FormulaType21 |
Used in price formulation. |
string |
Max length: 1 |
| FormulaType22 |
Used in price formulation. |
string |
Max length: 1 |
| FormulaType23 |
Used in price formulation. |
string |
Max length: 1 |
| FormulaType24 |
Used in price formulation. |
string |
Max length: 1 |
| FormulaAmount0 |
Used in price formulation. |
decimal number | |
| FormulaAmount1 |
Used in price formulation. |
decimal number | |
| FormulaAmount2 |
Used in price formulation. |
decimal number | |
| FormulaAmount3 |
Used in price formulation. |
decimal number | |
| FormulaAmount4 |
Used in price formulation. |
decimal number | |
| FormulaAmount5 |
Used in price formulation. |
decimal number | |
| FormulaAmount6 |
Used in price formulation. |
decimal number | |
| FormulaAmount7 |
Used in price formulation. |
decimal number | |
| FormulaAmount8 |
Used in price formulation. |
decimal number | |
| FormulaAmount9 |
Used in price formulation. |
decimal number | |
| FormulaAmount10 |
Used in price formulation. |
decimal number | |
| FormulaAmount11 |
Used in price formulation. |
decimal number | |
| FormulaAmount12 |
Used in price formulation. |
decimal number | |
| FormulaAmount13 |
Used in price formulation. |
decimal number | |
| FormulaAmount14 |
Used in price formulation. |
decimal number | |
| FormulaAmount15 |
Used in price formulation. |
decimal number | |
| FormulaAmount16 |
Used in price formulation. |
decimal number | |
| FormulaAmount17 |
Used in price formulation. |
decimal number | |
| FormulaAmount18 |
Used in price formulation. |
decimal number | |
| FormulaAmount19 |
Used in price formulation. |
decimal number | |
| FormulaAmount20 |
Used in price formulation. |
decimal number | |
| FormulaAmount21 |
Used in price formulation. |
decimal number | |
| FormulaAmount22 |
Used in price formulation. |
decimal number | |
| FormulaAmount23 |
Used in price formulation. |
decimal number | |
| FormulaAmount24 |
Used in price formulation. |
decimal number | |
| FormulaSourceAC |
Used in price formulation. |
integer | |
| FormulaTypeAC |
Used in price formulation. |
string |
Max length: 1 |
| FormulaAmountAC |
Used in price formulation. |
decimal number | |
| FormulaSourceLC |
Used in price formulation. |
integer | |
| FormulaTypeLC |
Used in price formulation. |
string |
Max length: 1 |
| FormulaAmountLC |
Used in price formulation. |
decimal number | |
| FormulaSourceRC |
Used in price formulation. |
integer | |
| FormulaTypeRC |
Used in price formulation. |
string |
Max length: 1 |
| FormulaAmountRC |
Used in price formulation. |
decimal number | |
| FormulaSourceEAC |
Used in price formulation. |
integer | |
| FormulaTypeEAC |
Used in price formulation. |
string |
Max length: 1 |
| FormulaAmountEAC |
Used in price formulation. |
decimal number | |
| ReplacementCost2 |
Cost per unit used to calculate inventory value. |
decimal number | |
| ReplacementCost3 |
Cost per unit used to calculate inventory value. |
decimal number | |
| ReplacementCost4 |
Cost per unit used to calculate inventory value. |
decimal number | |
| FormulaSourceRC2 |
Used in price formulation. |
integer | |
| FormulaTypeRC2 |
Used in price formulation. |
string |
Max length: 1 |
| FormulaAmountRC2 |
Used in price formulation. |
decimal number | |
| FormulaSourceRC3 |
Used in price formulation. |
integer | |
| FormulaTypeRC3 |
Used in price formulation. |
string |
Max length: 1 |
| FormulaAmountRC3 |
Used in price formulation. |
decimal number | |
| FormulaSourceRC4 |
Used in price formulation. |
integer | |
| FormulaTypeRC4 |
Used in price formulation. |
string |
Max length: 1 |
| FormulaAmountRC4 |
Used in price formulation. |
decimal number |