Required Fields

These fields in the F03B11Z1 table are required for processing batch invoices:

Field Name	Alias	Type	Length	Values to Enter/Definition
EDI - User ID	VJEDUS	Alpha	10	Enter the user ID of the person running the process or the person who receives messages in the Employee Work Center. This field, in conjunction with the EDI - Transaction Number (VJEDTN), the EDI - Batch Number (VJEDBT), and the EDI - Line Number (VJEDLN) fields, uniquely identifies an invoice.
EDI - Transaction Number	VJEDTN	Alpha	22	Enter the source system's document number so that the transaction can be cross-referenced. This field, in conjunction with the EDI - Line Number field (VJEDLN), uniquely identifies each transaction. Each new transaction number identifies a new invoice. You cannot have more than one transaction with the same number in a batch unless the line number is different.
EDI - Line Number	VJEDLN	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, in conjunction with the EDI - Transaction Number field (VJEDTN), identifies each pay item of the invoice.
EDI - Successfully Processed	VJEDSP	Alpha	1	Leave this field blank. The system populates this field to indicate whether the batch processor successfully processed the transaction. 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	VJEDTC	Alpha	1	Enter A in this field. No other values are valid.
EDI - Transaction Type	VJEDTR	Alpha	1	Enter I (for invoices) in this field. A code that identifies a particular kind of transaction.
EDI - Batch Number	VJEDBT	Alpha	15	Enter a number to group transactions for processing. This field, in conjunction with the EDI - Transaction Number (VJEDTN), the EDI - User ID (VJEDUS), and the EDI - Line Number (VJEDLN) fields, uniquely identifies a transaction within a specific batch. This field also specifies a level break and causes the assignment of a new batch number each time the value changes. To increase performance, assign one batch number for each group of transactions processed at one time.
Address Number	VJAN8	Number	8	Enter the address book number of the customer associated with the invoice transaction. The number you enter must exist in the Address Book Master table (F0101).
G/L Date	VJDGJ	Date	6	Enter the G/L date in the format that the database accepts. Some databases enable 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 6/1/99 corresponds to the Julian date 099152, and the date 6/01/00 corresponds to the Julian date 100153 (because the year 2000 has a leap day, 2/29/00). Alternatively, you can leave this field blank and complete the fields VJDGM (mm), VJDGD (dd), VJDGY (yy), VJDG# (cc) in the month/day/year/century format. Enter the prefix of the year in the Century field (VJDG#). For example, enter 19 for 1999, or enter 20 for 2008.
Invoice Date	VJDIVJ	Date	6	Enter the invoice date in the format that the database accepts. If you leave this field blank, the system uses the G/L date. See the data item for G/L Date (VJDGJ) for examples. Alternatively, you can leave this field blank and complete the fields VJDIVM (mm), VJDIVD (dd), VJDIVY (yy), and VJDIV# (cc) in the month/day/year/ century format. Enter the prefix of the year in the Century field (VJDIV#). For example, enter 19 for 1999 and 20 for 2008.
Company	VJCO	Number	5	A number that identifies the organization to which the invoice belongs. This number must exist in the Company Constants table (F0010) and must identify a reporting entity that has a complete balance sheet.
G/L Offset	VJGLC	Alpha	4	The value of this field, in conjunction with the Company Number (VJCO) field, specifies the A/R trade (offset) account to which the transaction posts. The account established in the AAI item RCxxxx (where xxxx 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). Do not complete this field unless you want to direct different transactions to different offset accounts.
Gross Amount	VJAG	Number	15	Enter the transaction amount in the format that the 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 (VJACR) instead.
Account Mode - G/L	VJAM	Alpha	1	For all records, enter 2 in this field.
Business Unit	VJMCU	Alpha	12	The value that you enter in this field must exist in the Business Unit Master table (F0006). If you leave this field blank, the system uses the value of the Security Business Unit field (MCU) in the customer's address book record.