| Name | Description | Type | Additional information | 
|---|---|---|---|
| PartId | 
                         Sedona internal autonumber for the Part record  | 
                    integer | 
                             None.  | 
                
| PartCode | 
                         Part Code  | 
                    string | 
                                 String length: inclusive between 0 and 25  | 
                
| Description | 
                         Description of the part  | 
                    string | 
                                 String length: inclusive between 0 and 50  | 
                
| Detail | 
                         Additonal detail information about the part  | 
                    string | 
                                 String length: inclusive between 0 and 255  | 
                
| SalesPrice | decimal number | 
                             None.  | 
                |
| ItemId | 
                         foreign key from the AR_Item table  | 
                    integer | 
                             None.  | 
                
| UnitOfMeasureId | integer | 
                             None.  | 
                |
| PrimaryVendorId | integer | 
                             None.  | 
                |
| NonValuePart | boolean | 
                             None.  | 
                |
| CustomerEquipment | boolean | 
                             None.  | 
                |
| Inactive | boolean | 
                             None.  | 
                |
| LaborUnits | decimal number | 
                             None.  | 
                |
| ServicePart | boolean | 
                             None.  | 
                |
| ManufacturerPartCode | 
                         Manufacturer's part code  | 
                    string | 
                                 String length: inclusive between 0 and 50  | 
                
| UPC | 
                         Univeral Product Code  | 
                    string | 
                                 String length: inclusive between 0 and 50  | 
                
| SalesPart | boolean | 
                             None.  | 
                |
| SpecialOrder | boolean | 
                             None.  | 
                |
| StandardCost | boolean | 
                             None.  |