D3003090B - F3002 Get BOM Records
2.1Parameters:
Data Item Data StructureI/ORequiredNotes
Description
INT01LevelI/OYLevel as an integer
EV01Record FoundI/OY1 = Record Found
EV01Subtract Safety StockIN1 = Sub Safety Stock from
0 = Do not adjust for Safety Stock.
DEFAULT: 0
KITParent ItemON
TBMType of BillON
BQTYBatch QtyON
CPNTLine NumberON
COBYCoByProductON
UOMBatch Qty UOMONUOM associated with Batch Qty.
STKTParent Stocking TypeON
CMCUComponent BranchON
RQTE1Requested QtyON
RQTE1Requested QtyON
with Shrink
UOMRequested Qty UOMONUOM associated with Requested
UMRequired Qty UOMONUOM associated with the Actual
Qty, Calc Required Qty, Calc
Extended Qty, Available Qty, and
On Hand Qty.
QNTYActualExtendedQtyONRequired quantity form F3002
and extended per requested Qty
EFFTEffective Thru DateON
OPSQOperation SequenceON
STKTStocking TypeON
FORQFixed or Variable ON
LITMSecond Item NumberON
AITMThird Item NumberON
EV01Text Lines ExistON'1' = associated text lines stored in
'0' = no associated text lines or text
lines not retrieved.
LTMFActual Mfg LeadtimeON
LTCMActual CumulativeON
Level
LTMFCalculated MfgON
Leadtime
LTCMCalculated CumulativeON
Leadtime
EV01Single Level Delete
LNTYLine TypeON
DSC1Component DescriptionON
EV01Substitute ExistsON
JOBSJob NumberIY
BREVBill Revision LevelON
KITLParent 2nd Item NumberON
ITCIssue Type CodeON
CPYPCumulative Yield PercentON
STPPOperation Scrap PercentON
SCRPScrap PercentON
RSCPResource PercentON
LOVDLeadtime Offset DaysON
OPTKOptional ItemON
CMRVComponent RevisionON
PRICUnit PriceON
UNCSUnit CostON
FTRCRequiredON
FORVDefault ComponentON
DSC1RemarkON
FTRPFeature Planned PercentON
F_1RPFeature Cost PercentON
BSEQBubble SequenceON
DRAWDrawing NumberON
RVNOLast Revision NumberON
MERLPart Revision LevelON
FRGDFrom GradeON
THGDThru GradeON
FRMPFrom PotencyON
THRPThru PotencyON
^
Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
---|---|---|---|---|
nLevel | INT01 | integer | NONE | NONE |
Number of Days in Future to Query for Responses Due. | ||||
cRecordFound | EV01 | char | NONE | NONE |
An option that specifies the type of processing for an event. | ||||
cCalculateAvailability | EV01 | char | NONE | NONE |
An option that specifies the type of processing for an event. | ||||
cSubtractSafetyStock | EV01 | char | NONE | NONE |
An option that specifies the type of processing for an event. | ||||
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.
| ||||
mnBatchQty | 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
| ||||
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). | ||||
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
| ||||
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
| ||||
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). | ||||
mnComponent | 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
| ||||
szRequiredQtyUOM | 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,
| ||||
mnActualRequiredQty | QNTY | MATH_NUMERIC | NONE | NONE |
The number of units that the system applies to the transaction. | ||||
mnActualExtendedQty | QNTY | MATH_NUMERIC | NONE | NONE |
The number of units that the system applies to the transaction. | ||||
mnCalcRequiredQty | QNTY | MATH_NUMERIC | NONE | NONE |
The number of units that the system applies to the transaction. | ||||
mnCalcExtendedQty | QNTY | MATH_NUMERIC | NONE | NONE |
The number of units that the system applies to the transaction. | ||||
mnAvailableQty | QNTY | MATH_NUMERIC | NONE | NONE |
The number of units that the system applies to the transaction. | ||||
mnOnHandQty | 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
| ||||
mnOperaitonSequence | 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
| ||||
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
| ||||
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
| ||||
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
| ||||
cTextLinesExist | EV01 | char | NONE | NONE |
An option that specifies the type of processing for an event. | ||||
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
| ||||
mnActualCumLeadtime | 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
| ||||
mnCalcCumLeadtime | 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
| ||||
cSingleLevelDelete | EV01 | char | NONE | NONE |
An option that specifies the type of processing for an event. | ||||
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
| ||||
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. | ||||
mnJobnumberA | JOBS | MATH_NUMERIC | OPT | NONE |
The job number (work station ID) which executed the particular job. | ||||
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
| ||||
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
| ||||
szComponentRevisionLevel | 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
| ||||
mnUnitPricePerPrimary | 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. | ||||
cRequiredYN | 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. | ||||
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
| ||||
szFromGrade | FRGD | char | OPT | 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 | OPT | 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
| ||||
mnFromPotency | FRMP | MATH_NUMERIC | OPT | 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 | OPT | NONE |
A number that indicates the maximum potency or percentage of active ingredients that is acceptable for an item.
The system displays a
| ||||
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. | ||||
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
| ||||
mnLineNumber | 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
|
B9800420 Get Data Dictionary Definition |
None |