Required Fields

The following fields are required in the F0411Z1 table:

Field Name

Alias

Type

Length

Definition

EDI - User ID

VLEDUS

Alpha

10

Enter the user ID of the person who runs the voucher batch process or the person who receives the messages in the work center. This field, in conjunction with the transaction number (VLEDTN), the batch number (VLEDBT), and the line number (VLEDLN), uniquely identifies a specific voucher.

EDI - Transaction Number

VLEDTN

Alpha

22

Enter the document number of the source system so that the transaction can be cross-referenced.

This field, in conjunction with the line number (VLEDLN), identifies each transaction. Each new transaction number indicates a new voucher. You cannot have more than one transaction with the same number in a batch unless the line number is different.

If the number assigned already exists in the F0411 table, the system returns an error message.

EDI - Line Number

VLEDLN

Number

7

Enter the pay item number only if a transaction has multiple pay items. If a transaction has only one pay item, you can leave this field blank.

This field is used in conjunction with the transaction number (VLEDTN) to identify each pay item of the voucher.

EDI - Successfully Processed

VLEDSP

Alpha

1

Enter 0.

The system completes this field to indicate whether the transaction was successfully processed using the batch processor. Blank or 0 (zero) indicates that the transaction was not processed or was processed in error. After the transaction is successfully processed, the system changes the value of the field to 1.

EDI - Transaction Action

VLEDTC

Alpha

1

Enter A in this field. No other values are valid.

EDI - Transaction Type

VLEDTR

Alpha

1

Enter V (for vouchers) in this field.

This field is a code that identifies a particular kind of transaction.

EDI - Batch Number

VLEDBT

Alpha

15

Enter a number to group transactions for processing.

This value, in conjunction with the transaction number (VLEDTN), the user ID (VLEDUS), and the line number (VLEDLN), uniquely identifies a transaction within a specific batch. This field also serves as a level break and causes the assignment of a new JD Edwards EnterpriseOne batch number each time that the value changes. To increase performance, assign one batch number for each group of transactions that are processed at one time.

Address Number

VLAN8

Number

11

Enter a number that identifies an entry in the Address Book system, such as employee, applicant, participant, customer, supplier, tenant, or location.

G/L Date

VLDGJ

Date

6

Enter the GL date in the format that your database accepts. Some databases allow you to enter the date in a Gregorian date format (mmddyy), while others might require a Julian date format.

The Julian date format is cyyddd (where c = century). Enter 0 (zero) for transactions in the 20th century and enter 1 for transactions in the 21st century. For example, the date June 1, 1999 corresponds to the Julian date 099152, and the date June 1, 2000 corresponds to the Julian date 100153 (because the year 2000 has a leap day, February, 29, 2000).

Alternatively, you can leave this field blank and complete the fields VLDGM (mm), VLDGD (dd), VLDGY (yy), and VLDG# (cc) in the month/day/year/century format. Enter the prefix of the year in the Century field (VLDG#). For example, enter 19 for 1999, or enter 20 for 2005.

Note that the voucher match automation process uses the GL date when determining the date range for the minimum and maximum dates of invoices to select for processing.

Company

VLCO

Alpha

5

Enter the number of the company to which the voucher belongs.

This number must exist in the F0010 table and must identify a reporting entity that has a complete balance sheet.

G/L Offset

VLGLC

Alpha

4

The value of this field, in conjunction with the company number (VLCO), determines the AP trade (offset) account to which the transaction is posted. The account established in the AAI item PCyyyy (where yyyy is the value in the G/L Offset field) is used in the post process. You can establish the AAI for each company or for company 00000 (as the default G/L Offset).

You complete this field only to direct different transactions to different offset accounts.

Gross Amount

VLAG

Number

15

Enter the transaction amount in the format that your database accepts. Some databases accept a decimal identifier while others do not.

If you enter the transaction in a foreign currency (Currency Mode F), leave this field blank and use the Currency Amount field (VLACR) instead.

If you process transactions using Currency Mode 3, you must complete both the Gross Amount and Currency Amount fields.

G/L Bank Account

VLGLBA

Number

8

Enter the bank account from which the voucher should be paid. Enter the account number in BU/Obj/Sub format. If you leave this field blank, the system uses the account that is set up in the AAI item PB for the company that is specified. If the AAI item for the company is not found, the system uses the AAI for company 00000.

Alternatively, enter the account ID (GMAID) of the bank account from which the voucher should be paid. The account ID is located in the F0901 table.

Business Unit

VLMCU

Alpha

12

Enter the business unit to which the voucher belongs. The value that you enter in this field must exist in the F0006 table. If you leave this field blank, the system uses the value in the Security Business Unit field (MCU) in the supplier's address book record.