DF311108A - Parts Structure File Server
| Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
|---|---|---|---|---|
| nIndexNumber | INT01 | integer | OPT | NONE |
Number of Days in Future to Query for Responses Due. | ||||
| nNumberofKeys | INT02 | integer | OPT | NONE |
Number of Days in the Past to Query for Quote Requests Received. | ||||
| 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
| ||||
| 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
| ||||
| cActionCode | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event. | ||||
| cReturnCursor | EV02 | char | OPT | NONE |
An option that specifies the type of processing for an event. | ||||
| idHrequestID | GENLNG | ID | OPT | NONE |
General purpose ID variable. | ||||
| 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
| ||||
| szVersionId | VID | char | OPT | NONE |
The version id is the version identification when a record was added or updated in a table. | ||||
| mnUniqueKeyIDInternal | UKID | MATH_NUMERIC | OPT | NONE |
This field is a unique number used to identify a record in a file. | ||||
| mnItemNumberShortKit | KIT | MATH_NUMERIC | OPT | NONE |
The system provides for three separate item numbers.
1. Item Number (short) - An eight-digit, computer assigned, completely
| ||||
| szTypeBill | TBM | char | OPT | 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.
| ||||
| szParentBranch | 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
| ||||
| 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
| ||||
| 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
| ||||
| mnComponentNumber | CPNT | MATH_NUMERIC | OPT | NONE |
A number that indicates the sequence of the components on a bill of material.
It initially indicates the relative sequence in which a
| ||||
| mnBOMRevisionNumber | BRVN | MATH_NUMERIC | OPT | NONE |
A Unique number to determine the Revision Number for BOM | ||||
| 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
| ||||
| mnLevelofBOM | LBOM | MATH_NUMERIC | OPT | NONE |
A component level within the BOM. | ||||
| cStockingType | STKT | char | OPT | 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
| ||||
| mnLeanBatchQuantity | LBQTY | 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
| ||||
| szUnitOfMeasureAsInput | UOM | char | OPT | 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). | ||||
| mnLeanQuantityPer | LQNTY | MATH_NUMERIC | OPT | NONE |
The number of Units required PER finished unit. | ||||
| mnQtyRequiredStandard | QNTY | MATH_NUMERIC | OPT | NONE |
The number of units that the system applies to the transaction. | ||||
| 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,
| ||||
| szTypeOperationCode | OPSC | char | OPT | NONE |
A user defined code (30/OT) that indicates the type of operation. Valid values include: A Alternate routing TT Travel time IT Idle time T Text | ||||
| mnSubstituteItemSequenceNu | SBNT | MATH_NUMERIC | OPT | NONE |
A number that indicates the sequence for the substitute items for a component.
The system looks for substitute items by this sequence
| ||||
| 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
| ||||
| cFixedorVariableBatchSize | FVBT | char | OPT | NONE |
| szEffectiveFromSerialNo | FSER | char | OPT | NONE |
This field is used to identify the serial number of a particular parent part and specify when the component will become an active part of the
| ||||
| szEffectiveThruSerialNo | TSER | char | OPT | NONE |
This field is used to identify the serial number of a particular parent part and specify when the component will no longer be an active part of
| ||||
| 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
| ||||
| 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
| ||||
| 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
| ||||
| 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
| ||||
| cComponentCostingMethod | CSTM | char | OPT | NONE |
Indicates the method to be used to compute the cost of the component.
Valid values are:
# indicates that this cost will be entered by you
| ||||
| cCostMethodPurchasing | CSMP | char | OPT | NONE |
Indicates which of the numerous unit costs available is to be used in costing outgoing Purchase Orders. Up to seven costs can be chosen
| ||||
| cOrderWithYN | ORDW | char | OPT | NONE |
Future use. The Order With code determines if work order generation (P31410) will explode this items bill of material to create orders for this
| ||||
| cFixedOrVariableQty | FORQ | char | OPT | 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
| ||||
| cCoproductsByproducts | COBY | char | OPT | NONE |
A code that distinguishes standard components or ingredients from co-products,by-products, and intermediates. Co-products are
| ||||
| cComponentType | COTY | char | OPT | NONE |
The component type determines what the component is used for in a bill of material. For example:
A Active ingredient
C Standard
| ||||
| 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
| ||||
| 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
| ||||
| 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. | ||||
| 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
| ||||
| mnStepScrapPercent | 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
| ||||
| 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
| ||||
| mnReworkPercent | REWP | MATH_NUMERIC | OPT | NONE |
| mnAsIsPercent | ASIP | MATH_NUMERIC | OPT | NONE |
| mnPercentCumulativePla | 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
| ||||
| 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
| ||||
| szEngineerChngOrderNo | ECO | char | OPT | NONE |
The number assigned to an engineering change order. | ||||
| jdDateEngineerChgeDate | ECOD | JDEDATE | OPT | NONE |
The date of the engineering change order. | ||||
| szDescriptionLine1 | DSC1 | char | OPT | NONE |
Brief information about an item; a remark or an explanation. | ||||
| szIssueFromLocation | IFLOCN | char | OPT | NONE |
A location from which material is issued. | ||||
| szLocation | LOCN | char | OPT | NONE |
The storage location from which goods will be moved. | ||||
| szLot | LOTN | char | OPT | NONE |
A number that identifies a lot or a serial number. A lot is a group of items with similar characteristics. | ||||
| 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
| ||||
| mnBubbleSequence | BSEQ | MATH_NUMERIC | OPT | NONE |
A secondary bill of material sequence number that indicates the drawing bubble number. | ||||
| cSubAssemblyFlag | SUBAF | char | OPT | NONE |
A flag to indicate that the Component in the BOM is a Sub Assembly. | ||||
| szExplodedBOMTableKeyID | EBTKID | char | OPT | NONE |
| mnShrinkFactor | SRNK | MATH_NUMERIC | OPT | 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 | OPT | NONE |
A value that determines whether the shrink factor you enter for this item is a percentage or a fixed quantity. Valid values are:
%
| ||||
| szDrawingNumber | DRAW | char | OPT | NONE |
An engineering drawing number. It might be the same as the part or item number. | ||||
| 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
| ||||
| 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
| ||||
| szMessageNo | SHNO | char | OPT | NONE |
A generic rates and message code (48/SN) that is assigned to a standard note, message, or general narrative explanation. You can use
| ||||
| mnPerAssemblySalePrice | PCTK | MATH_NUMERIC | OPT | NONE |
The percentage of the total assembly/kit price this component represents. | ||||
| mnAmountUnitCost | UNCS | MATH_NUMERIC | OPT | NONE |
The amount per unit, derived by dividing the total cost by the unit quantity. | ||||
| szPurchasingCostCenter | OMCU | char | OPT | NONE |
The business unit from an account number. The account number business unit is usually found in the data item MCU, however, Distribution
| ||||
| szObjectAccount | OBJ | char | OPT | NONE |
The portion of a general ledger account that refers to the division of the Cost Code (for example, labor, materials, and equipment) into
| ||||
| szSubsidiary | SUB | char | OPT | NONE |
A subset of an object account. Subsidiary accounts include detailed records of the accounting activity for an object account. | ||||
| 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
| ||||
| 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
| ||||
| szRevisionNumber | 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
| ||||
| mnItemNumberUseUp | UUPG | MATH_NUMERIC | OPT | NONE |
Future use This is the item number to use after this bill of material item is used up. | ||||
| 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. | ||||
| 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. | ||||
| 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. | ||||
| 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. | ||||
| 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. | ||||
| nSubstituteCounter | SUCO | integer | OPT | NONE |
The number of substitutes that have been defined for a component or ingredient. | ||||
| mnConsumptionStart | STRC | MATH_NUMERIC | OPT | NONE |
Future use - APS The number of days after the process start date that APS begins consumption of this particular item. The default value is 0. | ||||
| mnConsumptionEnd | ENDC | MATH_NUMERIC | OPT | NONE |
Reserved for J.D. Edwards. | ||||
| mnComponentNumberBOM | 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
| ||||
| szBubbleSequenceAlphaNum | BSEQAN | char | OPT | NONE |
A sequence number on a secondary bill of material that indicates the drawing bubble number or the location identifier for an engineering
| ||||
| cConstraintsFlag | APSC | char | OPT | NONE |
A code that specifies that the entity is constraint-based and can be planned by SCP. | ||||
| UniversalDateUpdated | UUPMJ | INVALID ITEM DATA TYPE: 55 | OPT | NONE |
| mnEndItemNumber | OKIT | MATH_NUMERIC | OPT | NONE |
| szEndItemBranch | MCU0 | char | OPT | NONE |
An alphanumeric field that identifies a separate entity within a business for which you want to track costs. For example, a business unit might
| ||||
| szEndItemBillType | OTBM | char | OPT | NONE |
| mnEndItemBatchQty | #BQT | MATH_NUMERIC | OPT | NONE |
A number that represents the quantity of finished units that you expect this bill of material or routing to produce. You can specify varying
| ||||
| mnComponentBatchQty | BQTE1 | MATH_NUMERIC | OPT | NONE |
The quantity of finished units that you expect this bill of material or routing to produce. This field allows you to specify varying quantities of
| ||||
| EffectiveFomDateTime | UEFFD | INVALID ITEM DATA TYPE: 55 | OPT | NONE |
Effective From Date based on U Time. | ||||
| EffectiveToDateTime | UEFTD | INVALID ITEM DATA TYPE: 55 | OPT | NONE |
Effective To Date based on U Time. | ||||
| szTypeofComponent | TYCOMP | char | OPT | NONE |
A UDC that defines the type of component: Valid Values are: 1.O - Optional Component 2.R -Rework Component. | ||||
| szBOMSTRING | BOSTR | char | OPT | NONE |
A Prep Code used by DFM Kanban Management. | ||||
| szMachineKey | MKEY | char | OPT | NONE |
The Location or Machine Key indicates the name of the machine on the network (server or workstation). | ||||
| szDFMLineIdentifier | DFMLINE | char | OPT | NONE |
This is used to identify the DFM line. | ||||
| szUnitOfMeasurePrimary | UOM1 | char | OPT | 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
| ||||
| None |
| None |