TranPrint Build Record Sequences interface for JD Edwards

About the TranPrint Build Record Sequences interface

The TranPrint Build Record Sequences business function gives the user the ability to send formatted records to the FD3N901 TranPrint Transaction Table.

The BD3N912 TranPrint Build Record Sequences Business Function gives the user the ability to send formatted records to the FD3N901 TranPrint Transaction Table.

The FD3N901 TranPrint Transaction Table is used for Label printing. This business function was written in C. It uses the DD3N912 data structure.

Name	Function name	Description
BD3N912	BuildRecordSequence	TranPrint Build Record Sequences BSFN
BD3N912	BuildRecordSequence	TranPrint Build Record Sequences Data Structure

The full name of this interface is BD3N912 TranPrint Build Record Sequences

This interface guide applies to the following JDE versions.

EnterpriseOne Xe

Processing options

This Business Function does not use processing options.

Processing

This business function concatenates all of the Field Names and Data Values together with the appropriate delimiters.

This business function concatenates all of the Field Names and Data Values together with the appropriate delimiters. Although the resulting string may be several hundred characters long, the LPUFD1 Unformatted Data field must be less than 250 characters. The business function breaks the string into separate sections that are less than 250 characters, and writes them out as separate records. It handles the proper advancement of the LPTNID Sequence Number field.

The BD3N912 TranPrint Build Record Sequences business function will allow up to 25 fields and values to be passed with each call. If more than 25 fields are needed, then the business function will need to be called multiple times until all of the required label data is provided.

The required fields include the Device Date and Time (szDateTimeFromDevice_DVDT), the Label Format (szFormatName_FMAT), and Device Name (szDeviceName_DVNM).The defaulted fields are:

Printer Number (mnPrinterNumber_PFN0) = 1
Label Copies (mnBlockCount_BLCT) = 1
dcLINK Action Code (szdcLINKActionCode_EV01) = 0
Starting Sequence Number (szStartingSeq_TNID) = 0

The business function does not retrieve Error Messages if the Program ID (szProgramId_PID) = ‘ND3N901'.

dcLINK action codes

dcLINKActionCode_EV01 = 0(Default): This will combine the fields and values into as many records as it will take to keep the LPUFD1 string under 250 characters. The characters over 250 are written to the next records LPUFD1 field until all of the fields and values are written. The business function will handle creating the LPTNID values in ascending numerical order. The last record will have a LPTNID field of ‘L”.
dcLINKActionCode_EV01 = 1: This option is a single record update. User must provide all validation before the business function is called. The business function will combine the fields and values up to 250 characters. Any characters beyond the 250 will be truncated. One record is written using the LPTNID provided. If subsequent calls are needed to include all of the fields and values for a label, the user will need to handle incrementing the Sequence Numbers (LPTNID) for each record. The last record must have a LPTNID value of ‘L'. All of the label records from ‘001' to ‘L' must have the same unique Device Date and Time (LPDVDT), Label Format (LPFMAT), Device Name (LPDVNM), Printer Number (LPPFN0), Label Copies (LPBLCT), and Cost Center (LPMMCU). The Sequence Numbers (LPTNID) would only be ‘0' (zero) if one record is all that is required to for a label.
dcLINKActionCode_EV01 = 2: This option is the same as dcLINKActionCode_EV01 = 0, except that it does not send the “L” value on the last record. When the quantity of fields and values exceeds 25, the business function must be called multiple times. This option would be used on all but the last call to the business function. The business function returns a suggested Starting Sequence Number (szStartingSeq_TNID). Reuse this value as the Starting Sequence Number (szStartingSeq_TNID) with the next call to the business function. All the label records must have the same unique Device Date and Time (LPDVDT), Label Format (LPFMAT), Device Name (LPDVNM), Printer Number (LPPFN0), Label Copies (LPBLCT), and Cost Center (LPMMCU).

Verify the processing

Use the FD3N901 TranPrint Transaction to verify that the requested data has been written to the table.

To verify the processing, complete the following steps.

Stop processing in TranPrint.
Open the FD3N901 TransPrint Transaction Table and examine the first group of records with the same Device Date and Time (LPDVDT) values. Verify that they have the same Device Name (LDPVNM). These records define a label to be printed.
Step Information
If there is more than one record used to create a label, the Sequence Number (LPTNID) should start with “001” and ascend sequentially. There must be a “001” and there must be an “L”. There cannot be any skipped Sequence Numbers. If there are more than 10 records in a group making up a label, then the sequence numbers must be left padded with zeros. The LPTNID is a character field and does a character sort, rather than a numeric sort. (E.g. ‘1', ‘11', ‘2', ‘3'…) vs. (E.g. ‘001', ‘002', ‘003'…'011')

If there is only one record needed to create the label, the Sequence number (LPTNID) must be zero.

To check that the parsing and delimiter rules have been followed, look at the LPUFD1 field. The field names are preceded by a ‘~', and the data values are preceded by a ‘!'. If a concatenated string must be split up to fit the 250-character limit, it must be split after a data value and before a new field name. Remember that the field names are case sensitive, and any values that contain commas must be enclosed in quotes.
Open the Loftware Label Design application and test print to the targeted label printer.
Activate TranPrint and examine the label.

Step Information

To learn more about TranPrint, refer to the TranPrint Setup Guide.

Input data structure

Input data structure DD3N912

Name	Default value	R/O	Alias	Notes
cdcLINKActionCode_EV01	0	X	EV01	dcLINK Action Codes: Value 0 is the only code used in this NER.
cActionCode_ACTION			ACTION
jdDateUpdated_UPMJ	(today)	X	upmj	Returned from GetAuditInfo if not passed in.
mnTimeUpdated_TDAY	(now)	X	tday	Returned from GetAuditInfo if not passed in
szUserId_USER	(current user id)	X	user	Returned from GetAuditInfo if not passed in
szWorkStationId_JOBN	(current workstation id)	X	jobn	Returned from GetAuditInfo if not passed in
mnJobNumber_JOBS			jobs	Generated within NER.
SzProgramId_PID	BD3N912	X	pid	Generally leave this blank and let it default in.
szVersion_VERS	ZJDE0001	X	vers	This is used by the function to look up the appropriate set of processing options.
cSuppressErrMsg_EV01		O	ev01
cErrorCode_ERRC			errc	Indicates an error condition. Set by program.
szErrorMessageKey_EKEY			ekey	Holds JDE error message number.
iDebugLevel_INT01	0	O	int01	Leave blank except for debugging and testing purposes only. Higher numbers will show more debug dialog boxes. Leaving this blank, or setting to 0, suppresses all debug dialog boxes. Do not leave a value greater than 0 in this field after initial setup and testing, as this will cause synchronous dialogs on the computer to pop up when the function is called.
szDateTimeFromDevice_DVDT		R	DVDT	Device Date and Time.
szFormatName_FMAT		R	FMAT	Label Format.
mnPrinterNumber_PFN0	1	X	PFN0	Printer Number.
szInputData_UFD1	-blank-	O	UFD1	String of formatted data.
mnBlockCount_BLCT	1	X	BLCT	Quantity, Copies of Label.
szSequence_TNID	“0”	X	TNID	Sequence Number ‘001', ‘002', etc.
szDeviceName_DVNM		R	DVNM	Device Name.
szCostCenterAlt_MMCU	-blank-	O	MMCU	Branch Plant or other unique Identifier.
szStartingSeq_TNID	“0”	O	TNID	Starting sequence.
szEndingSeq_TNID	“L”	O	TNID	Ending sequence number returned.
mnRandomNumber_FST1	0	O	FST1	(Future use).
szFieldName01	-blank-	O	GS2A	First Label Field Name.
szDataValue01	-blank-	O	GS5A	First Label Field Value.
szFieldName02	-blank-	O	GS2A	Second Label Field Name.
szDataValue02	-blank-	O	GS5A	Second Label Field Value.
(szFieldName + Next Number)	-blank-	O	GS2A	(Next Increment Label Field Name up to 25).
(szDataValue + Next Number)	-blank-	O	GS5A	(Next Increment Label Field Value up to 25).
szFieldName25	-blank-	O	GS2A	25^th Label Field Name.
szDataValue25	-blank-	O	GS5A	25^th Label Field Value.

R = Required

X = Required but will default in if not passed

O = Optional

There was a problem loading this topic

Mobile Enterprise Platform