This appendix contains the following topics:
Section B.2, "Mapping Fields in the F0911Z1 Table for Burdening"
Section B.3, "Mapping Fields in the F0911Z1 Table for Advanced Cost Accounting"
Section B.4, "Mapping Fields in the F0911Z1 Table for Externally Reconciled Transactions"
This section contains a list of the fields in the Journal Entry Transactions - Batch File (F0911Z1). These fields are required to run the Journal Entries Batch Processor program (R09110Z). Zero or blank is a value for some fields; however, null is not a valid value. Not all fields are displayed on General Accounting forms or used by the JD Edwards EnterpriseOne General Accounting system.
This table lists the required fields in the F0911Z1 table:
| Field Name | Alias | Type | Length | Definition |
|---|---|---|---|---|
| EDI - User ID | VNEDUS | Alpha | 10 | Enter the user ID of the person who is running the process or the person who is to receive messages in the Employee Queue Manager program (P012501). This field, with VNEDTN, VNEDBT, and VNEDLN, uniquely identifies a specific journal entry. |
| EDI - Transaction Number | VNEDTN | Alpha | 22 | Enter a value that, with VNEDLN, identifies each transaction. Each new transaction number indicates a new journal entry. You can have only one transaction with the same number in a batch unless VNEDLN is different. This field normally contains the document number of the source system so that the transaction can be readily identified. |
| EDI - Line Number | VNEDLN | Number | 7 | Enter a value that, with VNEDTN, identifies each line of the journal entry. |
| EDI - Successfully Processed | VNEDSP | Alpha | 1 | Enter a value that indicates whether a record has been processed successfully. Update this field with a value of 0. If the record is processed successfully, the system updates this field to a value of 1. If an error occurs, the system leaves 0 in the field. Do not leave this field blank. |
| EDI - Transaction Action | VNEDTC | Alpha | 1 | Enter A for transactions to be processed. No other values are valid. |
| EDI - Transaction Type | VNEDTR | Alpha | 1 | Enter J for journal entries. You cannot leave this field blank. |
| EDI - Batch Number | VNEDBT | Alpha | 15 | Enter a value that, with VNEDTN, VNEDUS, and VNEDLN, uniquely identifies a transaction within a specific batch. This field also acts as a level break and causes the assignment of a new batch number each time that the value changes. You can greatly increase performance by assigning one batch number for each group of transactions that is being processed at one time. |
| G/L Date | VNDGJ | Date | 6 | Enter a value that indicates the date of the transaction. This field is part of the header section of the journal entry; therefore, you can enter only one value for each document.
Enter the general ledger 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 (cyyddd, where c= century). Enter 0 for transactions in the 20th century and enter 1 for transactions in the 21st century. For example, the date June 1, 2007 corresponds to the Julian date 107152 and the date June 1, 2008 corresponds to the Julian date 108153 (because the year 2008 has a leap day, February 29). Alternatively, you can leave this field blank and complete VNDGM (mm), VNDGD (dd), VNDGY (yy), and VNDG# in the month/day/year/century format. Enter the prefix of the year in VNDG#. For example, enter 20 for 2007. |
| Account Number | VNANI | Alpha | 29 | A value that represents the account number that you want to update when you process the transaction. Complete either VNANI or VNAID, or VNMCU, VNOBJ, and VNSUB to designate the account number.
The first character in the VNANI field must correspond to the Symbol to Identify the Account Number in the F0009 table. For example, if the Symbol to Identify the Short Number is * and you want to enter the Short Number in VNANI, you must precede it with *. Otherwise, leave VNANI blank and enter the Short Number in VNAID. The system populates the fields that you leave blank, based on the account information that you enter. For example, if you complete the Business Unit, Object, and Subsidiary fields, the system updates the Account ID and Account Number fields when the transaction is processed. If you complete the Account Number field, the system updates the Business Unit, Object, Subsidiary, and Account ID fields when the transaction is processed. |
| Account ID | VNAID | Alpha | 8 | Enter a value that represents the identifier of the account that you want to update when you process the transaction. Complete either VNANI or VNAID, or VNMCU, VNOBJ, and VNSUB to designate the account number. |
| Business Unit | VNMCU | Alpha | 12 | Enter a value that helps identify the account number that you want to update when you process the transaction. Complete either VNANI or VNAID, or VNMCU, VNOBJ, and VNSUB to designate the account number. |
| Object Account | VNOBJ | Alpha | 6 | Enter a value that helps identify the account number that you want to update when you process the transaction. Complete either VNANI or VNAID, or VNMCU, VNOBJ, and VNSUB to designate the account number. |
| Amount - Tax | VNSTAM | Number | 15 | Enter the tax amount for journal entries with VAT. This amount is passed to the tax calculator for validation and calculation. If the Rate/Rate Area and Tax Explanation Code fields are not passed, this field is ignored. |
| Amount - Gross | VNAG | Number | 15 | Enter the gross amount for journal entries with VAT. This amount is passed to the tax calculator for validation and calculation. If the Rate/Rate Area and Tax Explanation Code fields are not passed, this field is ignored. |
| Track Taxes Flag | VNTKTX | Character | 1 | Specify whether to update tax information for the account taxed in the F0911. The value 1 updates tax explanation code, tax rate/area and tax item. |
| Distribution Line Number | VNDLNID | Number | 6 | Enter a value for the GLDLNID field in the F0911 table. The system does not perform any validation or formatting on the value in this field. |
| Check/Receipt Number | VNCKNU | String | 25 | Enter a value for the GLCKNU field in the F0911 table. The system does not perform any validation or formatting on the value in this field. |
| Subsidiary | VNSUB | Alpha | 8 | A value that helps identify the account number that you want to update when you process the transaction. Complete either VNANI or VNAID, or VNMCU, VNOBJ, and VNSUB to designate the account number. |
| Account Mode | VNAM | Alpha | 1 | Enter a value that directs the system to read a specific field to locate the account number. Values are:
1: Use the value in the VNAID field. 2: Use the value in the VNANI field. 3: Use the value in the VNANI field, but this value must be the third account number, as defined in the general accounting constants. 4: Use the values assigned in VNMCU, VNOBJ, and VNSUB. 7: Use the value in VNANI, but use the character in the first position of the VNANI field to identify the format in which the account number was entered, as defined in the general accounting constants. For example, if the value in VNANI is #123, the system uses the account number format that is represented by # in the general accounting constants. |
| Amount | VNAA | Number | 15 | Enter a value that represents the amount of the transaction. Enter the amount in the format that your database accepts. Some databases accept a decimal identifier, while others do not. If you are entering a foreign currency amount, leave this field blank and enter an amount in VNACR. |
| Explanation | VNEXA | Alpha | 30 | Enter a description of the transaction.
This field is part of the header section of the journal entry. Therefore, you can enter only one value for each document. |
| Company | VNCO | Alpha | 5 | Enter the number of the company for which you are processing the transaction. This is required for multicurrency processing. |
See Also
This section lists the fields in the Journal Entry Transactions - Batch File (F0911Z1) that are used for burdening.
This table lists the fields in the F0911Z1 table that are used by burdening:
| Field Name | Alias | Type | Length | Definition |
|---|---|---|---|---|
| Alternate Home Business Unit | AHBU | Number | 12 | Enter the number of the business unit in which the employees generally work. |
| Job Type | JBCD | String | 6 | Enter a code from UDC table 06/G that identifies a job within your organization. The job type must be valid for the contract assigned to the job master. |
| Job Step | JBST | String | 4 | Enter a code from UDC table 06/GS that identifies a specific level within a job type. |
| Employee Pool Grouping Code | EPGC | String | 3 | Enter a code from UDC table 00/12 that identifies the pool grouping. |
| Job Pool Grouping Code | JPGC | String | 3 | Enter a code from UDC table 00/12 that identifies the pool grouping. |
| Burdening Posted Code | BUPC | Character | 1 | Values are:
blank or 0: Unposted 1: Posted |
See Also
This section discusses how to map fields in the F0911Z1 table for the Advanced Cost Accounting system.
If you use the Advanced Cost Accounting system, this table lists the fields in the F0911Z1 table that are required:
| Field Name | Alias | Type | Length | Information |
|---|---|---|---|---|
| Cost Object Type 1– 4 | VNABT1 VNABT2 VNABT3 VNABT4 | Alpha | 1 | Enter up to four cost object types. The system uses these fields to edit the values entered in the corresponding 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–4 | VNABR1 VNABR2 VNABR3 VNABR4 | Alpha | 12 | Enter up to four cost objects. The value in each Cost Object field must follow the edit rules for the corresponding VNABT1 - VNABT4. |
| Posting Code 1–10 | VNPM01– VNPM10 | Alpha | 1 | Leave these fields blank. |
| Item Number | VNITM | Number | 8 | If you enter a value in this field, the system verifies that the item exists in the F4101 table. |
You can use optional fields to provide additional information about the journal entries. This table lists the fields in the F0911Z1 table are optional:
| Field Name | Alias | Type | Length | Definition |
|---|---|---|---|---|
| EDI - Detail Lines Processed | VNEDDL | Number | 5 | Enter the number of detail lines that are included in a specific transaction. For user verification only. |
| EDI - Transaction Type | VNEDTR | Alpha | 1 | Enter J for journal entry transactions or leave this field blank. |
| Document Company | VNKCO | Alpha | 5 | Enter a number 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 value is determined by the company that is associated with the business unit of the first journal entry line.
If you enter a value in this field, the value must exist in the F0010 table. This field is part of the header section of the journal entry. Therefore, you can enter only one value for each document. |
| Document Type | VNDCT | Alpha | 2 | Enter a code that identifies the type of transaction. If you leave this field blank, the system uses JE.
If you enter a value in this field, the value must exist in user-defined code (UDC) table 00/DT. This field is part of the header section of the journal entry. Therefore, you can enter only one value for each document. |
| Document Number | VNDOC | Number | 8 | Enter a number that identifies the transaction in the F0911 table. If you leave this field blank, the system uses next numbers for System 09 to generate a document number.
If you enter a value in this field, the value cannot exist in the F0911 table with the same general ledger and document type, or the transaction is considered a duplicate and is not processed. This field is part of the header section of the journal entry. Therefore, you can enter only one value for each document. |
| Journal Entry Line Number | VNJELN | Number | 7 | Enter a value that you use to track the number of lines in a journal entry. If you leave this field blank, the system updates it when it processes the transactions. The maximum number of journal entry lines in a transaction is 9999. |
| Line Extension Code | VNEXTL | Alpha | 2 | Enter a code that indicates the line extension. If you leave this field blank, the General Ledger Post program (R09801) updates it if multicurrency intercompany settlements exist. |
| G/L Posted Code | VNPOST | Alpha | 1 | Enter a value that indicates whether the transaction has been posted. If you leave this field blank, the General Ledger Post program updates it. If the transaction represents a model journal entry, enter M. |
| Batch Number | VNICU | Number | 8 | Enter a number used to group journal entries that are processed simultaneously. If you leave this field blank, the system uses next numbers for System 00 to generate a batch number.
This field is part of the header section of the journal entry. Therefore, you can enter only one value for each document. |
| Batch Type | VNICUT | Alpha | 2 | Enter a code that designates the type of transaction being processed (invoice, voucher, and so on). If you enter a value in this field, the value must exist in UDC table 98/IT. If you leave this field blank, the system populates the field with G when it processes the journal entries.
This field is part of the header section of the journal entry. Therefore, you can enter only one value for each document. |
| Batch Date | VNDICJ | Date | 6 | Enter the date of the batch. If you leave this field blank, the system uses the date on which the batch program is executed. If you complete this field, enter the date in a format that your database accepts. Review the field definition for VNDGJ for more information.
This field is part of the header section of the journal entry. Therefore, you can enter only one value for each document. |
| Batch System Date | VNDSYJ | Date | 6 | Enter the date on which the batch was entered into the system. If you leave this field blank, the system uses the date on which the batch program is processed. If you complete this field, enter the date in a format that your database accepts. Review the field definition for VNDGJ for more information.
This field is part of the header section of the journal entry. Therefore, you can enter only one value for each document. |
| Batch Time | VNTICU | Number | 6 | Enter the time when the batch was entered into the system. If you leave this field blank, the system uses the time that the batch program is processed.
This field is part of the header section of the journal entry. Therefore, you can enter only one value for each document. |
| Subledger | VNSBL | Alpha | 8 | Enter a code that identifies an auxiliary account for the transaction. If you complete this field, you must also enter a value in VNSBLT. |
| Subledger Type | VNSBLT | Alpha | 1 | Enter a code that identifies a category within a subledger. If you complete this field, the value must exist in UDC table 00/ST. |
| Ledger Type | VNLT | Alpha | 2 | Enter a code that identifies the type of ledger. You can leave this field blank, or enter AA or any other valid ledger type in UDC table 09/LT except CA. Never enter CA in this field.
This field is part of the header section of the journal entry. Therefore, you can enter only one value for each document. |
| Period Number | VNPN | Number | 2 | A code that indicates the accounting period. We recommend that you leave these fields blank. The system populates them, based on the general ledger date and company. |
| Century | VNCTRY | Number | 2 | The century in which the transaction takes place. if you leave this field blank, the system populates it based on the general ledger date and company. |
| Fiscal Year | VNFY | Number | 2 | The year in which the transaction takes place. If you leave this field blank, the system populates it based on the general ledger date and company. |
| Historical Exchange Rate | VNHCRR | Number | 15 | A previous exchange rate. Any value that you enter in this field is passed. The system does not validate it.
This field is part of the header section of the journal entry. Therefore, you can enter only one value for each document. |
| Historical Date | VNHDGJ | Date | 6 | Any value that you enter in this field is passed. The system does not validate it.
If you complete this field, enter the date in a format that your database accepts. Review the field definition for VNDGJ for more information. This field is part of the header section of the journal entry. Therefore, you can enter only one value for each document. |
| Units | VNU | Number | 15 | Enter the number of units in the transaction. If you complete this field, the system updates the Amount field with the value in the AU ledger when you run the Post General Ledger program (R09801). |
| Unit of Measure | VNUM | Alpha | 2 | Enter a value that describes the type of units entered. If you enter a value in this field, the value must exist in UDC table 00/UM. If you leave this field blank and a unit of measure is assigned to the account in the F0901 table, the system updates this field with that unit of measure. |
| G/L Offset | VNGLC | Alpha | 4 | Any value that you enter in this field is passed. The system does not validate it. |
| Reverse or Void (R/V) | VNRE | Alpha | 1 | Enter a value that indicates whether you want to reverse accrual entries. If you enter R (reverse) in this field, when the entry is posted, the system generates another journal entry with a general ledger date that is the first day of the next period. The transaction amount is reversed from the original entry.
Voided transactions are not eligible for this process. You must use the Journal Entry program (P0911) to void journal entries. This field is part of the header section of the journal entry. Therefore, you can enter only one value for each document. |
| Remark/ Explanation | VNEXR | Alpha | 30 | Enter a description for a specific journal entry line. |
| Reference 1 | VNR1 | Alpha | 8 | Any value that you enter in this field is passed. The system does not validate it.
This field is part of the header section of the journal entry. Therefore, you can enter only one value for each document. |
| Reference 2 | VNR2 | Alpha | 8 | Any value that you enter in this field is passed. The system does not validate it. |
| Document Pay Item | VNSFX | Alpha | 3 | Any value that you enter in this field is passed. The system does not validate it. |
| Document - Original | VNODOC | Number | 8 | Any value that you enter in this field is passed. The system does not validate it. |
| Document Company (Purchase Order) | VNPKCO | Alpha | 5 | Any value that you enter in this field is passed. The system does not validate it. |
| Document Company (Original Order) | VNOKCO | Alpha | 5 | Any value that you enter in this field is passed. The system does not validate it. |
| Document Type - Purchase Order | VNPDCT | Alpha | 2 | Any value that you enter in this field is passed. The system does not validate it. |
| Address Number | VNAN8 | Number | 8 | Enter the address book number of the customer or supplier who is associated with a voucher or invoice transaction. If you enter a value in this field, it must exist in the F0101 table. |
| Payment Number | VNCN | Alpha | 8 | Enter the payment number for the transaction. |
| Check Date | VNDKJ | Date | 6 | Enter the payment date that is associated with the payment number. Use a format that your database accepts. Review the field definition for VNDGJ for more information. |
| Check Cleared Date | VNDKC | Date | 6 | Enter the date on which the payment cleared the bank. Use a format that your database accepts. Review the field definition for VNDGJ for more information. |
| Serial Number | VNASID | Alpha | 25 | The asset ID that is associated with a fixed asset. The system verifies that this field exists in the F1201 table. |
| Batch Rear End Posted Code | VNBRE | Alpha | 1 | Any value that you enter in this field is passed. The system does not validate it. |
| Reconciled Code | VNRCND | Alpha | 1 | Enter a value that indicates whether the record is reconciled. You can enter R in this field to indicate that the record is reconciled.
Any value that you enter in this field is passed. The system does not validate it. |
| Summarized Code | VNSUMM | Alpha | 1 | Any value that you enter in this field is passed. The system does not validate it. |
| Purge Code | VNPRGE | Alpha | 1 | Any value that you enter in this field is passed. The system does not validate it. |
| Flag for 1099 | VNTNN | Alpha | 1 | Any value that you enter in this field is passed. The system does not validate it. |
| G/L Posting Code - Alternate 1 | VNALT1 | Alpha | 1 | Any value that you enter in this field is passed. The system does not validate it. |
| G/L Posting Code - Alternate 2 | VNALT2 | Alpha | 1 | Any value that you enter in this field is passed. The system does not validate it. |
| G/L Posting Code - Alternate 3 | VNALT3 | Alpha | 1 | Any value that you enter in this field is passed. The system does not validate it. |
| G/L Posting Code - Alternate 4 | VNALT4 | Alpha | 1 | Any value that you enter in this field is passed. The system does not validate it. |
| G/L Posting Code - Alternate 5 | VNALT5 | Alpha | 1 | Any value that you enter in this field is passed. The system does not validate it. |
| G/L Posting Code - Cash Basis Account | VNALT6 | Alpha | 1 | Any value that you enter in this field is passed. The system does not validate it. |
| Commitment Relief Flag | VNALT7 | Alpha | 1 | Any value that you enter in this field is passed. The system does not validate it. |
| Billing Control | VNALT8 | Alpha | 1 | Any value that you enter in this field is passed. The system does not validate it. |
| Currency Update | VNALT9 | Alpha | 1 | Any value that you enter in this field is passed. The system does not validate it. |
| G/L Posting Code - Alternate 0 | VNALT0 | Alpha | 1 | Any value that you enter in this field is passed. The system does not validate it.
We recommend that you leave this field blank. |
| Consumption Tax Cross Reference | VNALTX | Alpha | 1 | Any value that you enter in this field is passed. The system does not validate it. |
| Delete Not Allowed | VNDLNA | Alpha | 1 | Any value that you enter in this field is passed. The system does not validate it. |
| Client Free Form - Alternate 1 | VNCFF1 | Alpha | 1 | Any value that you enter in this field is passed. The system does not validate it. |
| Client Free Form - Alternate 2 | VNCFF2 | Alpha | 1 | Any value that you enter in this field is passed. The system does not validate it. |
| Lease Cost Ledger Posted Code | VNASM | Alpha | 1 | Any value that you enter in this field is passed. The system does not validate it. |
| Bill Code | VNBC | Alpha | 1 | If you enter a value in this field, the value must exist in UDC table 98/BC. |
| Supplier Invoice Number | VNVINV | Alpha | 25 | An invoice number for the transaction.
Any value that you enter in this field is passed. The system does not validate it. This field is part of the header section of the journal entry. Therefore, you can enter only one value for each document. |
| Invoice Date | VNIVD | Date | 6 | The invoice date for the transaction. Use a format that your database accepts. Review the field definition for VNDGJ for more information.
This field is part of the header section of the journal entry. Therefore, you can enter only one value for each document. |
| Categories - Work Order 01 | VNWR01 | Alpha | 4 | Any value that you enter in this field is passed. The system does not validate it. |
| Purchase Order | VNPO | Alpha | 8 | Any value that you enter in this field is passed. The system does not validate it. |
| Purchase Order Suffix | VNPSFX | Alpha | 3 | Any value that you enter in this field is passed. The system does not validate it. |
| Order Type | VNDCTO | Alpha | 2 | If you enter a value in this field, the value must exist in UDC table 00/DT. |
| Line Number | VNLNID | Number | 6 | Any value that you enter in this field is passed. The system does not validate it. |
| Fiscal Year - Weekly | VNWY | Number | 2 | Any value that you enter in this field is passed. The system does not validate it. |
| Fiscal Period - Weekly | VNWN | Number | 2 | Any value that you enter in this field is passed. The system does not validate it. |
| Closed Item - As Of Processing | VNFNLP | Alpha | 1 | Any value that you enter in this field is passed. The system does not validate it. |
| Sequence Number - Operations | VNOPSQ | Number | 5 | Any value that you enter in this field is passed. The system does not validate it. |
| Job Type (Craft) Code | VNJBCD | Alpha | 6 | Any value that you enter in this field is passed. The system does not validate it. |
| Job Step | VNJBST | Alpha | 4 | Any value that you enter in this field is passed. The system does not validate it. |
| Business Unit - Home | VNHMCU | Alpha | 12 | A value that indicates the business unit for the transaction. If you enter a value in this field, the system verifies that it exists in the F0006 table.
This field is part of the header section of the journal entry. Therefore, you can enter only one value for each document. |
| DOI Stub | VNDOI | Number | 2 | Any value that you enter in this field is passed. The system does not validate it. |
| Outsider Lease or Well ID | VNALID | Alpha | 25 | Any value that you enter in this field is passed. The system does not validate it. |
| ID Type | VNALTY | Alpha | 2 | Any value that you enter in this field is passed. The system does not validate it. |
| Service/Tax Date | VNDSVJ | Date | 6 | The service or tax date of the transaction. Use a format that your database accepts. If you leave this field blank, the system uses the value from VNDGJ. Review the field definition for VNDGJ for more information. |
The system does not use values in ignored fields. This table lists the fields that the system ignores:
| 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 |
| EDI - Send/Receive Indicator | VNEDER | Alpha | 1 |
| Batch File Create G/L Record | VNEDGL | Alpha | 1 |
| User Address Number | VNEDAN | Number | 8 |
| Fiscal Quarter (Obsolete) | VNFQ | Number | 2 |
| Reference 3 - Account Reconciliation | VNR3 | Alpha | 8 |
| Document Type - Original | VNODCT | Alpha | 2 |
| Document Pay Item - Original | VNOSFX | Alpha | 3 |
| G/L Posting Code - Alternate T | VNALTT | Alpha | 1 |
| G/L Posting Code - Alternate U | VNALTU | Alpha | 1 |
| Stock Inventory Commitment | VNALTV | Alpha | 1 |
| G/L Posting Code - Alternate W | VNALTW | Alpha | 1 |
| G/L Posting Code - Alternate Z | VNALTZ | Alpha | 1 |
| Registration Number | VNREG# | Number | 8 |
| Payment ID | VNPYID | Number | 15 |
| Transaction Originator | VNTORG | Alpha | 10 |
| 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 |
If you use outbound interoperability to send bank account information to a third-party software package for bank statement reconciliation, you can import the reconciliation information back into the JD Edwards EnterpriseOne General Accounting system to complete the reconciliation process.
You must populate these fields in the F0911Z1 table for each transaction that you want to update in the JD Edwards EnterpriseOne General Accounting system:
VNEDUS (EDI - User ID).
VNEDBT (EDI - Batch Number).
VNEDTN (EDI - Transaction Number).
VNEDLN (EDI - Line Number).
VNEDSP (EDI - Processed Flag) - The value in this field must be 2.
VNDOC (Document Number).
The values in these fields must match the records that you want to update in the F0911 table:
VNDCT (Document Type)
VNKCO (Document Company)
VNDGJ (G/L Date)
VNJELN (Journal Entry Line Number)
VNEXTL (Line Extension Code)
VNRCND (Reconciled Code)
VNDKC (Check Cleared Date)
After you populate the F0911Z1 table, you run the Update Externally Reconciled Transaction program to update the transactions from the F0911Z1 table to the JD Edwards EnterpriseOne General Accounting system.
Select Batch Journal Entry Processing (G09311), Update Externally Reconciled Transaction.
You run the Update Externally Reconciled Transaction program to update the reconciliation information from the F0911Z1 table to the JD Edwards EnterpriseOne General Accounting system. The program also updates the Processed Flag field (VNEDSP) to 1 (successfully processed) in the F0911Z1 table for each transaction to prevent the transaction from being processed again by the Update Externally Reconciled Transaction program or by the Journal Entry Batch Processor program (R09110Z).