3PAOpenDealDetailFields Opendealdetail Unit Parts

Fields - OpenDealDetail.Unit.Parts

Field NameData TypeDescription, Example
DealerIdstringInternal Dealer Identifier (intentionally left blank)
DealId (key)stringSystem generated unique identifier
DealUnitID (key)longUnit id on the deal
MajorUnitPartsId(key)longDMS assigned ID for the part associated with the unit
DealNo (key)stringExternal DMS deal identifier
PartNumberstringPart identifier
SuppliercodestringAbbreviated name of maker
RequestedQtyintAmount of part being requested
SpecialOrderQtyintAmount of part being special ordered
QtyintAmount of part sold
CostmoneyCost of the part after being sold from parts dept
PricemoneyPrice of the part
RetailmoneyStandard price of the part
SetupInstallstringS – Setup, I - Installed
DescriptionstringDescription of part
dealstateintStatus identifier of the deal – (1,7) = Quote, 2 = Deal, 3 = Canceled Quote, 4 = Voided Deal, 8 = Lead, 9 = Inactive Deal
internaltypeintDefines part type on deal – 0=Undefined, 1=Prep, 2=Dealer Add (installed), 3=Customer Add (not-installed), 4=Warranty