Distribution and Manufacturing Constant

Purpose of Document

The audience for this note is someone with developer level knowledge.

1154087.1_f4009_f4009t_f4009t1This document is provides simplified mapping on columns from F4009, F4009T and F4009T1 with parameters and controls on form. And this document can be used where the setting reside and what are the settings from F4009.

Note:

This note is written based on EnterpriseOne application release 9.0
Most of column/flag may not be descriptive
Different E1 release may not have a certain columns
Currently value from F4009 can be accessed through the Branch/Plant Constants (P41001).
F4009 contains only a single record with blank system code so all the values are to be accessed through Form Menu
All the columns define from F4009 are to be repeated either in 'System Constants' and 'Pricing Constants'
F4009T (Distribution Manufacturing Constants Tag File) is used only in Xe and ERP8
In 8.9, 8.10, 8.11, 8.11sp1, 8.12 and 9.0 columns in F4009T are merged into F4009 (Distribution/Manufacturing Constants)
A new table F4009T1 (Distribution/Manufacturing Constants Tag Table) is added to hold information on Taxed Sales Price

Below are simplified mappings on columns by actual usage:

<>A character used to identify a currency code in advanced pricing formulas. When entering a currency code preceded by this character,the system recognizes the entry as a currency code for formula pricing calculations. Alphabetic, numeric, and mathematical function (for example, +,-, *, /) values are not valid in this field.

F4009 - Distribution/Manufacturing Constants

Parameters	Col Alias	Data Dictionary	FC Control(FormID)	Form
cUoMConversionByBranch	bumc	Process UOM Conversions by Branch	UOM Conversions by Branch via [Work With Branch/Plant Constants] > (Form Exit) Sys. Constants	A code that indicates how the system uses the branch/plant within the Item Specific Unit of Measure Conversion tables. Valid values are: Y: The system displays the item-specific conversion table when adding an item to a specific branch/plant. N: The system displays the item-specific conversion table for all branch/plants from the Item Master table. (Default = N)
cSupplementalDataByBranch	bsdb	Process Supplemental Data Base by Branch	Supplemental DB by Branch (Hidden in Sys. Constants screen. Obsolete)	A code that indicates how the system uses the branch/plant within the Inventory Management Supplemental Database. Valid values are: Y: The supplemental data is unique by item and branch. N: The supplemental data is unique by item only. (Default = N)
cAllowDuplicateLots	ulot	Allow Duplicate Lots	Allow Duplicate Lots (Sys. Constants)	A code that determines whether the system can assign the same lot to multiple items. Valid values are: 1: Do not allow duplicate lots. The lot is restricted to one item and one branch/plant. 2: Allow duplicate lots. Can create a lot that contains multiple items and branch/plants. 3: Do not allow duplicate lots. The lot is restricted to one item, but can contain quantities in multiple branch/plants. (Default = 1)
cUpdateAverageCost	avgc	Update Average Cost On-Line	Update Average Cost On-Line (System Constants)	A code that indicates when the system calculates the new average cost for an item. Valid values are: Y: The system calculates a new average cost immediately after any transaction occurs that affects the average cost of an item. N: All processes that affect average cost create transactions to the Average Cost Work table (F41051). The system calculates a new average cost when running the Average Cost Update program. (Default = N)
cAdvancedSalesPricing	advp	Advanced Sales Pricing (Y/N)	Advanced Sales Pricing (Y/N) via [Work With Branch/Plant Constants] > (Form Exit) Price Constants	Indicates how the system determines the price of items within the system. If the system includes the advanced pricing module, this feature can be used Y: The system will use advanced pricing. N: The system will NOT use advanced pricing. (Default = N)
cSalesPriceRetrievalUoM	umb1	Sales Price Retrieval UOM	Sales Price Retrieval UOM (System Constants)	A code that specifies the unit of measure that the system uses for retrieving base prices and price adjustments for sales order processing, service and warranty management, and ship and debit processing. The system allows users to define base prices in the Item Base Price File table (F4106) and price adjustments in the Price Adjustment Detail table (F4072) in various units of measure. If the base price or price adjustments are not found in the specified unit of measure, then the system uses the primary unit of measure for the item.
cSalesPriceBasedOnDate	cp01	Sales Price Based On Date	Sales Price Based On Date (System Constants)	A code that determines how the system updates the Price Effective Date in the Sales Order Header (F4201) and Detail (F4211) tables. In the Sales Order Management system, the system uses the Price Effective Date to retrieve the base price from the Sales Order Header table (F4106) and price adjustments from Sales Order Detail table (F4072). In application of P41001 - System Constants DD item used is A202 with DD override to enable user to choose UDC UDC 40/DB - Pricing Based on Date. Available values are, Blank Transaction/Order Date 1 Requested Date 2 Promised Ship Date 3 Original Ship Date 4 Actual Ship Date 5 System Date 6 Invoice Date
cSymbolToIdentifyVariable	cp02	Symbol to Identify Variable Table	Symbol to Identify Variable Table (Pricing Constants)	A character used to identify a variable table in advanced pricing in the system. When entering a table name preceded by this character, the *system recognizes the name as a table name for formula pricing calculations. Alphabetic, numeric, and mathematical function (for example,+,-,,/) values are not valid in this field.
cSymbolToIdentifyUoM	cp03	Symbol to Identify Unit of Measure	Symbol to Identify UOM (Pricing Constants)	A character used to identify a unit of measure in advanced pricing formulas. When entering a unit of measure preceded by this character,the system recognizes the entry as a unit of measure for formula pricing calculations. Alphabetic, numeric, and mathematical function (for example,+,-,*,/) values are not valid in this field.
cSymbolToIdentifyCurrency	cp04	Symbol to Identify Currency Code	Symbol to Identify Currency (Pricing Constants)
cSymbolToIdentifyColumn	cp05	Symbol to Identify Data Base Field	Symbol to Identify Data Fields (Pricing Constants)	Character used to identify database fields in advanced pricing formulas. When entering a database field preceded by this character, the system recognizes the entry as a database field for formula pricing calculations. Alphabetic, numeric, and mathematical function (for example, +,-, *, /) values are not valid in this field.
cPurchasePriceRetrivalUOM	cp06	Purchase Price Retrieval UOM	Purchase Price Retrieval UOM (System Constants)	A code that represents the unit of measure that the system retrieves for the purchase base price (F41061) during purchase order processing. If specifying the unit of measure for transaction or pricing and the system does not find a record in that unit of measure, the system repeats the process using the primary unit of measure of the item.
cSystemConstants07	cp07	Purchase Rebate Category Code	Purchase Rebate Category Code (System Constants)	A number that determines which category code the system uses in the criteria for inclusion comparison.
cSystemConstants08	cp08	Pricing Audit (Y/N)	Pricing Audit (Y/N) (Not Implemented)	Code indicating whether the system tracks changes to the following pricing files: o Price Adjustment Schedule (F4070) o Price Adjustment Definition (F4071) o Price Adjustment Detail (F4072) o Price Variable (F4075) o Price Formula (F4076) o Base Prices (F4106) If tracking changes, the system creates records in the following audit files: o Price Adjustment Schedule Audit (F4070A) o Price Adjustment Name Audit (F4071A) o Price Adjustment Detail Audit (F4072A) o Price Variable Table Audit (F4075A) o Price Formula Audit (F4076A) o Base Prices Audit (F4106A) Valid codes are: Y: The system tracks changes and creates audit records N: The system does not track changes (Default N)
cSystemConstants09	cp09	Enable Internet PPAT Message Flag	Enable Internet PPAT Message Flag (Not Implemented)	A code that indicates whether the system sends over the internet any messages that are generated by Distribution programs. For EnterpriseOne, a checkmark indicates Y (Yes). (Default = N)
cSystemConstantsCode10	cp10	Non Coexisting Lot Processing	Non Coexisting Lot Processing (Obsolete)	A code that the system uses to determine the maximum length of the Lot/Serial Number field for lot processing. The length of the field depends on whether OneWorld coexists with WorldSoftware. For OneWorld, a check indicates non-coexistence and a maximum 30-character lot; a blank indicates coexistence and a maximum 12-character lot.
cControlCodeECS	cctl	Control Code - ECS	ECS Control (Y/N) (System Constants)	A code that indicates whether to use the Energy and Chemical System application.
cShipAscendingDateRule	sadr	Ship Ascending Date Rule	Ship Ascending Date Rule (System Constants)	An option that indicates whether the system applies the ship ascending date rule by customer and by item. When choosing this option, the system applies the ship ascending date rule during the sales order entry, pick slip/commitment processing, and ship confirmation processes. When the system applies the Ship Ascending Date rule, the system sorts shipping customers' lots in ascending order by expiration date, sell by date, or best before date. (Default = N)
cAdvancedProcurementPricing	cp11	Advanced Procurement Pricing (Y/N)	Advanced Procurement Pricing (Y/N) (Pricing Constants)	Use this field to specify whether to apply advanced pricing to the purchase price. Valid values are: Y: Apply advanced pricing to the purchase price. N: Apply standard price adjustments to the purchase price.
cScientificRounding	cp12	Scientific Rounding	Scientific Rounding (System Constants)	A flag that indicates if scientific rounding should be performed. Currently this feature is only enabled for Quality Management Test Results. Valid Values are: 0 = Scientific Rounding should not be performed 1 = Scientific Rounding should be performed (Default = 0)
cRequirePriceApproval	cp13	Require Price Approval	Require Price Approval (Pricing Constants)	A value that specifies whether the user wants all price changes provided through price approval workflow. Y: Apply price approval workflow. N: Do not apply price approval workflow.
cProcurementCostBasedOnDate	cp14	Procurement Cost Based On Date	Procurement Cost Based On Date (Not used)
cSystemConstantsCode15	cp15	System Constants Code 15	System Constants Code 15 (Not used)
cUseAuditLogForSalesOrderC	cp16	Use Audit Log for Sales Order Changes	Use Audit Log for Sales Order Changes (Not used)	An option that indicates whether the system writes sales order changes to an audit log.
cReasonCodeRequired	cp17	Reason Code Required	Reason Code Required (Obsolete - Moved to Processing option of P4210)	An option that indicates whether a reason code is required for each sales order change.
cApprovalProcessRequired	cp18	Approval Process Required	Approval Process Required (Obsolete - Moved to Processing Option of P4210)	An option that specifies whether changes made to a sales order will go through an approval process.
cUseCustomerSet	cp19	Use Customer Set	Use Customer Set (System Constants)	An option that specifies whether the system uses the customer set.
cPrepaymentProcessing	cp20	Prepayment Processing	Prepayment Processing (Obsolete - Moved to processing optoins)	An option that indicates whether the system is using prepayment processing.
cCriticalHoldDecoupling	chdc
cEnhancedLotProcessing	elot
cAdjustmentRetrievalMethod	ajrm
szOrganizationTypeStructur	ostp
cPricingAddressFlag	prad
cPreferenceRetrievalUOM	cp22	Preference Retrieval UOM	Pref Retriev UOM (System Constants)	A code that specifies the unit of measure that the system uses for retrieving advanced preference adjustments during sales order processing. The system allows the definition of advanced preference adjustments in the Adjustment Detail (F4072) table in various unit of measures. If specifying the unit of measure for transaction or pricing and the system does not locate a record in that unit of measure, the system repeats the process using the primary unit of measure of the item.
szPreferenceSchedule	prsn	Preference Schedule	Preference Schedule (System Constants)	A user defined code (40/AP) that identifies the advanced preference schedule that the system uses when resolving preferences. The advanced preference schedule determines which preferences the system resolves when using the advanced preference functionality. Preference schedules cannot be maintained directly through user defined codes, use the Price Adjustment Schedule (P4070) program instead.
cPromotionsMultipleResolut	pmrf	Multiple Promotions Resolution Flag	Multiple Promotions Resolution Flag (Pricing Constants)	An option that specifies which promotion to use when more than one promotion is in effect for an item or customer.
cPromotionsSystemFlag	prsf	Promotions System Flag	Promotions System Flag (Pricing Constants)	An option that indicates whether an in-house or third-party promotion package is being used. Valid values are: 0: No promotions system 1: J.D. Edwards ERP promotions system 2: Third-party promotions system
cFlagForFuture23	cp23
cFlagForFuture24	cp24
cFlagForFuture25	cp25
cFlagForFuture26	cp26
cFlagForFuture27	cp27
cSalesPricingOnOverridePrice	cp28	Sales Pricing On Override Price	Sales Pricing On Override Price (Pricing Constants)	A value that specifies whether the user wants the system to search and apply additional adjustments when the price is overridden on the order line. Values are: Y: Apply adjustments for the overridden price. N: Do not apply adjustments for the overridden price.
cProcPricingOnOverridePrice	cp29	Procurement Pricing On Override Price	Procurement Pricing On Override Price (Pricing Constants)	A value that specifies whether the user wants the system to search and apply additional adjustments when the price is overridden on the order line. Values are: Y: Apply adjustments for the overridden price. N: Do not apply adjustments for the overridden price.
cSymboltoIdentifyTestResName	cp30	Symbol to Identify Test Result Name	Symbol to Identify Test Result Name (Pricing Constants)	A character that used to identify a Test Result Name in an advanced pricing formula in the system. When entering a Test Result Name preceded by this character, the system recognizes the name as a Test Result name for formula pricing calculations. Alphabetic, numeric, parenthesis, and mathematical function (for example,+,-,*,/) values are not valid in this field.
cSymboltoIdentifyFnName	cp31	Symbol to Identify Function Name	Symbol to Identify Function Name (Pricing Constants)	A character used to identify a Function Name in an advanced pricing formula in the system. When entering a Function Name preceded by this character, the system recognizes the name as a Function name for formula pricing calculations. Alphabetic, numeric, parenthesis, and mathematical function (for example,+,-,*,/) values are not valid in this field.
cSymboltoIdentifyFnArgSep	cp32	Symbol to Identify Func. Arg. Separator	Symbol to Identify Func. Arg. Separator (Pricing Constants)	A character used to identify a Function Argument Separator in an advanced pricing formula in the system. When entering a Function, the system recognizes the arguments of the function based on the Function Argument Separator. Alphabetic, numeric, parenthesis, and mathematical function (for example,+,-,*,/) values are not valid in this field.
cSymboltoIdentifyAdjDetailRef	cp33	Symbol to Identify Adjustment Detail Ref	Symbol to Identify Adjustment Detail Ref (Pricing Constants)	A character used to identify an Adjustment Detail Reference sequence in an advanced pricing formula in the system. When entering an Adjustment Detail Reference, preceded by this character, the system recognizes the sequence as an Adjustment Detail Reference sequence for formula pricing calculations. Alphabetic, numeric, parenthesis, and mathematical function (for example,+,-,*,/) values are not valid in this field.
cPricingCacheFlag	cp34	Accelerated Pricing Resolution Engine	Accelerated Pricing Resolution Engine (Pricing Constants)	An option that determines the use of the Accelerated Pricing Resolution Engine. Values are: Blank or 0: Do not allow use. 1: Allow use. 2: Auto Load. Auto load automatically loads the cache when any user processes a transaction using one of the cached tables. It is recommended that you thoroughly read and understand the details of how the Accelerated Pricing Resolution Engine works, its limitations, and how to manage it before you enable it. Refer to <Document 760588.1> - E1: 45: Accelerated Pricing Resolution Engine (F4072, F4092, F40941, F40942, F40943)

Parameters

Col
Alias

Data
Dictionary

FC Control(FormID)

Form

cUoMConversionByBranch

bumc

Process UOM Conversions by Branch

UOM Conversions by Branch via [Work With Branch/Plant Constants] > (Form Exit) Sys. Constants

A code that indicates how the system uses the branch/plant within the Item Specific Unit of Measure Conversion tables. Valid values are:

Y: The system displays the item-specific conversion table when adding an item to a specific branch/plant.
N: The system displays the item-specific conversion table for all branch/plants from the Item Master table.

(Default = N)

cSupplementalDataByBranch

bsdb

Process Supplemental Data Base by Branch

Supplemental DB by Branch

(Hidden in Sys. Constants screen. Obsolete)

A code that indicates how the system uses the branch/plant within the Inventory Management Supplemental Database. Valid values are:

Y: The supplemental data is unique by item and branch.
N: The supplemental data is unique by item only.

(Default = N)

cAllowDuplicateLots

ulot

Allow Duplicate Lots

Allow Duplicate Lots

(Sys. Constants)

A code that determines whether the system can assign the same lot to multiple items. Valid values are:

1: Do not allow duplicate lots. The lot is restricted to one item and one branch/plant.
2: Allow duplicate lots. Can create a lot that contains multiple items and branch/plants.
3: Do not allow duplicate lots. The lot is restricted to one item, but can contain quantities in multiple branch/plants.

(Default = 1)

cUpdateAverageCost

avgc

Update Average Cost On-Line

Update Average Cost On-Line

(System Constants)

A code that indicates when the system calculates the new average cost for an item. Valid values are:

Y: The system calculates a new average cost immediately after any transaction occurs that affects the average cost of an item.
N: All processes that affect average cost create transactions to the Average Cost Work table (F41051). The system calculates a new average cost when running the Average Cost Update program.

(Default = N)

cAdvancedSalesPricing

advp

Advanced Sales Pricing (Y/N)

Advanced Sales Pricing (Y/N) via [Work With Branch/Plant Constants] > (Form Exit) Price Constants

Indicates how the system determines the price of items within the system. If the system includes the advanced pricing module, this feature can be used

Y: The system will use advanced pricing.
N: The system will NOT use advanced pricing.

(Default = N)

cSalesPriceRetrievalUoM

umb1

Sales Price Retrieval UOM

Sales Price Retrieval UOM

(System Constants)

A code that specifies the unit of measure that the system uses for retrieving base prices and price adjustments for sales order processing, service and warranty management, and ship and debit processing. The system allows users to define base prices in the Item Base Price File table (F4106) and price adjustments in the Price Adjustment Detail table (F4072) in various units of measure.

If the base price or price adjustments are not found in the specified unit of measure, then the system uses the primary unit of measure for the item.

cSalesPriceBasedOnDate

cp01

Sales Price Based On Date

Sales Price Based On Date

(System Constants)

A code that determines how the system updates the Price Effective Date in the Sales Order Header (F4201) and Detail (F4211) tables. In the Sales Order Management system, the system uses the Price Effective Date to retrieve the base price from the Sales Order Header table (F4106) and price adjustments from Sales Order Detail table (F4072).

In application of P41001 - System Constants DD item used is A202 with DD override to enable user to choose UDC UDC 40/DB - Pricing Based on Date. Available values are,
Blank Transaction/Order Date
1 Requested Date
2 Promised Ship Date
3 Original Ship Date
4 Actual Ship Date
5 System Date
6 Invoice Date

cSymbolToIdentifyVariable

cp02

Symbol to Identify Variable Table

Symbol to Identify Variable Table

(Pricing Constants)

A character used to identify a variable table in advanced pricing in the system. When entering a table name preceded by this character, the system recognizes the name as a table name for formula pricing calculations. Alphabetic, numeric, and mathematical function (for example,+,-,*,/) values are not valid in this field.

cSymbolToIdentifyUoM

cp03

Symbol to Identify Unit of Measure

Symbol to Identify UOM
(Pricing Constants)

A character used to identify a unit of measure in advanced pricing formulas. When entering a unit of measure preceded by this character,the system recognizes the entry as a unit of measure for formula pricing calculations. Alphabetic, numeric, and mathematical function (for example,+,-,*,/) values are not valid in this field.

cSymbolToIdentifyCurrency

cp04

Symbol to Identify Currency Code

Symbol to Identify Currency
(Pricing Constants)

cSymbolToIdentifyColumn

cp05

Symbol to Identify Data Base Field

Symbol to Identify Data Fields
(Pricing Constants)

Character used to identify database fields in advanced pricing formulas. When entering a database field preceded by this character, the system recognizes the entry as a database field for formula pricing calculations. Alphabetic, numeric, and mathematical function (for example, +,-, *, /) values are not valid in this field.

cPurchasePriceRetrivalUOM

cp06

Purchase Price Retrieval UOM

Purchase Price Retrieval UOM

(System Constants)

A code that represents the unit of measure that the system retrieves for the purchase base price (F41061) during purchase order processing.

If specifying the unit of measure for transaction or pricing and the system does not find a record in that unit of measure, the system repeats the process using the primary unit of measure of the item.

cSystemConstants07

cp07

Purchase Rebate Category Code

Purchase Rebate Category Code
(System Constants)

A number that determines which category code the system uses in the criteria for inclusion comparison.

cSystemConstants08

cp08

Pricing Audit (Y/N)

Pricing Audit (Y/N)
(Not Implemented)

Code indicating whether the system tracks changes to the following pricing files:

o Price Adjustment Schedule (F4070)
o Price Adjustment Definition (F4071)
o Price Adjustment Detail (F4072)
o Price Variable (F4075)
o Price Formula (F4076)
o Base Prices (F4106)

If tracking changes, the system creates records in the following audit files:

o Price Adjustment Schedule Audit (F4070A)
o Price Adjustment Name Audit (F4071A)
o Price Adjustment Detail Audit (F4072A)
o Price Variable Table Audit (F4075A)
o Price Formula Audit (F4076A)
o Base Prices Audit (F4106A)

Valid codes are:

Y: The system tracks changes and creates audit records
N: The system does not track changes

(Default N)

cSystemConstants09

cp09

Enable Internet PPAT Message Flag

Enable Internet PPAT Message Flag

(Not Implemented)

A code that indicates whether the system sends over the internet any messages that are generated by Distribution programs.

For EnterpriseOne, a checkmark indicates Y (Yes).
(Default = N)

cSystemConstantsCode10

cp10

Non Coexisting Lot Processing

Non Coexisting Lot Processing

(Obsolete)

A code that the system uses to determine the maximum length of the Lot/Serial Number field for lot processing. The length of the field depends on whether OneWorld coexists with WorldSoftware.

For OneWorld, a check indicates non-coexistence and a maximum 30-character lot; a blank indicates coexistence and a maximum 12-character lot.

cControlCodeECS

cctl

Control Code - ECS

ECS Control (Y/N)

(System Constants)

A code that indicates whether to use the Energy and Chemical System application.

cShipAscendingDateRule

sadr

Ship Ascending Date Rule

Ship Ascending Date Rule

(System Constants)

An option that indicates whether the system applies the ship ascending date rule by customer and by item. When choosing this option, the system applies the ship ascending date rule during the sales order entry, pick slip/commitment processing, and ship confirmation processes. When the system applies the Ship Ascending Date rule, the system sorts shipping customers' lots in ascending order by expiration date, sell by date, or best before date.
(Default = N)

cAdvancedProcurementPricing

cp11

Advanced Procurement Pricing (Y/N)

Advanced Procurement Pricing (Y/N)

(Pricing Constants)

Use this field to specify whether to apply advanced pricing to the purchase price. Valid values are:

Y: Apply advanced pricing to the purchase price.
N: Apply standard price adjustments to the purchase price.

cScientificRounding

cp12

Scientific Rounding

Scientific Rounding

(System Constants)

A flag that indicates if scientific rounding should be performed.
Currently this feature is only enabled for Quality Management Test Results.
Valid Values are:

0 = Scientific Rounding should not be performed
1 = Scientific Rounding should be performed

(Default = 0)

cRequirePriceApproval

cp13

Require Price Approval

Require Price Approval

(Pricing Constants)

A value that specifies whether the user wants all price changes provided through price approval workflow.

Y: Apply price approval workflow.
N: Do not apply price approval workflow.

cProcurementCostBasedOnDate

cp14

Procurement Cost Based On Date

Procurement Cost Based On Date
(Not used)

cSystemConstantsCode15

cp15

System Constants Code 15

System Constants Code 15
(Not used)

cUseAuditLogForSalesOrderC

cp16

Use Audit Log for Sales Order Changes

Use Audit Log for Sales Order Changes
(Not used)

An option that indicates whether the system writes sales order changes to an audit log.

cReasonCodeRequired

cp17

Reason Code Required

Reason Code Required
(Obsolete - Moved to Processing option of P4210)

An option that indicates whether a reason code is required for each sales order change.

cApprovalProcessRequired

cp18

Approval Process Required

Approval Process Required
(Obsolete - Moved to Processing Option of P4210)

An option that specifies whether changes made to a sales order will go through an approval process.

cUseCustomerSet

cp19

Use Customer Set

Use Customer Set
(System Constants)

An option that specifies whether the system uses the customer set.

cPrepaymentProcessing

cp20

Prepayment Processing

Prepayment Processing
(Obsolete - Moved to processing optoins)

An option that indicates whether the system is using prepayment processing.

cCriticalHoldDecoupling

chdc

cEnhancedLotProcessing

elot

cAdjustmentRetrievalMethod

ajrm

szOrganizationTypeStructur

ostp

cPricingAddressFlag

prad

cPreferenceRetrievalUOM

cp22

Preference Retrieval UOM

Pref Retriev UOM

(System Constants)

A code that specifies the unit of measure that the system uses for retrieving advanced preference adjustments during sales order processing. The system allows the definition of advanced preference adjustments in the Adjustment Detail (F4072) table in various unit of measures.

If specifying the unit of measure for transaction or pricing and the system does not locate a record in that unit of measure, the system repeats the process using the primary unit of measure of the item.

szPreferenceSchedule

prsn

Preference Schedule

Preference Schedule

(System Constants)

A user defined code (40/AP) that identifies the advanced preference schedule that the system uses when resolving preferences. The advanced preference schedule determines which preferences the system resolves when using the advanced preference functionality.

Preference schedules cannot be maintained directly through user defined codes, use the Price Adjustment Schedule (P4070) program instead.

cPromotionsMultipleResolut

pmrf

Multiple Promotions Resolution Flag

Multiple Promotions Resolution Flag

(Pricing Constants)

An option that specifies which promotion to use when more than one promotion is in effect for an item or customer.

cPromotionsSystemFlag

prsf

Promotions System Flag

Promotions System Flag

(Pricing Constants)

An option that indicates whether an in-house or third-party promotion package is being used. Valid values are:

0: No promotions system
1: J.D. Edwards ERP promotions system
2: Third-party promotions system

cFlagForFuture23

cp23

cFlagForFuture24

cp24

cFlagForFuture25

cp25

cFlagForFuture26

cp26

cFlagForFuture27

cp27

cSalesPricingOnOverridePrice

cp28

Sales Pricing On Override Price

Sales Pricing On Override Price

(Pricing Constants)

A value that specifies whether the user wants the system to search and apply additional adjustments when the price is overridden on the order line. Values are:

Y: Apply adjustments for the overridden price.
N: Do not apply adjustments for the overridden price.

cProcPricingOnOverridePrice

cp29

Procurement Pricing On Override Price

Procurement Pricing On Override Price

(Pricing Constants)

A value that specifies whether the user wants the system to search and apply additional adjustments when the price is overridden on the order line. Values are:

Y: Apply adjustments for the overridden price.
N: Do not apply adjustments for the overridden price.

cSymboltoIdentifyTestResName

cp30

Symbol to Identify Test Result Name

Symbol to Identify Test Result Name

(Pricing Constants)

A character that used to identify a Test Result Name in an advanced pricing formula in the system. When entering a Test Result Name preceded by this character, the system recognizes the name as a Test Result name for formula pricing calculations. Alphabetic, numeric, parenthesis, and mathematical function (for example,+,-,*,/) values are not valid in this field.

cSymboltoIdentifyFnName

cp31

Symbol to Identify Function Name

Symbol to Identify Function Name

(Pricing Constants)

A character used to identify a Function Name in an advanced pricing formula in the system. When entering a Function Name preceded by this character, the system recognizes the name as a Function name for formula pricing calculations. Alphabetic, numeric, parenthesis, and mathematical function (for example,+,-,*,/) values are not valid in this field.

cSymboltoIdentifyFnArgSep

cp32

Symbol to Identify Func. Arg. Separator

Symbol to Identify Func. Arg. Separator

(Pricing Constants)

A character used to identify a Function Argument Separator in an advanced pricing formula in the system. When entering a Function, the system recognizes the arguments of the function based on the Function Argument Separator. Alphabetic, numeric, parenthesis, and mathematical function (for example,+,-,*,/) values are not valid in this field.

cSymboltoIdentifyAdjDetailRef

cp33

Symbol to Identify Adjustment Detail Ref

Symbol to Identify Adjustment Detail Ref

(Pricing Constants)

A character used to identify an Adjustment Detail Reference sequence in an advanced pricing formula in the system. When entering an Adjustment Detail Reference, preceded by this character, the system recognizes the sequence as an Adjustment Detail Reference sequence for formula pricing calculations. Alphabetic, numeric, parenthesis, and mathematical function (for example,+,-,*,/) values are not valid in this field.

cPricingCacheFlag

cp34

Accelerated Pricing Resolution Engine

(Pricing Constants)

An option that determines the use of the Accelerated Pricing Resolution Engine.
Values are:
Blank or 0: Do not allow use.
1: Allow use.
2: Auto Load.
Auto load automatically loads the cache when any user processes a transaction using one of the cached tables.
It is recommended that you thoroughly read and understand the details of how the Accelerated Pricing Resolution Engine works, its limitations, and how to manage it before you enable it.
Refer to <Document 760588.1> - E1: 45: Accelerated Pricing Resolution Engine (F4072, F4092, F40941, F40942, F40943)

F4009T - Distribution/Manufacturing Constants Tag File (Obsolete for B9)

Parameters	Col Alias	Data Dictionary	FC Control(FormID)	Form
szProductCode	sy	System Code	N/A	A Space. Values defined here is form level data so this value remains blank
cAdvancedProcurementPricing	cp11	Advanced Procurement Pricing (Y/N)	Advanced Procurement Pricing (Y/N) (Pricing Constants)	Use this field to specify whether to apply advanced pricing to the purchase price. Valid values are: Y: Apply advanced pricing to the purchase price. N: Apply standard price adjustments to the purchase price.
cScientificRounding	cp12	Scientific Rounding	Scientific Rounding (System Constants)	A flag that indicates if scientific rounding should be performed. Currently this feature is only enabled for Quality Management Test Results. Valid Values are: 0 = Scientific Rounding should not be performed 1 = Scientific Rounding should be performed (Default = 0)
cRequirePriceApproval	cp13	Require Price Approval	Require Price Approval (Pricing Constants)	A value that specifies whether the user wants all price changes provided through price approval workflow. Y: Apply price approval workflow. N: Do not apply price approval workflow.
cProcurementCostBasedOnDate	cp14	Procurement Cost Based On Date	Procurement Cost Based On Date (Not used)
cSystemConstantsCode15	cp15	System Constants Code 15	System Constants Code 15 (Not used)

Parameters

Col
Alias

Data
Dictionary

FC Control(FormID)

Form

szProductCode

System Code

N/A

A Space. Values defined here is form level data so this value remains blank

cAdvancedProcurementPricing

cp11

Advanced Procurement Pricing (Y/N)

Advanced Procurement Pricing (Y/N)

(Pricing Constants)

Use this field to specify whether to apply advanced pricing to the purchase price. Valid values are:

Y: Apply advanced pricing to the purchase price.
N: Apply standard price adjustments to the purchase price.

cScientificRounding

cp12

Scientific Rounding

Scientific Rounding

(System Constants)

A flag that indicates if scientific rounding should be performed.
Currently this feature is only enabled for Quality Management Test Results.
Valid Values are:

0 = Scientific Rounding should not be performed
1 = Scientific Rounding should be performed

(Default = 0)

cRequirePriceApproval

cp13

Require Price Approval

Require Price Approval

(Pricing Constants)

A value that specifies whether the user wants all price changes provided through price approval workflow.

Y: Apply price approval workflow.
N: Do not apply price approval workflow.

cProcurementCostBasedOnDate

cp14

Procurement Cost Based On Date

Procurement Cost Based On Date
(Not used)

cSystemConstantsCode15

cp15

System Constants Code 15

System Constants Code 15
(Not used)

F4009T1 - Distribution/Manufacturing Constants Tag Table (9.0 and above)

Parameters	Col Alias	Data Dictionary	FC Control(FormID)	Form
cSalesTaxedPricesConstant	tpsc	Sales Taxed Prices	(Check Box) Enable Sales Taxed Prices (System Constants)	This check box is used to indicate whether taxed prices are enabled in the Sales Order Management system. When this check box is selected, additional fields are available for sales order processing. Use in conjunction with the Use Taxed Prices option on a sales order to display, calculate, and store taxed prices and tax amounts. If this check box is not selected, taxed prices are not enabled in the Sales Order Management system.
cCustomerTaxedPrices	ctxp	Customer with Taxed Prices	(Radio Button) By Sold To By Ship To (System Constants)	A code that indicates which customer the system uses to determine whether to use taxed prices for the sales order. Values are: 1 - "Sold to" customer 2 - "Ship to" customer (Actual value saved in F4009T1.CTXP are '1' or '2')
...

Parameters

Col
Alias

Data
Dictionary

FC Control(FormID)

Form

cSalesTaxedPricesConstant

tpsc

Sales Taxed Prices

(Check Box)
Enable Sales Taxed Prices
(System Constants)

This check box is used to indicate whether taxed prices are enabled in the Sales Order Management system. When this check box is selected, additional fields are available for sales order processing. Use in conjunction with the Use Taxed Prices option on a sales order to display, calculate, and store taxed prices and tax amounts. If this check box is not selected, taxed prices are not enabled in the Sales Order Management system.

cCustomerTaxedPrices

ctxp

Customer with Taxed Prices

(Radio Button)
By Sold To
By Ship To
(System Constants)

A code that indicates which customer the system uses to determine whether to use taxed prices for the sales order. Values are:

1 - "Sold to" customer
2 - "Ship to" customer
(Actual value saved in F4009T1.CTXP are '1' or '2')

...

Note:

F4009T1 is available in EnterpriseOne application release 9.0 and above

<Document 1329908.1> - April 5, 2011 - JD Edwards EnterpriseOne Sales Order Tax Inclusive Pricing
<Document 1234293.1> - JD Edwards EnterpriseOne Taxed Prices for Sales Orders 9.0

If Taxed Prices Enhancement is in place, some of routine may replace the call to B4000530(Fetch from F4009) with B4000560 (Fetch from F4009 and the tag table for this enhancement F4009T1).
In changing any value from F4009/F4009T1 database cache has to be reset as the table F4009/F4009T1 are a member of table F98613 which is database cache.
The information written above may be changed without prior notice to reflect constant enhancement which Oracle is executing.
If columns are not defined above those are coming from the Inventory Constants (F41001) table.
If a certain columns are written at form level menu, look for data based on system code (for example, Application Constant information can be found WHERE CISY='42').
If database cache of F4009 is having problem the File can not be accessed (error 3143) may appear. Possible cause can be either database cache is having problem or for the new environment this table is empty. To resolve this issue:

Check data through UTB or Databrowse by allocating Distribution/Manufacturing Constants (F4009) table
If there is data then delete database cache
If this table (F4009) is empty (and no row security) then:

1. Go to Branch/Plant Constants (P41001)
2. (Form Exit) System Constants and verify the default value
3. Click OK which will create a record into F4009
4. (Fast Path) WSJ - Work with Server Job
5. Highlight the logic server (e.g., MYPEDB1)
6. (Row Exit) Reset Cache
7. Tick "Database" and click OK

To discuss information further with Oracle experts and industry peers, we encourage you to review, join or start a discussion in the JDE1 Distribution Community.

To look at upcoming or archived Advisor Webcasts please see Advisor Webcast Details (Doc ID 548764.1) if your topic is not currently scheduled please suggest it.