D3103030 - F3102 File Server Data Structure
| Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
|---|---|---|---|---|
| cMode | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event. | ||||
| mnWorkOrderNumber | 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,
| ||||
| cParentOrComponent | PART | char | OPT | NONE |
An option that specifies whether the system displays parent records or child records. If you turn on this option, the system displays parent
| ||||
| szCostType | COST | char | OPT | NONE |
A code that designates each element of cost for an item. Examples of the cost object types are:
o A1 Purchased raw material
o B1
| ||||
| mnShortItemNumber | 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
| ||||
| cManufacturedOrPurchased | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event. | ||||
| mnJobNumber | JOBS | MATH_NUMERIC | OPT | NONE |
The job number (work station ID) which executed the particular job. | ||||
| szF3102CacheJobNumber | JOBN | char | OPT | NONE |
The code that identifies the work station ID that executed a particular job. | ||||
| idF3102CachePointer | GENLNG | ID | OPT | NONE |
General purpose ID variable. | ||||
| szOrderType | 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
| ||||
| mnOperationSequenceNumber | 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
| ||||
| sz2ndItemNumber | LITM | char | OPT | NONE |
A number that identifies the item. The system provides three separate item numbers plus an extensive cross-reference capability to
| ||||
| sz3rdItemNumber | AITM | char | OPT | NONE |
The system provides three separate item numbers plus an extensive cross-reference capability to alternate item numbers. These item
| ||||
| mnComponentItemNumber | CPIT | MATH_NUMERIC | OPT | NONE |
The short identifier for the component item number. | ||||
| szComponent3rdItemNumber | CPIA | char | OPT | NONE |
The system provides three separate item numbers plus an extensive cross reference capability to alternate item numbers.
These item
| ||||
| szComponent2ndItemNumber | CPIL | char | OPT | NONE |
The system provides three separate item numbers.
They are:
1. Item Number (short) - An eight digit, computer assigned, completely
| ||||
| cVarianceCode | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event. | ||||
| cUpdateStandard | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event. | ||||
| mnStandardAmount | OPAT | MATH_NUMERIC | OPT | NONE |
The standard amount to produce a given amount of product. | ||||
| mnStandardUnits | OPUN | MATH_NUMERIC | OPT | NONE |
The standard units to produce a given amount of product. | ||||
| cUpdateCurrent | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event. | ||||
| mnCurrentAmount | CCCA | MATH_NUMERIC | OPT | NONE |
The current amount to produce a given amount of product. | ||||
| mnCurrentUnits | CCCU | MATH_NUMERIC | OPT | NONE |
The current units to produce a given amount of product. | ||||
| cUpdatePlanned | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event. | ||||
| mnPlannedAmount | PLAT | MATH_NUMERIC | OPT | NONE |
The planned amount to produce a given amount of product. | ||||
| mnPlannedUnits | PLUN | MATH_NUMERIC | OPT | NONE |
Future Use. | ||||
| cUpdateActual | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event. | ||||
| mnActualAmount | CLAT | MATH_NUMERIC | OPT | NONE |
The actual amount to produce a given amount of product. | ||||
| mnActualUnits | CLUN | MATH_NUMERIC | OPT | NONE |
The actual units to produce a given amount of product. | ||||
| cUpdateCompleted | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event. | ||||
| mnCompletedAmount | CPAT | MATH_NUMERIC | OPT | NONE |
The amount completed for the work order. | ||||
| mnCompletedUnits | CPUN | MATH_NUMERIC | OPT | NONE |
The units completed for the work order. | ||||
| cUpdateScrap | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event. | ||||
| mnScrappedAmount | SLAT | MATH_NUMERIC | OPT | NONE |
The amount scrapped for the work order. | ||||
| mnScrappedUnits | SLUN | MATH_NUMERIC | OPT | NONE |
The units scrapped for the work order. | ||||
| cUpdateUnaccounted | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event. | ||||
| mnCurrentUnaccountedAmount | CCUA | MATH_NUMERIC | OPT | NONE |
The current amount reported but not yet posted to the general ledger. | ||||
| mnCurrentUnaccountedUnits | CCUU | MATH_NUMERIC | OPT | NONE |
The current units reported but not yet posted to the general ledger. | ||||
| cUpdateUnpostable | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event. | ||||
| mnUnpostableAmount | UNPA | MATH_NUMERIC | OPT | NONE |
A number that specifies the amount of scrap that is unaccounted for and is not reported to the general ledger through the Manufacturing
| ||||
| mnUnpostableUnits | UNPU | MATH_NUMERIC | OPT | NONE |
The current units reported but not yet posted to the general ledger. | ||||
| 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,
| ||||
| szWorkOrderUOM | UOM8 | char | OPT | NONE |
A user defined code (00/UM) that indicates the unit of measure in which you produce the item. | ||||
| szPrimaryUOM | 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
| ||||
| cUpdateEngineeringVariance | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event. | ||||
| mnEngineeringVariance | ENGV | MATH_NUMERIC | OPT | NONE |
This field contains the posted engineering variance amount that is calculated by Variance Journal Entries (P31804) when run in Final mode.
| ||||
| cUpdatePlannedVariance | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event. | ||||
| mnPlannedVariance | PLNV | MATH_NUMERIC | OPT | NONE |
This field contains the posted planned variance amount, calculated in the last run of P31804 (Final mode). It is equal to Planned amount -
| ||||
| cUpdateActualVariance | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event. | ||||
| mnActualVariance | VACT | MATH_NUMERIC | OPT | NONE |
This field contains the posted actual variance amount that is calculated by Variance Journal Entries (P31804) when run in Final mode. The
| ||||
| cUpdateOtherVariance | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event. | ||||
| mnOtherVariance | OTHV | MATH_NUMERIC | OPT | NONE |
This field contains the posted other variance amount, which is calculated in the last run of Variance Journal Entries (P31804) when run in
| ||||
| cUpdateNetVariance | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event. | ||||
| mnNetVariance | NETV | MATH_NUMERIC | OPT | NONE |
This field contains the posted Net variance amount, calculated in the last run of P31804 (Final mode). It is equal to Actual amount -
| ||||
| szFactorCode | SCTC | char | OPT | NONE |
A code used to retrieve factor information from the Generic Rate File (F00191). System Code 30 Record Type CF | ||||
| mnFactor | STFC | MATH_NUMERIC | OPT | NONE |
A generic factor number used to calculate data. | ||||
| szRateCode | RATS | char | OPT | NONE |
A code used to retrieve rate information from the Generic Rate File (F00191). System Code 30 Record Type CR | ||||
| mnRate | RTSD | MATH_NUMERIC | OPT | NONE |
A code used to define rate information in the Generic Rate File (F00191). | ||||
| cStandardCostingFlag | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event. | ||||
| szBranch | 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
| ||||
| 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
| ||||
| mnWorkOrderQuantity | UORG | MATH_NUMERIC | OPT | NONE |
The quantity of units affected by this transaction. | ||||
| mnQuantityShipped | SOQS | MATH_NUMERIC | OPT | 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
| ||||
| mnPrimaryOrderQuantity | UORG | MATH_NUMERIC | OPT | NONE |
The quantity of units affected by this transaction. | ||||
| mnAccountingCostQty | ACQ | MATH_NUMERIC | OPT | NONE |
An amount that the system uses in the Cost Rollup program to determine the allocation of setup costs. The system totals the setup costs
| ||||
| mnWorkOrderConversionFactor | MN29D9 | MATH_NUMERIC | OPT | NONE |
This is a generic field used as a work field in Everest. | ||||
| mnComponentToPrimaryConvFactor | MN29D9 | MATH_NUMERIC | OPT | NONE |
This is a generic field used as a work field in Everest. | ||||
| 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
| ||||
| cLaborRateSourceFlag | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event. | ||||
| cMachineRateSourceFlag | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event. | ||||
| cMPMBudgetLaborRate | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event. | ||||
| cMPMBudgetMachineRate | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event. | ||||
| szMPMStatus | SRST | char | OPT | NONE |
A user defined code (00/SS) that describes the status of a work order, rate schedule, or engineering change order. Any status change from
| ||||
| szMPMEstimateCostMethod | LEDG | char | OPT | NONE |
A user defined code (40/CM) that specifies the basis for calculating item costs. Cost methods 01 through 19 are reserved for J.D. Edwards
| ||||
| cMPMWorkOrderFlag | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event. | ||||
| szWorkOrderStatus | SRST | char | OPT | NONE |
A user defined code (00/SS) that describes the status of a work order, rate schedule, or engineering change order. Any status change from
| ||||
| szParentInventoryCostMethod | LEDG | char | OPT | NONE |
A user defined code (40/CM) that specifies the basis for calculating item costs. Cost methods 01 through 19 are reserved for J.D. Edwards
| ||||
| mnEmployee | AN8 | MATH_NUMERIC | OPT | NONE |
A number that identifies an entry in the Address Book system, such as employee, applicant, participant, customer, supplier, tenant, or
| ||||
| cCalculateCurrent | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event. | ||||
| cCalculatePlanned | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event. | ||||
| cCalculateActual | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event. | ||||
| cCalculateCompleted | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event. | ||||
| cCalculateScrapped | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event. | ||||
| cCalculateParent | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event. | ||||
| szR4211RelatedOrderNumber | RORN | char | OPT | NONE |
A number that identifies a secondary purchase order, sales order, or work order that is associated with the original order. This number is for
| ||||
| 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. | ||||
| cPrimaryBin | PBIN | char | OPT | NONE |
A code that indicates whether this is the primary or secondary location for this item within this stocking location. Valid values are:
P Primary
| ||||
| mnRestatedUnits | UORG | MATH_NUMERIC | OPT | NONE |
The quantity of units affected by this transaction. | ||||
| mnOperationOrderQuantity | UORG | MATH_NUMERIC | OPT | NONE |
The quantity of units affected by this transaction. | ||||
| mnComponentScrapPercent | 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
| ||||
| 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. | ||||
| 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
| ||||
| cOverheadPercentOrRate | PORR | char | OPT | NONE |
An option that determines whether values for overhead fields (cost components C1 through C4) in the Work Center Rates table (F30008) are
| ||||
| cModifyCostByWorkCenterEff | MWCE | char | OPT | NONE |
An option that determines whether the cost rollup creates cost component B4 (for labor efficiency) based on the direct labor value (cost
| ||||
| cIncludeVariableLaborOH | IVO | char | OPT | NONE |
An option that determines whether the cost rollup creates cost component C3 (for variable labor overhead) in the Item Cost Component
| ||||
| cCalcVariableOnDirectLabor | CVDL | char | OPT | NONE |
An option that determines whether the cost rollup includes direct labor expenses (cost component B1) in the total used to calculate variable
| ||||
| cCalcVariableOnSetupLabor | CVSL | char | OPT | NONE |
An option that determines whether the cost rollup includes setup labor expenses (cost component B2) in the total used to calculate variable
| ||||
| cIncludeWCEfficiencyInOH | CVDS | char | OPT | NONE |
An option that determines whether the cost rollup includes work center efficiency when calculating overhead values, if you specified that
| ||||
| cIncludeFixedLaborOH | IFO | char | OPT | NONE |
An option that determines whether the cost rollup creates cost component C4 (for fixed labor overhead) in the Item Cost Component
| ||||
| cCalculateFixedOnDirectLabor | CFDL | char | OPT | NONE |
An option that determines whether the cost rollup includes direct labor expenses (cost component B1) in the total used to calculate fixed
| ||||
| cCalculateFixedOnSetupLabor | CFSL | char | OPT | NONE |
An option that determines whether the cost rollup includes setup labor expenses (cost component B2) in the total used to calculate fixed
| ||||
| cIncludeFixedMachineOH | IFMO | char | OPT | NONE |
An option that determines whether the cost rollup creates cost component C2 (for fixed machine overhead) in the Item Cost Component
| ||||
| cIncludeVariableMachineOH | IVMO | char | OPT | NONE |
An option that determines whether the cost rollup creates cost component C1 (for variable machine overhead) in the Cost Components
| ||||
| cStandardCostCalculation | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event. | ||||
| mnRunLaborHours | RUNL | MATH_NUMERIC | OPT | NONE |
The standard hours of labor that you expect to incur in the normal production of this item.
The run labor hours in the Routing Master table
| ||||
| mnRunMachineHours | RUNM | MATH_NUMERIC | OPT | NONE |
The standard machine hours that you expect to incur in the normal production of this item. | ||||
| mnSetupLaborHours | SETL | MATH_NUMERIC | OPT | NONE |
The standard setup hours that you expect to incur in the normal completion of this item. This value is not affected by crew size. | ||||
| cCopyMode | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event. | ||||
| cCopyMPMCacheFlag | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event. | ||||
| cCopyFrozenOrSimulated | 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. | ||||
| mnUnitCost | UNCS | MATH_NUMERIC | OPT | NONE |
The amount per unit, derived by dividing the total cost by the unit quantity. | ||||
| 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
| ||||
| cErrorCode | ERRC | char | OPT | NONE |
This error code indicates if any errors occurred during the creation of the Trip Document Detail (F4914) records by the Delivery Document
| ||||
| 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
| ||||
| szUserID | USER | char | OPT | NONE |
The code that identifies a user profile. | ||||
| jdDateUpdated | UPMJ | JDEDATE | OPT | NONE |
The date that specifies the last update to the file record. | ||||
| mnTimeOfDay | TDAY | MATH_NUMERIC | OPT | NONE |
The computer clock in hours:minutes:seconds. | ||||
| szWorkStationID | JOBN | char | OPT | NONE |
The code that identifies the work station ID that executed a particular job. | ||||
| mnF3111EstimatedAmount | EA | MATH_NUMERIC | OPT | NONE |
A number that identifies the estimated unit cost of the part used on the work order. | ||||
| mnParentScrappedUnits | SOCN | MATH_NUMERIC | OPT | 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
| ||||
| szWorkCenter | 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
| ||||
| cCoByProduct | COBY | char | OPT | NONE |
A code that distinguishes standard components or ingredients from co-products,by-products, and intermediates. Co-products are
| ||||
| mnMachine | NUMB | MATH_NUMERIC | OPT | NONE |
An 8-digit number that uniquely identifies an asset. | ||||
| mnEstimatedLaborRate | LABP | MATH_NUMERIC | OPT | NONE |
A number that specifies the rate used to determine the estimated cost of labor hours for a specific operation in the Enter/Change Routing
| ||||
| mnEstimatedMachineRate | MACR | MATH_NUMERIC | OPT | NONE |
A rate that the system uses to determine the machine run cost for a specific item at a specific operation in the Work With Routing Master
| ||||
| mnEstimatedSetupLaborRate | SETR | MATH_NUMERIC | OPT | NONE |
A number that specifies the rate that you use to estimate the cost of setup labor for a specific operation in the Work With Routing Master
| ||||
| mnNetChangeFactor | MATH01 | MATH_NUMERIC | OPT | NONE |
- - - Good Performance Low Value. | ||||
| cCostByWorkCenter | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event. | ||||
| szTypeRouting | TRT | char | OPT | NONE |
A user defined code (40/TR) that indicates the type of routing. You can define different types of routing instructions for different uses.
For
| ||||
| cMasterRoutingYN | MRYN | char | OPT | NONE |
An option that determines whether the system uses the master routing for an item or a routing defined for the parent item. Both routings are
| ||||
| jdEffectiveFromDate | EFFF | JDEDATE | OPT | 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 | OPT | 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
| ||||
| szCostMethod | LEDG | char | OPT | NONE |
A user defined code (40/CM) that specifies the basis for calculating item costs. Cost methods 01 through 19 are reserved for J.D. Edwards
| ||||
| mnBatchQuantity | 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
| ||||
| szWorkcenterBranch | WMCU | char | OPT | NONE |
This is the branch/plant to which the work center belongs and must exist in the business unit master (F0006) and branch plant constants file
| ||||
| cUseF3111Cache | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event. | ||||
| mnF3111CacheJobNo | JOBS | MATH_NUMERIC | OPT | NONE |
The job number (work station ID) which executed the particular job. | ||||
| szLocation | LOCN | char | OPT | NONE |
The storage location from which goods will be moved. | ||||
| None |
| None |