D31P0020 - Cache Process Quote Detail
Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
---|---|---|---|---|
cSuppressErrorMessage | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event. | ||||
szErrorMessageID | DTAI | char | OPT | NONE |
A code that identifies and defines a unit of information. It is an alphanumeric code up to 8 characters long that does not allow blanks or
| ||||
idCacheCursor | GENLNG | ID | OPT | NONE |
General purpose ID variable. | ||||
mnJobNumber | JOBS | MATH_NUMERIC | OPT | NONE |
The job number (work station ID) which executed the particular job. | ||||
cProcessMode | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event. | ||||
cCacheCodeError | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event. | ||||
cReturnCursorFlag | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event. | ||||
mnProjectNumber | PRJM | MATH_NUMERIC | OPT | NONE |
A number that identifies an EPM project in the system. The project must be set up in the Add/Revise Project program (P31P011). | ||||
szQuoteVersion | QVER | char | OPT | NONE |
This field holds a number that uniquely identifies a quote version. During quote calculation, the system creates many quote versions, but it
| ||||
mnSequenceNumber | SEQN | MATH_NUMERIC | OPT | NONE |
A number used to organize the table into a logical group for online viewing and reporting. | ||||
mnOrderNumber | 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,
| ||||
szOrderType | DCTO | char | OPT | NONE |
A user defined code (00/DT) that identifies the type of document. This code also indicates the origin of the transaction. J.D. Edwards has
| ||||
szParentWoNumber | PARS | char | OPT | NONE |
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,
| ||||
szCostType | COST | char | OPT | NONE |
A code that designates each element of cost for an item. Examples of the cost object types are:
o A1 Purchased raw material
o B1
| ||||
mnEstimatedSpecialAmount | ESSA | MATH_NUMERIC | OPT | NONE |
The approximate amount of special costs associated with a task prior to quote acceptance. | ||||
mnEstimatedSpecialUnits | ESSU | MATH_NUMERIC | OPT | NONE |
The approximate number of special units associated with a task prior to quote acceptance. | ||||
mnEstimatedAmount | EAQT | MATH_NUMERIC | OPT | NONE |
The estimated amount that the system uses to budget for a project phase or task. | ||||
mnEstimatedOverride | EOQT | MATH_NUMERIC | OPT | NONE |
An amount that the system budgets for a project phase or task. You complete this field if you want the system to use the estimated amount
| ||||
mnMarginPercent | MRG3 | MATH_NUMERIC | OPT | NONE |
The system uses the margin percent in the calculation of the quote amount. The quote amount calculation is the estimated amount
| ||||
mnQuoteAmount | QAMT | MATH_NUMERIC | OPT | NONE |
The quoted amount of a task or a project. | ||||
mnForeignEstimatedAmount | EFAM | MATH_NUMERIC | OPT | NONE |
An amount, expressed in a foreign currency based on the quote exchange rate, that the system budgets for a project phase or task. This
| ||||
mnForeignEstimatedOverride | EFAO | MATH_NUMERIC | OPT | NONE |
An amount, expressed in a foreign currency based on the quote exchange rate, that the system budgets for a project phase or task.
| ||||
mnForeignExtendedCost | FEC | MATH_NUMERIC | OPT | NONE |
The product of the cost of an item, expressed in foreign currency according to the orders exchange rate, times the number of units. | ||||
mnForeignSpecialAmount | ESFA | MATH_NUMERIC | OPT | NONE |
A special amount, expressed in a foreign currency based on the quote exchange rate, that the system budgets for a project phase or task. | ||||
cLevelofDetail | LDM | char | OPT | NONE |
A code that identifies the relationship of parent and subordinate business units in a hierarchy. Up to nine levels of detail are available.
| ||||
mnItemNumber | ITM | MATH_NUMERIC | OPT | NONE |
An inventory item number. The system provides three separate item numbers plus an extensive cross-reference capability to other item
| ||||
sz2ndItemNumber | LITM | char | OPT | NONE |
A number that identifies the item. The system provides three separate item numbers plus an extensive cross-reference capability to
| ||||
sz3rdItemNumber | AITM | char | OPT | NONE |
The system provides three separate item numbers plus an extensive cross-reference capability to alternate item numbers. These item
| ||||
mnQuantityOrdered | UORG | MATH_NUMERIC | OPT | NONE |
The quantity of units affected by this transaction. | ||||
szBranchPlant | MMCU | char | OPT | NONE |
A code that represents a high-level business unit. Use this code to refer to a branch or plant that might have departments or jobs, which
| ||||
szUnitofMeasure | UOM | char | OPT | NONE |
A user defined code (00/UM) that indicates the quantity in which to express an inventory item, for example, CS (case) or BX (box). | ||||
cShipPhase | 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
| ||||
cSelectedforQuote | SQCF | char | OPT | NONE |
A code that indicates whether the system includes a row in the price calculation in the Quote Generation program. Valid values are:
Blank
| ||||
mnRelatedLineNumber | RLLN | MATH_NUMERIC | OPT | NONE |
A number of the detail line on the related order for which the current order was created. For example, on a purchase order created to fill
| ||||
jdStartDate | STRT | JDEDATE | OPT | NONE |
The start date for the order. You can enter this date manually, or have the system calculate it using a backscheduling routine. The routine
| ||||
jdRequestDate | DRQJ | JDEDATE | OPT | NONE |
The date that an item is scheduled to arrive or that an action is scheduled for completion. | ||||
szUserReservedCode | URCD | char | OPT | NONE |
This is a 2 position code that is reserved for the user. JDE does not currently use this field and will not utilize this field in the future. | ||||
jdUserReservedDate | URDT | JDEDATE | OPT | NONE |
This is a 6 position code that is reserved for the user. JDE does not currently use this field and will not utilize this field in the future. | ||||
mnUserReservedAmount | URAT | MATH_NUMERIC | OPT | NONE |
This is a 15 position code that is reserved for the user. JDE does not currently use this field and will not utilize this field in the future. | ||||
mnUserReservedNumber | URAB | MATH_NUMERIC | OPT | NONE |
This is a 8 position code that is reserved for the user. JDE does not currently use this field and will not utilize this field in the future. | ||||
szUserReservedReference | URRF | char | OPT | NONE |
A 15-position reference that is reserved for the user. J.D. Edwards does not currently use this field and does not plan to use it in the future. | ||||
szUserId | USER | char | OPT | NONE |
The code that identifies a user profile. | ||||
szProgramId | PID | char | OPT | NONE |
The number that identifies the batch or interactive program (batch or interactive object). For example, the number of the Sales Order Entry
| ||||
jdDateUpdated | UPMJ | JDEDATE | OPT | NONE |
The date that specifies the last update to the file record. | ||||
mnTimeUpdated | TDAY | MATH_NUMERIC | OPT | NONE |
The computer clock in hours:minutes:seconds. | ||||
szWorkStationId | JOBN | char | OPT | NONE |
The code that identifies the work station ID that executed a particular job. | ||||
nNumberKeys | INT01 | integer | OPT | NONE |
Number of Days in Future to Query for Responses Due. | ||||
szOrderDescription | DL01 | char | OPT | NONE |
A user defined name or remark. | ||||
cSelectedForDisplay | SQDF | char | OPT | NONE |
A code that specifies whether the system displays a row with a calculated price in the EPM - Online Proposals program (P31P101) and
| ||||
cNoChildFlag | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event. | ||||
nIndexNumber | INT01 | integer | OPT | NONE |
Number of Days in Future to Query for Responses Due. | ||||
mnForeignQuoteAmt | EFQA | MATH_NUMERIC | OPT | NONE |
An amount, expressed in a foreign currency based on the quote exchange rate, that represents the quote for a project phase or task. | ||||
mnTotalQuoteAmount | QAMT | MATH_NUMERIC | OPT | NONE |
The quoted amount of a task or a project. | ||||
szRelatedPoSoNumber | RORN | char | OPT | NONE |
A number that identifies a secondary purchase order, sales order, or work order that is associated with the original order. This number is for
| ||||
szRelatedOrderType | RCTO | char | OPT | NONE |
A user defined code (system 00, type DT) that indicates the document type of the secondary or related order. For example, a purchase
| ||||
szCompanyKeyRelated | RKCO | char | OPT | NONE |
The key company that is associated with the document number of the related order. | ||||
mnTotalEstimatedAmount | MATH01 | MATH_NUMERIC | OPT | NONE |
- - - Good Performance Low Value. | ||||
mnForeignTotalEstimatedAmount | MATH01 | MATH_NUMERIC | OPT | NONE |
- - - Good Performance Low Value. |
None |
None |