A Mapping Voucher Transactions to Batch Input Tables

This appendix contains the following topics:

A.1 Mapping Fields in the Voucher Transactions - Batch Upload Table (F0411Z1)

This section contains lists of fields in the F0411Z1 table that are either required, optional, ignored, or reserved for users. This section also contains lists of additional required fields for processing discounts, payments, taxes, and currency. The prefix for each alias field in the F0411Z1 table is VL.

A.1.1 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.

A.1.2 Optional Fields

Some fields in the F0411Z1 table are optional for batch voucher processing and are used with the first two tables. You can use the fields to provide additional information about vouchers. If you leave the field blank, the system will populate a value.

Review the optional fields:

Field Name Alias Type Length Definition
Account Mode - G/L VLAM Number 4 Enter a code from UDC H09/AM that specifies which of the three general ledger account numbers is being used for data entry.

Values are: 1 The short account ID number 2 The standard long account number 3 The long (unstructured, 24-byte) account number 7 The first character of the account number indicates the format of the account number You can also define special characters in the Accounting Constants file (F0009) to facilitate data entry. For example: / For the unstructured account number * For the short account ID number blank For the business unit.object.subsidiary number For example, if the account mode is 7 and the first character of the account number is *, the account number was entered as the short account ID number.

Amount Open - Foreign VLFAP Number 24 The unpaid foreign amount of a transaction.
Document Type - Original VLODCT Number 5 Enter user defined code from UDC 00/DT that identifies the origin and purpose of the original document.
Domestic Entry w/Mult Currency Distribution VLDMCD Number 4 An entry in this field indicates a domestic voucher or invoice was entered with a multi-currency distribution.
Date - Invoice - MO VLDIM Number 6 Enter the month of the invoice date. This may be either the date of the supplier's invoice to you or the date of your invoice to a customer.
Date - Invoice - DA VLDID Number 6 This is the days of the invoice date. This may be either the date of the supplier's invoice to you or the date of your invoice to a customer.
Date - Invoice - YR VLDIY Number 6 This is the year of the invoice date. This may be either the date of the supplier's invoice to you or the date of your invoice to a customer.
Date - Invoice - CTRY VLCTRY Number 6 The century on the invoice date. This may be either the date on the supplier's invoice to you or the date on your invoice to a customer.
Date - Service/Tax - MO VLDSVM Number 6 The service date is a memorandum date to record the date of actual field service or activity. If the date is left blank, in most instances the system will default it to the G/L date. Exceptions to this rule will result in an error message.
Date - Service/Tax - DA VLDSVD Number 6 The service date is a memorandum date to record the date of actual field service or activity. If the date is left blank, in most instances the system will default it to the G/L date. Exceptions to this rule will result in an error message.
Date - Service/Tax - YR VLDSVY Number 6 The service date is a memorandum date to record the date of actual field service or activity. If the date is left blank, in most instances the system will default it to the G/L date. Exceptions to this rule will result in an error message.
Date - Service/Tax - CTRY VLDSV# Number 6  
Date - Net Due - MO VLDDM Number 6 This is the date payment is due, regardless of whether the discount date may have already lapsed. For example, if the payment terms were 2/10, n/30, the due date would be 10 days after the invoice date. If left blank in invoice entry or voucher entry, this field will be computed automatically using the payment terms code from the screen. If the payment terms code on the screen is left blank, this field will be computed using the payment terms code from the Address Book master file (F0101) for that customer/supplier. This item is the month portion of the gregorian date.
Date - Net Due - DA VLDDD Number 6 This is the date payment is due, regardless of whether the discount date may have already lapsed. For example, if the payment terms were 2/10, n/30, the due date would be 10 days after the invoice date. If left blank in invoice entry or voucher entry, this field will be computed automatically using the payment terms code from the screen. If the payment terms code on the screen is left blank, this field will be computed using the payment terms code from the Address Book master file (F0101) for that customer/supplier. This item is the day portion of the gregorian date.
Date - Net Due - YR VLDDY Number 6 This is the date payment is due, regardless of whether the discount date may have already lapsed. For example, if the payment terms were 2/10, n/30, the due date would be 10 days after the invoice date. If left blank in invoice entry or voucher entry, this field will be computed automatically using the payment terms code from the screen. If the payment terms code on the screen is left blank, this field will be computed using the payment terms code from the Address Book master file (F0101) for that customer/supplier. This item is the year portion of the gregorian date.
Date - Net Due - CTRY VLDD# Number 6 This is the date payment is due, regardless of whether the discount date may have already lapsed. For example, if the payment terms were 2/10, n/30, the due date would be 10 days after the invoice date. If left blank in invoice entry or voucher entry, this field will be computed automatically using the payment terms code from the screen. If the payment terms code on the screen is left blank, this field will be computed using the payment terms code from the Address Book master file (F0101) for that customer/supplier. This item is the century portion of the gregorian date.
Date - Discount Due - MO VLDDNM Number 6 The last date that the discount on an invoice is available. For example, if payment terms are 2/10, net 30, the discount due date would be 10 days after the invoice date. This item is the month portion of the gregorian date.

If you leave the Discount Due Date field blank, the system automatically calculates the date using the payment terms code from the screen or, if there is no code on the screen, from the customer's Address Book Master file (F0101).

Date - Discount Due -DA VLDDND Number 6 The last date that the discount on an invoice is available. For example, if payment terms are 2/10, net 30, the discount due date would be 10 days after the invoice date. This item is the day portion of the gregorian date.

If you leave the Discount Due Date field blank, the system automatically calculates the date using the payment terms code from the screen or, if there is no code on the screen, from the customer's Address Book Master file (F0101).

Date - Discount Due - YR VLDDNY Number 6 The last date that the discount on an invoice is available. For example, if payment terms are 2/10, net 30, the discount due date would be 10 days after the invoice date. This item is the year portion of the gregorian date.

If you leave the Discount Due Date field blank, the system automatically calculates the date using the payment terms code from the screen or, if there is no code on the screen, from the customer's Address Book Master file (F0101).

Date - Discount Due - CTRY VLDDN# Number 6 The last date that the discount on an invoice is available. For example, if payment terms are 2/10, net 30, the discount due date would be 10 days after the invoice date. This item is the century portion of the Gregorian date.

If you leave the Discount Due Date field blank, the system automatically calculates the date using the payment terms code from the screen or, if there is no code on the screen, from the customer' s Address Book Master file (F0101).

Date - For G/L (and Voucher) - MO VLDGM Number 6 The date used for posting to the proper General Ledger fiscal period. The Company Constants file for the General Accounting system provides a table which defines date ranges for each accounting period. Accounting period 13 is used for 13 period accounting. Accounting period 14 is provided for those who do not want to use an extra accounting period for posting audit adjustments.

In all transaction processing, this date is edited for 'PBCO', 'PACO' and 'WACO' date warnings.

Date - For G/L (and Voucher) - DA VLDGD Number 6 The date used for posting to the proper General Ledger fiscal period. The Company Constants file for the General Accounting system provides a table which defines date ranges for each accounting period. Accounting period 13 is used for 13 period accounting. Accounting period 14 is provided for those who do not want to use an extra accounting period for posting audit adjustments.

In all transaction processing, this date is edited for 'PBCO', 'PACO' and 'WACO' date warnings.

Date - For G/L (and Voucher) - YR VLDGY Number 6 The date used for posting to the proper General Ledger fiscal period. The Company Constants file for the General Accounting system provides a table which defines date ranges for each accounting period. Accounting period 13 is used for 13 period accounting. Accounting period 14 is provided for those who do not want to use an extra accounting period for posting audit adjustments.

In all transaction processing, this date is edited for 'PBCO', 'PACO' and 'WACO' date warnings.

Date - For G/L (and Voucher) - CTRY VLDG# Number 6 The date used for posting to the proper General Ledger fiscal period. The Company Constants file for the General Accounting system provides a table which defines date ranges for each accounting period. Accounting period 13 is used for 13 period accounting. Accounting period 14 is provided for those who do not want to use an extra accounting period for posting audit adjustments.

In all transaction processing, this date is edited for 'PBCO', 'PACO' and 'WACO' date warnings.

Date - Batch - MO VLDICM Number 6 Enter the date of the batch. If you leave this field blank, the system uses the system date.
Date - Batch - DA VLDICD Number 6 Enter the date of the batch. If you leave this field blank, the system uses the system date.
Date - Batch - YR VLDICY Number 6 Enter the date of the batch. If you leave this field blank, the system uses the system date.
Date - Batch - CTRY VLDIC# Number 6 Enter the date of the batch. If you leave this field blank, the system uses the system date.
Transit Number - Bank VLTNST Number 23 The number assigned to a particular bank by the Federal Reserve to facilitate the clearing of funds.
Category Code - A/P Ledger 01 - Category Code - A/P Ledger 10 YC01 - YC10 Number 6 Reserved by J.D. Edwards.
Deferred Tax Status - VAT VLDTXS Number 4 Reserved by J.D. Edwards.
Currency Code - Base VLBCRC Number 6 Enter a code that represents the currency of the company for a transaction. For a foreign currency transaction, this is the currency code of the domestic side of the transaction.
Amount - To Distribute VLATAD Number 24 The amount of the transaction that must be posted to the general ledger for the transaction to balance. Depending on the tax information provided, the value of this field might be different from the gross or taxable amount of the transaction.

For example, if you enter a voucher for the taxable amount of 1000 CAD using tax explanation C (sales plus VAT), and the tax rate area is set up for 7% VAT and 3% Sales, the system calculates the amount to distribute as 1, 030 CAD (1000 + 30).

Amount - Currency To Distribute VLCTAD Number 24 For a journal entry with VAT, this represents the amount to be expensed in foreign currency.
Non-Recoverable Tax Amount VLNRTA Number 24 Enter the portion of the tax amount for which you cannot take a credit.
Foreign Non-Recoverable Tax VLFNRT Number 24 Enter the portion of the foreign tax amount for which you cannot take a credit.
Purchasing Taxable Y/N VLTAXP     A flag that indicates a voucher was created by the Procurement system (system 43).
Purge Flag VLPRGF     Reserved by J.D. Edwards.
Generic Flag 5 VLGFL5     Reserved by J.D. Edwards.
Generic Flag 6 VLGFL6     Reserved by J.D. Edwards.
Generic String 1 - Generic String 5 VLGEN1 - .VLGEN5   24 Reserved by J.D. Edwards.
Future - Withholding Tax Amount Domestic VLWTAD   24 Reserved for future use.
Future - Withholding Tax Amount Foreign VLWTAF   24 Reserved for future use.
Summarized Flag VLSMMF     A flag that indicates the voucher pay item was created by summarizing purchase order items.
Pay When Paid VLPYWP     This field is used to identify Pay When Paid transactions. Accounts Payable A 'W' will be used to identify Pay When Paid Voucher transactions.
Pay When Paid Group Number VLPWPG     This field is a number used to identify a record with a Pay When Paid group.
Netting Status Code VLNETST     Enter a user defined code (00/NS) that indicates the current netting status for a voucher or an invoice. Values are:

0: Ineligible for Netting

1: Approved for Netting

EDI - Detail Lines Processed VLEDDL Number 5 Specify the number of detail lines that are included in a specific transaction. This field is for user verification only.
Document Number VLDOC Number 8 Leave this field blank. If you leave this field blank, the system uses next numbers for system 04 to generate a document number that identifies the transaction in the F0411 table.

If you enter a value in this field, the value cannot exist in the F0411 table, or the transaction is considered a duplicate and is not processed. If you enter a value in this field, you must enter the same value in the corresponding field in the F0911Z1 table.

Note that the voucher match automation process uses the value in this field to overwrite the document number in the F0411 table.

Document Type VLDCT Alpha 2 Leave this field blank. If you leave this field blank, the value is determined by the processing options of the Voucher Entry MBF Processing Options program (P0400047), which specifies the type of transaction.

If you enter a value in this field, the value must exist in both UDC 00/DT (Document Type - All Documents) and UDC 00/DV (Document Type - Vouchers Only). If you enter a value in this field, you must enter the same value in the corresponding field in the F0911Z1 table.

Document Company VLKCO Alpha 5 Enter a code that identifies the company of the transaction. This field is used only to differentiate transaction numbers by company. If you leave this field blank, the system uses the value that you entered in the Company field (VLCO).

If you enter a value in this field, the value must exist in the F0010 table. Any value that you enter in this field must also be entered into the corresponding field in the F0911Z1 table.

Document Pay Item VLSFX Alpha 3 Leave this field blank. If you leave this field blank, the system assigns the pay item beginning with 001 to indicate the pay item number of the voucher. Use the Line Number field (VLEDLN) to designate transactions that have multiple pay items.

If the transaction number and the line number combination are duplicated, the system ignores the next and all subsequent transactions regardless of whether the Pay Item field is used.

If the tax constant Balance GL Distribution by Pay Item and Taxis enabled for the voucher company, this field is required.

Pay Item Extension Number VLSFXE Number 2 Leave this field blank. This field is updated by other systems that process records and store them in the F0411 table.

If the tax constant Balance GL Distribution by Pay Item and Taxis enabled for the voucher company, this field is required.

Adjusting Document Type VLDCTA Alpha 2 Leave this field blank. The system provides a code that is updated when processed vouchers are either changed or voided.
Payee Address Number VLPYE Number 8 Enter the address number that is used when a payee other than the supplier is paid. The value that you enter into this field must exist in the F0101 table.
Approver Address Number VLSNTO Number 8 Enter the address number that identifies the person who is authorized to approve a voucher for payment. The system uses this number in conjunction with payee approval; the Payee Approval field must contain a valid value.
Invoice Date VLDIVJ Date 6 Enter the invoice date in the format that your database accepts.

If you leave this field blank, the system uses the GL date. Refer to the data item for G/L Date (VLDGJ) for examples.

You can also leave this field blank and complete fields VLDIVM (mm), VLDIVD (dd), VLDIVY (yy), and VLDIV# (cc) in the month/date/year/century format. Enter the prefix of the year in the Century field (VLDIV#). For example, enter 19 for 1999 and 20 for 2005.

Fiscal Year VLFY Number 2 Leave this field blank. The system populates this field based on the GL date and the company to identify the fiscal year of the voucher.
Century VLCTRY Number 2 Leave this field blank. The system populates this field based on the GL date and the company to identify the century of the voucher.
Period Number VLPN Number 2 Leave this field blank. The system populates this field based on the GL date and the company to identify the fiscal period of the voucher.
Batch Number VLICU Number 8 Leave this field blank. If you leave this field blank, the system uses next numbers for system 00 to generate a batch number that it uses to group vouchers that are processed simultaneously.
Batch Type VLICUT Alpha 2 If you complete this field, you must enter V (voucher) to designate that the transaction is for a voucher. If you leave this field blank, the system populates the field with V when processing the vouchers.
Batch Date VLDICJ Date 6 If you leave this field blank, the system uses the date that the batch process program is run to identify the date that the batch was processed. If you complete this field, enter the date in a format that your database accepts. Refer to the field definition for G/L Date (VLDGJ) for more information about formats.

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

Balanced - Journal Entries VLBALJ Alpha 1 Leave this field blank. The system completes this field with a code that indicates whether the amounts of the journal entries that are associated with the transaction are in balance with the gross amount of the voucher.
Pay Status Code VLPST Alpha 1 If you leave this field blank, the system populates the field according to the value for the processing option for the Voucher Entry MBF Processing Options program (P0400047) to indicate whether the voucher is open, paid, or on hold. If you did not assign a value for the processing option, the system uses the default value of the data dictionary item PST.

The value of this field must exist in UDC 00/PS (Pay Status).

Amount Open VLAAP Number 15 Leave this field blank. The system automatically updates the Amount Open field (VLAAP) with the value in the Gross Amount field (VLAG) to identify the open amount of the voucher.

Processing partially paid vouchers is not supported by this application. If you enter a value in this field, you receive an error message, and the transaction is not processed.

G/L Posted Code VLPOST Alpha 1 Leave this field blank. The General Ledger Post program (R09801) updates this field with a code that identifies the posted status of the voucher.

If you previously processed historical data as a journal entry, you should create an associated F0911Z1 table transaction and use the AP trade account as the GL distribution account. Then, when the system posts the transaction, accounting will not be affected.

If you process posted voucher transactions out of balance (that is, without corresponding F0911Z1 table information), enter D in this field. However, by doing this, you compromise your ability to void these transactions in the future, and will create discrepancies on the AP batch integrity reports.

Object Account VLOBJ Alpha 6 The system does not validate this field. The system passes any value that you enter for the voucher into the F0411 table.
Subsidiary VLSUB Alpha 8 The system does not validate this field. The system passes any value that you enter for the voucher into the F0411 table.
Subledger Type VLSBLT Alpha 1 The system does not validate this field. The system passes any value that you enter for the voucher into the F0411 table.
Subledger VLSBL Alpha 8 The system does not validate this field. The system passes any value that you enter for the voucher into the F0411 table.
Void Flag VLVOD Alpha 1 Leave this field blank. The system populates this field with a code that identifies whether a voucher was voided when you void a voucher.
Document Company (Original Order) VLOKCO Alpha 8 The system does not validate this field. The system passes any value that you enter for the voucher into the F0411 table.

If you leave this field blank, the system updates it with the value that is assigned to the Document Company field in the F0411 table.

Document Type - Original VLODOC Alpha 2 The system does not validate this field. The system passes any value that you enter for the voucher into the F0411 table.

If you leave this field blank, the system updates it with the value that is assigned to the Document Type field in the F0411 table.

Document - Original VLOKCO Alpha 5 The system does not validate this field. The system passes any value that you enter for the voucher into the F0411 table.

If you leave this field blank, the system updates it with the values that is assigned to the Document Type field from the F0411.

Document Pay Item - Original VLOSFX Alpha 3 The system does not validate this field. The system passes any value that you enter for the voucher into the F0411 table.
Payment Handling Code VLCRC Alpha 3 Enter a value that exists in UDC 00/HC (Special Handling Code) to identify vouchers to segregate for payment processing or to provide additional information.
Supplier Invoice Number VLVINV Alpha 25 Enter a number to identify a supplier's invoice. Any value that you enter in this field passes to the corresponding F0411 table record. This field is not validated.
Document Company (Purchase Order) VLPKCO Alpha 5 The system does not validate this field. The system passes any value that you enter for the voucher into the F0411 table.
Purchase Order VLPO Alpha 8 The system does not validate this field. The system passes any value that you enter for the voucher into the F0411 table.
Document Type - Purchase Order VLPDCT Alpha 2 The system does not validate this field. The system passes any value that you enter for the voucher into the F0411 table.
Line Number VLLNID Number 6 The system does not validate this field. The system passes any value that you enter for the voucher into the F0411 table.
Order Suffix VLSFXO Alpha 3 The system does not validate this field. The system passes any value that you enter for the voucher into the F0411 table.
Unit VLUNIT Alpha 8 The system does not validate this field. The system passes any value that you enter for the voucher into the F0411 table.
Business Unit 2 VLMCU2 Alpha 12 The system does not validate this field. The system passes any value that you enter for the voucher into the F0411 table.
Name - Remark VLRMK Alpha 30 A code that provides an explanation for a voucher. Depending on how your processing options are set, this field might be printed on the payment.
Frequency - Recurring VLRF Alpha 2 Complete this field with a code to indicate the frequency of a recurring voucher only if the voucher is a recurring voucher that will be recycled. Documents that are generated with recurring information have the Document Type RR. The value that you enter in the Frequency Recurring field must exist in UDC H00/RF (Recurring Frequency).
Recurring Frequency # of Payments VLDRF Number 3 Complete this field with a number that indicates how many times a recurring voucher will be recycled only if the voucher is a recurring voucher that will be recycled. Documents that are generated with recurring information have the document type RR. The value that you enter in the Frequency Recurring field must exist in UDC H00/RF (Recurring Frequency).

If you enter 1, the system does not generate a new voucher.

Units VLU Number 15 The system does not validate this field. The system passes any value that you enter for the voucher into the F0411 table.
Unit of Measure VLUM Alpha 2 Enter a code to describe the type of units. The value that you enter must exist in UDC 00/UM (Unit of Measure).
Payment Instrument VLPYIN Alpha 1 Enter a code that indicates the type of payment with which to pay the voucher. The value that you enter in this field must exist in UDC 00/PY (Payment Instrument). If you leave this field blank, the system updates it with the corresponding value from the F0401 table when the voucher is processed.
Category Code - Address Book 7 VLAC07 Alpha 3 Enter a code to indicate the type of 1099 for which the voucher is eligible. The system uses this field to process 1099s. Any values that you enter should match the corresponding values on the 1099 form and exist in UDC 01/07.
Flag for 1099 VLTNN Alpha 1 Enter a code to indicate that the voucher is eligible for 1099 processing. This code is not used in JD Edwards EnterpriseOne software.
Item Number - Short VLITM Number 8 Enter a number to identify the inventory item. The system ignores any value that you enter in this field. The system does not validate values in this field.
Transaction Originator VLTORG Alpha 10 The system updates this field when the transaction is processed. Leave this field blank.
User ID VLUSER Alpha 10 The system updates this field when the transaction is processed. Leave this field blank.
Program ID VLPID Alpha 10 The system updates this field when the transaction is processed. Leave this field blank.
Date Updated VLUPMJ Date 6 The system updates this field when the transaction is processed. Leave this field blank.
Time Last Updated VLUPMT Number 6 The system updates this field when the transaction is processed. Leave this field blank.
Work Station ID VLJOBN Alpha 10 The system updates this field when the transaction is processed. Leave this field blank.

A.1.3 Ignored Fields

The system ignores the following fields in the F0411Z1 table:

Field Name Alias Type Length
Type Record VLEDTY Alpha 1
Record Sequence VLEDSQ Number 2
EDI - Document Type VLEDCT Alpha 2
EDI - Transaction Set Number VLEDTS Alpha 6
EDI - Translation Format VLEDFT Alpha 10
EDI - Transmission Date VLEDDT Date 6
EDI - Send/Receive Indicator VLEDER Alpha 1
Batch File Create G/L Record VLEDGL Alpha 1
User Address Number VLEDAN Number 8
Account ID VLAID2 Alpha 8
Bank Transit Short ID VLBAID Number 8
Sequence Number - Operations VLOPSQ Number 5
Control/Statement Field VLCTL Alpha 13
Closed Item - As Of Processing VLFNLP Alpha 1
Tax Rate/ Area 3 - Withholding VLTXA3 Alpha 10
Tax Expl Code 3 - Withholding VLEXR3 Alpha 2
A/R - A/P Miscellaneous Code 1 VLRP1 Alpha 1
A/R - A/P Miscellaneous Code 2 VLRP2 Alpha 1
Historical Currency Conversion Rate VLHCRR Number 15
Historical Date - Julian VLHDGJ Date 6
Historical Date - MO VLHDGM Number 2
Historical Date - DA VLHDGD Number 2
Historical Date - YR VLHDGY Number 2
Historical Date - CTRY VLHDG# Number 2
Reference VLVR01 Alpha 25

A.1.4 Fields Reserved for Users

The following fields in the F0411Z1 table are reserved for users. These fields are not updated by any JD Edwards EnterpriseOne program, nor are they displayed on any form in the JD Edwards EnterpriseOne Accounts Payable system:

Field Name Alias Type Length Definition
User Reserved Code VLURC1 Alpha 3 Enter any alphanumeric value up to three characters in length.
User Reserved Date VLURDT Date 6 Enter any date in this field. Use a format that your database accepts.

See the data item for G/L Date (VLDGJ) for more information about date formats.

User Reserved Amount VLURAT Number 15 Enter any amount in this field. Use a format that your database accepts.
User Reserved Number VLURAB Number 8 Enter any number up to eight digits in length.
User Reserved Reference VLURRF Alpha 15 Enter any alphanumeric value up to 15 characters in length.

A.1.5 Required Fields for Processing Discounts

The following fields in the F0411Z1 table are required for processing voucher discounts:

Field Name Alias Type Length Definition
Payment Terms Code VLPTC Alpha 3 Enter a payment terms code or leave this field blank.

The value that you enter in this field is validated against an entry in the Payment Terms (F0014) table. If the payment term is defined to calculate a discount, the system updates the Discount Available (VLADSC), Discount Due Date (VLDDNJ), and Net Due Date (VLDDJ) fields in the F0401 table accordingly.

If you leave this field blank and the supplier has a payment term in the F0401 table, the system uses the payment term from the Supplier Master table to determine the discount and the discount due date.

Discount Available VLADSC Number 15 Leave this field blank if you completed the Payment Terms Code field (VLPTC). The system calculates the discount amount and discount due date based on the value of the Payment Terms Code field (VLPTC). If the Payment Terms Code field is blank and the supplier has a payment term in the F0401 table, the system uses the payment term from the F0401 table to calculate the discount amount and the discount due date.

If you did not enter a payment term code, enter the amount of the discount in a format that your database accepts. Some databases accept a decimal identifier while others do not. If you enter a discount amount, you must also enter a discount due date (VLDDNJ).

You cannot enter the value in this field as a percent. For example, if you use USD currency, and you enter a value of .05, the system reads this as a five-cent discount.

Net Due Date VLDDJ Date 6 Leave this field blank if you completed the Payment Terms Code field (VLPTC). This field identifies the due date of the voucher regardless of whether a discount is available. The system automatically calculates the net due date when the voucher is processed. If you leave the Payment Terms Code field blank, and the supplier has a payment term in the F0401 table, the system uses the payment term from the F0401 table to determine the net due date (VLDDJ).

If you do not use a payment term, enter the net due date in a format that your database accepts. Refer to the data item for G/L Date (VLDGJ) for more information.

Alternatively, leave this field blank and complete the VLDDM (mm), VLDDD (dd), VLDDY (yy), and VLDD# (cc) fields in the month/day/year/century format. Enter the prefix of the year in the Century field (VLDD#). For example, enter 19 for 1999 and 20 or 2005.

Discount Due Date VLDDNJ Date 6 Leave this field blank if you completed the Payment Terms Code field (VLPTC). This field identifies the date through which a discount can be taken when the payment is issued. When vouchers are processed, this field is automatically populated based on the definition of the payment term. If you leave the Payment Terms Code field (VLPTC) blank, and the supplier has a payment term in the F0401 table, the system uses the payment term from the F0401 table to determine the Discount Available (VLADSC), Discount Due Date (VLDDNJ) and Net Due Date (VLDDJ) fields.

If you do not use a payment term, but you use the discount available, enter a date in the format that your database accepts. Refer to the data item for G/L Date (VLDGJ) for more information.

Alternatively, leave this field blank and complete the VLDDNM (mm), VLDDND (dd), VLDDNY (yy), and VLDDN# (cc) fields in the month/day/year/century format. Enter the prefix of the year in the Century field (VLDDN#). For example, enter 19 for 1999 and 20 for 2005.

Batch File Discount Handling Flag VLEDDH Alpha 1 Enter 1 in this field to process vouchers with discounts.
Discount Taken VLADSA Number 15 Leave this field blank. The system updates this field in the F0401 table when the payment is issued and the discount is taken.

A.1.6 Required Fields for Processing Payments

The following field is required for processing payments in the Voucher Transactions - Batch Upload table (F0411Z1).

You can process paid vouchers for the upload process if these vouchers meet two payment conditions:

  • Only one payment is allowed per voucher.

  • The payment amount must be for the total voucher amount.

Payment information is updated to the F0413 and F0414 tables.

Field Name Alias Type Length Definition
Matching Document Number VLDOCM Number 8 To process a paid voucher, enter the number of the payment that paid the voucher in full.

A.1.7 Required Fields for Processing Taxes

When populating the taxable, non-taxable and tax amount fields, you do not need to populate the gross amount (AG) field. The system calculates the gross amount based on the information in the tax amount fields. Conversely, if the gross amount field is populated, do not populate the taxable, non-taxable and tax amount fields.

If the tax information fields are not populated, but default values entered into the Supplier Master (F0401) table or the Business Unit Master (F0006) table, the system uses the default values (tax explanation code and/or tax rate area) to calculate taxes on vouchers unless the Bypass Tax Defaults processing option is activated.

Note:

The F0006 table only contains the field for Tax Rate Area. In order for this value to default into the record, enter a value in the Tax Explanation Code.

During tax processing, the system also uses the rules established in Tax Rules by Company program (P0022) to determine if the tax will be based on the gross amount, the amount less discount, etc. Verify the settings for Tax Rules by Company so taxes are calculated as desired.

To update the Sales, Use, VAT tax file (F0018), activate the Update Tax File processing option in the Post program before posting transactions.

Field Name Alias Type Length Definition
Taxable Amount VLATXA Number 15 Populate this field with the taxable amount of the voucher. If the total gross amount of the voucher is not taxable, enter the non-taxable portion of the voucher in the ATXN field. The taxable + non-taxable + tax amounts must equal the gross amount of the voucher.

Leave the gross amount field blank to have the system automatically calculate it based on the taxable and non-taxable amounts.

Non-Taxable Amount VLATXN Number 15 Enter the amount of the voucher that is not taxable. The taxable + non-taxable + tax amounts must equal the gross amount of the voucher.
Tax Amount VLSTAM Number 15 The amount of tax calculated for the voucher.

If you leave this field blank, the system calculates the tax amount based on values in the Amount - Taxable (ATXA), Tax Explanation Code (EXR1) and Tax Rate/Area (TXA1) fields.

Tax Rate/Area VLTXA1 Alpha 10 Enter a value that exists in the F4008 table. The tax rate/area determines the percent that the system uses to calculate tax and defines the taxing authority.
Tax Expl Code 1 VLEXR1 Alpha 1 Enter a value that exists in UDC table 00/EX. All values are hard-coded to perform tax calculations specific to the set up of the Tax Rate/Area and in conjunction with the Tax Rules by Company.
Service/Tax Date VLDSVJ Alpha 6 This date corresponds to the effective date used in the Tax Rate/Area. Enter this date in the format accepted by the database. See the data item for G/L Date (DGJ) for more information.

If you leave this field blank, the system uses the G/L date.

Alternatively, you can leave this field blank and populate the fields DSVM (mm), DSVD (dd), DSVY (yy), and DSV# (cc) in the month/day/year/century format. Enter the prefix of the year in the Century field (DSV#). For example, enter 19 for 1999 and 20 for 2005.


A.1.8 Required Fields for Processing Currency

This table identifies only the required fields in the F0411Z1 table for currency processing:

Field Name Alias Type Length Definition
Currency Mode VLCRRM Alpha 1 Enter a code used to designate whether the voucher is domestic or foreign. This field is used in conjunction with the Currency Code (CRCD), Gross Amount (AG), Currency Amount (ACR) and Currency Exchange Rate (CRR) fields to calculate whatever information is required for the transaction.

Enter D, F, or 3 depending on other information provided in the transaction.

If you leave this field blank, the system determines the value by the other information provided and is updated accordingly when the voucher is processed.

Currency Code VLCRCD Alpha 3 Enter a code that identifies the currency of the voucher. The value entered in this field must exist in the Currency Codes table (F0013).
Currency Amount VLACR Number 15 Enter the transaction amount in this field only if the value of the Currency Code (CRCD) field is different from the Currency Code assigned to the company, as defined in the Company Constants (F0010) table.
Exchange Rate VLCRR Number 15 The system uses this exchange rate to calculate either the domestic or foreign amount of the voucher depending on the information provided.

If this field is not populated and the Currency Mode (CRRM) is not 3, the system will use the exchange rate from the Exchange Rate table (F0015).

Enter an exchange rate to override the exchange rate established in the table, or if an exchange rate does not exist. If tolerance checking is activated via a processing option in the Master Business Function (P0400047), the exchange entered will be validated. If tolerance checking is not activated, no validation is performed.

Enter an exchange rate into the record if the Currency Mode (CRRM) is 3. When CRRM is 3, the exchange rate is not validated against the Exchange Rate table or the amounts entered on the transaction.

Foreign Discount Available VLCDS Number 15 Enter an amount or leave this field blank to calculate the discount based on the payment terms entered. If the payment term is blank, but one exists in the Supplier Master, the system calculates the discount based upon that payment term.

If the Currency Mode (CRRM) is 3 and a discount is available, enter amounts into the Foreign Discount Available (CDS) and Discount Available (ADSC) fields. The system does not perform calculations based upon a payment term.

Foreign Taxable Amount VLCTXA Number 15 The system calculates this field based upon the values in the Tax Rate/Area (TXA1), Tax Explanation Code (EXR1) and Currency Amount (ACR) fields. The system calculates the information that is not provided in the record. For example, if the Foreign Taxable Amount is entered, but the Currency Amount is blank, the system will calculate the Currency Amount.

Do not populate both the Currency Amount (ACR) and Foreign Taxable Amount (CTXA) fields.

Note that when you process transactions in foreign currency using the voucher match automation process, the process uses only the domestic currency fields to match F0411Z1 records to receipts and purchase orders.

Foreign Non-Taxable Amount VLCTXN Number 15 The system updates this field based on information in the Tax Rate/Area (VLTXA1), Tax Explanation Code (VLEXR1), and Currency Amount (VLACR) fields. The system calculates the amount that is not provided in the record. For example, if you enter the amount in the Foreign Taxable Amount field (VLCTXA) and you leave the Currency Amount field (VLACR) blank, the system calculates the currency amount. Do not complete both the Currency Amount (VLACR) and Foreign Taxable Amount (VLCTXA) fields. If the Currency Mode field (VLCRRM) is D, do not complete the Foreign Taxable Amount, Foreign Non-Taxable Amount, and Foreign Tax Amount fields. Instead, use the Taxable Amount (VLATXA), Non-Taxable Amount (VLATXN), and Tax Amount (VLSTAM) fields.
Foreign Tax Amount VLCTAM Number 15  
Domestic Entry w/Mult Currency Distr VLDMCD Alpha 1 If the distribution accounts in the F0911Z1 are for a company with a different currency than the company entered into the F0411Z1 record, activate the Multicurrency Intercompany Settlement function in the General Accounting Constants (F0009) table and update this field with a value of 1.

If you are not using Multicurrency Intercompany Settlements, leave this field blank.

Foreign Open Amount VLACR Number 15 The unpaid foreign amount of a transaction.

Leave this field blank. The system populates this field when the transaction is processed.

Amount - Foreign Discount Taken VLCDSA Number 24 The amount of the discount, expressed in the foreign currency of the transaction, that was taken or granted during the application of a payment to an open invoice or voucher.
Foreign Discount Taken VLDSA Number 15 The amount of the discount, expressed in the foreign currency of the transaction, that was taken or granted during the application of a payment to an open invoice or voucher.

Leave this field blank. The system updates this field when a payment is issued for a voucher containing an amount in the Foreign Discount Available field (CDS).


A.1.9 Fields Reserved for Voucher Match Automation

The following fields in the F0411Z1 table are used in the voucher match automation (VMA) process. This process enables you to set up and run an automated process to perform a 3-way voucher match for receipts, and to create vouchers and redistribute amounts for logged vouchers.

Field Name Alias Type Length Definition
Automation Flag ATFLG Alpha 1 The system uses this flag to determine if the record can be processed by the voucher match automation process.Valid values are:

Blank - Voucher match automation not enabled

1 - Voucher match automation enabled

Automation rule ATRL   2 These rules determine the guidelines that the process uses to match invoice lines to receipts. Possible values are:

01: Exact Match of Invoice Line to Purchase Order Line to Receipt Line

02: Match of Invoice Line to Receipt Line, Standard Tolerance Applied

03: Match of Invoice Line to Purchase Order Line to Multiple Receipt Lines, Standard Tolerance Applied

04: Exact Match of Invoice Line to Receipt Line

05: Match of Invoice Line to Purchase Order Line to Multiple Receipt Lines, Rounding Tolerance Applied

See "Automation Rules" in the JD Edwards EnterpriseOne Applications Procurement Management Implementation Guide.

Job Number JOBS     Indicates the workstation ID that runs a particular job.
Process Type PSTE   1 Indicates the status of the invoice in the voucher match automation process. Valid values are:

1: Invoice ready to match

2: Logged voucher created/ready to match

4: Match complete

You must set this field to value 1. Otherwise, the process ignores the record.


A.2 Mapping Fields in the Journal Entry Transactions - Batch File Table (F0911Z1)

This section contains a list of the required fields and ignored fields for processing batch vouchers in the F0911Z1 table. This section also contains lists of the required fields for using the JD Edwards EnterpriseOne Advanced Cost Accounting system and the required fields for using the JD Edwards EnterpriseOne Advanced Cost Accounting System to analyze profitability. The prefix for each alias field in the F0911Z1 table is VN

A.2.1 Required Fields

This table identifies only the required fields that you must complete. The system populates the remaining required fields based on information in the F0411Z1 table for the transaction.

The values that you enter in these fields must exactly match the values that you entered in the corresponding fields in the F0411Z1 table:

Field Name Alias Type Length
EDI - User ID VNEDUS Alpha 10
EDI - Transaction Number VNEDTN Alpha 22
EDI - Successfully Processed VNEDSP Alpha 1
EDI - Transaction Action VNEDTC Alpha 1
EDI - Transaction Type VNEDTR Alpha 1
EDI - Batch Number VNEDBT Alpha 15
EDI - Line Number VNEDLN Number 7
Company VNCO Alpha 5
G/L Date VNDGJ Date 6
Line Extension Code VNEXTL   5
Account Number VNANI Number 29
Account Mode VNAM Number 1
Account ID VNAID Alpha 8
Business Unit VNMCU Alpha 12
Object Account VNOBJ Alpha 6
Subsidiary VNSUB Alpha 8
Ledger Type VNLT Alpha 2
Amount VNAA Number 15
Name - Alpha Explanation VNEXA    
Amount - Gross VNAG Number 15
Track Taxes Flag VNTKTX    
Distribution Line Number VNDLNID    
Receipt Number VNCKNU    

A.2.2 Optional Fields

Field Name Alias Type Length
Document Company VNKCO Alpha 5
Document Type VNDCT Alpha 2
Document Number VNDOC Number 8
Batch Number VNICU Number 8
Batch Type VNICUT Alpha 1
Date - Batch (Julian) VNDICJ Date 6
Date - Batch System Date VNDSYJ Date 6
Batch Time VNTICU    
EDI - Send/Receive Indicator VNEDER Alpha 1
Journal Entry Line Number VNJELN    
Subledger - G/L VNSBL Alpha 1
Subledger Type VNSBLT Alpha 1
Period Number - General Ledger VNPN Number 2
Century VNCTRY Number 6
Fiscal Year VNFY Number 2
Units VNU Number 15
Unit of Measure VNUM Alpha 2
G/L Offset VNGLC Alpha 4
Reverse or Void (R/V) VNRE    
Name - Remark Explanation VNEXR    
Reference 1 - JE, Voucher, Invoice, etc. VNR1    
Reference 2 VNR2    
Document Pay Item VNSFX Alpha 3
Document - Original VNODOC Number 11
Document Company (Purchase Order) VNPKCO Alpha 5
Document Company (Original Order) VNOKCO Alpha 8
Document Type - Purchase Order VNPDCT Alpha 2
Address Number VNAN8 Number 11
Payment Number VNCN    
Date - Check - Julian VNDKJ    
Date - Check Cleared VNDKC    
Serial Number VNASID    
Batch Rear End Posted Code VNBRE    
Reconciled Code VNRCND    
Summarized Code VNSUMM    
Purge Code VNPRGE    
Flag for 1099 VNTNN Alpha 1
G/L Posting Code - Alternate 1 through G/L Posting Code - Alternate 5 VNALT1 through VNALT5    
G/L Posting Code - Cash Basis Acct VNALT6    
Commitment Relief Flag VNALT7    
Billing Control VNALT8    
Currency Update VNALT9    
G/L Posting Code - Alternate 0 VNALT0    
G/L Posted Code VNPOST Alpha 1
Consumption Tax Cross Reference VNALTX    
Delete Not Allowed VNDLNA    
Client Free Form - Alternate 1 and Client Free Form - Alternate 2 VNCFF1 and VNCFF2    
Lease Cost Ledger Posted Code VNASM    
Bill Code VNBC    
Supplier Invoice Number VNVINV Alpha 25
Date - Invoice VNIVD    
Categories - Work Order 01 VNWR01    
Purchase Order VNPO Alpha 8
Purchase Order Suffix VNPSFX    
Order Type VNDCTO    
Line Number VNLNID Number 6
Fiscal Year - Weekly VNWY    
Fiscal Period - Weekly VNWN    
Job Type (Craft) Code VNJBCD    
Job Step VNJBST    
Business Unit - Home VNHMCU    
DOI Sub VNDOI    
ID Type VNALTY    
Date - Service/Tax VNDSVJ Alpha 6
Outsider Lease or Well ID VNALID    
Date - For G/L (and Voucher) - MO VNDGM Number 6
Date - For G/L (and Voucher) - DA VNDGD Number 6
Date - For G/L (and Voucher) - YR VNDGY Number 6
Date - For G/L (and Voucher) - CTRY VNDG# Number 6
Date - Batch - MO VNDICM Number 6
Date - Batch - DA VNDICD Number 6
Date - Batch - YR VNDICY Number 6
Date - Batch - CTRY VNDIC# Number 6
Date - Batch System Date - MO VNDSYM    
Date - Batch System Date - DA VNDSYD    
Date - Batch System Date - YR VNDSYY    
Date - Batch System Date - CTRY VNDSY#    
Date - Check - MO VNDKM    
Date - Check - DA VNDKD    
Date - Check - YR VNDKY    
Date - Check - CTRY VNDK#    
Date - Service/Tax - MO VNDSVM Number 6
Date - Service/Tax - DA VNDSVD Number 6
Date - Service/Tax - YR VNDSVY Number 6
Date - Service/Tax - CTRY VNDSV# Number 6
Date - Check Cleared - MO VNDKCM    
Date - Check Cleared - DA VNDKCD    
Date - Check Cleared - YR VNDKCY    
Date - Check Cleared - CTRY VNDKC#    
Date - Invoice - MO VNIVDM    
Date - Invoice - DA VNIVDD    
Date - Invoice - YR VNIVDY    
Date - Invoice - CTRY VNIVD#    
Currency Code - Base VNBCRC Number 6
Tax Expl Code 1 VNEXR1 Alpha 1
Tax Rate/Area VNTXA1 Alpha 10
Tax - Short Item Number VNTXITM    
Activity-Based Costing Activity Code VNACTB    
Amount - Tax VNSTAM Number 15
Amount - Foreign Tax VNCTAM Number 24
Burdening Posted Code VNBUPC    
Alternate Home Business Unit VNAHBU    
Employee Pool Grouping Code VNEPGC    
Job Pool Grouping Code VNJPGC    
File Line Identifier 5.0 VNRC5    
Pay Item Extension Number VNSFXE Number 2
Auto Offset Method (S, Y, or B) VNOFM    
EDI - Detail Lines Processed VNEDDL Number 5

A.2.3 Ignored Fields

The system ignores the following fields in the F0911Z1 table:

Field Name Alias Type Length
Type Record VNEDTY Alpha 1
Record Sequence VNEDSQ Number 2
EDI - Document Type VNEDCT Alpha 2
EDI - Transaction Set Number VNEDTS Alpha 6
EDI - Translation Format VNEDFT Alpha 10
EDI - Transmission Date VNEDDT Date 6
Batch File Create G/L Record VNEDGL Alpha 1
User Address Number VNEDAN Number 8
Sequence Number - Operations VNOPSQ Number 5
Closed Item - As Of Processing VNFNLP Alpha 1
Historical Currency Conversion Rate VNHCRR Number 15
Historical Date - Julian VNHDGJ Date 6
Historical Date - MO VNHDGM Number 2
Historical Date - DA VNHDGD Number 2
Historical Date - YR VNHDGY Number 2
Historical Date - CTRY VNHDG# Number 2
Reference 3 - Account Reconciliation VNR3    
Document Type - Original VNODCT Number 5
Document Pay Item VNOSFX Alpha 3

If the tax constant Balance GL Distribution by Pay Item and Taxis enabled for the invoice company, this field is required.

G/L Posting Code - Alternate T VNALTT    
G/L Posting Code - Alternate U VNALTU    
Stocked Inventory Commitment VNALTV    
G/L Posting Code - Alternate W VNALTW    
G/L Posting Code - Account Debit Balance VNALTZ    
Transaction Originator VNTORG Alpha 10
Registration Number VNREG#    
Payment ID (Internal) VNPYID    
User ID VNUSER Alpha 10
Program ID VNPID Alpha 10
Work Station ID VNJOBN Alpha 10
Date - Updated VNUPMJ Date 6
Time - Last Updated VNUPMT Number 6

A.2.4 Required Fields for Processing Currency

This table identifies the required fields in the F0911Z1 table for currency processing:

Field Name Alias Type Length
Currency Code - From VNCRCD Number 6
Currency Conversion Rate - Spot Rate VNCRR Number 19
Currency Mode-Foreign or Domestic Entry VNCRRM    
Amount - Currency VNACR Number 24
Amount - Foreign Gross VNAGF    

A.2.5 Required Fields When Using the Advanced Cost Accounting System

If you use the JD Edwards EnterpriseOne Advanced Cost Accounting system, you must complete these additional fields in the F0911Z1 table:

Field Name Alias Type Length Definition
Cost Object Type 1 - Cost Object Type 4 VNABT1 - VNABT4 Alpha 1 Enter up to four cost object types. The system uses these fields to edit the values that you enter in the corresponding cost object fields (VNABR1 - VNABR4). If you enter a value in one of the cost object type fields, you must enter a value in the corresponding cost object field. The values in the cost object type fields must exist in the F1620 table.
Cost Object 1 - Cost Object 4 VNABR1 - VNABR4 Alpha 12 Enter up to four cost objects. The value in each cost object field must adhere to the edit rules for the corresponding cost object type (VNABT1 - VNABT4).
Posting Code 1 - Posting Code 10 VNPM01 - VNPM10 Alpha 1 Leave these fields blank.
Item Number VNITM Number 8 If you enter a value in this field, the system validates it against the F4101 table.

A.2.6 Required Fields When Using the Advanced Cost Accounting System to Analyze Profitability

When using the Advanced Cost Accounting System to analyze profitability, you must populate additional fields in the Needed for upgrade for XE and below table (F0911Z1T). The system updates these additional values into the corresponding Account Ledger Tag File table (F0911T). If you do not use track profitability, you do not have to complete any fields in the F0911Z1T table.

Field Name Alias Type Length Definition
EDI - User ID VNEDUS Alpha 10 The value in this field must match the value entered in the corresponding field in the F0411Z1 and F0911Z1 tables.
EDI - Transaction Number VNEDTN Alpha 22 The value in this field must match the value entered in the corresponding field in the F0411Z1 and F0911Z1 tables.
EDI - Batch Number VNEDBT Alpha 15 The value in this field must match the value entered in the corresponding field in the F0411Z1 and F0911Z1 tables.
EDI - Line Number VNEDLN Number 7 The value in this field must match the value entered in the corresponding field in the F0411Z1 and F0911Z1 tables.
Cost Object Type 1 - Cost Object Type 4 VNABT1 - VNABT4 Alpha 1 Enter up to four cost object types. The system uses these fields to edit the values entered in the corresponding Cost Object fields (ABR1 - ABR4). If you enter a value in one of the Cost Object Type fields, you must enter a value in the corresponding Cost Object field. The values in the Cost Object Type fields must exist in the Cost Object Types table (F1620).
Cost Object 1 - Cost Object 4 VNABR1 - VNABR4 Alpha 12 Enter up to four cost objects. The value in each Cost Object field must adhere to the edit rules for the corresponding values in the Cost Object Type fields (ABT1 - ABT4).
Posting Code 1 - Posting Code 10 VNPM01 - VNPM10 Alpha 1 Leave this fields blank.
Item Number VNITM Number 8 If you enter a value in this field, the system validates it against the Item Master table (F4101).

A.3 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.