D0000954 - Cache Process Prepayment Records
| Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both | 
|---|---|---|---|---|
| mnDocumentNumber | 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, 
  | ||||
| szOrderType | 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 
  | ||||
| szCompanyKeyOrderNumber | 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 
  | ||||
| szOrderSuffix | 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 | 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 
  | ||||
| mnSequenceNumber1 | SEQ | MATH_NUMERIC | OPT | NONE | 
A number that specifies the sequence of information.  | ||||
| szPrepaymentOriginationFlag | POF | char | OPT | NONE | 
This user defined code (00/PO) specifies the system from which prepayment originated, such as 01 indicates Sales Orde Entry.  | ||||
| cPaymentInstrument | RYIN | char | OPT | NONE | 
The user defined code (00/PY) that specifies how payments are made by the customer. For example:
C
Check  
D
Draft  
T
Electronic funds 
  | ||||
| szPrepaymentTransactionStatus | ATS | char | OPT | NONE | 
This field indicates the status of the prepayment transaction.  | ||||
| szPrepaymentErrorReasonCode | PERE | char | OPT | NONE | 
This user defined code (00/RP) that indicates the reason for invalid prepayment authorization or prepayment settlement.  | ||||
| jdAuthorizationTransactionDate | ATRD | JDEDATE | OPT | NONE | 
This date field indicates the date of prepayment authorization.  | ||||
| mnAuthorizationTransactionAmt | ATRM | MATH_NUMERIC | OPT | NONE | 
This amount of the prepayment credit card authorization.  | ||||
| jdAuthorizeExpiryDate | AEXD | JDEDATE | OPT | NONE | 
This field indicates an authorization expiration date.  | ||||
| jdSettleTransactionDate | SETD | JDEDATE | OPT | NONE | 
This date field indicates the date of prepayment settlement date.  | ||||
| mnSettleTransactionAmt | STRM | MATH_NUMERIC | OPT | NONE | 
This amount of the prepayment settlement.  | ||||
| mnSettleBatchNumber | SBTM | MATH_NUMERIC | OPT | NONE | 
Settle batch number.  | ||||
| jdSettlementDate | SEMD | JDEDATE | OPT | NONE | 
This date field indicates the date of the prepayment settlement.  | ||||
| szTransactionFeeCode | TRFC | char | OPT | NONE | 
This user defined code (00/FC) indicates the credit card transaction fee. For example, you can use daily, monthly, per transaction, or 
  | ||||
| szNameAlpha | ALPH | char | OPT | NONE | 
The text that names or describes an address. This 40-character alphabetic field appears on a number of forms and reports. You can enter 
  | ||||
| mnAddressNumber | 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 
  | ||||
| szAddressLine1 | ADD1 | char | OPT | NONE | 
The first line of a mailing address for an employee, customer, or supplier in the Address Book system. The U.S. Internal Revenue Service 
  | ||||
| szAddressLine2 | ADD2 | char | OPT | NONE | 
The second line of the mailing address for an employee, customer, or supplier in the Address Book system.
Attention Payroll users: The 
  | ||||
| szCity | CTY1 | char | OPT | NONE | 
A name that indicates the city associated with the address.  | ||||
| szState | ADDS | char | OPT | NONE | 
A user defined code (00/S) that specifies the state or province. This code is usually a postal service abbreviation.  | ||||
| szZipCode | MSZC | char | OPT | NONE | 
This field is used in the W-2 Magnetic Media S Record. It represents an employee's resident Zip Code.  | ||||
| szCountry | CTR | char | OPT | NONE | 
A user defined code (00/CN) that identifies a country. The country code has no effect on currency conversion.
The Address Book system 
  | ||||
| jdDateExpired | CEXP | JDEDATE | OPT | NONE | 
This field is to record the account number and expiration date of credit cards used by your customers who make purchases from you.  It is 
  | ||||
| szCreditCardType | CARD | char | OPT | NONE | 
This user defined code field (00/CA) indicates the type of credit card.  | ||||
| szDescription001 | DL01 | char | OPT | NONE | 
A user defined name or remark.  | ||||
| szCreditCardAccountNumber | CRCI | char | OPT | NONE | 
Credit card account number.  | ||||
| mnCashPaymentAmt | CASP | MATH_NUMERIC | OPT | NONE | 
This field indicates the amount that is prepaid with cash.  | ||||
| mnCheckPaymentAmt | CHKP | MATH_NUMERIC | OPT | NONE | 
This field indicates the amount that is prepaid with check.  | ||||
| szCkNumber | CKNU | char | OPT | NONE | 
For Auto Bank Statement, this code identifies the payment/receipt or reference number. 
NOTE:  
Bank Statement Detail section:  The 
  | ||||
| mnOtherPaymentAmt1 | OPY1 | MATH_NUMERIC | OPT | NONE | 
This field indicates the amount that is prepaid with alternate payment type.  | ||||
| mnOtherPaymentAmt2 | OPY2 | MATH_NUMERIC | OPT | NONE | 
This field indicates the amount that is prepaid with alternate payment type.  | ||||
| mnShipToAddress | 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, 
  | ||||
| szHeaderBranchPlant | EMCU | char | OPT | NONE | 
A business unit is an accounting entity required for management reporting. It can be a profit center, department, warehouse location, job, 
  | ||||
| szBranchPlant | 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 
  | ||||
| jdOrderTransactionDate | TRDJ | JDEDATE | OPT | NONE | 
The date that an order was entered into the system. This date determines which effective level the system uses for inventory pricing.  | ||||
| mnShortItemNumber | ITM | MATH_NUMERIC | OPT | NONE | 
An inventory item number. The system provides three separate item numbers plus an extensive cross-reference capability to other item 
  | ||||
| szLineType | 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 
  | ||||
| mnOrderedQuantity | UORG | MATH_NUMERIC | OPT | NONE | 
The quantity of units affected by this transaction.  | ||||
| szPaymentTerms | 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. 
  | ||||
| szTaxRateArea | 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 
  | ||||
| cSalesTaxableYN | 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 
  | ||||
| szTaxExplCode1 | 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 
  | ||||
| mnAmountTax2 | 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).  | ||||
| mnFutureUse0001 | FUT1 | MATH_NUMERIC | OPT | NONE | 
This field is for future use.  | ||||
| mnFutureUse0002 | FUT2 | MATH_NUMERIC | OPT | NONE | 
This field is for future use.  | ||||
| szFutureUse0003 | FUT3 | char | OPT | NONE | 
This field is for future use.  | ||||
| szFutureUse0004 | FUT4 | char | OPT | NONE | 
This field is for future use.  | ||||
| szFutureUse0005 | FUT5 | char | OPT | NONE | 
This field is for future use.  | ||||
| cFlagForFuture01 | FFG1 | char | OPT | NONE | 
This field is for future use.  | ||||
| cFlagForFuture02 | FFG2 | char | OPT | NONE | 
This field is for future use.  | ||||
| szUserReservedCode | 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 | 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 | 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 | 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 | 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.  | ||||
| szTransactionOriginator | TORG | char | OPT | NONE | 
The person who originally entered the transaction.  | ||||
| szProgramID | 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 
  | ||||
| mnMBFJobnumber | JOBS | MATH_NUMERIC | REQ | INPUT | 
The job number (work station ID) which executed the particular job.  | ||||
| szMBFComputerID | CTID | char | REQ | INPUT | 
| cCacheActionCode | ACTN | char | REQ | INPUT | 
A code that specifies the action that is performed. Valid values are: A Add C Change  | ||||
| mnNumberOfKeys | NKEYS | MATH_NUMERIC | REQ | INPUT | 
The number of keys in an index that will be used to retrieve, delete, or update a record.  | ||||
| cSuppressErrorMessage | SUPPS | char | OPT | INPUT | 
A flag indicating whether or not runtime error messaging will occur when an error message is issued from a business function.
       0 = allow 
  | ||||
| cSequentialFetch | EV01 | char | OPT | INPUT | 
An option that specifies the type of processing for an event.  | ||||
| idCacheCursorPointer | GENLNG | ID | OPT | BOTH | 
General purpose ID variable.  | ||||
| cCacheErrorCode | ERRC | char | OPT | OUTPUT | 
This error code indicates if any errors occurred during the creation of the Trip Document Detail (F4914) records by the Delivery Document 
  | ||||
| szErrorMessageID | DTAI | char | OPT | OUTPUT | 
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 
  | ||||
| szCurrencyCodeFrom | CRCD | char | OPT | NONE | 
A code that identifies the currency of a transaction.  | ||||
| szAcctNumberCreditBank | CBNK | char | OPT | NONE | 
The number assigned by a bank to identify the account for a company, customer, or supplier.
Note for Nordic users: Enter your bank, 
  | ||||
| szAuthorizeBatchNumber | ABTM | char | OPT | NONE | 
The batch number for the prepayment authorization.  | ||||
| mnTransactionFee | TFEE | MATH_NUMERIC | OPT | NONE | 
This amount indicates the credit card transaction fee. This is based on the transaction fee code.  | ||||
| szAuthorizeTransactionID | ATRI | char | OPT | NONE | 
This field indicates the identification number for authorization.  You can track your prepayment authorization transaction with this 
  | ||||
| B9800100 Get Audit Information | 
| F004201 Prepayment Transaction Table |