Fields – ServiceDet.Unit.Job.Parts
| Field Name | Data Type | Description, Example |
|---|---|---|
| DealerId | string | Internal Dealer Identifier (intentionally left blank) |
| ROHeaderID (key) | int | DMS internal identifier of RO |
| ROUnitID (key) | int | Unit identifier on the RO |
| ROJobID (key) | int | Job identifier on the RO |
| ROPartID(key) | int | Part identifier on RO |
| PartNumber | string | Part identifier |
| PartDescription | string | Description of part |
| SourceCode | string | Abbreviated maker of part |
| Qty | decimal | Amount of part sold on RO |
| RequestedQty | decimal | Amount of part requested |
| SpecialOrderQty | decimal | Amount of part special ordered |
| Cost | money | Cost of the part after being sold from parts dept |
| Price | money | Price of the part |
| ExtPrice | money | Extended Price of the part |
| DiscountPrice | money | Price of part after discount |
| Hasspecialorder | int | False = part was not special ordered, True = part was special ordered |