NameDescriptionTypeAdditional 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

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