| Name | Description | Type | Additional Information |
|---|---|---|---|
| DepartmentID |
ID of the department the product is in |
string |
Required Max length: 6 Must not contain a space or a tic (') |
| ProductID |
ID of the product |
string |
Required Max length: 10 Must not contain a space or a tic (') |
| ProductDescription |
Description of the product |
string |
Max length: 50 |
| Quantity |
Quantity of the product |
decimal number |
Max length: 10 Max of 3 decimal places Must be numeric |
| Cost |
Estimated cost |
decimal number |
Max length: 10 Max of 3 decimal places Must be numeric |
| Lotnum |
Product lot number |
string |
Max length: 30 |
| LotExpireDate |
Product lot number expiration date Used during add only |
string |
Format must be MM/dd/yyyy |
| PONumber |
Identifies the purchase order referenced |
string |
Max length: 15 Must not contain a space or a tic (') |
| POLineItem |
Line number of the product on purchase order referenced by PONumber |
integer |