send feedback

❮ Previous Next ❯

Service Order Labor interface for JD Edwards

About the Service Order Labor interface

This interface is used to dispose of an item, and to advance a given quantity of an item to the next operation code.

The Service Order Labor interface is used to advance a given quantity of an item to the next operation code in Service Order Labor. It is also used to dispose of an item. This interface was written in NER and calls a ‘C' business function BD3N1703 to retrieve the processing options.

Name	Function name	Description
DD3N1732		dcLINK Interface Service Order Labor
ND3N1732	dsiServiceOrderLabor	dcLINK Interface Service Order Labor
DD3N1703		PO Retrieval Service Order Labor
BD3N1703	PORetrievalServiceOrderLabor	PO Retrieval Service Order Labor

The full name of this interface is ND3N1732 Service Order Labor

This interface guide applies to the following JDE versions.

EnterpriseOne Xe through 9.1

Corresponding EnterpriseOne application

In EnterpriseOne, the application you would run to report Service Order Labor is P17332, which can be accessed via a button at the bottom of the screen on application P48201. The menu to find P48201/P17732 is G1712.

Processing options

Processing options for Service Order Labor.

The processing options version will default to ZJDE0001 if not otherwise specified in the parameter list on the call. Please note that, even if we are not directly using a particular processing option, it does not mean that it does not matter when running the interface, as JDE may use it.

Process tab

Parts Detail (cCreatePartsListFlag_EV02): This determines if the Parts Detail is automatically created.
Operation's Generic Text (cCopyRoutingText_EV01): This determines if the generic text is copied to the work order routing.
Queue and Move Hours (cDefaultQueueMoveHrsFlag_EV01): This determines if and how the queue and move hours are defaulted.
Address Search Type for Employees (szEmployeeAddressType_AT1): This sets the default search type.

Defaults tab

Time Basis Code (cTimeBasisCode_TIMB): The value of this field will be used as the default time basis code if no time basis code was provided, and a value was entered into this field.

Display tab

Billable Fields (cHideBillableFlds_EV01): This will determine if the Billable fields will be shown on the interactive application.
Payable Fields (cHidePayableFlds_EV01): This will determine if the Payable fields will be shown on the interactive application.
Hide Contract-related fields (cHideContractFlds_EV01): This will determine if the Contract-Related fields will be shown on the interactive application.

Exports tab

Transaction Type (szTransactionType_TYTN): The value of this field will be used as the transaction type for export transactions.

Versions tab

Capacity Load program (szP3313Version_VERS): The version used for the P3313 program.
Work with Activity Based Costing Workbench (szABCWorkbenchVersion_VER): The version used for the P1640 program.
Equipment Master Workbench (szP1701Version_VERS): The version used for the P1701 program.
Work Order Process Resource Revisions (szP3111PVersion_VERS): The version used for the P3111P program.

Processing option data structure for DD3N1703

The interface retrieves these parameters by calling BD3N1703.They are passed back in the following data structure.

Type	Description	Parameter
String	szVersion_VERS	Input
Char	cCreatePartsListFlag_EV02	Output
Char	cCopyRoutingText_EV01	Output
Char	cDefaultQueueMoveHrsFlag_EV01	Output
String	szEmployeeAddressType_AT1	Output
Char	cTimeBasisCode_TIMB	Output
Char	cHideBillableFlds_EV01	Output
Char	cHidePayableFlds_EV01	Output
Char	cHideContractFlds_EV01	Output
String	szTransactionType_TYTN	Output
String	szP3313Version_VERS	Output
String	szABCWorkbenchVersion_VER	Output
String	szP1701Version_VERS	Output
String	szP3111PVersion_VERS	Output

Processing

This interface provides two processing options, adding a service labor record, and changing a service labor record.

There are two primary activities that can be performed by this function: adding a labor record, or changing an existing labor record. The dsiActionCode is used to determine this.

In order to add a labor record, the cdsiActionCode must be an ‘A'. In order to change an existing record, the cdsiActionCode must be a ‘C'.

Action code	Advanced Inventory action code	Description
	A	Add a labor record.
	C	Change an existing labor record.

Required fields

There are two options available when using this interface.

To add a service labor record, the interface requires the user to supply the Advanced Inventory action code (A), order number, order type, item number, branch plant, and work center as a minimum. This will write the service labor order line. It is advisable, however, to also pass in run machine, estimated hours, and setup crew.
To change a service labor record, the interface requires the user to supply the Advanced Inventory action code (C), order number, order type, operation sequence, item number, branch plant, and work center, as a minimum. This will update the existing service labor order line.

Verify the processing

Steps to verify the processing of this interface.

To verify the processing, complete the following steps in JDE.

Open the work order entry program (P4820) on menu G1712.
Select the order you wish to view.
Select Labor Detail button at the bottom of the screen.

Step Information

The P17732 opens and provides a view of all the transactions for that order.

Input data structure

Input data structure for DD3N1732.

Name	Default value	R/O	Alias	Notes
cdsiActionCode_EV01	A	X	EV01	A = Add service labor line. C = Change existing service labor line. This will default to ‘A' if not passed in.
cActionCode_ACTION		N/A	ACTION	This is not currently used in this interface.
jdDateUpdated_UPMJ	(Current Date)	X	UPMJ	Retrieved from GetAuditInfo if not passed in.
mnTimeOfDay_TDAY	(Current Time)	X	TDAY	Retrieved from GetAuditInfo if not passed in.
szUserId_USER	(Current User)	X	USER	Retrieved from GetAuditInfo if not passed in.
szWorkStationId_JOBN	(Current Workstation)	X	JOBN	Retrieved from GetAuditInfo if not passed in.
mnJobNumber_JOBS		O	JOBS	Assigned in the interface.
szProgramId_PID	EP17732	X	PID	Defaulted in program if not passed in.
szVersion_VERS	ZJDE0001	X	VERS	Defaulted in program if not passed in. This is the version for P17732.
cSuppressErrMsg_EV01		O	EV01	This is not currently used in this interface.
cErrorCode_ERRC		X	ERRC	Returned from program.
szErrorMessageKey_EKEY		X	EKEY	Returned from program.
iDebugLevel_INT01		O	INT01	Leave blank except for debugging and testing purposes only. When running xml, pass in a ‘99' to get a server debug log. When running fat client, it will display M&D Debug statements if the value is greater than “0”.
szLongErrorMessage_DTAI		O	DTAI	Returned from program. Error messages are returned here.
mnOrderNumber_DOCO		R		The work order number. This is required.
szOrderType_DCTO		O		A user defined code (00/DT) that identifies the type of document.
szWorkOrderDescription_DL01		N/A		The description associated with the work order.
szItemNumber_UITM		N/A		The inventory item number associated with the equipment number.
szBranch_MMCU		R		This is the branch plant on the order. This is required.
szCompany_CO		N/A		A code that identifies a specific organization, fund, or other reporting entity.
szBillableCurrency_BCRCD		N/A		The currency for the billable amounts of a service order.
mnBillableExchangeRate_BCRR		N/A		The rate that the system uses to convert foreign currency amounts to domestic currency amounts.
szBillableBaseCurrency_CRDC		N/A		A code that identifies the domestic (base) currency of the company on a transaction.
cBillableCurrencyMode_BCRRM		N/A		A code that specifies whether the system uses the foreign currency (currency of the customer) or the domestic currency for billable amounts.
szWorkCenter_MCU		R		This is the work center for the labor record. This is required.
mnOperationSequence_OPSQ		O		This will default for an add record, but is required for changing a record.
szOperationStatus_OPST		O		This should default from the service order.
szWorkCenterDescription_DSC1		O		Work Center description. This will default if not passed in.
mnRunMachine_RUNM		O		Estimated machine hours for the labor record.
mnEstimatedHours_RUNL		O		This is the number of hours required to do the task. If estimated duration is passed in, this will be calculated within the interface.
mnSetupCrew_SETC		O		The number of people who work in the specified work center or routing operation. This will default to 1 if not passed in.
mnEstimatedDuration_EDUR		O		This is the time it should take to do the task – it is calculated by dividing the estimated hours by the setup crew
mnActualHours_LABA		O		Actual Hours worked.
mnPieceworkRate_PWRT		O		If it is set up in the manufacturing constants, this will be the Direct Labor Frozen rate.
mnExtendedCost_ECST		O		This is the estimated cost, based on the estimated hours times the piecework rate.
mnSetupLabor_SETL		O		The standard setup hours that you expect to incur in the normal completion of this item.
mnQueueHours_QUED		O		The total hours that an order is expected to be in queue at work centers and moving between work centers.
mnMoveHours_MOVD		O		The planned hours that are required to move the order from this operation to the next operation in the same work center.
jdPlannedStartDate_STRT		O		This is the operation start date. Defaults from the system date.
jdPlannedFinishDate_DRQJ		O		The date that an item is scheduled to arrive or that an action is scheduled for completion. Defaults from the system date.
jdActualFinishDate_STRX		O		The date that the work order or engineering change order is completed or canceled.
mnAssignedTo_AN8		O		The address book number of the person/entitiy who is supposed to be performing the operation.
mnAssignedToName_DL01		O		The description of the person/entity who is supposed to be performing the operation.
cTimeBasis_TIMB		O		A user defined code (30/TB) that indicates how machine or labor hours are expressed for a product. This defaults from the processing options.
szTypeCode_OPSC		O		A user defined code (30/OT) that indicates the type of operation.
mnPercentOfOverlap_POVR		O		This indicates the percentage that successive operations can overlap.
szMessageNumber_SHNO		O		A generic rates and message code (48/SN) that is assigned to a standard note, message, or general narrative explanation.
szAssetNumber_ASII				An identification code that represents an asset
szRelatedPoSoNumber_RORN		O		A number that identifies a secondary purchase order, sales order, or work order that is associated with the original order.
szRelatedOrderType_RCTO		O		A user defined code (system 00, type DT) that indicates the document type of the secondary or related order.
mnNextOperation_NXOP		O		Operation with which the current operation can be simultaneously processed.
mnResourceUnitsConsumed_RUC		O		A number that indicates how many of the line's resource units are needed to produce one item.
szCapacityUOM_CAPU		O		A unit of measure that you use to express the capacity of a production line.
szJobType_JBCD		O		A user-defined code (06/G) that identifies the jobs within your organization.
szCompentencyType_CMPE		O		A code that identifies a competency table or category for which you can track employee competencies.
szCompentencyCode_CMPC		O		A code that specifies a competency within a competency type.
mnCompetencyLevelFrom_CPLVLFR		O		This value set the lowest value to be included in the rule criteria range for a competency level range selection.
mnCompetencyLevelTo_CPLVLTO		O		This value set the highest value to be included in the rule criteria range for a competency level range selection.
cMatchRule_CMRQ		O		A field that indicates whether the resource must satisfy the requirements that define the rule criteria.
mnCustomerNumber_AN8		N/A		This is the customer number from the service order.
mnSiteNumber_SAID		N/A		This is the site number from the service order.
szEntitlementCheck_ENTCK		N/A		This is pulled from the service order.
szCoverageGroup_COVGR		N/A		This is pulled from the service order.
mnPercentCovered_PCOVR		O		The percentage covered under warranty or contract.
szServiceProvider_ALKY		O		This is the service provider. Defaults from the service order.
szServiceProviderDesc_DL01		N/A		This is the name or description for the service provider.
jdActualStart_D2J		O		The actual start date for the labor line.
szScheduledFinishTime_FTIME		O		The scheduled finish time for the labor line.
szActualStartTime_FTIME		O		The actual start time for the labor line.
szBillableAdjSchedule_ASN2		O		This user defined code (40/AS) identifies a price and adjustment schedule. It defaults from the F1797 for the customer number.
cMethodofPricing_MTHPR		O		A code used to determine if this type of service should be priced based on a flat rate or based on actual time and materials.
szCostType_COST		O		A code that designates each element of cost for an item
cBillableYN_BILL		O		Specifies whether a general ledger account should be billed.
mnEstimatedBillableRate_ESRTB		O		The estimated billable rate associated with a service.
mnEstimatedAmount_EBILL		O		The estimated amount associated with a service.
mnForeignEstBillRate_FESUNB		O		The foreign estimated billable rate associated with a service.
mnForeignEstBillAmount_FEBILL		O		The foreign estimated amount associated with a service.
mnActualBillableRate_ACRTB		O		The actual billable rate associated with a transaction.
mnTotalBilled_TOTB		O		The total amount billed through this application.
mnForeignActBillUnitRte_FACUNB		O		The actual billable rate in foreign currency associated with a transaction.
mnForeignActBillAmount_FTOTB		O		The actual billable amount in foreign currency associated with a transaction.
jdBillDate_DTBIL		N/A		The date a customer was billed for a service.
mnClaimAmount_CLAMT		O		The amount requested for providing a service.
szPayableAdjustSched_ASN4		O		A user defined code (40/AS) identifying a price and adjustment schedule.
cPayPricingMethod_PMTHP		O		A code used to determine if this type of service should be priced based on a flat rate or based on actual time and materials.
cPayableYN_PAYAB		O		This field specifies whether a general ledger account should be paid.
szPayableCurrency_PCRCD		O		A code that indicates the currency of the payable amounts on a work order or claim.
mnPayableExchangeRate_PCRR		O		The rate that the system uses to convert foreign currency amounts to domestic currency amounts.
cPayableCurrencyMode_PCRRM		O		A code that specifies whether payable amounts are in the foreign currency (currency of the service provider) or in the domestic currency.
mnEstimatedPayableRate_ESRTP		O		The estimated payable rate associated with a transaction.
mnEstimatedPaymentAmount_EPAAP		O		This is the estimated payment amount used in service billing.
mnForeignEstPayUnitRate_FESUNP		O		The estimated unit rate that is payable in the currency of the service provider. Only valid if the order is multi-currency.
mnForeignEstPayAmount_FEPAAP		O		The estimated payble amount that is payable in the currency of the service provider. Only valid if the order is multi-currency.
mnActualPayableRate_ACRTP		O		The actual payable rate associated with a transaction.
mnPaymentAmount_PAAP		O		The amount of the payment.
mnForeignActPayUnitRate_FACUNP		O		The actual unit rate that is payable in the currency of the service provider. Only valid if the order is multi-currency.
mnForeignActPayAmount_FPAAP		O		The actual amount that is payable in the currency of the service provider. Only valid if the order is multi-currency.
jdPaidDate_DTPAY		N/A		The date a service provider was paid for a service.
szCausalPartBusUnit_MCUCSL		O		The business unit that is related to the causal portion of the claim.
szCausalPart_UITM		O		A number that the system assigns to an item. It can be in short, long, or third item number format.
szCausalPartDescription_DL01		N/A		The description of the causal item.
szSupplierLotNumber_RLOT		O		The supplier's lot number for the item.
mnSuppRecVendorNumber_SRVEND		O		The address book number of the vendor to be used for supplier recovery.
szSuppRecVendorDesc_DL01		O		The description of the supplier recovery vendor.
szP3112Version_VERS		O		Defaulted to ZJDE0001 if not passed in.
szP48013Version_VERS		O		Defaulted to ZJDE0001 if not passed in.


szGuidUniqueID_GUID	Automatically generated by dcLINK	O	CFRGUID	If generate GUIDs is turned on in the dcLINK configuration utility, this field will contain a GUID (guaranteed unique identifier). The GUID is used to tie database changes in PeopleSoft to the transactions that triggered those changes to occur.
szGuidApprover1_USR1		O,R	USR1	An entry in this field or the Approver 2 field will cause a signature capture record to be written. Signature capture records are part of the GUID processing and should not be used unless a GUID is being created by dcLINK. The value of this field is a User ID, not an address book entry. There must be a value passed in to either this field, or the approver 2 field, otherwise it is an error.
szGuidFullName1_FULLNAME1		O	FULLNAME1	This field is the full name of the GUID Approver 1.
szGuidApprover2_USR2		O,R	USR2	GUID processing supports up to two approvers. If two approvers are required, this is the user ID of the second approver. There must be a value passed in to either this field or the approver 1 field otherwise it is an error.
szGuidFullName2_FULLNAME2		O	FULLNAME2	This field is the full name of the GUID Approver 2.
mnGuidReasonCode1_REASON1		O,R	REASON1	If either of the approver fields contains a value, but no value is entered into one of the reason code fields, then an error will be returned. Reason codes must match the valid reason codes setup for GUID processing, otherwise it is an error.
szGuidCommentField_COMMENTS		O	COMMENTS	This is a free form entry field that is used to further explain the reason code entered into the previous field.
mnGuidReasonCode2_REASON2		O,R	REASON2	If either of the approver fields contains a value, but no value is entered into one of the reason code fields, then an error will be returned. Reason codes must match the valid reason codes setup for GUID processing, otherwise it is an error.
szGuidCommentField2_2COMMENTS		O	2COMMENTS	This is a free form entry field that is used to further explain the reason code entered in the previous field.
szGuidScriptID_FMNMVERS		O	FMNMVERS	In PeopleSoft the screen ID where the change was made is captured. dcLINK captures the script ID.
szGuidTextMessage_TEXTMES		O	TEXTMES	This is a free form entry field.

O = Optional

R = Required

X = Required but will default in if not passed

Transaction test scenarios

The following test scenarios demonstrate a variety of ways in which this interface could be used, and the fields that would be passed for each scenario.

The data structure fields are in the left column, and the corresponding values for each scenario are listed by column.

Field name	Add labor record without actual hours	Add labor record with actual hours	Change a labor report and report actual hours
cdsiActionCode_EV01	A	A	C
cActionCode_ACTION
jdDateUpdated_UPMJ
mnTimeUpdated_TDAY
szUserId_USER
szWorkStationId_JOBN
mnJobNumber_JOBS
szProgramId_PID
szVersion_VERS
cSuppressErrMsg_EV01
cErrorCode_ERRC
szErrorMessageKey_EKEY
iDebugLevel_INT01
szGuidUniqueID_GUID
szGuidApprover1_USR1
szGuidFullName1_FULLNAME1
szGuidApprover2_USR2
szGuidFullName2_FULLNAME2
mnGuidReasonCode1_REASON1
szGuidCommentField_COMMENTS
mnGuidReasonCode2_REASON2
szGuidCommentField2_2COMMENTS
szGuidScriptID_FMNMVERS
szGuidTextMessage_TEXTMES
szLongErrorMessage_DTAI
mnOrderNumber_DOCO	463881	463881	463881
szOrderType_DCTO
szWorkOrderDescription_DL01
szItemNumber_UITM
szBranch_MMCU	M30	M30	M30
szCompany_CO
szBillableCurrency_BCRCD
mnBillableExchangeRate_BCRR
szBillableBaseCurrency_CRDC
cBillableCurrencyMode_BCRRM
szWorkCenter_MCU	200-801	200-801	200-801
mnOperationSequence_OPSQ			1.0
szOperationStatus_OPST
szWorkCenterDescription_DSC1
mnRunMachine_RUNM	1	1
mnEstimatedHours_RUNL
mnSetupCrew_SETC	2	2
mnEstimatedDuration_EDUR	3	3
mnActualHours_LABA		5.75	5.75
mnPieceworkRate_PWRT
mnExtendedCost_ECST
mnSetupLabor_SETL	1	1
mnQueueHours_QUED	1	1
mnMoveHours_MOVD	1	1
jdPlannedStartDate_STRT
jdPlannedFinishDate_DRQJ
jdActualFinishDate_STRX
mnAssignedTo_AN8
mnAssignedToName_DL01
cTimeBasis_TIMB
szTypeCode_OPSC
mnPercentOfOverlap_POVR
szMessageNumber_SHNO
szAssetNumber_ASII
szRelatedPoSoNumber_RORN
szRelatedOrderType_RCTO
mnNextOperation_NXOP
mnResourceUnitsConsumed_RUC
szCapacityUOM_CAPU
szJobType_JBCD
szCompentencyType_CMPE
szCompentencyCode_CMPC
mnCompetencyLevelFrom_CPLVLFR
mnCompetencyLevelTo_CPLVLTO
cMatchRule_CMRQ
mnCustomerNumber_AN8
mnSiteNumber_SAID
szEntitlementCheck_ENTCK
szCoverageGroup_COVGR
mnPercentCovered_PCOVR
szServiceProvider_ALKY
szServiceProviderDesc_DL01
jdActualStart_D2J
szScheduledFinishTime_FTIME
szActualStartTime_FTIME
szBillableAdjSchedule_ASN2
cMethodofPricing_MTHPR
szCostType_COST
cBillableYN_BILL
mnEstimatedBillableRate_ESRTB
mnEstimatedAmount_EBILL
mnForeignEstBillRate_FESUNB
mnForeignEstBillAmount_FEBILL
mnActualBillableRate_ACRTB
mnTotalBilled_TOTB
mnForeignActBillUnitRte_FACUNB
mnForeignActBillAmount_FTOTB
jdBillDate_DTBIL
mnClaimAmount_CLAMT
szPayableAdjustSched_ASN4
cPayPricingMethod_PMTHP
cPayableYN_PAYAB
szPayableCurrency_PCRCD
mnPayableExchangeRate_PCRR
cPayableCurrencyMode_PCRRM
mnEstimatedPayableRate_ESRTP
mnEstimatedPaymentAmount_EPAAP
mnForeignEstPayUnitRate_FESUNP
mnForeignEstPayAmount_FEPAAP
mnActualPayableRate_ACRTP
mnPaymentAmount_PAAP
mnForeignActPayUnitRate_FACUNP
mnForeignActPayAmount_FPAAP
jdPaidDate_DTPAY
szCausalPartBusUnit_MCUCSL
szCausalPart_UITM
szCausalPartDescription_DL01
szSupplierLotNumber_RLOT
mnSuppRecVendorNumber_SRVEND
szSuppRecVendorDesc_DL01
szP3112Version_VERS
szP48013Version_VERS

Common error messages

The following are common error messages that can be generated by this BF, and what those error messages mean.

Error message	Meaning
0002	Record Invalid. This error is returned when an error has been detected from one of these three business functions: dcLINK Set User ID, dcLINK Utility Set Audit Info, or dcLINK Utility Write Signature Capture Record. It will be set if the record cannot be found in the F3112 table when performing a change record.
006J	Invalid Unit of Measure. This is set when the Capacity UOM is invalid.
0115	Work Order Number Invalid. In this interface, this will be set if the order number is blank or zero.
0364	Equipment Number Invalid. If an equipment number is passed in, this is set if the equipment number is not found in the F1201.
3501	Sequence Number Invalid. This is set when performing a change action and the sequence number is not passed in.
078I	Fetch from table &1 failed. This occurs when the call to SWMGetServiceOrder (N1700980) fails. It is likely due to an invalid order number.
125T	Start Date Required. This is set if the planned start date is null, AND the planned start date retrieved from the F4801T are both null.
132W	Level From Greater Than Level To. This is set when the competency level from is greater than the competency level to.
1A02	Invalid Order Type. This will be set when the work order type is not equal to a 04 or 05, based on the F40039.
4507A	Work Center, Work Center Branch Invalid. The work center and branch combination is not valid.

There was a problem loading this topic

Mobile Enterprise Platform