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 |