F37021InsertDeleteSpecDetail

F37021 Insert/Delete Specification Detail - Workflow

Minor Business Rule

Object Name: N3700400

Parent DLL: CMFG

Location: Client/Server

Language: NER

Purpose:
Called from N3700330 if workflow is on to add/update/delete pending detail records.

Setup Notes:
Called from F37021 Update Specification Detail (N3700330).

Special Logic:
none

Function Outline:
//
VA evt_cApprovedStatus_STAW = " "
VA evt_cPendingStatus_STAW = "1"
VA evt_cHistoryStatus_STAW = "2"
VA evt_cRejectedStatus_STAW = "3"
//
//      Approved
//
If BF cApprovalActionCode is equal to "A"
//
//      ****  Additions and Changes*****
//
If BF cActionCode2 is equal to "A" Or BF cActionCode2 is equal to "1" Or BF cActionCode2 is equal
to "C" Or BF cActionCode2 is equal to "2"
If BF cActivateLogging is equal to "1"
Log History Records - F37021
//
//      Add Active Record
//
VA evt_mnQualityTableSeqNum_QTSN = "0"
Dates, Verify Effective Dates
F37021.Insert
Else
//
//     Delete Pending and Current Active Records
//
F37021.Delete
If BF cActionCode2 is equal to "C" Or BF cActionCode2 is equal to "2"
F37021.Delete
End If
//
//      Add Active Record
//
Dates, Verify Effective Dates
F37021.Insert
//      End Activate Logging
End If
//      End Add
End If
//
//      ****  Deletes ****
//
If BF cActionCode2 is equal to "3" Or BF cActionCode2 is equal to "D"
If BF cActionCode2 is equal to "1"
Log History Records - F37021
Else
//
//     Delete Current Active Record
//
F37021.Delete
//
//     Delete Current Pending Record
//
F37021.Delete
End If
End If
End If
//
//      Rejected
//
If BF cApprovalActionCode is equal to "R"
//
//      Delete Pending Record
//
F37021.Delete
//
//      Write Rejected Record
//
BF jdEffectiveFromDate = date_today( )
BF jdEffectiveThruDate = date_today( )
F37021.Insert
//      End Rejected
End If

^

Data Structure

D3700400 - F37021 Insert/Delete Specification Detail - Workflow

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
szSpecification	QSPC	char	OPT	NONE
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	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.
cStatus9	STAW	char	OPT	NONE
A user-defined code (00/WS) that indicates the approval status.
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.
mnQualityTableSequenceNumber	QTSN	MATH_NUMERIC	OPT	NONE
A control number that uniquely identifies master table records in the Quality Management system. The system automatically generates this number.
mnTestSortSequenceNumber	TSRT	MATH_NUMERIC	OPT	NONE
A number used to determine the sort order of tests and specifications within preference profiles (item/test specifications).
szTestID	QTST	char	OPT	NONE
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	OPT	NONE
An accounting entity, such as a profit center, department, warehouse location, job, project, workcenter, and so on, required for management reporting.
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.
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.
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.
mnUniqueKeyIDInternal	UKID	MATH_NUMERIC	OPT	NONE
This field is a unique number used to identify a record in a file.
cActionCode2	ACTN	char	OPT	NONE
A code that specifies the action that is performed. Valid values are: A Add C Change
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.
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.
szWorkStationId	JOBN	char	OPT	NONE
The code that identifies the work station ID that executed a particular job.
cActivateLogging	EV01	char	OPT	NONE
An option that specifies the type of processing for an event.
cApprovalActionCode	APPRACT	char	OPT	NONE
A code that determines whether a workflow recipient has accepted or rejected a workflow task that has been submitted for approval. Valid values are: A Accept. R Reject.
mnDeleteHistorySequenceNumber	QTSN	MATH_NUMERIC	OPT	NONE
A control number that uniquely identifies master table records in the Quality Management system. The system automatically generates this number.
cResequenceTestSortSequence	EV01	char	OPT	NONE
An option that specifies the type of processing for an event.
mnResequenceCounter	TSRT	MATH_NUMERIC	OPT	NONE
A number used to determine the sort order of tests and specifications within preference profiles (item/test specifications).
mnQualityMgmtAB2	QMAB2	MATH_NUMERIC	OPT	NONE
Reserved for Quality Management.
szQualityMgmtCode2	QMCD2	char	OPT	NONE
Reserved for Quality Management.
jdQualityMgmtDate2	QMDT2	JDEDATE	OPT	NONE
Reserved for Quality Management.
mnQualityMgmtNumeric2	QMNUM2	MATH_NUMERIC	OPT	NONE
Reserved for Quality Management.
szQualityMgmtReference2	QMRF2	char	OPT	NONE
Reserved for Quality Management.

Related Functions

None

Related Tables

None