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 |