1.Functional Description
1.1Purpose
The purpose of this business function is to calculate either the foreign and domestic flat rate amount or the foreign and domestic billing rate for the
call or the time entry record attached to the call.
call. This flat rate amount does not include the percentage covered under a contract. If the method of pricing is time and materials (T&M) then it will
use the Advanced Pricing module to determine the foreign and domestic billing rate to charge for the time entry record. This rate does not include the
percentage covered under a contract.
the foreign or domestic flat rate amount is zero and from Time Entry (P17505) whenever the time entry record has not been billed and the foreign or
domestic billing rate is zero.
1.2Setup Notes and Prerequisites
1.3Special Logic
2.Technical Specifications
2.4Processing
//
// If Currency Processing is Off OR the Currency Mode is Domestic
// the Pricing Business Function will be called if the Domestic
// amounts are zero.
//
// Else the Pricing Business Function will be called if the Foreign
// amounts are zero.
//
// ------------------------------------------------------------------------------
//
// Calculate price from Domestic Amounts
//
If SL CurrencyProcessing is equal to "N" Or BF cCurrencyMode_CRRM is equal to "D"
// Pricing Method is Flat Rate - return the Flat Rate Amount & Foreign
// Flat Rate Amount if applicable.
//
If BF cMethodofPricing_MTHPR is equal to "F" And BF jdDateBilled_DTBIL is equal to
mnFlatRateAmount_AMTFD is equal to
//
// Pricing Method isTime & Material - return the Billing Rate &
// Foreign Billing Rate if applicable.
//
If BF cMethodofPricing_MTHPR is equal to "T" And BF jdDateBilled_DTBIL is equal to
mnBillingRate_ARTBD is equal to
// Calculate price from Foreign Amounts
//
// Pricing Method is Flat Rate - return the Flat Rate Amount & Foreign
// Flat Rate Amount.
//
If BF cMethodofPricing_MTHPR is equal to "F" And BF jdDateBilled_DTBIL is equal to
mnForeignFlatRateAmount_AMTFF is equal to
//
// Pricing Method isTime & Material - return the Billing Rate &
// Foreign Billing Rate.
//
If BF cMethodofPricing_MTHPR is equal to "T" And BF jdDateBilled_DTBIL is equal to
mnForeignBillingRate_ARTBF is equal to
D1701750 - Calculate Case Pricing
Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
---|---|---|---|---|
jdDateBilled_DTBIL | DTBIL | JDEDATE | REQ | INPUT |
In service billing, the date a customer was billed for a service. | ||||
cBillableYN_BILL | BILL | char | REQ | INPUT |
Specifies whether a general ledger account should be billed. Valid codes are:
Y Yes, the account should be billed.
N No, it should not be
| ||||
szComputerID_CTID | CTID | char | REQ | INPUT |
mnJobnumber_JOBS | JOBS | MATH_NUMERIC | REQ | INPUT |
The job number (work station ID) which executed the particular job. | ||||
mnCallNumber_DOCO | DOCO | MATH_NUMERIC | REQ | INPUT |
A number that identifies an original document. This document can be a voucher, a sales order, an invoice, unapplied cash, a journal entry,
| ||||
szDocumentType_DCTO | DCTO | char | REQ | INPUT |
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
| ||||
szDocumentCompany_KCOO | KCOO | char | REQ | INPUT |
A number that, along with order number and order type, uniquely identifies an order document (such as a purchase order, a contract, a
| ||||
mnTimeEntryLineNumber_LNID | LNID | MATH_NUMERIC | OPT | INPUT |
A number that identifies multiple occurrences, such as line numbers on a purchase order or other document. Generally, the system assigns
| ||||
szCallAdjustmentSchedule_ASN3 | ASN3 | char | REQ | INPUT |
A user defined code (40/AS) that identifies a price and adjustment schedule. A price and adjustment schedule contains one or more
| ||||
szBaseCompanyCurrency_CRDC | CRDC | char | REQ | INPUT |
A code that identifies the domestic (base) currency of the company on a transaction. | ||||
szCustomerCurrency_CRCD | CRCD | char | OPT | INPUT |
A code that identifies the currency of a transaction. | ||||
cSuppressErrorMessage_SUPPS | SUPPS | char | OPT | INPUT |
A flag indicating whether or not runtime error messaging will occur when an error message is issued from a business function.
0 = allow
| ||||
szErrorMessageID_DTAI | 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
| ||||
mnCustomerNumber_ANC | ANC | MATH_NUMERIC | OPT | INPUT |
Client number in SAR records which corresponds to Address Book record. | ||||
mnSiteNumber_LANO | LANO | MATH_NUMERIC | OPT | INPUT |
The address book number for the lessor, renter, or lending institution. | ||||
szCustomerGroup_CGPC | CGPC | char | OPT | INPUT |
szSiteGroup_CGPC | CGPC | char | OPT | INPUT |
mnAdjustmentRevisionLevel_AREV | AREV | MATH_NUMERIC | OPT | OUTPUT |
This field maintains the current revision level of Advanced Pricing adjustments awarded within a sales order. Adjustments associated with
| ||||
cAdvAdjustmentRevLevel_EV02 | EV02 | char | OPT | OUTPUT |
An option that specifies the type of processing for an event. | ||||
cCurrencyMode_CRRM | CRRM | char | OPT | INPUT |
An option that specifies whether the system displays amounts in the domestic or foreign currency.
On
The system displays amounts in the
| ||||
mnExchangeRate_CRR | CRR | MATH_NUMERIC | OPT | INPUT |
A number (exchange rate) that a foreign currency amount is multiplied by to calculate a domestic currency amount.
The number in this field
| ||||
mnShortItemNumber_ITM | ITM | MATH_NUMERIC | OPT | INPUT |
An inventory item number. The system provides three separate item numbers plus an extensive cross-reference capability to other item
| ||||
szBranchPlant_MMCU | MMCU | char | OPT | INPUT |
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
| ||||
szCompany_CO | CO | char | OPT | INPUT |
A code that identifies a specific organization, fund, or other reporting entity. The company code must already exist in the Company
| ||||
szResponsibleBusinessUnit_MCUZ | MCUZ | char | OPT | INPUT |
Identifies a separate entity within a business for which you wish to track costs, for example, a warehouse location, job, project, work center,
| ||||
szPaymentTermsCode_PTC | PTC | char | OPT | INPUT |
A code that specifies the terms of payment, including the percentage of discount available if the invoice is paid by the discount due date.
| ||||
cPaymentInstrument_RYIN | RYIN | char | OPT | INPUT |
The user defined code (00/PY) that specifies how payments are made by the customer. For example:
C
Check
D
Draft
T
Electronic funds
| ||||
szCountry_CTR | CTR | char | OPT | INPUT |
A user defined code (00/CN) that identifies a country. The country code has no effect on currency conversion.
The Address Book system
| ||||
szProductFamily_PRODF | PRODF | char | OPT | INPUT |
A code that classifies an inventory item into a group for customer service. Some examples include: Laser Printer, Inkjet, or Fax. | ||||
szProductModel_PRODM | PRODM | char | OPT | INPUT |
A code that classifies an inventory item into a model for customer service. Some examples include: Laser Printer, Inkjet or Fax. | ||||
jdPriceEffectiveDate_EFTJ | EFTJ | JDEDATE | OPT | INPUT |
The date when a transaction, contract, obligation, preference, or policy rule becomes effective. | ||||
szServicePackage_SERP | SERP | char | OPT | INPUT |
A combination of service order type and coverage type used to define service support to which the customer is contractually entitled. A
| ||||
cTypeOfService_TYPS | TYPS | char | OPT | INPUT |
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
| ||||
szCostType_COST | COST | char | OPT | INPUT |
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
| ||||
mnCallQueue_CALLQ | CALLQ | MATH_NUMERIC | OPT | INPUT |
The address number of the case provider group. To resolve customer problems, the system or a person can assign case to provider
| ||||
mnServiceProvider_AN8 | AN8 | MATH_NUMERIC | OPT | INPUT |
A number that identifies an entry in the Address Book system, such as employee, applicant, participant, customer, supplier, tenant, or
| ||||
cCallType_CT01 | CT01 | char | OPT | INPUT |
A code that specifies the type of case. | ||||
szCallPriority_PRIOR | PRIOR | char | OPT | INPUT |
The values that indicate the severity of the customer issue. | ||||
szLanguage_LNGP | LNGP | char | OPT | INPUT |
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
| ||||
szEnvironment_ENV | ENV | char | OPT | INPUT |
The operating environment of the user. Some examples include Windows 95, Windows NT, UNIX or AS/400. | ||||
szCallCatCode01_JC01 | JC01 | char | OPT | INPUT |
User defined code associated with the team a customer issue is assigned to. | ||||
szCallCatCode02_JC02 | JC02 | char | OPT | INPUT |
User defined reporting code for assigning customer issues. | ||||
szCallCatCode03_JC03 | JC03 | char | OPT | INPUT |
User defined reporting code used when assigning customer issues. | ||||
szCallCatCode04_JC04 | JC04 | char | OPT | INPUT |
User defined reporting code used when assigning customer issues. | ||||
mnBillableUnits_BLCN | BLCN | MATH_NUMERIC | OPT | INPUT |
In general, this field displays the total billable consumption amount billed for a utility. However, use of this fields varies in the Bill Calculation
| ||||
mnBillableHours_HRBL | HRBL | MATH_NUMERIC | OPT | INPUT |
The number of hours billed. | ||||
mnTotalElapsedHours_TELH | TELH | MATH_NUMERIC | OPT | INPUT |
The total elapsed hours for a particular well test. | ||||
mnUserReservedAmount_URAT | URAT | MATH_NUMERIC | OPT | INPUT |
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. | ||||
mnCommitmentDuration_COMD | COMD | MATH_NUMERIC | OPT | INPUT |
The length of time (stored in minutes as an integer) that was committed to the customer. This length of time is used to set due dates/times
| ||||
szPricingLaborUnitOfMeasure_UM | UM | char | OPT | INPUT |
A user defined code (00/UM) that identifies the unit of measurement for an amount or quantity. For example, it can represent a barrel, box,
| ||||
mnFlatRateAmount_AMTFD | AMTFD | MATH_NUMERIC | OPT | BOTH |
The monetary amount charged to the customer regardless of how many hours were spent or how many parts were used in performing the
| ||||
mnForeignFlatRateAmount_AMTFF | AMTFF | MATH_NUMERIC | OPT | BOTH |
The monetary amount charged to the customer regardless of how many hours were spent or how many parts were used in performing the
| ||||
mnBillingRate_ARTBD | ARTBD | MATH_NUMERIC | OPT | BOTH |
The billing rate that the system uses when calculating the billable amount.
The billing rate is expressed in the currency that is set up for the
| ||||
mnForeignBillingRate_ARTBF | ARTBF | MATH_NUMERIC | OPT | BOTH |
The billing rate that the system uses when calculating the billable amount.
The billing rate is expressed in the currency that is set up for the
| ||||
szLocation_LOCN | LOCN | char | OPT | INPUT |
The storage location from which goods will be moved. | ||||
szLot_LOTN | LOTN | char | OPT | INPUT |
A number that identifies a lot or a serial number. A lot is a group of items with similar characteristics. | ||||
cMethodofPricing_MTHPR | MTHPR | char | OPT | INPUT |
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
| ||||
mnTriangulationRate1_TRR1 | TRR1 | MATH_NUMERIC | OPT | INPUT |
The triangulation currency rate used to convert the From currency code to the Triangulation currency code. | ||||
mnTriangulationRate2_TRR2 | TRR2 | MATH_NUMERIC | OPT | INPUT |
The triangulation currency rate that used to convert from the Triangulation currency code to the To currency code. | ||||
cCurrencyConversionMethod_CRCM | CRCM | char | OPT | INPUT |
A value that specifies which method to use when converting from one currency to another. Valid values are:
Y
Multiplier method. The
| ||||
mnAdvPricingProcessID_PEID | PEID | MATH_NUMERIC | REQ | BOTH |
A code that identifies the Inter-Process Communication ID. | ||||
mnAdvPricingTransID_TCID | TCID | MATH_NUMERIC | REQ | BOTH |
cUseBasePriceCalls_YN16 | YN16 | char | OPT | INPUT |
The Yes or No Entry field is a common, single-character entry field for simple yes or no responses on prompt screens. |
None |
None |