Q35GetWorkOrder

Cantara Business Function to fetch a Work Order's master data from JDE Tables F4801 and F4801T. Usually this function is used prior to calling the Q35WorkOrderMasterService to get a work orders current for fields that are not being updated.

Called By

This function is called by the following Q35 functions:

Data Structure

Name	Type	Inclusion	Direction
DOCO_mnOrderNumber	INTEGER	REQUIRED	IN
DCTO_szOrderType	UDC	OPTIONAL	OUT
PTWO_mnPegToWorkOrder	INTEGER	OPTIONAL	OUT
PARS_szParentOrderNumber	STRING	OPTIONAL	OUT
TYPS_cWOType	UDC	OPTIONAL	OUT
PRTS_cWOPriority	UDC	OPTIONAL	OUT
DL01_szWODescription	STRING	OPTIONAL	OUT
STCM_szStatusComment	STRING	OPTIONAL	OUT
MCU_szBusinessUnit	BUSINESSUNIT	OPTIONAL	OUT
MMCU_szBranchPlant	BUSINESSUNIT	OPTIONAL	OUT
SRST_szWOStatus	UDC	OPTIONAL	OUT
SUB_szSubsidiary	STRING	OPTIONAL	OUT
AN8_mnCustomerNumber	ADDRESSNUMBER	OPTIONAL	OUT
ANO_mnOriginatorNumber	ADDRESSNUMBER	OPTIONAL	OUT
ANSA_mnManager	ADDRESSNUMBER	OPTIONAL	OUT
ANPA_mnSupervisor	ADDRESSNUMBER	OPTIONAL	OUT
ANP_mnAssignedToAddressNumber	ADDRESSNUMBER	OPTIONAL	OUT
DPL_jdPlannedCompletionDate	DATE	OPTIONAL	OUT
ANT_mnInspectorNumber	ADDRESSNUMBER	OPTIONAL	OUT
NAN8_mnNextAddressNumber	ADDRESSNUMBER	OPTIONAL	OUT
STRT_jdStartDate	DATE	OPTIONAL	OUT
DRQJ_jdRequestedDate	DATE	OPTIONAL	OUT
STRX_jdCompletionDate	DATE	OPTIONAL	OUT
WR01_szWOCategoryCode001	UDC	OPTIONAL	OUT
WR02_szWOCategoryCode002	UDC	OPTIONAL	OUT
WR03_szWOCategoryCode003	UDC	OPTIONAL	OUT
WR04_szWOCategoryCode004	UDC	OPTIONAL	OUT
WR05_szWOCategoryCode005	UDC	OPTIONAL	OUT
WR06_szWOCategoryCode006	UDC	OPTIONAL	OUT
WR07_szWOCategoryCode007	UDC	OPTIONAL	OUT
WR08_szWOCategoryCode008	UDC	OPTIONAL	OUT
WR09_szWOCategoryCode009	UDC	OPTIONAL	OUT
WR10_szWOCategoryCode010	UDC	OPTIONAL	OUT
VR01_szReference	STRING	OPTIONAL	OUT
VR02_szReference2	STRING	OPTIONAL	OUT
AMTC_mnChargeToOriginalAmount	FLOAT	OPTIONAL	OUT
HRSO_mnEstimatedHours	FLOAT	OPTIONAL	OUT
HRSA_mnHoursActual	FLOAT	OPTIONAL	OUT
ITM_mnShortItemNumber	SHORTITEM	OPTIONAL	OUT
NUMB_mnAssetNumber	ASSETNUMBER	OPTIONAL	OUT
UORG_mnQtyOrdered	FLOAT	OPTIONAL	OUT
UOM_szUnitOfMeasure	UDC	OPTIONAL	OUT
SHNO_szMessageNumber	STRING	OPTIONAL	OUT
TBM_szTypeOfBill	UDC	OPTIONAL	OUT
TRT_szTypeOfRouting	UDC	OPTIONAL	OUT
SPRT_cFlashMessage	UDC	OPTIONAL	OUT
PC_mnPercentComplete	FLOAT	OPTIONAL	OUT
LOTN_szLotNumber	STRING	OPTIONAL	OUT
SBLI_cSubledgerInactiveCode	UDC	OPTIONAL	OUT
ESDN_mnEstimatedDowntimeHours	FLOAT	OPTIONAL	OUT
ACDN_mnActualDowntimeHours	FLOAT	OPTIONAL	OUT
SAID_mnServiceAddressNumber	ADDRESSNUMBER	OPTIONAL	OUT
APRT_szApprovalType	UDC	OPTIONAL	OUT
AMLC_mnEstimatedLaborAmount	FLOAT	OPTIONAL	OUT
AMMC_mnEstimatedMaterialAmount	FLOAT	OPTIONAL	OUT
AMOT_mnEstimatedOtherAmount	FLOAT	OPTIONAL	OUT
LBAM_mnActualLaborAmount	FLOAT	OPTIONAL	OUT
MTAM_mnActualMaterialAmount	FLOAT	OPTIONAL	OUT
ISSUE_szISSUE	STRING	OPTIONAL	OUT
PRODM_szProductModel	UDC	OPTIONAL	OUT
WHO2_szContactName2	STRING	OPTIONAL	OUT
AR1_szPhoneAreaCode1	STRING	OPTIONAL	OUT
PHN1_szPhoneNumberOne	STRING	OPTIONAL	OUT
TMCO_mnTimeCompleted	INTEGER	OPTIONAL	OUT
MTHPR_cMethodofPricing	UDC	OPTIONAL	OUT
ENTCK_szEntitlementCheck	UDC	OPTIONAL	OUT
RYIN_cPaymentInstrumentA	UDC	OPTIONAL	OUT
RSTM_mnResponseTime	FLOAT	OPTIONAL	OUT
CTR_szCountry	UDC	OPTIONAL	OUT
REGION_szGeographicRegion	UDC	OPTIONAL	OUT
TXA1_szTaxArea1	STRING	OPTIONAL	OUT
EXR1_szTaxExplanationCode1	UDC	OPTIONAL	OUT
LNGP_szLanguagePreference	UDC	OPTIONAL	OUT
GLCCV_szGLCategoryCovered	UDC	OPTIONAL	OUT
GLCNC_szGLCategoryNonCovered	UDC	OPTIONAL	OUT
COVGR_szCoverageGroup	UDC	OPTIONAL	OUT
TIMEZONES_szTimeZoes	UDC	OPTIONAL	OUT
PRODF_szProductFamily	UDC	OPTIONAL	OUT
CRDC_szCurrencyCodeTo	STRING	OPTIONAL	OUT
CRCD_szCurrencyCodeFrom	STRING	OPTIONAL	OUT
CRRM_cCurrencyMode	UDC	OPTIONAL	OUT
CRR_mnCurrencyConverRateOv	FLOAT	OPTIONAL	OUT
WR11_szECOworkbenchselections	UDC	OPTIONAL	OUT
WR12_szCategoriesWorkOrder12	UDC	OPTIONAL	OUT
WR13_szCategoriesWorkOrder13	UDC	OPTIONAL	OUT
WR14_szCategoriesWorkOrder14	UDC	OPTIONAL	OUT
WR15_szCategoriesWorkOrder15	UDC	OPTIONAL	OUT
WR16_szCategoriesWorkOrder16	UDC	OPTIONAL	OUT
WR17_szCategoriesWorkOrder17	UDC	OPTIONAL	OUT
WR18_szCategoriesWorkOrder18	UDC	OPTIONAL	OUT
WR19_szCategoriesWorkOrder19	UDC	OPTIONAL	OUT
WR20_szCategoriesWorkOrder20	UDC	OPTIONAL	OUT
MCULT_szWorkCenterLeadCraft	STRING	OPTIONAL	OUT
DOC_mnDocVoucherInvoiceE	INTEGER	OPTIONAL	OUT
OTAM_mnAmountActualOther	FLOAT	OPTIONAL	OUT
mnPlannedFinishTime	INTEGER	OPTIONAL	OUT
SEST_mnTimeScheduledStart	INTEGER	OPTIONAL	OUT
mnRequestedFinishTime	INTEGER	OPTIONAL	OUT
SRYN_cEligibleSupplierRecovery	UDC	OPTIONAL	OUT
SQOR_mnUnitsSecondaryQtyOr	FLOAT	OPTIONAL	OUT
SOQS_mnUnitsQuantityShipped	FLOAT	OPTIONAL	OUT
SOBK_mnUnitsQuanBackorHeld	FLOAT	OPTIONAL	OUT
SOCN_mnUnitsQuantityCanceled	FLOAT	OPTIONAL	OUT
QTYT_mnQuantityShippedToDate	FLOAT	OPTIONAL	OUT
SSOQ_mnSecondaryQtyCompleted	FLOAT	OPTIONAL	OUT
UOM2_szUnitOfMeasureSecondary	UDC	OPTIONAL	OUT
SEQN_mnSequenceNumber2	FLOAT	OPTIONAL	OUT
DUAL_cDualUnitOfMeasureItem	CHARACTER	OPTIONAL	OUT
SHFT_cShiftCode	UDC	OPTIONAL	OUT
TRDJ_jdDateTransactionJulian	DATE	OPTIONAL	OUT
LOCN_szLocation	LOCATION	OPTIONAL	OUT