Q35UpdateWorkOrderDates
Cantara Business Function to provide a service to update a Work Order's date fields as if updating in the standard JDE Application P17714 or P13714.
It is assumed dates will be updated with their times i.e if updating DPL_jdPlannedCompletionDate then it is assumed mnRequestedFinishTime is being updated as well.
To set a date fields value to null date the EV01_cDefaultBlanksToCurrent flag must be set to “0” to ensure the functions treats the date field parameters exactly as they are passed into the function. If the flag is not set to “0” and a date parameter is blank, then it retains its current value for that date and its related time. The EV01_cDefaultBlanksToCurrent parameter defaults to “1” if it is not “0”.
JDE default labels for Date & Time data aliases in tables F4801/F4801T:
Calls
This function calls the following Q35 functions:
Data Structure
Name | Type | Inclusion | Direction | Parameter Notes |
|---|---|---|---|---|
DOCO_mnOrderNumber | INTEGER | REQUIRED | IN | Work Order number to be updated |
VERS_szP17714Version | STRING | OPTIONAL | IN | P17714 version for Processing Option references. Default = ZJDE0001 |
EV01_cSuppressErrors | CHARACTER | OPTIONAL | IN | "1" = suppress NER errors |
DTAI_szErrorMessageDataItem | ERRORALIAS | OPTIONAL | OUT | Returned error code, if any |
DPL_jdPlannedCompletionDate | DATE | OPTIONAL | BOTH | New DPL Date, format yyyy/MM/dd |
mnRequestedFinishTime | INTEGER | OPTIONAL | BOTH | New alias SEET Time, format as integer representing hmmss |
STRT_jdStartDate | DATE | OPTIONAL | BOTH | New STRT Date, format yyyy/MM/dd Cannot be set to Null Date as this will default as Today |
SEST_mnTimeScheduledStart | INTEGER | OPTIONAL | BOTH | New alias SEST Time, format as integer representing hmmss |
DRQJ_jdRequestedDate | DATE | OPTIONAL | BOTH | New DRQJ Date, format yyyy/MM/dd Cannot be set to Null Date as this will default as Today |
mnPlannedFinishTime | INTEGER | OPTIONAL | BOTH | New alias PBTM Time, format as integer representing hmmss |
STRX_jdCompletionDate | DATE | OPTIONAL | BOTH | New STRX Date, format yyyy/MM/dd |
TMCO_mnTimeCompleted | INTEGER | OPTIONAL | BOTH | New alias TMCO Time, format as integer representing hmmss |
EV01_cDefaultBlanksToCurrent | CHARACTER | OPTIONAL | IN | Value “0” attempts to set Date & Time to provided values, including Null Date and 0 Time if permitted. Any other value including blank are treated as “1”. Must be “1” to trigger calculation of Service WO Response Time |
RSTM_mnResponseTime | FLOAT | OPTIONAL | BOTH | Response Time override value |
EV01_cReserveObject | CHARACTER | OPTIONAL | IN | Reserve Object mode for NQ35CA13.Q35ReserveObject where “1”=Standard JDE Reservation, “2”=OK if same user, remove reservation after, “3”=OK if same user, do not remove reservation |