"https://epicor-dev./E10Test/api/v2/odata/OCM14091/Erp.BO.JobStatusSvc/$metadata#JobStatus/$entity"JOB FROM ERP
What the Attributes In Meaning in ERP of Epcior
SchedStatus
JobHeld
Plant
JobReleased
WIStartDate
WIDueDate
SchedStatus - Assuming this is whether the job is scheduled or not.
JobHeld - You can place a job on Hold, though, it may just be a visible “Flag” and not prevent anything in the system unless you wire up some BPMs based on the flag status.
Plant - The site the job is for.
JobReleased - true/false. Time entries cannot be placed on jobs that are not released.
WIStartDate/DueDate - These are “what if” dates utilized by the scheduling engine. So if you move a job around on the scheduling board it uses the what-if dates to recalculate scheduling operations, material requirement due dates, etc.
I recommend looking at the help documentation within the system and/or field help to learn more about specific fields.
1 Like
Thanks for the clarification.
We need your help in understanding the attributes of the Epicor ERP system. Below are the fields and related queries that need clarification:
- Fresh Job Identification
- we must fetch newly created jobs from the ERP system. However, we are unable to identify any attributes that can be used to determine if a job is freshly created. Could you suggest the relevant attribute(s) or approach to identify fresh jobs in the system?
- Job Department Association
- We need to determine which department a job belongs to. Could you provide guidance on the attribute(s) or methodology we should use to ascertain the department associated with a specific job?
{
"@odata.context": "https://*******/E10Test/api/v2/odata/OCM14091/Erp.BO.JobStatusSvc/$metadata#JobStatus/$entity",
"Company": "OCM14091",
"JobClosed": false,
"ClosedDate": null,
"JobComplete": false,
"JobCompletionDate": null,
"JobEngineered": true,
"JobReleased": true,
"JobHeld": true,
"SchedStatus": "R",
"JobNum": "022983",
"PartNum": "SBU200-P",
"RevisionNum": "1",
"DrawNum": "",
"PartDescription": "SLAB BOLSTER UPPER - 2'' HEIGHT - PLAIN - 5000/FT SKID",
"ProdQty": 100000,
"IUM": "FT",
"StartDate": "2024-02-09T00:00:00-06:00",
"StartHour": 0,
"DueDate": "2024-02-09T00:00:00-06:00",
"DueHour": 0,
"ReqDueDate": "2024-02-09T00:00:00-06:00",
"JobCode": "",
"QuoteNum": 0,
"QuoteLine": 0,
"ProdCode": "1000",
"InCopyList": false,
"WIName": "",
"WIStartDate": "2024-02-09T00:00:00-06:00",
"WIStartHour": 0,
"WIDueDate": "2024-02-09T00:00:00-06:00",
"WIDueHour": 0,
"SchedCode": "NORMAL",
"SchedLocked": false,
"ProjectID": "",
"WIPCleared": false,
"JobFirm": true,
"PersonList": "",
"PersonID": "",
"ProdTeamID": "",
"QtyCompleted": 50000,
"Plant": "MfgSys",
"DatePurged": null,
"TravelerReadyToPrint": false,
"TravelerLastPrinted": "2024-01-29T00:00:00-06:00",
"StatusReadyToPrint": false,
"StatusLastPrinted": null,
"CallNum": 0,
"CallLine": 0,
"JobType": "MFG",
"RestoreFlag": "",
"PhaseID": "",
"AnalysisCode": "",
"LockQty": false,
"HDCaseNum": 0,
"ProcessMode": "S",
"PlannedActionDate": "2024-02-09T00:00:00-06:00",
"PlannedKitDate": "2024-02-09T00:00:00-06:00",
"MSPTaskID": "",
"MSPPredecessor": "",
"UserMapData": "",
"ProductionYield": false,
"OrigProdQty": 100000,
"PreserveOrigQtys": false,
"NoAutoCompletion": false,
"NoAutoClosing": false,
"CreatedBy": "dbrown",
"CreateDate": "2024-01-29T00:00:00-06:00",
"WhseAllocFlag": false,
"OwnershipStatus": "",
"PDMObjID": "",
"ExportRequested": "",
"SplitMfgCostElements": false,
"XRefPartNum": "",
"XRefPartType": "",
"XRefCustNum": 0,
"BasePartNum": "",
"BaseRevisionNum": "",
"RoughCutScheduled": false,
"EquipID": "",
"PlanNum": 0,
"MaintPriority": "",
"SplitJob": false,
"NumberSource": true,
"CloseMeterReading": 0,
"Forward": false,
"SchedSeq": 0,
"PAAExists": false,
"DtlsWithinLeadTime": false,
"GroupSeq": 0,
"RoughCut": true,
"PlanGUID": "",
"PlanUserID": "",
"LastChangedBy": "",
"LastChangedOn": null,
"EPMExportLevel": 0,
"JobWorkflowState": "",
"JobCSR": "",
"ExternalMES": false,
"SysRevID": 898030776,
"SysRowID": "a9f04876-f5dd-4b5d-a2fc-c51a589cbf54",
"LastExternalMESDate": null,
"LastScheduleDate": null,
"LastScheduleProc": "",
"SchedPriority": 0,
"DaysLate": 0,
"ContractID": "",
"ProjProcessed": false,
"SyncReqBy": false,
"CustName": "",
"CustID": "",
"IsCSRSet": false,
"UnReadyCostProcess": false,
"ProcSuspendedUpdates": "",
"ProjProcessedDate": null,
"PCLinkRemoved": false,
"ExternalMESSyncRequired": false,
"ExternalMESLastSync": null,
"EpicorFSA": false,
"AdvanceLaborRate": false,
"dspReadyCostProcess": false,
"EnableJobEngineered": false,
"EnableJobFirm": false,
"EnableJobReleased": false,
"EnableMaterialStatus": false,
"EnableProject": false,
"EngineerAllowed": false,
"EquipLocDesc": "",
"ExtUpdated": false,
"FinalOpDueDate": null,
"FirmProcEnable": false,
"FirmProcess": false,
"HasPlanAsAsm": false,
"HeaderSensitive": false,
"IgnoreMtlConstraints": false,
"JobTypeName": "",
"KitTime": 0,
"LockedQty": false,
"NewMeter": 0,
"OldJobNum": "",
"OrderQty": 0,
"PartmasterPart": false,
"PhaseDescription": "",
"PMJob": false,
"ProcessModeDescription": "",
"ReceiveTime": 0,
"SmartString": "",
"SmartStringProcessed": false,
"SOExists": false,
"StockQty": 0,
"ToFirm": false,
"XRefPartTypeDesc": "",
"ChangeDescription": "",
"ClearDataset": false,
"IsCoPart": false,
"BitFlag": 8,
"AnalysisCdDescription": "",
"CallLineLineDesc": "",
"EquipMeterUOM": "",
"EquipSerialNum": "",
"EquipLocID": "",
"EquipPlant": "",
"EquipDescription": "",
"EquipBrand": "",
"EquipModel": "",
"EquipCurrentMeter": 0,
"EquipTypeID": "",
"EquipOEM": "",
"ExpenseCodeDescription": "",
"HDCaseDescription": "",
"PartNumSalesUM": "FT",
"PartNumIUM": "FT",
"PartNumTrackLots": false,
"PartNumPartDescription": "SLAB BOLSTER UPPER - 2'' HEIGHT - PLAIN - 5000/FT SKID",
"PartNumTrackSerialNum": false,
"PartNumTrackDimension": false,
"PartNumSellingFactor": 1,
"PartNumPricePerCode": "E",
"PartNumLocationIDNumReq": false,
"PersonIDName": "",
"PlantName": "OCM Manufacturing",
"PlantMaintPlant": "MfgSys",
"ProdCodeDescription": "SBU - PLAIN DOM",
"ProdTeamIDDescription": "",
"ProdTeamIDName": "",
"ProjectIDDescription": "",
"QuoteLineLineDesc": "",
"QuoteNumCurrencyCode": "",
"SchedCodeDescription": "NORMAL",
"RowMod": ""
}