This Function has 4 modes:
 1 = Add record to cache
 2 = Fetch record from cache
 3 = Delete all records from cache
 4 = Terminate cache
D5200221 - Contract Billing Retainage Calculation Cache Data Structure
| Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both | 
|---|---|---|---|---|
| szComputerID_CTID | CTID | char | REQ | INPUT | 
| mnJobnumberA_JOBS | JOBS | MATH_NUMERIC | REQ | INPUT | 
The job number (work station ID) which executed the particular job.  | ||||
| mnLineNumber_MATH01 | MATH01 | MATH_NUMERIC | REQ | INPUT | 
- - - Good Performance Low Value.  | ||||
| cModeProcessing_MODE | MODE | char | REQ | INPUT | 
The processing mode used in Purchase Order Consolidator to signify when specific orders are being processed.  | ||||
| mnDocumentOrderAlt_DOCZ | DOCZ | MATH_NUMERIC | OPT | BOTH | 
The original document number.  This can be a voucher, an invoice, unapplied cash, a journal entry number, etc.  Matching document 
  | ||||
| szDocTypeInvoiceOnly_DCTI | DCTI | char | OPT | BOTH | 
A user defined (00/DI) document type for invoice entry. Any document type set up for invoice-only entry should begin with the letter R 
  | ||||
| szDocumentCompanyInvoice_KCOI | KCOI | char | OPT | BOTH | 
Invoice Document Company.  | ||||
| szDocumentPayItem_SFX | SFX | char | OPT | BOTH | 
A number that identifies the pay item for a voucher or an invoice. The system assigns the pay item number. If the voucher or invoice has 
  | ||||
| mnDocumentOrderInvoiceE_DOCO | DOCO | MATH_NUMERIC | OPT | BOTH | 
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 | BOTH | 
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 
  | ||||
| szCompanyKeyOrderNo_KCOO | KCOO | char | OPT | BOTH | 
A number that, along with order number and order type, uniquely identifies an order document (such as a purchase order, a contract, a 
  | ||||
| szContractChangeNum_COCH | COCH | char | OPT | BOTH | 
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 | BOTH | 
A number that identifies multiple occurrences, such as line numbers on a purchase order or other document. Generally, the system assigns 
  | ||||
| szOwnerPayItem_OPIM | OPIM | char | OPT | BOTH | 
The pay item number as defined by the owner. This field is alphanumeric and can be up to 15 characters in length. It is recommended that 
  | ||||
| mnBatchNumber_ICU | ICU | MATH_NUMERIC | OPT | BOTH | 
A number that identifies a group of transactions that the system processes and balances as a unit. When you enter a batch, you can either 
  | ||||
| jdApplicatnDate_APDT | APDT | JDEDATE | OPT | BOTH | 
The date of the last or current application. (An application is assigned each time an invoice is issued for the contract.)  | ||||
| jdDateForGLandVoucherJULIA_DGJ | DGJ | JDEDATE | OPT | BOTH | 
A date that identifies the financial period to which the transaction will be posted. You define financial periods for a date pattern code that you 
  | ||||
| jdDateServiceCurrency_DSVJ | DSVJ | JDEDATE | OPT | BOTH | 
A date that indicates when you purchased goods or services, or when you incurred a tax liability.  | ||||
| cDateExchangeRateDateBasi_ERDB | ERDB | char | OPT | BOTH | 
A code that controls which date the system uses to retrieve the exchange rate for the invoice. Valid values are:
1
Use the invoice date 
  | ||||
| szCurrencyCodeFrom_CRCD | CRCD | char | OPT | BOTH | 
A code that identifies the currency of a transaction.  | ||||
| szCurrencyCodeOrigin_CRCF | CRCF | char | OPT | BOTH | 
The currency code of the insured amount.  | ||||
| mnCurrencyConverRateDiv_CRRD | CRRD | MATH_NUMERIC | OPT | BOTH | 
A number (exchange rate) that a foreign currency amount is divided by to calculate a domestic currency amount. The number you enter in 
  | ||||
| szCostCenter_MCU | MCU | char | OPT | BOTH | 
An alphanumeric code that identifies a separate entity within a business for which you want to track costs. For example, a business unit 
  | ||||
| cRetainageControlFlag_RCTL | RCTL | char | OPT | BOTH | 
An option that determines whether the retainage amount is stored in the Accounts Receivable or General Accounting system and whether 
  | ||||
| mnAddressNumberJobAr_AN8O | AN8O | MATH_NUMERIC | OPT | BOTH | 
The address book number to which the system posts billing and accounts receivable transactions.  | ||||
| szCompany_CO | CO | char | OPT | BOTH | 
A code that identifies a specific organization, fund, or other reporting entity. The company code must already exist in the Company 
  | ||||
| mnParentContNumber_PCTN | PCTN | MATH_NUMERIC | OPT | BOTH | 
The parent contract number to which this particular contract is attached.  | ||||
| szParentContractType_PCTT | PCTT | char | OPT | BOTH | 
The parent contract type to which this particular contract is attached.  | ||||
| szParentCntrctDocumentCo_PCKO | PCKO | char | OPT | BOTH | 
Parent Contract Document Company.  | ||||
| szCostCenterHost_JUCU | JMCU | char | OPT | BOTH | 
The Business Unit responsible for the job. This is particularly useful during transfer pricing.  | ||||
| szDescription001_DL01 | DL01 | char | OPT | BOTH | 
A user defined name or remark.  | ||||
| cPricingType_PRTP | PRTP | char | OPT | BOTH | 
A code that specifies the billing terms that are defined by the billing line on the contract. The system uses the predefined codes for the 
  | ||||
| szCostCenterSubsequent_MCUS | MCUS | char | OPT | BOTH | 
Either a subsequent business unit or a project number.
A subsequent business unit specifies where to charge costs (or revenues) when the 
  | ||||
| szTaxExplanationCode1_EXR1 | EXR1 | char | OPT | BOTH | 
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 
  | ||||
| szTaxArea1_TXA1 | TXA1 | char | OPT | BOTH | 
A code that identifies a tax or geographic area that has common tax rates and tax authorities. The system validates the code you enter 
  | ||||
| szGlOffsetRetention_RGLC | RGLC | char | OPT | BOTH | 
A code that designates the offset accounts for retainage, for example RETN or 1225. You set up the code as an automatic accounting 
  | ||||
| cActivateVertexTaxComplia_VVTX | VVTX | char | OPT | BOTH | 
This flag determines whether to use the Vertex Tax Compliance system for tax calculations.  Values are:
Y 
Use Vertex system to calculate 
  | ||||
| mnVertexJobNumber_JOBS | JOBS | MATH_NUMERIC | OPT | BOTH | 
The job number (work station ID) which executed the particular job.  | ||||
| szVertexTransactionType_VVTY | VVTY | char | OPT | BOTH | 
Vertex Sales and Use Tax transaction type.  | ||||
| szVertexProductCategory_VVTC | VVTC | char | OPT | BOTH | 
User defined code used in the Vertex Tax Decision Maker for products or services that are non-taxable or are at a non-stanard rate.  | ||||
| szPaymentTermsCode01_PTC | PTC | char | OPT | BOTH | 
A code that specifies the terms of payment, including the percentage of discount available if the invoice is paid by the discount due date. 
  | ||||
| mnDomCurrTaxableAmt_ATXA | ATXA | MATH_NUMERIC | OPT | BOTH | 
The amount on which taxes are assessed.  | ||||
| mnForCurrTaxableAmt_CTXA | CTXA | MATH_NUMERIC | OPT | BOTH | 
That portion of the sale that is subject to tax in foreign currency.  | ||||
| idGenericLong_GENLNG | GENLNG | ID | OPT | BOTH | 
General purpose ID variable.  | ||||
| mnDeferredTaxDomestic_DDTR | DDTR | MATH_NUMERIC | OPT | BOTH | 
The deferred tax associated with the retainage amount.  | ||||
| mnDeferredTaxForeign_FDTR | FDTR | MATH_NUMERIC | OPT | BOTH | 
The deferred tax associated with the retainage stored in the foreign currency of the transaction.  | ||||
| mnAmtDiscountAvailable_ADSC | ADSC | MATH_NUMERIC | OPT | BOTH | 
The amount of the invoice or voucher pay item that is eligible to be subtracted from the gross amount when the transaction is paid. The 
  | ||||
| mnForeignDiscountAvail_CDS | CDS | MATH_NUMERIC | OPT | BOTH | 
The foreign amount of the discount available as opposed to the amount of the discount actually taken.  | ||||
| mnAmtTax2_STAM | STAM | MATH_NUMERIC | OPT | BOTH | 
The amount assessed and payable to tax authorities. It is the total of the VAT, use, and sales taxes (PST).  | ||||
| mnForeignTaxAmount_CTAM | CTAM | MATH_NUMERIC | OPT | BOTH | 
The tax amount in foreign currency. This can be the sales, use, or VAT tax.  | ||||
| mnAmountTaxExempt_ATXN | ATXN | MATH_NUMERIC | OPT | BOTH | 
The amount upon which taxes are not assessed. This is the portion of the transaction not subject to sales, use, or VAT taxes because the 
  | ||||
| mnForeignTaxExempt_CTXN | CTXN | MATH_NUMERIC | OPT | BOTH | 
The foreign amount associated with this document which is not subject to sales, use or value-added tax due to the nature of the transaction 
  | ||||
| szGlClass_GLC | GLC | char | OPT | BOTH | 
A code that determines the trade account that the system uses as the offset when you post invoices or vouchers. The system concatenates 
  | ||||
| jdDateDueJulian_DDJ | DDJ | JDEDATE | OPT | BOTH | 
In Accounts Receivable, the date that the net payment is due.
In Accounts Payable, the date that the payment is due to receive a discount 
  | ||||
| jdDateBillFrom_BTFR | BTFR | JDEDATE | OPT | BOTH | 
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 | BOTH | 
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 
  | ||||
| mnRetainage_RTNG | RTNG | MATH_NUMERIC | OPT | BOTH | 
This field is the retained dollars for a contract line.  | ||||
| mnRetainageForeign_FTNG | FTNG | MATH_NUMERIC | OPT | BOTH | 
xThis field is the retained dollars for a contract line.  | ||||
| None | 
| None |