| Name | Description | Type | Additional Information |
|---|---|---|---|
| DeptID |
The Agvance ID of the Department That the Product is Listed Under |
string |
Required Max length: 6 |
| ProdID |
The Agvance ID of the Product Unique to the Department |
string |
Required Max length: 10 |
| LotNumber |
The Lot Number Assigned to the Product |
string |
Max length: 30 |
| Quantity |
The quantity of the product |
decimal number |
Max of 3 decimal places Must be numeric |
| TaxExemptCode |
The tax exempt code |
string |
Max length: 20 |
| UnitPrice |
The price per unit for the product |
decimal number | |
| TaxYN |
True/False, include tax for product |
boolean | |
| Total |
The total for the product |
decimal number |
Max of 2 decimal places Must be numeric |
| DiscountDollars |
The discount dollars for a product |
decimal number |
Max of 2 decimal places Must be numeric |
| StateTaxCode |
The state tax code associated with the product |
string |
Max length: 15 |
| AdjTaxCode |
The adjustment tax code associated with the product |
string |
Max length: 15 |
| TaxRate |
The tax rate associated with the product |
decimal number |
Max of 3 decimal places Must be numeric |
| Taxamount |
The tax amount for the product |
decimal number |
Max of 2 decimal places Must be numeric |
| ShipFromLocation |
The product's ship from location |
string |
Max length: 6 |
| IsSurchargeProduct |
True/False surcharge for the product |
boolean |
Must be 0, 1, True, or False |