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
| ||||
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
| ||||
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
| ||||
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
| ||||
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
| ||||
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
| ||||
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
| ||||
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
| ||||
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
| ||||
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
| ||||
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
| ||||
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
| ||||
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
| ||||
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
| ||||
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
| ||||
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
| ||||
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
| ||||
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
| ||||
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
| ||||
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. |
None |
None |