GL Interface

STATUS	NOT NULL	VARCHAR2(50)
LEDGER_ID		NUMBER(15)
ACCOUNTING_DATE	NOT NULL	DATE
CURRENCY_CODE	NOT NULL	VARCHAR2(15)
DATE_CREATED	NOT NULL	DATE
CREATED_BY	NOT NULL	NUMBER(15)
ACTUAL_FLAG	NOT NULL	VARCHAR2(1)
USER_JE_CATEGORY_NAME	NOT NULL	VARCHAR2(25)
USER_JE_SOURCE_NAME	NOT NULL	VARCHAR2(25)
CURRENCY_CONVERSION_DATE		DATE
ENCUMBRANCE_TYPE_ID		NUMBER
BUDGET_VERSION_ID		NUMBER
USER_CURRENCY_CONVERSION_TYPE		VARCHAR2(30)
CURRENCY_CONVERSION_RATE		NUMBER
AVERAGE_JOURNAL_FLAG		VARCHAR2(1)
ORIGINATING_BAL_SEG_VALUE		VARCHAR2(25)
SEGMENT1		VARCHAR2(25)
SEGMENT2		VARCHAR2(25)
SEGMENT3		VARCHAR2(25)
SEGMENT4		VARCHAR2(25)
SEGMENT5		VARCHAR2(25)
SEGMENT6		VARCHAR2(25)
SEGMENT7		VARCHAR2(25)
SEGMENT8		VARCHAR2(25)
SEGMENT9		VARCHAR2(25)
SEGMENT10		VARCHAR2(25)
SEGMENT11		VARCHAR2(25)
SEGMENT12		VARCHAR2(25)
SEGMENT13		VARCHAR2(25)
SEGMENT14		VARCHAR2(25)
SEGMENT15		VARCHAR2(25)
SEGMENT16		VARCHAR2(25)
SEGMENT17		VARCHAR2(25)
SEGMENT18		VARCHAR2(25)
SEGMENT19		VARCHAR2(25)
SEGMENT20		VARCHAR2(25)
SEGMENT21		VARCHAR2(25)
SEGMENT22		VARCHAR2(25)
SEGMENT23		VARCHAR2(25)
SEGMENT24		VARCHAR2(25)
SEGMENT25		VARCHAR2(25)
SEGMENT26		VARCHAR2(25)
SEGMENT27		VARCHAR2(25)
SEGMENT28		VARCHAR2(25)
SEGMENT29		VARCHAR2(25)
SEGMENT30		VARCHAR2(25)
ENTERED_DR		NUMBER
ENTERED_CR		NUMBER
ACCOUNTED_DR		NUMBER
ACCOUNTED_CR		NUMBER
TRANSACTION_DATE		DATE	Do not enter a value in this column.

REFERENCE1		VARCHAR2(100)	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		VARCHAR2(240)	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).
REFERENCE3		VARCHAR2(100)	Do not enter a value in this column.
REFERENCE4		VARCHAR2(100)	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		VARCHAR2(240)	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		VARCHAR2(100)	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		VARCHAR2(100)	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		VARCHAR2(100)	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.
REFERENCE9		VARCHAR2(100)	Do not enter values in this column.
REFERENCE10		VARCHAR2(240)	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.
REFERENCE11		VARCHAR2(240)	Do not enter values in this column.
REFERENCE12		VARCHAR2(100)	Do not enter values in this column.
REFERENCE13		VARCHAR2(100)	Do not enter values in this column.
REFERENCE14		VARCHAR2(100)	Do not enter values in this column.
REFERENCE15		VARCHAR2(100)	Do not enter values in this column.
REFERENCE16		VARCHAR2(100)	Do not enter values in this column.
REFERENCE17		VARCHAR2(100)	Do not enter values in this column.
REFERENCE18		VARCHAR2(100)	Do not enter values in this column.
REFERENCE19		VARCHAR2(100)	Do not enter values in this column.
REFERENCE20		VARCHAR2(100)	Do not enter values in this column.
REFERENCE21		VARCHAR2(240)	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.
REFERENCE22		VARCHAR2(240)
REFERENCE23		VARCHAR2(240)
REFERENCE24		VARCHAR2(240)
REFERENCE25		VARCHAR2(240)
REFERENCE26		VARCHAR2(240)
REFERENCE27		VARCHAR2(240)
REFERENCE28		VARCHAR2(240)
REFERENCE29		VARCHAR2(240)
REFERENCE30		VARCHAR2(240)
JE_BATCH_ID		NUMBER(15)	Do not enter values in this column.
PERIOD_NAME		VARCHAR2(15)
JE_HEADER_ID		NUMBER(15)	Do not enter values in this column.
JE_LINE_NUM		NUMBER(15)	Do not enter values in this column.
CHART_OF_ACCOUNTS_ID		NUMBER(15)	Do not enter values in this column.
FUNCTIONAL_CURRENCY_CODE		VARCHAR2(15)	Do not enter values in this column.
CODE_COMBINATION_ID		NUMBER(15)
DATE_CREATED_IN_GL		DATE	Do not enter values in this column.
WARNING_CODE		VARCHAR2(4)	Do not enter values in this column.
STATUS_DESCRIPTION		VARCHAR2(240)	Do not enter values in this column.
STAT_AMOUNT		NUMBER	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.
GROUP_ID		NUMBER(15)	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.
REQUEST_ID		NUMBER(15)	Do not enter values in this column.
SUBLEDGER_DOC_SEQUENCE_ID		NUMBER	Do not enter values in this column.
SUBLEDGER_DOC_SEQUENCE_VALUE		NUMBER	Do not enter values in this column.
ATTRIBUTE1		VARCHAR2(150)	ATTRIBUTE1 through ATTRIBUTE 10: Enter values for your descriptive flexfield "Journals - Journal Entry Line". The values you enter depend on how you defined your descriptive flexfield in the Descriptive Flexfield Segments form.
ATTRIBUTE2		VARCHAR2(150)
GL_SL_LINK_ID		NUMBER
GL_SL_LINK_TABLE		VARCHAR2(30)
ATTRIBUTE3		VARCHAR2(150)	ATTRIBUTE1 through ATTRIBUTE 10: Enter values for your descriptive flexfield "Journals - Journal Entry Line". The values you enter depend on how you defined your descriptive flexfield in the Descriptive Flexfield Segments form.
ATTRIBUTE4		VARCHAR2(150)
ATTRIBUTE5		VARCHAR2(150)
ATTRIBUTE6		VARCHAR2(150)
ATTRIBUTE7		VARCHAR2(150)
ATTRIBUTE8		VARCHAR2(150)
ATTRIBUTE9		VARCHAR2(150)
ATTRIBUTE10		VARCHAR2(150)
ATTRIBUTE11		VARCHAR2(150)	ATTRIBUTE11 through ATTRIBUTE 20: Enter values for your descriptive flexfield "Journals - Captured Information". The values you enter depend on how you defined your descriptive flexfield in the Descriptive Flexfield Segments form.
ATTRIBUTE12		VARCHAR2(150)
ATTRIBUTE13		VARCHAR2(150)
ATTRIBUTE14		VARCHAR2(150)
ATTRIBUTE15		VARCHAR2(150)
ATTRIBUTE16		VARCHAR2(150)
ATTRIBUTE17		VARCHAR2(150)
ATTRIBUTE18		VARCHAR2(150)
ATTRIBUTE19		VARCHAR2(150)
ATTRIBUTE20		VARCHAR2(150)
CONTEXT		VARCHAR2(150)	CONTEXT: Enter the context field value for the descriptive flexfield "Journals - Journal Entry Line" that identifies the structure of your descriptive flexfield. If you enter a value, you can also enter some combination of values in the columns ATTRIBUTE1 through ATTRIBUTE10.
CONTEXT2		VARCHAR2(150)	CONTEXT2: Enter Yes to identify your Value Added Tax Descriptive Flexfield structure. You must use this column if you import data for the Value Added Tax Descriptive Flexfield. Enter No to indicate that your journal entry line is not a tax item. If you enter No, the four Value Added Tax Descriptive Flexfield related columns must be null.
INVOICE_DATE		DATE	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.
TAX_CODE		VARCHAR2(15)	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		VARCHAR2(20)	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.
INVOICE_AMOUNT		NUMBER	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.
CONTEXT3		VARCHAR2(150)	CONTEXT3: Enter the context field value (natural account) for the descriptive flexfield "Journals - Captured Information" that identifies the structure of your descriptive flexfield. Enter a value only if you are importing the descriptive flexfield "Journals - Captured Information" without validation. If you enter a value, you can also enter some combination of values in the columns ATTRIBUTE11 through ATTRIBUTE20.
USSGL_TRANSACTION_CODE		VARCHAR2(30)	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.
DESCR_FLEX_ERROR_MESSAGE		VARCHAR2(240)	Do not enter values in this column.