Required Fields

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.