| Name | Description | Type | Additional Information |
|---|---|---|---|
| OrderNumber |
The Sales Order Number in Agvance |
string | |
| CustID |
The Agvance ID of the Customer to whom the Sales Order is Being Sent |
string |
Required Max length: 6 |
| LineItem |
The Number Associated With the Order of Products on the Sales Order. |
integer |
Required |
| DeptID |
The Agvance ID of the Department in Which the Product on That Line Item Resides |
string |
Required Max length: 6 |
| ProdID |
The Agvance ID of the Product That is on That Line |
string |
Required Max length: 10 |
| ProductName |
The Description of the Product That is on That Line |
string |
Max length: 50 |
| Quantity |
The Quantity of the Product That is on That Line |
decimal number |
Max of 3 decimal places |
| InvUnits |
The Agvance Inventory Unit of Measure of the Product on That Line |
string |
Max length: 4 |
| Price |
The Selling Price of the Product on That Line |
decimal number |
Max of 4 decimal places |
| BillUnits |
The Agvance Billing Unit of Measure of the Product on That Line |
string |
Max length: 4 |
| CropCode |
The Agvance Crop Id for the Product on That Line |
string |
Max length: 50 |
| AllocationNumber |
The Agvance ID That Represents a Sales Allocation |
string |
Must be numeric Range: inclusive between 0 and 2147483647 |
| BillingDivisor |
The Ratio of Inventory Units to Billing Units of the Product on That Line |
string | |
| PriceLevel |
An Integer Value That Corresponds to the Agvance Price Level; 0=List, 1=L1, 2=L2, 3=L3, 4=L4, 5=L5, 6=L6, 7=L7, 8=L8, 9=AvCst, 10=LsCst, 11=RpCst, 12=L9, 13=L10, 14=L11, 15=L12, 16=L13, 17=L14, 18=L15, 19=L16, 20=L17, 21=L18, 22=L19, 23=L20, 24=L21, 25=L22, 26=L23, 27=L24, 28=Est. Avg. Cost |
string |
Max length: 2 |
| AlternateProductId |
Alternate ID for the product |
string |
Max length: 40 |