F3283GetNextRulesTableDetail

F3283 Get Next Rules Table Detail

Major Business Rule

Object Name: B3200950

Parent DLL: CMFG

Location: Client/Server

Language: C

1.Functional Description
This business function will get all the Rules Table Detail rows from the F3283 table for a given key.
This business function will provide records by either full key or partial key.

The first time the function is called, pass a '1' in the Type parameter so the Request is not
released.
To get the next value in the table, pass a '2' in the Type parameter. To release the request, pass a
'3'
in the Type parameter. If one record is wanted only, pass a '4' to get record and also release
Request.

Keys: Pass the number of key elements used to fetch the record.

Suppress Error Message: 1=Suppress runtime error message handling, 0=Allow runtime error
message handling.

1Purpose
This business function will get the next Rules Table Detail row by key, and have capability to
provide records by either full key or partial key.

1.2Setup Notes and Prerequisites
• Set on "Suppress Error Messages" to suppress the runtime error message handling. Otherwise, if an
error occurs the error message will be displayed on the message line and the appropriate field (if any)
will be highlighted.

• The user passes to the business function the number key fields within the index that will be used.

• Keys = Number of keys in the index that should be used to retrieve the Rules Table Detail row for
the primary index.

• Return Field values.

1.3Special Logic
None.

2.Technical Specifications
2.4Processing

1. If the Input Request Type = '3', Release the Request and exit the Business function.
2. If the Input Request Type is '1' or '4', Get the Rules Table Detail row (F3283) using the
specified key values.
3. If the Request Type = '2', read the next F3283 row using above keys.
4. If row is found
Load the Output fields.
Exit
    Else
Release the request and exit the business function.
    Endif
5. If any errors or Request Type = '4', Release the request and exit the function.

Retrievals:
1.  Rules Detail Table values  (F3283).

Returns:
1.  If fetch fails, return Error Message ID '0002' (Record Invalid).
2.  If fetch is successful,  return the field values if required.
3.  If EOF reached, return '1' in End of File parameter, otherwise return 0
4. Other errors : "3143"

Data Structure

D3200950 - F3283 Get Next Rules Table Detail

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
mnBubbleSequence	BSEQ	MATH_NUMERIC	NONE	NONE
A secondary bill of material sequence number that indicates the drawing bubble number.
mnUnitPriceEntered	UPAX	MATH_NUMERIC	NONE	NONE
The price charged for the unit of measure in the adjoining field. Use these fields, for example, if your primary unit of measure is EA (each), but you typically use a list price per box.
mnIdentifierShortItem	ITM	MATH_NUMERIC	NONE	NONE
An inventory item number. The system provides three separate item numbers plus an extensive cross-reference capability to other item numbers (see data item XRT) to accommodate substitute item numbers, replacements, bar codes, customer numbers, supplier numbers, and so forth. The item numbers are as follows: o Item Number (short) - An eight-digit, computer-assigned item number o 2nd Item Number - The 25-digit, free-form, user defined alphanumeric item number o 3rd Item Number - Another 25-digit, free-form, user defined alphanumeric item number
mnQtyRequiredStandard	QNTY	MATH_NUMERIC	NONE	NONE
The number of units that the system applies to the transaction.
szUnitOfMeasure	UM	char	NONE	NONE
A user defined code (00/UM) that identifies the unit of measurement for an amount or quantity. For example, it can represent a barrel, box, cubic meter, liter, hour, and so on.
szUserReservedCode	URCD	char	NONE	NONE
This is a 2 position code that is reserved for the user. JDE does not currently use this field and will not utilize this field in the future.
jdUserReservedDate	URDT	JDEDATE	NONE	NONE
This is a 6 position code that is reserved for the user. JDE does not currently use this field and will not utilize this field in the future.
mnUserReservedAmount	URAT	MATH_NUMERIC	NONE	NONE
This is a 15 position code that is reserved for the user. JDE does not currently use this field and will not utilize this field in the future.
mnUserReservedNumber	URAB	MATH_NUMERIC	NONE	NONE
This is a 8 position code that is reserved for the user. JDE does not currently use this field and will not utilize this field in the future.
szUserReservedReference	URRF	char	NONE	NONE
A 15-position reference that is reserved for the user. J.D. Edwards does not currently use this field and does not plan to use it in the future.
cRequestType	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.
nKeys	INT01	integer	NONE	NONE
Number of Days in Future to Query for Responses Due.
cEndofFile	EV01	char	NONE	NONE
An option that specifies the type of processing for an event.
cReturnFieldValues	EV01	char	NONE	NONE
An option that specifies the type of processing for an event.
cSuppressErrorMessages	EV01	char	NONE	NONE
An option that specifies the type of processing for an event.
hRequestF3283	GENLNG	ID	NONE	NONE
General purpose ID variable.
jdEffectiveFromDate	EFFF	JDEDATE	OPT	NONE
A date that indicates one of the following: o When a component part goes into effect on a bill of material o When a routing step goes into effect as a sequence on the routing for an item o When a rate schedule is in effect The default is the current system date. You can enter future effective dates so that the system plans for upcoming changes. Items that are no longer effective in the future can still be recorded and recognized in Product Costing, Shop Floor Management, and Capacity Requirements Planning. The Material Requirements Planning system determines valid components by effectivity dates, not by the bill of material revision level. Some forms display data based on the effectivity dates you enter.
jdEffectiveThruDate	EFFT	JDEDATE	OPT	NONE
A date that indicates one of the following: o When a component part is no longer in effect on a bill of material o When a routing step is no longer in effect as a sequence on the routing for an item o When a rate schedule is no longer active The default is December 31 of the default year defined in the Data Dictionary for Century Change Year. You can enter future effective dates so that the system plans for upcoming changes. Items that are no longer effective in the future can still be recorded and recognized in Product Costing, Shop Floor Management, and Capacity Requirements Planning. The Material Requirements Planning system determines valid components by effectivity dates, not by the bill of material revision level. Some forms display data based on the effectivity dates you enter.
szConfiguredTableKeyID	CTKID	char	OPT	NONE
An identifier that represents a branch, table name, and up to 20 segment key values. It is generated from an encryption algorithm. The system always converts the configured table information into a 32-character digest. The digest is always a full 32 characters in length, consists of numbers and characters, and does not contain any blanks. You cannot determine the initial value from the digest, and it has no significant meaning.
szTableSegmentValue1	TSV1	char	OPT	NONE
A value used as a key to a table.
szTableSegmentValue2	TSV2	char	OPT	NONE
A value used as a key to a table.
szTableSegmentValue3	TSV3	char	OPT	NONE
The Table Segment Value is a value used as a key to a table.
szTableSegmentValue4	TSV4	char	OPT	NONE
The Table Segment Value is a value used as a key to a table.
szTableSegmentValue5	TSV5	char	OPT	NONE
The Table Segment Value is a value used as a key to a table.
szTableSegmentValue6	TSV6	char	OPT	NONE
The Table Segment Value is a value used as a key to a table.
szTableSegmentValue7	TSV7	char	OPT	NONE
The Table Segment Value is a value used as a key to a table.
szTableSegmentValue8	TSV8	char	OPT	NONE
The Table Segment Value is a value used as a key to a table.
szTableSegmentValue9	TSV9	char	OPT	NONE
The Table Segment Value is a value used as a key to a table.
szTableSegmentValue10	TSV0	char	OPT	NONE
The Table Segment Value is a value used as a key to a table.
szTableSegmentValue11	TSV11	char	OPT	NONE
A value that is used as a key to a table.
szTableSegmentValue12	TSV12	char	OPT	NONE
A value that is used as a key to a table.
szTableSegmentValue13	TSV13	char	OPT	NONE
A value that is used as a key to a table.
szTableSegmentValue14	TSV14	char	OPT	NONE
A value that is used as a key to a table.
szTableSegmentValue15	TSV15	char	OPT	NONE
A value that is used as a key to a table.
szTableSegmentValue16	TSV16	char	OPT	NONE
A value that is used as a key to a table.
szTableSegmentValue17	TSV17	char	OPT	NONE
A value that is used as a key to a table.
szTableSegmentValue18	TSV18	char	OPT	NONE
A value that is used as a key to a table.
szTableSegmentValue19	TSV19	char	OPT	NONE
A value that is used as a key to a table.
szTableSegmentValue20	TSV20	char	OPT	NONE
A value that is used as a key to a table.
szRulesTableName	TBLC	char	OPT	NONE
The name of a collection of data that you set up to minimize the number of assembly inclusion rules that you need for a configured item. You must define rule table names in user defined code table 32/TN. A rule table can be accessed by 1 to 20 keys and can return up to 99 values. When you reference a rule table in an assembly inclusion rule, the system uses the rule keys to retrieve the values that are associated with the rule table. For example, if you defined segment 10 to be the color of an item, you could set the table to retrieve item Red Component when the customer enters Red for segment 10. In this example, the table would be: Item Color = Value Red = Red Component The table would include the following: If the color segment value = red, then use item number Red Component on the configured item sales order and work order parts list.
cRulesTableType	RTBT	char	OPT	NONE
A value that identifies the type of rule table. Valid values are: P Part list (on sales order and work order) Q Work order component (on work order only) C Calculated values H Hot Spot X Price/Cost adjustment
szBranchPlant	MCU	char	OPT	NONE
An alphanumeric code that identifies a separate entity within a business for which you want to track costs. For example, a business unit might be a warehouse location, job, project, work center, branch, or plant. You can assign a business unit to a document, entity, or person for purposes of responsibility reporting. For example, the system provides reports of open accounts payable and accounts receivable by business unit to track equipment by responsible department. Business unit security might prevent you from viewing information about business units for which you have no authority.
szRulesTableValue	TVAL	char	OPT	NONE
A value that is assigned to a component and is stored in, and returned from, a rules table.

Related Functions

None

Related Tables

F3283 Rules Table Detail