F1204RetrieveLocation

F1204 Retrieve Location

Minor Business Rule

Object Name: B1200150

Parent DLL: CMFG

Location: Client/Server

Language: C

Functional Description

Purpose
To retrieve the location of an asset for a specified date. If the date is not the start date of a
location, retrieve the location the has a start date less than the specified date and an end date
greater than or equal to the specified date.

Setup Notes and Prerequisites

Special Logic

Technical Specification




Set Selection for Location Tracking Table using:


Asset Number = Input Asset Number


Effective Date <= Input Date


Ending Date >= Input Date


Fetch selected record


If Fetch successful


Assign Output Location = Location from F1204


Else


Assign Output Error Code = '1'


End If

Data Structure

D1200150 - F1204 Retrieve Location

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
mnAssetItemNumber	NUMB	MATH_NUMERIC	REQ	INPUT
An 8-digit number that uniquely identifies an asset.
jdDateBeginningEffective	EFTB	JDEDATE	REQ	INPUT
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.
szCostCenterLocation	LOC	char	REQ	OUTPUT
The current physical location of an asset. The location must have a valid business unit or job number in the Business Unit Master table (F0006).
cErrorCode	EV01	char	REQ	OUTPUT
' ' = Location Found '1' = Location Not Found ^

Related Functions

F1204 Location Tracking Table
JDEAPP Applications Global Definitions - include file only

Related Tables

F1204 Location Tracking Table