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 |