F37021Delete

F37021and F3702 Table I/O

Minor Business Rule

Object Name: N3700280

Parent DLL: CMFG

Location: Client/Server

Language: NER

Purpose:

• Delete Specification detail records from F37021

Setup Notes:
• Used to replace table I/O in the application on 'Delete All'

Special Logic:
• none

Processing:
If Status = Blank, Null or '1'
Perform Select and Fetch on F37021 with a key of Spec, Branch/Plant and Status
Else If Status = '2' or '3'
Perform Fetch Single on F37021 with a key of Spec, Branch/Plant, Status, Effective
Thru and Quality Table Sequence Number
Endif
^

Data Structure

D3700280B - F37021 Delete

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
szSpecification	QSPC	char	REQ	INPUT
The unique identification for a set of tests which need to be performed together. For example: F-156 - FDA Specification 156 SP34 - Specification 34
szCostCenter	MCU	char	REQ	INPUT
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.
cErrorCode	EV01	char	OPT	OUTPUT
An option that specifies the type of processing for an event.
cStatus	STAW	char	OPT	BOTH
A user-defined code (00/WS) that indicates the approval status.
jdEffectiveThruDate	EFFT	JDEDATE	OPT	BOTH
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.
mnQualityTableSequenceNumber	QTSN	MATH_NUMERIC	OPT	BOTH
A control number that uniquely identifies master table records in the Quality Management system. The system automatically generates this number.

Related Functions

Related Tables

F37021FetchSingle

F37021FetchSingle

F37021and F3702 Table I/O

Minor Business Rule

Object Name: N3700280

Parent DLL: CMFG

Location: Client/Server

Language: NER

Purpose:

• Select a single record from the Specification detail file, F37021. Most often used to check if a
record is valid for delete, if found it can not be deleted.

Setup Notes:
• Used to replace table I/O in applications.

Special Logic:
• none

Processing:

Perform Fetch Single on F37021 with a key of Spec, Branch/Plant and Status
^

Data Structure

D3700280A - F37021 Fetch Single

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
szTestID	QTST	char	REQ	INPUT
The unique identification for a test to be performed on an item. For example: COL Color test DENS Density Test CL-2 Clarity Test
szCostCenter2	MCU2	char	REQ	INPUT
An accounting entity, such as a profit center, department, warehouse location, job, project, workcenter, and so on, required for management reporting.
cErrorCode	EV01	char	OPT	OUTPUT
An option that specifies the type of processing for an event.
cStatus	STAW	char	OPT	BOTH
A user-defined code (00/WS) that indicates the approval status.

Related Functions

Related Tables

F3702Delete

F37021and F3702 Table I/O

Minor Business Rule

Object Name: N3700280

Parent DLL: CMFG

Location: Client/Server

Language: NER

Purpose:

• Delete Specification header records from F3702

Setup Notes:
• Used to replace table I/O in the application on 'Delete All'

Special Logic:
• none

Processing:
If Status = Blank, Null or '1'
Perform Select and Fetch on F37021 with a key of Spec, Branch/Plant and Status
Else If Status = '2' or '3'
Perform Fetch Single on F37021 with a key of Spec, Branch/Plant, Status, Effective
Thru and Quality Table Sequence Number
Endif
^

Data Structure

D3700280C - F3702 Delete

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
szSpecification	QSPC	char	REQ	INPUT
The unique identification for a set of tests which need to be performed together. For example: F-156 - FDA Specification 156 SP34 - Specification 34
szCostCenter	MCU	char	REQ	INPUT
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.
cErrorCode	EV01	char	OPT	OUTPUT
An option that specifies the type of processing for an event.
cStatus	STAW	char	OPT	BOTH
A user-defined code (00/WS) that indicates the approval status.
jdEffectiveThruDate	EFFT	JDEDATE	OPT	BOTH
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.
mnQualityTableSequenceNumber	QTSN	MATH_NUMERIC	OPT	BOTH
A control number that uniquely identifies master table records in the Quality Management system. The system automatically generates this number.

Related Functions

Related Tables