GetLastActivityDate

Get Last Activity Date

Minor Business Rule

Object Name: B03B0091

Parent DLL: CFIN

Location: Client/Server

Language: C

B03B0091
Get Last Activity Date

Functional Description

Purpose
This function Get Last Activity Date retrieves the Activity Type and the Activity Date from the
Customer Activity Log Table (F03B31).

Setup Notes and Prerequisites

Special Logic

Technical Specifications

Parameters
ItemDescriptionI/OReq?Notes
AN8mnAddressNumberIYes
COszCompanyIYes
AITszActivityO
DTIjdDateTicklerO

Related Tables
F03B31Customer Activity Log

Related Business Functions

Processing

• JDB_SelectKeyed on table F03B31 using Address Number, and Company
• If JDEDB_PASSED then copy Activity, and Tickler Date to output fields
• return ER_SUCCESS

^

Data Structure

D03B0091 - Get Last Activity Date

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.
szCompany	CO	char	NONE	NONE
A code that identifies a specific organization, fund, or other reporting entity. The company code must already exist in the Company Constants table (F0010) and must identify a reporting entity that has a complete balance sheet. At this level, you can have intercompany transactions. Note: You can use company 00000 for default values such as dates and automatic accounting instructions. You cannot use company 00000 for transaction entries.
jdDateTickler	DTI	JDEDATE	NONE	NONE
The date an activity was performed or, for promise activities, the reminder date.
szActivity	AIT	char	NONE	NONE
A code that identifies a message in the Account Activity Log.

Related Functions

None

Related Tables

F03B31 Customer Activity Log