Powered by InfoCaptor


Previous Page   Next Page

Bank Statements
More Folder Details
Dependent FoldersFolder ComponentsTable ComponentsAnalyzed
NoneNone.CEFG_BANK_STATEMENTSUnknown
Folder Items
Item NameItem DescriptionItem Depends OnIt Ext ColumnItem KeyItem Id
Bank Account IDBank account uniquely identifier.Bank Statements.Bank Account IDBANK_ACCOUNT_IDBANK_ACCOUNT_ID119006
Bank Account Name Bank Statements.Bank Account NameBANK_ACCOUNT_NAMEBANK_ACCOUNT_NAME119025
Bank Account Number Bank Statements.Bank Account NumberBANK_ACCOUNT_NUMBERBANK_ACCOUNT_NUMBER119041
Beginning BalanceBeginning balance of the bank statement.Bank Statements.Beginning BalanceBEGINNING_BALANCEBEGINNING_BALANCE119451
Check DigitsHolds any check digits that result from bank account number validation in FBS.Bank Statements.Check DigitsCHECK_DIGITSCHECK_DIGITS121960
Completion StatusIndicates whether the bank statement is completely reconciled or not.Bank Statements.Completion StatusCOMPLETION_STATUSCOMPLETION_STATUS122900
Created ByStandard WHO column.Bank Statements.Created ByCREATED_BYCREATED_BY124567
Created DateStandard WHO column.Bank Statements.Created DateCREATED_DATECREATED_DATE125366
Credit Line CountTotal number of receipt transactions in the bank statement.Bank Statements.Credit Line CountCREDIT_LINE_COUNTCREDIT_LINE_COUNT126755
Credit TotalTotal deposit or receipt amount of the bank statement.Bank Statements.Credit TotalCREDIT_TOTALCREDIT_TOTAL126796
Currency CodeCurrency code for pricelist; FK to gl_curr_mst.Bank Statements.Currency CodeCURRENCY_CODECURRENCY_CODE126996
Debit Line CountTotal number of payment transactions in the bank statement.Bank Statements.Debit Line CountDEBIT_LINE_COUNTDEBIT_LINE_COUNT128739
Debit TotalTotal payment amount of the bank statement.Bank Statements.Debit TotalDEBIT_TOTALDEBIT_TOTAL128742
Document Sequence NumberA sequence number assigned by the system or by you. This number maybe used to uniquely identify your bank statements.Bank Statements.Document Sequence NumberDOCUMENT_SEQUENCE_NUMBERDOCUMENT_SEQUENCE_NUMBER130364
Ending BalanceEnding balance of the bank statement.Bank Statements.Ending BalanceENDING_BALANCEENDING_BALANCE132713
Last Updated ByStandard WHO column.Bank Statements.Last Updated ByLAST_UPDATED_BYLAST_UPDATED_BY139193
Last Updated DateStandard WHO column.Bank Statements.Last Updated DateLAST_UPDATED_DATELAST_UPDATED_DATE139943
Organization IDOrganization identifier.Bank Statements.Organization IDORG_IDORG_ID150954
Organization Name Bank Statements.Organization NameORG_NAMEORG_NAME151037
Statement DateBank statement date.Bank Statements.Statement DateSTATEMENT_DATESTATEMENT_DATE163377
Statement Date - Day Bank Statements.Statement Date STATEMENT_DATE_DAY191485
Statement Date - Month Bank Statements.Statement Date STATEMENT_DATE_MONTH191489
Statement Date - Quarter Bank Statements.Statement Date STATEMENT_DATE_QUARTER191493
Statement Date - Year Bank Statements.Statement Date STATEMENT_DATE_YEAR191497
Statement IdBank statement header identifier.Bank Statements.Statement IdSTATEMENT_IDSTATEMENT_ID163380
Statement NumberStatement number to which this line belongs.Bank Statements.Statement NumberSTATEMENT_NUMBERSTATEMENT_NUMBER163388
Folder Joins
Join NameJoin ConditionJoin DetailsOptional Join ConfigurationAuto
Bank Statements -> Bank Statement LinesBank Statements.Statement Id = Bank Statement Lines.Statement IdAlways exist in master folderNoneNo