1.Functional Description
1.1Purpose
This named E/R function will retrieve a row on the Rule Table Value Definition table (F32821) and
return all row values. The error message "0002" will be returned if the record does not exist for the
key values specified. The calling program will be responsible for processing this error code, i.e.
sending or printing an error message to the user.
Branch Plant (MCU)
Rules Table Type (RTBT)
Parent Item Number (KIT)
Bubble Sequence (BSEQ)
1.2Setup Notes and Prerequisites
No special setup instructions.
1.3Special Logic
No special logic.
2.Technical Specifications
2.4Processing
Fetch the record from the F32821 using key fields specified and return output values from the file.
If record does not exist, pass error message "0002" back to the calling program.
^
D3200960 - F32821 Get Rules Value Definition Row
Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
---|---|---|---|---|
mnItemNumberShortKit | KIT | MATH_NUMERIC | NONE | NONE |
The system provides for three separate item numbers.
1. Item Number (short) - An eight-digit, computer assigned, completely
| ||||
mnBubbleSequence | BSEQ | MATH_NUMERIC | NONE | NONE |
A secondary bill of material sequence number that indicates the drawing bubble number. | ||||
mnSegmentNumber | PEL | MATH_NUMERIC | NONE | NONE |
A number that establishes the sequence in which the segments were defined in the system. Segment numbers are user
| ||||
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. | ||||
szUserId | USER | char | NONE | NONE |
The code that identifies a user profile. | ||||
szProgramId | PID | char | NONE | NONE |
The number that identifies the batch or interactive program (batch or interactive object). For example, the number of the Sales Order Entry
| ||||
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. | ||||
cSuppressErrorMsgID | 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
| ||||
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
| ||||
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
| ||||
szCostCenter | 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
| ||||
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
| ||||
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
|
None |
None |