F30006EditLine

F30006 Work Center Master Bsfn

Master Business Function

Object Name: N3001840

Parent DLL: CMFGBASE

Location: Client/Server

Language: NER

1.Functional Description
1.1Purpose
This function will:
•

Perform field level edits on input parameters (when full or partial edits requested).
• Perform standard data dictionary and UDC edits (if full edits requested) on input parameters.
• Perform the appropriate action (Add, Update, or Delete) to the Work Center Master table (F30006) and
Work Center Tag File (F30006T).
• If interoperability is enabled, outbound Add, Update, or Delete transactions are written to the Work
Center transaction file (F30006Z1).

'b7
1.2Setup Notes and Prerequisites

1.3Special Logic

• Includes logic for repetitive manufacturing: validation of capacity and shift fields.
• This function updates F30006 using values passed into the data structure.
• If the data structure field TYTN is greater than blank, outbound interoperability transactions are
written to F30006Z1.
'b7
2.Technical Specifications
2.4Processing
Main Processing:

1.Initialize the following fields:

a. BF szErrorMessageID = "          "

b. BF cErrorConditions = " "

c.If Process Edits-parm is blank, assign a default value of '2' (i.e. Full edits).
d.If Action Code-parm is equal to 1, assign a value of 'A'.

If Action Code-parm is equal to 2, assign a value of 'C'.
If Action Code-parm is equal to 3, assign a value of 'D'.

2.Validate that the F30006 Work Center (MCU) and the F30006 Branch (MMCU) key fields are not
blank.

3.Validate the action code and validate the requested action against F30006.  A record should not
already exist if an "add" is being performed; an update or delete must have an existing record on
F30006.

F30006 Get WC Master Row (B3000400):

           BF szWorkCenter -> szBusinessUnit
     BF szBranch -> szBranch
           "1" -> cCallType
           "1" -> cSuppressErrorMessages

     VA evt_szErrorMsgID_DTAI <- szErrorMessageID

4.Perform the following edit processing based on the ActionCode-parm (see 6. Thru 8.  below).

5.Set the ErrorConditions-parm based on errors encountered:

If hard errors occur, set the error code to '1'.

Add/Update Edits:

6.If Process Edits is '1' or '2':

a.If the Location-parm (LOCN) has been passed in as input,

LocationBranch-parm (LOMC)is required. Validate that they are both populated;  set error "024U"
if only one is populated.

b.If the DispatchGroup-parm is blank, default this field to the WorkCenter-parm value.

c.If the Location is not blank:

i.Validate the location:

Format Location (B4000310):

Cost Center<=LocationBranch-parm
Display Format Locn<=Location-parm
File Format Location=>FileLocation (WF)
Mode<='2'
Validate<='1'

d. Validate Shift Hours are valid for the Branch:

i. If branch is blank, set an error if WRH2-parm, WHR3-parm, WRH4-parm, WRH5-parm, or
WHR6-parm is not blank.
ii. If branch is not blank, fetch the manufacuring constant shift codes for the branch.
Get Manufacturing Constants (B3000450):
     BF szBranch -> szBranchPlant

     VA evt_szErrorMsgID_DTAI <- szErrorMessageId

                 VA evt_cMfgCnstShiftCode1 <- cShiftCode
                 VA evt_cMfgCnstShiftCode2 <- cShift2Code
                 VA evt_cMfgCnstShiftCode3 <- cShift3Code
                 VA evt_cMfgCnstShiftCode4 <- cShift4Code
                 VA evt_cMfgCnstShiftCode5 <- cShift5Code

     VA evt_cMfgCnstShiftCode6 <- cShift6Code
If SHFT is blank, repeat i.
iii. If SHFT is not blank, set an error "038P" :

For WRH2-parm if VA evt_cMfgCnstShiftCode2 is blank
For WRH3-parm if VA evt_cMfgCnstShiftCode3 is blank
For WRH4-parm if VA evt_cMfgCnstShiftCode4 is blank
For WRH5-parm if VA evt_cMfgCnstShiftCode5 is blank

For WRH6-parm if VA evt_cMfgCnstShiftCode6 is blank

e.Validate that total shift hours per day do not exceed 24, issue a warning "038F" if so.

f.Validate Capacity

i.If LIC-parm is equal to '1', set error "038L" if CAPU-parm and/or CPSD-parm are not
entered.
ii.If CAPU-parm is entered set error "038L" if CPSD-parm is not entered, and vice versa.
iii.If CPMI-parm or CPMA-parm is entered, set error "038L" if CAPU-parm and/or CPSD-parm
are not entered.
iv.If CPMA-parm is less than CPSD-parm or less than CPMI-parm, set error "038L".

7.If Process Edits = '2' (full edits), perform standards "tool" editing (DD and UDC edits):

a.Validate the BranchPlant-parm value against the Business Unit Master table (F0006); set
error "3091" if the BranchPlant-parm is not a valid business unit:

F0006 Check Business Unit Existence (B5100003):

Business Unit<=BranchPlant-parm

Found Flag=>Valid Business Unit (WF)

a.Validate the WorkCenter-parm value against the Business Unit Master table (F0006); set
error "3091" if the WorkCenter-parm is not a valid business unit:

F0006 Check Business Unit Existence (B5100003):

Business Unit<=WorkCenter-parm
Found Flag=>Valid Business Unit (WF)

b.If the DispatchGroup-parm is not blank, validate the value against the Business Unit
Master table (F0006); set error "3091" if the DispatchGroup-parm is not a valid business unit:

F0006 Check Business Unit Existence (B5100003):

Business Unit<=DispatchGroup-parm
Found Flag=>Valid Business Unit (WF)

c.If the LocationBranch-parm is not blank, validate the value against the Business Unit
Master table (F0006); set error "3091" if the LocationBranch-parm is not a valid business unit:

F0006 Check Business Unit Existence (B5100003):

Business Unit<=LocationBranch-parm
Found Flag=>Valid Business Unit (WF)

d.On all other input parameters which are F30006 table fields, perform standard data
dictionary edits, including UDC edits,  and return any default values.  If the function does not
return successful, set error "0025" .

Data Dictionary Validation (BDDVAL):

Data Item<=Data item alias, e.g. "CRTW"
Everest Type<=1 if character;  9 if numeric

2 if string;  11 if date

Character or Numeric<=input parameter, e.g.

CritcalWorkCenter-parm

Delete Edits:

8.Verify that the work center being deleted is not being used in a work order routing (F3003) or
a manufacturing routing (F3112).

a.Check Routing Master (F3003).  Set error "4847" if the ErrorMsgId (WF) is blank and the
EndOfFile(WF) = '0'  (i.e. record exists on F3003) after this call.  The function must be called
twice; once to perform the read and once to release the pointer to the table row:

Get Next Routing (B3001390):

Work Center<=WorkCenter-parm
Request Type<='1'
Error Message ID=>ErrorMsgId (WF)
Index<='3'
Keys<='1'
End of File=>EndOfFile (WF)
Return Field Values<='0'
Suppress Error Messages<='1'
hRequestF3003<=RequestF3003 (WF)

Get Next Routing (B3001390):

Request Type<='3'
Suppress Error Messages<='1'
hRequestF3003<=RequestF3003 (WF)

b.Check Manufacturing Routing Table (F3112). Set error "4847" if the ErrorMsgId (WF) is
blank after this call (i.e. record is found on F3112):

Get Routing Instructions Data (B3100510):

Work Center<=WorkCenter-parm
Error Message ID=>ErrorMsgId (WF)
Index<='3'
Keys<='1'
Suppress Error Messages<='1'

Update tables:
If no errors were encountered so far:

1.Retrieve audit information:

Get Audit Information (B9800100):

User Name=>UserName (WF)
Date=>Date (WF)
Time=>Time (WF)
Workstation=>Workstation (WF)

2.Process the action against the Work Center Master table (F30006):

a.If the Location is not blank, format the display location to the file format:

Format Location (B4000310):

Cost Center<=LocationBranch-parm
Display Format Locn<=Location-parm
File Format Location=>FileLocation (WF)
Mode<='2'

b.If Action Code is "A",  add a new Work Center Master record (F30006) using values passed
into the data structure and the audit information. If the add was not successful, set error "0002".

Interoperability:

If szTransactionType-parm is greater than blank:

1. EDI Batch Number, Get Next Number (N4700060):

               VA evt_szBatchNumber <- szEdiBatchNumber

Get Next Transaction Number (B0000175):

                 "JDEWC" -> szTransactionType
                 VA evt_szUserID_USER -> szUserId
                 VA evt_szBatchNumber -> szBatchNumber
                 VA evt_szTransactionNumber <- szTransactionNumber
                 "1" -> cSuppressErrorMessage
2.Insert an outbound Add (Action code = A) transaction to the Work Center Transaction File
(F30006Z1).  If the insert was not successful, set error "0002".

3. Add Transaction To Subsystem Queue (B0000176):

                   "R00460" -> szUBEName
                   "ZJDE0001" -> szVersion
                   VA evt_szUserID_USER -> szUserId
                   VA evt_szBatchNumber -> szBatchNumber
                   VA evt_szTransactionNumber -> szTransactionNumber
                   "1" -> cSuppressErrorMessage
                   VA evt_mnLineNumber -> mnLineNumber
                   "JDEWC" -> szTransactionType
                   "" -> szDocumentType
                   VA evt_szActionCode -> szTransactionAction

c.If Action Code is "C",  Update the Work Center Master record (F30006) with values passed
into the data structure and audit information. If the update processing was not successful, set
error "0002".

Interoperability:

If szTransactionType-parm is greater than blank:

1. EDI Batch Number, Get Next Number (N4700060):

               VA evt_szBatchNumber <- szEdiBatchNumber

'1a'1a

Data Structure

D3001840B - F30006 Work Center MBF

2.1Parameters:  D3001840B

Data Item Data Structure Description     I/ORequiredNotes
ACTNAction Code                                     IYA or 1 = Add,
                                                                                                                C or 2 = Change/Update,
                                                                                                                D or 3 = Delete,
                                                                                                                I = Inquiry
EV01Process Edits                                     IN0 = No Editing
                                                                                                                1 = General Editing only
                                                                                                                2 = Full  Editing
(General plus all Data Dictionary and UDC editing)

EV01Suppress Error Msgs                   IN1 = Suppress messages
MCUWork Center                                   IYPrimary Key field (F30006)
MCUWDispatch Group                               I/ONWork Center field (F30006)
MMCUBranch Plant                               I/ONWork Center field (F30006)
LOCNLocation                                               I/ONWork Center field (F30006)
CRTWCritical work Center               I/ONWork Center field (F30006)
PILCPrime Load Code                               I/ONWork Center field (F30006)
BFPFPay Point Code                               I/ONWork Center field (F30006)
DEMODemo Calc Capactiy               I/ONWork Center field (F30006)
AN8Address Number                               I/ONWork Center field (F30006)
AVRTReplenishment Hours               I/ONWork Center field (F30006)
TRKSResource Offset                               I/ONWork Center field (F30006)
WRHRWork Hour Per Day               I/ONWork Center field (F30006)
WOREWork Center Efficiency                I/ONWork Center field (F30006)
WORUWork Center Utilization               I/ONWork Center field (F30006)
QMADNumber Of Employees                I/ONWork Center field (F30006)
NOMANumber Of Machines               I/ONWork Center field (F30006)
SQDStandard Queue Hours               I/ONWork Center field (F30006)
MOVDMove Hours                               I/ONWork Center field (F30006)
QUEDQueue Hours                               I/ONWork Center field (F30006)
SETCCrew Size                               I/ONWork Center field (F30006)
DL1Hours Per Shift 1                               I/ONWork Center field (F30006)
DL2Hours Per Shift 2                               I/ONWork Center field (F30006)
DL3Hours Per Shift 3                               I/ONWork Center field (F30006)
DE1Shift Start 1                               I/ONWork Center field (F30006)
DE2Shift Start 2                                I/ONWork Center field (F30006)
DE3Shift Start 3                               I/ONWork Center field (F30006)
DC1Shift Code 1                               I/ONWork Center field (F30006)
DC2Shift Code 2                               I/ONWork Center field (F30006)
DC3Shift Code 3                               I/ONWork Center field (F30006)
URDTUser Reserved Date               I/ONWork Center field (F30006)
URATUser Reserved Amount               I/ONWork Center field (F30006)
URABUser Reserved Number               I/ONWork Center field (F30006)
URRFUser Reserved Reference               I/ONWork Center field (F30006)
URCDUser Reserved Code               I/ONWork Center field (F30006)
PIDProgram ID                                   INCurrent program name
ERRCError Conditions                                  ONBlank = No errors
                                                                                                                1 = Errors found
DTAIError Message ID                                  ONError Message ID
TYTNType Transaction                                   INInteroperability Flag:
                                                                                                                Blank = Off, JDEWC = On
LICLine Cell Station Flag               I/ONRepetitive field (F30006T)
SHF2Work Hours Shift 2               I/ONRepetitive field (F30006T)
SHF3Work Hours Shift 3               I/ONRepetitive field (F30006T)
SHF4Work Hours Shift 4               I/ONRepetitive field (F30006T)
SHF5Work Hours Shift 5               I/ONRepetitive field (F30006T)
SHF6Work Hours Shift 6               I/ONRepetitive field (F30006T)
CAPUCapacity UOM                               I/ONRepetitive field (F30006T)
CPSDCapacity Standard               I/ONRepetitive field (F30006T)
CPMICapacity Minimum               I/ONRepetitive field (F30006T)
CPMACapacity Maximum               I/ONRepetitive field (F30006T)
SHMCShift Branch                               I/ONRepetitive field (F30006T)
EV01Write Before Images                   INInteroperability Flag:
                                                                                                                0 = After Images only
                                                                                                                1 = Before and After
                                                                                                                                                                                                                      Images

^

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

cActionCode ACTN char NONE NONE

^

cProcessEdits EV01 char NONE NONE

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

cSuppressErrorMsgs EV01 char NONE NONE

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

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

szDispatchGroup MCUW char NONE NONE

A category code used to group work centers within an overall business unit. For example, you can use this code to group similar machines
operating out of several work centers that report to one business unit.

szBranchPlant MMCU char NONE NONE

A code that represents a high-level business unit. Use this code to refer to a branch or plant that might have departments or jobs, which
represent lower-level business units, subordinate to it. For example:     o Branch/Plant (MMCU)     o Dept A (MCU)     o Dept B (MCU)     o Job 123
(MCU) Business unit security is based on the higher-level business unit.

szLocation LOCN char NONE NONE

The storage location from which goods will be moved.

cCriticalWorkCenter CRTW char NONE NONE

A code that indicates whether the work center is critical or not critical when the system calculates capacity. Valid values are: N Not a critical
work center. 1 A critical work center in calculating RRP only. 2 A critical work center in calculating RCCP and CRP. 3 A critical work center in
calculating RRP, RCCP, and CRP. The system also displays Type 3 work centers when you select Type 1 or Type 2 in this field. 4 Not a capacity
work center. The system does not include this work center in capacity planning. Note: The data selection is a system feature that processes
certain groups of information with the RRP, RCCP, and CRP programs.

cPrimeLoadCode PILC char NONE NONE

A code that determines if a work center is machine or labor intensive. The system also uses prime load codes in Resource Requirements
Planning and Capacity Requirements Planning calculations to develop load profiles. Valid codes are:    L Run labor hours only    M Machine
hours only    B Run labor plus setup labor hours    C Machine plus setup hours    O Other (will not generate resource units)

cPayPointCode BFPF char NONE NONE

A code that indicates whether a work center has labor, material, or both,backflushed through it when quantities are reported against
operations occurring in the work center. If you do not override the routing record, the system uses the work center value as the default. Valid codes
are:    0   Not a backflush work center    B Backflush material and labor    M Backflush material only    L Backflush labor only    P Preflush material
only

cDemoCalcCapacity DEMO char NONE NONE

Future use. A switch selecting either Demonstrated (D) or Calculated (C) capacity to use in CRP calculations for work center
capacity. Demonstrated Capacity is the proven capacity calculated from actual output performance data. This is usually the number of items produced times
standard hours per item. Calculated (or Rated) Capacity is the capacity calculated from such data as utilization, efficiency and planned
hours.

mnAddressNumber AN8 MATH_NUMERIC NONE NONE

A number that identifies an entry in the Address Book system, such as employee, applicant, participant, customer, supplier, tenant, or
location.

mnReplenishmentHours AVRT MATH_NUMERIC NONE NONE

The time required before a consuming location has a replacement kanban available from its supplying location. This value is used only for
kanban card processing in Shop Floor Management.

mnResourceOffset TRKS MATH_NUMERIC NONE NONE

A value used in the Resource Profile table (F3303) to determine the number of days that the actual use of a work center resource should be
offset from the forecasted need date.

mnWorkHourPerDay WRHR MATH_NUMERIC NONE NONE

The number of work hours that the manufacturing plant operates per day.

mnWorkCenterEfficiency WORE MATH_NUMERIC NONE NONE

A user defined value that indicates how efficiently a work center operates. This value usually refers to staff efficiency. When you enter a
value in this field, and the Modify Cost by Work Center Efficiency field in the Job Shop Manufacturing Constants table (F3009) is set to Y, the
system creates a new cost component (B4) from the cost calculated from the direct labor cost (B1). For example, if the constant is set to Y, the value
of this field is 80%, and the direct labor cost is 10, the system creates a B4 cost component for 2 in the Item Cost Component Add-Ons table
(F30026). The Refresh Resource Units program also uses this value as a default when calculating rated capacity. Enter percents as whole
numbers. For example, enter 80% as 80.00. Note: The system expects that the routing times entered for each operator are the actual times it
takes to complete an operation. Efficiency does not affect total cost. Efficiency does reassign some of the costs into different cost
components. Efficiency does not change the duration or backscheduling of a work order.

mnWorkCenterUtilization WORU MATH_NUMERIC NONE NONE

A percentage that indicates how intensively a work center is being used. This value usually refers to machine use. It is the ratio of the direct
time charged for production activities to the planned hours. The Refresh Resource Units program also uses this value as a default when
calculating rated capacity. Enter percents as whole numbers. For example, enter 80% as 80.00.

mnNumberOfEmployees QMAD MATH_NUMERIC NONE NONE

The normal number of employees in this work center. When you run the Work Center Resource Units Refresh program, the system
multiplies this number by the Number of Work Hours Per Day from the Manufacturing Constants table (F3009) to generate the total gross labor hours
available in the work center each day.

mnNumberOfMachines NOMA MATH_NUMERIC NONE NONE

The normal number of machines in this work center. When you run the Work Center Resource Units Refresh program, this number is
multiplied by the number of work hours per day from the Manufacturing Constants table (F3009) to generate the total gross machine hours available
in the work center each day.

mnStandardQueueHours SQD MATH_NUMERIC NONE NONE

Future Use The expected number of hours a job will wait in the queue at this work center before work on it begins.

mnMoveHours MOVD MATH_NUMERIC NONE NONE

The planned hours that are required to move the order from this operation to the next operation in the same work center. If the Routing
Master values are blank, the system retrieves the default value from the work order routing. However, the system uses these values only for
backscheduling variable leadtime items.

mnQueueHours QUED MATH_NUMERIC NONE NONE

The total hours that an order is expected to be in queue at work centers and moving between work centers. The system stores this value in
the Item Branch table (F4102). You can calculate this value using the Leadtime Rollup program or you can enter it manually. When you run the
Leadtime Rollup program, the system overrides manual entries and populates the table with calculated values.

mnCrewSize SETC MATH_NUMERIC NONE NONE

The number of people who work in the specified work center or routing operation. The system multiplies the Run Labor value in the Routing
Master table (F3003) by crew size during costing to generate total labor amounts. If the Prime Load Code is L or B, the system uses the total
labor hours for backscheduling. If the Prime Load Code is C or M, the system uses the total machine hours for backscheduling without
modification by crew size.

mnHoursPerShift1 DL1 MATH_NUMERIC NONE NONE

Future use This is the planned number of hours for the duration of shift 1 for this work center.

mnHoursPerShift2 DL2 MATH_NUMERIC NONE NONE

Future use This is the planned number of hours for the duration of shift 2 for this work center.

mnHoursPerShift3 DL3 MATH_NUMERIC NONE NONE

Future use This is the planned number of hours for the duration of shift 3 for this work center.

mnShiftStart1 DE1 MATH_NUMERIC NONE NONE

Future use. The demonstrated capacity for shift 1.

mnShiftStart2 DE2 MATH_NUMERIC NONE NONE

Future use. The demonstrated capacity for shift 2.

mnShiftStart3 DE3 MATH_NUMERIC NONE NONE

Future use The demonstrated capacity for shift 3.

cShift1Code DC1 char NONE NONE

A user defined code (00/SH) that identifies daily work shifts.

cShift2Code DC2 char NONE NONE

Future use. This is the planned number of standard hours available in this work center by multiplying number of machines or crew size by
planned hours for shift 2.

cShift3Code DC3 char NONE NONE

Future use. This is the planned number of standard hours available in this work center by multiplying number of machines or crew size by
planned hours for shift 3.

jdUserReservedDate URDT JDEDATE NONE 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 NONE 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.

mnUserReservedNumber URAB MATH_NUMERIC NONE 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.

szUserReservedReference URRF char NONE 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.

szUserReservedCode URCD char NONE 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.

szProgramId PID char NONE 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.

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

szTypeTransaction TYTN char OPT NONE

The qualifier used to identify a specific type of transaction.

cLinecellstationflag999 LIC char OPT NONE

A code that defines the type of work center. Valid values are :    0   Stand alone work center    1   Production line in a repetitive environment    2
  Production line in a Lean Environment

mnHoursWorkHoursShift29 WRH2 MATH_NUMERIC OPT NONE

The number of work hours that the manufacturing plant operates in shift 2.

mnHoursWorkHoursShift39 WRH3 MATH_NUMERIC OPT NONE

The number of work hours that the manufacturing plant operates in shift 3.

mnHoursWorkHoursShift49 WRH4 MATH_NUMERIC OPT NONE

The number of work hours that the manufacturing plant operates in shift 4.

mnHoursWorkHoursShift59 WRH5 MATH_NUMERIC OPT NONE

The number of work hours that the manufacturing plant operates in shift 5.

mnHoursWorkHoursShift69 WRH6 MATH_NUMERIC OPT NONE

The number of work hours that the manufacturing plant operates in shift 6.

szUMCapacityUOM CAPU char OPT NONE

A unit of measure that you use to express the capacity of a production line. Examples of units of measure include hours, number of
stampings, coats of paint, and so on. This item is used for repetitive processing only.

mnCapacityStandard CPSD MATH_NUMERIC OPT NONE

The standard capacity level at which a production line usually operates. Capacity is stated in units per hour. This level is used for repetitive
processing only.

mnCapacityMinimum CPMI MATH_NUMERIC OPT NONE

The lower limit of the capacity, beyond which the production line should not operate. Management sets this limit, based on factors such as
efficiencies, costs, and so on. Capacity is stated in units per hour. This limit is used for repetitive processing only.

mnCapacityMaximum CPMA MATH_NUMERIC OPT NONE

The upper limit of the capacity, beyond which a production line cannot produce. Capacity is stated in units per hour. This limit is used for
repetitive processing only.

cWriteBeforeImages EV01 char OPT NONE

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

szLocationBranch LOMC char OPT NONE

This is the branch plant of the location associated with the work center.

szWorkDayCalendarKey WDCK char OPT NONE

A code used to classify values within a calendar type. For example, if the calendar type is ROUTE, you can enter a code that specifies a
particular route, such as Daily or Weekend. Note: The system does not validate the code that you enter.

szWorkDayCalendarType WDCT char OPT NONE

A user defined code (42/WD) that specifies how the calendar is used. For example, the calendar might be specific to an industry such as
banking or it might be used to schedule delivery persons for a route. Note: If you use the default value of *, the system updates the value to
blank even though blank is not set up as a valid value in the UDC table.

Related Functions

None

Related Tables

None

on: absolute; left: 0.500000in">=>EndOfFile (WF)
Return Field Values<='0'
Suppress Error Messages<='1'
hRequestF3003<=RequestF3003 (WF)

Get Next Routing (B3001390):

Request Type<='3'
Suppress Error Messages<='1'
hRequestF3003<=RequestF3003 (WF)

b.Check Manufacturing Routing Table (F3112). Set error "4847" if the ErrorMsgId (WF) is
blank after this call (i.e. record is found on F3112):

Get Routing Instructions Data (B3100510):

Work Center<=WorkCenter-parm
Error Message ID=>ErrorMsgId (WF)
Index<='3'
Keys<='1'
Suppress Error Messages<='1'

Update tables:
If no errors were encountered so far:

1.Retrieve audit information:

Get Audit Information (B9800100):

User Name=>UserName (WF)
Date=>Date (WF)
Time=>Time (WF)
Workstation=>Workstation (WF)

2.Process the action against the Work Center Master table (F30006):

a.If the Location is not blank, format the display location to the file format:

Format Location (B4000310):

Cost Center<=LocationBranch-parm
Display Format Locn<=Location-parm
File Format Location=>FileLocation (WF)
Mode<='2'

b.If Action Code is "A",  add a new Work Center Master record (F30006) using values passed
into the data structure and the audit information. If the add was not successful, set error "0002".

Interoperability:

If szTransactionType-parm is greater than blank:

1. EDI Batch Number, Get Next Number (N4700060):

               VA evt_szBatchNumber <- szEdiBatchNumber

Get Next Transaction Number (B0000175):

                 "JDEWC" -> szTransactionType
                 VA evt_szUserID_USER -> szUserId
                 VA evt_szBatchNumber -> szBatchNumber
                 VA evt_szTransactionNumber <- szTransactionNumber
                 "1" -> cSuppressErrorMessage
2.Insert an outbound Add (Action code = A) transaction to the Work Center Transaction File
(F30006Z1).  If the insert was not successful, set error "0002".

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
cActionCode	ACTN	char	NONE	NONE
^
cProcessEdits	EV01	char	NONE	NONE
An option that specifies the type of processing for an event.
cSuppressErrorMsgs	EV01	char	NONE	NONE
An option that specifies the type of processing for an event.
szWorkCenter	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.
szDispatchGroup	MCUW	char	NONE	NONE
A category code used to group work centers within an overall business unit. For example, you can use this code to group similar machines operating out of several work centers that report to one business unit.
szBranchPlant	MMCU	char	NONE	NONE
A code that represents a high-level business unit. Use this code to refer to a branch or plant that might have departments or jobs, which represent lower-level business units, subordinate to it. For example: o Branch/Plant (MMCU) o Dept A (MCU) o Dept B (MCU) o Job 123 (MCU) Business unit security is based on the higher-level business unit.
szLocation	LOCN	char	NONE	NONE
The storage location from which goods will be moved.
cCriticalWorkCenter	CRTW	char	NONE	NONE
A code that indicates whether the work center is critical or not critical when the system calculates capacity. Valid values are: N Not a critical work center. 1 A critical work center in calculating RRP only. 2 A critical work center in calculating RCCP and CRP. 3 A critical work center in calculating RRP, RCCP, and CRP. The system also displays Type 3 work centers when you select Type 1 or Type 2 in this field. 4 Not a capacity work center. The system does not include this work center in capacity planning. Note: The data selection is a system feature that processes certain groups of information with the RRP, RCCP, and CRP programs.
cPrimeLoadCode	PILC	char	NONE	NONE
A code that determines if a work center is machine or labor intensive. The system also uses prime load codes in Resource Requirements Planning and Capacity Requirements Planning calculations to develop load profiles. Valid codes are: L Run labor hours only M Machine hours only B Run labor plus setup labor hours C Machine plus setup hours O Other (will not generate resource units)
cPayPointCode	BFPF	char	NONE	NONE
A code that indicates whether a work center has labor, material, or both,backflushed through it when quantities are reported against operations occurring in the work center. If you do not override the routing record, the system uses the work center value as the default. Valid codes are: 0 Not a backflush work center B Backflush material and labor M Backflush material only L Backflush labor only P Preflush material only
cDemoCalcCapacity	DEMO	char	NONE	NONE
Future use. A switch selecting either Demonstrated (D) or Calculated (C) capacity to use in CRP calculations for work center capacity. Demonstrated Capacity is the proven capacity calculated from actual output performance data. This is usually the number of items produced times standard hours per item. Calculated (or Rated) Capacity is the capacity calculated from such data as utilization, efficiency and planned hours.
mnAddressNumber	AN8	MATH_NUMERIC	NONE	NONE
A number that identifies an entry in the Address Book system, such as employee, applicant, participant, customer, supplier, tenant, or location.
mnReplenishmentHours	AVRT	MATH_NUMERIC	NONE	NONE
The time required before a consuming location has a replacement kanban available from its supplying location. This value is used only for kanban card processing in Shop Floor Management.
mnResourceOffset	TRKS	MATH_NUMERIC	NONE	NONE
A value used in the Resource Profile table (F3303) to determine the number of days that the actual use of a work center resource should be offset from the forecasted need date.
mnWorkHourPerDay	WRHR	MATH_NUMERIC	NONE	NONE
The number of work hours that the manufacturing plant operates per day.
mnWorkCenterEfficiency	WORE	MATH_NUMERIC	NONE	NONE
A user defined value that indicates how efficiently a work center operates. This value usually refers to staff efficiency. When you enter a value in this field, and the Modify Cost by Work Center Efficiency field in the Job Shop Manufacturing Constants table (F3009) is set to Y, the system creates a new cost component (B4) from the cost calculated from the direct labor cost (B1). For example, if the constant is set to Y, the value of this field is 80%, and the direct labor cost is 10, the system creates a B4 cost component for 2 in the Item Cost Component Add-Ons table (F30026). The Refresh Resource Units program also uses this value as a default when calculating rated capacity. Enter percents as whole numbers. For example, enter 80% as 80.00. Note: The system expects that the routing times entered for each operator are the actual times it takes to complete an operation. Efficiency does not affect total cost. Efficiency does reassign some of the costs into different cost components. Efficiency does not change the duration or backscheduling of a work order.
mnWorkCenterUtilization	WORU	MATH_NUMERIC	NONE	NONE
A percentage that indicates how intensively a work center is being used. This value usually refers to machine use. It is the ratio of the direct time charged for production activities to the planned hours. The Refresh Resource Units program also uses this value as a default when calculating rated capacity. Enter percents as whole numbers. For example, enter 80% as 80.00.
mnNumberOfEmployees	QMAD	MATH_NUMERIC	NONE	NONE
The normal number of employees in this work center. When you run the Work Center Resource Units Refresh program, the system multiplies this number by the Number of Work Hours Per Day from the Manufacturing Constants table (F3009) to generate the total gross labor hours available in the work center each day.
mnNumberOfMachines	NOMA	MATH_NUMERIC	NONE	NONE
The normal number of machines in this work center. When you run the Work Center Resource Units Refresh program, this number is multiplied by the number of work hours per day from the Manufacturing Constants table (F3009) to generate the total gross machine hours available in the work center each day.
mnStandardQueueHours	SQD	MATH_NUMERIC	NONE	NONE
Future Use The expected number of hours a job will wait in the queue at this work center before work on it begins.
mnMoveHours	MOVD	MATH_NUMERIC	NONE	NONE
The planned hours that are required to move the order from this operation to the next operation in the same work center. If the Routing Master values are blank, the system retrieves the default value from the work order routing. However, the system uses these values only for backscheduling variable leadtime items.
mnQueueHours	QUED	MATH_NUMERIC	NONE	NONE
The total hours that an order is expected to be in queue at work centers and moving between work centers. The system stores this value in the Item Branch table (F4102). You can calculate this value using the Leadtime Rollup program or you can enter it manually. When you run the Leadtime Rollup program, the system overrides manual entries and populates the table with calculated values.
mnCrewSize	SETC	MATH_NUMERIC	NONE	NONE
The number of people who work in the specified work center or routing operation. The system multiplies the Run Labor value in the Routing Master table (F3003) by crew size during costing to generate total labor amounts. If the Prime Load Code is L or B, the system uses the total labor hours for backscheduling. If the Prime Load Code is C or M, the system uses the total machine hours for backscheduling without modification by crew size.
mnHoursPerShift1	DL1	MATH_NUMERIC	NONE	NONE
Future use This is the planned number of hours for the duration of shift 1 for this work center.
mnHoursPerShift2	DL2	MATH_NUMERIC	NONE	NONE
Future use This is the planned number of hours for the duration of shift 2 for this work center.
mnHoursPerShift3	DL3	MATH_NUMERIC	NONE	NONE
Future use This is the planned number of hours for the duration of shift 3 for this work center.
mnShiftStart1	DE1	MATH_NUMERIC	NONE	NONE
Future use. The demonstrated capacity for shift 1.
mnShiftStart2	DE2	MATH_NUMERIC	NONE	NONE
Future use. The demonstrated capacity for shift 2.
mnShiftStart3	DE3	MATH_NUMERIC	NONE	NONE
Future use The demonstrated capacity for shift 3.
cShift1Code	DC1	char	NONE	NONE
A user defined code (00/SH) that identifies daily work shifts.
cShift2Code	DC2	char	NONE	NONE
Future use. This is the planned number of standard hours available in this work center by multiplying number of machines or crew size by planned hours for shift 2.
cShift3Code	DC3	char	NONE	NONE
Future use. This is the planned number of standard hours available in this work center by multiplying number of machines or crew size by planned hours for shift 3.
jdUserReservedDate	URDT	JDEDATE	NONE	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	NONE	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.
mnUserReservedNumber	URAB	MATH_NUMERIC	NONE	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.
szUserReservedReference	URRF	char	NONE	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.
szUserReservedCode	URCD	char	NONE	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.
szProgramId	PID	char	NONE	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.
cErrorConditions	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.
szTypeTransaction	TYTN	char	OPT	NONE
The qualifier used to identify a specific type of transaction.
cLinecellstationflag999	LIC	char	OPT	NONE
A code that defines the type of work center. Valid values are : 0 Stand alone work center 1 Production line in a repetitive environment 2 Production line in a Lean Environment
mnHoursWorkHoursShift29	WRH2	MATH_NUMERIC	OPT	NONE
The number of work hours that the manufacturing plant operates in shift 2.
mnHoursWorkHoursShift39	WRH3	MATH_NUMERIC	OPT	NONE
The number of work hours that the manufacturing plant operates in shift 3.
mnHoursWorkHoursShift49	WRH4	MATH_NUMERIC	OPT	NONE
The number of work hours that the manufacturing plant operates in shift 4.
mnHoursWorkHoursShift59	WRH5	MATH_NUMERIC	OPT	NONE
The number of work hours that the manufacturing plant operates in shift 5.
mnHoursWorkHoursShift69	WRH6	MATH_NUMERIC	OPT	NONE
The number of work hours that the manufacturing plant operates in shift 6.
szUMCapacityUOM	CAPU	char	OPT	NONE
A unit of measure that you use to express the capacity of a production line. Examples of units of measure include hours, number of stampings, coats of paint, and so on. This item is used for repetitive processing only.
mnCapacityStandard	CPSD	MATH_NUMERIC	OPT	NONE
The standard capacity level at which a production line usually operates. Capacity is stated in units per hour. This level is used for repetitive processing only.
mnCapacityMinimum	CPMI	MATH_NUMERIC	OPT	NONE
The lower limit of the capacity, beyond which the production line should not operate. Management sets this limit, based on factors such as efficiencies, costs, and so on. Capacity is stated in units per hour. This limit is used for repetitive processing only.
mnCapacityMaximum	CPMA	MATH_NUMERIC	OPT	NONE
The upper limit of the capacity, beyond which a production line cannot produce. Capacity is stated in units per hour. This limit is used for repetitive processing only.
cWriteBeforeImages	EV01	char	OPT	NONE
An option that specifies the type of processing for an event.
szLocationBranch	LOMC	char	OPT	NONE
This is the branch plant of the location associated with the work center.
szWorkDayCalendarKey	WDCK	char	OPT	NONE
A code used to classify values within a calendar type. For example, if the calendar type is ROUTE, you can enter a code that specifies a particular route, such as Daily or Weekend. Note: The system does not validate the code that you enter.
szWorkDayCalendarType	WDCT	char	OPT	NONE
A user defined code (42/WD) that specifies how the calendar is used. For example, the calendar might be specific to an industry such as banking or it might be used to schedule delivery persons for a route. Note: If you use the default value of *, the system updates the value to blank even though blank is not set up as a valid value in the UDC table.