F00090GetSupplDBSetupRow

F00090 Get Suppl DB Setup Row

Minor Business Rule

Object Name: N0000530

Parent DLL: CMFGBASE

Location: Client/Server

Language: NER

Data Structure

D0000530 - F00090 Get Suppl DB Setup Row

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.
cSuppDataNumericFlag1	SFN1	char	NONE	NONE
An option that specifies whether the system uses the data you enter in the generic numeric key 1 field as a key field for supplemental data. Valid values are: On Generic numeric key 1 is a key field for supplemental data Off Generic numeric key 1 is not a key field for supplemental data
cSuppDataNumericFlag2	SFN2	char	NONE	NONE
An option that specifies whether the system uses the data you enter in the generic numeric key 1 field as a key field for supplemental data. Valid values are: On Generic numeric key 1 is a key field for supplemental data Off Generic numeric key 1 is not a key field for supplemental data
cSuppDataAlphaFlag2	SFA2	char	NONE	NONE
An option that specifies whether the system uses the data you enter in the generic alphanumeric key 1 field as a key field for supplemental data. Valid values are: On Generic alphanumeric key 1 is a key field for supplemental data Off Generic alphanumeric key 1 is not a key field for supplemental data
cSuppDataAlphaFlag1	SFA1	char	NONE	NONE
An option that specifies whether the system uses the data you enter in the generic alphanumeric key 1 field as a key field for supplemental data. Valid values are: On Generic alphanumeric key 1 is a key field for supplemental data Off Generic alphanumeric key 1 is not a key field for supplemental data
cKeyCompanyFlag	FKCO	char	NONE	NONE
An option that specifies whether the system uses Company as a key field for supplemental data. Valid values are: On Company is a key field for supplemental data Off Company is not a key field for supplemental data
cBusinessUnitFlag	FMC6	char	NONE	NONE
An option that specifies whether the system uses the business unit as a key field for supplemental data. Valid values are: On Business unit is a key field for supplemental data Off Business unit is not a key field for supplemental data
szDocumentCompanyDescripti	DLKC	char	NONE	NONE
A field that enables you to override the default description for the Document Company in the Supplemental Database inquiry and entry programs. If you leave this field blank, the system uses the default description from the data dictionary.
szBusinessUnitDescription	DLMC	char	NONE	NONE
A field that enables you to override the default description for Business Unit in the Supplemental Database inquiry and entry programs. If you leave this field blank, the system uses the default description from the data dictionary.
szSuppDataKeyDescription1	SBD1	char	NONE	NONE
A field that enables you to override the default description for the data dictionary alias you entered as a key field for the Supplemental Database inquiry and entry programs. If you leave this field blank, the system uses the default description from the data dictionary.
szSuppDataKeyDescription2	SBD2	char	NONE	NONE
A field that enables you to override the default description for the data dictionary alias you entered as a key field for the Supplemental Database inquiry and entry programs. If you leave this field blank, the system uses the default description from the data dictionary.
szSuppDataKeyDescription3	SBD3	char	NONE	NONE
A field that enables you to override the default description for the data dictionary alias you entered as a key field for the Supplemental Database inquiry and entry programs. If you leave this field blank, the system uses the default description from the data dictionary.
szSuppDataKeyDescription4	SBD4	char	NONE	NONE
A field that enables you to override the default description for the data dictionary alias you entered as a key field for the Supplemental Database inquiry and entry programs. If you leave this field blank, the system uses the default description from the data dictionary.
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.
szValidationFileName	VFIL	char	NONE	NONE
Specifies the file name to use for validating the current data field contents. This file name is automatically provided from the data dictionary if it exists.
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.
cExecuteSelection	FDS	char	NONE	NONE
A flag that determines whether the specified data selection routine needs to be performed.
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.
szFunctionName1	FCNM	char	NONE	NONE
The name of a valid business function.
cSuppressErrorMessages	EV01	char	NONE	NONE
An option that specifies the type of processing for an event.
szErrorMessageID	DTAI	char	NONE	NONE
A code that identifies and defines a unit of information. It is an alphanumeric code up to 8 characters long that does not allow blanks or special characters such as %, &, or +. You create new data items using system codes 55-59. You cannot change the alias.

Related Functions

None

Related Tables

None