send feedback

❮ Previous Next ❯

Blend Movement interface for JD Edwards

About the Blend Movement interface

This is an API that allows Advanced Inventory to perform four operations: T2B (Tank to Barrel), B2T (Barrel to Tank), T2T (Tank to Tank) and TOPT2B (Top Barrel from Tank) in JDEdwards Blend Management.

This functionality exists in P31B87 Create/Edit Operations. This will allow you to Add and Modify the Operations. It will also allow Add/Empty/Delete, and Update Barrels by calling internally another function to perform this functionality.

This interface was written in NER and calls a “C” business function BD3N3B06 and BD3N3B04 to retrieve the processing options.

Name	Function name	Description
DD3N3B06		PO Retrieval: Blend Operation Header
BD3N3B06	PORetrievalBlendOperation Header	PO Retrieval: Blend Operation Header
DD3N3B04		PO Retrieval: Blend Edit Operation
BD3N3B04	PORetrievalBlendEditOperation	PO Retrieval: Blend Edit Operation
DD3N3B6A		Advanced Inventory Interface: Blend Movement transaction
ND3N3B6A	dsiBlendMovement	Advanced Inventory Interface: Blend Movement transaction

The full name of this interface is ND3N3B6A Blend Movement

This interface guide applies to the following JDE versions.

EnterpriseOne 9.1

Corresponding EnterpriseOne application

In EnterpriseOne, from menu B31B03, Operation Search P31B94, select Add Blend Operation or Find. Select a record and select Edit Operation to go to P31B69 Operation Header Parent Powerform, which is discussed in another IUG. From the Operation Header, select Continue to go to P31B87 Operation Detail.

Depending on the base operation code, and whether the Operation Header has been saved, closed and then selected after the save, the P31B87 may return one of a variety of displays. The typical display seen, for instance when a T2T operation is created or viewed, will include a From Vessel section with a To Vessel section, a Movement Detail tab with Calculate Move button (additional buttons if T2B or other VBT operations are selected), and tabs for Resources, Equipment and Consumables.

In addition, below the tab selection section, Save, Cancel, and other buttons display. Of these, at least two are NOT a part of in this Blend Movement IUG: Instruct Lot Attributes and Validate Spec.

Processing options

In this interface, the processing option does not have much of a role in processing the transaction.

The processing options for P31B94 Operation Search include three tabs: Default, Display, and Versions. Default options and Display processing options will typically be left blank. Versions options include the program versions that are called.

9, Operation Header Parent Form (P31B69) and 10, Create/Edit Operation Detail (P31B87) version entries are of special significance in establishing workings of the related business functions.

Processing option data structure: DD3N3B06

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

Type	Description	Parameter
String	szPOVerison_VERS	Input
String	szDefaultWorkFlowStatus_WSD2	Output
Character	cRunCalculateWOStatus_EV01	Output
Character	cReScheduleOperationsFlag_Ev01	Output
String	szCreateEditOpDetail_VERS	Output
String	szCalculateWOStatus_VER1	Output

Processing option data structure: DD3N3B04

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

Type	Description	Parameter
String	szPOVerison_VERS	Input
String	cRunCalculateWOStatus_EV01	Output
Character	cSimpleVesselEntry_EV01	Output
Character	cRunGenerateBarrelStyle_EV01	Output
Character	cOperationHeaderDisplay_EV01	Output
Character	cSubformRegion2Display_EV01	Output
Character	cSubformRegion3Display_EV01	Output
String	szCalculateWOStatusVers_VER1	Output
String	szBillOfLadingVersion_VERS	Output
String	szBottlingVesselVersion_VERS	Output
String	szGenBarrelStyleDefVers_VERS	Output
String	szInvByVesselViewVers_VERS	Output
String	szTankMasterVersion_VERS	Output
String	szWeightagDetailVers_VERS	Output

Processing

This interface can be used to add operations and revise the listed movement operations.

Revisions can be made to the Operation Header, Operation Details, Movement Details, Resources, Equipment, and Consumables. A review of the individual input parameters identifies specifically what fields may be added and/or revised. Refer to the Special Processing Interface Usage Guide for more information.

Verify the processing

Verify the processing by viewing the details of the Operation Header and related details.

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

In EnterpriseOne, from the menu G31B03, select Operation Search P31B94 to view the Operation Header.
Select Continue to view the related details including the From Vessel grid (VBT), Movement Detail, Resources, Equipment, and Consumables.

Input data structure

Input data structure for Blend Movement DD3N4220.

Name	Default values	R/O	Alias	Notes
szConfgOperShortHDR_WCOPCD		R	WCOPCD	Enter configured operation code to determine what base operation interface would perform.
szWorkflowStatusHDR_WSD		R	WSD	Enter Operation Status.
szBlendMgmtRefeHDR_WRF		O	WRF
szWineryHDR_MCU		R	MCU	Enter Winery.
szCreatorHDR_ALKY		R	ALKY	Enter Creator.
udInstrtedStartDtHDR_WSDT		O	WSDT
udInstrtedEndDtHDR_WEDT		O	WEDT
mnDurationHDR_WDUR		O	WDUR
udActuStartDtHDR_WASDT		O	WASDT
udWIMActEndDtHDR_WAEDT		O	WAEDT
mnWIMActualDurationHDR_WADUR		O	WADUR
cTimeUOMHDR_WUOMT		O	WUOMT
cInstructionMethdHDR_INSTMET		O	INSTMET	Enter Instruction Method. 1 = From After 2 - From Move 3 = To After 4 = To Move
cDistributionMethdHDR_DISTMET		O	DISTMET	Enter Distribution Method. 1 = Equal 2 = To Vessel Capacity 3 = Percentage 4 = Move to Capacity 5 = Blend to Capacity
cPerformAfterMeasuHDR_WPAD		O	WPAD	Enter Perform After Measure. 0 = Do Not Measure 1 = Final Measure 2 = Intermediate Measure
cPerfrmSurveyMeasuHDR_WPSD		O	WPSD
cShowPlannMeasuHDR_WSBDV		O	WSBDV
szOperaCatCode2HDR_WH2		O	WH2	Enter Operation Category Code 2, UDC value.
szOperaCatCode3HDR_WH3		O	WH3	Enter Operation Category Code 3, UDC value.
szOperaCatCode4HDR_WH4		O	WH4	Enter Operation Category Code 4, UDC value.
szOperaCatCode5HDR_WH5		O	WH5	Enter Operation Category Code 5, UDC value.
szAltOperationNumHDR_WALOP		O	WALOP
szWorkOrderReferNumHDR_WAWOR		O	WAWOR
szCompMatTypeHDR_CMATYPE		O	CMATYPE
szVesselNumberFrm_WVNUM		R	WVNUM	Enter Valid From Vessel/Tank number.
szVesselTypeFrm_WSVT		O	WSVT
mnInstructedAfterQtyFrm_WIAV		O	WIAV	Can be entered while creating new operation.
szInstructedAltQtyFrm_WDFI		O	WDFI
nVesselSequenceNoFrm_WVSEQ		R	WVSEQ	Enter valid sequence number of From Vessel/Tank number.
szVesselLocationFrm_WVLOCN		O	WVLOCN	Defaulted by interface if not passed in.
cMeasureTypeFrm_TDPT		O	TDPT	Defaulted by interface if not passed in.
cGenerateVBTTo_EV01		C	EV01	Enter “1” to create new VBT while creating new operations.
szTankNumberTo_WVNUM		R	WVNUM	Enter To Vessel/Tank number.
szTankTypeTo_BATP		O	BATP	Defaulted by interface if not passed in.
nVesselSeqNoTo_WVSEQ		R	WVSEQ	Enter valid sequence number of To Vessel/Tank.
szTankLocationTo_WVLOCN		O	WVLOCN	Defaulted by interface if not passed in.
cMeasureTypeTo_TDPT		O	TDPT	Defaulted by interface if not passed in.
szVBTTypeTo_WSVT		O	WSVT	Defaulted by interface if not passed in.
mnPlannedMoveQtyMOV_WPLVLMV		O	WPLVLMV
mnActualMoveQtyMOV_WACTVLMV		O	WACTVLMV
szQuantityUOMMOV_WVUM		O	WVUM
szWorkGroupCode_WGID		O	WGID	This is required for Resource tab entry.
mnStaffNumber_SFNB		O	SFNB	This is required for Resource tab entry.
mnActualTime_WACTIME		O	WACTIME	This is required for Resource tab entry.
cTimeUOMResource_WUOMT		O	WUOMT	This is required for Resource tab entry.
szEquipmentNumEQP_EQPNUM		O	EQPNUM	This is required for Equipment tab entry.
szWineryEQP_MCU		O	MCU	This is required for Equipment tab entry.
mnActualTimeEQP_WACTIME		O	WACTIME	This is required for Equipment tab entry.
szTimeUnitOfMeasure_WTUOM		O	WTUOM	This is required for Equipment tab entry.
szEquipParameterText_EQPPT		O	EQPPT	This is required for Equipment tab entry.
szItemNoUnknownFormat_UITM		O	UITM	This is required for Consumables tab entry.
szWineryConsum_MCU		O	MCU	This is required for Consumables tab entry.
szLocationConsum_LOCN		O	LOCN	This is required for Consumables tab entry.
szLotConsum_LOTN		O	LOTN	This is required for Consumables tab entry.
mnEquipConsQuantity_ECQTY		O	ECQTY	This is required for Consumables tab entry.
szUnitOfMeasPrimConsm_UOM1		O	UOM1	This is required for Consumables tab entry.
mnIdentifShortItemConsm_ITM		O	ITM
cdsiActionCode_EV01		O	EV01	“A” = Add Operation “C” = Edit Operation
cActionCode_ACTION		O	ACTION	“A” = Add record in Resource, Equipment or Consumable tab.
jdDateUpdated_UPMJ		O	UPMJ	Retrieved from GetAuditInfo.
mnTimeUpdated_TDAY		O	TDAY	Retrieved from GetAuditInfo.
szUserId_USER		O	USER	Retrieved from GetAuditInfo.
szWorkStationId_JOBN		O	JOBN	Retrieved from GetAuditInfo.
mnJobNumber_JOBS		O	JOBS	Internally created.
szProgramId_PID	ND3N3B6A	O	PID	Defaulted in program if not passed in.
szVersion_VERS	ZJDE0001	O	VERS	Defaulted in program if not passed in.
cSuppressErrMsg_EV01		O	EV01	Defaulted in program.
cErrorCode_ERRC		O	ERRC	Defaulted in program if needed.
szErrorMessageKey_EKEY		O	EKEY	Defaulted in program if needed.
iDebugLevel_INT01		O	INT01	Use “99” to generate the debug log file in JDE Enterprise Server.
szGuidUniqueID_GUID		O	GUID	GUID values are all optional unless a business must comply with FDA 21 CFR Part 11 auditing requirements. Refer to Special Processing Interface Usage Guide for GUID input data structure details.
szGuidApprover1_USR1		O	USR1
szGuidFullName1_FULLNAME1		O	FULLNAME1
szGuidApprover2_USR2		O	USR2
szGuidFullName2_FULLNAME2		O	FULLNAME2
mnGuidReasonCode1_REASON1		O	REASON1
szGuidCommentField_COMMENTS		O	COMMENTS
mnGuidReasonCode2_REASON2		O	REASON2
szGuidCommentField2_2COMMENTS		O	2COMMENTS
szGuidScriptID_FMNMVERS		O	FMNMVERS
szGuidTextMessage_TEXTMES		O	TEXTMES
nOperationID_WOPID		C	WOPID	For a new operation this ID will create by interface, and for Edit operation, by user needs to pass this operation ID.
szErrorMessgeCode_DTAI		O	DTAI	Defaulted in program when needed.
mnOperationNumber_WOPN		C	WOPN	For new operation this ID will create by interface, and for edit operation, by user needs to pass this operation ID.
mnInstructedMoveQtyFrm_WIMV		O	WIMV
mnInstructedMoveQtyTo_WIMV		O	WIMV
mnInstructedAfterQtyTo_WIAV		O	WIAV
szDipFeetInchesTo_WDFI		O	WDFI
mnInsttedAlterQtyFrm_WIAD		O	WIAD
mnInsttedAlterQtyTo_WIAD		O	WIAD
cFAVolumeUsed_WAF		C	WAF	Enter “1” to change the From After Actual Volume Amount.
mnFAActualVolume_WACTVLMV		C	WACTVLMV	When “1” is entered in cFAVolumeUsed_WAF then this field should have value.
cTAVolumeUsed_WAF		C	WAF	Enter “1” for change the To After Actual Volume Amount.
mnTAActualVolume_WACTVLMV		C	WACTVLMV	When enter “1” in cTAVolumeUsed_WAF then this field should have value.
cAddOrRemoveBarrel_EV01		C	EV01	“A” = Add barrel to existing operation. “E” = Empty barrel to existing operation. “D” = Delete barrel from existing operation. “U” = Update location and rack Number for T2B and TOPT2B operation.
mnBarrelNumber_BRLNUM		C	BRLNUM	Enter barrel number based on AddOrRemove barrel flag.
szBarrelID_BARID		O	BARID
szBarrelLocation_LOCN		C	LOCN	If AddOrRemove barrel flag equals to “U” then enter barrel location here.
szRackNumberBrl_RKNMR		C	RKNMR	If AddOrRemove barrel flag equals to “U” then enter rack number here.

R = Required (shaded in blue for quick reference)

O = Optional

X = Required but will default in if not passed

C = Conditional (see explanation for conditions)

To remove previously entered data from a field, use these input values(applicable for Operation Header).

To remove a string 3 characters or longer: %#%
To remove a numeric field value: -1
To remove a date field input: 01/01/1900

Additional information

Notes on JDE Blend Movement ND3N3B6A.

Action code usage

Action codes are very important in this interface.

For cdsiActionCode: “A” is used to add a new operation, and “C” is used to edit the existing operation.
For cActionCode: “A” is used to add a new record for the Resource, Consumables, and Equipment tab.
For cAddOrRemoveBarrel: “A” is used to add a barrel, “E” is used for an empty barrel, “D” is used to delete a barrel from the existing operation, "U" is used for updating the barrel Location or Rack Number.

Sequence number

Sequence numbers are very important for processing this transaction flawlessly. The user must pass correct From and To sequence numbers for this transaction.

Typical process flow

A typical process flow should start with the Operation ID and Operation Number, and call the dsiBlendSubOperationHeader function to load the header cache. The header cache should be kept in an open state to perform the rest of the transaction.

The process will then return to the dsiBlendMovement function and load the From Vessel and To Vessel records in the cache.

When these tasks are complete, the process will check if the Barrel related flag is on (ADD/EMPTY/DELETE, or Update). If so, then the process will call the dsiAddBarrelToVBT function and return to the dsiBlendMovement function.

The process will then call the dsiBlendSubEquipResourceConsum function, perform the required transaction, and return to the parent function dsiblendMovement.

The process will then execute the Save and Close functionality.

The user should then ADD/EMPTY/DELETE the barrel from the existing blend operation. This interface can be used for barrel scanning solutions from Advanced Inventory. The following related JDE tables will be affected:

F31B70
F31B72
F31B71
F31B101
F31B03

Example

The following parameters are required for the Add new operation for T2T, B2T, T2B, and TOPT2B. Required field parameters are shown in bold. If VBT generation is required for T2B, pass the value "1" in the parameter cGenerateVBTTo_EV01.

szConfgOperShortHDR_WCOPCD = T2B
szWorkflowStatusHDR_WSD = ACTIV
szWineryHDR_MCU = W10
szCreatorHDR_ALKY = 2207072
cInstructionMethdHDR_INSTMET = 1
cDistributionMethdHDR_DISTMET = 1
cPerformAfterMeasuHDR_WPAD = 2
cPerfrmSurveyMeasuHDR_WPSD = 1
cShowPlannMeasuHDR_WSBDV = 1
szVesselNumberFrm_WVNUM = KR-98 (example number - use your own number)
szVesselTypeFrm_WSVT = STO
mnInstructedAfterQtyFrm_WIAV = 170
cGenerateVBTTo_EV01
nVesselSequenceNoFrm_WVSEQ = 15
szVesselLocationFrm_WVLOCN = WH1
cMeasureTypeFrm_TDPT = W
szTankNumberTo_WVNUM = VBT-14-00000528 (example number - use your own number)
szTankTypeTo_BATP = ORE
nVesselSeqNoTo_WVSEQ = 15
cdsiActionCode_EV01 = A

The following parameters are required for the Edit operation for T2T, B2T, T2B, and TOPT2B. Required field parameters are shown in bold. If From After Volume or To After Volume need to be edited, the cFAVolumeUsed_WAF or cTAVolumeUsed_WAF parameter needs to be passed a value of "1".

szConfgOperShortHDR_WCOPCD = T2B
szWorkflowStatusHDR_WSD
szWineryHDR_MCU = W10
szCreatorHDR_ALKY = 2207072
cInstructionMethdHDR_INSTMET = 1
cDistributionMethdHDR_DISTMET = 1
cPerformAfterMeasuHDR_WPAD = 2
cPerfrmSurveyMeasuHDR_WPSD = 1
cShowPlannMeasuHDR_WSBDV = 1
szVesselNumberFrm_WVNUM = KR-98
szVesselTypeFrm_WSVT = STO
mnInstructedAfterQtyFrm_WIAV = 170
nVesselSequenceNoFrm_WVSEQ = 15
szVesselLocationFrm_WVLOCN = WH1
cMeasureTypeFrm_TDPT = W
szTankNumberTo_WVNUM = VBT-14-00000528
szTankTypeTo_BATP = ORE
nVesselSeqNoTo_WVSEQ = 15
cdsiActionCode_EV01 = C
nOperationID_WOPID = 926
mnOperationNumber_WOPN = 1559
cFAVolumeUsed_WAF
mnFAActualVolume_WACTVLMV
cTAVolumeUsed_WAF
mnTAActualVolume_WACTVLMV

The following parameters are required for the ADD/EMPTY/DELETE barrel from the T2B operation. In order to delete a barrel from operations, it must first be Empty.

cAddOrRemoveBarrel_EV01 = A
mnBarrelNumber_BRLNUM = 571
szBarrelLocation_LOCN = CLEAN
szRackNumberBrl_RKNMR = TEST_RACK_1

There was a problem loading this topic

Mobile Enterprise Platform