MRPClearTimeSeriesMessagesOrPegg

MRP, Clear TimeSeries, Messages Or Pegging Qtys

Minor Business Rule

Object Name: B3400430

Parent DLL: CMFG

Location: Client/Server

Language: C

1.Functional Description

1.1Purpose
The purpose of this function is to delete records from various Manufacturing tables including F3411
(Messages), F3412 (Pegging), and F3413 (Time Series).  The user passes the name of the file to delete
records from and a flag indicating which records to delete.  If Delete Flag = '1', all records are
removed from the specified table.  If Delete Flag = '0', the function deletes records matching the input
Item Number and Branch key values. If Delete Flag = '2', the function deletes records matching the
Branch key value.

1.2Setup Notes and Prerequisites
• None.
'b7'b7'b7'b7'b7
1.3Special Logic
None.

2.Technical Specifications
Open the table specified by Table Name
If the open failed
Set Error Message ID = '3143'.  If Suppress Error Message <> '1', SetGBRError with code
'3143'.
Exit the function
EndIf

If Delete Flag = '1'
Delete all records from the selected table
Else
If Table is F3411 then

Delete records from F3411 using input ITM, MCU, MMHCLD <> 'Z' And MMMSGT <> 'M'
(when Delete Flag = '0')
Delete records from F3411 using input MCU, MMHCLD <> 'Z' And MMMSGT <> 'M'
(when Delete Flag = '2')

Else
Delete records from the table using the input ITM and MCU as key values

           (when Delete Flag = '0')

Delete records from the table using the input MCU as key value

           (when Delete Flag = '2')

End If
EndIf
If the delete operation failed
Set Error Message ID = '3143'.  If Suppress Error Message <> '1', SetGBRError with code
'3143'.
EndIf

Data Structure

D3400430 - MRP, Clear TimeSeries, Messages Or Pegging Qtys

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

mnShortItemNumber 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

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

szTableName OBJP char NONE NONE

Primary object in a relationship of two objects.

cDeleteFlag EV01 char NONE NONE

An option that specifies the type of processing for an event.

cSuppressErrorMessage EV02 char NONE NONE

An option that specifies the type of processing for an event.

cErrorCode ERRC char NONE NONE

This error code indicates if any errors occurred during the creation of the Trip Document Detail (F4914) records by the Delivery Document
Set Server program (XT4914).

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.

cNumberOfKeys EV03 char OPT NONE

A radio button that specifies the level at which trace/track result is to be displayed.  Select the Detail to display all transactions except IB, IX,
and IZ types.  Or, select Derivative Lots Only to display only those transactions that may have created new derivative lot.

Related Functions

None

Related Tables

F3411 MPS/MRP/DRP Message File

F3412 MPS/MRP/DRP Lower Level Requirements File

F3413 MPS/MRP/DRP Summary File

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
mnShortItemNumber	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
szBranch	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.
szTableName	OBJP	char	NONE	NONE
Primary object in a relationship of two objects.
cDeleteFlag	EV01	char	NONE	NONE
An option that specifies the type of processing for an event.
cSuppressErrorMessage	EV02	char	NONE	NONE
An option that specifies the type of processing for an event.
cErrorCode	ERRC	char	NONE	NONE
This error code indicates if any errors occurred during the creation of the Trip Document Detail (F4914) records by the Delivery Document Set Server program (XT4914).
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.
cNumberOfKeys	EV03	char	OPT	NONE
A radio button that specifies the level at which trace/track result is to be displayed. Select the Detail to display all transactions except IB, IX, and IZ types. Or, select Derivative Lots Only to display only those transactions that may have created new derivative lot.

F3411 MPS/MRP/DRP Message File
F3412 MPS/MRP/DRP Lower Level Requirements File
F3413 MPS/MRP/DRP Summary File