GetMfgConstantsData

Get MFG Constants Data

Minor Business Rule

Object Name: B3000450

Parent DLL: CMFGBASE

Location: Client/Server

Language: C

1.Functional Description

1.1Purpose
Retrieve the Work Center Data from the Work Center Master File using either the Pointer to the F30006
Record or the Business Unit.  The Shift Information and User Defined Information are retrieved in a
separate business function.

1.2Setup Notes and Prerequisites

1.3Special Logic
Returns:
1.)  Return error message '4507' (Work Center Invalid), if the work center does not exist in the Work
Center Master Table.
2.)  Return error message '4366' (No Memory), if an error occurs allocating memory for the Work
Center Master Record Data structure in the VerifyAndGetWorkCenterMaster business function.
3.)  Return the Work Center Master Information.

2.Technical Specifications

2.4Processing
Edits:
1.0.  If DS F3009 Pointer is not equal to NULL, return requested information from F3009.

2.0.  If DS F3009 Pointer is equal to NULL, Retrieve the Manufacturing Constants Record using the
Branch/Plant.

2.1.  Retreive the F3009 using the Branch/Plant.
2.2.  If the Manufacturing Constants row cannot be located, assign DS Error Message Code = '4430'
(Constants not set up).  If the Manufacturing Constants row cannot be located and DS Suppress Error
Messages is not equal to '1', SetGBRError where the error message is '4430' and DS  Branch/Plant
is highlighted.

2.3.If the VerifyAndGetWorkCenterMaster ErrorMessageID is equal to blanks:

2.3.1. Retrieve the requested information from the Data Structure.

2.3.2. Retrieve the additional data fields from the F30006T table.  If no record is found, set
an error.

Returns:
1.).  If the pointer to the F3009 record is not sent and the Manufacturing Constants is not found
using the Branch/Plant, error code 4430 (Constants not set up) is returned.
2.)  If the Manufacturing Constants Record is found, the Manufacturing Constants Data is return.

Data Structure

D3000450 - Get MFG Constants Data

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

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.

idF3009Pointer GENLNG ID NONE NONE

General purpose ID variable.

cSuppressErrorMessage EV01 char NONE NONE

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

szSystemCode SY char NONE NONE

A user defined code (98/SY) that identifies a system. Valid values include: 01 Address Book 03B Accounts Receivable 04 Accounts
Payable 09 General Accounting 11 Multicurrency

cDateOrSerialNumber DORS char NONE NONE

This field indicates whether the item effectivity is to be tracked by date or serial number.

mnMaximumLevels MAXL MATH_NUMERIC NONE NONE

The maximum number of levels expected in the bill of material.  Improved program performance can be achieved by a close
approximation of the greatest level in the bill of material.

cLogBillOfMaterial LOGB char NONE NONE

A code that determines whether changes to the bill of material are recorded in the Bill of Material Change File table (F3011). When you log
bill of material changes, the system saves the old bill of material and the new, changed bill of material. To record changes to the bill of
material, click the Log Bill of Material option under the BOM/Routing Options heading.

cOverheadPerOrRate PORR char NONE NONE

An option that determines whether values for overhead fields (cost components C1 through C4) in the Work Center Rates table (F30008) are
expressed as percents or rates. For World: Valid values are:    R Express overhead values as rates (currency values).    P Express overhead
values as percents. For OneWorld: To specify whether the system expresses the overhead fields as percents or rates, click either Percents
or Rates under the Overheads heading.

cModifyCostbyWCEfficiency MWCE char NONE NONE

An option that determines whether the cost rollup creates cost component B4  (for labor efficiency) based on the direct labor value (cost
component B1) and the Work Center Efficiency percent from the Work Center Master table (F30006). For World: Valid values are:    Y Yes. Create
cost component B4.    N No. Do not create cost component B4. For OneWorld: To create cost component B4, click the Modify cost by Work
Center Efficiency option under the Costing Options heading.

cIncludeVarLaborOH IVO char NONE NONE

An option that determines whether the cost rollup creates cost component C3  (for variable labor overhead) in the Item Cost Component
Add-Ons table (F30026). For World: Valid values are:    Y Yes. Create cost component C3.    N No. Do not create cost component C3. For
OneWorld: To create cost component C3, click the Include Variable Labor Overhead in cost option under the Costing Options heading.

cCalcVarOnDirectLabor CVDL char NONE NONE

An option that determines whether the cost rollup includes direct labor expenses (cost component B1) in the total used to calculate variable
labor overhead (cost component C3). For World: Valid values are:    Y Yes. Include direct labor expenses.    N No. Do not include direct labor
expenses. For OneWorld: To include direct labor expenses, click the Calculate Var. on Direct Labor option under the Costing Options
heading.

cCalcVarOnSetupLabor CVSL char NONE NONE

An option that determines whether the cost rollup includes setup labor expenses (cost component B2) in the total used to calculate variable
setup overhead (cost component C3). For World: Valid values are:    Y Yes. Include setup labor expenses.    N No. Do not include setup labor
expenses. For OneWorld: To include setup labor expenses, click the Calculate Var. on Setup Labor option under the Costing Options
heading.

cIncludeWCEfficiencyInOH CVDS char NONE NONE

An option that determines whether the cost rollup includes work center efficiency when calculating overhead values, if you specified that
you want to modify costs by work center efficiency. For World: Valid values are:    Y Yes. Include work center efficiency.    N No. Do not include
work center efficiency. For OneWorld: To include work center efficiency, click the Include Work Center Eff. in Overhead option under the Costing
Options heading.

cIncludeFixedLaborOH IFO char NONE NONE

An option that determines whether the cost rollup creates cost component C4  (for fixed labor overhead) in the Item Cost Component
Add-Ons table (F30026). For World: Valid values are:    Y Yes. Create cost component C4.    N No. Do not create cost component C4. For
OneWorld: To create cost component C4, click the Include Fixed Labor Overhead in cost option under the Costing Options heading.

cCalcFixedOnDirectLabor CFDL char NONE NONE

An option that determines whether the cost rollup includes direct labor expenses (cost component B1) in the total used to calculate fixed
labor overhead (cost component C4). For World: Valid values are:    Y Yes. Include direct labor expenses.    N No. Do not include direct labor
expenses. For OneWorld: To include direct labor expenses, click the Calculate Fixed on Direct Labor option under the Costing Options heading.

cCalcFixedOnSetupLabor CFSL char NONE NONE

An option that determines whether the cost rollup includes setup labor expenses (cost component B2) in the total used to calculate fixed
setup overhead (cost component C4). For World: Valid values are:    Y Yes. Include setup labor expenses.    N No. Do not include setup labor
expenses. For OneWorld: To include setup labor expenses, click the Calculate Fixed on Setup Labor option under the Costing Options heading.

cOnlineBomValidation CFDS char NONE NONE

An option that determines whether the system performs an online component or parent validation and low-level code assignment when you
revise a bill of material. J.D. Edwards recommends that you validate items online unless your bills of material are extremely large. If you
choose not to validate items online, you must validate the items in batch. Run the Integrity Analysis program (P30601) after updates to the bill of
material and before you run the Item Cost Component - Frozen Update program (R30835) or perform a DRP/MPS/MRP generation
(R3482). To specify that the system validates items online, click the On-Line BOM Validation option under the BOM/Routing Options heading. If you do
not click the On-Line BOM Validation option, the system does not validate items online.

cIncludeVarMachineOH IVMO char NONE NONE

An option that determines whether the cost rollup creates cost component C1  (for variable machine overhead) in the Cost Components
table (F30026). For World: Valid values are:    Y Yes. Create cost component C1.    N No. Do not create cost component C1. For OneWorld: To
create cost component C1, click the Include Var. Machine Overhead in Cost option under the Costing Options heading.

cIncludeFixedMachineOH IFMO char NONE NONE

An option that determines whether the cost rollup creates cost component C2  (for fixed machine overhead) in the Item Cost Component
Add-Ons table (F30026). For World: Valid values are:    Y Yes. Create cost component C2.    N No. Do not create cost component C2. For
OneWorld: To create cost component C2, click the Include Fixed Machine Overhead in Cost option under the Costing Options heading.

cBackFlushOptions BFOP char NONE NONE

A code that determines how the system performs commitment and release of inventory. Valid codes are:    1   Create a standard parts list
based on the value in the Commitment Control field in the Job Shop Manufacturing Constants table (F3009).    2   Create a parts list, committing to
the location indicated in the Work Center Master table (F30006). The Operation Sequence field in the Bill of Material Master table (F3002)
determines the work center that is used. Note: You must create the work order routing before the parts list. If you are running the work order
generation (R31410), you must set the Process Tab,Parts List and Routing Instructions processing option to 3 to generate the parts list and
routing instructions at the same time. If you define a consuming location on the routing instructions, this location overrides the consuming location
defined in the Work Center Master table.

cMasterRoutings MRYN char NONE NONE

An option that determines whether the system uses the master routing for an item or a routing defined for the parent item. Both routings are
retrieved from the Routing Master table (F3003). If you choose to check for master routings, the Shop Floor Management system checks the
Item Cross Reference table (F4104), cross-reference type MR, for the parent item. If it finds a cross-reference, the program uses the master
routing from the Routing Master Table (F3003). If it does not find a cross-reference, the system uses the routing defined for the parent item. If
you do not choose to check for master routings, the program uses the parent item's routing from the Routing Master table. For World: Valid
values are:    Y Yes, use the master routing for an item, if one exists.    N No, do not check for a master routing for the item. For OneWorld: To specify
whether the system checks for cross-references and uses a master routing for the item, click the Master Routings option under the
BOM/Routing Options heading.

mnWorkHoursPerDay WRHR MATH_NUMERIC NONE NONE

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

cCommitmentControl FLD1 char NONE NONE

An option that determines how the system commits inventory to a work order, and specifies the inventory location to which commitments are
made. Valid values are: 1 Primary Location 2 Split-Cross Branch Boundaries 3 Split-Don't Cross Branch Boundaries Note: The system
activates this field only when you create hard commitments. The three available options are as follows:   o  Primary Location. Make commitments to
the primary location in the branch/plant where the work order originates.   o  Split-Cross Branch Boundaries. Split the parts list and
commitments to fill any component shortages. The system can cross branch boundaries to fill requirements. In this case, the system uses the next
alphabetical branch/plant listed in the table that occurs after the branch/plant on the work order header. For example, for the branch/plants CAL,
CHI, CLE, and HOU: If the system starts committing inventory at branch/plant CHI, it accesses CLE as the next branch/plant. If inventory is low in
all locations, the system makes the remaining commitments to the primary location of the branch/plant on the work order header.   o
Split-Don't Cross Branch Boundaries. This option is similar to Split-Cross Branch Boundaries, but the system cannot cross branch boundaries. Note:
When you set the Commitment Method field in the Item Branch/Plant table to 2 or 3 (lot number or expiration date control), you must use the
Split-Don't Cross Branch Boundaries option.

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.

cHardSoftCommit FLD2 char NONE NONE

An option that determines how the Shop Floor Management system commits inventory. The options are as follows:     o Hard commitment at
creation of parts list. The system performs a hard commitment at the creation of the parts list. The hard commitment remains in effect until
inventory is relieved.     o Soft commitment, then changed to hard commitment when printing. The system performs a soft commitment at the
creation of the parts list.        The system then changes the commitment to a hard commitment during the pick list print process (P31410) for the
work order. The hard commitment remains in effect until inventory is relieved.     o Soft commitment at creation of parts list. The system performs a
soft commitment at creation of the parts list. The soft commitment remains in effect until inventory is relieved. When you set the Commitment
Method field in the Branch/Plant Constants form to 2 or 3, you must use either Hard commitment at creation of parts list or Soft commitment,
then hard commitment when printing because a hard commitment must be performed. If you want to identify substitute items when a shortage
occurs, you must choose the hard commitment at creation of parts list option. When you choose either Soft, Hard when printing or Soft at creation
of Parts List, any line item in the parts list may be hard-committed prior to printing or relieving the inventory. For World: When the hard/soft
commit option is set to 2 or 3, any line item in the parts list may be hard committed prior to printing or relieving the inventory. Valid codes are:    1
Hard commitment    2   Soft commitment, hard commitment when printing (P31410)    3   Soft commitment For OneWorld: To specify how the
program commits inventory, click one of the following options under the Hard/Soft Commit heading:     o Hard at creation of parts list     o Soft, Hard
when printing (P31410)     o Soft at creation of parts list

mnWorkHoursShift2 WRH2 MATH_NUMERIC OPT NONE

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

mnWorkHoursShift3 WRH3 MATH_NUMERIC OPT NONE

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

mnWorkHoursShift4 WRH4 MATH_NUMERIC OPT NONE

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

mnWorkHoursShift5 WRH5 MATH_NUMERIC OPT NONE

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

mnWorkHoursShift6 WRH6 MATH_NUMERIC OPT NONE

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

cShiftCode SHFT char OPT NONE

A user defined code (00/SH) that identifies daily work shifts. In payroll systems, you can use a shift code to add a percentage or amount to
the hourly rate on a timecard. For payroll and time entry: If an employee always works a shift for which a shift rate differential is applicable,
enter that shift code on the employee's master record. When you enter the shift on the employee's master record, you do not need to enter the
code on the timecard when you enter time. If an employee occasionally works a different shift, you enter the shift code on each applicable
timecard to override the default value.

cShift2Code SHF2 char OPT NONE

A user defined code (system 06, type SH) that identifies a secondary daily work shift. In manufacturing systems, up to six shift levels can be
defined (each with a unique shift code assigned). The shift code is the identifier associated with a particular shift. Resource units for a Work
Center can be broken down by the shift code.

cShift3Code SHF3 char OPT NONE

A user defined code (system 06, type SH) that identifies a secondary daily work shift. In manufacturing systems, up to six shift levels can be
defined (each with a unique shift code assigned). The shift code is the identifier associated with a particular shift. Resource units for a Work
Center can be broken down by the shift code.

cShift4Code SHF4 char OPT NONE

A user defined code (system 06, type SH) that identifies a secondary daily work shift. In manufacturing systems, up to six shift levels can be
defined (each with a unique shift code assigned). The shift code is the identifier associated with a particular shift. Resource units for a Work
Center can be broken down by the shift code.

cShift5Code SHF5 char OPT NONE

A user defined code (system 06, type SH) that identifies a secondary daily work shift. In manufacturing systems, up to six shift levels can be
defined (each with a unique shift code assigned). The shift code is the identifier associated with a particular shift. Resource units for a Work
Center can be broken down by the shift code.

cShift6Code SHF6 char OPT NONE

A user defined code (system 06, type SH) that identifies a secondary daily work shift. In manufacturing systems, up to six shift levels can be
defined (each with a unique shift code assigned). The shift code is the identifier associated with a particular shift. Resource units for a Work
Center can be broken down by the shift code.

szStatusForChange SRS1 char OPT NONE

This field specifies the status beyond which work orders and rates can not be changed in the Line Scheduling and Line Sequencing
Workbench programs.

cMachineRateSource MARS char OPT NONE

A code that specifies the source for machine rates when the system calculates routing costs for an estimate. Valid values are:    1   Work
Center Rates table (F30008).    2   Equipment Rates table (F1301)

cLaborRateSource LARS char OPT NONE

A code that specifies the source for labor rates when the system calculates the routing costs for an estimate. Valid values are: 1 Work Center
Rates table (F30008)   2 Employee Labor Rates table (F00191)

cPercentBillValidation PBVD char OPT NONE

This flag designates whether percent bills are allowed to contain fixed or variable components in addition to the 100% formula. If left blank,
only percent components will be allowed and it must total 100%.

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.

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.

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.

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.

cCostByWorkCenter CWC char OPT NONE

A code, maintained in the Manufacturing Constants program (P3009), that indicates whether the system tracks cost variances for discrete
and process items on a summarized level in the Item Cost Component Add-Ons table (F30026) or on a detailed level in the Item Cost
Component Detail table (F300261). Valid values are: Y Yes. Maintain costs on a detailed level by cost component and work center. N No. Maintain costs
on a summarized level by cost component only.

Related Functions

None

Related Tables

F3009 Job Shop Manufacturing Constants

F3009T Manufacturing Constants Tag File - Needed for upgrade

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
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.
idF3009Pointer	GENLNG	ID	NONE	NONE
General purpose ID variable.
cSuppressErrorMessage	EV01	char	NONE	NONE
An option that specifies the type of processing for an event.
szSystemCode	SY	char	NONE	NONE
A user defined code (98/SY) that identifies a system. Valid values include: 01 Address Book 03B Accounts Receivable 04 Accounts Payable 09 General Accounting 11 Multicurrency
cDateOrSerialNumber	DORS	char	NONE	NONE
This field indicates whether the item effectivity is to be tracked by date or serial number.
mnMaximumLevels	MAXL	MATH_NUMERIC	NONE	NONE
The maximum number of levels expected in the bill of material. Improved program performance can be achieved by a close approximation of the greatest level in the bill of material.
cLogBillOfMaterial	LOGB	char	NONE	NONE
A code that determines whether changes to the bill of material are recorded in the Bill of Material Change File table (F3011). When you log bill of material changes, the system saves the old bill of material and the new, changed bill of material. To record changes to the bill of material, click the Log Bill of Material option under the BOM/Routing Options heading.
cOverheadPerOrRate	PORR	char	NONE	NONE
An option that determines whether values for overhead fields (cost components C1 through C4) in the Work Center Rates table (F30008) are expressed as percents or rates. For World: Valid values are: R Express overhead values as rates (currency values). P Express overhead values as percents. For OneWorld: To specify whether the system expresses the overhead fields as percents or rates, click either Percents or Rates under the Overheads heading.
cModifyCostbyWCEfficiency	MWCE	char	NONE	NONE
An option that determines whether the cost rollup creates cost component B4 (for labor efficiency) based on the direct labor value (cost component B1) and the Work Center Efficiency percent from the Work Center Master table (F30006). For World: Valid values are: Y Yes. Create cost component B4. N No. Do not create cost component B4. For OneWorld: To create cost component B4, click the Modify cost by Work Center Efficiency option under the Costing Options heading.
cIncludeVarLaborOH	IVO	char	NONE	NONE
An option that determines whether the cost rollup creates cost component C3 (for variable labor overhead) in the Item Cost Component Add-Ons table (F30026). For World: Valid values are: Y Yes. Create cost component C3. N No. Do not create cost component C3. For OneWorld: To create cost component C3, click the Include Variable Labor Overhead in cost option under the Costing Options heading.
cCalcVarOnDirectLabor	CVDL	char	NONE	NONE
An option that determines whether the cost rollup includes direct labor expenses (cost component B1) in the total used to calculate variable labor overhead (cost component C3). For World: Valid values are: Y Yes. Include direct labor expenses. N No. Do not include direct labor expenses. For OneWorld: To include direct labor expenses, click the Calculate Var. on Direct Labor option under the Costing Options heading.
cCalcVarOnSetupLabor	CVSL	char	NONE	NONE
An option that determines whether the cost rollup includes setup labor expenses (cost component B2) in the total used to calculate variable setup overhead (cost component C3). For World: Valid values are: Y Yes. Include setup labor expenses. N No. Do not include setup labor expenses. For OneWorld: To include setup labor expenses, click the Calculate Var. on Setup Labor option under the Costing Options heading.
cIncludeWCEfficiencyInOH	CVDS	char	NONE	NONE
An option that determines whether the cost rollup includes work center efficiency when calculating overhead values, if you specified that you want to modify costs by work center efficiency. For World: Valid values are: Y Yes. Include work center efficiency. N No. Do not include work center efficiency. For OneWorld: To include work center efficiency, click the Include Work Center Eff. in Overhead option under the Costing Options heading.
cIncludeFixedLaborOH	IFO	char	NONE	NONE
An option that determines whether the cost rollup creates cost component C4 (for fixed labor overhead) in the Item Cost Component Add-Ons table (F30026). For World: Valid values are: Y Yes. Create cost component C4. N No. Do not create cost component C4. For OneWorld: To create cost component C4, click the Include Fixed Labor Overhead in cost option under the Costing Options heading.
cCalcFixedOnDirectLabor	CFDL	char	NONE	NONE
An option that determines whether the cost rollup includes direct labor expenses (cost component B1) in the total used to calculate fixed labor overhead (cost component C4). For World: Valid values are: Y Yes. Include direct labor expenses. N No. Do not include direct labor expenses. For OneWorld: To include direct labor expenses, click the Calculate Fixed on Direct Labor option under the Costing Options heading.
cCalcFixedOnSetupLabor	CFSL	char	NONE	NONE
An option that determines whether the cost rollup includes setup labor expenses (cost component B2) in the total used to calculate fixed setup overhead (cost component C4). For World: Valid values are: Y Yes. Include setup labor expenses. N No. Do not include setup labor expenses. For OneWorld: To include setup labor expenses, click the Calculate Fixed on Setup Labor option under the Costing Options heading.
cOnlineBomValidation	CFDS	char	NONE	NONE
An option that determines whether the system performs an online component or parent validation and low-level code assignment when you revise a bill of material. J.D. Edwards recommends that you validate items online unless your bills of material are extremely large. If you choose not to validate items online, you must validate the items in batch. Run the Integrity Analysis program (P30601) after updates to the bill of material and before you run the Item Cost Component - Frozen Update program (R30835) or perform a DRP/MPS/MRP generation (R3482). To specify that the system validates items online, click the On-Line BOM Validation option under the BOM/Routing Options heading. If you do not click the On-Line BOM Validation option, the system does not validate items online.
cIncludeVarMachineOH	IVMO	char	NONE	NONE
An option that determines whether the cost rollup creates cost component C1 (for variable machine overhead) in the Cost Components table (F30026). For World: Valid values are: Y Yes. Create cost component C1. N No. Do not create cost component C1. For OneWorld: To create cost component C1, click the Include Var. Machine Overhead in Cost option under the Costing Options heading.
cIncludeFixedMachineOH	IFMO	char	NONE	NONE
An option that determines whether the cost rollup creates cost component C2 (for fixed machine overhead) in the Item Cost Component Add-Ons table (F30026). For World: Valid values are: Y Yes. Create cost component C2. N No. Do not create cost component C2. For OneWorld: To create cost component C2, click the Include Fixed Machine Overhead in Cost option under the Costing Options heading.
cBackFlushOptions	BFOP	char	NONE	NONE
A code that determines how the system performs commitment and release of inventory. Valid codes are: 1 Create a standard parts list based on the value in the Commitment Control field in the Job Shop Manufacturing Constants table (F3009). 2 Create a parts list, committing to the location indicated in the Work Center Master table (F30006). The Operation Sequence field in the Bill of Material Master table (F3002) determines the work center that is used. Note: You must create the work order routing before the parts list. If you are running the work order generation (R31410), you must set the Process Tab,Parts List and Routing Instructions processing option to 3 to generate the parts list and routing instructions at the same time. If you define a consuming location on the routing instructions, this location overrides the consuming location defined in the Work Center Master table.
cMasterRoutings	MRYN	char	NONE	NONE
An option that determines whether the system uses the master routing for an item or a routing defined for the parent item. Both routings are retrieved from the Routing Master table (F3003). If you choose to check for master routings, the Shop Floor Management system checks the Item Cross Reference table (F4104), cross-reference type MR, for the parent item. If it finds a cross-reference, the program uses the master routing from the Routing Master Table (F3003). If it does not find a cross-reference, the system uses the routing defined for the parent item. If you do not choose to check for master routings, the program uses the parent item's routing from the Routing Master table. For World: Valid values are: Y Yes, use the master routing for an item, if one exists. N No, do not check for a master routing for the item. For OneWorld: To specify whether the system checks for cross-references and uses a master routing for the item, click the Master Routings option under the BOM/Routing Options heading.
mnWorkHoursPerDay	WRHR	MATH_NUMERIC	NONE	NONE
The number of work hours that the manufacturing plant operates per day.
cCommitmentControl	FLD1	char	NONE	NONE
An option that determines how the system commits inventory to a work order, and specifies the inventory location to which commitments are made. Valid values are: 1 Primary Location 2 Split-Cross Branch Boundaries 3 Split-Don't Cross Branch Boundaries Note: The system activates this field only when you create hard commitments. The three available options are as follows: o Primary Location. Make commitments to the primary location in the branch/plant where the work order originates. o Split-Cross Branch Boundaries. Split the parts list and commitments to fill any component shortages. The system can cross branch boundaries to fill requirements. In this case, the system uses the next alphabetical branch/plant listed in the table that occurs after the branch/plant on the work order header. For example, for the branch/plants CAL, CHI, CLE, and HOU: If the system starts committing inventory at branch/plant CHI, it accesses CLE as the next branch/plant. If inventory is low in all locations, the system makes the remaining commitments to the primary location of the branch/plant on the work order header. o Split-Don't Cross Branch Boundaries. This option is similar to Split-Cross Branch Boundaries, but the system cannot cross branch boundaries. Note: When you set the Commitment Method field in the Item Branch/Plant table to 2 or 3 (lot number or expiration date control), you must use the Split-Don't Cross Branch Boundaries option.
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.
cHardSoftCommit	FLD2	char	NONE	NONE
An option that determines how the Shop Floor Management system commits inventory. The options are as follows: o Hard commitment at creation of parts list. The system performs a hard commitment at the creation of the parts list. The hard commitment remains in effect until inventory is relieved. o Soft commitment, then changed to hard commitment when printing. The system performs a soft commitment at the creation of the parts list. The system then changes the commitment to a hard commitment during the pick list print process (P31410) for the work order. The hard commitment remains in effect until inventory is relieved. o Soft commitment at creation of parts list. The system performs a soft commitment at creation of the parts list. The soft commitment remains in effect until inventory is relieved. When you set the Commitment Method field in the Branch/Plant Constants form to 2 or 3, you must use either Hard commitment at creation of parts list or Soft commitment, then hard commitment when printing because a hard commitment must be performed. If you want to identify substitute items when a shortage occurs, you must choose the hard commitment at creation of parts list option. When you choose either Soft, Hard when printing or Soft at creation of Parts List, any line item in the parts list may be hard-committed prior to printing or relieving the inventory. For World: When the hard/soft commit option is set to 2 or 3, any line item in the parts list may be hard committed prior to printing or relieving the inventory. Valid codes are: 1 Hard commitment 2 Soft commitment, hard commitment when printing (P31410) 3 Soft commitment For OneWorld: To specify how the program commits inventory, click one of the following options under the Hard/Soft Commit heading: o Hard at creation of parts list o Soft, Hard when printing (P31410) o Soft at creation of parts list
mnWorkHoursShift2	WRH2	MATH_NUMERIC	OPT	NONE
The number of work hours that the manufacturing plant operates in shift 2.
mnWorkHoursShift3	WRH3	MATH_NUMERIC	OPT	NONE
The number of work hours that the manufacturing plant operates in shift 3.
mnWorkHoursShift4	WRH4	MATH_NUMERIC	OPT	NONE
The number of work hours that the manufacturing plant operates in shift 4.
mnWorkHoursShift5	WRH5	MATH_NUMERIC	OPT	NONE
The number of work hours that the manufacturing plant operates in shift 5.
mnWorkHoursShift6	WRH6	MATH_NUMERIC	OPT	NONE
The number of work hours that the manufacturing plant operates in shift 6.
cShiftCode	SHFT	char	OPT	NONE
A user defined code (00/SH) that identifies daily work shifts. In payroll systems, you can use a shift code to add a percentage or amount to the hourly rate on a timecard. For payroll and time entry: If an employee always works a shift for which a shift rate differential is applicable, enter that shift code on the employee's master record. When you enter the shift on the employee's master record, you do not need to enter the code on the timecard when you enter time. If an employee occasionally works a different shift, you enter the shift code on each applicable timecard to override the default value.
cShift2Code	SHF2	char	OPT	NONE
A user defined code (system 06, type SH) that identifies a secondary daily work shift. In manufacturing systems, up to six shift levels can be defined (each with a unique shift code assigned). The shift code is the identifier associated with a particular shift. Resource units for a Work Center can be broken down by the shift code.
cShift3Code	SHF3	char	OPT	NONE
A user defined code (system 06, type SH) that identifies a secondary daily work shift. In manufacturing systems, up to six shift levels can be defined (each with a unique shift code assigned). The shift code is the identifier associated with a particular shift. Resource units for a Work Center can be broken down by the shift code.
cShift4Code	SHF4	char	OPT	NONE
A user defined code (system 06, type SH) that identifies a secondary daily work shift. In manufacturing systems, up to six shift levels can be defined (each with a unique shift code assigned). The shift code is the identifier associated with a particular shift. Resource units for a Work Center can be broken down by the shift code.
cShift5Code	SHF5	char	OPT	NONE
A user defined code (system 06, type SH) that identifies a secondary daily work shift. In manufacturing systems, up to six shift levels can be defined (each with a unique shift code assigned). The shift code is the identifier associated with a particular shift. Resource units for a Work Center can be broken down by the shift code.
cShift6Code	SHF6	char	OPT	NONE
A user defined code (system 06, type SH) that identifies a secondary daily work shift. In manufacturing systems, up to six shift levels can be defined (each with a unique shift code assigned). The shift code is the identifier associated with a particular shift. Resource units for a Work Center can be broken down by the shift code.
szStatusForChange	SRS1	char	OPT	NONE
This field specifies the status beyond which work orders and rates can not be changed in the Line Scheduling and Line Sequencing Workbench programs.
cMachineRateSource	MARS	char	OPT	NONE
A code that specifies the source for machine rates when the system calculates routing costs for an estimate. Valid values are: 1 Work Center Rates table (F30008). 2 Equipment Rates table (F1301)
cLaborRateSource	LARS	char	OPT	NONE
A code that specifies the source for labor rates when the system calculates the routing costs for an estimate. Valid values are: 1 Work Center Rates table (F30008) 2 Employee Labor Rates table (F00191)
cPercentBillValidation	PBVD	char	OPT	NONE
This flag designates whether percent bills are allowed to contain fixed or variable components in addition to the 100% formula. If left blank, only percent components will be allowed and it must total 100%.
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.
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.
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.
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.
cCostByWorkCenter	CWC	char	OPT	NONE
A code, maintained in the Manufacturing Constants program (P3009), that indicates whether the system tracks cost variances for discrete and process items on a summarized level in the Item Cost Component Add-Ons table (F30026) or on a detailed level in the Item Cost Component Detail table (F300261). Valid values are: Y Yes. Maintain costs on a detailed level by cost component and work center. N No. Maintain costs on a summarized level by cost component only.

F3009 Job Shop Manufacturing Constants
F3009T Manufacturing Constants Tag File - Needed for upgrade