Powered by InfoCaptor


Previous Page   Next Page

Bank Accounts
More Folder Details
Dependent FoldersFolder ComponentsTable ComponentsAnalyzed
NoneNone.APFG_BANK_ACCOUNTSUnknown
Folder Items
Item NameItem DescriptionItem Depends OnIt Ext ColumnItem KeyItem Id
Account Holder Name Bank Accounts.Account Holder NameACCOUNT_HOLDER_NAMEACCOUNT_HOLDER_NAME114186
Account Type Bank Accounts.Account TypeACCOUNT_TYPEACCOUNT_TYPE266171
Agreement Number Bank Accounts.Agreement NumberGLBL_JEDK_EDI_AGREEMENT_NUMB_4GLBL_JEDK_EDI_AGREEMENT_NUMB_4266189
Agreement Type Bank Accounts.Agreement TypeGLBL_JEDK_EDI_AGREEMENT_TYPE_4GLBL_JEDK_EDI_AGREEMENT_TYPE_4266188
Alternate Account Holder Name Bank Accounts.Alternate Account Holder NameALTERNATE_ACCOUNT_HOLDER_NAMEALTERNATE_ACCOUNT_HOLDER_NAME115754
Alternate Bank Account Name Bank Accounts.Alternate Bank Account NameALTERNATE_BANK_ACCOUNT_NAMEALTERNATE_BANK_ACCOUNT_NAME115757
Bank Account IDBank account uniquely identifier.Bank Accounts.Bank Account IDBANK_ACCOUNT_IDBANK_ACCOUNT_ID119004
Bank Account Name Bank Accounts.Bank Account NameBANK_ACCOUNT_NAMEBANK_ACCOUNT_NAME119022
Bank Account Number Bank Accounts.Bank Account NumberBANK_ACCOUNT_NUMBERBANK_ACCOUNT_NUMBER119039
Bank Account Type Bank Accounts.Bank Account TypeBANK_ACCOUNT_TYPEBANK_ACCOUNT_TYPE119044
Bank Branch IdBank branch unique identifier.Bank Accounts.Bank Branch IdBANK_BRANCH_IDBANK_BRANCH_ID119048
Bank Code Bank Accounts.Bank CodeGLBL_JEDK_EDI_BANK_CODE_3GLBL_JEDK_EDI_BANK_CODE_3266175
Bank Code 1 Bank Accounts.Bank Code 1GLBL_JEDK_EDI_BANK_CODE_4GLBL_JEDK_EDI_BANK_CODE_4266186
Bank Notice Bank Accounts.Bank NoticeGLBL_JEDK_EDI_BANK_NOTICE_4GLBL_JEDK_EDI_BANK_NOTICE_4266192
Collection Format Program Bank Accounts.Collection Format ProgramGLBL_COLLECTION_FORMAT_PROGR_6GLBL_COLLECTION_FORMAT_PROGR_6266195
Collection Remittance Media Bank Accounts.Collection Remittance MediaGLBL_COLLECTION_REMITTANCE_M_6GLBL_COLLECTION_REMITTANCE_M_6266194
Communication Agreement ID Bank Accounts.Communication Agreement IDGLBL_JEDK_EDI_COM_AGREEMENTI_3GLBL_JEDK_EDI_COM_AGREEMENTI_3266174
Company Code For Bank Bank Accounts.Company Code For BankGLBL_COMPANY_CODE_FOR_BANK_6GLBL_COMPANY_CODE_FOR_BANK_6266200
Contact Area CodeArea code of bank contact person telephone number.Bank Accounts.Contact Area CodeCONTACT_AREA_CODECONTACT_AREA_CODE123188
Contact First NameFirst name of branch contact person.Bank Accounts.Contact First NameCONTACT_FIRST_NAMECONTACT_FIRST_NAME123190
Contact Last NameLast name of branch contact person.Bank Accounts.Contact Last NameCONTACT_LAST_NAMECONTACT_LAST_NAME123205
Contact Middle NameMiddle name of branch contact person.Bank Accounts.Contact Middle NameCONTACT_MIDDLE_NAMECONTACT_MIDDLE_NAME123207
Contact PhoneTelephone number of bank contact person.Bank Accounts.Contact PhoneCONTACT_PHONECONTACT_PHONE123219
Contact PrefixTitle prefix of branch contact person.Bank Accounts.Contact PrefixCONTACT_PREFIXCONTACT_PREFIX123222
Contact TitleTitle of branch contact person.Bank Accounts.Contact TitleCONTACT_TITLECONTACT_TITLE123234
Context Value Bank Accounts.Context ValueGLBL_CONTEXT_VALUEGLBL_CONTEXT_VALUE266172
Country Code Bank Accounts.Country CodeGLBL_JEDK_EDI_COUNTRY_CODE_4GLBL_JEDK_EDI_COUNTRY_CODE_4266185
Created ByStandard WHO column.Bank Accounts.Created ByCREATED_BYCREATED_BY124512
Creation DateStandard WHO column.Bank Accounts.Creation DateCREATION_DATECREATION_DATE125944
Currency CodeCurrency code for pricelist; FK to gl_curr_mst.Bank Accounts.Currency CodeCURRENCY_CODECURRENCY_CODE126991
DD_CODE Bank Accounts.DD_CODEGLBL_DD_CODE_2GLBL_DD_CODE_2266173
DescriptionThe accounting period description.Bank Accounts.DescriptionDESCRIPTIONDESCRIPTION129517
Dummy Bank Accounts.DummyGLBL_JEDK_EDI_DUMMY_4GLBL_JEDK_EDI_DUMMY_4266184
Electronic Funds Transfer User Number Bank Accounts.Electronic Funds Transfer User NumberEFT_USER_NUMBEREFT_USER_NUMBER131341
Factoring Format Program Bank Accounts.Factoring Format ProgramGLBL_FACTORING_FORMAT_PROGRA_6GLBL_FACTORING_FORMAT_PROGRA_6266197
Factoring Remittance Media Bank Accounts.Factoring Remittance MediaGLBL_FACTORING_REMITTANCE_ME_6GLBL_FACTORING_REMITTANCE_ME_6266196
Import Code Bank Accounts.Import CodeGLBL_JEDK_EDI_IMPORT_CODE_4GLBL_JEDK_EDI_IMPORT_CODE_4266187
Inactive DateDate on which bank account becomes inactive.Bank Accounts.Inactive DateINACTIVE_DATEINACTIVE_DATE136181
Inactive Date - Day Bank Accounts.Inactive Date INACTIVE_DATE_DAY181149
Inactive Date - Month Bank Accounts.Inactive Date INACTIVE_DATE_MONTH181219
Inactive Date - Quarter Bank Accounts.Inactive Date INACTIVE_DATE_QUARTER181289
Inactive Date - Year Bank Accounts.Inactive Date INACTIVE_DATE_YEAR181359
JEDK_EDI_SENDER_ID Bank Accounts.JEDK_EDI_SENDER_IDGLBL_JEDK_EDI_SENDER_ID_3GLBL_JEDK_EDI_SENDER_ID_3266179
Last Update DateStandard WHO column.Bank Accounts.Last Update DateLAST_UPDATE_DATELAST_UPDATE_DATE140475
Last Updated ByStandard WHO column.Bank Accounts.Last Updated ByLAST_UPDATED_BYLAST_UPDATED_BY139136
Maximum Payment AmountMaximum amount allowed per payment for bank account.Bank Accounts.Maximum Payment AmountMAXIMUM_PAYMENT_AMOUNTMAXIMUM_PAYMENT_AMOUNT146431
Maximum Payment Batch OutlayMaximum payment batch outlay for bank account.Bank Accounts.Maximum Payment Batch OutlayMAXIMUM_PAYMENT_BATCH_OUTLAYMAXIMUM_PAYMENT_BATCH_OUTLAY146432
Minimum Payment AmountMinimum amount allowed per payment for bank account.Bank Accounts.Minimum Payment AmountMINIMUM_PAYMENT_AMOUNTMINIMUM_PAYMENT_AMOUNT147152
Multicurrency Allowed FlagIndicates whether you allow payments in multiple currencies from this bank account.Bank Accounts.Multicurrency Allowed FlagMULTICURRENCY_ALLOWED_FLAGMULTICURRENCY_ALLOWED_FLAG147497
Occurrence File Format Program Bank Accounts.Occurrence File Format ProgramGLBL_OCCURRENCE_FILE_FORMAT__6GLBL_OCCURRENCE_FILE_FORMAT__6266199
Occurrence Report Format Program Bank Accounts.Occurrence Report Format ProgramGLBL_OCCURRENCE_REPORT_FORMA_6GLBL_OCCURRENCE_REPORT_FORMA_6266198
Password Bank Accounts.PasswordGLBL_JEDK_EDI_PASSWORD_3GLBL_JEDK_EDI_PASSWORD_3266178
Payment Category Bank Accounts.Payment CategoryGLBL_JEDK_EDI_PAYMENT_CATEGO_4GLBL_JEDK_EDI_PAYMENT_CATEGO_4266180
Payment CategoryID Bank Accounts.Payment CategoryIDGLBL_JEDK_EDI_SEQUENCE_NUMBE_4GLBL_JEDK_EDI_SEQUENCE_NUMBE_4266181
Payment Channel Bank Accounts.Payment ChannelGLBL_JEDK_EDI_PAYMENT_CHANNE_4GLBL_JEDK_EDI_PAYMENT_CHANNE_4266183
Payment Means Bank Accounts.Payment MeansGLBL_JEDK_EDI_PAYMENT_MEANS_4GLBL_JEDK_EDI_PAYMENT_MEANS_4266182
Payment Type Bank Accounts.Payment TypeGLBL_PAYMENT_TYPE_5GLBL_PAYMENT_TYPE_5266193
Pooled Account FlagIndicates whether this is a pooled bank account.Bank Accounts.Pooled Account FlagPOOLED_ACCOUNT_FLAGPOOLED_ACCOUNT_FLAG154711
Settlement Code Bank Accounts.Settlement CodeGLBL_JEDK_EDI_SETTLEMENT_COD_4GLBL_JEDK_EDI_SETTLEMENT_COD_4266190
Short Notice Bank Accounts.Short NoticeGLBL_JEDK_EDI_SHORT_NOTICE_4GLBL_JEDK_EDI_SHORT_NOTICE_4266191
UBT-Number Bank Accounts.UBT-NumberGLBL_JEDK_EDI_UBT_NUMBER_3GLBL_JEDK_EDI_UBT_NUMBER_3266176
User Name Bank Accounts.User NameGLBL_JEDK_EDI_USER_NAME_3GLBL_JEDK_EDI_USER_NAME_3266177
Zero Payments Allowed FlagIndicates whether the bank account allows zero amount payments.Bank Accounts.Zero Payments Allowed FlagZERO_PAYMENTS_ALLOWED_FLAGZERO_PAYMENTS_ALLOWED_FLAG168229
Folder Joins
Join NameJoin ConditionJoin DetailsOptional Join ConfigurationAuto
Bank Accounts -> AP Invoice PaymentsBank Accounts.Bank Account ID = AP Invoice Payments.External Bank Account IdAlways exist in master folderNoneNo
Bank Accounts -> AP Invoice Payments 1Bank Accounts.Bank Account ID = AP Invoice Payments.Aps External Bank Account IdAlways exist in master folderNoneNo
Bank Accounts -> AP Payment SchedulesBank Accounts.Bank Account ID = AP Payment Schedules.External Bank Account IDAlways exist in master folderNoneNo
Bank Accounts -> Bank BranchesBank Accounts.Bank Branch Id = Bank Branches.Bank Branch IdAlways exist in master folderNoneNo
Bank Accounts -> Bank StatementsBank Accounts.Bank Account ID = Bank Statements.Bank Account IDAlways exist in master folderNoneNo
Bank Accounts -> PaymentsBank Accounts.Bank Account ID = Payments.Bank Account IDAlways exist in master folderNoneNo
Bank Accounts -> Payments 1Bank Accounts.Bank Account ID = Payments.External Bank Account IDAlways exist in master folderOuter join on detail No