PreviousEffectiveAddress

Previous Effective Address Date

Major Business Rule

Object Name: B0100037

Parent DLL: CFIN

Location: Client/Server

Language: C




1.Functional Description





1.1Purpose


If in an add mode, the effective date is set to the current date


and all address fields are left blank.  On a revision mode the


address fields are set by the effective address date set in the


F0101 file.


1.2Setup Notes and Prerequisites


• If address book number is blank or zero then the function will exit with no error returned.





1.3Special Logic





2.Technical Specifications





2.1Parameters:


2.2Related Tables 


Table Table Description


F0116Address by Date


 





2.3Related Business Functions


Source NameFunction Name


RETDATENot sure this is used


B9800100Get Audit Information





2.4Processing .

Data Structure

D0100033 - Effective Date Address Retrival

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
mnAddressNumber	AN8	MATH_NUMERIC	NONE	NONE
^
jdDateBeginningEffective	EFTB	JDEDATE	NONE	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.
cEffectiveDateExistence10	EFTF	char	NONE	NONE
A code that indicates whether a record has been processed by an update program based on some date criteria. Values are: Blank or 0 Record has not been processed by the update program. 1 Record has been processed by the update program.
szAddressLine1	ADD1	char	NONE	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	NONE	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	NONE	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	NONE	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	NONE	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	NONE	NONE
A name that indicates the city associated with the address.
szCountyAddress	COUN	char	NONE	NONE
The name of a county, parish, or other political district that is necessary for the address or for tax purposes.
szState	ADDS	char	NONE	NONE
A user defined code (00/S) that specifies the state or province. This code is usually a postal service abbreviation.
szCountry	CTR	char	NONE	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.
szUserid	USER	char	NONE	NONE
The code that identifies a user profile.
szProgramid	PID	char	NONE	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.
jdDateupdated	UPMJ	JDEDATE	NONE	NONE
The date that specifies the last update to the file record.
szWorkstationid	JOBN	char	NONE	NONE
The code that identifies the work station ID that executed a particular job.
mnTimelastupdated	UPMT	MATH_NUMERIC	NONE	NONE
The time that specifies when the program executed the last update to this record.
szNamealpha	ALPH	char	NONE	NONE
The text that names or describes an address. This 40-character alphabetic field appears on a number of forms and reports. You can enter dashes, commas, and other special characters, but the system cannot search on them when you use this field to search for a name.
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.

Related Functions

B0000127 Return todays date in JDEDATE format

Related Tables

F0116 Address by Date