NameDescriptionTypeAdditional information
JobPartId

Sedona internal autonumber for the OE_Job_Parts record (assigned automatically on POST)

integer

None.

JobSystemId

Foreign key from AR_Customer_System table

integer

Required

PartCode

Abbreviated Part_Code, from IN_Part table

string

Required

String length: inclusive between 0 and 25

Quantity

Quantity of the Part

integer

Required

Rate

Rate

decimal number

Required

Amount

calculated automatically as Quantity * Rate (should not include tax)

decimal number

None.

Location

Location of the Part

string

None.

InvoiceItem

Defaults to False if not supplied

boolean

None.

MasterItemCode

Item_Code from AR_Item table; the Recurring Revenue item that this item will be “rolled up” into. Items of like Master Item and cycle are grouped together in the application. Defaults to N/A if not set explicitly.

string

String length: inclusive between 0 and 25

LaborUnits

Units of Labor; defaults to zero if not supplied

decimal number

None.

MasterJobPartCode

Abbreviated Part_Code, from IN_Part table

string

String length: inclusive between 0 and 25

IssuedQuantity

defaults to zero if not supplied

integer

None.

PurchaseCost

Purchase Cost; defaults to zero if not supplied

decimal number

None.

PurchaseDescription

Purchase Description

string

String length: inclusive between 0 and 25

VendorCode

Vendor_Code from AP_Vendor; defaults to N/A if not supplied

string

String length: inclusive between 0 and 50

JobPartDescription

Part Description

string

String length: inclusive between 0 and 128

PhaseCode

Phase_Code from OE_Phase table

string

String length: inclusive between 0 and 50

IssueFromStock

Defaults to False if not supplied

boolean

None.