D31P0050 - Cache Project Process
| Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both | 
|---|---|---|---|---|
| szParentWoNumber | PARS | char | OPT | BOTH | 
A number that identifies the parent work order. You can use this number to do the following:
    o Enter default values for new work orders, 
  | ||||
| idProjectCusorPtr | GENLNG | ID | OPT | BOTH | 
General purpose ID variable.  | ||||
| cActioncode | EV01 | char | OPT | BOTH | 
An option that specifies the type of processing for an event.  | ||||
| cSequentialFetch | EV01 | char | OPT | BOTH | 
An option that specifies the type of processing for an event.  | ||||
| cCacheErrorCode | EV01 | char | OPT | BOTH | 
An option that specifies the type of processing for an event.  | ||||
| mnPlannedMaterial | MATH01 | MATH_NUMERIC | OPT | BOTH | 
- - - Good Performance Low Value.  | ||||
| mnPlannedLabor | MATH01 | MATH_NUMERIC | OPT | BOTH | 
- - - Good Performance Low Value.  | ||||
| mnPlannedOther | MATH01 | MATH_NUMERIC | OPT | BOTH | 
- - - Good Performance Low Value.  | ||||
| mnPlannedSpecailAmount | MATH01 | MATH_NUMERIC | OPT | BOTH | 
- - - Good Performance Low Value.  | ||||
| mnPlannedSpecailUnits | MATH01 | MATH_NUMERIC | OPT | BOTH | 
- - - Good Performance Low Value.  | ||||
| mnEstimatedSpecialAmount | MATH01 | MATH_NUMERIC | OPT | BOTH | 
- - - Good Performance Low Value.  | ||||
| mnEstimatedSpecialUnit | MATH01 | MATH_NUMERIC | OPT | BOTH | 
- - - Good Performance Low Value.  | ||||
| mnTotalPlanned | MATH01 | MATH_NUMERIC | OPT | BOTH | 
- - - Good Performance Low Value.  | ||||
| mnTotalEstimated | MATH01 | MATH_NUMERIC | OPT | BOTH | 
- - - Good Performance Low Value.  | ||||
| mnBugetedCost | MATH01 | MATH_NUMERIC | OPT | BOTH | 
- - - Good Performance Low Value.  | ||||
| szErrorMessageID | DTAI | char | OPT | OUTPUT | 
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 
  | ||||
| mnJobnumber | JOBS | MATH_NUMERIC | REQ | BOTH | 
The job number (work station ID) which executed the particular job.  | ||||
| nIndexNumber | INT01 | integer | REQ | INPUT | 
Number of Days in Future to Query for Responses Due.  | ||||
| mnWorkFileLineNumber | MATH01 | MATH_NUMERIC | OPT | BOTH | 
- - - Good Performance Low Value.  | ||||
| nNumberOfKeys | INT02 | integer | REQ | INPUT | 
Number of Days in the Past to Query for Quote Requests Received.  | ||||
| mnMPMParentNumber | MATH01 | MATH_NUMERIC | OPT | BOTH | 
- - - Good Performance Low Value.  | ||||
| mnSOParentLineNumber | MATH01 | MATH_NUMERIC | OPT | BOTH | 
- - - Good Performance Low Value.  | ||||
| mnOrderNumber | DOCO | MATH_NUMERIC | OPT | BOTH | 
A number that identifies an original document. This document can be a voucher, a sales order, an invoice, unapplied cash, a journal entry, 
  | ||||
| szOrderType | DCTO | char | OPT | BOTH | 
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 
  | ||||
| szOrderSuffix | SFXO | char | OPT | BOTH | 
In the A/R and A/P systems, a code that corresponds to the pay item. In the Sales Order and Procurement systems, this code identifies 
  | ||||
| szRelatedOrderNumber | RORN | char | OPT | BOTH | 
A number that identifies a secondary purchase order, sales order, or work order that is associated with the original order. This number is for 
  | ||||
| szRelatedOrderType | RCTO | char | OPT | BOTH | 
A user defined code (system 00, type DT) that indicates the document type of the secondary or related order. For example, a purchase 
  | ||||
| mnLineNumber | LNID | MATH_NUMERIC | OPT | BOTH | 
A number that identifies multiple occurrences, such as line numbers on a purchase order or other document. Generally, the system assigns 
  | ||||
| mnPegToWorkOrder | PTWO | MATH_NUMERIC | OPT | BOTH | 
Case number related to the service work order.  | ||||
| cWOType | TYPS | char | OPT | BOTH | 
A user defined code (00/TY) that indicates the classification of a work order or engineering change order.
You can use work order type as a 
  | ||||
| cWOPriority | PRTS | char | OPT | BOTH | 
A user defined code (00/PR) that indicates the relative priority of a work order or engineering change order in relation to other orders.
A 
  | ||||
| szWODescription | DL01 | char | OPT | BOTH | 
A user defined name or remark.  | ||||
| szStatusComment | STCM | char | OPT | BOTH | 
A brief description to explain the status of the work order.  | ||||
| szCompany | CO | char | OPT | BOTH | 
A code that identifies a specific organization, fund, or other reporting entity. The company code must already exist in the Company 
  | ||||
| szBusinessUnit | MCU | char | OPT | BOTH | 
An alphanumeric code that identifies a separate entity within a business for which you want to track costs. For example, a business unit 
  | ||||
| szBranchPlant | MMCU | char | OPT | BOTH | 
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 
  | ||||
| szLocation | LOCN | char | OPT | BOTH | 
The storage location from which goods will be moved.  | ||||
| szAisleLocation | AISL | char | OPT | BOTH | 
A code that identifies a location in a warehouse. This code is used in conjunction with a bin and lot identifier, to indicate a specific, tangible 
  | ||||
| szBinLocation | BIN | char | OPT | BOTH | 
  | ||||
| szWOStatus | SRST | char | OPT | BOTH | 
A user defined code (00/SS) that describes the status of a work order, rate schedule, or engineering change order. Any status change from 
  | ||||
| jdDateStatusChanged | DCG | JDEDATE | OPT | BOTH | 
  | ||||
| szSubsidiary | SUB | char | OPT | BOTH | 
  | ||||
| mnCustomerNumber | AN8 | MATH_NUMERIC | OPT | BOTH | 
  | ||||
| mnOriginatorNumber | ANO | MATH_NUMERIC | OPT | BOTH | 
  | ||||
| mnManager | ANSA | MATH_NUMERIC | OPT | BOTH | 
  | ||||
| mnSupervisor | ANPA | MATH_NUMERIC | OPT | BOTH | 
  | ||||
| mnAssignedToAddressNumber | ANP | MATH_NUMERIC | OPT | BOTH | 
The address book number of the person assigned to do the work.  | ||||
| jdPlannedCompletionDate | DPL | JDEDATE | OPT | BOTH | 
The date that the work order or engineering change order is planned to be completed.  | ||||
| mnNextAddressNumber | NAN8 | MATH_NUMERIC | OPT | BOTH | 
An eight-position number used to identify each entry in the Address Book,e.g., employees, customers, suppliers, special mailing 
  | ||||
| mnInspectorNumber | ANT | MATH_NUMERIC | OPT | BOTH | 
The address book number of the inspector.  | ||||
| jdOrderDate | TRDJ | JDEDATE | OPT | BOTH | 
The date that an order was entered into the system. This date determines which effective level the system uses for inventory pricing.  | ||||
| jdStartDate | STRT | JDEDATE | OPT | BOTH | 
The start date for the order. You can enter this date manually, or have the system calculate it using a backscheduling routine. The routine 
  | ||||
| jdRequestedDate | DRQJ | JDEDATE | OPT | BOTH | 
The date that an item is scheduled to arrive or that an action is scheduled for completion.  | ||||
| jdCompletionDate | STRX | JDEDATE | OPT | BOTH | 
The date that the work order or engineering change order is completed or canceled.  | ||||
| jdAssignedToDate | DAP | JDEDATE | OPT | BOTH | 
  | ||||
| jdAssignToInspectorDate | DAT | JDEDATE | OPT | BOTH | 
The date that the system sends the engineering change order notice to the inspector in the review process.  | ||||
| jdPaperPrintedDate | PPDT | JDEDATE | OPT | BOTH | 
This field indicates the date that the workorder paperwork was last printed. A blank field would indicate that the workorder paperwork has 
  | ||||
| szWOCategoryCode001 | WR01 | char | OPT | BOTH | 
A user defined code (00/W1) that indicates the current stage or phase of development for a work order. You can assign a work order to only 
  | ||||
| szWOCategoryCode002 | WR02 | char | OPT | BOTH | 
A user defined code (00/W2) that indicates the type or category of a work order.
Note: A processing option for some forms lets you enter a 
  | ||||
| szWOCategoryCode003 | WR03 | char | OPT | BOTH | 
A user defined code (00/W3) that indicates the type or category of the work order.
Note: A processing option for some forms allows you to 
  | ||||
| szWOCategoryCode004 | WR04 | char | OPT | BOTH | 
A user defined code (00/W4) that indicates the type or category of the work order.  | ||||
| szWOCategoryCode005 | WR05 | char | OPT | BOTH | 
A user defined code (00/W5) that indicates the type or category of the work order.  | ||||
| szWOCategoryCode006 | WR06 | char | OPT | BOTH | 
A user defined code (00/W6) that indicates the status of the work order.  | ||||
| szWOCategoryCode007 | WR07 | char | OPT | BOTH | 
A user defined code (00/W7) that indicates the service type for the work order.  | ||||
| szWOCategoryCode008 | WR08 | char | OPT | BOTH | 
A user defined code (00/W8) that indicates the type or category of the work order.  | ||||
| szWOCategoryCode009 | WR09 | char | OPT | BOTH | 
A user defined code (00/W9) that indicates the type or category of the work order.  | ||||
| szWOCategoryCode010 | WR10 | char | OPT | BOTH | 
A user defined code (00/W0) that indicates the type or category of the work order.  | ||||
| szReference1 | VR01 | char | OPT | BOTH | 
An alphanumeric value used as a cross-reference or secondary reference number. Typically, this is the customer number, supplier 
  | ||||
| szReference2 | VR02 | char | OPT | BOTH | 
A field available to record reference numbers, such as the supplier's bid document number, quote document, sales order, work order, or 
  | ||||
| mnEstimatedAmount | AMTO | MATH_NUMERIC | OPT | BOTH | 
  | ||||
| mnCrewSize | SETC | MATH_NUMERIC | OPT | BOTH | 
The number of people who work in the specified work center or routing operation.
The system multiplies the Run Labor value in the Routing 
  | ||||
| mnDistributionRate | BRT | MATH_NUMERIC | OPT | BOTH | 
A rate that the system uses to mark up the revenue amount reflected in the billing of professional services such as draftsmen, engineers, or 
  | ||||
| szPayType | PAYT | char | OPT | BOTH | 
A code to define the type of pay, deduction, benefit or accrual.
Pay types are numbered from 1 to 999 Deductions and benefits from 1000 to 
  | ||||
| mnChargeToOriginalAmount | AMTC | MATH_NUMERIC | OPT | BOTH | 
The dollar amount changed from the original dollars budgeted for this Work Order.  | ||||
| mnEstimatedHours | HRSO | MATH_NUMERIC | OPT | BOTH | 
The estimated hours that are budgeted for this work order.  | ||||
| mnChargeToOriginalHours | HRSC | MATH_NUMERIC | OPT | BOTH | 
The number of hours changed to the original hours budgeted.  | ||||
| mnActualAmount | AMTA | MATH_NUMERIC | OPT | BOTH | 
The actual dollars accumulated for the work order.  | ||||
| mnHoursActual | HRSA | MATH_NUMERIC | OPT | BOTH | 
  | ||||
| mnShortItemNumber | ITM | MATH_NUMERIC | OPT | BOTH | 
An inventory item number. The system provides three separate item numbers plus an extensive cross-reference capability to other item 
  | ||||
| sz3rdItemNumber | AITM | char | OPT | BOTH | 
The system provides three separate item numbers plus an extensive cross-reference capability to alternate item numbers. These item 
  | ||||
| sz2ndItemNumber | LITM | char | OPT | BOTH | 
A number that identifies the item. The system provides three separate item numbers plus an extensive cross-reference capability to 
  | ||||
| mnAssetNumber | NUMB | MATH_NUMERIC | OPT | BOTH | 
An 8-digit number that uniquely identifies an asset.  | ||||
| szUnitNumber | APID | char | OPT | BOTH | 
A 12-character alphanumeric code used as an alternate identification number for an asset. This number is not required, nor does the 
  | ||||
| mnQtyOrdered | UORG | MATH_NUMERIC | OPT | BOTH | 
The quantity of units affected by this transaction.  | ||||
| mnQtyBackOrdered | SOBK | MATH_NUMERIC | OPT | BOTH | 
The number of units backordered in Sales Order Management or in Work Order Processing, using either the entered or the primary unit of 
  | ||||
| mnQtyCanceled | SOCN | MATH_NUMERIC | OPT | BOTH | 
The number of units canceled in Sales Order or Work Order Processing, using either the entered or the primary unit of measure defined for 
  | ||||
| mnQtyShipped | SOQS | MATH_NUMERIC | OPT | BOTH | 
The number of units committed for shipment in Sales Order Entry, using either the entered or the primary unit of measure defined for this 
  | ||||
| mnQuantityShippedToDate | QTYT | MATH_NUMERIC | OPT | BOTH | 
The number of units which have passed through the Sales Update process. In Workorder Processing, this field identifies the total quantity 
  | ||||
| szUnitOfMeasure | UOM | char | OPT | BOTH | 
A user defined code (00/UM) that indicates the quantity in which to express an inventory item, for example, CS (case) or BX (box).  | ||||
| szMessageNumber | SHNO | char | OPT | BOTH | 
A generic rates and message code (48/SN) that is assigned to a standard note, message, or general narrative explanation. You can use 
  | ||||
| mnBeginTime | PBTM | MATH_NUMERIC | OPT | BOTH | 
A field that is used to enter the beginning time of the operation sequence for the work center operation on the routing.  | ||||
| szTypeOfBill | TBM | char | OPT | BOTH | 
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. 
  | ||||
| szTypeOfRouting | TRT | char | OPT | BOTH | 
A user defined code (40/TR) that indicates the type of routing. You can define different types of routing instructions for different uses.
For 
  | ||||
| cPickListPrinted | SHTY | char | OPT | BOTH | 
A code to designate whether or not the Work Order Pick List has been printed for a Work Order.  If a 1 is in this code, the Work Order Pick 
  | ||||
| cPostingEdit | PEC | char | OPT | BOTH | 
A code that controls G/L posting and account balance updates in the Account Master table (F0901). Valid values are:
Blank
Allows all 
  | ||||
| cVarianceFlag | PPFG | char | OPT | BOTH | 
A 1 in this field indicates that this work order has had work order activity run against it in update mode. A 2 in this field indicates that this work 
  | ||||
| cBillOfMaterialFlag | BM | char | OPT | BOTH | 
This is a code value that will be utilized in the future to specify if a Bill of Material was used to create this order's part list.  | ||||
| cRouteSheetFlag | RTG | char | OPT | BOTH | 
A code to inhibit printing or the routing instructions on the work order.  | ||||
| cFlashMessage | SPRT | char | OPT | BOTH | 
A user defined code (00/WM) that indicates a change in the status of a work order. The system indicates a changed work order with an 
  | ||||
| cFreezeCode | UNCD | char | OPT | BOTH | 
A code that indicates if the line on the order is frozen. MPS/MRP does not suggest changes to frozen orders.  Valid values are:
Y
Yes, freeze 
  | ||||
| cIndentedCode | INDC | char | OPT | BOTH | 
The work description will be indented to the right up to nine spaces.  | ||||
| mnResequenceCode | RESC | MATH_NUMERIC | OPT | BOTH | 
You can use the resequence code to rearrange work items within a cost code.
If you are using a GANTT chart for your planning, your chart 
  | ||||
| mnMilesOrHoursAmount | MOH | MATH_NUMERIC | OPT | BOTH | 
The meter reading, in units such as miles or hours, at which you want to receive a reminder message about an asset. If you use this field, 
  | ||||
| jdTicklerDate | TDT | JDEDATE | OPT | BOTH | 
The date that you want to receive a reminder message about an asset.  | ||||
| mnProjectedBudgetAmount | POU | MATH_NUMERIC | OPT | BOTH | 
The dollar amount (or quantity) required in addition to the budget (original +actual) to complete an item.  | ||||
| mnPercentComplete | PC | MATH_NUMERIC | OPT | BOTH | 
A measurement that identifies the progress being made on an item such as an account, work order, and so on. It is not always a calculated 
  | ||||
| mnLeadtimeLevel | LTLV | MATH_NUMERIC | OPT | BOTH | 
A value that represents the leadtime for an item at its assigned level in the production process, as defined on Plant Manufacturing Data. 
  | ||||
| mnLeadtimeCumulative | LTCM | MATH_NUMERIC | OPT | BOTH | 
The total number of days required to build an item from its lowest level components to the final assembly. The system calculates the value 
  | ||||
| mnUnaccountedHours | CTS1 | MATH_NUMERIC | OPT | BOTH | 
The number of unaccounted direct labor hours associated with a specific operation for a work order.  | ||||
| szLotNumber | LOTN | char | OPT | BOTH | 
A number that identifies a lot or a serial number. A lot is a group of items with similar characteristics.  | ||||
| mnLotPotency | LOTP | MATH_NUMERIC | OPT | BOTH | 
A code that indicates the potency of the lot expressed as a percentage of active or useful material (for example, the percentage of alcohol 
  | ||||
| szLotGrade | LOTG | char | OPT | BOTH | 
A code that indicates the grade of a lot. The grade is used to indicate the quality of the lot. Examples include the following:
   A1   Premium 
  | ||||
| mnCriticalRatioPriority1 | RAT1 | MATH_NUMERIC | OPT | BOTH | 
| mnCriticalRatioPriority2 | RAT2 | MATH_NUMERIC | OPT | BOTH | 
| szDocumentType | DCT | char | OPT | BOTH | 
A user defined code (00/DT) that identifies the origin and purpose of the transaction.  PeopleSoft reserves several prefixes for document 
  | ||||
| cSubledgerInactiveCode | SBLI | char | OPT | BOTH | 
An option that indicates whether a specific subledger is inactive. Examples of inactive subledgers are jobs that are closed, employees 
  | ||||
| szRelatedKeyCompany | RKCO | char | OPT | BOTH | 
The key company that is associated with the document number of the related order.  | ||||
| szBillRevisionLevel | BREV | char | OPT | BOTH | 
A value that indicates the revision level of a bill of material. It is usually used in conjunction with an engineering change notice or 
  | ||||
| szRoutingRevisionLevel | RREV | char | OPT | BOTH | 
A number that indicates the revision level of a routing. It is usually used in conjunction with an engineering change notice or engineering 
  | ||||
| cDrawingChange | DRWC | char | OPT | BOTH | 
A code that indicates whether the engineering change order requires a drawing change. Valid values are:
For World,
   Y Yes, a drawing 
  | ||||
| cRoutingChange | RTCH | char | OPT | BOTH | 
A code that indicates whether the engineering change order requires a change to the routing. Valid values are:
For World,
   Y Yes, a change 
  | ||||
| cNewPartNumberRequired | PNRQ | char | OPT | BOTH | 
A code that indicates whether a new part number is required for an engineering change order. Valid values are:
For World,
   Y Yes, a new 
  | ||||
| szReasonCode | REAS | char | OPT | BOTH | 
A user defined code (40/CR) that indicates the reason for an engineering change order.  | ||||
| szPhase | PHSE | char | OPT | BOTH | 
A user defined code (40/PH) that indicates how the system phases in an engineering change order.  | ||||
| szExistingDisposition | XDSP | char | OPT | OUTPUT | 
A user defined code (40/ED) that identifies the disposition of the existing item affected by the engineering change order.  | ||||
| cBillOfMaterialsChange | BOMC | char | OPT | BOTH | 
A code that indicates whether the engineering change order requires a change to the bill of material. Valid values are:
For World,
   Y Yes, a 
  | ||||
| szUserReservedCode | URCD | char | OPT | BOTH | 
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 | BOTH | 
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 | BOTH | 
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.  | ||||
| mnUserReservedNumber | URAB | MATH_NUMERIC | OPT | BOTH | 
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.  | ||||
| szUserReservedReference | URRF | char | OPT | BOTH | 
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.  | ||||
| mnParentNumber | AAID | MATH_NUMERIC | OPT | BOTH | 
A parent number groups related components together. You can associate each item of property and piece of equipment with a parent item. 
  | ||||
| szNextStatus | NTST | char | OPT | BOTH | 
The next status for a work order, according to the work order activity rules,as the work order moves through the approval route.
You must 
  | ||||
| mnCriticality | XRTO | MATH_NUMERIC | OPT | BOTH | 
The criticality of a work order.  | ||||
| mnEstimatedDowntimeHours | ESDN | MATH_NUMERIC | OPT | BOTH | 
This is the estimated duration of a work order. It defines how long the piece of equipment will be down in order to complete the work order, 
  | ||||
| mnActualDowntimeHours | ACDN | MATH_NUMERIC | OPT | BOTH | 
This is the actual duration of a work order. It defines how long the piece of equipment was down in order to complete the work order, which 
  | ||||
| mnServiceAddressNumber | SAID | MATH_NUMERIC | OPT | BOTH | 
A unique numeric identifier for a physical location at which utility service is delivered.  A service address often corresponds to a parcel of 
  | ||||
| mnMeterPosition | MPOS | MATH_NUMERIC | OPT | BOTH | 
A slot, either physical or figurative, into which a meter may be placed in order to measure consumption of a utility service.  A meter position 
  | ||||
| mnEstimatedLaborAmount | AMLC | MATH_NUMERIC | OPT | BOTH | 
This is the estimated labor cost of a work order.  | ||||
| szApprovalType | APRT | char | OPT | BOTH | 
A user defined code (system 48, type AP) indicating the type of work order approval path that a work order follows. You can use processing 
  | ||||
| mnEstimatedMaterialAmount | AMMC | MATH_NUMERIC | OPT | BOTH | 
This is the estimated material cost of a work order.  | ||||
| mnEstimatedOtherAmount | AMOT | MATH_NUMERIC | OPT | BOTH | 
Amount - Estimated Other.  | ||||
| mnActualLaborAmount | LBAM | MATH_NUMERIC | OPT | BOTH | 
The actual cost of labor that is associated with a task.  | ||||
| mnActualMaterialAmount | MTAM | MATH_NUMERIC | OPT | BOTH | 
The actual cost of materials that is associated with a task.  | ||||
| szItemNumberUnknownFormat | UITM | char | OPT | BOTH | 
A number that the system assigns to an item. It can be in short, long, or third item number format.  | ||||
| szItemNumberDescription1 | DL01 | char | OPT | BOTH | 
  | ||||
| szItemNumberDescription2 | DL02 | char | OPT | BOTH | 
Additional text that further describes or clarifies a field in the system.  | ||||
| mnQtyWithShrinkage | UORG | MATH_NUMERIC | OPT | BOTH | 
The quantity of units affected by this transaction.  | ||||
| cStockingType | STKT | char | OPT | BOTH | 
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 
  | ||||
| szPrimaryAssetNumber | ASII | char | OPT | BOTH | 
An identification code that represents an asset. You enter the identification code in one of the following formats:
1
Asset number (a 
  | ||||
| szMaintenancePercentComplete | VC04A | char | OPT | BOTH | 
This is a generic field used as a work field in Everest.  | ||||
| mnKitMasterLineNumber | EV03 | char | OPT | BOTH | 
A radio button that specifies the level at which trace/track result is to be displayed.  Select the Detail to display all transactions except IB, IX, 
  | ||||
| mnLineNumberKitMaster | KTLN | MATH_NUMERIC | OPT | BOTH | 
This line number indicates the relative sequence in which a component is added to a kit or single level bill of materials. For example, the 
  | ||||
| szLineIdentifier | LINE | char | OPT | BOTH | 
A number that defines a production line or cell. Detailed work center operations can be defined inside the line or cell.  | ||||
| szCostMethod | LEDG | char | OPT | BOTH | 
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 
  | ||||
| cInventoryCostLevel | EV01 | char | OPT | BOTH | 
An option that specifies the type of processing for an event.  | ||||
| mnUnacctDirectLbrAmt | CTS4 | MATH_NUMERIC | OPT | BOTH | 
The amount of unaccounted direct labor associated with a specific operation for a work order.  | ||||
| mnUnacctScrapAmt | CTS7 | MATH_NUMERIC | OPT | BOTH | 
The amount of unaccounted scrap dollars associated with a specific component for a work order.  Manufacturing accounting uses this 
  | ||||
| mnUnacctScrapUnits | CTS8 | MATH_NUMERIC | OPT | BOTH | 
The number of units of unaccounted scrap that the system associates with a specific component for a work order.  Manufacturing 
  | ||||
| mnSecondaryOrderQty | UOM2 | char | OPT | BOTH | 
A user defined code (00/UM) that indicates an alternate unit of measure for the item.  | ||||
| szSecondaryUnitOfMeasure | SSOQ | MATH_NUMERIC | OPT | BOTH | 
The number of units that have been completed, expressed in the secondary unit of measure.  | ||||
| mnProjectNumber | PRJM | MATH_NUMERIC | OPT | BOTH | 
A number that identifies an EPM project in the system. The project must be set up in the Add/Revise Project program (P31P011).  | ||||
| mnTaskID | 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, 
  | ||||
| mnSequenceNumber2 | SEQN | MATH_NUMERIC | OPT | NONE | 
A number used to organize the table into a logical group for online viewing and reporting.  | ||||
| szDrawingNumber | DRAW | char | OPT | NONE | 
  | ||||
| mnBubbleSequence | BSEQ | MATH_NUMERIC | OPT | NONE | 
A secondary bill of material sequence number that indicates the drawing bubble number.  | ||||
| cResourcesAssigned | TRAF | char | OPT | NONE | 
A code that indicates whether a resource has been assigned to a work order through the Resource Assignment program (P48331). You 
  | ||||
| cChangesToPartsAndRoutings | MPRC | char | OPT | NONE | 
This field states if changes to a work order parts list and routing instructions are allowed. If this field is set to 0, then changes are allowed.  | ||||
| cProductionCostsExist | MPCE | char | OPT | NONE | 
This field states whether or not the production cost data exists. If this field is set to 1, then the production costs exist in the Production Cost 
  | ||||
| cShipThisPhase | SHPP | char | OPT | NONE | 
An option that specifies whether the system can generate a sales order line for a project task. Project Requirements Planning uses this 
  | ||||
| cDirectProjectRelationship | PRRP | char | OPT | NONE | 
A code that specifies whether work orders are directly attached to the work breakdown structure (WBS) for a project. Valid values are:
0
The 
  | ||||
| cAlertSensitiveTask | ALSE | char | OPT | NONE | 
A code that specifies whether the system sends alerts. Alerts are messages that inform you that an exception to a business process has 
  | ||||
| cChargeCosttoProjectAccount | CHPR | char | OPT | NONE | 
A code that specifies whether the system charges the work order costs to the project account rather than to a finished goods account. Valid 
  | ||||
| szAccountId | AID | char | OPT | NONE | 
A number that the system assigns to each general ledger account in the Account Master table (F0901) to uniquely identify it.  | ||||
| mnActualSpecialAmount | ACSA | MATH_NUMERIC | OPT | NONE | 
The user-defined special amount for this task which is retrieved from the General Ledger when actual costs are reported.  | ||||
| mnActualSpecialUnits | ACSU | MATH_NUMERIC | OPT | NONE | 
The user-defined special units for this task, which are retrieved from the general ledger when actual units are reported.  | ||||
| mnAmountActualOther | OTAM | MATH_NUMERIC | OPT | NONE | 
The actual other cost associated with a work order.  | ||||
| jdDateActualToStart | ATST | JDEDATE | OPT | NONE | 
The date when the item or line of work was actually started.  | ||||
| jdDateOther5J | D5J | JDEDATE | OPT | NONE | 
Enter a date that relates to a project or job in this field. Use the information for reporting purposes. This date is user defined.  | ||||
| jdDateOther6J | D6J | JDEDATE | OPT | NONE | 
Enter a date that relates to a project or job in this field. Use the information for reporting purposes. This date is user defined.  | ||||
| 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 
  | ||||
| szSerialTagNumber | ASID | char | OPT | NONE | 
A 25-character alphanumeric number that you can use as an alternate asset identification number. You might use this number to track 
  | ||||
| mnOriginalAmountCommitted | OACM | MATH_NUMERIC | OPT | NONE | 
The original amount committed to inventory for a project work order.  | ||||
| mnRemainingAmountCommitted | RACM | MATH_NUMERIC | OPT | NONE | 
The remaining amount committed to inventory for a project work order.  | ||||
| cChargeToProject | EV01 | char | OPT | NONE | 
An option that specifies the type of processing for an event.  | ||||
| szBusinessUnitSubsequent | MCUS | char | OPT | NONE | 
Either a subsequent business unit or a project number.
A subsequent business unit specifies where to charge costs (or revenues) when the 
  | ||||
| cMSProjectUtilized | EV01 | char | OPT | NONE | 
An option that specifies the type of processing for an event.  | ||||
| mnComponentIDNumber | CFGCID | MATH_NUMERIC | OPT | NONE | 
A number that represents a component in a configuration. This number, which is generated by next numbers, always restarts at 1 and 
  | ||||
| mnConfigurationIDNumber | CFGID | MATH_NUMERIC | OPT | NONE | 
An identifier that represents a unique configuration. It is generated by a next number value and is the key to the configuration tables.  | ||||
| szISSUE | ISSUE | char | OPT | BOTH | 
A description of the customer issue.  | ||||
| szProductModel | PRODM | char | OPT | BOTH | 
A code that classifies an inventory item into a model for customer service. Some examples include: Laser Printer, Inkjet or Fax.  | ||||
| szContactName2 | WHO2 | char | OPT | BOTH | 
The name of the caller, customer, or other contact.  | ||||
| szPhoneAreaCode1 | AR1 | char | OPT | BOTH | 
The first segment of a telephone number. In the United States, the prefix is the three-digit area code.  | ||||
| szPhoneNumberOne | PHN1 | char | OPT | BOTH | 
| mnTimeCompleted | TMCO | MATH_NUMERIC | OPT | BOTH | 
The time the task was completed.  | ||||
| cMethodofPricing | MTHPR | char | OPT | BOTH | 
A code used to determine if this type of service should be priced based on a flat rate or based on actual time and materials.
Valid values 
  | ||||
| szEntitlementCheck | ENTCK | char | OPT | BOTH | 
A user defined code (17/ER) to indicate the results of an entitlement check.
Valid values are:
   0   Not entitled
   1   Transaction entitled
   2   
  | ||||
| cPaymentInstrumentA | RYIN | char | OPT | BOTH | 
The user defined code (00/PY) that specifies how payments are made by the customer. For example:
C
Check  
D
Draft  
T
Electronic funds 
  | ||||
| mnResponseTime | RSTM | MATH_NUMERIC | OPT | BOTH | 
The guaranteed time during which service will be completed, as provided by a service contract, from the time that a provider logs a 
  | ||||
| szCountry | CTR | char | OPT | BOTH | 
A user defined code (00/CN) that identifies a country. The country code has no effect on currency conversion.
The Address Book system 
  | ||||
| szGeographicRegion | REGION | char | OPT | BOTH | 
The geographic region of the customer.  | ||||
| szTaxArea1 | TXA1 | char | OPT | BOTH | 
A code that identifies a tax or geographic area that has common tax rates and tax authorities. The system validates the code you enter 
  | ||||
| szTaxExplanationCode1 | EXR1 | char | OPT | BOTH | 
A hard-coded user defined code (00/EX) that controls the algorithm that the system uses to calculate tax and G/L distribution amounts. The 
  | ||||
| szLanguagePreference | LNGP | char | OPT | BOTH | 
A user defined code (01/LP) that specifies the language to use on forms and printed reports. Before you specify a language, a code for that 
  | ||||
| szGLCategoryCovered | GLCCV | char | OPT | BOTH | 
A user defined code (41/9) that identifies the G/L Offset to use when the system is searching for the account to which it will post the covered 
  | ||||
| szGLCategoryNonCovered | GLCNC | char | OPT | BOTH | 
A user defined code (41/9) that identifies the G/L Offset to use when the system is searching for the account to which it will post the 
  | ||||
| szCoverageGroup | COVGR | char | OPT | BOTH | 
A user defined code that specifies the Coverage Group. The Coverage Group consists of unlimited cost codes and the percentage 
  | ||||
| szPriceAdjustScheduleFour | ASN4 | char | OPT | BOTH | 
A user defined code (40/AS) identifying a price and adjustment schedule. A price and adjustment schedule contains one or more 
  | ||||
| szPriceAdjustScheduleServi | ASN2 | char | OPT | BOTH | 
This user defined code (40/AS) identifies a price and adjustment schedule. A price and adjustment schedule contains one or more 
  | ||||
| mnTimeScheduledStartHHMMSS | SEST | MATH_NUMERIC | OPT | BOTH | 
The time of day that an activity is scheduled to begin. The start time is calculated by the constraints based planning system.  | ||||
| mnTimeScheduledEndHHMMSS | SEET | MATH_NUMERIC | OPT | BOTH | 
The time of day that an activity is scheduled to end. The end time is calculated by the constraints-based planning system.  | ||||
| szDaylightSavingsRuleName | DSAVNAME | char | OPT | BOTH | 
Unique name identifying a daylight savings rule. Use daylight savings rules to adjust time for a geographic and political locale.  | ||||
| szTimeZoes | TIMEZONES | char | OPT | BOTH | 
Choose the time zone for which you want to view the date and time.  | ||||
| szProductFamily | PRODF | char | OPT | BOTH | 
A code that classifies an inventory item into a group for customer service. Some examples include: Laser Printer, Inkjet, or Fax.  | ||||
| mnCausalPart | CSLPRT | MATH_NUMERIC | OPT | BOTH | 
The item number that indicates which part failed and caused the equipment failure.  | ||||
| szCostCenterCsl | MCUCSL | char | OPT | BOTH | 
The business unit that is related to the causal portion of the claim.  | ||||
| szVendorLotNumber | RLOT | char | OPT | BOTH | 
The supplier's lot number for the item.  | ||||
| szFailureCode | FAILCD | char | OPT | BOTH | 
A user defined code (17/FC) that indicates the type of defect.  | ||||
| jdFailureDate | FAILDT | JDEDATE | OPT | BOTH | 
The date of the equipment failure.  | ||||
| mnFailureTime | FAILTM | MATH_NUMERIC | OPT | BOTH | 
The time of the equipment failure.  | ||||
| mnRepairTime | REPTM | MATH_NUMERIC | OPT | BOTH | 
The time that the equipment was repaired.  | ||||
| jdRepairDate | REPDT | JDEDATE | OPT | BOTH | 
The date that the equipment was repaired.  | ||||
| mnPrimaryLastVendorNo | VEND | MATH_NUMERIC | OPT | BOTH | 
  | ||||
| mnAssessorNumber | AN8AS | MATH_NUMERIC | OPT | BOTH | 
The address book number that identifies the assessor.  | ||||
| mnSupplierRecoveryManagerN | AN8SRM | MATH_NUMERIC | OPT | BOTH | 
The address book number that identifies the supplier recovery manager.  | ||||
| mnSupplierRecoveryManagerN_2 | AN8SRM | MATH_NUMERIC | OPT | BOTH | 
The address book number that identifies the supplier recovery manager.  | ||||
| cEligibleSupplierRecovery | SRYN | char | OPT | BOTH | 
A code that specifies whether a work order or a warranty claim is eligible as a source for a supplier recovery claim.  | ||||
| szEntitlementCheckSupplier | ENTCKS | char | OPT | BOTH | 
For future use.  | ||||
| mnCurrentBalanceMeter1 | CURBALM1 | MATH_NUMERIC | OPT | BOTH | 
The current balance of meter 1.  | ||||
| mnCurrentBalanceMeter2 | CURBALM2 | MATH_NUMERIC | OPT | BOTH | 
The current balance of meter 2.  | ||||
| mnCurrentBalanceMeter3 | CURBALM3 | MATH_NUMERIC | OPT | BOTH | 
The current balance that appears on meter 3.  | ||||
| szCurrencyCodeTo | CRDC | char | OPT | BOTH | 
A code that identifies the domestic (base) currency of the company on a transaction.  | ||||
| szCurrencyCodeFrom | CRCD | char | OPT | BOTH | 
A code that identifies the currency of a transaction.  | ||||
| cCurrencyMode | CRRM | char | OPT | BOTH | 
An option that specifies whether the system displays amounts in the domestic or foreign currency.
On 
The system displays amounts in the 
  | ||||
| mnCurrencyConverRateOv | CRR | MATH_NUMERIC | OPT | BOTH | 
A number (exchange rate) that a foreign currency amount is multiplied by to calculate a domestic currency amount. 
The number in this field 
  | ||||
| mnCumPlannedMaterial | MATH01 | MATH_NUMERIC | OPT | BOTH | 
- - - Good Performance Low Value.  | ||||
| mnCumPlannedLabor | MATH01 | MATH_NUMERIC | OPT | BOTH | 
- - - Good Performance Low Value.  | ||||
| mnCumPlannedOther | MATH01 | MATH_NUMERIC | OPT | BOTH | 
- - - Good Performance Low Value.  | ||||
| mnCumPlannedSpecialAmount | MATH01 | MATH_NUMERIC | OPT | BOTH | 
- - - Good Performance Low Value.  | ||||
| mnCumPlannedSpecialUnits | MATH01 | MATH_NUMERIC | OPT | BOTH | 
- - - Good Performance Low Value.  | ||||
| mnCumEstimatedMaterial | MATH01 | MATH_NUMERIC | OPT | BOTH | 
- - - Good Performance Low Value.  | ||||
| mnCumEstimatedLabor | MATH01 | MATH_NUMERIC | OPT | BOTH | 
- - - Good Performance Low Value.  | ||||
| mnCumEstimatedOther | MATH01 | MATH_NUMERIC | OPT | BOTH | 
- - - Good Performance Low Value.  | ||||
| mnCumEstimatedSpecialAmount | MATH01 | MATH_NUMERIC | OPT | BOTH | 
- - - Good Performance Low Value.  | ||||
| mnCumEstimatedSpecialUnit | MATH01 | MATH_NUMERIC | OPT | BOTH | 
- - - Good Performance Low Value.  | ||||
| mnCumTotalPlanned | MATH01 | MATH_NUMERIC | OPT | BOTH | 
- - - Good Performance Low Value.  | ||||
| mnCumTotalEstimated | MATH01 | MATH_NUMERIC | OPT | BOTH | 
- - - Good Performance Low Value.  | ||||
| mnCumBudgetedCost | MATH01 | MATH_NUMERIC | OPT | BOTH | 
- - - Good Performance Low Value.  | ||||
| cCacheRecordIsUpdatedFlag | EV01 | char | OPT | BOTH | 
An option that specifies the type of processing for an event.  | ||||
| mnCumActualMaterial | MATH01 | MATH_NUMERIC | OPT | BOTH | 
- - - Good Performance Low Value.  | ||||
| mnCumActualLabor | MATH01 | MATH_NUMERIC | OPT | BOTH | 
- - - Good Performance Low Value.  | ||||
| mnCumActualOther | MATH01 | MATH_NUMERIC | OPT | BOTH | 
- - - Good Performance Low Value.  | ||||
| mnCumActualSpecialAmount | MATH01 | MATH_NUMERIC | OPT | BOTH | 
- - - Good Performance Low Value.  | ||||
| mnCumActualSpecialUnits | MATH01 | MATH_NUMERIC | OPT | BOTH | 
- - - Good Performance Low Value.  | ||||
| szPromotionID | PMTN | char | OPT | BOTH | 
An identification number that tracks revenue, costs, and expenses for each promotion.  | ||||
| mnDocVoucherInvoiceE | DOC | MATH_NUMERIC | OPT | BOTH | 
A number that identifies the original document, such as a voucher, invoice, or journal entry. On entry forms, you can assign the document 
  | ||||
| szCompanyKey | KCO | char | OPT | BOTH | 
A number that, with the document number, document type and G/L date, uniquely identifies an original document, such as invoice, voucher, 
  | ||||
| szContractChangeNum | COCH | char | OPT | BOTH | 
The change number of the contract. The change order number of the base contract is always initialized to 000. Each time you enter a 
  | ||||
| mnmnContractLineNumber | LNID | MATH_NUMERIC | OPT | BOTH | 
A number that identifies multiple occurrences, such as line numbers on a purchase order or other document. Generally, the system assigns 
  | ||||
| szCreatedByUser | CRTU | char | OPT | BOTH | 
The address book number of the user who created this record.  | ||||
| cSecondCall | SCALL | char | OPT | BOTH | 
A code that specifies multiple callbacks for a maintenance request. Enter a value from UDC 17/CB.  | ||||
| cReimbursementMethod | RMTHD | char | OPT | BOTH | 
An option that specifies how a dealer is reimbursed for a claim or how a claim is paid by a supplier. For example, dealers can request 
  | ||||
| szCompCodeSystemAssembly33 | VMRS33 | char | OPT | BOTH | 
A user defined code (17/C8) that indicates the location of a specific part, such as the fuse to the air conditioning compressor clutch,  within a 
  | ||||
| mnIssueNumber | ISNO | MATH_NUMERIC | OPT | BOTH | 
A number that identifies a customer issue.  | ||||
| cSerializedcomponents | SRCN | char | OPT | NONE | 
This flag indicates if a production order has serialized components. If this flag is on 1, the completions program will associate the serialized 
  | ||||
| cTaskType | TSKTP | char | OPT | NONE | 
A value that indicates the type of task for scheduling. Valid values are: Blank Non-Fixed (Default) 1 Fixed Task 2 Fixed Structure  | ||||
| cBillingFlag | BILLA | char | OPT | NONE | 
A value that indicates that a task is billable.  Only billable tasks appear on Project Quote.  If a parent task is marked billable, children tasks 
  | ||||
| cETOLevelOfDetail | LODL | char | OPT | NONE | 
A system generated value based on the task hierarchy that indicates how costs would be rolled up when creating quotes.  The functionality 
  | ||||
| nETOBillableChildren | BILLC | integer | OPT | NONE | 
A counter that tracks the number of child tasks for a given task that has been marked billable.  | ||||
| None | 
| None |