Equipment Validation interface for JD Edwards

About the Equipment Validation interface

The Equipment Validation interface allows for calling a function to validate the equipment number being processed and return some information back to TimeTRAC.

The equipment number being processed must be setup in the asset master file (F1201).

Name	Function name	Description
DD3N0007		dcLINK TimeTRAC: Equipment Validation
ND3N0007	dcLINKTimeTRACEquipValidation	dcLINK TimeTRAC: Equipment Validation

The full name of this interface is ND3N0007 Equipment Validation

This interface guide applies to the following JDE versions.

EnterpriseOne Xe through 9.1

Corresponding EnterpriseOne application

This NER is unique to TimeTRAC to validate the equipment number. There is no corresponding application in EnterpriseOne.

Processing options

This NER does not use any processing options to perform its processing.

Processing

This NER will validate that the equipment number passed in is a valid asset number/unit number/serial number in the F1201 Asset Master file.

If the equipment number being passed in is not a valid number, or the equipment has been disposed, then an error number will be returned in the szErrorMessageKey_GS1A and the cReturnErrorCode_ERRC will have a value of ‘2'.

If the equipment number is a valid equipment number, then this NER will return the equipment description, unit number, serial number, location, etc.

One of the fields being returned is the equipment status. Equipment status is a user defined field, meaning the user can enter any codes they want. Since those codes have meaning only to the user, this NER simply returns the value to the calling program and does not try to interpret the codes relative to the availability of the equipment.

The sole input field is the szInputAssetNumber_ASII. This field will accept any of tthe following values.

Asset number
Unit number
Serial number

This NER will determine which one is passed in and use it to validate the equipment number. It will return all three values back.

The asset number will be in mnAssetitemNumber_ASID.
The unit number will be in szUnitNumber_APID.
The serial number will be in szSerialTagNumber_ASID.

In EnterpriseOne, one of these three numbers is designated to be the “primary” number (the one usually entered to look up the machine). Whichever one is setup as the “primary” will also be returned in the szPrimiaryAssetNo_ASII.

The account number being returned is the asset cost account number.

Required fields

There is only one input field, szInputAssetNumber_ASII, and it is required. If no equipment number is passed in, or an invalid equipment number is passed, the same error will be returned: Asset Number Invalid.

Verify the processing

To verify this business function, compare the information returned to the information in the asset master file.

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

In EnterpriseOne, from the menu G1211, execute the program Master Information P1204.
Use this program to view how the equipment number is setup and if the correct information is being returned.

Input data structure

Input data structure for Equipment Validation ND3N0007.

Name	Default values	R/O	Alias	Notes
szInputAssetNumber_ASII		R	ASII	This is the only input field and it cannot be left blank. Any valid asset number, unit number, or serial number may be used. It is not necessary to prefix the numbers. This NER will figure out which one is being passed in.
cReturnErrorCode_ERRC	Blanks	O	ERRC	If an error is found when this business function is called, then a ‘2' will be returned in this field.
szErrorMessageKey_GS1A	Blanks	O	GS1A	The error message key will be the alias of the error message.
szPrimaryAssetNo_ASII		O	ASII	This field will contain the value of the default number that is used to read the asset master. For example, if the unit number is setup in the company constants as the default, then the unit number will be returned in this field.
mnAssetItemNumber_NUMB		O	NUMB	This field will return the asset number of the item being validated.
szUnitNumber_APID		O	APID	This field will return the unit number of the item being validated. Unit number is not always required so this field may be blank.
szSerialTagNumber_ASID		O	ASID	This field will return the serial number of the item being validated. Serial number is not always required so this field may be blank.
szAssetDescription1_DL01		O	DL01	Each asset can have a description of up to three lines of text. This is the first description line.
szAssetDescription2_DL02		O	DL02	Each asset can have a description of up to three lines of text. This is the second description line.
szAssetDescription3_DL03		O	DL03	Each asset can have a description of up to three lines of text. This is the third description line.
szAssetLocation_LOC		O	LOC	This is the location where the asset is located.
szLocationDesc_DL01		O	DL01	This is the description of the location.
szCompany_CO		O	CO	The company number that the asset was set up under.
szGLAccountNumber_ANI		O	ANI	This is the cost account number of the asset from the asset master file. There are three pieces that can make up this number: the cost center, the object account, and the subsidiary account.
szEquipmentStatus_EQST		O	EQST	The status code of the equipment number being processed.

R = Required

X = Required but will default in if not passed

O = Optional

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	Validate using the asset number	Validate using a unit number	Validate using a serial number	An example of an invalid equipment number
szInputAssetNumber_ASII	1018	U 9153	35D70C2 3D80222S4 35402	1666
cReturnErrorCode_ERRC				2
szErrorMessageKey_GS1A				0626
szPrimaryAssetNo_ASII	1018	1018	1018	0
mnAssetItemNumber_NUMB	1018	1018	1018	0
szUnitNumber_APID	U-9153	U-9153	U-9153
szSerialTagNumber_ASID	35D70C2 3D80222S4 35402	35D70C2 3D80222S4 35402	35D70C2 3D80222S4 35402
szAssetDescription1_DL01	Ace Truck, ¾ Ton Panel	Ace Truck, ¾ Ton Panel	Ace Truck, ¾ Ton Panel
szAssetDescription2_DL02	Chevrolet 2004 261CID	Chevrolet 2004 261CID	Chevrolet 2004 261CID
szAssetDescription3_DL03
szAssetLocation_LOC	5100	5100	5100
szLocationDesc_DL01	Potomac Hotel	Potomac Hotel	Potomac Hotel
szCompany_CO	00050	00050	00050
szGLAccountNumber_ANI	50.2040	50.2040	50.2040
szEquipmentStatus_EQST

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
0626	Asset Number Invalid: Input. This message will be received if 1) no value is passed into the business function in the szInputAssetNumber_ASII field, or 2) a value was passed in but it does not exist in the F1201 Asset Master file.
501B	The Item was Disposed. An equipment number was found, but the equipment number has a disposition date that is less than or equal to today's date.

There was a problem loading this topic

Mobile Enterprise Platform