F3282GetRulesTableCrossRef

F3282 Get Rules Table Cross Ref Row

Major Business Rule

Object Name: N3200940

Parent DLL: CMFG

Location: Client/Server

Language: NER

1.Functional Description

1.1Purpose
This named E/R function will retrieve a row on the Configured Item/Rules Table Cross Reference table
(F3282) and return all row values.  The error message 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.

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 F3282 using key fields specified and return output values from the file.
If record does not exist, pass error message back to the calling program. If the Parent Item Number is
not passed, the first one found is passed back.

Data Structure

D3200940 - F3282 Get Rules Table Cross Ref 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 non-significant item number. 2. 2nd Item Number - The 25-digit, free form, user defined alphanumeric item number. 3. 3rd Item Number - Another 25-digit, free form, user defined alphanumeric item number.
mnNumberSegmentNumber1	PEL1	MATH_NUMERIC	NONE	NONE
A number that identifies a key to the table. This number is based on the segments that you defined for a configured item. Configured table processing references segment numbers and their associated values to define component parts, calculated values, hot spots, and prices for configured items.
mnItemNumberTableSegment1	SIT1	MATH_NUMERIC	NONE	NONE
A number that the system assigns to an item. It can be in short, long, or third item number format.
szTableSegmentBranch1	TMC1	char	NONE	NONE
The branch/plant of the configured item for which the segment is a key to the configured table.
mnNumberSegmentNo2	PEL2	MATH_NUMERIC	NONE	NONE
A number that identifies a key to the table. This number is based on the segments that you defined for a configured item. Configured table processing references segment numbers and their associated values to define component parts, calculated values, hot spots, and prices for configured items.
mnItemNumberTableSeg2	SIT2	MATH_NUMERIC	NONE	NONE
A number that the system assigns to an item. It can be in short, long, or third item number format.
szTableSegmentBranch2	TMC2	char	NONE	NONE
The branch/plant of the configured item for which the segment is a key to the configured table.
mnNumberSegmentNo3	PEL3	MATH_NUMERIC	NONE	NONE
A number that identifies a key to the table. This number is based on the segments that you defined for a configured item. Configured table processing references segment numbers and their associated values to define component parts, calculated values, hot spots, and prices for configured items.
mnItemNumberTableSeg3	SIT3	MATH_NUMERIC	NONE	NONE
A number that the system assigns to an item. It can be in short, long, or third item number format.
szTableSegmentBranch3	TMC3	char	NONE	NONE
The branch/plant of the configured item for which the segment is a key to the configured table.
mnNumberSegmentNo4	PEL4	MATH_NUMERIC	NONE	NONE
A number that identifies a key to the table. This number is based on the segments that you defined for a configured item. Configured table processing references segment numbers and their associated values to define component parts, calculated values, hot spots, and prices for configured items.
mnItemNumberTableSegment4	SIT4	MATH_NUMERIC	NONE	NONE
A number that the system assigns to an item. It can be in short, long, or third item number format.
szTableSegmentBranch4	TMC4	char	NONE	NONE
The branch/plant of the configured item for which the segment is a key to the configured table.
mnNumberSegmentNo5	PEL5	MATH_NUMERIC	NONE	NONE
A number that identifies a key to the table. This number is based on the segments that you defined for a configured item. Configured table processing references segment numbers and their associated values to define component parts, calculated values, hot spots, and prices for configured items.
mnItemNumberTableSegment5	SIT5	MATH_NUMERIC	NONE	NONE
A number that the system assigns to an item. It can be in short, long, or third item number format.
szTableSegmentBranch5	TMC5	char	NONE	NONE
The branch/plant of the configured item for which the segment is a key to the configured table.
mnNumberSegmentNo6	PEL6	MATH_NUMERIC	NONE	NONE
A number that identifies a key to the table. This number is based on the segments that you defined for a configured item. Configured table processing references segment numbers and their associated values to define component parts, calculated values, hot spots, and prices for configured items.
mnItemNumberTableSegment6	SIT6	MATH_NUMERIC	NONE	NONE
A number that the system assigns to an item. It can be in short, long, or third item number format.
szTableSegmentBranch6	TMC6	char	NONE	NONE
The branch/plant of the configured item for which the segment is a key to the configured table.
mnNumberSegmentNo7	PEL7	MATH_NUMERIC	NONE	NONE
A number that identifies a key to the table. This number is based on the segments that you defined for a configured item. Configured table processing references segment numbers and their associated values to define component parts, calculated values, hot spots, and prices for configured items.
mnItemNumberTableSegment7	SIT7	MATH_NUMERIC	NONE	NONE
A number that the system assigns to an item. It can be in short, long, or third item number format.
szTableSegmentBranch7	TMC7	char	NONE	NONE
The branch/plant of the configured item for which the segment is a key to the configured table.
mnNumberSegmentNo8	PEL8	MATH_NUMERIC	NONE	NONE
A number that identifies a key to the table. This number is based on the segments that you defined for a configured item. Configured table processing references segment numbers and their associated values to define component parts, calculated values, hot spots, and prices for configured items.
mnItemNumberTableSegment8	SIT8	MATH_NUMERIC	NONE	NONE
A number that the system assigns to an item. It can be in short, long, or third item number format.
szTableSegmentBranch8	TMC8	char	NONE	NONE
The branch/plant of the configured item for which the segment is a key to the configured table.
mnNumberSegmentNo9	PEL9	MATH_NUMERIC	NONE	NONE
A number that identifies a key to the table. This number is based on the segments that you defined for a configured item. Configured table processing references segment numbers and their associated values to define component parts, calculated values, hot spots, and prices for configured items.
mnItemNumberTableSegment9	SIT9	MATH_NUMERIC	NONE	NONE
A number that the system assigns to an item. It can be in short, long, or third item number format.
szTableSegmentBranch9	TMC9	char	NONE	NONE
The branch/plant of the configured item for which the segment is a key to the configured table.
mnNumberSegmentNo10	PEL0	MATH_NUMERIC	NONE	NONE
A number that identifies a key to the table. This number is based on the segments that you defined for a configured item. Configured table processing references segment numbers and their associated values to define component parts, calculated values, hot spots, and prices for configured items.
mnItemNumberTableSegment10	SIT0	MATH_NUMERIC	NONE	NONE
A number that the system assigns to an item. It can be in short, long, or third item number format.
szTableSegmentBranch10	TMC0	char	NONE	NONE
The branch/plant of the configured item for which the segment is a key to the configured table.
mnNumberSegmentNo11	PEL11	MATH_NUMERIC	OPT	NONE
A number that identifies a key to the table. This number is based on the segments that you defined for a configured item. Configured table processing references segment numbers and their associated values to define component parts, calculated values, hot spots, and prices for configured items.
mnItemNumberTableSegment11	SIT11	MATH_NUMERIC	OPT	NONE
A number that the system assigns to an item. It can be in short, long, or third item number format.
szTableSegmentBranch11	TMC11	char	OPT	NONE
The branch/plant of the configured item for which the segment is a key to the configured table.
mnNumberSegmentNo12	PEL12	MATH_NUMERIC	OPT	NONE
A number that identifies a key to the table. This number is based on the segments that you defined for a configured item. Configured table processing references segment numbers and their associated values to define component parts, calculated values, hot spots, and prices for configured items.
mnItemNumberTableSegment12	SIT12	MATH_NUMERIC	OPT	NONE
A number that the system assigns to an item. It can be in short, long, or third item number format.
szTableSegmentBranch12	TMC12	char	OPT	NONE
The branch/plant of the configured item for whihc the segment is a key to the configured table.
mnNumberSegmentNumber13	PEL13	MATH_NUMERIC	OPT	NONE
A number that identifies a key to the table. This number is based on the segments that you defined for a configured item. Configured table processing references segment numbers and their associated values to define component parts, calculated values, hot spots, and prices for configured items.
mnItemNumberTableSegment13	SIT13	MATH_NUMERIC	OPT	NONE
A number that the system assigns to an item. It can be in short, long, or third item number format.
szTableSegmentBranch13	TMC13	char	OPT	NONE
The branch/plant of the configured item for which the segment is a key to the configured table.
mnNumberSegmentNo14	PEL14	MATH_NUMERIC	OPT	NONE
A number that identifies a key to the table. This number is based on the segments that you defined for a configured item. Configured table processing references segment numbers and their associated values to define component parts, calculated values, hot spots, and prices for configured items.
mnItemNumberTableSegment14	SIT14	MATH_NUMERIC	OPT	NONE
A number that the system assigns to an item. It can be in short, long, or third item number format.
szTableSegmentBranch14	TMC14	char	OPT	NONE
The branch/plant of the configured item for which the segment is a key to the configured table.
mnNumberSegmentNo15	PEL15	MATH_NUMERIC	OPT	NONE
A number that identifies a key to the table. This number is based on the segments that you defined for a configured item. Configured table processing references segment numbers and their associated values to define component parts, calculated values, hot spots, and prices for configured items.
mnItemNumberTableSegment15	SIT15	MATH_NUMERIC	OPT	NONE
A number that the system assigns to an item. It can be in short, long, or third item number format.
szTableSegmentBranch15	TMC15	char	OPT	NONE
The branch/plant of the configured item for which the segment is a key to the configured table.
mnNumberSegmentNo16	PEL16	MATH_NUMERIC	OPT	NONE
A number that identifies a key to the table. This number is based on the segments that you defined for a configured item. Configured table processing references segment numbers and their associated values to define component parts, calculated values, hot spots, and prices for configured items.
mnItemNumberTableSegment16	SIT16	MATH_NUMERIC	OPT	NONE
A number that the system assigns to an item. It can be in short, long, or third item number format.
szTableSegmentBranch16	TMC16	char	OPT	NONE
The branch/plant of the configured item for which the segment is a key to the configured table.
mnNumberSegmentNo17	PEL17	MATH_NUMERIC	OPT	NONE
A number that identifies a key to the table. This number is based on the segments that you defined for a configured item. Configured table processing references segment numbers and their associated values to define component parts, calculated values, hot spots, and prices for configured items.
mnItemNumberTableSegment17	SIT17	MATH_NUMERIC	OPT	NONE
A number that the system assigns to an item. It can be in short, long, or third item number format.
szTableSegmentBranch17	TMC17	char	OPT	NONE
The branch/plant of the configured item for which the segment is a key to the configured table.
mnNumberSegmentNo18	PEL18	MATH_NUMERIC	OPT	NONE
A number that identifies a key to the table. This number is based on the segments that you defined for a configured item. Configured table processing references segment numbers and their associated values to define component parts, calculated values, hot spots, and prices for configured items.
mnItemNumberTableSegment18	SIT18	MATH_NUMERIC	OPT	NONE
A number that the system assigns to an item. It can be in short, long, or third item number format.
szTableSegmentBranch18	TMC18	char	OPT	NONE
The branch/plant of the configured item for which the segment is a key to the configured table.
mnNumberSegmentNo19	PEL19	MATH_NUMERIC	OPT	NONE
A number that identifies a key to the table. This number is based on the segments that you defined for a configured item. Configured table processing references segment numbers and their associated values to define component parts, calculated values, hot spots, and prices for configured items.
mnItemNumberTableSegment19	SIT19	MATH_NUMERIC	OPT	NONE
A number that the system assigns to an item. It can be in short, long, or third item number format.
szTableSegmentBranch19	TMC19	char	OPT	NONE
The branch/plant of the configured item for which the segment is a key to the configured table.
mnNumberSegmentNo20	PEL20	MATH_NUMERIC	OPT	NONE
A number that identifies a key to the table. This number is based on the segments that you defined for a configured item. Configured table processing references segment numbers and their associated values to define component parts, calculated values, hot spots, and prices for configured items.
mnItemNumberTableSegment20	SIT20	MATH_NUMERIC	OPT	NONE
A number that the system assigns to an item. It can be in short, long, or third item number format.
szTableSegmentBranch20	TMC20	char	OPT	NONE
The branch/plant of the configured item for which the segment is a key to the configured table.
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.
jdDateUpdated	UPMJ	JDEDATE	OPT	NONE
The date that specifies the last update to the file record.
mnTimeOfDay	TDAY	MATH_NUMERIC	OPT	NONE
The computer clock in hours:minutes:seconds.
szUserId	USER	char	OPT	NONE
The code that identifies a user profile.
szProgramId	PID	char	OPT	NONE
The number that identifies the batch or interactive program (batch or interactive object). For example, the number of the Sales Order Entry interactive program is P4210, and the number of the Print Invoices batch process report is R42565. The program ID is a variable length value. It is assigned according to a structured syntax in the form TSSXXX, where: T The first character of the number is alphabetic and identifies the type, such as P for Program, R for Report, and so on. For example, the value P in the number P4210 indicates that the object is a program. SS The second and third characters of the number are numeric and identify the system code. For example, the value 42 in the number P4210 indicates that this program belongs to system 42, which is the Sales Order Processing system. XXX The remaining characters of the numer are numeric and identify a unique program or report. For example, the value 10 in the number P4210 indicates that this is the Sales Order Entry program.
szWorkStationId	JOBN	char	OPT	NONE
The code that identifies the work station ID that executed a particular job.
szErrorMessageID	DTAI	char	OPT	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.
cSuppressErrorMessage	SUPPS	char	OPT	NONE
A flag indicating whether or not runtime error messaging will occur when an error message is issued from a business function. 0 = allow runtime error message handling. 1 = suppress runtime error message handling.
szUserReservedCode	URCD	char	OPT	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	OPT	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	OPT	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	OPT	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	OPT	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.
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.

Related Functions

None

Related Tables

None