This appendix contains the following topics:
Section A.1, "Mapping Fields in the Voucher Transactions - Batch Upload Table (F0411Z1)"
Section A.2, "Mapping Fields in the Journal Entry Transactions - Batch File Table (F0911Z1)"
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.
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. (Release 9.1 Update) 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. |
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. (Release 9.1 Update) 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. |
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 |
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. |
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. |
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. |
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. |
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. (Release 9.1 Update) 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). |
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 |
|
| 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. |
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
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 |
| 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 |
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 |
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 |
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. |
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). |
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.
| 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. |