Powered by InfoCaptor


Previous Page   Next Page

Account Balances
More Folder Details
Dependent FoldersFolder ComponentsTable ComponentsAnalyzed
NoneNone.AXFG_ACCOUNT_BALANCESUnknown
Folder Items
Item NameItem DescriptionItem Depends OnIt Ext ColumnItem KeyItem Id
Account Account Balances.AccountACCOUNTACCOUNT268012
Account 1 Account Balances.Account 1ACCOUNT_50214ACCOUNT_50214268014
Account IDUnique identification number assigned to an account codecombination, which is a concatenation of the account segment values.Account Balances.Account IDACCOUNT_IDACCOUNT_ID114196
Account SegmentName of the Account SegmentAccount Balances.Account SegmentACCOUNT_SEGMENTACCOUNT_SEGMENT114274
Application IdApplication identifierAccount Balances.Application IdAPPLICATION_IDAPPLICATION_ID116097
Application Name Account Balances.Application NameAPPLICATION_NAMEAPPLICATION_NAME116246
Balancing SegmentName of the Balancing Segment (accounting area)Account Balances.Balancing SegmentBALANCING_SEGMENTBALANCING_SEGMENT118993
Beginning BalanceBeginning balance of the bank statement.Account Balances.Beginning BalanceBEGINNING_BALANCEBEGINNING_BALANCE119450
Company Account Balances.CompanyCOMPANY_50214COMPANY_50214268013
Cost Center Account Balances.Cost CenterCOST_CENTER_50214COST_CENTER_50214268015
Country Account Balances.CountryCOUNTRY_50214COUNTRY_50214268016
Created ByStandard WHO column.Account Balances.Created ByCREATED_BYCREATED_BY124565
Creation DateStandard WHO column.Account Balances.Creation DateCREATION_DATECREATION_DATE125997
Creation Date - Day Account Balances.Creation Date CREATION_DATE_DAY172145
Creation Date - Month Account Balances.Creation Date CREATION_DATE_MONTH172599
Creation Date - Quarter Account Balances.Creation Date CREATION_DATE_QUARTER173053
Creation Date - Year Account Balances.Creation Date CREATION_DATE_YEAR173507
Credit Beginning BalanceCR balance at beginning of period, credit total onlyAccount Balances.Credit Beginning BalanceCREDIT_BEGINNING_BALANCECREDIT_BEGINNING_BALANCE126729
Credit Ending BalanceCR balance at end of the period, credit total onlyAccount Balances.Credit Ending BalanceCREDIT_ENDING_BALANCECREDIT_ENDING_BALANCE126745
Credit TransactionCR total during the period, credit transactions onlyAccount Balances.Credit TransactionCREDIT_TRANSACTIONCREDIT_TRANSACTION126797
Customer Account Balances.CustomerCUSTOMER_50214CUSTOMER_50214268018
Debit Beginning BalanceDR balance at beginning of the period, debit total onlyAccount Balances.Debit Beginning BalanceDEBIT_BEGINNING_BALANCEDEBIT_BEGINNING_BALANCE128735
Debit Ending BalanceDR balance at end of the period, debit total onlyAccount Balances.Debit Ending BalanceDEBIT_ENDING_BALANCEDEBIT_ENDING_BALANCE128738
Debit TransactionDR total during the period, debit transactions onlyAccount Balances.Debit TransactionDEBIT_TRANSACTIONDEBIT_TRANSACTION128743
Ending BalanceEnding balance of the bank statement.Account Balances.Ending BalanceENDING_BALANCEENDING_BALANCE132712
Historic BalanceA flag indicating that either the balance was not calculated from accounting lines,but was manually entered (initial balance) or that the lines that made up the balance were purgedAccount Balances.Historic BalanceHISTORIC_BALANCEHISTORIC_BALANCE135810
Last Update DateStandard WHO column.Account Balances.Last Update DateLAST_UPDATE_DATELAST_UPDATE_DATE140528
Last Update Date - Day Account Balances.Last Update Date LAST_UPDATE_DATE_DAY183550
Last Update Date - Month Account Balances.Last Update Date LAST_UPDATE_DATE_MONTH183978
Last Update Date - Quarter Account Balances.Last Update Date LAST_UPDATE_DATE_QUARTER184406
Last Update Date - Year Account Balances.Last Update Date LAST_UPDATE_DATE_YEAR184834
Last Updated ByStandard WHO column.Account Balances.Last Updated ByLAST_UPDATED_BYLAST_UPDATED_BY139189
Period NameThe name of an accounting period.Account Balances.Period NamePERIOD_NAMEPERIOD_NAME153091
Period Name Sort NumberNumber that allows balances to be sorted by historical orderrather than by (alphabetical) period nameAccount Balances.Period Name Sort NumberPERIOD_NAME_SORT_NUMBERPERIOD_NAME_SORT_NUMBER153154
Project Account Balances.ProjectPROJECT_50214PROJECT_50214268019
Sales Channel Account Balances.Sales ChannelSALES_CHANNEL_50214SALES_CHANNEL_50214268017
Set Of Books IdThe unique identification number assigned to a set of books.Account Balances.Set Of Books IdSET_OF_BOOKS_IDSET_OF_BOOKS_ID161484
Set Of Books NameThe set of books name.Account Balances.Set Of Books NameSET_OF_BOOKS_NAMESET_OF_BOOKS_NAME161553
Trading Partner IdIdentifier of the supplier, customer, or inventory organizationAccount Balances.Trading Partner IdTRADING_PARTNER_IDTRADING_PARTNER_ID165527
Trading Partner NameName of the trading partner (customer, supplier, or inv organization)Account Balances.Trading Partner NameTRADING_PARTNER_NAMETRADING_PARTNER_NAME165531
Trading Partner Site IdIdentifier of the supplier or customer site or tthe subinventory orcost groupAccount Balances.Trading Partner Site IdTRADING_PARTNER_SITE_IDTRADING_PARTNER_SITE_ID165536
Trading Partner Site NameName of the trading partner siteAccount Balances.Trading Partner Site NameTRADING_PARTNER_SITE_NAMETRADING_PARTNER_SITE_NAME165539
TransactionTotal volume during the period, debit - creditAccount Balances.TransactionTRANSACTIONTRANSACTION165600
Folder Joins
Join NameJoin ConditionJoin DetailsOptional Join ConfigurationAuto
Account Balances -> Accounting Entry LinesAccount Balances.Application Id = Accounting Entry Lines.Application Id Account Balances.Set Of Books Id = Accounting Entry Lines.Set Of Books Id Account Balances.Trading Partner Id = Accounting Entry Lines.Trading Partner Id Account Balances.Trading Partner Site Id = Accounting Entry Lines.Trading Partner Site Id Account Balances.Account ID = Accounting Entry Lines.Account ID Account Balances.Period Name = Accounting Entry Lines.Period NameMight not exist in master folderOuter join on detail No