| Name | Description | Type | Additional Information |
|---|---|---|---|
| DirectYN | string |
Max length: 1 Must be numeric Valid options: 0 or 1. |
|
| PONumber | string |
Max length: 15 |
|
| POLineItem | integer |
Max length: 5 Must be numeric |
|
| PRNumber | string |
Max length: 15 |
|
| PRLineItem | integer |
Max length: 5 Must be numeric |
|
| PrePaidYN | boolean |
Must be 0, 1, True, or False |
|
| DepartmentID | string |
Required Max length: 6 Must not contain a space or a tic (') |
|
| ProductID | string |
Required Max length: 10 Must not contain a space or a tic (') |
|
| ProductDescription | string |
Max length: 50 |
|
| Quantity | decimal number |
Required Max length: 10 Max of 3 decimal places Must be filled out and numeric |
|
| UnitCost | decimal number |
Required Cannot be negative Max length: 13 Max of 3 decimal places Must be filled out and numeric |
|
| Total | decimal number |
Required Max length: 14 Max of 2 decimal places Must be filled out and numeric |
|
| Freight |
Optional line item Freight amount. Will override freight calculation when set |
decimal number |
Max length: 10 Max of 2 decimal places |
| LotNumber | string |
Max length: 30 |
|
| MFOriginCity |
If provided must exist in Agvance Motor Fuel Setup (must also include the MFOriginState) - See MotorFuel/GetMotorFuelSetupInfo |
string |
Max length: 25 |
| MFOriginState |
Required when MFOriginCity is set; If provided and MFOriginCity is not set, this must exist in the Agvance list of states |
string |
Max length: 2 |
| MFDestinationCity | string |
Max length: 25 |
|
| MFDestinationState | string |
Max length: 2 |
|
| MFSellerLicense | string |
Max length: 10 |
|
| MFModeOfTransportation |
If provided must exist in Agvance Motor Fuel Setup - See MotorFuel/GetMotorFuelSetupInfo |
string |
Max length: 10 |
| MFBillOfLadingDate | string |
Data type: DateTime Format must be MM/dd/yyyy |
|
| MFNetGallons | decimal number |
Max length: 10 Must be numeric |
|
| MFGrossGallons | decimal number |
Max length: 10 Must be numeric |
|
| MFSchedule |
If provided must exist in Agvance Motor Fuel Setup - See MotorFuel/GetMotorFuelSetupInfo |
string |
Max length: 25 |
| MFTaxFeeType |
Valid entries are: 'Both Free', 'MFT-Free UST/EIF-pd', 'MFT-pd UST/EIF-free', 'Both Paid' See MotorFuel/GetMotorFuelSetupInfo |
string |
Max length: 20 |
| MFFreightVendorId |
Must be a valid vendor id from the Agvance database if provided - if not will atempt to set based on Agvance defaults. Only valid when MFDestinationCity is provided or set by defaults |
string |
Max length: 10 |
| MFMILicenseType |
If provided must exist in Agvance Motor Fuel Setup - See MotorFuel/GetMotorFuelSetupInfo |
string |
Max length: 8 |
| ContainerKey | integer |
Must be numeric |
|
| MFBillOfLadingNumber | string |
Max length: 15 |
|
| MFSalesTaxPaid | boolean |