Journal Interface
Stores the journal information to be imported to create journals.
QName: {http://xmlns.oracle.com/apps/financials/generalLedger/journals/desktopEntry/journalImportService/}GlInterface
Relationships
The following table describes how this service data object is related to other service data objects or business object services.
| Relationship Type | Object or Service |
|---|---|
|
Contains |
|
|
Contained by |
|
|
Handled by |
Attributes
The following table describes attributes in the service data object.
| Name | Type | Description |
|---|---|---|
|
AccountedCr |
decimal |
The transaction credit amount in the ledger currency. |
|
AccountedDr |
decimal |
The transaction debit amount in the ledger currency. |
|
AccountingDate |
{http://xmlns.oracle.com/adf/svc/types/}date-Date |
The accounting date on which the journals are recorded. |
|
Attribute1 |
string |
Segment value 1 for the Journal Lines descriptive flexfield. |
|
Attribute10 |
string |
Segment value 10 for the Journal Lines descriptive flexfield. |
|
Attribute11 |
string |
Segment value 11 for the Journals Captured Information descriptive flexfield. |
|
Attribute12 |
string |
Segment value 12 for the Journals Captured Information descriptive flexfield. |
|
Attribute13 |
string |
Segment value 13 for the Journals Captured Information descriptive flexfield. |
|
Attribute14 |
string |
Segment value 14 for the Journals Captured Information descriptive flexfield. |
|
Attribute15 |
string |
Segment value 15 for the Journals Captured Information descriptive flexfield. |
|
Attribute16 |
string |
Segment value 16 for the Journals Captured Information descriptive flexfield. |
|
Attribute17 |
string |
Segment value 17 for the Journals Captured Information descriptive flexfield. |
|
Attribute18 |
string |
Segment value 18 for the Journals Captured Information descriptive flexfield. |
|
Attribute19 |
string |
Segment value 19 for the Journals Captured Information descriptive flexfield. |
|
Attribute2 |
string |
Segment value 2 for the Journal Lines descriptive flexfield. |
|
Attribute20 |
string |
Segment value 20 for the Journals Captured Information descriptive flexfield. |
|
Attribute3 |
string |
Segment value 3 for the Journal Lines descriptive flexfield. |
|
Attribute4 |
string |
Segment value 4 for the Journal Lines descriptive flexfield. |
|
Attribute5 |
string |
Segment value 5 for the Journal Lines descriptive flexfield. |
|
Attribute6 |
string |
Segment value 6 for the Journal Lines descriptive flexfield. |
|
Attribute7 |
string |
Segment value 7 for the Journal Lines descriptive flexfield. |
|
Attribute8 |
string |
Segment value 8 for the Journal Lines descriptive flexfield. |
|
Attribute9 |
string |
Segment value 9 for the Journal Lines descriptive flexfield. |
|
AttributeCategory |
string |
The context code for the Journal Lines descriptive flexfield. Use the Manage General Ledger Descriptive Flexfields task to identify valid values. Use Attribute1 to Attribute10 for the segment values. |
|
AttributeCategory2 |
string |
The context code for the Journals Captured Information descriptive flexfield. Use the Manage General Ledger Descriptive Flexfields task to identify valid values. Use Attribute11 to Attribute20 for the segment values. |
|
AttributeCategory3 |
string |
Oracle internal use only. |
|
AttributeDate1 |
{http://xmlns.oracle.com/adf/svc/types/}date-Date |
Descriptive Flexfield: segment of the user descriptive flexfield. |
|
AttributeDate10 |
{http://xmlns.oracle.com/adf/svc/types/}date-Date |
Descriptive Flexfield: segment of the user descriptive flexfield. |
|
AttributeDate2 |
{http://xmlns.oracle.com/adf/svc/types/}date-Date |
Descriptive Flexfield: segment of the user descriptive flexfield. |
|
AttributeDate3 |
{http://xmlns.oracle.com/adf/svc/types/}date-Date |
Descriptive Flexfield: segment of the user descriptive flexfield. |
|
AttributeDate4 |
{http://xmlns.oracle.com/adf/svc/types/}date-Date |
Descriptive Flexfield: segment of the user descriptive flexfield. |
|
AttributeDate5 |
{http://xmlns.oracle.com/adf/svc/types/}date-Date |
Descriptive Flexfield: segment of the user descriptive flexfield. |
|
AttributeDate6 |
{http://xmlns.oracle.com/adf/svc/types/}date-Date |
Descriptive Flexfield: segment of the user descriptive flexfield. |
|
AttributeDate7 |
{http://xmlns.oracle.com/adf/svc/types/}date-Date |
Descriptive Flexfield: segment of the user descriptive flexfield. |
|
AttributeDate8 |
{http://xmlns.oracle.com/adf/svc/types/}date-Date |
Descriptive Flexfield: segment of the user descriptive flexfield. |
|
AttributeDate9 |
{http://xmlns.oracle.com/adf/svc/types/}date-Date |
Descriptive Flexfield: segment of the user descriptive flexfield. |
|
AttributeNumber1 |
decimal |
Descriptive Flexfield: segment of the user descriptive flexfield. |
|
AttributeNumber10 |
decimal |
Descriptive Flexfield: segment of the user descriptive flexfield. |
|
AttributeNumber2 |
decimal |
Descriptive Flexfield: segment of the user descriptive flexfield. |
|
AttributeNumber3 |
decimal |
Descriptive Flexfield: segment of the user descriptive flexfield. |
|
AttributeNumber4 |
decimal |
Descriptive Flexfield: segment of the user descriptive flexfield. |
|
AttributeNumber5 |
decimal |
Descriptive Flexfield: segment of the user descriptive flexfield. |
|
AttributeNumber6 |
decimal |
Descriptive Flexfield: segment of the user descriptive flexfield. |
|
AttributeNumber7 |
decimal |
Descriptive Flexfield: segment of the user descriptive flexfield. |
|
AttributeNumber8 |
decimal |
Descriptive Flexfield: segment of the user descriptive flexfield. |
|
AttributeNumber9 |
decimal |
Descriptive Flexfield: segment of the user descriptive flexfield. |
|
AverageJournalFlag |
boolean |
The indicator for whether the journal is an average balances journal. |
|
BalanceType |
string |
The balance type of the journal. |
|
BalancingSegmentValue |
string |
Oracle internal use only. |
|
ChartOfAccountsId |
long |
The unique identifier for the chart of accounts. |
|
CodeCombinationId |
long |
The unique identifier for the account combination. |
|
CurrencyCode |
string |
The currency of the journal amounts. |
|
CurrencyConversionDate |
{http://xmlns.oracle.com/adf/svc/types/}date-Date |
The date used to convert journal amounts from the entered currency to the ledger currency. |
|
CurrencyConversionRate |
decimal |
The rate used to convert journal amounts from the entered currency to the ledger currency. |
|
CurrencyConversionType |
string |
The type of currency conversion. For Oracle Fusion ERP in the Cloud, use the UserCurrencyConversionType attribute instead. |
|
DescrFlexErrorMessage |
string |
Oracle internal use only. |
|
EnteredCrAmount |
{http://xmlns.oracle.com/adf/svc/types/}AmountType |
The transaction credit amount in the entered currency. |
|
EnteredDrAmount |
{http://xmlns.oracle.com/adf/svc/types/}AmountType |
The transaction debit amount in the entered currency. |
|
GlInterfaceId |
long |
Oracle internal use only.
|
|
GlSlLinkId |
decimal |
The link to associated subledger data. Oracle internal use only. |
|
GlSlLinkTable |
string |
The table that contains associated subledger data. Oracle internal use only. |
|
GroupId |
long |
Oracle internal use only. |
|
InvoiceAmount |
{http://xmlns.oracle.com/adf/svc/types/}AmountType |
Oracle internal use only. |
|
InvoiceDate |
{http://xmlns.oracle.com/adf/svc/types/}date-Date |
Oracle internal use only. |
|
InvoiceIdentifier |
string |
Oracle internal use only. |
|
JeCategoryName |
string |
Oracle internal use only. |
|
JeSourceName |
string |
Oracle internal use only. |
|
JgzzReconReference |
string |
Oracle internal use only. |
|
JournalLineGdf |
Journal Line Global Descriptive Flexfield. |
|
|
LedgerId |
long |
The unique identifier for the ledger. |
|
LedgerName |
string |
Ledger name for the journal to be imported. |
|
LegalEntityIdentifier |
string |
Unique number used to identify a legal entity. |
|
ManagementSegmentValue |
string |
Oracle internal use only. |
|
ObjectVersionNumber |
int |
Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. |
|
OriginatingBalSegValue |
string |
The originating balancing segment value for intercompany transactions. |
|
PeriodName |
string |
The accounting period in which the journal entries are recorded. |
|
Reference1 |
string |
The name of the journal batch. |
|
Reference10 |
string |
The description of the journal entry line. |
|
Reference11 |
string |
Oracle internal use only. |
|
Reference12 |
string |
Oracle internal use only. |
|
Reference13 |
string |
Oracle internal use only. |
|
Reference14 |
string |
Oracle internal use only. |
|
Reference15 |
string |
Oracle internal use only. |
|
Reference16 |
string |
Oracle internal use only. |
|
Reference17 |
string |
Oracle internal use only. |
|
Reference18 |
string |
Oracle internal use only. |
|
Reference19 |
string |
Oracle internal use only. |
|
Reference2 |
string |
The description of the journal batch. |
|
Reference20 |
string |
Oracle internal use only. |
|
Reference21 |
string |
Journal line reference column 1. |
|
Reference22 |
string |
Journal line reference column 2. |
|
Reference23 |
string |
Journal line reference column 3. |
|
Reference24 |
string |
Journal line reference column 4. |
|
Reference25 |
string |
Journal line reference column 5. |
|
Reference26 |
string |
Journal line reference column 6. |
|
Reference27 |
string |
Journal line reference column 7. |
|
Reference28 |
string |
Journal line reference column 8. |
|
Reference29 |
string |
Journal line reference column 9. |
|
Reference3 |
string |
Oracle internal use only. |
|
Reference30 |
string |
Journal line reference column 10. |
|
Reference4 |
string |
The name of the journal. |
|
Reference5 |
string |
The description of the journal. |
|
Reference6 |
string |
The journal entry reference. This is a free text attribute. |
|
Reference7 |
string |
The indicator for whether the journal entry can be reversed. Valid values: Y, N. |
|
Reference8 |
string |
The period in which the journal entry is reversed. |
|
Reference9 |
string |
The method for reversing the journal entry. Valid values: Y, N. Meanings: Y changes sign, N switches debits to credits. |
|
ReferenceDate |
{http://xmlns.oracle.com/adf/svc/types/}date-Date |
The reference date for sequencing to meet statutory requirements in Italy. Date format: YYYY/MM/DD. |
|
Segment1 |
string |
Segment value 1 of the account combination. |
|
Segment10 |
string |
Segment value 10 of the account combination. |
|
Segment11 |
string |
Segment value 11 of the account combination. |
|
Segment12 |
string |
Segment value 12 of the account combination. |
|
Segment13 |
string |
Segment value 13 of the account combination. |
|
Segment14 |
string |
Segment value 14 of the account combination. |
|
Segment15 |
string |
Segment value 15 of the account combination. |
|
Segment16 |
string |
Segment value 16 of the account combination. |
|
Segment17 |
string |
Segment value 17 of the account combination. |
|
Segment18 |
string |
Segment value 18 of the account combination. |
|
Segment19 |
string |
Segment value 19 of the account combination. |
|
Segment2 |
string |
Segment value 2 of the account combination. |
|
Segment20 |
string |
Segment value 20 of the account combination. |
|
Segment21 |
string |
Segment value 21 of the account combination. |
|
Segment22 |
string |
Segment value 22 of the account combination. |
|
Segment23 |
string |
Segment value 23 of the account combination. |
|
Segment24 |
string |
Segment value 24 of the account combination. |
|
Segment25 |
string |
Segment value 25 of the account combination. |
|
Segment26 |
string |
Segment value 26 of the account combination. |
|
Segment27 |
string |
Segment value 27 of the account combination. |
|
Segment28 |
string |
Segment value 28 of the account combination. |
|
Segment29 |
string |
Segment value 29 of the account combination. |
|
Segment3 |
string |
Segment value 3 of the account combination. |
|
Segment30 |
string |
Segment value 30 of the account combination. |
|
Segment4 |
string |
Segment value 4 of the account combination. |
|
Segment5 |
string |
Segment value 5 of the account combination. |
|
Segment6 |
string |
Segment value 6 of the account combination. |
|
Segment7 |
string |
Segment value 7 of the account combination. |
|
Segment8 |
string |
Segment value 8 of the account combination. |
|
Segment9 |
string |
Segment value 9 of the account combination. |
|
SetOfBooksId |
long |
Oracle internal use only. |
|
StatisticalValue |
decimal |
The statistical amount. |
|
Status |
string |
The status of the journal import. Use NEW. |
|
TaxCode |
string |
Oracle internal use only. |
|
TransactionDate |
{http://xmlns.oracle.com/adf/svc/types/}date-Date |
Oracle internal use only. |
|
USSGLTransactionCode |
string |
Oracle internal use only. |
|
UserCurrencyConversionType |
string |
The type of conversion rate and translated value for the CurrencyConversionType attribute. Use either the CurrencyConversionType attribute or the UserCurrencyConversionType attribute, but not both. |
|
UserJeCategoryName |
string |
The user-defined name for the journal entry category. |
|
UserJeSourceName |
string |
The user-defined name for the journal entry source. |