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