F5192RetrieveColumn

F5192 Fetch Column

Minor Business Rule

Object Name: N5100050

Parent DLL: CAEC

Location: Client/Server

Language: NER

Functional Description

Purpose
Fetch Column Information from F5192.
Use Table I/O to accomplish this task.
The compiled Table I/O should be faster than ER interpreted code.
^

Data Structure

D5100050 - F5192 Retrieve Column

Description is a required entry field in the table.
Description is returned blank when the record is not found.
^

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
szColumn	COLN	char	REQ	INPUT
An alphanumeric code that identifies a column. A column represents a performance factor, such as the average unit cost for an item and the last cost that you paid for an item. For example, you can review performance factors to compare suppliers' costs and services for a certain item.
szDescription	DL01	char	OPT	OUTPUT
A user defined name or remark.
szColumnHeading	DL01	char	OPT	OUTPUT
A user defined name or remark.
szFormula	FMLA	char	OPT	OUTPUT
A calculation that the system uses to determine an amount or quantity for this column. You can use a single predefined value or multiple predefined values in conjunction with mathematical operators to enter a formula. Valid mathematical operators are: + Add - Subtract * Multiply / Divide ( ) Left and right parentheses for nesting For example, you can enter the following formula to have the system calculate on-time percentages: 20/(20+21+22) The formula above equals on-time percentages for the following reasons: o 20 is the value for on-time amounts. o 21 is the value for early amounts. o 22 is the value for late amounts.
mnDecimals	DCML	MATH_NUMERIC	OPT	OUTPUT
The number of characters that appear to the right of the decimal point. For example, if you enter 2, the amount or quantity in this column would have two characters to the right of the decimal point, such as 7.00.
cEditCode	EC	char	OPT	OUTPUT
Determines how data is printed or displayed. Depending on the code, you can change the appearance of the fields as follows (standard IBM edit codes): o Show commas - 1, 2, A, B, J, K, N, or O o Show decimal point - 1, 2, 3, 4, A, B, C, D, J, K, L, M, N, O, P, Q o Show sign for negative - A, B, C, D ("CR") or J through Q ("-") o Suppress leading zeros - 1 through 4, A through D, J through Q, Y and Z Refer to user defined codes (system 98/ type EC) for all valid codes,including additional J.D. Edwards edit codes.
mnMultiplier	MLTP	MATH_NUMERIC	OPT	OUTPUT
The factor by which the amounts or unit quantities in a column are multiplied. The result of the calculation in the Formula field is multiplied by this factor before it is displayed on the Job Status Inquiry form. For example, if you want to scale down extremely large numbers to thousands, enter .001. If you want percentages to be displayed as whole numbers, enter 100.
szGlossary	DITM	char	OPT	OUTPUT
The item in the Data Dictionary table (F9201) that describes the information that a column represents. Typically, a column contains information about a supplier's performance to allow you to compare suppliers' costs and services for a certain item. The related glossary description is displayed when you access field help for the column.

Related Functions

None

Related Tables

None