1. General Accounting Implementation Guide
  2. Detail Area Fields

Detail Area Fields

TR CD (transaction code)

Enter a valid code from UDC table 09/BJ to identify the type of transaction on a bank statement.

Value Date

Enter the date that the payment amount was debited or credited to the bank account. The value date is not the date that the bank reconciled the payment. Automatic payments populate this field automatically.

If the Value Date processing option is 0, the system uses the default GL date from the header area for this field. If it is1, the system uses the statement date.

G/L Date

Enter the GL date or the bank statement date.

If the G/L Date processing option is 0, the system uses the default GL date from the header area in this field. If it is 1, the system uses the statement date.

Pmt/Rcpt Number (payment/receipt number)

Based on the transaction code in the TR CD field, do one of the following:

CR: Enter the batch number of the receipt. The system validates this number to verify whether the receipt batch number exists.

CK: Enter the number of the payment. The Bank Journal Statement Process program uses this number to locate the payment record in the F0911 table when reconciling the transaction.

JE: Leave this field blank.

CRE or CRI: Enter the number of the receipt from the bank statement. The system does not validate either number against any other tables in JD Edwards EnterpriseOne.

DP: Enter the payment number of the draft paid to the supplier.

PWM or PWO: Leave this field blank. The system uses the number that you enter for the payment.

Ty (type)

Enter the code from UDC table 00/DT that specifies the kind of document that the system uses to match the original document. If you entered a default document type for the transaction code in a processing option, the system uses it as the default.

G/L Posted Code

A code that designates the processed and reconciled status of a bank statement transaction. This code represents the G/L posted code status of F0917 records as well as the reconciliation status of F0917 and F0911 records.

For unprocessed or unreconciled records, the G/L Posted Code field in the F0917 table is A and the Reconciled field is blank.

For processed or reconciled records, valid codes are specified in the processing options for the Bank Journal Statement Process program (R09170). These codes are edited against UDC table 09/RC. For reconciled records, the code in the G/L Posted Code field is the same as the code in the Reconciled field for both the F0917 and F0911 tables.

After you enter a transaction on the Enter Statement form and click OK or select Detail from the Row menu, the system displays one of the following, based on a processing option setting:

  • If the Editing Mode processing option is 1 or 2, the system displays the detail form that corresponds to the transaction code that you entered. If you entered CR, the system displays the Clear Receipts form. If you entered CK, the system displays the Clear Payment form and so on.

    If the Editing Mode processing option is 2, the system also performs editing if you enter an invalid value or leave required fields blank on the detail form.

    Default values for some fields on the detail form are specified in processing options for the Bank Statement Entry program.

  • If the Editing Mode processing option is 0, the system does not display a detail form. Instead, it displays the warning message Incomplete Transactions Exist. Click OK and then Cancel. You must remember to enter the detail at another time.