EffectiveAddressServer

AB Effective Address MBF

Master Business Function

Object Name: N0100059

Parent DLL: CALLBSFN

Location: Client/Server

Language: NER

Business Function Specification

Source NameN0100059DesignerSudip Mitra
Data Structure D0100059ProgrammerSudip Mitra
Function NameEffective Address MBFSystem Code01
Function CategoryBAT
Function Use192

Revisions Log
DateProgrammerSAR NumberDescription
Sudip Mitra2248931Created
Sudip Mitra2248931Modified

1.Functional Description

1.1Purpose
This function is used to Add, Update or Inquire Effective Address in F0116 file. The Action Code is used to determine the mode of the business function
operation.  This function will automatically determine, based on the records in the table if the address needs to be inserted or updated into the F0116 table.
This function is also responsible for the update of Effective date in F0101 table when ever needed.

1.2Setup Notes and Prerequisites

1.3Special Logic

Technical Specifications

Parameters:

NameAliasI/ORequiredTable
Action CodeACTNA (Add), C(Change), or I(Inquire) allowed
Update Master FileEV01 Not used
Process EditsEV01 Not Used
Suppress Error MessageSUPPS  Not Used
Error Msg IDDTA1Not used
VersionVERNot Used
Address NumberAN8Address Number for which the Effective address  is added or changed.
Date Beginning EffectiveEFTBThe date when the Address becomes effective
Address Line 1ADD1Address Line 1
Address Line 2ADD2Address Line 2
Address Line 3ADD3Address Line 3
Address Line 4ADD4Address Line 4
Zip Code PostalADDZZip Code Postal
CityCTY1City
County AddressCOUNCounty Address
StateADDSState
CountryCTRCountry
Program IDPIDProgram ID, only if you want to override. Default is N0100059

2.4Processing










Data Structure
D0100059 - A/B Effective Address MBF

 
Parameter Name Data Item Data Type Req/Opt I/O/Both
mnAddressNumber AN8 MATH_NUMERIC OPT NONE
A number that identifies an entry in the Address Book system, such as employee, applicant, participant, customer, supplier, tenant, or 

location.


jdDateBeginningEffective EFTB JDEDATE OPT NONE
The date that an address, item, transaction, or table record becomes active.  The meaning of this field differs, depending on the program.  

For example, the effective date could represent the following: 



  o When a change of address becomes effective.



  o When a lease becomes 

effective.



  o When a price becomes effective.



  o When the currency exchange rate becomes effective.



  o When a tax rate becomes effective. 




szAddressLine1 ADD1 char OPT NONE
The first line of a mailing address for an employee, customer, or supplier in the Address Book system. The U.S. Internal Revenue Service 

(IRS) restricts the size of the address that prints on an employee's year-end tax return. To comply with IRS regulations, the system has the 

following restrictions:



  o  On W-2 returns, the system prints only the last three nonblank address lines plus the city, state, and postal code.



  o  On 

1099 returns, the system prints only the last nonblank address line plus the city, state, and postal code.



  o  On other U.S. federal magnetic 

media, the system prints only the last nonblank address line plus the city, state, and postal code.


szAddressLine2 ADD2 char OPT NONE
The second line of the mailing address for an employee, customer, or supplier in the Address Book system.



Attention Payroll users: The 

Internal Revenue Service (IRS) restricts the size of the address that prints on employee's year-end forms. To comply with IRS regulations, the 

address that prints on W-2 forms includes only the last three nonblank address lines plus the city, state, and postal code. The address that 

prints on 1099 forms includes only the last nonblank address line plus the city, state, and postal code. If you process year-end information using 

the federal magnetic media format, the address that prints on those forms contains only the last nonblank address line plus the city, state, 

and postal code.
szAddressLine3 ADD3 char OPT NONE
The third line of the mailing address for an employee, customer, or supplier in the Address Book system.



Attention Payroll users: The 

Internal Revenue Service (IRS) restricts the size of the address that prints on employee's year-end forms. To comply with IRS regulations, the 

address that prints on W-2 forms includes only the last three nonblank address lines plus the city, state, and postal code. The address that prints 

on 1099 forms includes only the last nonblank address line plus the city, state, and postal code. If you process year-end information using 

the federal magnetic media format, the address that prints on those forms contains only the last nonblank address line plus the city, state, and 

postal code.
szAddressLine4 ADD4 char OPT NONE
The fourth line of the mailing address for an employee, customer, or supplier in the Address Book system.



Attention Payroll users: The 

Internal Revenue Service (IRS) restricts the size of the address that prints on employee's year-end forms. To comply with IRS regulations, the 

address that prints on W-2 forms includes only the last three nonblank address lines plus the city, state, and postal code. The address that 

prints on 1099 forms includes only the last nonblank address line plus the city, state, and postal code. If you process year-end information using 

the federal magnetic media format, the address that prints on those forms contains only the last nonblank address line plus the city, state, and 

postal code.
szZipCodePostal ADDZ char OPT NONE
The United States ZIP code or the postal code that specifies where a letter is to be routed.  Attach this code to the address for delivery in 

other countries. This code is used as the low end value when doing Postal Code Transaction range processing.
szCity CTY1 char OPT NONE
A name that indicates the city associated with the address.
szCountyAddress COUN char OPT NONE
The name of a county, parish, or other political district that is necessary for the address or for tax purposes.
szState ADDS char OPT NONE
A user defined code (00/S) that specifies the state or province. This code is usually a postal service abbreviation.
szCountry CTR char OPT NONE
A user defined code (00/CN) that identifies a country. The country code has no effect on currency conversion.



The Address Book system 

uses the country code for data selection and address formatting.
szProgramId PID char OPT NONE
The number that identifies the batch or interactive program (batch or interactive object). For example, the number of the Sales Order Entry 

interactive program is P4210, and the number of the Print Invoices batch process report is R42565.



The program ID is a variable length value. 

It is assigned according to a structured syntax in the form TSSXXX, where:



T

The first character of the number is alphabetic and identifies the 

type, such as P for Program, R for Report, and so on. For example, the value P in the number P4210 indicates that the object is a 

program.



SS

The second and third characters of the number are numeric and identify the system code. For example, the value 42 in the number P4210 

indicates that this program belongs to system 42, which is the Sales Order Processing system.



XXX

The remaining characters of the numer are 

numeric and identify a unique program or report. For example, the value 10 in the number P4210 indicates that this is the Sales Order Entry 

program.










cActionCode ACTN char OPT NONE
A code that specifies the action that is performed. Valid values are:



A

Add



C

Change


cUpdateMasterFile EV01 char OPT NONE
An option that specifies the type of processing for an event.


cProcessEdit EV01 char OPT NONE
An option that specifies the type of processing for an event.


cSuppressErrorMessage SUPPS char OPT NONE
A flag indicating whether or not runtime error messaging will occur when an error message is issued from a business function.



       0 = allow 

runtime error message handling.

       1 = suppress runtime error message handling.
szErrorMsgID DTA1 char OPT NONE
A 256 byte field used to hold miscellaneous data.
szVersionconsolidated VER char OPT NONE
Identifies a specific set of data selection and sequencing settings for the application. Versions may be named using any combination of 

alpha and numeric characters. Versions that begin with 'XJDE' or 'ZJDE' are set up by J.D. Edwards.
szCarrierRoute CRTE char OPT NONE
This field is used to indicate the Carrier Route for the U.S. Postal Service and is reserved for future use.
mnSynchronizationStatus SYNCS MATH_NUMERIC OPT NONE
A user defined code that indicates the post synchronization validation status of the record. 



Valid Values are:



0

Success (Blank)



1

The record 

is pending post synchronization Add validation on the server (PVA)



2

The record is pending post synchronization Change validation on the 

server (PVC)



3

The record is in error from the post synchronization Add validation on the server (ERRA)



4

The record is in error from the post 

synchronization Change validation on the server (ERRC)



5

The associated F0101 record is in error (ERRP)



6

The record is pending post 

synchronization Add validation on the server and the associated F0101 record is in error (ERRPA)



7

The record is pending post synchronization 

Change validation on the server and the associated F0101 record is in error (ERRPC)


mnServerStatus CAAD MATH_NUMERIC OPT NONE
A user defined code that indicates the server synchronization status of the record. 



Valid values are: 



0

The record has been changed on the 

Server or has been processed by post synchronization validation on the Server.



1

The record has been changed on the Disconnected 

Client.



2

The record has been changed on the Disconnected Client and has been synchronized to the Server. This value is set only on 

Disconnected Client and any records with a value of 2 cannot be changed.


cCallSalesTeamAlignment EV01 char OPT NONE
An option that specifies the type of processing for an event.



Related Functions

 
None

Related Tables

 
None

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
mnAddressNumber	AN8	MATH_NUMERIC	OPT	NONE
A number that identifies an entry in the Address Book system, such as employee, applicant, participant, customer, supplier, tenant, or location.
jdDateBeginningEffective	EFTB	JDEDATE	OPT	NONE
The date that an address, item, transaction, or table record becomes active. The meaning of this field differs, depending on the program. For example, the effective date could represent the following: o When a change of address becomes effective. o When a lease becomes effective. o When a price becomes effective. o When the currency exchange rate becomes effective. o When a tax rate becomes effective.
szAddressLine1	ADD1	char	OPT	NONE
The first line of a mailing address for an employee, customer, or supplier in the Address Book system. The U.S. Internal Revenue Service (IRS) restricts the size of the address that prints on an employee's year-end tax return. To comply with IRS regulations, the system has the following restrictions: o On W-2 returns, the system prints only the last three nonblank address lines plus the city, state, and postal code. o On 1099 returns, the system prints only the last nonblank address line plus the city, state, and postal code. o On other U.S. federal magnetic media, the system prints only the last nonblank address line plus the city, state, and postal code.
szAddressLine2	ADD2	char	OPT	NONE
The second line of the mailing address for an employee, customer, or supplier in the Address Book system. Attention Payroll users: The Internal Revenue Service (IRS) restricts the size of the address that prints on employee's year-end forms. To comply with IRS regulations, the address that prints on W-2 forms includes only the last three nonblank address lines plus the city, state, and postal code. The address that prints on 1099 forms includes only the last nonblank address line plus the city, state, and postal code. If you process year-end information using the federal magnetic media format, the address that prints on those forms contains only the last nonblank address line plus the city, state, and postal code.
szAddressLine3	ADD3	char	OPT	NONE
The third line of the mailing address for an employee, customer, or supplier in the Address Book system. Attention Payroll users: The Internal Revenue Service (IRS) restricts the size of the address that prints on employee's year-end forms. To comply with IRS regulations, the address that prints on W-2 forms includes only the last three nonblank address lines plus the city, state, and postal code. The address that prints on 1099 forms includes only the last nonblank address line plus the city, state, and postal code. If you process year-end information using the federal magnetic media format, the address that prints on those forms contains only the last nonblank address line plus the city, state, and postal code.
szAddressLine4	ADD4	char	OPT	NONE
The fourth line of the mailing address for an employee, customer, or supplier in the Address Book system. Attention Payroll users: The Internal Revenue Service (IRS) restricts the size of the address that prints on employee's year-end forms. To comply with IRS regulations, the address that prints on W-2 forms includes only the last three nonblank address lines plus the city, state, and postal code. The address that prints on 1099 forms includes only the last nonblank address line plus the city, state, and postal code. If you process year-end information using the federal magnetic media format, the address that prints on those forms contains only the last nonblank address line plus the city, state, and postal code.
szZipCodePostal	ADDZ	char	OPT	NONE
The United States ZIP code or the postal code that specifies where a letter is to be routed. Attach this code to the address for delivery in other countries. This code is used as the low end value when doing Postal Code Transaction range processing.
szCity	CTY1	char	OPT	NONE
A name that indicates the city associated with the address.
szCountyAddress	COUN	char	OPT	NONE
The name of a county, parish, or other political district that is necessary for the address or for tax purposes.
szState	ADDS	char	OPT	NONE
A user defined code (00/S) that specifies the state or province. This code is usually a postal service abbreviation.
szCountry	CTR	char	OPT	NONE
A user defined code (00/CN) that identifies a country. The country code has no effect on currency conversion. The Address Book system uses the country code for data selection and address formatting.
szProgramId	PID	char	OPT	NONE
The number that identifies the batch or interactive program (batch or interactive object). For example, the number of the Sales Order Entry interactive program is P4210, and the number of the Print Invoices batch process report is R42565. The program ID is a variable length value. It is assigned according to a structured syntax in the form TSSXXX, where: T The first character of the number is alphabetic and identifies the type, such as P for Program, R for Report, and so on. For example, the value P in the number P4210 indicates that the object is a program. SS The second and third characters of the number are numeric and identify the system code. For example, the value 42 in the number P4210 indicates that this program belongs to system 42, which is the Sales Order Processing system. XXX The remaining characters of the numer are numeric and identify a unique program or report. For example, the value 10 in the number P4210 indicates that this is the Sales Order Entry program.
cActionCode	ACTN	char	OPT	NONE
A code that specifies the action that is performed. Valid values are: A Add C Change
cUpdateMasterFile	EV01	char	OPT	NONE
An option that specifies the type of processing for an event.
cProcessEdit	EV01	char	OPT	NONE
An option that specifies the type of processing for an event.
cSuppressErrorMessage	SUPPS	char	OPT	NONE
A flag indicating whether or not runtime error messaging will occur when an error message is issued from a business function. 0 = allow runtime error message handling. 1 = suppress runtime error message handling.
szErrorMsgID	DTA1	char	OPT	NONE
A 256 byte field used to hold miscellaneous data.
szVersionconsolidated	VER	char	OPT	NONE
Identifies a specific set of data selection and sequencing settings for the application. Versions may be named using any combination of alpha and numeric characters. Versions that begin with 'XJDE' or 'ZJDE' are set up by J.D. Edwards.
szCarrierRoute	CRTE	char	OPT	NONE
This field is used to indicate the Carrier Route for the U.S. Postal Service and is reserved for future use.
mnSynchronizationStatus	SYNCS	MATH_NUMERIC	OPT	NONE
A user defined code that indicates the post synchronization validation status of the record. Valid Values are: 0 Success (Blank) 1 The record is pending post synchronization Add validation on the server (PVA) 2 The record is pending post synchronization Change validation on the server (PVC) 3 The record is in error from the post synchronization Add validation on the server (ERRA) 4 The record is in error from the post synchronization Change validation on the server (ERRC) 5 The associated F0101 record is in error (ERRP) 6 The record is pending post synchronization Add validation on the server and the associated F0101 record is in error (ERRPA) 7 The record is pending post synchronization Change validation on the server and the associated F0101 record is in error (ERRPC)
mnServerStatus	CAAD	MATH_NUMERIC	OPT	NONE
A user defined code that indicates the server synchronization status of the record. Valid values are: 0 The record has been changed on the Server or has been processed by post synchronization validation on the Server. 1 The record has been changed on the Disconnected Client. 2 The record has been changed on the Disconnected Client and has been synchronized to the Server. This value is set only on Disconnected Client and any records with a value of 2 cannot be changed.
cCallSalesTeamAlignment	EV01	char	OPT	NONE
An option that specifies the type of processing for an event.