D1700550G - Cache Process SCE Detail Cache
Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
---|---|---|---|---|
mnMBFJobNumber | JOBS | MATH_NUMERIC | OPT | NONE |
The job number (work station ID) which executed the particular job. | ||||
szMBFComputerID | CTID | char | OPT | NONE |
cCacheActionCode | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event. | ||||
cCacheErrorCode | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event. | ||||
nNumberOfKeys | INT01 | integer | OPT | NONE |
Number of Days in Future to Query for Responses Due. | ||||
cSuppressErrorMessage | SUPPS | char | OPT | NONE |
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 | 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
| ||||
idCacheCursorPtr | GENLNG | ID | OPT | NONE |
General purpose ID variable. | ||||
cSequentialFetch | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event. | ||||
idF1721RecordPtr | GENLN2 | ID | OPT | NONE |
General purpose ID variable. | ||||
cOriginal | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event. | ||||
cAction | ACTN | char | OPT | NONE |
A code that specifies the action that is performed. Valid values are: A Add C Change | ||||
mnDocumentNumber_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,
| ||||
szDocumentType_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
| ||||
szDocumentCompany_KCOO | KCOO | char | OPT | NONE |
A number that, along with order number and order type, uniquely identifies an order document (such as a purchase order, a contract, a
| ||||
szContractChgNumber_COCH | COCH | char | OPT | NONE |
The change number of the contract. The change order number of the base contract is always initialized to 000. Each time you enter a
| ||||
mnLineNumber_LNID | 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
| ||||
mnDocNumberSalesOrder_DOC1 | DOC1 | MATH_NUMERIC | OPT | NONE |
The document number associated with a given document type. | ||||
szDocTypeSalesOrder_DCT1 | DCT1 | char | OPT | NONE |
Used to record the Closing journal entry's document type in the Lot Proceed files. | ||||
szDocCompanySalesOrder_SKCO | SKCO | char | OPT | NONE |
Document Company (Sales Order) | ||||
szDocVersionSalesOrder_OSFX | OSFX | char | OPT | NONE |
The number that identifies a specific pay item associated with the document. | ||||
szDescription01_DL01 | DL01 | char | OPT | NONE |
A user defined name or remark. | ||||
jdContractStartDate_CSDT | CSDT | JDEDATE | OPT | NONE |
The date you actually start work on the contract. | ||||
jdContractEndDate_CDTE | CDTE | JDEDATE | OPT | NONE |
The date you actually completed work on the contract. | ||||
jdChangeDate_CHD | CHD | JDEDATE | OPT | NONE |
The date of last change for the change order. This date will control general ledger processing for the change order. | ||||
szProjectNumber_MCUS | 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
| ||||
szAccountId_AID | 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. | ||||
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
| ||||
szObjectAccount_OBJ | 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
| ||||
szSubsidiary_SUB | SUB | char | OPT | NONE |
A subset of an object account. Subsidiary accounts include detailed records of the accounting activity for an object account. | ||||
szSubledger_SBL | SBL | char | OPT | NONE |
A code that identifies a detailed, auxiliary account within a general ledger account. A subledger can be an equipment item number or an
| ||||
cSubledgerType_SBLT | SBLT | char | OPT | NONE |
A user defined code (00/ST) that is used with the Subledger field to identify the subledger type and how the system performs subledger
| ||||
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
| ||||
szGLClass_GLC | GLC | char | OPT | NONE |
A code that determines the trade account that the system uses as the offset when you post invoices or vouchers. The system concatenates
| ||||
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
| ||||
mnAddressNoCustomer_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
| ||||
mnAddressNoShipTo_SHAN | SHAN | MATH_NUMERIC | OPT | NONE |
The address number of the location to which you want to ship this order. The address book provides default values for customer address,
| ||||
mnAddressNoBillTo_ANOB | ANOB | MATH_NUMERIC | OPT | NONE |
The address number of an alternate location to which the owner wants the invoice (application) sent. | ||||
mnAddressNoSiteNo_LANO | LANO | MATH_NUMERIC | OPT | NONE |
The address book number for the lessor, renter, or lending institution. | ||||
mnUnits_U | U | MATH_NUMERIC | OPT | NONE |
The quantity of something that is identified by a unit of measure. For example, it can be the number of barrels, boxes, cubic yards, gallons,
| ||||
szUnitOfMeasure_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,
| ||||
mnUnitPrice_UP | UP | MATH_NUMERIC | OPT | NONE |
The list or base price you charge for one primary or pricing unit of this item. | ||||
mnUnitPriceForeign_FUPC | FUPC | MATH_NUMERIC | OPT | NONE |
The foreign price per unit. | ||||
szPricingUnitOfMeasure_UOM4 | UOM4 | char | OPT | NONE |
A user defined code (00/UM) that indicates the unit of measure in which you usually price the item. | ||||
jdPriceEffectiveDate_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
| ||||
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
| ||||
szTaxRateArea_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
| ||||
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
| ||||
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. | ||||
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. | ||||
szItemNumberUnknown_UITM | UITM | char | OPT | NONE |
A number that the system assigns to an item. It can be in short, long, or third item number format. | ||||
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
| ||||
szBranchPlant_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
| ||||
szProductComponent_PRODC | PRODC | char | OPT | NONE |
The components that make an equipment number or components associated with a customer site. | ||||
jdCancelDate_CNDJ | CNDJ | JDEDATE | OPT | NONE |
The date that the order should be canceled if the goods have not been sent to the customer or the goods have not been received from the
| ||||
szCancelReasonCode_CNRC | CNRC | char | OPT | NONE |
A user defined code for defining reasons a contract was cancelled. | ||||
mnNonBillableDuration_CDUR | CDUR | MATH_NUMERIC | OPT | NONE |
The duration associated with a contract. | ||||
cBillBySite_YN | YN | 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. | ||||
mnBillableDuration_BDUR | BDUR | MATH_NUMERIC | OPT | NONE |
The billing duration associated with a contract. | ||||
cBillingFrequencyCode_BLFC | BLFC | char | OPT | NONE |
A code that indicates the billing cycle. The code that you enter must exist in the Billing Frequency Master table (F15019). | ||||
szBillingUnitOfMeasure_BUM | BUM | char | OPT | NONE |
A user defined code (system 00/type UM) that identifies the unit of measurement for an amount or quantity as it was billed. For example, it
| ||||
jdDateBillFrom_BTFR | BTFR | JDEDATE | OPT | NONE |
The from date used to determine if a transaction is billed. The transaction is billed if the general ledger date falls between the from date and
| ||||
jdBilledThroughDate_BTDT | BTDT | JDEDATE | OPT | NONE |
This field will be used in the Recurring Billing module as part of a date-oriented billing method, as opposed to period-oriented billing. This
| ||||
jdRenewalDate_RNWDT | RNWDT | JDEDATE | OPT | NONE |
A date prior to the contract end date that allows the end user to prepare a renewal notice prior to the contract end date. | ||||
jdGLDate_DGL | DGL | JDEDATE | OPT | NONE |
A date that identifies the financial period to which the transaction is to be posted.
The company constants specify the date range for each
| ||||
mnTaxAmount_STAM | STAM | MATH_NUMERIC | OPT | NONE |
The amount assessed and payable to tax authorities. It is the total of the VAT, use, and sales taxes (PST). | ||||
mnRecurringBillingAmt_RRBA | RRBA | MATH_NUMERIC | OPT | NONE |
A fixed amount you want to bill with each recurring frequency. | ||||
mnRecurrBillingAmountFo_FRBA | FRBA | MATH_NUMERIC | OPT | NONE |
A fixed amount that you want to bill with each recurring frequency. | ||||
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.
| ||||
jdBillSuspendDate_SSDJ | SSDJ | JDEDATE | OPT | NONE |
The date when a recurring order is no longer to be processed. | ||||
mnExchangeRate_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
| ||||
szCurrencyCodeDomestic_CRCD | CRCD | char | OPT | NONE |
A code that identifies the currency of a transaction. | ||||
szCurrencyCodeForeign_CRCF | CRCF | char | OPT | NONE |
The currency code of the insured amount. | ||||
mnExchangeRateDivisor_CRRD | CRRD | MATH_NUMERIC | OPT | NONE |
A number (exchange rate) that a foreign currency amount is divided by to calculate a domestic currency amount. The number you enter in
| ||||
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
| ||||
mnExtendedPrice_AEXP | AEXP | MATH_NUMERIC | OPT | NONE |
The number of units multiplied by the unit price. | ||||
mnExtendedPriceForeign_FEA | FEA | MATH_NUMERIC | OPT | NONE |
The product of the foreign price times the number of units. | ||||
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 | ||||
mnDiscountAmount_DSCT | DSCT | MATH_NUMERIC | OPT | NONE |
Total amount of the discount. | ||||
mnDiscountAmountForeign_CDSA | CDSA | MATH_NUMERIC | OPT | NONE |
The amount of the discount, expressed in the foreign currency of the transaction, that was taken or granted during the application of a
| ||||
mnNoServiceUnitsRelieved_UREC | UREC | MATH_NUMERIC | OPT | NONE |
The original quantity of the order line, plus or minus any changes to that quantity, less all quantities shipped, received and/or vouchered to
| ||||
mnNoServiceUnitsOpen_UOPN | UOPN | MATH_NUMERIC | OPT | NONE |
The original quantity for the order detail line, plus or minus any changes to that quantity, minus all quantities shipped, received, and
| ||||
mnAmountReceived_AREC | AREC | MATH_NUMERIC | OPT | NONE |
The value of the goods received to date against the original order line. | ||||
mnAmountReceivedForeign_FREC | FREC | MATH_NUMERIC | OPT | NONE |
Amount - Received Foreign | ||||
mnAmountOpen_AOPN | AOPN | MATH_NUMERIC | OPT | NONE |
The amount of the order, invoice, or voucher that is still unpaid or open.
When you enter a document (for example, an order, invoice, or
| ||||
mnAmountOpenForeign_FOPN | FOPN | MATH_NUMERIC | OPT | NONE |
The open amount of a blanket order that the system uses to determine the amount originally released. The system uses this amount when
| ||||
szNoOfServiceUnitsUOM_UOM2 | UOM2 | char | OPT | NONE |
A user defined code (00/UM) that indicates an alternate unit of measure for the item. | ||||
szCreatedByUser_CRTU | CRTU | char | OPT | NONE |
The address book number of the user who created this record. | ||||
mnLineTotal_TOTD | TOTD | MATH_NUMERIC | OPT | NONE |
Total dollars is a factor used to calculate average days to pay. The amount is equal to the sum of cash received against valid accounts
| ||||
mnLineTotalForeign_FOAG | FOAG | MATH_NUMERIC | OPT | NONE |
When an adjustment is made to an invoice, the gross amount of the pay item before the adjustment. The foreign original gross amount is
| ||||
mnLineNumberSalesOrder_LINN | LINN | MATH_NUMERIC | OPT | NONE |
A number that identifies multiple occurrences (such as line numbers on a purchase order or other document). Generally, the system
| ||||
szPrimaryItemNumber | UITM | char | OPT | NONE |
A number that the system assigns to an item. It can be in short, long, or third item number format. | ||||
mnNbrDaysInContract_DAYSC | DAYSC | MATH_NUMERIC | OPT | NONE |
The number of days in the contract based on the contract start date and the contract end date. | ||||
cBilledFlag_BILLF | BILLF | char | OPT | NONE |
A user defined code (17/YN) that indicates whether the line has been billed. | ||||
mnDailyAmoritzationAmt_DAILY | DAILY | MATH_NUMERIC | OPT | NONE |
The daily amortization amount. This amount is the contract amount divided by the number of days in the contract. | ||||
jdUserReservedDate_URDT | 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. | ||||
szPriceAdjustSchedule_ASN1 | ASN1 | char | OPT | NONE |
A user defined code (system 40, type AS) identifying a price and adjustment schedule. A price and adjustment schedule contains one or
| ||||
mnPriceByAddress_AN8PB | AN8PB | MATH_NUMERIC | OPT | NONE |
The address book number that is used for pricing. | ||||
cAdvancePriceFlag_ADPRF | ADPRF | char | OPT | NONE |
Use 0 or N to specify that advance pricing was not used to price. Use 1 or Y to specify advance pricing was used. | ||||
jdInstalDate_JCD | JCD | JDEDATE | OPT | NONE |
The date the contract for the asset was put into effect. | ||||
szChangeStatus_CHGST | CHGST | char | OPT | NONE |
A user defined code (17/CH) that specifies the change status of a contract. On a detail line, enter the value 99 for a deleted contract. | ||||
mnDomesticCreditAmount_AMTCD | AMTCD | MATH_NUMERIC | OPT | NONE |
The monetary amount the customer has been credited for this order. The monetary amount is expressed in the currency that is set up for the
| ||||
mnForeignCreditAmount_AMTCF | AMTCF | MATH_NUMERIC | OPT | NONE |
The monetary amount that the customer has been credited for this order. The monetary amount is expressed in the currency that is set up
| ||||
mnDomesticCancelAmount_CANDM | CANDM | MATH_NUMERIC | OPT | NONE |
The monetary amount that has been cancelled. The monetary amount is expressed in the currency that is set up for the company initiating
| ||||
mnForeignCancelAmount_CANFN | CANFN | MATH_NUMERIC | OPT | NONE |
The monetary amount that has been cancelled. The monetary amount is expressed in the currency that is set up for the customer. | ||||
cBillSuspendFlag_BSUSP | BSUSP | char | OPT | NONE |
A code that identifes whether a contract detail line is suspended. Valid values are:
Blank
The contract detail line is not suspended and will
| ||||
cRenewalFlag_RNFLG | RNFLG | char | OPT | NONE |
A user defined code (17/YN) that allows you to specify whether the contract detail line is included in the data selection for contract renewals.
| ||||
cBaseWarrantyFlag_BSWAR | BSWAR | char | OPT | NONE |
An option that indicates whether the contract is a base warranty contract. | ||||
mnAdjustmentRevisionLevel_AREV | AREV | MATH_NUMERIC | OPT | NONE |
This field maintains the current revision level of Advanced Pricing adjustments awarded within a sales order. Adjustments associated with
| ||||
szContractDetailCategory_CD01 | CD01 | char | OPT | NONE |
One of ten reporting codes that you can assign to a service contract detail line. Use these codes to identify contract lines for reports.
| ||||
szContractDetailCategory_CD02 | CD02 | char | OPT | NONE |
One of ten reporting codes that you can assign to a service contract detail line. Use these codes to identify contract lines for reports.
| ||||
szContractDetailCategory_CD03 | CD03 | char | OPT | NONE |
One of ten reporting codes that you can assign to a service contract detail line. Use these codes to identify contract lines for reports.
| ||||
szContractDetailCategory_CD04 | CD04 | char | OPT | NONE |
One of ten reporting codes that you can assign to a service contract detail line. Use these codes to identify contract lines for reports.
| ||||
szContractDetailCategory_CD05 | CD05 | char | OPT | NONE |
One of ten reporting codes that you can assign to a service contract detail line. Use these codes to identify contract lines for reports.
| ||||
mnPriceCapPercentage_PCPR | PCPR | MATH_NUMERIC | OPT | NONE |
For future use. The price cap percentage associated with a contract. | ||||
mnMeterReading1_MXMET1 | MXMET1 | MATH_NUMERIC | OPT | NONE |
The meter reading balance of meter 1. | ||||
mnMeterReading2_MXMET2 | MXMET2 | MATH_NUMERIC | OPT | NONE |
The meter reading balance of meter 2. | ||||
mnMeterReading3_MXMET3 | MXMET3 | MATH_NUMERIC | OPT | NONE |
The meter reading balance of meter 3. | ||||
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
| ||||
szPriceAdjustScheduleServ_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
| ||||
cFreeContract_BTF05 | BTF05 | char | OPT | NONE |
Use this line type flag used to indicate that this is a free contract. | ||||
cBillingInAdvanceArrears_ADAR | ADAR | char | OPT | NONE |
A code to determine how a contract should be billed. | ||||
cAdvancedPricingExists_EV01 | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event. |
B0000083 Convert Math Numeric to String with Left Zero Pad | ||||
B0000128 Retrieve Company Currency Code | ||||
B0000130 Retrieve Company From Business Unit | ||||
B0100009 Create Compressed Description | ||||
B0100015 Get A/B info for A/R and A/P | ||||
B1700560 F1721 Service Contract Entry MBF S/WM Edit Module | ||||
B4000770 Convert String To Numeric | ||||
B4000880 Verify And Get Address Book for OP | ||||
B4200100 Get Sold To Billing Instructions | ||||
B4200140 Get Ship To Billing Instructions | ||||
B9800002 Language Type Editing | ||||
B9800100 Get Audit Information | ||||
N1700050 F17001 Check For S/WM | ||||
N1700850 Validate S/WM Line Type | ||||
X0010 Next Numbers | ||||
X0903 Fiscal Date Edits + | ||||
X4101 Validate and Retrieve Item Master | ||||
XX0901 Validate Account Number |
F1720 Contract Header | ||||
F1721 Contract Detail |