Functional Description
Purpose
This Named ER will look in F4013Z file to see if components have been chosen for the Order Key. If
the records are found, they will be retrieved and passed to F4211EditLine. If records are not found for
the order key, the NER will automatically select the default components for a Kit Item, based on how
the Bill of Materials (F3002) has been setup. This is intended for use with Batch Transaction Editor
(R40211Z) and for EDI Inbound Purchasing Order Batch Program.
Setup Notes and Prerequisites
None.
Special Logic
None.
Technical Specification
Data Structure
mnParentItemNumberKIT
szCostCenterAltMMCU
szTypeBillTBM
mnComponentLineNumberCPNT
mnDocumentNumberDOCO
szOrderTypeDCTO
szDocumentCompanyKCOO
mnLineNumberLNID
jdRequestedDateDRQJ
jdTransactionDateTRDJ
jdPromiseDeliveryDatePDDJ
szLineTypeLNTY
szLastStatusCodeLTTR
szNextStatusCodeNXTR
szTransactionUoMUOM
szPricingUoMUOM4
mnQTYShippedSOQS
mnQTYBackorderedSOBK
mnQTYCanceledSOCN
szBaseCompanyCurrencyCRCD
szCustomerCurrencyCRDC
cCheckAvailabilityYNCKAV
cBackordersAllowedYNBACK
cAllowPartialShipmntsYNAPTS
szHeaderBranchPlantEMCU
mnSoldToAddressNumberAN8
WriteKitCompToF4211YNEV05
cAddorMaintainMODE
mnTransactionQtyUORG
mnDomesticExtendedPriceAEXP
mnForeignExtendedPriceFEA
mnDomesticExtendedCostECST
mnForeignExtendedCostFEC
szPODefaultReasonCodeVC03A
OrdercommitmentDateDATE01
cConversionsByBranchBUMC
cSalesPriceRetrievalUOMUMB1
cPricingEffectiveBasedOnDateCP01
cAdvancedSalesPricingYNADVP
mnLastLineNumberAssignedLNIX
cPricingMethodPMTH
mnJobnumberAJOBS
cCurrencyConverYNARCRYR
cOKorCANCELEV01
szPrimaryItemNumberUITM
szSOEVersionIDVERS
cTaxableYNTAX1
cUseCacheorWFEV02
mnFromLineNumLINN
mnThruLineNumberLIN
cPriceOverrideCodePROV
cCostOverrideCodeCSTO
Related Tables
Table Table Description
F4201ZSales Header
F4211ZSales Detail
F42UI01Sales Header Work File
F42UI11Sales Detail Work File
Related Business Functions
Source NameFunction Name
Look at flow for kits in batch below.
Processing
This NER calls multiple business functions, The order in which these functions are called follows the
Interactive Kits Program.
The program assumes that the client Bill of Materials F3002 and the Servers Bill of Materials is the
same. If the two files are not the same, the servers version will win.
If the Kit Item has Standard components, they will always be selected.
If the Kit Item has Optional but Required Components, they will always be selected.
If the Kit Item has Default Components AND user does not chose any components, all the Default
Components will be selected.
If the Kit Item has components that have been chosen by the user while running P4004Z (Batch Order
Entry) they will exist in the F4013Z file, and they will be selected as long as they are in the Server
Bill of Material.
'b7
Flow for Kits in Batch NER
Verifications from Calling Program
If no Errors, call Kits in Batch NER
Kits in Batch NER
F4101 Get Item Master Information
F41002 Get Item UoM Conversion
While End of BOM Structure == 0
While End of Vertical Structure == 0
if Text Line is not Found
end if
if Text(Y/N) != "Y"
Kit Processing, Edits for Sales Order Entry
end if
Kit Processing, Verify Next Status for Kits
if OPTK=='S' || FORV=='Y' || OPTK=='O' && FTRC=='Y'|| Record Found in F4013Z==1
if Text(Y/N) != "Y"
Availability Compare Quantities
F4105/F4106 Get Cost/Price for Kits
end if
Item Number, Convert Short To Long
Line Number, Increment for Kit Components
Kit Processing, Update Link List
end if
End While
While Horizontal Record Found == 0 && End of BOM Structure == 0
if Text Line is not Found
end if
if Text(Y/N) != "Y"
Kit Processing, Edits for Sales Order Entry
end if
Kit Processing, Verify Next Status for Kits
if OPTK=='S' || FORV=='Y' || OPTK=='O' && FTRC=='Y'|| Record
Found in F4013Z==1
if Text(Y/N) != "Y"
Availability Compare Quantities
F4105/F4106 Get Cost/Price for Kits
end if
Item Number, Convert Short To Long
Line Number, Increment for Kit Components
Kit Processing, Update Link List
end if
end while
end while //BOM Structure == 1
Delete F3002 Link List
Kit Balancing
Kit Parent Get Max To Be Sold
Kit Parent Calc Balncd Ship Qtys
Kit Component Calc Balncd Shp Qtys
while Record Found == 1 || Record Found == 0 && Edit Line Errors != 2
end while
Kit Processing, Update Link List
Action Code == 4 (Destroy the whole link list)
End of NER
Verifications of F4211 Edit Line in Calling Program
Update the Parent Item Line in the F42UI11 (or in Cache)
D4201050 - Kits in Batch Data Structure
Special Input Expected
Parameters:
Data Item Data Structure DescriptionI/ORequiredNotes
KIT Kit Master I Item number of Kit
Parent Item
MMCU Kit Master Branch I Branch Plant for Kit
Parent
TBM Type of Bill I
CPNT Component Line Number I
DOCO Document Number I
DCTO Document Type I
KCOO Document Company I
LNID Line Number I
DRQJ Requested Date I
TRDJ Transaction Date I
PDDJ Promised Date I
LNTY Line Type I
LTTR Last Status I
NXTR Next Status I
UOM Transaction UOM I
UOM4 Pricing UOM I
SOQS Quantity Shipped I
SOBK Quantity Back Ordered I
SOCN Quantity Canceled I
CRCD Base Company Currency I
CRDC Customer Currency I
CKAV Check Availability Flag I
BACK Back Orders Allowed Flag I
APTS Allowed Partial Shipments I
EMCU Header Branch Plant I
AN8 Sold To Address Number I
EV05 WriteKitCompToF4211 Flag I
MODE Mode-A for Add,
M for Maintenance I A for Add mode
only
UORG Transaction Qty I
AEXP Extended Price - DomesticI/O
FEA Extended Price - ForeignI/O
ECST Extended Cost - DomesticI/O
FEC Extended Cost - Foreign I/O
VC03A PO Default Reason Code I
DATE01Order Commitment Date I
BUMC Conversion By Branch I
UMB1 Sales Price Retrieval UOM I
CP01 Price Effective Based On Date I
ADVP Advanced Pricing Flag I Y or N
LNIX Last Line Number AssignedI/O
PMTH Pricing Method I From Item Master
JOBS Job Number I Get from Edit Line
(B4200310)
CRYR Currency Conversion I
Special Output Returned
Parameters:
Data Item Data Structure DescriptionI/ORequiredNotes
AEXP Extended Price - DomesticI/O
FEA Extended Price - ForeignI/O
ECST Extended Cost - DomesticI/O
FEC Extended Cost - Foreign I/O
LNIX Last Line Number AssignedI/O
^
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
| ||||
szCostCenterAlt | 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
| ||||
szTypeBill | TBM | char | NONE | NONE |
A user defined code (40/TB) that designates the type of bill of material. You can define different types of bills of material for different uses.
| ||||
mnComponentLineNumber | CPNT | MATH_NUMERIC | NONE | NONE |
A number that indicates the sequence of the components on a bill of material.
It initially indicates the relative sequence in which a
| ||||
mnDocumentNumber | 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
| ||||
szDocumentCompany | 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
| ||||
mnLineNumber | LNID | MATH_NUMERIC | NONE | NONE |
A number that identifies multiple occurrences, such as line numbers on a purchase order or other document. Generally, the system assigns
| ||||
jdRequestedDate | DRQJ | JDEDATE | NONE | NONE |
The date that an item is scheduled to arrive or that an action is scheduled for completion. | ||||
jdTransactionDate | TRDJ | JDEDATE | NONE | NONE |
The date that an order was entered into the system. This date determines which effective level the system uses for inventory pricing. | ||||
jdPromisedDeliveryDate | 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
| ||||
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
| ||||
szLastStatusCode | LTTR | char | NONE | NONE |
A code (system 40/type AT) specifying the last step in the processing cycle that this order line has successfully completed. | ||||
szNextStatusCode | NXTR | char | NONE | NONE |
A user defined code (system 40/type AT) indicating the next step in the order flow of the line type. | ||||
szTransactionUoM | 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). | ||||
szPricingUoM | UOM4 | char | NONE | NONE |
A user defined code (00/UM) that indicates the unit of measure in which you usually price the item. | ||||
mnQTYShipped | SOQS | MATH_NUMERIC | NONE | NONE |
The number of units committed for shipment in Sales Order Entry, using either the entered or the primary unit of measure defined for this
| ||||
mnQTYBackordered | SOBK | MATH_NUMERIC | NONE | NONE |
The number of units backordered in Sales Order Management or in Work Order Processing, using either the entered or the primary unit of
| ||||
mnQTYCanceled | SOCN | MATH_NUMERIC | NONE | NONE |
The number of units canceled in Sales Order or Work Order Processing, using either the entered or the primary unit of measure defined for
| ||||
szBaseCompanyCurrency | CRCD | char | NONE | NONE |
A code that identifies the currency of a transaction. | ||||
szCustomerCurrency | CRDC | char | NONE | NONE |
A code that identifies the domestic (base) currency of the company on a transaction. | ||||
cCheckAvailabilityYN | CKAV | char | NONE | NONE |
A code that specifies whether the system performs availability checking. You might want to turn on availability checking for certain items.
| ||||
cBackordersAllowedYN | BACK | char | NONE | NONE |
An option that specifies whether to allow backorders for this item. You can allow backorders by item using the Item Master (P4101) or Item
| ||||
cAllowPartialShipmntsYN | APTS | char | NONE | NONE |
An option that indicates whether the customer accepts partial line shipments. Valid values are:
On
The customer accepts partial line
| ||||
szHeaderBranchPlant | EMCU | char | NONE | NONE |
A business unit is an accounting entity required for management reporting. It can be a profit center, department, warehouse location, job,
| ||||
mnSoldToAddressNumber | 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
| ||||
WriteKitCompToF4211YN | EV05 | char | NONE | NONE |
A flag that indicates whether automatic spell check is turned on. | ||||
cAddorMaintain | MODE | char | NONE | NONE |
The processing mode used in Purchase Order Consolidator to signify when specific orders are being processed. | ||||
mnTransactionQty | UORG | MATH_NUMERIC | NONE | NONE |
The quantity of units affected by this transaction. | ||||
mnDomesticExtendedPrice | AEXP | MATH_NUMERIC | NONE | NONE |
The number of units multiplied by the unit price. | ||||
mnForeignExtendedPrice | FEA | MATH_NUMERIC | NONE | NONE |
The product of the foreign price times the number of units. | ||||
mnDomesticExtendedCost | 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
| ||||
mnForeignExtendedCost | FEC | MATH_NUMERIC | NONE | NONE |
The product of the cost of an item, expressed in foreign currency according to the orders exchange rate, times the number of units. | ||||
szPODefaultReasonCode | VC03A | char | NONE | NONE |
This is a generic field used as a work field in Everest. | ||||
OrdercommitmentDate | DATE01 | JDEDATE | NONE | NONE |
Event point for JDE Date. | ||||
cConversionsByBranch | BUMC | char | NONE | NONE |
A code that indicates how the system uses the branch/plant within the Item Specific Unit of Measure Conversion tables. Valid values are:
Y
| ||||
cSalesPriceRetrievalUOM | UMB1 | char | NONE | NONE |
A code that specifies the unit of measure that the system uses for retrieving base prices and price adjustments for sales order processing,
| ||||
cPricingEffectiveBasedOnDate | CP01 | char | NONE | NONE |
A code that determines how the system updates the Price Effective Date in the Sales Order Header (F4201) and Detail (F4211) tables. In
| ||||
cAdvancedSalesPricingYN | ADVP | char | NONE | NONE |
Indicates how the system determines the price of items within your system. If your system includes the advanced pricing module, you may
| ||||
mnLastLineNumberAssigned | LNIX | MATH_NUMERIC | NONE | NONE |
cPricingMethod | PMTH | char | NONE | NONE |
A code that determines how the system calculates the price for kit items or configured items. Valid values are:
Blank
Use for items that are
| ||||
mnJobnumberA | JOBS | MATH_NUMERIC | NONE | NONE |
The job number (work station ID) which executed the particular job. | ||||
cCurrencyConverYNAR | CRYR | char | NONE | NONE |
A code that specifies whether to use multi-currency accounting, and the method of multi-currency accounting to use:
Codes are:
N Do not
| ||||
cOKorCANCEL | EV01 | char | NONE | NONE |
An option that specifies the type of processing for an event. | ||||
szPrimaryItemNumber | UITM | char | NONE | NONE |
A number that the system assigns to an item. It can be in short, long, or third item number format. | ||||
szSOEVersionID | VERS | char | NONE | NONE |
A user-defined set of specifications that control how applications and reports run. You use versions to group and save a set of user-defined
| ||||
cTaxableYN | TAX1 | char | NONE | NONE |
A code that indicates whether the item is subject to sales tax when you sell it. The system calculates tax on the item only if the customer is
| ||||
cUseCacheorWF | EV02 | char | NONE | NONE |
An option that specifies the type of processing for an event. | ||||
mnFromLineNum | LINN | MATH_NUMERIC | NONE | NONE |
A number that identifies multiple occurrences (such as line numbers on a purchase order or other document). Generally, the system
| ||||
mnThruLineNumber | LIN | MATH_NUMERIC | NONE | NONE |
To move rapidly through a long list of journal entries, enter a line number. The system shifts the information on that line to the top of the
| ||||
cPriceOverrideCode | PROV | char | NONE | NONE |
A value established by the sales order entry program whenever a unit or extended price is entered into an order line item, overriding the
| ||||
cCostOverrideCode | CSTO | char | NONE | NONE |
A code that specifies whether the change order is a terms only change. For those organizations that elect to view subcontracts on a
| ||||
cCalledFromR47011YN | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event. | ||||
mnSalesOrderNumber | DOCO | MATH_NUMERIC | OPT | NONE |
A number that identifies an original document. This document can be a voucher, a sales order, an invoice, unapplied cash, a journal entry,
| ||||
szSalesOrderType | DCTO | char | OPT | 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
| ||||
mnProcessID | PEID | MATH_NUMERIC | OPT | NONE |
A code that identifies the Inter-Process Communication ID. | ||||
mnTransactionID | TCID | MATH_NUMERIC | OPT | NONE |
None |
None |