1.Functional Description
1.1Purpose
This function will perform Load, Delete, Update, Get, and Clear functions on the BOMExplosion cache used in BOM Explosion routine. On a Create
process, an identifier for the cache (hCache handle) is passed back to the calling program for subsequent calls to this function.
1.2Setup Notes and Prerequisites
The calling application is responsible for loading all appropriate key values to the data structure and identifying the number of keys to use in
retrieval/update processes. The application must also store the hCache pointers passed back from the "Create" process and pass these pointers back to the
business function on the other process modes which require them (see technical specifications below).
1.3Special Logic
There is no special logic within this function.
2.4Processing
Cache Layout:.
AliasData ItemNotes
Index
INT01LevelIndex
EV01Continue ExplodingIndex
OPSQOperationSeqForSortingIndex
MMCUParent BranchIndex
KITParent ItemIndex
TBMType Of BillIndex
BQTYBatch QuantityIndex
CPNTLine NoIndex
CMCUComponent BranchIndex
ITMComponent ItemIndex
COBYCoByProductIndex
FORQFixed Or VariableIndex
INT01Actual LevelIndex
CPNTActual Line NoIndex
Parent Information
UOMBatchQtyUOM
STKTParent Stocking Type
UOMRequested Qty UOM
RQTE1Requested Qty
RQTE1Requested Qty with Shrink
Component Information
STKTComponent Stocking Type
QNTYActualRequiredQty
UMComponentUOM
QNTYActualExtendedQty
EFFFEffective From Date
EFFTEffective Thru Date
OPSQOperation Sequence
LITMSecond Item Number
AITMThird Item Number
EV01Text Lines Exist
FRMPFrom Potency
THRPThru Potency
FRGDFrom Grade
THGDThru Grade
LNTYLine Type
ITCIssue Type CodeAdded B7321
CPYPCumulative Yield PercentAdded B7321
STPPOperation Scrap PercentAdded B7321
SCRPScrap PercentAdded B7321
RSCPResource PercentAdded B7321
LOVDLeadtime Offset DaysAdded B7321
OPTKOptional ItemAdded B7321
CMRVComponent Revision Added B7321
PRICUnit PriceAdded B7321
UNCSUnit CostAdded B7321
FTRCRequiredAdded B7321
FORVDefault ComponentAdded B7321
DSC1RemarkAdded B7321
FTRPFeature Planned PercentAdded B7321
F_1RPFeature Cost PercentAdded B7321
BSEQBubble SequenceAdded B7321
Calculated quantities
UOM1ComponentPrimaryUOM
UOM2ComponentSecondaryUOM
MN29D9CFPrimaryToComponent
MN29D9CFComponentToPrimary
QNTYCalcRequiredQtyPrimary
QNTYCalcExtendedQtyPrimary
Shrink
SNSRoundToWholeNumber
SRNKShrink Factor
SRKFShrink Factor Method
Availability
SAFESafetyStock
FRMPFrom Potency
THRPThru Potency
FRGDFrom Grade
THGDThru Grade
Leadtime
LTLVActual Leadtime Level
LTMFActual Mfg Leadtime
LTCMActual Cumulative Leadtime
LTLVCalculated Leadtime Level
LTMFCalculated Mfg Leadtime
LTCMCalculated Cumulative Leadtime
I. Perform setup functions
B.Initialize return code to success.
C.If not successful, Set error "032E," "Error Processing Cache" and set return code to failure.
II. Processing Based on Mode.
E.If Process Mode is "5" - DELETE ALL:
G.If Process Mode is "7" - ADD/UPDATE:
D3003100 - Cache Process BOM Explosion
2.1Parameters:
Data Item Data StructureI/ORequiredNotes
Description
INT01LevelI/OYKey value
EV01ContinueExplodingI/ONKey Value used when phantoms
MMCUParent BranchI/ONKey Value
KITParent ItemI/ONKey value
TBMType of BillI/ONKey value
BQTYBatch Qty PrimaryI/ONKey value
CPNTLine NoI/ONKey value
COBYCoByProductI/ONKey value
INT01Actual LevelI/ONKey Value used when phantoms
subassemblies or phantoms been displayed.
component of the subassembly or phantom.
ITMComponent ItemI/ONKey Value
FORQFixed Or Variable I/ONKey Value
STKTParent Stocking TypeI/ON
UOMBatch Qty UOMI/ON
RQTE1Requested QtyI/ON
RQTE1Requesed Qty with ShrinkI/ON
UOMRequested Qty UOMI/ON
STKTStocking TypeI/ON
QNTYActual Required QtyI/ON
UMComponent UOM I/ON
QNTYActual Extended QtyI/ON
EFFFEffective From DateI/ON
EFFTEffective Thru DateI/ON
OPSQOperation SequenceI/ON
LITMSecondItemNumberI/ON
AITMThirdItemNumber I/ON
UOM1Component PrimaryI/ON
UOM
UOM2ComponentSecondaryI/ON
UOM
MN29D9CFPrimaryToComponentI/ON
MN29D9CFComponentToPrimaryI/ON
QNTYCalc Required QtyI/ON
Primary
QNTYCalc Extended QtyI/ON
Primary
EV01Text Lines ExistI/ON
SNSRound To Whole NumberI/ON
SRNKShrink FactorI/ON
SRKFShrink Factor MethodI/ON
SAFESafety StockI/ON
FRMPFrom PotencyI/ON
THRPThru PotencyI/ON
FRGDFrom GradeI/ON
THGDThru GradeI/ON
LTLVActual Leadtime LevelI/ON
LTMFActual Mfg LeadtimeI/ON
LTCMActual Cum LeadtimeI/ON
LTLVCalc Leadtime LevelI/ON
LTMFCalc Mfg LeadtimeI/ON
LTCMCalc Cum LeadtimeI/ON
LNTYLine TypeI/OY
DSC1Component DescriptionI/OY
EV01 Substitute Exists I/O N
ITCIssue Type CodeI/ON
CPYPCumulative Yield PercentI/ON
STPPOperation Scrap PercentI/ON
SCRPScrap PercentI/ON
RSCPResource PercentI/ON
LOVDLeadtime Offset DaysI/ON
OPTKOptional ItemI/ON
CMRVComponent Revision I/ON
PRICUnit PriceI/ON
UNCSUnit CostI/ON
FTRCRequiredI/ON
FORVDefault ComponentI/ON
DSC1RemarkI/ON
FTRPFeature Planned PercentI/ON
F_1RPFeature Cost PercentI/ON
BSEQBubble SequenceI/ON
BREVBill Revision LevelI/ON
KITLParent 2nd Item NumberI/ON
INT01Number of KeysIYNumber of Keys to be used in the
"3' = Update element
"4" = Delete cache elements
"5" = Delete All cache elements
"6" = Get Next cache element
"7' = Add/Update cache element
"8" = End cache (terminate cache)
"2" = Invalid Input Parameter
"3" = Failed to Create CACHE
"4" = Failed to Add CACHE
"5" = Failed to Delete CACHE
"6" = Cache is loaded
"7" = Empty CACHE
DTAIError Message IDON
JOBSJob NumberIYUnique job number for that
DRAWDrawing NumberI/ON
RVNOLast Revision NumberI/ON
MERLPart Revision LevelI/ON
^
Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
---|---|---|---|---|
nLevel | INT01 | integer | OPT | NONE |
Number of Days in Future to Query for Responses Due. | ||||
cContinueExploding | EV01 | char | NONE | NONE |
An option that specifies the type of processing for an event. | ||||
mnOperationSeqForSorting | OPSQ | MATH_NUMERIC | NONE | NONE |
A number used to indicate an order of succession.
In routing instructions, a number that sequences the fabrication or assembly steps in the
| ||||
szParentBranch | 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
| ||||
mnParentItem | KIT | MATH_NUMERIC | NONE | NONE |
The system provides for three separate item numbers.
1. Item Number (short) - An eight-digit, computer assigned, completely
| ||||
szTypeOfBill | 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.
| ||||
mnBatchQuantityPrimary | BQTY | MATH_NUMERIC | NONE | NONE |
The quantity of finished units that you expect this bill of material or routing to produce. You can specify varying quantities of components
| ||||
cCoByProduct | COBY | char | NONE | NONE |
A code that distinguishes standard components or ingredients from co-products,by-products, and intermediates. Co-products are
| ||||
nActualLevel | INT01 | integer | NONE | NONE |
Number of Days in Future to Query for Responses Due. | ||||
szComponentBranch | CMCU | char | NONE | 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
| ||||
mnComponentItem | ITM | MATH_NUMERIC | NONE | NONE |
An inventory item number. The system provides three separate item numbers plus an extensive cross-reference capability to other item
| ||||
cFixedOrVariable | FORQ | char | NONE | NONE |
A code that indicates if the quantity per assembly for an item on the bill of material varies according to the quantity of the parent item
| ||||
cParentStockingType | STKT | char | NONE | NONE |
A user defined code (41/I) that indicates how you stock an item, for example, as finished goods or as raw materials. The following stocking
| ||||
szBatchQtyUOM | 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). | ||||
mnRequestedQty | RQTE1 | MATH_NUMERIC | NONE | NONE |
The number of parent items that you want to process. The system calculates lower level values in quantity per the number of parent items
| ||||
mnRequestedQtyWithShrink | RQTE1 | MATH_NUMERIC | NONE | NONE |
The number of parent items that you want to process. The system calculates lower level values in quantity per the number of parent items
| ||||
szRequestedQtyUOM | 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). | ||||
cStockingType | STKT | char | NONE | NONE |
A user defined code (41/I) that indicates how you stock an item, for example, as finished goods or as raw materials. The following stocking
| ||||
mnActualRequiredQty | QNTY | MATH_NUMERIC | NONE | NONE |
The number of units that the system applies to the transaction. | ||||
szComponentUOM | UM | char | NONE | 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,
| ||||
mnActualExtendedQty | QNTY | MATH_NUMERIC | NONE | NONE |
The number of units that the system applies to the transaction. | ||||
jdEffectiveFromDate | EFFF | JDEDATE | NONE | 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
| ||||
jdEffectiveThruDate | EFFT | JDEDATE | NONE | 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
| ||||
mnOperationSequence | OPSQ | MATH_NUMERIC | NONE | NONE |
A number used to indicate an order of succession.
In routing instructions, a number that sequences the fabrication or assembly steps in the
| ||||
szSecondItemNumber | LITM | char | NONE | NONE |
A number that identifies the item. The system provides three separate item numbers plus an extensive cross-reference capability to
| ||||
szThirdItemNumber | AITM | char | NONE | NONE |
The system provides three separate item numbers plus an extensive cross-reference capability to alternate item numbers. These item
| ||||
szComponentPrimaryUOM | UOM1 | char | NONE | NONE |
A user defined code (00/UM) that identifies the unit of measure that the system uses to express the quantity of an item, for example, EA
| ||||
szComponentSecondaryUOM | UOM2 | char | NONE | NONE |
A user defined code (00/UM) that indicates an alternate unit of measure for the item. | ||||
mnCFPrimaryToComponent | MN29D9 | MATH_NUMERIC | NONE | NONE |
This is a generic field used as a work field in Everest. | ||||
mnCFComponentToPrimary | MN29D9 | MATH_NUMERIC | NONE | NONE |
This is a generic field used as a work field in Everest. | ||||
mnCalcExtendedQtyPrimary | QNTY | MATH_NUMERIC | NONE | NONE |
The number of units that the system applies to the transaction. | ||||
mnCalcRequiredQtyPrimary | QNTY | MATH_NUMERIC | NONE | NONE |
The number of units that the system applies to the transaction. | ||||
cTextLinesExist | EV01 | char | NONE | NONE |
An option that specifies the type of processing for an event. | ||||
cRoundToWholeNumber | SNS | char | NONE | NONE |
A code that determines whether the system performs rounding for planning purposes. Valid values are:
R Round either up or down to the
| ||||
mnShrinkFactor | SRNK | MATH_NUMERIC | NONE | NONE |
A fixed quantity or percentage that the system uses to determine inventory shrinkage for an item. The system increases the planned order
| ||||
cShrinkFactorMethod | SRKF | char | NONE | NONE |
A value that determines whether the shrink factor you enter for this item is a percentage or a fixed quantity. Valid values are:
%
| ||||
mnSafetyStock | SAFE | MATH_NUMERIC | NONE | NONE |
The quantity of stock kept on hand to cover high-side variations in demand. | ||||
mnFromPotency | FRMP | MATH_NUMERIC | NONE | NONE |
A number that indicates the minimum potency or percentage of active ingredients acceptable for an item.
The system displays a warning
| ||||
mnThruPotency | THRP | MATH_NUMERIC | NONE | NONE |
A number that indicates the maximum potency or percentage of active ingredients that is acceptable for an item.
The system displays a
| ||||
szFromGrade | FRGD | char | NONE | NONE |
A user defined code (40/LG) that indicates the minimum grade that is acceptable for an item.
The system displays a warning message if
| ||||
szThruGrade | THGD | char | NONE | NONE |
A user defined code (40/LG) that indicates the maximum grade that is acceptable for an item.
The system displays a warning message if
| ||||
mnActualLeadtimeLevel | LTLV | MATH_NUMERIC | NONE | NONE |
A value that represents the leadtime for an item at its assigned level in the production process, as defined on Plant Manufacturing Data.
| ||||
mnActualMfgLeadtime | LTMF | MATH_NUMERIC | NONE | NONE |
The total number of days required to build an item from its lowest level components to the final assembly. This value is the total of the level
| ||||
mnActualCumulativeLeadtime | LTCM | MATH_NUMERIC | NONE | NONE |
The total number of days required to build an item from its lowest level components to the final assembly. The system calculates the value
| ||||
mnCalcLeadtimeLevel | LTLV | MATH_NUMERIC | NONE | NONE |
A value that represents the leadtime for an item at its assigned level in the production process, as defined on Plant Manufacturing Data.
| ||||
mnCalcMfgLeadtime | LTMF | MATH_NUMERIC | NONE | NONE |
The total number of days required to build an item from its lowest level components to the final assembly. This value is the total of the level
| ||||
mnCalcCumulativeLeadtime | LTCM | MATH_NUMERIC | NONE | NONE |
The total number of days required to build an item from its lowest level components to the final assembly. The system calculates the value
| ||||
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
| ||||
szComponentDescription | DSC1 | char | OPT | NONE |
Brief information about an item; a remark or an explanation. | ||||
cSubstituteExists | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event. | ||||
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
| ||||
mnCumulativeYieldPercent | CPYP | MATH_NUMERIC | OPT | NONE |
The cumulative planned output yield percent for a step. The system uses this value to adjust the operation step scrap percent for the
| ||||
mnOperationScrapPercent | STPP | MATH_NUMERIC | OPT | NONE |
A value that the system uses to increase or decrease the amount of materials to account for loss within the operation. The system updates
| ||||
mnScrapPercent | 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
| ||||
mnResourcePercent | RSCP | MATH_NUMERIC | OPT | NONE |
A number that indicates what percent of the ingredients should be issued separately to co-products and by-products. | ||||
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
| ||||
cOptionalItemKit | OPTK | char | OPT | NONE |
A code that indicates whether a component is standard or optional within a bill of material or for kit processing. Valid codes are:
S
| ||||
szComponentRevision | CMRV | char | OPT | NONE |
A code that indicates the current revision level of a component on the bill of material. It is usually used with an engineering change notice
| ||||
mnUnitPrice | PRIC | MATH_NUMERIC | OPT | NONE |
A base or default price that is used with multipliers from the pricing rules to develop discounted prices. If no formula applies to an item or no
| ||||
mnUnitCost | UNCS | MATH_NUMERIC | OPT | NONE |
The amount per unit, derived by dividing the total cost by the unit quantity. | ||||
cRequired | FTRC | char | OPT | NONE |
A code that specifies whether a component is required. Valid codes are:
Y The component is required.
N The component is not a
| ||||
cDefaultComponent | FORV | char | OPT | NONE |
An option that specifies a default component. Use this field if you are creating Sales Orders using the Recurring Orders Edited Creation
| ||||
szRemark | DSC1 | char | OPT | NONE |
Brief information about an item; a remark or an explanation. | ||||
mnFeaturePlannedPercent | FTRP | MATH_NUMERIC | OPT | NONE |
The percentage of demand for a specified feature based on projected production. For example, a company might produce 65% of their
| ||||
mnFeatureCostPercent | F$RP | MATH_NUMERIC | OPT | NONE |
A percentage that the Simulate Cost Rollup program uses to calculate the cost of a feature or option item as a percentage of the total cost
| ||||
mnBubbleSequence | BSEQ | MATH_NUMERIC | OPT | NONE |
A secondary bill of material sequence number that indicates the drawing bubble number. | ||||
szBillRevisionLevel | BREV | char | OPT | NONE |
A value that indicates the revision level of a bill of material. It is usually used in conjunction with an engineering change notice or
| ||||
szParent2ndItemNumber | KITL | char | OPT | NONE |
The system provides for three separate item numbers.
1. Item Number (short) - An eight-digit, computer assigned, completely
| ||||
nNumberOfKeys | INT01 | integer | OPT | NONE |
Number of Days in Future to Query for Responses Due. | ||||
cProcessMode | 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. | ||||
cSuppressErrorMessages | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event. | ||||
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
| ||||
mnJobnumber | JOBS | MATH_NUMERIC | OPT | NONE |
The job number (work station ID) which executed the particular job. | ||||
cReturnCursorFlag | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event. | ||||
idCursor | GENLNG | ID | OPT | NONE |
General purpose ID variable. | ||||
szDrawingNumber | DRAW | char | OPT | NONE |
An engineering drawing number. It might be the same as the part or item number. | ||||
szLastRevisionNo | RVNO | char | OPT | NONE |
A subset to the drawing number. It provides an additional description of the drawing and is useful if the system uses an engineering drawing
| ||||
szPartRevisionLevel | MERL | char | OPT | NONE |
The revision level for an item. If you enter a revision level in this field, verify that the revision level of the routing for an item matches the
| ||||
mnActualParentItem | KIT | MATH_NUMERIC | OPT | NONE |
The system provides for three separate item numbers.
1. Item Number (short) - An eight-digit, computer assigned, completely
| ||||
szActualParentBranch | MMCU | char | OPT | 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
| ||||
mnActualBatchQuantity | BQTY | MATH_NUMERIC | OPT | NONE |
The quantity of finished units that you expect this bill of material or routing to produce. You can specify varying quantities of components
| ||||
szItemFlashMessage | IFLA | char | OPT | NONE |
User defined code system 40, type FL, which is used to flash a warning message about a particular item. | ||||
cPotencyControl | OT1Y | char | OPT | NONE |
A code that indicates whether you control the item by potency. | ||||
mnStandardPotency | STDP | MATH_NUMERIC | OPT | NONE |
The percentage of active ingredients normally found in an item. | ||||
cPartialsAllowedYN | PRTA | char | OPT | NONE |
When you specify component and substitute items on the bill of material, this field indicates whether the total quantity is required to be
| ||||
cActiveIngredientFlag | AING | char | OPT | NONE |
A code that indicates whether an item is an active component of a parent item. When the item is an active component, the system can
| ||||
mnActualLineNo | CPNB | MATH_NUMERIC | OPT | NONE |
A number that specifies how the system displays the sequence of components on a single-level bill of material. This number initially
| ||||
mnLineNo | CPNB | MATH_NUMERIC | OPT | NONE |
A number that specifies how the system displays the sequence of components on a single-level bill of material. This number initially
| ||||
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. | ||||
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. | ||||
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. | ||||
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. | ||||
cBOMCHAR | BCHAR | char | OPT | NONE |
A field that indicates whether the item is included in the Lean Superflush. A | ||||
szBOMSTRING | BOSTR | char | OPT | NONE |
A Prep Code used by DFM Kanban Management. |
None |
None |