Powered by InfoCaptor


Previous Page   Next Page

Journal Lines
More Folder Details
Dependent FoldersFolder ComponentsTable ComponentsAnalyzed
NoneNone.GLFG_JOURNAL_LINESUnknown
NoneNone.GLFG_JOURNAL_LINESUnknown
NoneNone.GLFG_JOURNAL_LINESUnknown
NoneNone.GLFG_JOURNAL_LINESUnknown
Folder Items
Item NameItem DescriptionItem Depends OnIt Ext ColumnItem KeyItem Id
Account Journal Lines.AccountACCOUNTACCOUNT268430
Account 1 Journal Lines.Account 1ACCOUNT_50214ACCOUNT_50214268432
Account IDUnique identification number assigned to an account codecombination, which is a concatenation of the account segment values.Journal Lines.Account IDACCOUNT_IDACCOUNT_ID114207
Amount Includes Tax Journal Lines.Amount Includes TaxTAX_AMOUNT_INCLUDES_TAX_3TAX_AMOUNT_INCLUDES_TAX_3268445
Company Journal Lines.CompanyCOMPANY_50214COMPANY_50214268431
Context Journal Lines.ContextLINE_CONTEXTLINE_CONTEXT268438
Context Value Journal Lines.Context ValueLOCAL_CONTEXT_VALUELOCAL_CONTEXT_VALUE268451
Converted CreditThe journal line converted credit amount in the functional currency.Journal Lines.Converted CreditCONVERTED_CRCONVERTED_CR123477
Converted DebitsThe journal line converted debit amount in the functional currency.Journal Lines.Converted DebitsCONVERTED_DRCONVERTED_DR123478
Cost Center Journal Lines.Cost CenterCOST_CENTER_50214COST_CENTER_50214268433
Country Journal Lines.CountryCOUNTRY_50214COUNTRY_50214268434
Customer Journal Lines.CustomerCUSTOMER_50214CUSTOMER_50214268436
Customer/Vendor Name Journal Lines.Customer/Vendor NameTAX_CUSTOMER/VENDOR_NAME_3TAX_CUSTOMERVENDOR_NAME_3268448
Customer/Vendor Reference Journal Lines.Customer/Vendor ReferenceTAX_CUSTOMER/VENDOR_REFERENC_3TAX_CUSTOMERVENDOR_REFERENC_3268449
DescriptionThe accounting period description.Journal Lines.DescriptionDESCRIPTIONDESCRIPTION129547
Document Date Journal Lines.Document DateTAX_DOCUMENT_DATE_3TAX_DOCUMENT_DATE_3268447
Document Identifier Journal Lines.Document IdentifierTAX_DOCUMENT_IDENTIFIER_3TAX_DOCUMENT_IDENTIFIER_3268446
Effective DateThe journal entry effective date.Journal Lines.Effective DateEFFECTIVE_DATEEFFECTIVE_DATE130761
Entered CreditsThe journal line credit amount in the entered currency.Journal Lines.Entered CreditsENTERED_CRENTERED_CR133413
Entered DebitsThe journal line debit amount in the entered currency.Journal Lines.Entered DebitsENTERED_DRENTERED_DR133422
Journal Entry IDThe unique identification number assigned to a journal entry.Journal Lines.Journal Entry IDJOURNAL_ENTRY_IDJOURNAL_ENTRY_ID138304
Journal Entry NameThe name of the journal entry.Journal Lines.Journal Entry NameJOURNAL_ENTRY_NAMEJOURNAL_ENTRY_NAME138309
Journal Line NumberJournal entry line number.Journal Lines.Journal Line NumberJOURNAL_LINE_NUMBERJOURNAL_LINE_NUMBER138312
Period NameThe name of an accounting period.Journal Lines.Period NamePERIOD_NAMEPERIOD_NAME153113
Project Journal Lines.ProjectPROJECT_50214PROJECT_50214268437
Quantity Journal Lines.QuantityLINE_QUANTITYLINE_QUANTITY268440
Reconciliation Reference Journal Lines.Reconciliation ReferenceLOCAL_RECON_REFLOCAL_RECON_REF268452
Reference 10The journal line reference 10.Journal Lines.Reference 10REFERENCE_10REFERENCE_10158245
Reference 1The journal line reference 1.Journal Lines.Reference 1REFERENCE_1REFERENCE_1158244
Reference 2The journal line reference 2.Journal Lines.Reference 2REFERENCE_2REFERENCE_2158246
Reference 3The journal line reference 3.Journal Lines.Reference 3REFERENCE_3REFERENCE_3158247
Reference 4The journal line reference 4.Journal Lines.Reference 4REFERENCE_4REFERENCE_4158248
Reference 5The journal line reference 5.Journal Lines.Reference 5REFERENCE_5REFERENCE_5158249
Reference 6The journal line reference 6.Journal Lines.Reference 6REFERENCE_6REFERENCE_6158250
Reference 7The journal line reference 7.Journal Lines.Reference 7REFERENCE_7REFERENCE_7158251
Reference 8The journal line reference 8.Journal Lines.Reference 8REFERENCE_8REFERENCE_8158252
Reference 9The journal line reference 9.Journal Lines.Reference 9REFERENCE_9REFERENCE_9158253
Rounding Rule Journal Lines.Rounding RuleTAX_ROUNDING_RULE_3TAX_ROUNDING_RULE_3268444
SKU Journal Lines.SKULINE_SKULINE_SKU268439
Sales Channel Journal Lines.Sales ChannelSALES_CHANNEL_50214SALES_CHANNEL_50214268435
Set Of Books IDThe unique identification number assigned to a set of books.Journal Lines.Set Of Books IDSET_OF_BOOKS_IDSET_OF_BOOKS_ID161510
Set Of Books NameThe set of books name.Journal Lines.Set Of Books NameSET_OF_BOOKS_NAMESET_OF_BOOKS_NAME161580
Stat AmountThe statistical amount.Journal Lines.Stat AmountSTAT_AMOUNTSTAT_AMOUNT163615
Subledger Document NumberThe subledger document number a journal line references.Journal Lines.Subledger Document NumberSUBLEDGER_DOCUMENT_NUMBERSUBLEDGER_DOCUMENT_NUMBER163811
Tax Code Journal Lines.Tax CodeTAX_TAX_CODE_3TAX_TAX_CODE_3268443
Tax Line Journal Lines.Tax LineTAX_TAX_LINETAX_TAX_LINE268441
Tax Registration Number Journal Lines.Tax Registration NumberTAX_TAX_REGISTRATION_NUMBER_3TAX_TAX_REGISTRATION_NUMBER_3268450
Tax Type Journal Lines.Tax TypeTAX_TAX_TYPE_3TAX_TAX_TYPE_3268442
Account Journal Lines.AccountACCOUNTACCOUNT268430
Account 1 Journal Lines.Account 1ACCOUNT_50214ACCOUNT_50214268432
Account IDUnique identification number assigned to an account codecombination, which is a concatenation of the account segment values.Journal Lines.Account IDACCOUNT_IDACCOUNT_ID114207
Amount Includes Tax Journal Lines.Amount Includes TaxTAX_AMOUNT_INCLUDES_TAX_3TAX_AMOUNT_INCLUDES_TAX_3268445
Company Journal Lines.CompanyCOMPANY_50214COMPANY_50214268431
Context Journal Lines.ContextLINE_CONTEXTLINE_CONTEXT268438
Context Value Journal Lines.Context ValueLOCAL_CONTEXT_VALUELOCAL_CONTEXT_VALUE268451
Converted CreditThe journal line converted credit amount in the functional currency.Journal Lines.Converted CreditCONVERTED_CRCONVERTED_CR123477
Converted DebitsThe journal line converted debit amount in the functional currency.Journal Lines.Converted DebitsCONVERTED_DRCONVERTED_DR123478
Cost Center Journal Lines.Cost CenterCOST_CENTER_50214COST_CENTER_50214268433
Country Journal Lines.CountryCOUNTRY_50214COUNTRY_50214268434
Customer Journal Lines.CustomerCUSTOMER_50214CUSTOMER_50214268436
Customer/Vendor Name Journal Lines.Customer/Vendor NameTAX_CUSTOMER/VENDOR_NAME_3TAX_CUSTOMERVENDOR_NAME_3268448
Customer/Vendor Reference Journal Lines.Customer/Vendor ReferenceTAX_CUSTOMER/VENDOR_REFERENC_3TAX_CUSTOMERVENDOR_REFERENC_3268449
DescriptionThe accounting period description.Journal Lines.DescriptionDESCRIPTIONDESCRIPTION129547
Document Date Journal Lines.Document DateTAX_DOCUMENT_DATE_3TAX_DOCUMENT_DATE_3268447
Document Identifier Journal Lines.Document IdentifierTAX_DOCUMENT_IDENTIFIER_3TAX_DOCUMENT_IDENTIFIER_3268446
Effective DateThe journal entry effective date.Journal Lines.Effective DateEFFECTIVE_DATEEFFECTIVE_DATE130761
Entered CreditsThe journal line credit amount in the entered currency.Journal Lines.Entered CreditsENTERED_CRENTERED_CR133413
Entered DebitsThe journal line debit amount in the entered currency.Journal Lines.Entered DebitsENTERED_DRENTERED_DR133422
Journal Entry IDThe unique identification number assigned to a journal entry.Journal Lines.Journal Entry IDJOURNAL_ENTRY_IDJOURNAL_ENTRY_ID138304
Journal Entry NameThe name of the journal entry.Journal Lines.Journal Entry NameJOURNAL_ENTRY_NAMEJOURNAL_ENTRY_NAME138309
Journal Line NumberJournal entry line number.Journal Lines.Journal Line NumberJOURNAL_LINE_NUMBERJOURNAL_LINE_NUMBER138312
Period NameThe name of an accounting period.Journal Lines.Period NamePERIOD_NAMEPERIOD_NAME153113
Project Journal Lines.ProjectPROJECT_50214PROJECT_50214268437
Quantity Journal Lines.QuantityLINE_QUANTITYLINE_QUANTITY268440
Reconciliation Reference Journal Lines.Reconciliation ReferenceLOCAL_RECON_REFLOCAL_RECON_REF268452
Reference 10The journal line reference 10.Journal Lines.Reference 10REFERENCE_10REFERENCE_10158245
Reference 1The journal line reference 1.Journal Lines.Reference 1REFERENCE_1REFERENCE_1158244
Reference 2The journal line reference 2.Journal Lines.Reference 2REFERENCE_2REFERENCE_2158246
Reference 3The journal line reference 3.Journal Lines.Reference 3REFERENCE_3REFERENCE_3158247
Reference 4The journal line reference 4.Journal Lines.Reference 4REFERENCE_4REFERENCE_4158248
Reference 5The journal line reference 5.Journal Lines.Reference 5REFERENCE_5REFERENCE_5158249
Reference 6The journal line reference 6.Journal Lines.Reference 6REFERENCE_6REFERENCE_6158250
Reference 7The journal line reference 7.Journal Lines.Reference 7REFERENCE_7REFERENCE_7158251
Reference 8The journal line reference 8.Journal Lines.Reference 8REFERENCE_8REFERENCE_8158252
Reference 9The journal line reference 9.Journal Lines.Reference 9REFERENCE_9REFERENCE_9158253
Rounding Rule Journal Lines.Rounding RuleTAX_ROUNDING_RULE_3TAX_ROUNDING_RULE_3268444
SKU Journal Lines.SKULINE_SKULINE_SKU268439
Sales Channel Journal Lines.Sales ChannelSALES_CHANNEL_50214SALES_CHANNEL_50214268435
Set Of Books IDThe unique identification number assigned to a set of books.Journal Lines.Set Of Books IDSET_OF_BOOKS_IDSET_OF_BOOKS_ID161510
Set Of Books NameThe set of books name.Journal Lines.Set Of Books NameSET_OF_BOOKS_NAMESET_OF_BOOKS_NAME161580
Stat AmountThe statistical amount.Journal Lines.Stat AmountSTAT_AMOUNTSTAT_AMOUNT163615
Subledger Document NumberThe subledger document number a journal line references.Journal Lines.Subledger Document NumberSUBLEDGER_DOCUMENT_NUMBERSUBLEDGER_DOCUMENT_NUMBER163811
Tax Code Journal Lines.Tax CodeTAX_TAX_CODE_3TAX_TAX_CODE_3268443
Tax Line Journal Lines.Tax LineTAX_TAX_LINETAX_TAX_LINE268441
Tax Registration Number Journal Lines.Tax Registration NumberTAX_TAX_REGISTRATION_NUMBER_3TAX_TAX_REGISTRATION_NUMBER_3268450
Tax Type Journal Lines.Tax TypeTAX_TAX_TYPE_3TAX_TAX_TYPE_3268442
Account Journal Lines.AccountACCOUNTACCOUNT268430
Account 1 Journal Lines.Account 1ACCOUNT_50214ACCOUNT_50214268432
Account IDUnique identification number assigned to an account codecombination, which is a concatenation of the account segment values.Journal Lines.Account IDACCOUNT_IDACCOUNT_ID114207
Amount Includes Tax Journal Lines.Amount Includes TaxTAX_AMOUNT_INCLUDES_TAX_3TAX_AMOUNT_INCLUDES_TAX_3268445
Company Journal Lines.CompanyCOMPANY_50214COMPANY_50214268431
Context Journal Lines.ContextLINE_CONTEXTLINE_CONTEXT268438
Context Value Journal Lines.Context ValueLOCAL_CONTEXT_VALUELOCAL_CONTEXT_VALUE268451
Converted CreditThe journal line converted credit amount in the functional currency.Journal Lines.Converted CreditCONVERTED_CRCONVERTED_CR123477
Converted DebitsThe journal line converted debit amount in the functional currency.Journal Lines.Converted DebitsCONVERTED_DRCONVERTED_DR123478
Cost Center Journal Lines.Cost CenterCOST_CENTER_50214COST_CENTER_50214268433
Country Journal Lines.CountryCOUNTRY_50214COUNTRY_50214268434
Customer Journal Lines.CustomerCUSTOMER_50214CUSTOMER_50214268436
Customer/Vendor Name Journal Lines.Customer/Vendor NameTAX_CUSTOMER/VENDOR_NAME_3TAX_CUSTOMERVENDOR_NAME_3268448
Customer/Vendor Reference Journal Lines.Customer/Vendor ReferenceTAX_CUSTOMER/VENDOR_REFERENC_3TAX_CUSTOMERVENDOR_REFERENC_3268449
DescriptionThe accounting period description.Journal Lines.DescriptionDESCRIPTIONDESCRIPTION129547
Document Date Journal Lines.Document DateTAX_DOCUMENT_DATE_3TAX_DOCUMENT_DATE_3268447
Document Identifier Journal Lines.Document IdentifierTAX_DOCUMENT_IDENTIFIER_3TAX_DOCUMENT_IDENTIFIER_3268446
Effective DateThe journal entry effective date.Journal Lines.Effective DateEFFECTIVE_DATEEFFECTIVE_DATE130761
Entered CreditsThe journal line credit amount in the entered currency.Journal Lines.Entered CreditsENTERED_CRENTERED_CR133413
Entered DebitsThe journal line debit amount in the entered currency.Journal Lines.Entered DebitsENTERED_DRENTERED_DR133422
Journal Entry IDThe unique identification number assigned to a journal entry.Journal Lines.Journal Entry IDJOURNAL_ENTRY_IDJOURNAL_ENTRY_ID138304
Journal Entry NameThe name of the journal entry.Journal Lines.Journal Entry NameJOURNAL_ENTRY_NAMEJOURNAL_ENTRY_NAME138309
Journal Line NumberJournal entry line number.Journal Lines.Journal Line NumberJOURNAL_LINE_NUMBERJOURNAL_LINE_NUMBER138312
Period NameThe name of an accounting period.Journal Lines.Period NamePERIOD_NAMEPERIOD_NAME153113
Project Journal Lines.ProjectPROJECT_50214PROJECT_50214268437
Quantity Journal Lines.QuantityLINE_QUANTITYLINE_QUANTITY268440
Reconciliation Reference Journal Lines.Reconciliation ReferenceLOCAL_RECON_REFLOCAL_RECON_REF268452
Reference 10The journal line reference 10.Journal Lines.Reference 10REFERENCE_10REFERENCE_10158245
Reference 1The journal line reference 1.Journal Lines.Reference 1REFERENCE_1REFERENCE_1158244
Reference 2The journal line reference 2.Journal Lines.Reference 2REFERENCE_2REFERENCE_2158246
Reference 3The journal line reference 3.Journal Lines.Reference 3REFERENCE_3REFERENCE_3158247
Reference 4The journal line reference 4.Journal Lines.Reference 4REFERENCE_4REFERENCE_4158248
Reference 5The journal line reference 5.Journal Lines.Reference 5REFERENCE_5REFERENCE_5158249
Reference 6The journal line reference 6.Journal Lines.Reference 6REFERENCE_6REFERENCE_6158250
Reference 7The journal line reference 7.Journal Lines.Reference 7REFERENCE_7REFERENCE_7158251
Reference 8The journal line reference 8.Journal Lines.Reference 8REFERENCE_8REFERENCE_8158252
Reference 9The journal line reference 9.Journal Lines.Reference 9REFERENCE_9REFERENCE_9158253
Rounding Rule Journal Lines.Rounding RuleTAX_ROUNDING_RULE_3TAX_ROUNDING_RULE_3268444
SKU Journal Lines.SKULINE_SKULINE_SKU268439
Sales Channel Journal Lines.Sales ChannelSALES_CHANNEL_50214SALES_CHANNEL_50214268435
Set Of Books IDThe unique identification number assigned to a set of books.Journal Lines.Set Of Books IDSET_OF_BOOKS_IDSET_OF_BOOKS_ID161510
Set Of Books NameThe set of books name.Journal Lines.Set Of Books NameSET_OF_BOOKS_NAMESET_OF_BOOKS_NAME161580
Stat AmountThe statistical amount.Journal Lines.Stat AmountSTAT_AMOUNTSTAT_AMOUNT163615
Subledger Document NumberThe subledger document number a journal line references.Journal Lines.Subledger Document NumberSUBLEDGER_DOCUMENT_NUMBERSUBLEDGER_DOCUMENT_NUMBER163811
Tax Code Journal Lines.Tax CodeTAX_TAX_CODE_3TAX_TAX_CODE_3268443
Tax Line Journal Lines.Tax LineTAX_TAX_LINETAX_TAX_LINE268441
Tax Registration Number Journal Lines.Tax Registration NumberTAX_TAX_REGISTRATION_NUMBER_3TAX_TAX_REGISTRATION_NUMBER_3268450
Tax Type Journal Lines.Tax TypeTAX_TAX_TYPE_3TAX_TAX_TYPE_3268442
Account Journal Lines.AccountACCOUNTACCOUNT268430
Account 1 Journal Lines.Account 1ACCOUNT_50214ACCOUNT_50214268432
Account IDUnique identification number assigned to an account codecombination, which is a concatenation of the account segment values.Journal Lines.Account IDACCOUNT_IDACCOUNT_ID114207
Amount Includes Tax Journal Lines.Amount Includes TaxTAX_AMOUNT_INCLUDES_TAX_3TAX_AMOUNT_INCLUDES_TAX_3268445
Company Journal Lines.CompanyCOMPANY_50214COMPANY_50214268431
Context Journal Lines.ContextLINE_CONTEXTLINE_CONTEXT268438
Context Value Journal Lines.Context ValueLOCAL_CONTEXT_VALUELOCAL_CONTEXT_VALUE268451
Converted CreditThe journal line converted credit amount in the functional currency.Journal Lines.Converted CreditCONVERTED_CRCONVERTED_CR123477
Converted DebitsThe journal line converted debit amount in the functional currency.Journal Lines.Converted DebitsCONVERTED_DRCONVERTED_DR123478
Cost Center Journal Lines.Cost CenterCOST_CENTER_50214COST_CENTER_50214268433
Country Journal Lines.CountryCOUNTRY_50214COUNTRY_50214268434
Customer Journal Lines.CustomerCUSTOMER_50214CUSTOMER_50214268436
Customer/Vendor Name Journal Lines.Customer/Vendor NameTAX_CUSTOMER/VENDOR_NAME_3TAX_CUSTOMERVENDOR_NAME_3268448
Customer/Vendor Reference Journal Lines.Customer/Vendor ReferenceTAX_CUSTOMER/VENDOR_REFERENC_3TAX_CUSTOMERVENDOR_REFERENC_3268449
DescriptionThe accounting period description.Journal Lines.DescriptionDESCRIPTIONDESCRIPTION129547
Document Date Journal Lines.Document DateTAX_DOCUMENT_DATE_3TAX_DOCUMENT_DATE_3268447
Document Identifier Journal Lines.Document IdentifierTAX_DOCUMENT_IDENTIFIER_3TAX_DOCUMENT_IDENTIFIER_3268446
Effective DateThe journal entry effective date.Journal Lines.Effective DateEFFECTIVE_DATEEFFECTIVE_DATE130761
Entered CreditsThe journal line credit amount in the entered currency.Journal Lines.Entered CreditsENTERED_CRENTERED_CR133413
Entered DebitsThe journal line debit amount in the entered currency.Journal Lines.Entered DebitsENTERED_DRENTERED_DR133422
Journal Entry IDThe unique identification number assigned to a journal entry.Journal Lines.Journal Entry IDJOURNAL_ENTRY_IDJOURNAL_ENTRY_ID138304
Journal Entry NameThe name of the journal entry.Journal Lines.Journal Entry NameJOURNAL_ENTRY_NAMEJOURNAL_ENTRY_NAME138309
Journal Line NumberJournal entry line number.Journal Lines.Journal Line NumberJOURNAL_LINE_NUMBERJOURNAL_LINE_NUMBER138312
Period NameThe name of an accounting period.Journal Lines.Period NamePERIOD_NAMEPERIOD_NAME153113
Project Journal Lines.ProjectPROJECT_50214PROJECT_50214268437
Quantity Journal Lines.QuantityLINE_QUANTITYLINE_QUANTITY268440
Reconciliation Reference Journal Lines.Reconciliation ReferenceLOCAL_RECON_REFLOCAL_RECON_REF268452
Reference 10The journal line reference 10.Journal Lines.Reference 10REFERENCE_10REFERENCE_10158245
Reference 1The journal line reference 1.Journal Lines.Reference 1REFERENCE_1REFERENCE_1158244
Reference 2The journal line reference 2.Journal Lines.Reference 2REFERENCE_2REFERENCE_2158246
Reference 3The journal line reference 3.Journal Lines.Reference 3REFERENCE_3REFERENCE_3158247
Reference 4The journal line reference 4.Journal Lines.Reference 4REFERENCE_4REFERENCE_4158248
Reference 5The journal line reference 5.Journal Lines.Reference 5REFERENCE_5REFERENCE_5158249
Reference 6The journal line reference 6.Journal Lines.Reference 6REFERENCE_6REFERENCE_6158250
Reference 7The journal line reference 7.Journal Lines.Reference 7REFERENCE_7REFERENCE_7158251
Reference 8The journal line reference 8.Journal Lines.Reference 8REFERENCE_8REFERENCE_8158252
Reference 9The journal line reference 9.Journal Lines.Reference 9REFERENCE_9REFERENCE_9158253
Rounding Rule Journal Lines.Rounding RuleTAX_ROUNDING_RULE_3TAX_ROUNDING_RULE_3268444
SKU Journal Lines.SKULINE_SKULINE_SKU268439
Sales Channel Journal Lines.Sales ChannelSALES_CHANNEL_50214SALES_CHANNEL_50214268435
Set Of Books IDThe unique identification number assigned to a set of books.Journal Lines.Set Of Books IDSET_OF_BOOKS_IDSET_OF_BOOKS_ID161510
Set Of Books NameThe set of books name.Journal Lines.Set Of Books NameSET_OF_BOOKS_NAMESET_OF_BOOKS_NAME161580
Stat AmountThe statistical amount.Journal Lines.Stat AmountSTAT_AMOUNTSTAT_AMOUNT163615
Subledger Document NumberThe subledger document number a journal line references.Journal Lines.Subledger Document NumberSUBLEDGER_DOCUMENT_NUMBERSUBLEDGER_DOCUMENT_NUMBER163811
Tax Code Journal Lines.Tax CodeTAX_TAX_CODE_3TAX_TAX_CODE_3268443
Tax Line Journal Lines.Tax LineTAX_TAX_LINETAX_TAX_LINE268441
Tax Registration Number Journal Lines.Tax Registration NumberTAX_TAX_REGISTRATION_NUMBER_3TAX_TAX_REGISTRATION_NUMBER_3268450
Tax Type Journal Lines.Tax TypeTAX_TAX_TYPE_3TAX_TAX_TYPE_3268442
Folder Joins
Join NameJoin ConditionJoin DetailsOptional Join ConfigurationAuto
Journal Lines -> Accounting Entry LinesJournal Lines.Reference 9 = Accounting Entry Lines.GL Reference 9 Journal Lines.Reference 10 = Accounting Entry Lines.GL Reference 10 Journal Lines.Account ID = Accounting Entry Lines.Account ID Journal Lines.Set Of Books ID = Accounting Entry Lines.Set Of Books IdMight not exist in master folderOuter join on detail No
Journal Lines -> Bank Statement ReconciliationsJournal Lines.Journal Entry ID = Bank Statement Reconciliations.Journal Header Id Journal Lines.Journal Line Number = Bank Statement Reconciliations.Journal Line NumberAlways exist in master folderNoneNo