F3293GetConfiguratorConstantRow

F3293 Get Configurator Constant Row

Minor Business Rule

Object Name: N3200570

Parent DLL: CMFG

Location: Client/Server

Language: NER

1.Functional Description

1.1Purpose
Verify that a row exists or retrieve information in the file.  The error message "017F" will be
returned if the record does not exist for the branch/plant specified.  The calling program will be
responsible for processing this error code, i.e. sending or printing an error message to the user.

1.2Setup Notes and Prerequisites

1.3Special Logic

2.Technical Specifications
2.4Processing
Fetch the record from the F3209 using key fields specified and return all the fields in the file.  If
record does not exist, pass error message "017F" back to the calling program.

Data Structure

D3200570 - F3209 Get Configurator Constants Row

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

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

cDelimitersegment SECD char NONE NONE

A character separator that you use with configured items during order entry. This character must be the same for each branch/plant. The
default character is a /. Although you can specify a different character, J.D. Edwards recommends that you do not use an * and that you do not
change the value after you specify it. For the segment delimiter, use a character that could never appear within an answer to a segment
question.

cPartslistrouting APLR char NONE NONE

Controls whether the parts list and routing for configured item work orders will be created using subsystem or batch processing. Both
methods use the Order Processing DREAM Writer (P31410) to write parts list and routing records. Valid values are:    1   Batch processing. You must
run the Order Processing program and change the selection options to accommodate the different sales order numbers being processed.
2   Subsystem processing. After you start the subsystem, the Order Processing program automatically processes any new work orders
generated from a configured item sales order. Subsystem processing involves less user interaction and does not generate shop floor
paperwork.

cCheckavailability CAVL char NONE NONE

A code that specifies whether the system verifies that a configured parent item is in stock during sales order entry. The default value is
1. The system searches inventory for a configuration that matches the parent item during sales order update. If the system locates more than one
item, a form displays all matching locations, lots, and their available quantities. From the form, you can choose an item to hard-commit during
the update. If the system locates only one item, the item is hard-committed to inventory during the update. The check availablity feature might
negatively affect system performance.

szLinetype LNTY char NONE NONE

A code that controls how the system processes lines on a transaction. It controls the systems with which the transaction interfaces, such as
General Ledger, Job Cost, Accounts Payable, Accounts Receivable, and Inventory Management. It also specifies the conditions under
which a line prints on reports, and it is included in calculations. Codes include the following: S Stock item   J Job cost   N Nonstock item   F Freight
T Text information   M Miscellaneous charges and credits   W Work order

szSalesquotedocumenttypeli SQRT char NONE NONE

The Sales Quote Document Type List is a user defined code table (32/QL) that is used to define valid document types for sales quotes in
your company. For example, you could define sales quote document types by branch/plant or by type of quote, such as corporate or
seasonal quotes.

cCostsalesquotes CCSQ char NONE NONE

A setting that specifies which costs accumulate when the order type matches one of the sales quote document types. Valid values are: 0 The
costs of only the P and X assembly inclusion rules accumulate. 1 All costs from P, Q, R, and X (cost) assembly inclusion rules accumulate.
This is the default value.

szWochangestatus WOCS char NONE NONE

This field determines the value of the work order status field (user defined code 00/SS) for a configured item. Sales Order Entry has
processing options that determine the beginning status and the change status of a work order for a configured item. The processing options work
as follows:     o If the current status of the work order is greater than or equal to the work order change status, the system enters the code value
from the change status processing option into the status field on the work order.     o If the current status of the work order is less than the work
order change status, the system enters the code value from the beginning status processing option into the status field on the work order.

cDisplaycalculatedsegment DCSG char NONE NONE

A setting that indicates whether the system displays calculated segments during order entry. Valid values are: 0 The system does not
displays calculated segments when you enter an order; however, it stores the value of the segment in history. When you enter a multilevel
configured item, the system does not displays levels that have only calculated segments. The default value is 0. 1 The system displays calculated
segments when you enter an order.

cSuppressErrorMessage EV01 char NONE NONE

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

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.

cConfiguratorErrorCharacter CEC char OPT NONE

A code that indicates an error in the calculation. This code is a single character value. For example, the error character can be set to error =
!. The default value is 1.

Related Functions

None

Related Tables

None

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
szCostcenter	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.
cDelimitersegment	SECD	char	NONE	NONE
A character separator that you use with configured items during order entry. This character must be the same for each branch/plant. The default character is a /. Although you can specify a different character, J.D. Edwards recommends that you do not use an * and that you do not change the value after you specify it. For the segment delimiter, use a character that could never appear within an answer to a segment question.
cPartslistrouting	APLR	char	NONE	NONE
Controls whether the parts list and routing for configured item work orders will be created using subsystem or batch processing. Both methods use the Order Processing DREAM Writer (P31410) to write parts list and routing records. Valid values are: 1 Batch processing. You must run the Order Processing program and change the selection options to accommodate the different sales order numbers being processed. 2 Subsystem processing. After you start the subsystem, the Order Processing program automatically processes any new work orders generated from a configured item sales order. Subsystem processing involves less user interaction and does not generate shop floor paperwork.
cCheckavailability	CAVL	char	NONE	NONE
A code that specifies whether the system verifies that a configured parent item is in stock during sales order entry. The default value is 1. The system searches inventory for a configuration that matches the parent item during sales order update. If the system locates more than one item, a form displays all matching locations, lots, and their available quantities. From the form, you can choose an item to hard-commit during the update. If the system locates only one item, the item is hard-committed to inventory during the update. The check availablity feature might negatively affect system performance.
szLinetype	LNTY	char	NONE	NONE
A code that controls how the system processes lines on a transaction. It controls the systems with which the transaction interfaces, such as General Ledger, Job Cost, Accounts Payable, Accounts Receivable, and Inventory Management. It also specifies the conditions under which a line prints on reports, and it is included in calculations. Codes include the following: S Stock item J Job cost N Nonstock item F Freight T Text information M Miscellaneous charges and credits W Work order
szSalesquotedocumenttypeli	SQRT	char	NONE	NONE
The Sales Quote Document Type List is a user defined code table (32/QL) that is used to define valid document types for sales quotes in your company. For example, you could define sales quote document types by branch/plant or by type of quote, such as corporate or seasonal quotes.
cCostsalesquotes	CCSQ	char	NONE	NONE
A setting that specifies which costs accumulate when the order type matches one of the sales quote document types. Valid values are: 0 The costs of only the P and X assembly inclusion rules accumulate. 1 All costs from P, Q, R, and X (cost) assembly inclusion rules accumulate. This is the default value.
szWochangestatus	WOCS	char	NONE	NONE
This field determines the value of the work order status field (user defined code 00/SS) for a configured item. Sales Order Entry has processing options that determine the beginning status and the change status of a work order for a configured item. The processing options work as follows: o If the current status of the work order is greater than or equal to the work order change status, the system enters the code value from the change status processing option into the status field on the work order. o If the current status of the work order is less than the work order change status, the system enters the code value from the beginning status processing option into the status field on the work order.
cDisplaycalculatedsegment	DCSG	char	NONE	NONE
A setting that indicates whether the system displays calculated segments during order entry. Valid values are: 0 The system does not displays calculated segments when you enter an order; however, it stores the value of the segment in history. When you enter a multilevel configured item, the system does not displays levels that have only calculated segments. The default value is 0. 1 The system displays calculated segments when you enter an order.
cSuppressErrorMessage	EV01	char	NONE	NONE
An option that specifies the type of processing for an event.
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.
cConfiguratorErrorCharacter	CEC	char	OPT	NONE
A code that indicates an error in the calculation. This code is a single character value. For example, the error character can be set to error = !. The default value is 1.