F3293DeleteAssemblyInclusion

F3293 Delete Assembly Inclusion Rule

Major Business Rule

Object Name: B3200130

Parent DLL: CMFG

Location: Client/Server

Language: C

1.Functional Description

1.1Purpose
This function will delete one or more rows from the the following three tables:

a)Assembly Inclusion Rules table (F3293)

b) Rule Values (F32921)
c) Rule Ranges (F32922)

Rows can be deleted by one of the following options:
a) Configured Item, Branch/Plant, Rule Type
b) Configured Item, Branch/Plant, Rule Type, Rule Number
c) Configured Item, Branch/Plant, Rule Type, Rule Number, range of Rule Sequence Numbers
Note: The Beginning and Ending Rule Sequence Numbers can contain the same value in order to delete
one specific row.

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. If the Beginning/Ending Sequence Number (and Rule Number) have been specified, delete all rows
within the range of sequence numbers (including the beginning and ending sequence numbers) for the
Configured Item, Branch/Plant, Rule Type, Rule Number specified. Rows are deleted from the following tables:

• Assembly Inclusion Rules (F3293)
• Rule Values (F32921)
• Rule Ranges (F32922)

B. If the Beginning/Ending Sequence Numbers have not been specified:
1.If the Rule number has been specified, delete all rows matching the specified Configured Item,
Branch/Plant, Rule Type, and Rule Number.
2. If the Rule number has not been specified, delete all rows matching the
specified Configured Item,Branch/Plant, and Rule Type.

This function deletes multiple rows on the Assembly Inclusion Rules Table (F3293) based on key values
passed in as input parameters.

Data Structure

D3200130 - F3293 Delete Assembly Inclusion Rule

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
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.
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.
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
mnRuleNumber	ATO#	MATH_NUMERIC	NONE	NONE
The number associated with a set of cross-segment editing rules or assembly inclusion rules.
mnBegSeqNumber	ATOS	MATH_NUMERIC	NONE	NONE
The Sequence number is the rule number within an edit group of cross-segment editing rules or assembly inclusion rules. You can insert a line within a rule to assign a new sequence number.
mnEndSeqNumber	RCK9	MATH_NUMERIC	NONE	NONE
This field is used to create a unique key within a file. If you are using a program which will allow you to resequence the records, we recommend you use one of the following data dictionary items: DSS5, DSS7, DSS9.
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

Related Tables

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