Powered by InfoCaptor


Previous Page   Next Page

Bank Branches
More Folder Details
Dependent FoldersFolder ComponentsTable ComponentsAnalyzed
NoneNone.APFG_BANK_BRANCHESUnknown
Folder Items
Item NameItem DescriptionItem Depends OnIt Ext ColumnItem KeyItem Id
Address Line 1First address line.Bank Branches.Address Line 1ADDRESS_LINE1ADDRESS_LINE1115059
Address Line 2Second address line.Bank Branches.Address Line 2ADDRESS_LINE2ADDRESS_LINE2115070
Address Line 3Third address line.Bank Branches.Address Line 3ADDRESS_LINE3ADDRESS_LINE3115080
Address Line 4Fourth address line.Bank Branches.Address Line 4ADDRESS_LINE4ADDRESS_LINE4115090
Alternate Address Lines Bank Branches.Alternate Address LinesALTERNATE_ADDRESS_LINESALTERNATE_ADDRESS_LINES115756
Alternate Bank Branch Name Bank Branches.Alternate Bank Branch NameALTERNATE_BANK_BRANCH_NAMEALTERNATE_BANK_BRANCH_NAME115758
Alternate Bank Name Bank Branches.Alternate Bank NameALTERNATE_BANK_NAMEALTERNATE_BANK_NAME115759
Area Code Bank Branches.Area CodeAREA_CODEAREA_CODE116396
Bank Branch IdBank branch unique identifier.Bank Branches.Bank Branch IdBANK_BRANCH_IDBANK_BRANCH_ID119049
Bank Branch Name Bank Branches.Bank Branch NameBANK_BRANCH_NAMEBANK_BRANCH_NAME119051
Bank Branch Number Bank Branches.Bank Branch NumberBANK_BRANCH_NUMBERBANK_BRANCH_NUMBER119052
Bank Branch TypeBranch type indicates which list the bank routing number is on. Valid types are ABA, CHIPS, SWIFT and OTHER.Bank Branches.Bank Branch TypeBANK_BRANCH_TYPEBANK_BRANCH_TYPE119053
Bank Name Bank Branches.Bank NameBANK_NAMEBANK_NAME119079
Bank Name 1 Bank Branches.Bank Name 1GLBL_PRIMARY_ID_BANK_NAME_4GLBL_PRIMARY_ID_BANK_NAME_4266210
Bank Number Bank Branches.Bank NumberBANK_NUMBERBANK_NUMBER119092
City Bank Branches.CityCITYCITY122036
Contact First NameFirst name of branch contact person.Bank Branches.Contact First NameCONTACT_FIRST_NAMECONTACT_FIRST_NAME123191
Contact Last NameLast name of branch contact person.Bank Branches.Contact Last NameCONTACT_LAST_NAMECONTACT_LAST_NAME123206
Contact Middle NameMiddle name of branch contact person.Bank Branches.Contact Middle NameCONTACT_MIDDLE_NAMECONTACT_MIDDLE_NAME123208
Contact PrefixTitle prefix of branch contact person.Bank Branches.Contact PrefixCONTACT_PREFIXCONTACT_PREFIX123223
Contact TitleTitle of branch contact person.Bank Branches.Contact TitleCONTACT_TITLECONTACT_TITLE123235
Context Bank Branches.ContextCONTEXTCONTEXT266203
Context Value Bank Branches.Context ValueGLBL_CONTEXT_VALUEGLBL_CONTEXT_VALUE266206
Country Bank Branches.CountryCOUNTRYCOUNTRY123815
County Bank Branches.CountyCOUNTYCOUNTY123884
Created ByStandard WHO column.Bank Branches.Created ByCREATED_BYCREATED_BY124513
Creation DateStandard WHO column.Bank Branches.Creation DateCREATION_DATECREATION_DATE125945
DescriptionThe accounting period description.Bank Branches.DescriptionDESCRIPTIONDESCRIPTION129518
Electronic Data Interchange ID NumberEDI trading partner number for the Bank Branch.Bank Branches.Electronic Data Interchange ID NumberEDI_ID_NUMBEREDI_ID_NUMBER130712
Electronic Funds Transfer Swift code Bank Branches.Electronic Funds Transfer Swift codeEFT_SWIFT_CODEEFT_SWIFT_CODE131340
Electronic Funds Transfer User Number Bank Branches.Electronic Funds Transfer User NumberEFT_USER_NUMBEREFT_USER_NUMBER131342
End Effective DateThe date after which an account becomes inactive.Bank Branches.End Effective DateEND_EFFECTIVE_DATEEND_EFFECTIVE_DATE133092
End Effective Date - Day Bank Branches.End Effective Date END_EFFECTIVE_DATE_DAY178571
End Effective Date - Month Bank Branches.End Effective Date END_EFFECTIVE_DATE_MONTH178667
End Effective Date - Quarter Bank Branches.End Effective Date END_EFFECTIVE_DATE_QUARTER178763
End Effective Date - Year Bank Branches.End Effective Date END_EFFECTIVE_DATE_YEAR178859
Immediate Destination Number Bank Branches.Immediate Destination NumberIMMEDIATE_DESTINATION_NUMBERIMMEDIATE_DESTINATION_NUMBER266205
Immediate Origin Number Prefix Bank Branches.Immediate Origin Number PrefixIMMEDIATE_ORIGIN_NUMBER_PREFIXIMMEDIATE_ORIGIN_NUMBER_PREFIX266204
Institution TypeInstitution type. Possible values are Bank or Clearing House. INSTITUTION_TYPE181569
Institution Type 1 Bank Branches.Institution Type 1INSTITUTION_TYPEINSTITUTION_TYPE1266202
Last Update DateStandard WHO column.Bank Branches.Last Update DateLAST_UPDATE_DATELAST_UPDATE_DATE140476
Last Updated ByStandard WHO column.Bank Branches.Last Updated ByLAST_UPDATED_BYLAST_UPDATED_BY139137
Maximum Number Of Collection Documents Bank Branches.Maximum Number Of Collection DocumentsGLBL_MAXIMUM_NUM_OF_COLLECTI_3GLBL_MAXIMUM_NUM_OF_COLLECTI_3266208
PhoneTelephone number.Bank Branches.PhonePHONEPHONE154007
Primary ID Branch Bank Branches.Primary ID BranchGLBL_PRIMARY_ID_BRANCH_4GLBL_PRIMARY_ID_BRANCH_4266209
Primary ID Number Bank Branches.Primary ID NumberGLBL_PRIMARY_ID_NUMBER_4GLBL_PRIMARY_ID_NUMBER_4266212
Primary ID Type Bank Branches.Primary ID TypeGLBL_PRIMARY_ID_TYPE_4GLBL_PRIMARY_ID_TYPE_4266211
Primary ID Validation Digit Bank Branches.Primary ID Validation DigitGLBL_PRIMARY_ID_VALIDATION_D_4GLBL_PRIMARY_ID_VALIDATION_D_4266213
Start Effective DateThe date on which an account becomes active.Bank Branches.Start Effective DateSTART_EFFECTIVE_DATESTART_EFFECTIVE_DATE163254
Start Effective Date - Day Bank Branches.Start Effective Date START_EFFECTIVE_DATE_DAY191105
Start Effective Date - Month Bank Branches.Start Effective Date START_EFFECTIVE_DATE_MONTH191191
Start Effective Date - Quarter Bank Branches.Start Effective Date START_EFFECTIVE_DATE_QUARTER191277
Start Effective Date - Year Bank Branches.Start Effective Date START_EFFECTIVE_DATE_YEAR191363
State Bank Branches.StateSTATESTATE163358
Taxpayer ID Bank Branches.Taxpayer IDGLBL_TAXPAYER_ID_2GLBL_TAXPAYER_ID_2266207
Zip CodePostal code.Bank Branches.Zip CodeZIP_CODEZIP_CODE168231
Folder Joins
Join NameJoin ConditionJoin DetailsOptional Join ConfigurationAuto
Bank Branches -> Cash ReceiptsBank Branches.Bank Branch Id = Cash Receipts.Issuer Bank Branch IdAlways exist in master folderNoneNo