Customer Master Revisions interface for JD Edwards

About the Customer Master Revisions interface

This interface can be used to inquire upon, add, or edit a Customer Master record.

When the need arises to inquire upon, add, or edit a Customer Master record, this function may be used. In the EnterpriseOne system, the Customer Master application is P03013, which can be accessed from the G03B13 menu. The corresponding dcLINK® interface is ND3N1014 (dcLINK Customer Master Revisions).

This interface is fairly straightforward. It allows the user to add, edit, or inquire upon a Customer Master record.

Objects

Name	Function name	Description
DD3N0301		PO Retrieval - Customer Master
BD3N0301	PORetrievalCustomerMaster	PO Retrieval - Customer Master
DD3N0302		PO Retrieval - Customer Master MBF
BD3N0302	PORetrievalCustomerMasterMBF	PO Retrieval - Customer Master MBF
DD3N1014		dcLINK Customer Master Revisions
ND3N1014	dcLINKCustomerMasterRevisions	dcLINK Interface - Customer Master Revisions

The full name of this interface is ND3N1014 Customer Master Revisions

This interface guide applies to the following JDE versions.

EnterpriseOne 9.1

Processing options

This interface requires processing options from two programs.

This interface requires processing options from two programs. The processing options from P03013 include a version of the P0100042 to be used. A version will default to ZJDE0001 if not otherwise specified in the parameter list on the call.

P03013 Processing options

Entry tab

Tax ID (cTaxID_EV01): This is not used in the ND3N1014.

Defaults tab

Search Type (szSearchAddressType1_AT1): The szSearchType_AT1 field will be defaulted from this. It is based on UDC 01/ST.
Amount Currency Code (szCurrencyCodeAmounts_CRCA): This is not used in the ND3N1014.

Versions tab

Customer Master MBF Version (szMBFVersionP0100042_VER): The version specified here will be passed into the szVersion of the N0100042 calls. If it is not specified, it will default ZJDE0001.
Address Book Version (szABVersionP01012_VER): This is not used in the ND3N1014.

Processing option data structure for DD3N0101

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

Type	Description	Parameter
String	po_szVersion_VERS	Input
Char	po_cTaxID_EV01	Output
Char	po_szSearchAddressType1_AT1	Output
String	po_szCurrencyCodeAmounts_CRCA	Output
String	po_szMBFVersionP0100042_VER	Output
String	po_szABVersionP01012_VER	Output

P0100042 Processing options

Outbound tab

Transaction Type (szTransactionType_TYTN): This is not used in the ND3N1014.
Change Transaction Image (cChangeTransImage_BIPROC): This is not used in the ND3N1014.

Defaults tab

Default Category Codes (cDefaultCategoryCodes_EV01): If this is set, the category codes on the customer master will be defaulted from the address book record.

Processing option data structure for DD3N0302

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

Type	Description	Parameter
String	szVersion_VERS	Input
String	szTransactionType_TYTN	Output
Char	cChangeTransImage_BIPROC	Output
Char	cDefaultCategoryCodes_EV01	Output

Processing

The required fields for processing differ based on whether the action is an add, a delete, or a change.

The required fields differ based on whether the action is an add, a delete, or a change. For all transaction types, the cdcLINKActionCode_EV01 and mnCustomerNumber_AN8 are required. If this is a change, then all of the fields will be retrieved from the existing record. Those that are not designated to be wiped out will be kept as they are.

Any field that needs to be blanked out will require the following be passed in.

If a string field that is three or longer needs to be blanked out, pass in a ‘%#%'.
If a string field that is two long needs to be blanked out, pass in a ‘%#'.
If a character field needs to be blanked out, pass in a ‘@'.
If a numeric field needs to be blanked out, pass in a negative number (example, -1).
If a date field needs to be blanked out, pass in ‘01/01/1900'.

Verify the processing

Who's Who (P03013|Work With Customer Master) may be used to verify a dcLINK^® Interface – Customer Master Revisions transaction.

Input data structure

Input data structure for DD3N1010 Contact Revisions.

Name	Default values	R/O	Alias	Notes
cdcLINKActionCode_EV01		R	EV01	dcLINK Action Codes: Values ‘A' (add), ‘C' (change), and ‘I' (inquire) are valid. If no dcLINK Action Code is passed in, it will set an error.
cActionCode_ACTION			ACTION	Not used.
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	Not used.
szProgramId_PID	ND3N1012	X	PID	Generally leave this blank and let it default in.
szVersion_VERS	ZJDE0001		VERS	Not used.
cSuppressErrMsg_EV01			EV01	Not used.
cErrorCode_ERRC			ERRC	Indicates an error condition. Set by program.
szErrorMessageKey_EKEY			EKEY	Holds EnterpriseOne error message number.
iDebugLevel_INT01		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 it will cause synchronous dialogs on the computer to pop up when the function is called.
mnCustomerNumber_AN8		C	AN8	Required if using an action code of ‘C' or ‘I', unless the szMobileAddressBookNumber_DS50 field is being used.
szAlphaName_ALPH		R	ALPH	Required if using an action code of ‘A'.
szLongAddressNumber_ALKY		O	ALKY	This will not pass in.
szCompany_CO		O	CO
szPaymentTermsAR_TRAR		O	TRAR
cPaymentInstrument_RYIN		O	RYIN	UDC 00/PY.
mnAlternatePayor_ARPY		O	ARPY	From the address book master.
mnParentNumber_PA8		O	PA8	From the address book master.
cAutoReceiptYN_ATCS		O	ATCS	Valid is ‘Y' or ‘N'.
szCurrencyCode_CRCD		O	CRCD
szABAmountCodes_CRCA		O	CRCA
cHoldInvoices_HDAR		O	HDAR	Valid is ‘Y' or ‘N'.
cSendInvoiceTo_SITO		O	SITO	UDC H00/SI.
szAutoReceiptsExecuteList_ARL		O	ARL
mnMinCashReceiptPercent_PWPCP		O	PWPCP
mnCreditLimit_ACL		O	ACL
szCreditManager_CMGR		O	CMGR	UDC 01/CR.
szCreditMessage_CM		O	CM	UDC 00/CM.
szTempCreditMessage_TSTA		O	TSTA	UDC 00/CM.
szPersonOpeningAcct_POPN		O	POPN
szLastReviewedBy_PLCR		O	PLCR
jdFinancialStmtsOnHand_FNDJ		O	FNDJ
jdDunAndBradstreetDate_DNBJ		O	DNBJ
szDunAndBradstreetRating_DB		O	DB	UDC 01/DB.
jdExperianDate_TWDJ		O	TWDJ
szExperianTRWNumber_TRW		O	TRW	UDC 01/TR.
jdRecallForReviewDate_RVDJ		O	RVDJ
jdDateOfLastCreditReview_DLC		O	DLC
jdDateAccountOpened_DAOJ		O	DAOJ
cABCCodeMargin_ABC2		O	ABC2	UDC H01/A1.
cABCCodeAverageDays_ABC3		O	ABC3	UDC H01/A2.
cABCCodeSales_ABC1		O	ABC1	UDC H01/A3.
szCollectionManager_CLMG		O	CLMG	UDC 01/CM.
szPolicyName_PLYN		O	PLYN
szDeductionManager_ALKY		O	ALKY	From the address book master.
szStandardPolicy_CO		O	CO
cSendStatement_STTO		O	STTO	UDC H00/SV.
szStatementCycle_CYCN		O	CYCN
cCollectionReport_COLL		O	COLL	Valid values are ‘Y' or ‘N'.
cPrintStatement_STMT		O	STMT	Valid values are ‘Y' or ‘N'.
cDelinquencyFees_AFC		O	AFC	Valid values are ‘Y' or ‘N'.
cDelinquencyNotices_DNLT		O	DNLT	Valid values are ‘Y' or ‘N'.
szGLOffset_ARC		O	ARC
szModelJEDocType_DTAR		O	DTAR	UDC 00/DT.
mnModelJENumber_DCAR		O	DCAR
szModelJECompany_KCOR		O	KCOR
szAccountNumber_ANI		O	ANI
szTaxExplanationCode_EXR1		O	EXR1	UDC 00/EX.
szTaxRateArea_TXA1		O	TXA1
cPersonCorporationCode_TAXC		O	TAXC	UDC H00/TA.
szTaxId_TAX		O	TAX
szAdditionalIndTaxID_TX2		O	TX2
szShippingLabelProgram_SLPG		O	SLPG
szPickPackConfig_CFPP		O	CFPP
szStdCartonPackConfig_CFSP		O	CFSP
szShippingLabelVersion_SLDW		O	SLDW
cDefaultConfiguration_CFDF		O	CFDF	Valid values are ‘0', ‘1', or ‘2'.
cPackagingCode_RQ01		O	RQ01	Valid values are ‘1' or blank.
cTransportationMethod_RQ05		O	RQ05	Valid values are ‘1' or blank.
cRequiresEquipment_RQ07		O	RQ07	Valid values are ‘1' or blank
cWeight_RQ02		O	RQ02	Valid values are ‘1' or blank.
cRouting_RQ06		O	RQ06	Valid values are ‘1' or blank.
cIdentificationCode2_RQ04		O	RQ04	Valid values are ‘1' or blank.
cIdentificationCode1_RQ03		O	RQ03	Valid values are ‘1' or blank.
cReferenceNumber1_RQ08		O	RQ08	Valid values are ‘1' or blank.
cReferenceNumber2_RQ09		O	RQ09	Valid values are ‘1' or blank.
szDefaultIDCode1_DR03		O	DR03	UDC 41/X3.
szDefaultIDCode2_DR04		O	DR04	UDC 41/X3.
szDefaultReferenceQual_DR08		O	DR08	UDC 41/X6.
szDefaultIDQualifier_DR09		O	DR09	UDC 41/X6.
cBatchProcessingMode_EDPM		O	EDPM	UDC H40/EE.
cCustomerTypeIdentifier_EDCI		O	EDCI	UDC 40/CI.
cItemTypeIdentifier_EDII		O	EDII	UDC 40/II.
mnAmountDecimals_EDAD		O	EDAD
mnQuantityDecimals_EDQD		O	EDQD
cMethod_CRMD		O	CRMD	UDC 00/SM.
szCategoryCode01_AC01		O	AC01	UDC 01/01.
szCategoryCode02_AC02		O	AC02	UDC 01/02.
szCategoryCode03_AC03		O	AC03	UDC 01/03.
szGeographicRegion_AC04		O	AC04	UDC 01/04.
szCategoryCode05_AC05		O	AC05	UDC 01/05.
szCategoryCode06_AC06		O	AC06	UDC 01/06.
szCategoryCode07_AC07		O	AC07	UDC 01/07.
szCategoryCode08_AC08		O	AC08	UDC 01/08.
szCategoryCode09_AC09		O	AC09	UDC 01/09.
szCategoryCode10_AC10		O	AC10	UDC 01/10.
szCategoryCode11_AC11		O	AC11	UDC 01/W1.
szCategoryCode12_AC12		O	AC12	UDC 01/W2.
szCategoryCode13_AC13		O	AC13	UDC 01/W3.
szCategoryCode14_AC14		O	AC14	UDC 01/W4.
szCategoryCode15_AC15		O	AC15	UDC 01/W5.
szCategoryCode16_AC16		O	AC16	UDC 01/W6.
szCategoryCode17_AC17		O	AC17	UDC 01/W7.
szCategoryCode18_AC18		O	AC18	UDC 01/W8.
szCategoryCode19_AC19		O	AC19	UDC 01/W9.
szCategoryCode20_AC20		O	AC20	UDC 01/WT.
szCategoryCode21_AC21		O	AC21	UDC 01/N1.
szCategoryCode22_AC22		O	AC22	UDC 01/N2.
szCategoryCode23_AC23		O	AC23	UDC 01/N3.
szCategoryCode24_AC24		O	AC24	UDC 01/N4.
szCategoryCode25_AC25		O	AC25	UDC 01/N5.
szCategoryCode26_AC26		O	AC26	UDC 01/N6.
szCategoryCode27_AC27		O	AC27	UDC 01/N7.
szCategoryCode28_AC28		O	AC28	UDC 01/N8.
szCategoryCode29_AC29		O	AC29	UDC 01/N9.
szCategoryCode30_AC30		O	AC30	UDC 01/NA.
cBillingAddressType_BADT		O	BADT	UDC H42/BA.
mnRelatedAddressNumber_N8RE1		O	N8RE1	UDC 40/RA.
szAdjustmentSchedule_ASN		O	ASN	UDC 40/AS.
szCustomerPriceGroup_CPGP		O	CPGP	UDC 40/PC.
mnMinimumOrderValue_MINO		O	MINO
mnMaximumOrderValue_MAXO		O	MAXO
szPrintMessage_INMG		O	INMG	UDC 40/PM.
szOrderTemplate_ORTP		O	ORTP	UDC 40/OT.
cCreditCheckLevel_ARTO		O	ARTO	UDC H42/AR.
cItemRestrictions_EDF2		O	EDF2	UDC H40/ED.
mnTradeDiscount_TRDC		O	TRDC
szDeliveryInstructLine1_DEL1		O	DEL1
szDeliveryInstructLine2_DEL2		O	DEL2
szBuyingSegmentCode_BSC		O	BSC	UDC 42B/BS.
cCustomerPORequiredYN_PORQ		O	PORQ	Valid values are ‘Y' or ‘N'.
cExemptFromCreditHold_EXHD		O	EXHD	Valid values are ‘Y' or ‘N'.
cDeliveryNote_EDF1		O	EDF1	Valid values are ‘Y' or ‘N'.
cInvoiceConsolidation_ICON		O	ICON	Valid values are ‘Y' or ‘N'.
cBackordersAllowed_BACK		O	BACK	Valid values are ‘Y' or ‘N'.
cSubstitutesAllowed_SBAL		O	SBAL	Valid values are ‘Y' or ‘N'.
cPartialShipmentsAllowed_APTS		O	APTS	Valid values are ‘Y' or ‘N'.
cPartOrderShipmentsAllow_APTS		O	APTS	Valid values are ‘Y' or ‘N'.
cPricePickList_PLST		O	PLST	Valid values are ‘Y' or ‘N'.
cApplyFreight_AFT		O	AFT	Valid values are ‘Y' or ‘N'.
cCertOfAnalysisPrint_SI02		O	SI02	Valid values are ‘Y' or ‘N'.
cBypassAuditLogging_BYAL		O	BYAL	Valid values are ‘0' or ‘1'.
cCustomerStatus_CUSTS		O	CUSTS	Valid values are ‘0' or ‘1'.
mnInvoiceCopies_INVC		O	INVC
szHoldOrdersCode_HOLD		O	HOLD	UDC 42/HC.
cPriorityProcessingCode_PRIO		O	PRIO	UDC H40/PR.
szWeightDisplayUM_WUMD		O	WUMD	UDC 00/UM.
szVolumeDisplayUM_VUMD		O	VUMD	UDC 00/UM.
szFreightHandlingCode_FRTH		O	FRTH	UDC 42/FR.
szZoneNumber_ZON		O	ZON	UDC 40/ZN.
mnCarrier_CARS		O	CARS	From the address book master.
cAdjustmentOnInvoice_DSPA		O	DSPA	Valid values are ‘Y' or ‘N'.
szRouteCode_ROUT		O	ROUT	UDC 40/RT.
szStopCode_STOP		O	STOP	UDC 42/SP.
szOPBusinessObjective_OPBO		O	OPBO	UDC 34A/BO.
szMobileAddressBookNumber_DS50		O	DS50	Used for MOBILEApps processing.
Globally Unique Identifier (GUID) Fields	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.

R = Required

O = Optional

X = Required but will default in if not passed

C = Conditional (see notes for conditions)

There was a problem loading this topic

Mobile Enterprise Platform