F3293InsertAIREditGroup

F3293 Insert AIR Edit Group

Major Business Rule

Object Name: B3200120

Parent DLL: CMFG

Location: Client/Server

Language: C

1.Functional Description

1.1Purpose
This function is used to insert a new edit group into a set of Assembly Inclusion Rules.  All rules
from the insertion point (i.e. beginning rule number passed in through input parameters) are "moved
down", i.e. rule number is incremented by 1 to make room for the new edit group.  Any associated Rule
Values (F32921) or Rule Ranges (F32922) rows are also updated to the new rule number.

To perform this insertion process, the Assembly Inclusion Rules table (F3293) is read from the last
rule for the specified Configured Item "backwards" to the insertion point in the rule group; an index
with the rule number and rule sequence number sorted in descending order is used for this retrieval
process.

1.2Setup Notes and Prerequisites
No special setup for this function.

1.3Special Logic
There is no special logic within this function.

2.Technical Specifications

2.4Processing
A. Using the key values passed in as input parameters, read the F3293 table from the last rule for
the Branch/Configured Item/Rule Type to the beginning rule number passed in from the calling program.
Key #7 (KIT, MCU, ATOT, ATO# (descending), ATOS (descending)) should be used for retrieving these
rows in this "reverse" sequence.
B. For each record retrieved (excluding the rules matching the beginning rule number), increment
the rule number by 1.  Read F3293 with the new key value.  If the record exists, overwrite the record;
if the record does not already exist on F3293, insert a new F3293 row into the table.
("B3200090-Update Assembly Inclusion Rule" business function is used for this update).
C. At an edit group break, any "leftover" rules (i.e. rules which were not overwritten) from the
previous edit group should be deleted using the B3200130-Delete Assembly Inclusion Rule business
function.
D. For each F3293 row processed, select all rows from the Rule Values (F32921) table with the same
Configured Item, Branch/Plant, Rule Type and Rule Number if the Selection Values (ATIV) column
contains *VALUE or *VALUES.  Write new values records for all rows retrieved with the new rule number using
the F32921 Update Rule Values business function (B3200160).  Values records for the "old" rule number
should be deleted after the new records are written.
E. For each F3293 row processed, select all rows from the Rule Ranges (F32922) table with the same
Configured Item, Branch/Plant, Rule Type and Rule Number if the Selection Values (ATIV) column
contains *RANGE or *RANGES.  Write new ranges records for all rows retrieved with the new rule number using
the F32922 Update Rule Ranges business function (B3200170). Ranges records for the "old" rule number
should be deleted after the new records are written.

Data Structure

D3200120 - F3293 Insert AIR Edit Group

Parameter Name Data Item Data Type Req/Opt I/O/Both

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

szBranchPlant MCU char NONE 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.

cRuleType ATOT char NONE NONE

A value that identifies whether the resulting value of the assembly inclusion rule is a part number, price, routing operation, or calculated
value. The valid values are:    P Part List    Q Work Order Component    C Calculation    H Hot Spot    X Price/Cost Adjustment    R Route Sheet

mnBegRuleNumber ATO# MATH_NUMERIC NONE NONE

The number associated with a set of cross-segment editing rules or assembly inclusion rules.

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

Related Functions

B3200090 F3293 Update Assembly Inclusion Rule

B3200130 F3293 Delete Assembly Inclusion Rule

B3200160 F32921 Update Rule Values

B3200170 F32922 Update Rule Ranges

Related Tables

F32921 Cross Segment Editing Rules - Values

F32922 Cross Segment Editing Rules - Range

F3293 Assembly Inclusions Rules

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
mnConfiguredItemShort	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.
szBranchPlant	MCU	char	NONE	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.
cRuleType	ATOT	char	NONE	NONE
A value that identifies whether the resulting value of the assembly inclusion rule is a part number, price, routing operation, or calculated value. The valid values are: P Part List Q Work Order Component C Calculation H Hot Spot X Price/Cost Adjustment R Route Sheet
mnBegRuleNumber	ATO#	MATH_NUMERIC	NONE	NONE
The number associated with a set of cross-segment editing rules or assembly inclusion rules.
cSuppressErrorMessages	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.

B3200090 F3293 Update Assembly Inclusion Rule
B3200130 F3293 Delete Assembly Inclusion Rule
B3200160 F32921 Update Rule Values
B3200170 F32922 Update Rule Ranges

F32921 Cross Segment Editing Rules - Values
F32922 Cross Segment Editing Rules - Range
F3293 Assembly Inclusions Rules