1.Functional Description
1.1Purpose
This business function determines whether the test condition ("If Condition") of an Assembly
Inclusion Rule is true or false and then processes the "Then Statement" portion of the edit group. The "Then
Statement" processing is based on the Rule Type:
2. Rule Type "P" or "Q" - Writes All Components List Cache
3. Rule Type "R" - Writes Routings Cache
4. Rule Type "X" - Writs Price/Cost Cache
1.2Setup Notes and Prerequisites
This function is called from N3200470, Process AIR Rules. N3200470 is called either from P3294 at
sales order entry or R31410 during work order generation.
1.3Special Logic
None
2.Technical Specifications
2.4Processing
A.After processing all retrieved records for this Configured Item, Branch/Plant, and Rule Type,
exit the business function. Pass back the number of "P" records written to the All Components cache.
Also, pass back the data structure I/O fields (i.e. current value of ATSQ, LVL, SEQ; "Next" fields;
Next Sales Order Line Number, and other I/O fields).
B.Routine to retrieve BPUUPRC - F4106 - Base Price (BP) for external fields in DERC/DERP logic:
The following parameters will need to be added to B3200460 and N3200670 data structures.
Job Number (JOBS)
Sales Order Version (VERS)
Use Cache in Edit Line (EV04)
Last Line No. Assigned (LNIX)
Work File Line Number (LNIX)
exit the business function. Pass back the number of "P" records written to the All Components cache.
Also, pass back the data structure I/O fields (i.e. current value of ATSQ, LVL, SEQ; "Next" fields;
Next Sales Order Line Number, and other I/O fields).
B.Routine to retrieve BPUUPRC - F4106 - Base Price (BP) for external fields in DERC/DERP logic:
The following parameters will need to be added to B3200460 and N3200670 data structures.
Job Number (JOBS)
Sales Order Version (VERS)
Use Cache in Edit Line (EV04)
Last Line No. Assigned (LNIX)
Work File Line Number (LNIX)
b)Job Number (JOBS) = Job Number (JOBS) passed in as input (new parameter)
c)Line Action (ACTN) = 'Add'
d)Process Edits (EV01) = '1'
e)Write to Work File (EV03) = Use Cache in Edit Line (EV01) passed in as input (new
parameter).
f)Record Written to Work File (EV04) = '1'
g)Error Conditions (ERRC) = blank
h)Currency Control (CRYR) = Currency Conversion (CRYR) passed in as input.
i)Program ID (PID) = 'B3200460'
j)Version ID (VERS) = Sales Order Version passed in as input (new parameter).
k)Order Company (KCOO) = Order Company (KCOO) passed in as input.
l)Order Number (DOCO) = Order Number passed in as input.
m)Order Type (DCTO) = Order Type passed in as input.
n)Last Line Number Assign = Last Line Number parameter passed in as input.
o)CM Line Number = 0.
p)Line Number (XLIN) =0.
q)Item Number (UITM) =
(ITM) to primary item number using X4101. See the logic in I3200790_X4101 (B3200790).
ii.If the F3293 Component Item Number (ITM) is zero, perform the same conversion using the
Parent Item (KIT) value.
Branch/Plant (CMCU).
ii.If the parent item is passed, use the F3293 Parent Branch/Plant (MCU).
t)Transaction Unit of Measure (UM) =
blank, retrieve the component UOM (IMUOM9) by reading F4101 using Get Item Master Row (XF4101)
business function. Read F4101 with the component Item Number parameter.
ii.If the parent item is passed, use the transaction unit of measure passed in as input.
F4101 using Get Item Master Row (XF4101) business function. Read F4101 with the either the
component or parent item (based on which item is being passed).
v)Related Kit Item Number (RLIT) = F3293 Parent Item Number (KIT) converted to string.
w)Related Kit Component (RKIT) = Sales Order Line Number (LNID) passed in as input.
x)Line Type (LNTY) = "S".
not need to perform Extract Data Item function.
3)Call B4200310-F4211 Edit Line with the following parameters to delete the sales order detail
line written to retrieve the price in step 1 above:
b)Job Number (JOBS) = Job Number (JOBS) passed in as input (new parameter)
c)Line Action (ACTN) = 'Delete
d)Process Edits (EV01) = '1'
e)Write to Work File (EV03) = Use Cache in Edit Line (EV01) passed in as input (new
parameter).
f)Record Written to Work File (EV04) = '1'
g)Error Conditions (ERRC) =
h)Currency Control (CRYR) = Currency Conversion (CRYR) passed in as input.
i)Program ID (PID) = 'B3200460'
j)Version ID (VERS) = Sales Order Version passed in as input (new parameter).
k)Order Company (KCOO) = Order Company (KCOO) passed in as input.
l)Order Number (DOCO) = Order Number passed in as input.
m)Order Type (DCTO) = Order Type passed in as input.
n)Last Line Number Assign = Last Line Number parameter passed in as input.
o)CM Line Number = 0.
p)Line Number (XLIN) =0.
C.Routine to retrieve Rule Table Value from F3283:
b)F3293 Parent Item (KIT)
c)F3293 Branch/Plant (MCU)
d)F3293 Rule Table Type (RTBT)
in branch/plant).
3)If no record was found, read F3282 for generic branch/plant and item (same key as above except
blanks in branch/plant and zeros in item).
4)If Cross-Reference record (F3282) was found, retrieve the Rules Table Definition (F3281) row
using these keys:
b)F3282 Branch/Plant (MCU)
c)F3282 Rule Table Type (RTBT)
b)F3283 MCU = F3282 MCU
c)F3283 RTBT = F3282 RTBT
d)All other F3283 fields = blanks
logic multiple times (F3281 NSEG value times).
ii.Branch/Plant = If F3282 item (SITn) is not 0, use F3282 MCU; otherwise, use F3293 MCU.
iii.Segment Number = Use F3282 Segment Number (PELn).
SV2, SV3, etc).
multiple times (F3281 NSEG value times).
ii. DCTO = Document type (DCTO) passed in as input parameter.
iii. KCOO = Key company (KC00) passed in as input parameter.
iv. LNID =
(manipulate LNID '85.
If F3282 Item (SITn) is zero, use Sales Order Line Number.
2.If F3282 Item (SITn) is zero, use the F3293 item number (KIT).
iii. ITM =
2.If F3282 Item (SIT) is zero, use the F3293 parent item number (KIT).
SV2, SV3, etc).
This function will be used to Evaluate and Process Assembly Inclusion Rules
D3200460 - F3293 Evaluate And Process AIR
Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
---|---|---|---|---|
mnParentItemNumber | KIT | MATH_NUMERIC | NONE | NONE |
The system provides for three separate item numbers.
1. Item Number (short) - An eight-digit, computer assigned, completely
| ||||
szBranch_Plant | 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
| ||||
cRuleType | ATOT | char | NONE | NONE |
A value that identifies whether the resulting value of the assembly inclusion rule is a part number, price, routing operation, or calculated
| ||||
cQuoteIndicator | EV01 | char | NONE | NONE |
An option that specifies the type of processing for an event. | ||||
cCostSalesQuotesIndicator | 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
| ||||
cCallType | EV01 | char | NONE | NONE |
An option that specifies the type of processing for an event. | ||||
cUpdateQ_RulesFlag | EV01 | char | NONE | NONE |
An option that specifies the type of processing for an event. | ||||
cUpdateR_RulesFlag | EV01 | char | NONE | NONE |
An option that specifies the type of processing for an event. | ||||
szOrderBranchPlant | 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
| ||||
mnOrderTransactionQty | QTY | MATH_NUMERIC | NONE | NONE |
The number of units associated with an asset. | ||||
mnOrderNumber | DOCO | MATH_NUMERIC | NONE | NONE |
A number that identifies an original document. This document can be a voucher, a sales order, an invoice, unapplied cash, a journal entry,
| ||||
szOrderType | DCTO | char | NONE | NONE |
A user defined code (00/DT) that identifies the type of document. This code also indicates the origin of the transaction. J.D. Edwards has
| ||||
szOrderCompany | KCOO | char | NONE | NONE |
A number that, along with order number and order type, uniquely identifies an order document (such as a purchase order, a contract, a
| ||||
szOrderLineType | 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
| ||||
szOrderTransactionUOM | UOM | char | NONE | NONE |
A user defined code (00/UM) that indicates the quantity in which to express an inventory item, for example, CS (case) or BX (box). | ||||
jdOrderRequestDate | DRQJ | JDEDATE | NONE | NONE |
The date that an item is scheduled to arrive or that an action is scheduled for completion. | ||||
mnExtendedCost | ECST | MATH_NUMERIC | NONE | NONE |
For accounts receivable and accounts payable, the invoice (gross) amount. For sales orders and purchase orders, the unit cost times the
| ||||
mnOrderAddressBookNo | AN8 | MATH_NUMERIC | NONE | NONE |
A number that identifies an entry in the Address Book system, such as employee, applicant, participant, customer, supplier, tenant, or
| ||||
jdOrderShipDate | PDDJ | JDEDATE | NONE | NONE |
The promised shipment date for either a sales order or purchase order. The Supply and Demand Programs use this date to calculate
| ||||
mnJobNumber | JOBS | MATH_NUMERIC | NONE | NONE |
The job number (work station ID) which executed the particular job. | ||||
mnNumberP_RulesWrtToCache | MATH01 | MATH_NUMERIC | NONE | NONE |
- - - Good Performance Low Value. | ||||
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
| ||||
szParentWO_Number | PARS | char | NONE | NONE |
A number that identifies the parent work order. You can use this number to do the following:
o Enter default values for new work orders,
| ||||
mnWorkOrderNumber | DOCO | MATH_NUMERIC | NONE | NONE |
A number that identifies an original document. This document can be a voucher, a sales order, an invoice, unapplied cash, a journal entry,
| ||||
mnUnitPriceValue | UPRC | MATH_NUMERIC | NONE | NONE |
The list or base price to be charged for one unit of this item. In sales order entry, all prices must be set up in the Item Base Price File table
| ||||
jdDatePriceEffectiveDate | PEFJ | JDEDATE | OPT | NONE |
The system uses the Price Effective Date to determine the base price and all advanced price adjustments. The value loaded in this date
| ||||
mnConfigurationIDNumber | CFGID | MATH_NUMERIC | OPT | NONE |
An identifier that represents a unique configuration. It is generated by a next number value and is the key to the configuration tables. | ||||
mnComponentIDNumber | CFGCID | MATH_NUMERIC | OPT | NONE |
A number that represents a component in a configuration. This number, which is generated by next numbers, always restarts at 1 and
| ||||
szSystemCode | SY | char | OPT | NONE |
A user defined code (98/SY) that identifies a system. Valid values include:
01
Address Book
03B
Accounts Receivable
04
Accounts
| ||||
cForeignOrDomestic | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event. | ||||
szCustomerGroup | CSTP | char | OPT | NONE |
Customer types that a customer can be grouped into for each of the different preference types. | ||||
szItemGroup | ITTP | char | OPT | NONE |
Item types that a item can be grouped into for each of the different preference types. | ||||
cParentInventoryInterface | IVI | char | OPT | NONE |
A code that identifies the type of interface to the Inventory Management system. Valid values are:
Y The dollar or unit value of any activity
| ||||
mnParentSOLineNumber | LNID | MATH_NUMERIC | OPT | NONE |
A number that identifies multiple occurrences, such as line numbers on a purchase order or other document. Generally, the system assigns
| ||||
mnOrderPromisingVersion | MATH01 | MATH_NUMERIC | OPT | NONE |
- - - Good Performance Low Value. | ||||
mnParentIDNumber | CFGPID | MATH_NUMERIC | OPT | NONE |
A number that represents the parent component of a component in a configuration. | ||||
szTransferToBranch | 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
|
B3200350 Cache Process Segement Values | ||||
B3200370 Cache Process All Components | ||||
B3200390 Cache Process Routings | ||||
B3200400 Cache Process Price Cost | ||||
B3200450 F3292 F3293 Evaluate Rule Condition | ||||
B3200480 Evaluate Boolean Expression | ||||
B3200500 F3293 Evaluate Derived Calculation | ||||
B3200950 F3283 Get Next Rules Table Detail | ||||
B4000520 Get Item UoM Conversion Factor | ||||
B4200310 Sales Order Entry Master Business Function | ||||
N3200920 F3281 Get Rule Definition Row | ||||
N3200940 F3282 Get Rules Table Cross Ref Row | ||||
N3200960 F32821 Get Rules Value Definition Row | ||||
X4101 Validate and Retrieve Item Master |
F3293 Assembly Inclusions Rules | ||||
F32942 Needed for upgrade from Xe and below | ||||
F32943 Needed for upgrade from Xe and below | ||||
F4102 Item Branch File |