D4303090A - Multiple Accounts Detail Cache
Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
---|---|---|---|---|
szCacheActionCode_CATN | CACTN | char | OPT | NONE |
A code that indicates the activity you want to perform. Valid codes:
o Get - Retrieve the cache element
o Add - Add a cache element
o
| ||||
idIndexNumber_INID | INID | ID | OPT | NONE |
Numeric I.D. used for the table's index. | ||||
mnNumberKeys_NKEYS | NKEYS | MATH_NUMERIC | OPT | NONE |
The number of keys in an index that will be used to retrieve, delete, or update a record. | ||||
cSuppressErrorMessages_EV01 | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event. | ||||
szErrorMessageID_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
| ||||
idCacheCursor_GENLNG | GENLNG | ID | OPT | NONE |
General purpose ID variable. | ||||
mnJobnumberA_JOBS | JOBS | MATH_NUMERIC | OPT | NONE |
The job number (work station ID) which executed the particular job. | ||||
szComputerID_CTID | CTID | char | OPT | NONE |
cActionCode_ACTN | ACTN | char | OPT | NONE |
A code that specifies the action that is performed. Valid values are: A Add C Change | ||||
cFlagTransactionEdit_EDFL | EDFL | char | OPT | NONE |
Flag that determines whether a transaction has been edited as valid or not. 0 Not yet edited/Needs reediting. 1 Edited and valid. | ||||
mnProcessID_PEID | PEID | MATH_NUMERIC | OPT | NONE |
A code that identifies the Inter-Process Communication ID. | ||||
mnTransactionID_TCID | TCID | MATH_NUMERIC | OPT | NONE |
mnDocumentOrderInvoiceE_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,
| ||||
szCompanyKeyOrderNo_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
| ||||
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
| ||||
szOrderSuffix_SFXO | SFXO | char | OPT | NONE |
In the A/R and A/P systems, a code that corresponds to the pay item. In the Sales Order and Procurement systems, this code identifies
| ||||
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
| ||||
mnDistributionLineNumber_DLNID | DLNID | MATH_NUMERIC | OPT | NONE |
szAcctNoInputMode_ANI | ANI | char | OPT | NONE |
A value that identifies an account in the general ledger. Use one of the following formats to enter account numbers:
o Standard account
| ||||
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. | ||||
szPurchasingCostCenter_OMCU | OMCU | char | OPT | NONE |
The business unit from an account number. The account number business unit is usually found in the data item MCU, however, Distribution
| ||||
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. | ||||
szDescription001_DL01 | DL01 | char | OPT | NONE |
A user defined name or remark. | ||||
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
| ||||
jdDtForGLAndVouch1_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
| ||||
mnPeriodNoGeneralLedge_PN | PN | MATH_NUMERIC | OPT | NONE |
A number indicating the current accounting period. This number, used in conjunction with the Company Constants table (F0010) and the
| ||||
mnFiscalYear1_FY | FY | MATH_NUMERIC | OPT | NONE |
A number that identifies the fiscal year. Generally, you can either enter a number in this field or leave it blank to indicate the current fiscal
| ||||
mnCentury_CTRY | CTRY | MATH_NUMERIC | OPT | NONE |
The calendar century associated with the year. Enter is the first two digits of
the year. For example, 19 indicates any year beginning with 19
| ||||
szCategoryCodeGl001_R001 | R001 | char | OPT | NONE |
Category code 1 associated with the Account Master table (F0901). This is a user defined code (09/01) for use in flex account mapping and
| ||||
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
| ||||
cSplitType_MAST | MAST | char | OPT | NONE |
Multiple Account Split Type. Valid values are: 1: Split by Percentage (default) 2: Split by Fixed Amount 3: Split by Fixed Quantity | ||||
mnSplitPercentage_MASP | MASP | MATH_NUMERIC | OPT | NONE |
The multiple account percentage that the system uses for creating the G/L distribution. | ||||
mnSplitAmount_MASA | MASA | MATH_NUMERIC | OPT | NONE |
The amount that the system uses when creating the G/L distribution. | ||||
mnSplitQuantity_MASU | MASU | MATH_NUMERIC | OPT | NONE |
The multiple-account split quantity that the system uses for creating the G/L distribution. | ||||
mnSplitForeignAmount_MASF | MASF | MATH_NUMERIC | OPT | NONE |
The foreign amount that the system uses when creating the G/L distribution. | ||||
mnUnitsTransactionQty_UORG | UORG | MATH_NUMERIC | OPT | NONE |
The quantity of units affected by this transaction. | ||||
mnUnitsChangeOrderQty_UCHG | UCHG | MATH_NUMERIC | OPT | NONE |
The number of units that are on hold. | ||||
mnUnitsOpenQuantity_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
| ||||
mnUnitsLineItemQtyRe_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
| ||||
mnUnitsRelieved_URLV | URLV | MATH_NUMERIC | OPT | NONE |
This field contains the units that have been relieved from the total number of committed units. | ||||
mnAmountExtendedPrice_AEXP | AEXP | MATH_NUMERIC | OPT | NONE |
The number of units multiplied by the unit price. | ||||
mnAmountChange_ACHG | ACHG | MATH_NUMERIC | OPT | NONE |
The value of the units on hold. | ||||
mnAmountOpen1_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
| ||||
mnAmountReceived_AREC | AREC | MATH_NUMERIC | OPT | NONE |
The value of the goods received to date against the original order line. | ||||
mnAmountRelieved_ARLV | ARLV | MATH_NUMERIC | OPT | NONE |
This field contains the amount that has been relieved from the total commitment amount. | ||||
mnTaxCommitment_FTN1 | FTN1 | MATH_NUMERIC | OPT | NONE |
The total tax amount committed to the PA ledger. The system uses this amount to relieve taxes at the committed rate. | ||||
mnTaxAmountRelieved_TRLV | TRLV | MATH_NUMERIC | OPT | NONE |
This field contains the amount of tax that has been relieved from the total tax commitment amount. | ||||
mnAmountForeignExtPrice_FEA | FEA | MATH_NUMERIC | OPT | NONE |
The product of the foreign price times the number of units. | ||||
mnForeignChangedAmount_FCHG | FCHG | MATH_NUMERIC | OPT | NONE |
The change amount of a detail line on an Order. This is stated as the foreign change amount which is converted by the exchange rate
| ||||
mnAmountForeignOpen_FAP | FAP | MATH_NUMERIC | OPT | NONE |
The unpaid foreign amount of a transaction. | ||||
mnAmountReceivedForeign_FREC | FREC | MATH_NUMERIC | OPT | NONE |
Amount - Received Foreign | ||||
mnForeignTaxAmount_CTAM | CTAM | MATH_NUMERIC | OPT | NONE |
The tax amount in foreign currency. This can be the sales, use, or VAT tax. | ||||
mnTaxForeignAmountRelieve_FTRL | FTRL | MATH_NUMERIC | OPT | NONE |
This field contains the amount of foreign tax that has been relieved. | ||||
szUserReservedCode_URCD | URCD | char | OPT | NONE |
This is a 2 position code that is reserved for the user. JDE does not currently use this field and will not utilize this field in the future. | ||||
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. | ||||
mnUserReservedAmount_URAT | URAT | MATH_NUMERIC | OPT | NONE |
This is a 15 position code that is reserved for the user. JDE does not currently use this field and will not utilize this field in the future. | ||||
mnUserReservedNumber_URAB | URAB | MATH_NUMERIC | OPT | NONE |
This is a 8 position code that is reserved for the user. JDE does not currently use this field and will not utilize this field in the future. | ||||
szUserReservedReference_URRF | URRF | char | OPT | NONE |
A 15-position reference that is reserved for the user. J.D. Edwards does not currently use this field and does not plan to use it in the future. | ||||
szUserId_USER | USER | char | OPT | NONE |
The code that identifies a user profile. | ||||
szProgramId_PID | PID | char | OPT | NONE |
The number that identifies the batch or interactive program (batch or interactive object). For example, the number of the Sales Order Entry
| ||||
szWorkStationId_JOBN | JOBN | char | OPT | NONE |
The code that identifies the work station ID that executed a particular job. | ||||
jdDateUpdated_UPMJ | UPMJ | JDEDATE | OPT | NONE |
The date that specifies the last update to the file record. | ||||
mnTimeOfDay_TDAY | TDAY | MATH_NUMERIC | OPT | NONE |
The computer clock in hours:minutes:seconds. | ||||
cSplitQuantityOverride_UOVR | UOVR | char | OPT | NONE |
cCacheName_EV01 | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event. | ||||
szDatabasePurchCostCenter_OMCU | OMCU | char | OPT | NONE |
The business unit from an account number. The account number business unit is usually found in the data item MCU, however, Distribution
| ||||
szDatabaseObjectAccount_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
| ||||
szDatabaseSubsidiary_SUB | SUB | char | OPT | NONE |
A subset of an object account. Subsidiary accounts include detailed records of the accounting activity for an object account. | ||||
cSourceOfRecord_EV01 | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event. | ||||
mnNumberOfCacheRecords_MATH01 | MATH01 | MATH_NUMERIC | OPT | NONE |
- - - Good Performance Low Value. | ||||
szCurrencyCodeFrom_CRCD | CRCD | char | OPT | NONE |
A code that identifies the currency of a transaction. | ||||
mnTableAmountOpen_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
| ||||
mnTableUnitsOpen_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
| ||||
mnTableTaxCommitment_FTN1 | FTN1 | MATH_NUMERIC | OPT | NONE |
The total tax amount committed to the PA ledger. The system uses this amount to relieve taxes at the committed rate. | ||||
mnTableUnitsTransQty_UORG | UORG | MATH_NUMERIC | OPT | INPUT |
The quantity of units affected by this transaction. | ||||
mnTableUnitsChgOrderQty_UCHG | UCHG | MATH_NUMERIC | OPT | NONE |
The number of units that are on hold. | ||||
mnTableUnitsLineItemQtyRe_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
| ||||
mnTableUnitsRelieved_URLV | URLV | MATH_NUMERIC | OPT | NONE |
This field contains the units that have been relieved from the total number of committed units. | ||||
mnTableAmountExtPrice_AEXP | AEXP | MATH_NUMERIC | OPT | NONE |
The number of units multiplied by the unit price. | ||||
mnTableAmountChange_ACHG | ACHG | MATH_NUMERIC | OPT | NONE |
The value of the units on hold. | ||||
mnTableAmountReceived_AREC | AREC | MATH_NUMERIC | OPT | NONE |
The value of the goods received to date against the original order line. | ||||
mnTableAmountRelieved_ARLV | ARLV | MATH_NUMERIC | OPT | NONE |
This field contains the amount that has been relieved from the total commitment amount. | ||||
mnTableTaxAmountRelieved_TRLV | TRLV | MATH_NUMERIC | OPT | NONE |
This field contains the amount of tax that has been relieved from the total tax commitment amount. | ||||
mnTableAmountForExtPrice_FEA | FEA | MATH_NUMERIC | OPT | NONE |
The product of the foreign price times the number of units. | ||||
mnTableForeignChgAmount_FCHG | FCHG | MATH_NUMERIC | OPT | NONE |
The change amount of a detail line on an Order. This is stated as the foreign change amount which is converted by the exchange rate
| ||||
mnTableAmountForeignOpen_FAP | FAP | MATH_NUMERIC | OPT | NONE |
The unpaid foreign amount of a transaction. | ||||
mnTableAmountReceivedFor_FREC | FREC | MATH_NUMERIC | OPT | NONE |
Amount - Received Foreign | ||||
mnTableForeignTaxAmount_CTAM | CTAM | MATH_NUMERIC | OPT | NONE |
The tax amount in foreign currency. This can be the sales, use, or VAT tax. | ||||
mnTableTaxForAmtRelieved_FTRL | FTRL | MATH_NUMERIC | OPT | NONE |
This field contains the amount of foreign tax that has been relieved. | ||||
szTableAccountId_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. | ||||
szTableSubledger_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
| ||||
cTableSubledgerType_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
| ||||
jdTableGLDate_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
| ||||
mnTableCentury_CTRY | CTRY | MATH_NUMERIC | OPT | NONE |
The calendar century associated with the year. Enter is the first two digits of
the year. For example, 19 indicates any year beginning with 19
| ||||
mnTableFiscalYear_FY | FY | MATH_NUMERIC | OPT | NONE |
A number that identifies the fiscal year. Generally, you can either enter a number in this field or leave it blank to indicate the current fiscal
| ||||
mnTablePeriodNumber_PN | PN | MATH_NUMERIC | OPT | NONE |
A number indicating the current accounting period. This number, used in conjunction with the Company Constants table (F0010) and the
|
None |
None |