send feedback

❮ Previous Next ❯

Barrel Master interface for JD Edwards

About the Barrel Master interface

This NER can be used to add or edit a barrel in Blend Management.

The Barrel Master interface is used to add or edit a barrel in Blend Management. This interface was written in NER and calls a ‘C' business function BD3N4302 to retrieve the processing options.

Name	Function name	Description
DD3N3B01		PO Retrieval: Barrel Master
BD3N3B01	PORetrievalBarrelMaster	PO Retrieval: Barrel Master
DD3N3B03		dsi: Barrel Master
ND3N3B03	dsiBarrelMaster	dsi Interface: Barrel Master
ND3N3B03	dsiBlendSubWriteBarrelMaster	dsi: Blend Sub-Function Write Barrel Master

The full name of this interface is ND3NB03 Barrel Master

This interface guide applies to the following JDE versions.

EnterpriseOne 9.1

Corresponding EnterpriseOne application

In EnterpriseOne, the application you would run to Add or Edit the Barrel Master is P31B03. The menu to find P31B03 is G31B02.

Input data structure DD3N3B03

Input data structure for Barrel Master DD3N4141.

Name	Default value	R/O	Alias	Notes
cdcLINKActionCode_EV01	A	X	EV01	A = Add. C = Edit. This will default to ‘A' if not passed in.
cActionCode_ACTION		R	ACTION	0 = Add without running R31B34. 1 = Add from PO and running R31B34. 2 = Add from PO without running R31B34. 3 = Add running R31B34.
jdDateUpdated_UPMJ	(Current Date)	X	UPMJ	Retrieved from GetAuditInfo.
mnTimeOfDay_TDAY	(Current Time)	X	TDAY	Retrieved from GetAuditInfo.
szUserId_USER	(Current User)	X	USER	Retrieved from GetAuditInfo.
szWorkStationId_JOBN	(Current Workstation)	X	JOBN	Retrieved from GetAuditInfo.
mnJobNumber_JOBS		O	JOBS	Assigned by Begin Document.
szProgramId_PID	EP31B03	X	PID	Defaulted in program if not passed in.
szVersion_VERS	ZJDE0001	X	VERS	Defaulted in program if not passed in.
cSuppressErrMsg_EV01		O	EV01
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”.
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.
szWinery_MCU		R	MCU
szBarrelSegmentString_HCDS		R,O	HCDS	First text field of the 3 segments to create a new barrel number.
szBarrelSegmentYear_CUSE		O	CUSE	A user defined value that indicates the current use of a wine barrel.
mnBarrelSegment3_BARSEG3		O	BARSEG3	A value that represents the third segment of the Barrel ID. You can manually input a number in this field or have the system automatically generate the next available number.
szBarrelProfileDesc_BPDESC		O	BPDESC	Text description.
szBarrelAvailCode_BAVC		R,O	BAVC	A user defined value indicating the availability status of a barrel.
szBarrelType_BATP		R,O	BATP	A value that indicates a particular type of class of barrel or container.
cLeasedYN_LEAS		R,O	LEAS	Y/N flag indicating whether a barrel is leased or not.
szBarrel_ID_BARID		Return Data	BARID	A string that uniquely identifies an individual barrel (or collection of barrels). This is a string comprised of 3 segments.
mnBarrelOwner_BOWN		O	BOWN	A number corresponding to the Address Book number for the owner of a barrel.
mnLeaseCompany_LESCO		O	LESCO	A value that indicates the address book number of the company that barrels are leased from if barrels are not owned.
szLeaseCoName_LESCN		O	LESCN	The text name of the Barrel leasing company.
mnLeaseTerm_LESTM		O	LESTM	A value indicating the number of months (typically) in the term of a barrel lease.
jdLeaseDate_LESDT		O	LESDT	Date when a lease contract was entered.
szLeaseDocRef_LDREF		O	LDREF	A plain text description or reference to where a barrel is leased.
jdCommissionDate_DAFC		O	DAFC	Date representing when a barrel was first brought into service.
mnShaveBy_SHAVEBY		O	SHAVEBY	An indication of the Winery staff member who performed a barrel shave operation.
jdShaveDate_SHAVD		O	SHAVD	Date a barrel shave operation was completed.
jdDateOutService_DAOS		O	DAOS	Date indicating when a barrel was taken out of service.
szLocation_LOCN		O	LOCN	The storage location of the barrel.
szRackNumber_RKNMR		O	RKNMR	A unique string that identifies a particular barrel storage rack.
szBarrelColorStatus_BCST		O	BCST	A value used to indicate the color status inside a barrel.
szBarrelVolume_BVST		O	BVST	A value indicating the fill status of a barrel.
cBarrelNew_Used_BARCO		O	BARCO	A value indicating the condition of the barrel (New, Used, Reconditioned)
mnBarrelAge_RKNUM		O	RKNUM	A number that identifies barrel age.
mnTotalCapacity_TOCAP		O	TOCAP	A value that indicates the total capacity of a barrel or container.
mnFermentCapacity_FCAP		O	FCAP	A value that indicates the total fermentation capacity of a barrel or container.
szBarrelUOM_BCUOM		O	BCUOM	A code that represents the volume unit of measure (typically volume) associated with the total barrel capacity, or total container capacity.
mnBarrelPO_WBPO		O	WBPO	The Purchase Order that the original barrel order was completed on.
mnBlendSupplier_SUPL		O	SUPL	A number indicating the address book number of the supplier of a tank, barrel, or other equipment.
mnOriginalQTY_QTOR		O	QTOR	A value that represents the original quantity.
mnYearReceived_RECY		O	RECY	A value to indicate the year a barrel (or other vessel) was received.
mnReceiptQty_QTRC		O	QTRC	A value that represents the number of barrels received. If the winery tracking method is collection, then this is the number of barrels in the collection.
mnAssetNumber_ANUMW		O	ANUMW	A number that identifies an asset.
szProfileCode_BPCO		O	BPCO	A code that represents a barrel profile which is used to set common attributes for barrels.
szGeneral_GECM		O	GECM	A field that contains general comments.
szCostGroup_WCG		O	WCG	A code that identifies a set of one or more cost components associated with a Blend Operation.
cInsert_INSF		O	INSF	A flag that identifies whether or not a barrel contains an Insert. “0” = Vessel does not contain an insert(s). “1” = Vessel does contain an insert(s).
mnInsertNumber_INUM		O	INUM	A unique number that identifies a barrel insert.
mnInsertSupplier_INSU		O	INSU	The address book number for the supplier of a barrel insert.
szCooper_COOP		O	COOP	A user defined code for the Cooper (manufacturer) of a barrel, insert, plank, or other wine vessel.
szBarrelClass_BRLCLA		O	BRLCLA	A user defined code (31B/CL) that identifies an attribute of a barrel. For example, a barrel may be classified as spirit, sherry, or wine.
szToastLevel_TLEV		O	TLEV	A user defined value indicated the level of toast (charring) to the interior of the barrel.
cHeadToast_TSTH		O	TSTH	A value that indicates whether or not the head(s) of a barrel have been toasted.
szBarrelTypeVariation_BATV		O	BATV	A string that identifies a variation of a particular type.
szForest_FORES		O	FORES	Value to describe the forest the wood was harvested from.
szCountry_WCTRO		O	WCTRO	A user defined value that indicates a country.
szLocality_OLOC		O	OLOC	An indication of a region or location within a country.
mnNumberFills_NUMFL		O	NUMFL	Over the useable life of a barrel, this value represents the cumulative number of times a barrel has been filled.
jdFirstUse_DAFU		O	DAFU	Date representing the date when a barrel was first used.
jdLastUse_DALS		O	DALS	Date when SO2 (Sulfur Dioxide) treatment was last performed to a barrel.
szCurrentUse_CUSE		O	CUSE	A user defined value that indicates the current use of a wine barrel.
szNextUse_NXUSE		O	NXUSE	A user defined value indicating the intended next use of a particular barrel.
jdDateTreated_DALT		O	DALT	Date when the last treatment operation was performed on a barrel.
szMethodTreated_MTDLT		O	MTDLT	The most recent treatment method that has been applied to a barrel.
szBarrelCategoryCode1_SCTM		O	SCTM	A barrel category code defined by the user in 31B/R1.
szBarrelCategoryCode2_SDRM		O	SDRM	A barrel category code defined by the user in 31B/R2.
szBarrelCategoryCode3_SBDM		O	SBDM	A barrel category code defined by the user in 31B/R3.
szBarrelCategoryCode4_SDRL		O	SDRL	A barrel category code defined by the user in 31B/R4.
szBarrelCategoryCode5_INFO		O	INFO	A barrel category code defined by the user in 31B/R5.
mnBarrelNumber_BRLNUM		O,R	BRLNUM	Required when doing an edit to an existing barrel.

O = Optional

R = Required

X = Required, but will default in if not passed

Processing options

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 is still needed when running the interface, as JDE may use it.

Versions tab

Generate barrel style definition (szGenerateStyleVersion_VERS): the value of this field is used as the processing option to specify the version of the Generate Barrel Style Definition (R31B34) that the system uses. If left blank, the program will use the XJDE0001 version.

ERP PPO tab

Using purchase order information from ERP (cPODataFromCRM_EV01): this controls whether the PO uses the ERP or not. A blank value doesn't use the ERP. A value of “1” will use the ERP.

Processing option data structure: DD3N3B01

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

Type	Description	Parameter
String	szGenerateStyleVersion_VERS	Output
Character	cPODataFromCRM_EV01	Output
String	szPOVersion_VERS	Input

Processing

There are two primary activities that can be performed by the dsiBarrelMaster function: Add a new barrel, and Edit an existing barrel. A combination of the cActionCode and cdcLINKActionCode are used to specify which activity will happen.

In order to perform an Add barrel activity, the cdcLINKActionCode needs to be set to an ‘A'. The cActionCode is then used to specify whether the barrel add will be done using PO Receipt, or by generating a report using R31B34.

A cdcLINKActionCode of “C” allows the user to edit an existing Barrel. The cActionCode is not used.

The function dsiBlendSubWriteBarrelMaster is only called from the dsiBarrelMaster, and never called as a standalone.

Action code	dcLINK action code	Description
0	A	Add a barrel without running R31B34.
	C	Edit an existing barrel.
1	A	Add from PO Receipts and run R31B34.
2	A	Add from PO Receipts without running R31B34.
3	A	Add a barrel and run R31B34.

Required fields

There are several options available when using this interface.

For an Add, the interface requires the user to supply the following: action code, dcLINK action code, winery, barrel segment, barrel available code, barrel type, and lease(Y/N).
For an Edit, the following fields are required: dcLINK action code, winery, and barrel number.

Verify the processing

Barrel Master will either add a new barrel, or change an existing barrel. To verify that this occurred, use the EnterpriseOne Barrel Master program, P31B03, on menu G31B02.

To verify that the processing completed successfully, complete the following steps in JDE.

Open the EnterpriseOne Barrel Master program, P31B03.
On the G31B02 menu, inquire on the winery/barrel that was just processed and verify that the data specified was written to the barrel.

Step Information

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.
0003	Blanks Invalid. In this interface, it is used when a required field is left blank.
0052	Business Unit Invalid. This is set when Barrel Segment String is left blank.
451I	Invalid Type. This error occurs when an invalid Barrel Type is entered.
449WIM	Invalid Barrel Type. This error occurs when an invalid Barrel Type is entered.

There was a problem loading this topic

Mobile Enterprise Platform