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.