F00091GetSupplDBDatatypeRow

F00091 Get Suppl DB Datatype Row

Master Business Function

Object Name: N0000540

Parent DLL: CMFGBASE

Location: Client/Server

Language: NER

Data Structure

D0000540 - F00091 Get Suppl DB Datatype 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.
szTypeofData	TYDT	char	NONE	NONE
A code that you assign to supplemental data so that you can group data by categories. Valid values include: A Approval steps B Requisition requirements C Interview process N Requisition notes
szDataTypeClass	CLS	char	NONE	NONE
A user defined code (00/CL) that identifies a group of data types in the Central Information File.
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.
mnSequenceNumber52Display	DSS5	MATH_NUMERIC	NONE	NONE
A number that specifies the order of a group of records on the form.
szDescription001	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
szSystemCode1	SY1	char	NONE	NONE
A user defined code (98/SY) that identifies a J.D. Edwards system.
szSystemCode2	SY2	char	NONE	NONE
A code used to designate the system number. See UDC 98/SY.
szUserDefinedCodes	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.
szUserDefinedCodes1	RT1	char	NONE	NONE
A code that designates the type of record. Most often, the code is used to obtain records in the User Defined Codes (F0005) table. The code is defined in the User Defined Code Types (F0004) table.
szUserDefinedCodes2	RT2	char	NONE	NONE
A code that designates the type of the record. Most often, it is used to obtain records in the User Defined Codes (F0005) table. The code is defined in the User Defined Code Types (F0004) table.
szGenDescCol1	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.
szGenDescCol2	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.
szGenDescCol3	GDC3	char	NONE	NONE
The title of a supplemental data column.
szGenDescCol4	GDC4	char	NONE	NONE
The title of a supplemental data column.
szDateColumnTitle	GDC5	char	NONE	NONE
The title of a supplemental data column that relates to a date. For example, a possible column heading for the date field linked to a data type for education might be Graduation.
szDateColumnTitle6	GDC6	char	NONE	NONE
The title of a supplemental data column that relates to a date. For example,if you set up a record type for professional licenses, a possible column title for the date field might be Expires.
szDateColumnTitle7	GDC7	char	NONE	NONE
The title of a supplemental data column that relates to an amount. For example, if the data type relates to stock options, the heading could be Strike Price. This column contains statistical or measurable information.
szUserDateColumnTitle	GDCA	char	NONE	NONE
The title of a supplemental data column that relates to a date. For example, a possible column heading for the date field linked to the education data type might be Graduation.
szUserDefinedQuantityTitle	GDC0	char	NONE	NONE
The title of a supplemental data column that relates to quantities. For example, if you want to track quantity to be scrapped, a column heading might be Scrapped.
szUserDaysColumnTitle	GDCC	char	NONE	NONE
The title of a supplemental data column that relates to a heading of a supplemental data column heading for the User Defined Days field (DYUD). For example, a possible column heading for the days field linked to scheduling data type might be Lead Time. This column contains numbers.
szOrderColumnTitle	GDC8	char	NONE	NONE
The title of a supplemental data field that relates to a document number. For example, if your company handles accounts receivables, a possible column heading might be Invoices. This column contains document numbers.
szUserAddressColumnTitle	GDCD	char	NONE	NONE
The title of a supplemental data column that relates to addresses. For example, a possible column heading for the address field linked to an education data type might be the College Address.
szAddressType1	AT1	char	NONE	NONE
A user defined code (01/ST) that specifies the kind of address book record to search for. Examples include: E Employees X Ex-employees V Suppliers C Customers P Prospects M Mail distribution lists TAX Tax authorities
szApplicationID	EAP	char	NONE	NONE
The ID that the system uses to call an application.
szProgramName	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.
szUserId	USER	char	NONE	NONE
The code that identifies a user profile.
szWorkStationId	JOBN	char	NONE	NONE
The code that identifies the work station ID that executed a particular job.
jdDateUpdated	UPMJ	JDEDATE	NONE	NONE
The date that specifies the last update to the file record.
mnTimeOfDay	TDAY	MATH_NUMERIC	NONE	NONE
The computer clock in hours:minutes:seconds.
cSuppressErrorMsgs	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.
szRemark3ColumnTitle	GDCE	char	OPT	NONE
The title of a supplemental data column.
szUserTimeColumnTitle	GDCF	char	OPT	NONE
Text that specifies the title of a supplemental data column that relates to a time.

Related Functions

None

Related Tables

None