Powered by InfoCaptor


Previous Page   Next Page

Bank Statement Lines
More Folder Details
Dependent FoldersFolder ComponentsTable ComponentsAnalyzed
NoneNone.CEFG_BANK_STATEMENT_LINESUnknown
Folder Items
Item NameItem DescriptionItem Depends OnIt Ext ColumnItem KeyItem Id
AgentCustomer number of supplier number that may be used to identify thematching transaction.Bank Statement Lines.AgentAGENTAGENT115330
Agent Bank Account NumberCustomer or supplier bank account that may be used for identifying thematching transaction.Bank Statement Lines.Agent Bank Account NumberAGENT_BANK_ACCOUNT_NUMBERAGENT_BANK_ACCOUNT_NUMBER115333
AmountThe amount of revenue authorized for the agreement.Bank Statement Lines.AmountAMOUNTAMOUNT115858
ChargesAny charges applicable to this external transaction.Bank Statement Lines.ChargesCHARGESCHARGES121905
Created ByStandard WHO column.Bank Statement Lines.Created ByCREATED_BYCREATED_BY124568
Created DateStandard WHO column.Bank Statement Lines.Created DateCREATED_DATECREATED_DATE125367
Currency CodeCurrency code for pricelist; FK to gl_curr_mst.Bank Statement Lines.Currency CodeCURRENCY_CODECURRENCY_CODE126997
DescriptionThe accounting period description.Bank Statement Lines.DescriptionDESCRIPTIONDESCRIPTION129521
Effective DateThe journal entry effective date.Bank Statement Lines.Effective DateEFFECTIVE_DATEEFFECTIVE_DATE130756
Effective Date - Day Bank Statement Lines.Effective Date EFFECTIVE_DATE_DAY176515
Effective Date - Month Bank Statement Lines.Effective Date EFFECTIVE_DATE_MONTH176519
Effective Date - Quarter Bank Statement Lines.Effective Date EFFECTIVE_DATE_QUARTER176523
Effective Date - Year Bank Statement Lines.Effective Date EFFECTIVE_DATE_YEAR176527
Exchange DateCurrency exchange date for determining the currency exchange rate tobe used for converting the source transaction amount to the forecastcurrency amount.Bank Statement Lines.Exchange DateEXCHANGE_DATEEXCHANGE_DATE133778
Exchange RateCurrency exchange rate used for converting the source transactionamount to the forecast currency amount for the 'User' exchange ratetype.Bank Statement Lines.Exchange RateEXCHANGE_RATEEXCHANGE_RATE133786
Exchange Rate TypeCurrency exchange rate type used for converting the sourcetransaction amount to the forecast currency amount.Bank Statement Lines.Exchange Rate TypeEXCHANGE_RATE_TYPEEXCHANGE_RATE_TYPE133802
Invoice NumberInvoice number that may be used for identifying the matchingtransaction.Bank Statement Lines.Invoice NumberINVOICE_NUMBERINVOICE_NUMBER137463
Last Updated ByStandard WHO column.Bank Statement Lines.Last Updated ByLAST_UPDATED_BYLAST_UPDATED_BY139194
Last Updated DateStandard WHO column.Bank Statement Lines.Last Updated DateLAST_UPDATED_DATELAST_UPDATED_DATE139944
Line NumberUser-assigned bank statement line number to uniquely identifyindividual transactions.Bank Statement Lines.Line NumberLINE_NUMBERLINE_NUMBER144717
Reconciliation StatusStatus that indicates whether the bank statement is matched to atransaction or not.Bank Statement Lines.Reconciliation StatusRECONCILIATION_STATUSRECONCILIATION_STATUS158135
Statement DateBank statement date.Bank Statement Lines.Statement DateSTATEMENT_DATESTATEMENT_DATE163378
Statement Date - Day Bank Statement Lines.Statement Date STATEMENT_DATE_DAY191487
Statement Date - Month Bank Statement Lines.Statement Date STATEMENT_DATE_MONTH191491
Statement Date - Quarter Bank Statement Lines.Statement Date STATEMENT_DATE_QUARTER191495
Statement Date - Year Bank Statement Lines.Statement Date STATEMENT_DATE_YEAR191499
Statement IdBank statement header identifier.Bank Statement Lines.Statement IdSTATEMENT_IDSTATEMENT_ID163381
Statement Line IdBank statement line identifier.Bank Statement Lines.Statement Line IdSTATEMENT_LINE_IDSTATEMENT_LINE_ID163382
Statement NumberStatement number to which this line belongs.Bank Statement Lines.Statement NumberSTATEMENT_NUMBERSTATEMENT_NUMBER163389
Transaction AmountTransaction amount in the transaction currency, not in the bankcurrency.Bank Statement Lines.Transaction AmountTRANSACTION_AMOUNTTRANSACTION_AMOUNT165612
Transaction CodeA bank-assigned code used to identify the type of banking activities.Bank Statement Lines.Transaction CodeTRANSACTION_CODETRANSACTION_CODE165615
Transaction Date Bank Statement Lines.Transaction DateTRANSACTION_DATETRANSACTION_DATE165639
Transaction Date - Day Bank Statement Lines.Transaction Date TRANSACTION_DATE_DAY192319
Transaction Date - Month Bank Statement Lines.Transaction Date TRANSACTION_DATE_MONTH192373
Transaction Date - Quarter Bank Statement Lines.Transaction Date TRANSACTION_DATE_QUARTER192427
Transaction Date - Year Bank Statement Lines.Transaction Date TRANSACTION_DATE_YEAR192481
Transaction Number Bank Statement Lines.Transaction NumberTRANSACTION_NUMBERTRANSACTION_NUMBER165760
Transaction TypeType of the external cash transaction, either payment or receipt.Bank Statement Lines.Transaction TypeTRANSACTION_TYPETRANSACTION_TYPE165839
Folder Joins
Join NameJoin ConditionJoin DetailsOptional Join ConfigurationAuto
Bank Statement Lines -> Bank Statement Reconciliation ErrorsBank Statement Lines.Statement Line Id = Bank Statement Reconciliation Errors.Statement Line IdAlways exist in master folderOuter join on detail No
Bank Statement Lines -> Bank Statement ReconciliationsBank Statement Lines.Statement Line Id = Bank Statement Reconciliations.Statement Line IdAlways exist in master folderOuter join on detail No
Bank Statement Lines -> Bank Statement Reconciliations 1Bank Statement Lines.Statement Line Id = Bank Statement Reconciliations.Matching Statement Line IdAlways exist in master folderNoneNo