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 |