CalculateBestAmount

Calculate Best Amount

Minor Business Rule

Object Name: N5300006

Parent DLL: CAEC

Location: Client/Server

Language: NER

Functional Description

This program will automatically calculate the BEST amount for a change request detail line item record for Cost,
Revenue or Subcontract record types.

Best Amount is calculated as follows:

If a detail line item for either Cost, Revenue, or Subcontract has a final amount then the final amount is the best amount.
If a detail line item for either Cost, Revenue, or Subcontract has no final amount but has a quoted amount, then the
quoted amount is the best amount.
If a detail line item for either Cost, Revenue, or Subcontract has no final amount, no quoted amount but has an original
amount, then the original amount is the best amount.

Example:

Original amount:$ 1500
Quoted amount:    2500
Final amount:    2125
Best amount:    2125

Original amount:$ 1500
Quoted amount:    2500
Final amount:           0
Best amount:    2500

Original amount:    1500
Quoted amount:                0
Final amount:                     0
Best amount:    1500

Data Structure

D5300006 - Calculate Best Amount

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
szCostCenter	MCU	char	OPT	NONE
An alphanumeric code that identifies a separate entity within a business for which you want to track costs. For example, a business unit might be a warehouse location, job, project, work center, branch, or plant. You can assign a business unit to a document, entity, or person for purposes of responsibility reporting. For example, the system provides reports of open accounts payable and accounts receivable by business unit to track equipment by responsible department. Business unit security might prevent you from viewing information about business units for which you have no authority.
mnChangeOrderNumber	CONO	MATH_NUMERIC	OPT	NONE
The number assigned to the change request for a particular job.
mnLastRequoteNumber	REQB	MATH_NUMERIC	OPT	NONE
The last requote number for the change request. A requote is a snapshot of the change request at a particular point in time. You can create requotes when you change the information for a change request, such as when you change statuses or amounts. Requotes provide a record of the changes leading up to the current information for the change request.
mnLineNumber	LNID	MATH_NUMERIC	OPT	NONE
A number that identifies multiple occurrences, such as line numbers on a purchase order or other document. Generally, the system assigns this number,but in some cases you can override it.
szStatusCodeCost	SCOS	char	OPT	NONE
A user defined code (53/ST) that specifies the status of a cost change request for a selected job and line item. The system uses this code in the approval process of the change request, and determines which ledger type is updated in the Account Balances table (F0902).
szStatusCodeRevenue	SREV	char	OPT	NONE
A user defined code (53/ST) that specifies the status of a revenue change request for a selected job and line item. The system uses this code in the approval process of the change request, and determines which ledger type is updated in the Account Balances table (F0902).
szStatusCodeSubcontract	SSUB	char	OPT	NONE
A user defined code (53/ST) that specifies the status of a subcontract change request for a selected job and line item. The system uses this code in the approval process of the change request, and determines which ledger type is updated in the Account Balances table (F0902).
mnAmountOriginalCost	COAM	MATH_NUMERIC	OPT	NONE
The original amount for a cost change request detail item.
mnAmountOriginalRevenue	ROAM	MATH_NUMERIC	OPT	NONE
The original amount for a revenue change request detail item.
mnAmountOriginalSubcontract	SOAM	MATH_NUMERIC	OPT	NONE
The original amount for a subcontract change request detail item.
mnAmountQuotedCost9	CQAM	MATH_NUMERIC	OPT	NONE
The quoted amount for a detail item for a request for a cost change.
mnAmountQuotedRevenue9	RQAM	MATH_NUMERIC	OPT	NONE
The quoted revenue amount for a line item in the change request.
mnAmountQuotedSubcontract9	SQAM	MATH_NUMERIC	OPT	NONE
The quoted subcontract amount for a line item in the change request.
mnAmountFinalCost	CFAM	MATH_NUMERIC	OPT	NONE
The final amount for a detail item for a request for a cost change.
mnAmountFinalRevenue	FRAM	MATH_NUMERIC	OPT	NONE
The final revenue amount for a line item in the change request.
mnAmountFinalSubcontract	SFAM	MATH_NUMERIC	OPT	NONE
The final subcontract amount for a line item in the change request.
mnAmountBestCost	BCAM	MATH_NUMERIC	OPT	NONE
The best amount for a detail item on a request for a cost change.
mnAmountBestRevenue	BRAM	MATH_NUMERIC	OPT	NONE
The best amount for a detail item on a request for a revenue change.
mnAmountBestSubcontract9	BSAM	MATH_NUMERIC	OPT	NONE
The best amount for a detail item on a request for a subcontract change.
cForceBestToZeroCost	CFB0	char	OPT	NONE
A code that indicates whether the best cost amount for a detail line item for a change request should be zero.
cForceBestToZeroRevenue	RFB0	char	OPT	NONE
A code that indicates whether the best revenue amount for a line item in the change request should be zero.
cForceBestToZeroSubcontract	SFB0	char	OPT	NONE
A code that specifies whether the best subcontract amount for a line item in the change request should be zero.
mnUnitRateOriginalCost	CURO	MATH_NUMERIC	OPT	NONE
The original cost of a unit rate that is associated with a change request detail line item.
mnUnitRateOriginalRevenue	RURO	MATH_NUMERIC	OPT	NONE
The original revenue unit rate associated with a change request detail line item.
mnUnitRateOriginalSubcontract	SURO	MATH_NUMERIC	OPT	NONE
The original subcontract unit rate for a line item in the change request.
mnUnitRateQuotedCost	CURQ	MATH_NUMERIC	OPT	NONE
The quoted cost of a unit rate that is associated with a change request detail line item.
mnUnitRateQuotedRevenue	RURQ	MATH_NUMERIC	OPT	NONE
The quoted revenue unit rate associated with a change request detail line item.
mnUnitRateQuotedSubcontract	SURQ	MATH_NUMERIC	OPT	NONE
The quoted subcontract unit rate for a line item in the change request.
mnUnitRateFinalCost	FURC	MATH_NUMERIC	OPT	NONE
The final cost for a unit rate that is associated with a change request detail line item.
mnUnitRateFinalRevenue	FURR	MATH_NUMERIC	OPT	NONE
The final revenue unit rate for a line item in the change request.
mnUnitRateFinalSubcontract	FURS	MATH_NUMERIC	OPT	NONE
The final subcontract unit rate for a line item in the change request.
mnUnitRateBestCost	BURC	MATH_NUMERIC	OPT	NONE
The best cost for a unit rate that is associated with a change request detail line item.
mnUnitRateBestRevenue	FURB	MATH_NUMERIC	OPT	NONE
The best revenue unit rate that is associated with a change request detail line item.
mnUnitRateBestSubcontract	BURS	MATH_NUMERIC	OPT	NONE
The best subcontract unit rate that is associated with a detail line item for a change request.
mnQuantityOriginalCost	OQTC	MATH_NUMERIC	OPT	NONE
The original cost quantity for a line item in the change request.
mnQuantityOriginalRevenue	RQTO	MATH_NUMERIC	OPT	NONE
The original revenue quantity for a line item in the change request.
mnQuantityOriginalSubcontract	SQTO	MATH_NUMERIC	OPT	NONE
The original subcontract quantity for a line item in the change request.
mnQuantityquotedCost	QQTC	MATH_NUMERIC	OPT	NONE
The quoted quantity associated with a detail line item for a request for a cost change.
mnQuantityQuotedRevenue	RQTQ	MATH_NUMERIC	OPT	NONE
The quoted revenue quantity for a line item in the change request.
mnQuantityQuotedSubcontract	SQTQ	MATH_NUMERIC	OPT	NONE
The quoted subcontract quantity for a line item in the change request.
mnQuantityFinalCost	CQTF	MATH_NUMERIC	OPT	NONE
The final quantity associated with a detail line item for a request for a cost change.
mnQuantityFinalRevenue	RQTF	MATH_NUMERIC	OPT	NONE
The final revenue quantity for a line item in the change request.
mnQuantityFinalSubcontract	SQTF	MATH_NUMERIC	OPT	NONE
The final subcontract quantity for a line item in the change request.
mnQuantityBestCost	CBTF	MATH_NUMERIC	OPT	NONE
The best quantity associated with a detail line item for a request for a cost change.
mnQuantityBestRevenue	RQTB	MATH_NUMERIC	OPT	NONE
The best revenue quantity for a line item in the change request.
mnQuantityBestSubcontract	SQTB	MATH_NUMERIC	OPT	NONE
The best subcontract quantity for a line item in the change request.

Related Functions

None

Related Tables

None