DF311109A - Routing Structure File Server
| Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both | 
|---|---|---|---|---|
| cDataDictionaryValidation | EV04 | char | NONE | NONE | 
PeopleSoft event point processing flag 04.  | ||||
| cSuppressErrorMessage | EV05 | char | NONE | NONE | 
A flag that indicates whether automatic spell check is turned on.  | ||||
| szErrorMessageID | DTAI | char | NONE | 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 | NONE | NONE | 
This error code indicates if any errors occurred during the creation of the Trip Document Detail (F4914) records by the Delivery Document 
  | ||||
| cActionCode | EV01 | char | OPT | NONE | 
An option that specifies the type of processing for an event.  | ||||
| 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.  | ||||
| cReturnHrequest | EV02 | char | OPT | NONE | 
An option that specifies the type of processing for an event.  | ||||
| idHrequestID | GENLNG | ID | OPT | NONE | 
General purpose ID variable.  | ||||
| mnUniqueKeyIDInternal | UKID | MATH_NUMERIC | OPT | NONE | 
This field is a unique number used to identify a record in a file.  | ||||
| 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 
  | ||||
| mnItemNumberShortKit | KIT | MATH_NUMERIC | OPT | NONE | 
The system provides for three separate item numbers.
   1.   Item Number (short) - An eight-digit, computer assigned, completely 
  | ||||
| szItemNumber2ndKit | KITL | char | OPT | NONE | 
The system provides for three separate item numbers.
   1.   Item Number (short) - An eight-digit, computer assigned, completely 
  | ||||
| szItemNumber3rdKit | KITA | char | OPT | NONE | 
The system provides three separate item numbers:
   1. Item Number (short) - An eight-digit, computer assigned, completely non-significant 
  | ||||
| szCostCenterAlt | 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 
  | ||||
| szAutoLoadDescription | ALD | char | OPT | NONE | 
This field is used to pull in a standard description from a user defined for the specified operation.  | ||||
| szDescriptionLine1 | DSC1 | char | OPT | NONE | 
Brief information about an item; a remark or an explanation.  | ||||
| szLineIdentifier | LINE | char | OPT | NONE | 
A number that defines a production line or cell. Detailed work center operations can be defined inside the line or cell.  | ||||
| szCostCenter | 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 
  | ||||
| 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 
  | ||||
| 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 
  | ||||
| cPayPointCode | BFPF | char | OPT | NONE | 
A code that indicates whether a work center has labor, material, or both,backflushed through it when quantities are reported against 
  | ||||
| cLaborOrMachine | LAMC | char | OPT | NONE | 
A code to designate whether the operation is labor or machine.  | ||||
| cTimeBasisCode | TIMB | char | OPT | NONE | 
A user defined code (30/TB) that indicates how machine or labor hours are expressed for a product. Time basis codes identify the time 
  | ||||
| mnOperationShrinkage | OPSR | MATH_NUMERIC | OPT | NONE | 
Future use. This field indicates the percentage of scrap that is typically encountered for this operation for this part.  If the quantity ordered is 
  | ||||
| mnUnitsBatchQuantity | 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 
  | ||||
| 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).  | ||||
| mnRunMachineStandard | RUNM | MATH_NUMERIC | OPT | NONE | 
The standard machine hours that you expect to incur in the normal production of this item.  | ||||
| mnRunLaborStandard | 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 
  | ||||
| mnSetupLaborHrsStdr | 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.  | ||||
| mnCrewSize | SETC | MATH_NUMERIC | OPT | NONE | 
The number of people who work in the specified work center or routing operation.
The system multiplies the Run Labor value in the Routing 
  | ||||
| mnMoveHours | MOVD | MATH_NUMERIC | OPT | NONE | 
The planned hours that are required to move the order from this operation to the next operation in the same work center.
If the Routing 
  | ||||
| mnQueueHours | QUED | MATH_NUMERIC | OPT | NONE | 
The total hours that an order is expected to be in queue at work centers and moving between work centers.
The system stores this value in 
  | ||||
| mnLeadtimeOverlap | LTPC | MATH_NUMERIC | OPT | NONE | 
Future use This field is used to modify the normal logic in the backscheduling routine. If operation number 010 starts on day one and is 
  | ||||
| mnPercentOfOverlap | POVR | MATH_NUMERIC | OPT | NONE | 
A number that indicates the percentage that successive operations can overlap.
The actual overlap percentage entered for the operation 
  | ||||
| mnNextOperation | NXOP | MATH_NUMERIC | OPT | NONE | 
The operation number with which the current operation can be simultaneously processed.  | ||||
| mnPercentOperationalPl | OPYP | MATH_NUMERIC | OPT | NONE | 
The planned output yield percent for a step. The Planned Yield Update program uses this value to update the cumulative percent in the 
  | ||||
| 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 
  | ||||
| szUnitNumber | APID | char | OPT | NONE | 
A 12-character alphanumeric code used as an alternate identification number for an asset. This number is not required, nor does the 
  | ||||
| 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 
  | ||||
| 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  | ||||
| szInspectionCode | INPE | char | OPT | NONE | 
Future use. This is a user defined code specifying the type of normal inspection practice for this particular item.  Examples that could be 
  | ||||
| szJobCategory | JBCD | char | OPT | NONE | 
A user defined code (07/G) that defines the jobs within your organization. You can associate pay and benefit information with a job type and 
  | ||||
| mnAddressNumber | 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 
  | ||||
| mnPrimaryLastVendorNo | VEND | MATH_NUMERIC | OPT | NONE | 
The address book number of the preferred provider of this item.  | ||||
| cPurchaseOrderY | POY | char | OPT | NONE | 
Determines if the Work Order Generation program (P31410) creates a purchase order for a subcontracted operation within a routing. Valid 
  | ||||
| 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  
  | ||||
| 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.  | ||||
| szRoutingRevisionLevel | RREV | char | OPT | NONE | 
A number that indicates the revision level of a routing. It is usually used in conjunction with an engineering change notice or engineering 
  | ||||
| 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.  | ||||
| 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.  | ||||
| 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 
  | ||||
| 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 
  | ||||
| szLocation | LOCN | char | OPT | NONE | 
The storage location from which goods will be moved.  | ||||
| mnResourceunitsconsumed | RUC | MATH_NUMERIC | OPT | NONE | 
A number that indicates how many of the line's resource units are needed to produce one item.  | ||||
| szUMCapacityUOM | CAPU | char | OPT | NONE | 
A unit of measure that you use to express the capacity of a production line. Examples of units of measure include hours, number of 
  | ||||
| szActivityCode | ACTB | char | OPT | NONE | 
The aggregation of actions performed within an organization that are useful for purposes of activity-based costing.  | ||||
| mnAssetItemNumber | NUMB | MATH_NUMERIC | OPT | NONE | 
An 8-digit number that uniquely identifies an asset.  | ||||
| nCoByCounter | CBCO | integer | OPT | NONE | 
A number that indicates the quantity of the co-products and by-products for the routing operation.  | ||||
| nComponent_IngredientCount | CICO | integer | OPT | NONE | 
The number of components or ingredients that are defined for the routing operation.  | ||||
| nIntermediateCounter | IMCO | integer | OPT | NONE | 
The number of intermediates that are defined for the routing operation.  | ||||
| mnMinimumProduction | MPRO | MATH_NUMERIC | OPT | NONE | 
Future Use - APS A value that specifies the minimum production quantity required for APS.  | ||||
| cConstraintsFlag | APSC | char | OPT | NONE | 
A code that specifies that the entity is constraint-based and can be planned by SCP.  | ||||
| mnMinimumSeparation | MNSP | MATH_NUMERIC | OPT | NONE | 
Reserved by J.D. Edwards.  | ||||
| mnMaximumSeparation | MXSP | MATH_NUMERIC | OPT | NONE | 
Future use - APS
A value that specifies the maximum wait time until the end of the activity. This value can be used only with the APS 
  | ||||
| szCompentencyType | CMPE | char | OPT | NONE | 
A code that identifies a competency table or category for which you can track employee competencies. Valid values 
  | ||||
| szCompentencyCode | CMPC | char | OPT | NONE | 
A code that specifies a competency within a competency type. For example, a competency for the competency type "Skill" might be "C 
  | ||||
| mnCompetencyLevelFrom | CPLVLFR | MATH_NUMERIC | OPT | NONE | 
This value set the lowest value to be included in the rule criteria range for a competency level range selection.  | ||||
| mnCompetencyLevelTo | CPLVLTO | MATH_NUMERIC | OPT | NONE | 
This value set the highest value to be included in the rule criteria range for a competency level range selection.  | ||||
| cRuleMatchFlag | CMRQ | char | OPT | NONE | 
A field that indicates whether the resource must satisfy the requirements that define the rule criteria. Valid values are:
   1   The resource must 
  | ||||
| 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 
  | ||||
| mnUnitsBatchQty | 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 
  | ||||
| mnLevelOfRouting | LROUT | MATH_NUMERIC | OPT | NONE | 
The level within the routing.  | ||||
| szVersionId | VID | char | OPT | NONE | 
The version id is the version identification when a record was added or updated in a table.  | ||||
| szMachineKey | MKEY | char | OPT | NONE | 
The Location or Machine Key indicates the name of the machine on the network (server or workstation).  | ||||
| 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.  | ||||
| mnRunLaborExtended | ERUNL | MATH_NUMERIC | OPT | NONE | 
This is the Run Labor Hours calculated based on the end item batch quantity.  | ||||
| mnExtendedRunMachine | ERUNM | MATH_NUMERIC | OPT | NONE | 
This is the Run Machine Hours calculated based on the end item batch quantity.  | ||||
| UniversalDateUpdated | UUPMJ | INVALID ITEM DATA TYPE: 55 | OPT | NONE | 
| szDFMLineIdentifier | DFMLINE | char | OPT | NONE | 
This is used to identify the DFM line.  | ||||
| None | 
| None |