UpdateEFTFinF0116

Update EFTF in F0116

Major Business Rule

Object Name: B0100027

Parent DLL: CFIN

Location: Client/Server

Language: C

1.Functional Description

1.1Purpose
To accept a date and the EFTF flag value from the input parameters and update the F0116 (Effective Address Table) and the F0101 (Address Master
Table).

1.2Setup Notes and Prerequisites
• This procedure will not create any Effective Date records it will only update records that are
already there.
• It is ran from the UBE R01840.
• The cEffectiveDateExistence parameter is the value for the EFTF flag in the F0116 record.

• Sending a zero will make the F0116 record no longer current for that effective address record.
• Sending a 1 will make the F0116 record the current effective address record, and the F0101 record
will be set to the date that is input.

1.3Special Logic

2.Technical Specifications

2.1Parameters:
2.2Related Tables
Table Table Description
F0101Address Book Master
F0116Effective Date

2.3Related Business Functions
Source NameFunction Name

2.4Processing

Data Structure

D0100027 - Update EFTF in F0116

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
mnAddressNumber	AN8	MATH_NUMERIC	NONE	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	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.
cEffectiveDateExistence	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.
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.

Related Functions

None

Related Tables

F0101 Address Book Master
F0116 Address by Date