RetrieveAliasesFromF00090

Retrieve Aliases from F00090 using SDB code

Minor Business Rule

Object Name: N4101020

Parent DLL: COPBASE

Location: Client/Server

Language: NER

Functional Description
Purpose
This function retrieves Aliases from F00090 using SDB Code.

Setup Notes and Prerequisites
None.

Special Logic
None.

Technical Specification
Based on the Supplemental Database code, retrieve the aliases from the Supplemental Database Setup
file F00090.

Processing
Based on the Supplemental Database code, retrieve the aliases from file F00090.

Retrievals:
Supplemental Database Table (F00090).
SAL1- SDB Alias 1
SAL2- SDB Alias 2
SAL3- SDB Alias 3
SAL4- SDB Alias 4

Data Structure

D4101020 - Retrieve Alias from F00090 using SDB code

Parameters:
Data ItemData Structure Description I/0Required
SDBSupplemental Database Code IY
SAL1SDB Alias 1ON
SAL2SDB Alias 2ON
SAL3SDB Alias 3ON
SAL4SDB Alias 4ON
SYNSunchronize Database
FILEFile Name
^

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
szSupplementalDatabaseCode	SDB	char	NONE	NONE
A user defined code (00/SD) that sets up databases for groups of related supplemental data types. This code differentiates the supplemental data types for various systems. For example, the Employee (E) supplemental database contains data types that you use to track additional employee information, such as education and job skills.
szSuppDatabaseAlias1	SAL1	char	NONE	NONE
A data dictionary alias name for the first alphanumeric key of the generic supplemental database. Valid values for this key are defined in the attached user defined code.
szSuppDatabaseAlias2	SAL2	char	NONE	NONE
A data dictionary alias name for the second alphanumeric key of the generic supplemental database. Valid values for this key are defined in the attached user defined code.
szSuppDatabaseAlias3	SAL3	char	NONE	NONE
A data dictionary alias name for the first numeric key of the generic supplemental database. Valid values for this key are defined in the attached user defined code.
szSuppDatabaseAlias4	SAL4	char	NONE	NONE
A data dictionary alias name for the second numeric key of the generic supplemental database. Valid values for this key are defined in the attached user defined code.
cSunchronizeDatabase	SYN	char	NONE	NONE
An indicator that determines whether a supplemental database should be synchronized between OneWorld and WorldSoftware systems. Except for supplemental database codes I (inventory by item) and IB (inventory by item/branch), free-form generic text is not passed from one system to the other system. Only records are synchronized between the two systems. If you create a new database code or a new data type, you must manually enter the database code or data type into both the OneWorld system and the WorldSoftware system.
szFileName	FILE	char	NONE	NONE
The number of a specific table. For example, the Account Master table name is F0901. See the Standards Manual on the programmers' menu for naming conventions.

Related Functions

None

Related Tables

None