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 |