Optional Fields

These fields in the F03B11Z1 table are optional for batch invoice processing. You can use the fields to provide additional information about invoices.

We recommend that you leave specific fields blank so that the system updates them.

Field Name	Alias	Type	Length	Values to Enter/Definition
EDI - Detail Lines Processed	VJEDDL	Number	5	The number of detail lines included in a specific transaction. For user verification only.
Document Number	VJDOC	Number	8	The number that identifies the transaction in the F03B11 table. If you leave this field blank, the system uses next numbers for system 03B to generate a document number. If you enter a value in this field, the value cannot exist in the F03B11 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 Journal Entry Transactions - Batch File table (F0911Z1). It is recommended that you leave this field blank.
Document Type	VJDCT	Alpha	2	A code that specifies the type of transaction. If you leave this field blank, the value is specified by a processing option in the Invoice Entry MBF Processing Options program (P03B0011). If you enter a value in this field, the value must exist in both UDC tables 00/DT (Document Type - All Documents) and 00/DI (Document Type - Invoices Only). If you enter a value in this field, you must enter the same value in the corresponding field in the F0911Z1 table. It is recommended that you leave this field blank.
Document Company	VJKCO	Alpha	5	A code that specifies 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 (VJCO). If you enter a value in this field, the value must exist in the F0010 table. If you enter a value in this field, but do not enter a value in the corresponding field (VNKCO) in the F0911Z1 table, the value entered here is passed to that field. It is recommended that you leave this field blank.
Document Pay Item	VJSFX	Alpha	3	A code that specifies the pay item number of the invoice. If you leave this field blank, the system assigns the pay item beginning with 001. Use the Line Number field (VJEDLN) to specify transactions that have multiple pay items. If the transaction number (VJEDTN) and the line number (VJEDLN) combination are duplicated, the next and all subsequent transactions is ignored regardless of whether the Pay Item field (VJSFX) is used. If the tax constant Balance GL Distribution by Pay Item and Taxis enabled for the invoice company, this field is required.
Batch Type	VJICUT	Alpha	2	A code that specifies the type of transaction being processed, such as invoice, voucher, and so on. If you complete this field, you must enter IB (Invoice Batch). If you leave this field blank, the system updates the field with IB when processing the invoices.
Batch Number	VJICU	Number	8	A number used to group invoices that are processed simultaneously. If you leave this field blank, the system uses next numbers for system 00 to generate a batch number. It is recommended that you leave this field blank.
Batch Date	VJDICJ	Date	6	The date the batch was entered. If you leave this field blank, the system uses the date that the batch process program is run. If you complete this field, enter the date in a format that the database accepts. See the field definition for G/L Date (VJDGJ) for more information. Alternatively, you can leave this field blank and complete the fields VJDICM (mm), VJDICD (dd), VJDICY (yy), and VJDIC# (cc) in the month/day/year/ century format. Enter the prefix of the year in the Century field (VJDIC#). For example, enter 19 for 1999, or enter 20 for 2008.
Fiscal Year	VJFY	Number	2	We recommend that you leave this field blank. The system updates this field based on the G/L date and company.
Century	VJCTRY	Number	2	We recommend that you leave this field blank. The system updates this field based on the G/L date and company.
Period Number	VJPN	Number	2	We recommend that you leave this field blank. The system updates this field based on the G/L date and company.
Account ID	VJAID	Number	8	The short account ID that corresponds to the A/R trade account. When the invoice is processed, the system updates this field with the account ID associated with the account number retrieved for the AAI item RCxxxx (where xxxx is the value of the G/L Offset field). The account ID is stored in the Account Master table (F0901). It is recommended that you leave this field blank.
Address Number - Parent	VJPA8	Number	8	The parent number of the customer. The value that you enter must exist in the Address Book Master table (F0101). If you leave this field blank, the parent number assigned to the customer in the F03012 table is used. If a parent number does not exist in the F03012 table, the system uses the customer address book number.
Address Number - Alternate Payee	VJAN8J	Number	8	The alternate payor for the customer. If the invoice is to be paid by another party, complete this field with the address book number of the payor. If you leave this field blank, the system updates it with the value in the Send Statement To field for the customer in the F03012 table. If you enter a value in this field, the value that you enter must exist in the Address Book Master table (F0101).
Payor Address Number	VJPYR	Number	8	The alternate payor for the customer. If the invoice is to be paid by another party, complete this field with the address book number of the payor. The system validates this field against the Address Book Master table (F0101). Any value that you enter must exist as an address book record in the system. If you leave this field blank, the system uses the value from the Alternate Payee field (VJAN8J).
G/L Posted Code	VJPOST	Alpha	1	A code to specify the posting status of the transaction. Leave this field blank. Run the General Ledger Post Report program (R09801) to update this field. If you previously processed historical data as a journal entry, it is recommended that you create an associated Journal Entry Transactions - Batch File (F0911Z1) transaction and use the A/R trade account as the G/L distribution account. Then, when the transaction is posted, it does not affect accounting. If you process posted invoice transactions out of balance (that is, without corresponding entries in the Journal Entry Transactions - Batch File table), enter D in this field. However, by doing this, you compromise the ability to void these transactions in the future, and you create discrepancies in the A/R Batch Integrity reports.
A/R Post Status	VJISTR	Alpha	1	You must leave this field blank. This field indicates that a change record for the invoice exists in the Invoice Revisions table (F03B112). Changes to invoices cannot be processed using the Batch Invoice Processor (R03B11Z1A). You must use Standard Invoice Entry (P03B2002) to make changes to posted invoices.
Balanced - Journal Entries	VJBALJ	Alpha	1	This field indicates whether the amounts of the journal entries associated with the transaction are in balance with the gross amount of the invoice. It is recommended that you leave this field blank.
Pay Status Code	VJPST	Alpha	1	This field indicates whether the invoice is open, paid, or on hold. The value of this field must exist in UDC 00/PS (Payment Status Codes). If you leave this field blank, the system updates it according to the value in the processing option of the Invoice Entry MBF Processing Options program (P03B0011). If you did not assign a value in the processing option, the default value of the data dictionary item PST is used.
Amount Open	VJAAP	Number	15	The system updates the Amount Open field (VJAAP) with the value in the Gross Amount field (VJAG), regardless of whether a value exists. Processing partially paid invoices is not supported by this application. It is recommended that you leave this field blank.
Object Account	VJOBJ	Alpha	6	Any value that you enter in this field is passed to the F03B11 table. The system does not validate this field.
Subsidiary	VJSUB	Alpha	8	Any value that you enter in this field is passed to the F03B11 table. The system does not validate this field.
Subledger Type	VJSBLT	Alpha	1	Any value that you enter in this field is passed to the F03B11 table. The system does not validate this field.
Subledger - G/L	VJSBL	Alpha	8	Any value that you enter in this field is passed to the F03B11 table. The system does not validate this field.
Number of Sent Reminders - Total	VJRMDS	Number	3	Enter the total number of notices that were sent to a customer. If you leave this field blank, the system updates it each time a delinquency notice is generated for an invoice.
Collection Report (Y/N)	VJCOLL	Alpha	1	This field specifies whether a customer is eligible to be placed on the Collection report. If you leave this field blank, the system updates it with the value from the policy assigned to the customer in the F03012 table.
Collection Reason Code	VJCORC	Alpha	2	The system updates this field when the Collection Report (R03B461) is run. It is recommended that you leave this field blank.
Apply Finance Charges - Y/N	VJAFC	Alpha	1	If you leave this field blank, the system uses the value that is assigned to the customer in the F03012 table.
Document - Original	VJODOC	Alpha	8	Any value that you enter in this field is passed to the F03B11 table. The system does not validate this fields If you leave this fields blank, the system updates it with the value assigned to the Document Number field from the F03B11 table.
Document Type - Original	VJODCT	Alpha	2	Any value that you enter in this field is passed to the F03B11 table. The system does not validate this fields If you leave this fields blank, the system updates it with the value assigned to the Document Type field from the F03B11 table.
Document Company (Original Order)	VJOKCO	Alpha	5	Any value that you enter in this field is passed to the F03B11 table. The system does not validate this fields If you leave this fields blank, the system updates it with the value assigned to the Document Company field from the F03B11 table.
Document Pay Item - Original	VJOSFX	Alpha	3	Any value that you enter in this field is passed to the F03B11 table. The system does not validate this field. If you leave this field blank, the system updates it with the value assigned to the Pay Item field from the F03B11 table.
Supplier Invoice Number	VJVINV	Alpha	25	Any value that you enter in this field is passed to the F03B11 table. The system does not validate this field.
Purchase Order	VJPO	Alpha	8	Any value that you enter in this field is passed to the F03B11 table. The system does not validate this field.
Document Type - Purchase Order	VJPDCT	Alpha	2	Any value that you enter in this field is passed to the F03B11 table. The system does not validate this field.
Document Company (Purchase Order)	VJPKCO	Alpha	5	Any value that you enter in this field is passed to the F03B11 table. The system does not validate this field.
Order Type	VJDCTO	Alpha	2	Any value that you enter in this field is passed to the F03B11 table. The system does not validate this field.
Line Number	VJLNID	Number	6	Any value that you enter in this field is passed to the F03B11 table. The system does not validate this field.
Sales Document Number	VJSDOC	Number	8	Any value that you enter in this field is passed to the F03B11 table. The system does not validate this field.
Sales Document Type	VJSDCT	Alpha	2	Any value that you enter in this field is passed to the F03B11 table. The system does not validate this field.
Document Company (Sales Order)	VJSKCO	Alpha	5	Any value that you enter in this field is passed to the F03B11 table. The system does not validate this field.
Order Suffix	VJSFXO	Alpha	3	Any value that you enter in this field is passed to the F03B11 table. The system does not validate this field.
Commission Code 1	VJCMC1	Number	8	You can enter the address book number of the sales person who should receive a commission. Typically, this is tracked in the Sales Order system. The value that you enter is passed and no validation is performed.
Reference	VJVR01	Alpha	25	Any value that you enter in this field is passed to the F03B11 table. The system does not validate this field.
Unit	VJUNIT	Alpha	8	Any value that you enter in this field is passed to the F03B11 table. The system does not validate this field.
Business Unit 2	VJMCU2	Alpha	12	Any value that you enter in this field is passed to the F03B11 table. The system does not validate this field.
Remark	VJRMK	Alpha	30	This field describes the invoice pay item. This field is user defined and appears on the Standard Invoice Entry form.
Alpha Name	VJALPH	Alpha	40	If you leave this field blank, the system uses the alpha name that is associated with the address book number in the Address Book Master table (F0101). If you enter a value in this field and it differs from the value in the Address Book Master, undesirable results might occur.
Alpha Name	VJALPH	Alpha	40	If you leave this field blank, the system uses the alpha name that is associated with the address book number in the Address Book Master table (F0101). If you enter a value in this field and it differs from the value in the Address Book Master, undesirable results might occur.
Frequency - Recurring	VJRF	Alpha	2	See the Note after the table.
Recurring Frequency # of Payments	VJDRF	Number	3	See the Note after the table.
Control/ Statement Field	VJCTL	Alpha	13	Enter the statement number of the last statement generated for this invoice. Any value that you enter in this field is passed to the F03B11 table. The system does not validate this field.
Item Number - Short	VJITM	Number	8	Enter the inventory item number. Any value that you enter in this field is passed to the F03B11 table. The system does not validate this field.
Units	VJU	Number	15	Any value that you enter in this field is passed to the F03B11 table. The system does not validate this field.
Unit of Measure	VJUM	Alpha	2	This field describes the type of units. The value that you enter must exist in UDC 00/UM (Unit of Measure).
G/L Posting Code - Cash Basis Acct	VJALT6	Alpha	1	This field must be left blank. The system updates this field during receipt processing.
Payment Instrument	VJRYIN	Alpha	1	Any 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 F03012 table when the invoice is processed.
Void Date - For G/L - Julian	VJVDGJ	Date	6	This field must be left blank. The system updates this field when invoices are voided.
Void Reason Code	VJVRE	Alpha	3	This field must be left blank. The system updates this field when invoices are voided.
A/R - A/P Miscellaneous Code 1	VJRP1	Alpha	1	This field must be left blank. The Sales Order Processing System updates this field.
A/R - A/P Miscellaneous Code 2	VJRP2	Alpha	1	This field must be left blank. The Sales Order Processing System updates this field.
A/R - A/P Cash Rcpts/Inv Reg Code	VJRP3	Alpha	1	This field must be left blank. The Sales Order system updates this field.
A/R Reporting Codes 1-10	VJAR01, VJAR02, VJAR03, VJAR04, VJAR05, VJAR06, VJAR07, VJAR08, VJAR09, VJAR10	Alpha	3	If you leave this field blank, the system uses the values from the address book category codes (AC01 - AC10) for this customer. If you enter a value into this field and a value already exists in the address book category codes for this customer, the system uses the value that you enter in the F03B11Z1 table. The system does not validate this field.
Transaction Originator	VJTORG	Alpha	10	This field should be left blank. The system updates this field when the transaction is processed.
User ID	VJUSER	Alpha	10	This field should be left blank. The system updates this field when the transaction is processed.
Program ID	VJPID	Alpha	10	This field should be left blank. The system updates this field when the transaction is processed.
Date - Updated	VJUPMJ	Date	6	This field should be left blank. The system updates this field when the transaction is processed.
Time - Last Updated	VJUPMT	Number	6	This field should be left blank. The system updates this field when the transaction is processed.
Work Station ID	VJJOBN	Alpha	10	This field should be left blank. The system updates this field when the transaction is processed.

Note: Complete the Frequency - Recurring (VJRF) and Recurring Frequency # of Payments (VJDRF) fields only if the invoice is a recurring invoice that will be recycled. Documents generated with recurring information have the Document Type RR. The value that you enter in the Frequency - Recurring field (VJRF) must exist in UDC H00/RF (Recurring Frequency).The number of payments corresponds to the number of times the invoice will be recycled. If the number of payments is equal to 1, the system does not generate a new invoice.