D90CG503B - CRM Case Billing Process
| Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
|---|---|---|---|---|
| mnCustomerNumber_AN8 | AN8 | MATH_NUMERIC | OPT | NONE |
A number that identifies an entry in the Address Book system, such as employee, applicant, participant, customer, supplier, tenant, or
| ||||
| mnShortItem_ITM | 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
| ||||
| szBusinessUnit_MCU | 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
| ||||
| szProductModel_PRODM | PRODM | char | OPT | NONE |
A code that classifies an inventory item into a model for customer service. Some examples include: Laser Printer, Inkjet or Fax. | ||||
| mnAssetItemNumber_NUMB | NUMB | MATH_NUMERIC | OPT | NONE |
An 8-digit number that uniquely identifies an asset. | ||||
| szLineType_LNTY | LNTY | char | OPT | NONE |
A code that controls how the system processes lines on a transaction. It controls the systems with which the transaction interfaces, such as
| ||||
| szCompany_CO | CO | char | OPT | NONE |
A code that identifies a specific organization, fund, or other reporting entity. The company code must already exist in the Company
| ||||
| mnAddNumOwnerBilling_AN0B | ANOB | MATH_NUMERIC | OPT | NONE |
The address number of an alternate location to which the owner wants the invoice (application) sent. | ||||
| mnAddNumSendTo_USA5 | USA5 | MATH_NUMERIC | OPT | NONE |
User defined address book number. This will be verified against Address Book. | ||||
| szEntitlementCheckFlag_ENTCK | ENTCK | char | OPT | NONE |
A user defined code (17/ER) to indicate the results of an entitlement check.
Valid values are:
0 Not entitled
1 Transaction entitled
2
| ||||
| cServiceType_TYPS | TYPS | char | OPT | NONE |
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
| ||||
| cMethodofPricing_MTHPR | MTHPR | char | OPT | NONE |
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
| ||||
| szGLCategoryCovered_GLCCV | GLCCV | char | OPT | NONE |
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 | GLCNC | char | OPT | NONE |
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
| ||||
| szCurrencyCodeFrom_CRCD | CRCD | char | OPT | NONE |
A code that identifies the currency of a transaction. | ||||
| szCurrencyCodeTo_CRDC | CRDC | char | OPT | NONE |
A code that identifies the domestic (base) currency of the company on a transaction. | ||||
| mnCurrencyConverRate_CRR | CRR | MATH_NUMERIC | OPT | NONE |
A number (exchange rate) that a foreign currency amount is multiplied by to calculate a domestic currency amount.
The number in this field
| ||||
| cCurrencyMode_CRRM | CRRM | char | OPT | NONE |
An option that specifies whether the system displays amounts in the domestic or foreign currency.
On
The system displays amounts in the
| ||||
| szCostComponent_COST | 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
| ||||
| szCoverageGroup_COVGR | COVGR | char | OPT | NONE |
A user defined code that specifies the Coverage Group. The Coverage Group consists of unlimited cost codes and the percentage
| ||||
| mnPercentCovered_PCOVR | PCOVR | MATH_NUMERIC | OPT | NONE |
The percentage covered under warranty or contract. This is used to calculate the amount to bill or the amount to cost for the line item being
| ||||
| cBillableYN_BILL | BILL | char | OPT | NONE |
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
| ||||
| szTaxArea_TXA1 | TXA1 | char | OPT | NONE |
A code that identifies a tax or geographic area that has common tax rates and tax authorities. The system validates the code you enter
| ||||
| szTaxExplanationCode_EXR1 | EXR1 | char | OPT | NONE |
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
| ||||
| szPriceAdjustSch_ASN3 | ASN3 | char | OPT | NONE |
A user defined code (40/AS) that identifies a price and adjustment schedule. A price and adjustment schedule contains one or more
| ||||
| jdDatePriceEffectiveDate_PEFJ | PEFJ | JDEDATE | OPT | NONE |
The system uses the Price Effective Date to determine the base price and all advanced price adjustments. The value loaded in this date
| ||||
| cTaxableYN_TAX1 | TAX1 | char | OPT | NONE |
A code that indicates whether the item is subject to sales tax when you sell it. The system calculates tax on the item only if the customer is
| ||||
| mnBillableUnits_BLCN | BLCN | MATH_NUMERIC | OPT | NONE |
In general, this field displays the total billable consumption amount billed for a utility. However, use of this fields varies in the Bill Calculation
| ||||
| szBillableUnitOfMeasure_UM | UM | char | OPT | NONE |
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,
| ||||
| cDiscountFactorType_DSFT | DSFT | char | OPT | NONE |
On the Item Price Category Revisions, a $ indicates that the numeric type is an added amount, a % indicates the factor is a multiplier. | ||||
| mnDiscountPercent_DSPC | DSPC | MATH_NUMERIC | OPT | NONE |
Takeoff Pricing file discount percentage | ||||
| mnCaseNumber_DOCO | 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 | 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
| ||||
| mnSiteNumber_AN8 | AN8 | MATH_NUMERIC | OPT | NONE |
A number that identifies an entry in the Address Book system, such as employee, applicant, participant, customer, supplier, tenant, or
| ||||
| szServicePackage_SERP | SERP | char | OPT | NONE |
A combination of service order type and coverage type used to define service support to which the customer is contractually entitled. A
| ||||
| cRequestType_CT01 | CT01 | char | OPT | NONE |
A code that specifies the type of case. | ||||
| szIssuePriority_PRIOR | PRIOR | char | OPT | NONE |
The values that indicate the severity of the customer issue. | ||||
| szLanguagePreference_LNGP | LNGP | char | OPT | NONE |
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 | NONE |
The operating environment of the user. Some examples include Windows 95, Windows NT, UNIX or AS/400. | ||||
| szReqCatCodeJC01_JC01 | JC01 | char | OPT | NONE |
User defined code associated with the team a customer issue is assigned to. | ||||
| szReqCatCodeJC02_JC02 | JC02 | char | OPT | NONE |
User defined reporting code for assigning customer issues. | ||||
| szReqCatCodeJC03_JC03 | JC03 | char | OPT | NONE |
User defined reporting code used when assigning customer issues. | ||||
| szReqCatCodeJC04_JC04 | JC04 | char | OPT | NONE |
User defined reporting code used when assigning customer issues. | ||||
| mnDomesticFlatRate_AMTFD | AMTFD | MATH_NUMERIC | OPT | NONE |
The monetary amount charged to the customer regardless of how many hours were spent or how many parts were used in performing the
| ||||
| mnForeignFlatRate_AMTFF | AMTFF | MATH_NUMERIC | OPT | NONE |
The monetary amount charged to the customer regardless of how many hours were spent or how many parts were used in performing the
| ||||
| szLot_LOTN | LOTN | char | OPT | NONE |
A number that identifies a lot or a serial number. A lot is a group of items with similar characteristics. | ||||
| mnMinimumDomestic_MINAD | MINAD | MATH_NUMERIC | OPT | NONE |
The minimum monetary amount to charge the customer. If the billable amount is less than the minimum amount, the system charges the
| ||||
| mnMinimumForeign_MINAF | MINAF | MATH_NUMERIC | OPT | NONE |
The minimum monetary amount to charge the customer. If the billable amount is less than the minimum amount, the system charges the
| ||||
| mnInvoiceDiscountAvail_IDSC | IDSC | MATH_NUMERIC | OPT | NONE |
The amount of the discount available, as opposed to the amount of the discount actually taken. The discount calculated is based on the
| ||||
| mnInvoiceDiscountForeign_CIDS | CIDS | MATH_NUMERIC | OPT | NONE |
The foreign currency amount of the discount available, as opposed to the amount of the discount actually taken. The discount calculated is
| ||||
| mnInvoiceTaxAmount_ITAM | ITAM | MATH_NUMERIC | OPT | NONE |
The tax amount in the invoice. This can be either the sales, use or VAT tax. | ||||
| mnAmountJournaledTax_JTAX | JTAX | MATH_NUMERIC | OPT | NONE |
The portion of the tax amount calculated for this entry that is not automatically generated by the post program. | ||||
| mnAmountJournaledTaxFor_JTXF | JTXF | MATH_NUMERIC | OPT | NONE |
The portion of the tax amount calculated for this entry that is not automatically generated by the post program. | ||||
| cMode_EV01 | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event. | ||||
| szErrorItem_DTAI | 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
| ||||
| cErrorCode_ERRC | ERRC | char | OPT | NONE |
This error code indicates if any errors occurred during the creation of the Trip Document Detail (F4914) records by the Delivery Document
| ||||
| cVertexFlag_VVTX | VVTX | char | OPT | NONE |
This flag determines whether to use the Vertex Tax Compliance system for tax calculations. Values are:
Y
Use Vertex system to calculate
| ||||
| szPOFlatTransType_VVTY | VVTY | char | OPT | NONE |
Vertex Sales and Use Tax transaction type. | ||||
| szPOVertexTransType_VVTY | VVTY | char | OPT | NONE |
Vertex Sales and Use Tax transaction type. | ||||
| szBranch_MMCU | 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
| ||||
| szPOCostType_COST | 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
| ||||
| cConstantServiceType_TYPS | TYPS | char | OPT | NONE |
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
| ||||
| cPaymentInstrument_RYIN | RYIN | char | OPT | NONE |
The user defined code (00/PY) that specifies how payments are made by the customer. For example:
C
Check
D
Draft
T
Electronic funds
| ||||
| szPaymentTermsCode_PTC | PTC | char | OPT | NONE |
A code that specifies the terms of payment, including the percentage of discount available if the invoice is paid by the discount due date.
| ||||
| szItemBalanceCat_VVIT | VVIT | char | OPT | NONE |
This field tells the Vertex Tax interface the Item Branch/Plant category code to use for Product Category for Sales Tax. The Product
| ||||
| szServiceContAdjSchedule_ASN2 | ASN2 | char | OPT | NONE |
This user defined code (40/AS) identifies a price and adjustment schedule. A price and adjustment schedule contains one or more
| ||||
| szHoldServAdjSchedule_ASN2 | ASN2 | char | OPT | NONE |
This user defined code (40/AS) identifies a price and adjustment schedule. A price and adjustment schedule contains one or more
| ||||
| mnPOPricingUnits_BLCN | BLCN | MATH_NUMERIC | OPT | NONE |
In general, this field displays the total billable consumption amount billed for a utility. However, use of this fields varies in the Bill Calculation
| ||||
| szPOUnitOfMeasure_UM | UM | char | OPT | NONE |
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,
| ||||
| mnAdvPricingTransID_TCID | TCID | MATH_NUMERIC | OPT | NONE |
| jdStartEffectiveDate_EFTB | EFTB | JDEDATE | OPT | NONE |
The date that an address, item, transaction, or table record becomes active. The meaning of this field differs, depending on the program.
| ||||
| mnFBillableAmount_MINAF | MINAF | MATH_NUMERIC | OPT | NONE |
The minimum monetary amount to charge the customer. If the billable amount is less than the minimum amount, the system charges the
| ||||
| mnDBillableAmount_MINAD | MINAD | MATH_NUMERIC | OPT | NONE |
The minimum monetary amount to charge the customer. If the billable amount is less than the minimum amount, the system charges the
| ||||
| cBillForCase_EV01 | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event. | ||||
| cAdjScheduleChange_EV01 | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event. | ||||
| szCountry_CTR | CTR | char | OPT | NONE |
A user defined code (00/CN) that identifies a country. The country code has no effect on currency conversion.
The Address Book system
| ||||
| mnInvoiceTaxForeign_CITX | CITX | MATH_NUMERIC | OPT | NONE |
The tax amount on the invoice in foreign currency. This can be either the sales, use or VAT tax. | ||||
| szProductFamily_PRODF | PRODF | char | OPT | NONE |
A code that classifies an inventory item into a group for customer service. Some examples include: Laser Printer, Inkjet, or Fax. | ||||
| mnCaseProviderGroup_CALLQ | CALLQ | MATH_NUMERIC | OPT | NONE |
The address number of the case provider group. To resolve customer problems, the system or a person can assign case to provider
| ||||
| cCaseUseBasePrice_YN16 | YN16 | char | OPT | NONE |
The Yes or No Entry field is a common, single-character entry field for simple yes or no responses on prompt screens. | ||||
| mnAdvPricingProcessID_PEID | PEID | MATH_NUMERIC | OPT | NONE |
A code that identifies the Inter-Process Communication ID. | ||||
| mnDTotalTaxableAmt_MINAD | MINAD | MATH_NUMERIC | OPT | NONE |
The minimum monetary amount to charge the customer. If the billable amount is less than the minimum amount, the system charges the
| ||||
| mnFTotalTaxableAmt_MINAF | MINAF | MATH_NUMERIC | OPT | NONE |
The minimum monetary amount to charge the customer. If the billable amount is less than the minimum amount, the system charges the
| ||||
| mnAssignee_AN8 | AN8 | MATH_NUMERIC | OPT | NONE |
A number that identifies an entry in the Address Book system, such as employee, applicant, participant, customer, supplier, tenant, or
| ||||
| mnDTotalBillableAmt_MINAD | MINAD | MATH_NUMERIC | OPT | NONE |
The minimum monetary amount to charge the customer. If the billable amount is less than the minimum amount, the system charges the
| ||||
| mnFTotalBillableAmt_MINAF | MINAF | MATH_NUMERIC | OPT | NONE |
The minimum monetary amount to charge the customer. If the billable amount is less than the minimum amount, the system charges the
| ||||
| mnCommitDuration_COMD | COMD | MATH_NUMERIC | OPT | NONE |
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
| ||||
| None |
| None |