Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
cCacheActionCode | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event.
|
cCacheCodeError | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event.
|
cRecordFoundInTable | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event.
|
cReturnCursor | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event.
|
cSuppressErrorMessage | SUPPS | char | OPT | NONE |
A flag indicating whether or not runtime error messaging will occur when an error message is issued from a business function.
0 = allow
runtime error message handling.
1 = suppress runtime error message handling. |
szErrorMessageID | DTAI | char | OPT | 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.
|
idCursor | GENLNG | ID | OPT | NONE |
General purpose ID variable. |
nIndexNumber | INT01 | integer | OPT | NONE |
Number of Days in Future to Query for Responses Due.
|
nNumberOfKeys | INT01 | integer | OPT | NONE |
Number of Days in Future to Query for Responses Due.
|
mnJobNumber | JOBS | MATH_NUMERIC | OPT | NONE |
The job number (work station ID) which executed the particular job. |
mnAtoRuleNumber | ATO# | MATH_NUMERIC | OPT | NONE |
The number associated with a set of cross-segment editing rules or assembly inclusion rules. |
mnAtoSeqNumber | ATOS | MATH_NUMERIC | OPT | NONE |
The Sequence number is the rule number within an edit group of cross-segment editing rules or assembly inclusion rules. You can insert a
line within a rule to assign a new sequence number. |
mnIdentifierShortItem | ITM | MATH_NUMERIC | OPT | NONE |
An inventory item number. The system provides three separate item numbers plus an extensive cross-reference capability to other item
numbers (see data item XRT) to accommodate substitute item numbers, replacements, bar codes, customer numbers, supplier numbers, and
so forth. The item numbers are as follows:
o Item Number (short) - An eight-digit, computer-assigned item number
o 2nd Item Number - The
25-digit, free-form, user defined alphanumeric item number
o 3rd Item Number - Another 25-digit, free-form, user defined alphanumeric item
number |
mnParentSegmentNumber | PEL | MATH_NUMERIC | OPT | NONE |
A number that establishes the sequence in which the segments were defined in the system. Segment numbers are user
defined.
Cross-segment editing rules reference the segment numbers to ensure that the set of values defines a valid configuration.
Assembly inclusion rules
reference segment numbers and their associated values to define prices, component parts, routing, and calculated values for configured items.
|
mnSegmentProductFamilyNum | PSIN | MATH_NUMERIC | OPT | NONE |
The configured item that a segment in an Assembly Inclusion Rule references. |
mnChildSegmentNumber | CEL | MATH_NUMERIC | OPT | NONE |
Reserved by J.D. Edwards
A segment answer that is used for comparison in a cross-segment editing rule.
|
mnSequenceNoOperations | OPSQ | MATH_NUMERIC | OPT | NONE |
A number used to indicate an order of succession.
In routing instructions, a number that sequences the fabrication or assembly steps in the
manufacture of an item. You can track costs and charge time by operation.
In bills of material, a number that designates the routing step in the
fabrication or assembly process that requires a specified component part. You define the operation sequence after you create the routing
instructions for the item. The Shop Floor Management system uses this number in the backflush/preflush by operation process.
In engineering
change orders, a number that sequences the assembly steps for the engineering change.
For repetitive manufacturing, a number that
identifies the sequence in which an item is scheduled to be produced.
Skip To fields allow you to enter an operation sequence that you want to begin
the display of information.
You can use decimals to add steps between existing steps. For example, use 12.5 to add a step between steps
12 and 13. |
mnUnitPriceEntered | UPAX | MATH_NUMERIC | OPT | NONE |
The price charged for the unit of measure in the adjoining field. Use these fields, for example, if your primary unit of measure is EA (each),
but you typically use a list price per box. |
mnAmountMemoCost1 | CST1 | MATH_NUMERIC | OPT | NONE |
A user-defined cost the system uses based on information that you supply,which includes the name of the costing method and the method
of calculation. |
mnQtyRequiredStandard | QNTY | MATH_NUMERIC | OPT | NONE |
The number of units that the system applies to the transaction.
|
mnLeadtimeOffsetDays | LOVD | MATH_NUMERIC | OPT | NONE |
The number of days that a part is needed before or after the start date of a manufacturing work order. The system adds the leadtime offset
days for the part to the start date of the work order to determine the actual date that the part is required. To indicate that a part is needed prior
to the work order start date, enter the days as a negative number. To indicate how many days after the work order start date that the part is
required, enter a positive number. |
mnBubbleSequence | BSEQ | MATH_NUMERIC | OPT | NONE |
A secondary bill of material sequence number that indicates the drawing bubble number. |
mnPercentOfScrap | SCRP | MATH_NUMERIC | OPT | NONE |
The percentage of unusable component material that is created during the manufacture of a particular parent item.
During DRP/MPS/MRP
generation, the system increases gross requirements for the component item to compensate for the loss.
Note: Shrink is the expected loss of
parent items (and hence, components) due to the manufacturing process. Shrink and scrap are compounded to figure the total loss in the
manufacture of a particular item. Accurate shrink and scrap factors can help to produce more accurate planning calculations.
Enter percentages
as whole numbers: 5 percent as 5.0
|
mnUniqueKeyIDInternal | UKID | MATH_NUMERIC | OPT | NONE |
This field is a unique number used to identify a record in a file. |
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. |
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. |
mnTimeOfDay | TDAY | MATH_NUMERIC | OPT | NONE |
The computer clock in hours:minutes:seconds. |
mnItemNumberShortKit | KIT | MATH_NUMERIC | OPT | NONE |
The system provides for three separate item numbers.
1. Item Number (short) - An eight-digit, computer assigned, completely
non-significant item number.
2. 2nd Item Number - The 25-digit, free form, user defined alphanumeric item number.
3. 3rd Item Number - Another
25-digit, free form, user defined alphanumeric item number. |
szCostCenter | MCU | char | OPT | NONE |
An alphanumeric code that identifies a separate entity within a business for which you want to track costs. For example, a business unit
might be a warehouse location, job, project, work center, branch, or plant.
You can assign a business unit to a document, entity, or person for
purposes of responsibility reporting. For example, the system provides reports of open accounts payable and accounts receivable by
business unit to track equipment by responsible department.
Business unit security might prevent you from viewing information about business units
for which you have no authority.
|
szIdentifier2ndItem | LITM | char | OPT | NONE |
A number that identifies the item. The system provides three separate item numbers plus an extensive cross-reference capability to
alternative item numbers. The three types of item numbers are:
Item Number (short)
An 8-digit, computer-assigned item number.
2nd Item Number
A
25-digit, user defined, alphanumeric item number.
3rd Item Number
Another 25-digit, user defined, alphanumeric item number.
In addition to
these three basic item numbers, the system provides an extensive cross-reference search capability. You can define numerous
cross-references to alternative part numbers. For example, you can define substitute item numbers, replacements, bar codes, customer numbers, or
supplier numbers.
|
szIdentifier3rdItem | AITM | char | OPT | NONE |
The system provides three separate item numbers plus an extensive cross-reference capability to alternate item numbers. These item
numbers are as follows:
1. Item Number (short) - An 8-digit, computer-assigned item number.
2. 2nd Item Number - The 25-digit, free-form, user
defined alphanumeric item number.
3. 3rd Item Number - Another 25-digit, free-form, user defined alphanumeric item number.
In addition to
these three basic item numbers, an extensive cross-reference search capability has been provided (see XRT). Numerous cross references to
alternate part numbers can be user defined, such as substitute item numbers, replacements, bar codes, customer numbers, or supplier
numbers. |
szBranchComponent | CMCU | char | OPT | NONE |
A secondary or lower-level business unit. The system uses the value that you enter to indicate that a branch or plant contains several
subordinate departments or jobs. For example, assume that the component branch is named MMCU. The structure of MMCU might be as follows:
Branch/Plant - (MMCU)
Dept A - (MCU)
Dept B - (MCU)
Job 123 - (MCU) |
szDescriptionLine1 | DSC1 | char | OPT | NONE |
Brief information about an item; a remark or an explanation.
|
szAndOrSelectionBeginning | AO5B | char | OPT | NONE |
A collection of open and closed brackets to group conditional configurator rules.
For example, to define the condition (Seg 1 = A OR Seg 2 =
B) AND Seg 3 = C,use the following brackets:
(Seg 1 = A O Seg 2 = B) A Seg 3 = C |
szAndOrSelectionEnding | AO5E | char | OPT | NONE |
A collection of open and closed brackets to group conditional configurator rules.
For example, to define the condition (Seg 1 = A OR Seg 2 =
B) AND Seg 3 = C,use the following brackets:
(Seg 1 = A O Seg 2 = B) A Seg 3 = C |
szCostCenterHeader | EMCU | char | OPT | NONE |
A business unit is an accounting entity required for management reporting. It can be a profit center, department, warehouse location, job,
project, work center, branch/plant, and so forth.
This business unit is from the business unit entered on the header of a sales/purchase order for
reporting purposes.
This data is always right justified on entry (for example, CO123 would appear as _______CO123). A security mechanism
has been provided to inhibit users from entering or locating business units outside the scope of their authority. |
szRelationship | VALR | char | OPT | NONE |
A user defined code (00/VA) that indicates the relationship between the ranges of variances that you display. Valid values are:
EQ
Equal
to
LT
Less than
LE
Less than or equal to
GT
Greater than
GE
Greater than or equal to
NE
Not equal to
NL
Not less than
NG
Not greater than
CT
Contains (only allowed in selection for Open Query File function)
CU
Same as "CT" but converts all input data to uppercase letters
|
szSelectionValueAtoIf | ATIV | char | OPT | NONE |
An answer that is valid for the segment and rule relationship. You can enter a specific UDC value or one of the following values:
*VALUES
The system provides multiple values lists for you to use in the logic rule. You can enter up to 45 values.
*BLANK
The system uses a blank
value in the logic rule.
*ZERO
The system searches for amounts equal to zero as part of the logic rule.
*RANGE
The system uses a range of
values (for example, 1 to 50) in the logic rule. You enter the range of values. The first value in the range must be less than the second value.
*ALL
The system uses all values in the logic rule.
|
szLineType | LNTY | char | OPT | 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 |
szUnitOfMeasure | UM | char | OPT | NONE |
A user defined code (00/UM) that identifies the unit of measurement for an amount or quantity. For example, it can represent a barrel, box,
cubic meter, liter, hour, and so on. |
szExternalProgramID | EPGM | char | OPT | NONE |
The name of the external program written by your MIS department, that will be providing values for external variables. |
szDerivedCalculation | DERC | char | OPT | NONE |
An algebraic formula that specifies the quantity, price, hours, or a value associated with a rule.
The following examples illustrate the syntax
for possible derived calculations:
Segment References
o S3 indicates segment 3.
o S3=Piston= indicates segment 3 in item
Piston.
Trigonometric and Logarithmic Functions
o SIN(20) indicates the sine of 20.
o COS(S3) indicates the cosine of segment 3.
o TAN(S4) indicates
the tangent of segment 4.
o ARC(S3) indicates the arctangent of segment 3.
o LOG indicates log to base 10.
o LN indicates natural log.
o 2**5 indicates an exponent, 2 to the fifth power.
Substring
SUBSTR(S10,1,4) indicates that the substring from segment 10 starts at the first
position of the string and includes the first 4 positions.
Concatenations
CONCAT(S3,S4) combines the values of segments 3 and 4.
External
Fields
Specifies the fields from non-configurator tables that you want the system to access as part of a calculation. Use the ampersand character
followed by the field name. For example, &T2AMTU(WD) indicates an amount field in the Item Supplemental Database table, and the WD
data type.
External Programs
Specifies that a program external to the system is to be used for the calculation. Enter the name of the external
program and EXTVAR in the Derived Calculations field.
Smart Parts
PS4 indicates a smart part number P2000 when the value of segment 4 is
2000.
|
szSmartPartCalculation | DERP | char | OPT | NONE |
Defines a formula that calculates the part number associated with a rule. A smart part formula consists of a literal value (constant) and a
segment answer (variable). The literal value must be in single quotes.
For example,
o The part number consists of the literal 'P' and the value of
segment 4.
If the smart part calculation and the value of Segment 4 is 2000, then the smart part would be P2000.
o To reference
segments that have already been entered on a different level, specify the item number of that level with the segment number.
For example, the
notation for Segment 4 of Piston is: Derived Calculation S4=Piston=
o To remove a particular string within a larger string use the substring
function. It removes a string when you define the the segment, beginning position, and length. For example, if Segment 4 equals 1234, the last
three positions (234) can be used with the notation:
SUBSTR(S4,2,3) where 2 is the beginning position and 3 is the length of the substring.
o
To combine two fields, use the concatenation function. For example, CONCAT(S3,S1) which will combine the values of Segment 3 and 1 into
one field. |
szRulesTableName | TBLC | char | OPT | NONE |
The name of a collection of data that you set up to minimize the number of assembly inclusion rules that you need for a configured item. You
must define rule table names in user defined code table 32/TN. A rule table can be accessed by 1 to 20 keys and can return up to 99
values. When you reference a rule table in an assembly inclusion rule, the system uses the rule keys to retrieve the values that are associated
with the rule table. For example, if you defined segment 10 to be the color of an item, you could set the table to retrieve item Red Component
when the customer enters Red for segment 10. In this example, the table would be:
Item Color = Value
Red = Red Component
The table
would include the following: If the color segment value = red, then use item number Red Component on the configured item sales order and
work order parts list.
|
szConfiguredItemAlias | CIA | char | OPT | NONE |
Reserved by J.D. Edwards
A code that references a configured item within a derived calculation. The code is associated with the particular
occurrence of the item in the configuration. It can then be used in a derived calculation to reference that occurrence.
|
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. |
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.
|
szUserId | USER | char | OPT | NONE |
The code that identifies a user profile.
|
szProgramId | PID | char | OPT | NONE |
The number that identifies the batch or interactive program (batch or interactive object). For example, the number of the Sales Order Entry
interactive program is P4210, and the number of the Print Invoices batch process report is R42565.
The program ID is a variable length value.
It is assigned according to a structured syntax in the form TSSXXX, where:
T
The first character of the number is alphabetic and identifies the
type, such as P for Program, R for Report, and so on. For example, the value P in the number P4210 indicates that the object is a
program.
SS
The second and third characters of the number are numeric and identify the system code. For example, the value 42 in the number P4210
indicates that this program belongs to system 42, which is the Sales Order Processing system.
XXX
The remaining characters of the numer are
numeric and identify a unique program or report. For example, the value 10 in the number P4210 indicates that this is the Sales Order Entry
program.
|
szWorkStationId | JOBN | char | OPT | NONE |
The code that identifies the work station ID that executed a particular job.
|
cAtoLineType | ATOT | char | OPT | NONE |
A value that identifies whether the resulting value of the assembly inclusion rule is a part number, price, routing operation, or calculated
value. The valid values are:
P Part List
Q Work Order Component
C Calculation
H Hot Spot
X Price/Cost Adjustment
R Route Sheet |
cAndOrSelection | AO | char | OPT | NONE |
A code that determines whether compound data selection logic is based on an A = AND condition or an O = OR condition. |
cFixedOrVariableQuantity | FOVQ | char | OPT | NONE |
Reserved by J.D. Edwards
A code that specifies whether the quantity of a configured item varies according to the quantity of the parent item
produced or is fixed regardless of the parent quantity. Valid values are:
F
Fixed quantity
V
Variable quantity
|
cConfigureQntySeparately | CQS | char | OPT | NONE |
Reserved by J.D. Edwards
A code that specifies if the item's configuration is entered separately for each quantity of the item. Valid values
are:
0
All quantitiy is configured with a single set of segments.
1
Each item will be configured separately.
|
cWriteAttachedDetailLine | WADL | char | OPT | NONE |
A user defined code (32/WA) that indicates whether the component line generates a detail line that indicates whether the component is
going to be shipped. Valid values are:
0
Do not create a detail line.
1
Create a detail line.
|
cConfiguredItemDestination | CIDN | char | OPT | NONE |
A user defined code (32/DE) that specifies the type of transaction that the component of a configured item should generate. If the conditions
for the transaction, processing options, and branch/plant are not correct for the transaction type, then the system does not generate the
transaction. You use the Transaction Type field in combination with the Write Attached Detail Line on Assembly Inclusion Rules field. Valid values
are:
0
Sales Order
1
Direct Ship
2
Transfer
3
Inter Branch/Company
|
cIssueTypeCode | ITC | char | OPT | NONE |
A code that indicates how the system issues each component in the bill of material from stock. In Shop Floor Management, it indicates how
the system issues a part to a work order. Valid values are:
I Manual issue
F Floor stock (there is no issue)
B Backflush (when the part is
reported as complete)
P Preflush (when the parts list is generated)
U Super backflush (at the pay-point operation)
S Sub-contract item (send
to supplier)
Blank Shippable end item
You can issue a component in more than one way within a specific branch/plant by using different
codes on the bill of material and the work order parts list. The bill of material code overrides the branch/plant value. |
cFactorValueType | FVTY | char | OPT | NONE |
A code that indicates whether the factor value is a multiplier (%) or an additional/deductible cash amount ($) when applied to an order's
price. |
cSalesOrderStatus03 | SO03 | char | OPT | NONE |
A user defined code (32/PF) that indicates whether the system prints the configurator part on the
sales order and work order. The system
uses the value that you enter in this field to affect programs such as Print Pick Slips (R42520), Print Invoices (R42565), Bill of Lading (R42530),
and parts list on Work Order Print (R31415). Valid values are:
0
Do not print the configurator part on the sales order or the work order.
1
Print the
configurator part on both the sales order and the work order.
2
Print the configurator part on the sales order only.
3
Print the configurator part on
the work order only.
|
cPriceRollUpFlag | PRU | char | OPT | NONE |
A user defined code (32/PP) that indicates whether the price or cost of an add-on is included in the price or cost of the parent configured
item. Valid values are:
0
Separate the price or cost of the add-on.
1
Include the price or cost of the add-on in the price or cost of the parent item.
When you choose this value, the extended price or cost is zero.
|
jdEffectiveFromDate | EFFF | JDEDATE | OPT | NONE |
A date that indicates one of the following:
o When a component part goes into effect on a bill of material
o When a routing step goes into
effect as a sequence on the routing for an item
o When a rate schedule is in effect The default is the current system date. You can enter
future effective dates so that the system plans for upcoming changes. Items that are no longer effective in the future can still be recorded and
recognized in Product Costing, Shop Floor Management, and Capacity Requirements Planning. The Material Requirements Planning system
determines valid components by effectivity dates, not by the bill of material revision level. Some forms display data based on the effectivity
dates you enter. |
jdEffectiveThruDate | EFFT | JDEDATE | OPT | NONE |
A date that indicates one of the following:
o When a component part is no longer in effect on a bill of material
o When a routing step is no
longer in effect as a sequence on the routing for an item
o When a rate schedule is no longer active The default is December 31 of the
default year defined in the Data Dictionary for Century Change Year. You can enter future effective dates so that the system plans for upcoming
changes. Items that are no longer effective in the future can still be recorded and recognized in Product Costing, Shop Floor Management,
and Capacity Requirements Planning. The Material Requirements Planning system determines valid components by effectivity dates, not by
the bill of material revision level. Some forms display data based on the effectivity dates you enter. |
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. |
jdDateUpdated | UPMJ | JDEDATE | OPT | NONE |
The date that specifies the last update to the file record. |