Assigning Values to Optional Columns
You can enter values for many optional columns in the GL_INTERFACE table. Enter values in these columns for maximum control over the way Journal Import groups the journal entry lines it creates into journal entries.
If you have enabled average balance processing, Journal Import will group transactions by Accounting Date. Transactions are grouped before they are validated and, if the Effective Date Rule is Roll Date, rolled to the nearest valid business day within the period.
If you do not enter a value in an optional column and a default value exists for that particular column, Journal Import automatically enters the default value.
Enter values in the following optional columns of the GL_INTERFACE table:
REFERENCE1 (Batch Name): Enter a batch name for your import batch. Journal Import creates a default batch name using the following format: (Optional User-Entered REFERENCE1) (Source) (Request ID) (Actual Flag) (Group ID). If you enter a batch name, Journal Import prefixes the first 50 characters of your batch name to the above format.
REFERENCE2 (Batch Description): Enter a description for your batch. If you do not enter a batch description, Journal Import automatically gives your batch a description using the format: Journal Import (Source) (Request Id).
REFERENCE4 (Journal entry name): Enter a journal entry name for your journal entry. Journal Import creates a default journal entry name using the following format: (Category Name) (Currency) (Currency Conversion Type, if applicable) (Currency Conversion Rate, if applicable) (Currency Conversion Date, if applicable) (Encumbrance Type ID, if applicable) (Budget Version ID, if applicable). If you enter a journal entry name, Journal Import prepends the first 25 characters of your journal entry name to the above format.
REFERENCE5 (Journal entry description): Enter a description for your journal entry. If you do not enter a journal entry description, Journal Import automatically gives your journal entry a description using the format: Journal Import - Concurrent Request ID.
REFERENCE6 (Journal entry reference): Enter a reference name or number for your journal entry. If you do not enter a journal entry reference, Journal Import automatically creates a journal entry reference called Journal Import Created.
REFERENCE7 (Journal entry reversal flag): Enter Yes to mark your journal entry for reversal. If you do not enter Yes, Journal Import automatically defaults to No.
REFERENCE8 (Journal entry reversal period or effective date): Enter the name of the period to which you want to reverse your journal entry. If you have enabled average balance processing, enter the effective date for the reversal.
Note: If you enter Yes in the REFERENCE7 column, you must enter a value in this column.
REFERENCE10 (Journal entry line description): Enter a description for your journal entry line. If you do not enter a journal entry line description, Journal Import uses the subledger document sequence value. If there is no document sequence value, Journal Import creates a journal entry description called Journal Import Created.
REFERENCE21 through REFERENCE30: Enter a reference name or number to further identify your import journal entry lines. Columns REFERENCE21 through REFERENCE30 map into columns REFERENCE_1 through REFERENCE_10, respectively, of the GL_JE_LINES table.
Once in the GL_JE_LINES table, your General Ledger application prints the value stored in REFERENCE_1 in standard reports run with Line detail, and prints the value stored in REFERENCE_4 in standard reports run with Source detail. The other reference columns are for descriptive or tracking purposes only. The values in these columns are not used in your General Ledger application.
GROUP_ID: Enter a unique group number to distinguish import data within a source. You can run Journal Import in parallel for the same source if you specify a unique group number for each request.
STAT_AMOUNT: Enter the statistical amount associated with your journal entry line data. You define statistical units of measure in the Statistical Units of Measure form of your General Ledger application. You must use this column when you want to see statistical and monetary amounts in the same journal entry line.
USSGL_TRANSACTION_CODE: Enter a valid USSGL transaction code for your journal entry line. Journal Import validates and imports the USSGL transaction codes when you have the profile option Enable Transaction Code set to Yes, and you have defined your USSGL transaction codes using the Public Sector Transaction Codes window.
Note: This column is ignored for commercial installations of General Ledger.
INVOICE_DATE: Enter the date on which you paid or collected tax on your tax journal entry line. Enter the date in the format DD-MON-YY or the default date format for your language. Your invoice date should correspond to the date when tax amounts were paid or received for this invoice. You must use this column if you import data for the Value Added Tax Descriptive Flexfield.
INVOICE_AMOUNT: Enter an invoice amount. Enter the net invoice amount that relates to your tax journal entry line amount. You must use this column if you import data for the Value Added Tax Descriptive Flexfield.
TAX_CODE: Enter a valid tax code that identifies the type of tax paid for this invoice. You define a list of valid tax codes for this field when you define your descriptive flexfield values. You must use this column if you import data for the Value Added Tax Descriptive Flexfield.
INVOICE_IDENTIFIER: Enter an invoice identifier. Enter reference information about the source document or invoice upon which you paid or collected tax. You must use this column if you import data for the Value Added Tax Descriptive Flexfield.
See Also
Understanding the GL_INTERFACE Table
Assigning Values for Accounts
Assigning Values for Additional and Conditionally Required Columns
Assigning Values for Currency Conversion
Required NULL Columns in the GL_INTERFACE Table
Importing Specialized Data
About Journal Import Validation
Overview (of Average Balance Processing)