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. |