| Name | Description | Type | Additional information |
|---|---|---|---|
| JobId |
Sedona internal autonumber for the Job record |
integer |
None. |
| JobCode |
Abbreviated Job Code |
string |
String length: inclusive between 0 and 25 |
| CustomerId |
Foreign key from AR_Customer table |
integer |
None. |
| CustomerSiteId |
Foreign key from AR_Customer_Site table |
integer |
None. |
| BusinessName |
From AR_Customer_Site table |
string |
None. |
| Address1 |
From AR_Customer_Site table |
string |
None. |
| CityState | string |
None. |
|
| JobStatusCode |
Value from OE_Job_Status table |
string |
None. |
| JobTypeCode |
Value from OE_Job_Type table |
string |
None. |
| Description | string |
String length: inclusive between 0 and 50 |
|
| SalespersonCode |
Value from SY_Employee table |
string |
None. |
| DepartmentCode |
Value from SY_Department table |
string |
None. |
| Amount | decimal number |
None. |
|
| BilledAmount | decimal number |
None. |
|
| RMRAmount | decimal number |
None. |
|
| BilledRMRAmount | decimal number |
None. |
|
| SoldDate | date |
None. |
|
| StartDate | date |
None. |
|
| ProjectedEndDate | date |
None. |
|
| EndDate | date |
None. |
|
| PONumber | string |
String length: inclusive between 0 and 20 |
|
| InstallerCode | string |
None. |
|
| Memo | string |
String length: inclusive between 0 and 255 |
|
| EstMaterial | decimal number |
None. |
|
| EstLabor | decimal number |
None. |
|
| EstOther | decimal number |
None. |
|
| ChangeOrder | boolean |
None. |
|
| MasterJobId | integer |
None. |
|
| BillOnDay | integer |
None. |
|
| BillThruDay | integer |
None. |
|
| HoldBackPctg | decimal number |
None. |
|
| TaxingGroupCode |
Value from AR_Taxing_Group table |
string |
None. |
| JobLocked | boolean |
None. |
|
| EstOverhead | decimal number |
None. |
|
| EstCommission | decimal number |
None. |
|
| Reversal | boolean |
None. |
|
| InstallCompanyCode |
Value from OE_Install_Company table |
string |
None. |
| TotalLaborUnits | decimal number |
None. |
|
| PartLaborUnits | decimal number |
None. |
|
| InstallLaborUnits | decimal number |
None. |
|
| LaborUnits | decimal number |
None. |
|
| TotalRMRAmount | decimal number |
None. |
|
| TotalBilledRMRAmount | decimal number |
None. |
|
| InstallAmount | decimal number |
None. |
|
| PartAmount | decimal number |
None. |
|
| ProjMgrCode | string |
None. |
|
| PrevailingWage | decimal number |
None. |
|
| PermitRequired | boolean |
None. |
|
| Permit1 | string |
String length: inclusive between 0 and 25 |
|
| Permit2 | string |
String length: inclusive between 0 and 25 |
|
| Permit3 | string |
String length: inclusive between 0 and 25 |
|
| QuoteId | integer |
None. |
|
| BranchCode |
Value from AR_Branch table |
string |
None. |
| CommissionMultiplier | decimal number |
None. |
|
| CommissionApprovalDate | date |
None. |
|
| CommissionApprovedBy | string |
String length: inclusive between 0 and 30 |
|
| Salesperson2Code |
Value from SY_Employee table |
string |
None. |
| Salesperson1CommissionPctg | decimal number |
None. |
|
| Salesperson2CommissionPctg | decimal number |
None. |
|
| CreationDate | date |
None. |
|
| EnteredBy | string |
String length: inclusive between 0 and 30 |
|
| OverrideTaskList | boolean |
None. |
|
| SalesSplit | boolean |
None. |
|
| UnitsUsed | decimal number |
None. |
|
| OutsideInvoicingDone | decimal number |
None. |
|
| UserCode |
the user making this change; defaults to UserCode value from config file if not set explicitly |
string |
String length: inclusive between 0 and 30 |
| Site |
AR_Customer_Site record associated with the Job |
CustomerSite |
None. |
| JobSystem |
OE_Job_System record associated with the Job |
JobSystem |
None. |
| Tasks |
list of Job Taks, only filled when returning a single job |
Collection of JobTask |
None. |
| Notes |
list of Job Taks, only filled when returning a single job |
Collection of JobNote |
None. |
| JobParts |
list of Parts used on the job |
Collection of JobPart |
None. |