VerifyAndGetItemSupplementData

Verify And Get Item Supplement Data Type

Major Business Rule

Object Name: B4100830

Parent DLL: COPBASE

Location: Client/Server

Language: C

Functional Description

Purpose
This function will retrieve system code and record type from the F41090 based on ther DSDB and TYDB
passed in from F41092.

Setup Notes and Prerequisites
None

Special Logic
None

Technical Specifications
This function fetchs on F41090 based on the Keys passed in:
Index = 1   Keys = 1 :DSDB
2:  DSDB, TYDB
Index = 2  Keys = 1:CLSI
2:CLSI, TYDB
^

Data Structure

D4100830 - Verify And Get Item Supplement Data Type

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
cDistributionDatabase	DSDB	char	NONE	NONE
The code representing what Distribution Data Base is to be used. Currently,only the Inventory Supplemental Data Base is available. This field should be equal to I.
szTypeData	TYDB	char	NONE	NONE
A code that you enter to distinguish the type of data that you later enter in the Supplemental Database. This user defined code is often an abbreviation for the data it represents. For example, you could define "AT" to represent "Advertising Types" and "SP"to represent "Special Promotions."
cDisplayMode	DSPM	char	NONE	NONE
A code that specifies the format of a data type. This code determines the display mode for supplemental data. Valid codes are: C Code format, which displays the form for entering code-specific information. These codes might be associated with the User Defined Codes (F0005) table. N Narrative format, which displays the form for entering narrative text. P Program exit, which allows you to exit to the program you specified in the Pgm ID field. M Message format, which displays the form for entering code-specific information. The system can edit the code values you enter against values in the Generic Message/Rates table (F00191). This code is not used by the Human Resources or Financials systems.
szDescription	DL01	char	NONE	NONE
A user defined name or remark.
szSystemCode	SY	char	NONE	NONE
A user defined code (98/SY) that identifies a system. Valid values include: 01 Address Book 03B Accounts Receivable 04 Accounts Payable 09 General Accounting 11 Multicurrency
szRecordType	RT	char	NONE	NONE
A code that identifies the table that contains user defined codes. The table is also referred to as a UDC type.
cCallType	EV01	char	NONE	NONE
An option that specifies the type of processing for an event.
cSuppressErrorMessage	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.
mnIndex	CDL	MATH_NUMERIC	NONE	NONE
The length of the user defined code. It cannot be greater than 10 characters.
mnKeys	CDL	MATH_NUMERIC	NONE	NONE
The length of the user defined code. It cannot be greater than 10 characters.
szDataTypeClassification	CLSI	char	NONE	NONE
A code that the system uses to group similar data types within the Supplemental Database.
szTitleCode	GDC1	char	NONE	NONE
A description of a supplemental data column that relates to a user defined code. For example, if the supplemental data type relates to the educational degrees of employees (BA, MBA, Ph.D, and so on), the description could be Degree. This column contains user defined codes.
szAmountTitle	GDC2	char	NONE	NONE
The title of a supplemental data column that relates to an amount. For example, if the data type relates to bid submittals, the heading could be Bid Amounts. This column contains statistical or measurable information.
szRemarkColumnTitle1	GDC3	char	NONE	NONE
The title of a supplemental data column.
szRemarkColumnTitle2	GDC4	char	NONE	NONE
The title of a supplemental data column.
szFilenameID	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.
szProgramID	PGM	char	NONE	NONE
The name of an executable program.
szVersion	VERS	char	NONE	NONE
A user-defined set of specifications that control how applications and reports run. You use versions to group and save a set of user-defined processing option values and data selection and sequencing options. Interactive versions are associated with applications (usually as a menu selection). Batch versions are associated with batch jobs or reports. To run a batch process, you must choose a version.
mnDisplaySequence	DSS5	MATH_NUMERIC	NONE	NONE
A number that specifies the order of a group of records on the form.
szProgramName	PGMG	char	NONE	NONE
The program that performs an existence check for a specified Address Book number.

Related Functions

None

Related Tables

F41090 Item Supplemental Data Types