Mapping Fields in the Voucher Transactions Batch Upload - Voucher Match Automation Table (F0411Z1T)

This section contains selected fields in the F0411Z1T table. You must populate the fields listed in this section if you require that item information is used to match receipt lines to invoice lines when you use the voucher match automation (VMA) process. You set an option in the suppler master record to require item information.

Though the VMA process requires data for these fields only when you require item information, Oracle recommends that you populate this table at the same time that you populate the F0411Z1 table with the supplier invoice records that you use for the VMA process.

See "Populate the Voucher Transaction Batch Upload - Voucher Match Automation Table (F0411Z1T)" in the JD Edwards EnterpriseOne Applications Procurement Management Implementation Guide.

Field Name

Alias

Type

Length

Definition

User ID

EDUS

Numeric

10

The value in this field must match the value entered in the corresponding field in the F0411Z1 table.

Batch Number

EDBT

Numeric

15

The value in this field must match the value entered in the corresponding field in the F0411Z1 table.

Transaction Number

EDTN

Numeric

22

The value in this field must match the value entered in the corresponding field in the F0411Z1 table.

Line Number

EDLN

Numeric

7

The value in this field must match the value entered in the corresponding field in the F0411Z1 table.

Short Item Number

ITM

Alpha Numeric

8

A value for item information is required only if the supplier master record indicates that item information is required to match a receipt to an invoice.

When you require item information, you can complete this field; or complete the 2nd Item Number or Item Number - Customer/Supplier field. When you complete the 2nd Item Number or Item Number - Customer/Supplier field instead of the Short Item Number field, the system retrieves the short item number when you process records using the voucher match automation process.

2nd Item Number

LITM

Alpha Numeric

8

A value for item information is required only if the supplier master record indicates that item information is required to match a receipt to an invoice.

If you complete the 2nd Item Number or Item Number - Customer/Supplier field instead of the Short Item Number field, the system retrieves the short item number when you process records using the voucher match automation process.

Item Number - Customer/Supplier

CITM

Alpha Numeric

A value for item information is required only if the supplier master record indicates that item information is required to match a receipt to an invoice.

If you complete the 2nd Item Number or Item Number - Customer/Supplier field instead of the Short Item Number field, the system retrieves the short item number when you process records using the voucher match automation process.

Invoice Match Status

STAVM

Numeric

1

When you use the voucher match automation process, the process uses this field to track the status of the invoice. When you create the F0411Z1T record, this field must be blank.

(Release 9.2 Update) Future Use String 4 FUSS4 String 30 When you use the voucher match automation process, the process uses this field to store the expense account to which the system will charge the invoice fee. You must enter all eight digits of the account ID of the expense account for the system to recognize the expense account.