Optional Fields

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.