COUNTRY_CDDefault Value: BANK_BRANCH_TBL.COUNTRY_CD
BANK_CDDefault Value: BANK_BRANCH_TBL.BANK_CD
BRANCH_EC_CDDefault Value: BANK_BRANCH_TBL.BRANCH_EC_CD
BANK_BRCH_BRA(SQL Table) |
Index Back |
|---|---|
Bank BranchBank-Branch Table |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | COUNTRY_CD |
Character(3) | VARCHAR2(3) NOT NULL |
Country Code
Default Value: BANK_BRANCH_TBL.COUNTRY_CD |
| 2 | BANK_CD |
Character(11) | VARCHAR2(11) NOT NULL |
Bank ID
Default Value: BANK_BRANCH_TBL.BANK_CD |
| 3 | BRANCH_EC_CD |
Character(17) | VARCHAR2(17) NOT NULL |
Bank Branch ID
Default Value: BANK_BRANCH_TBL.BRANCH_EC_CD |
| 4 | VERIFY_DIGIT_BRA | Character(5) | VARCHAR2(5) NOT NULL | Verifier Digit used at bank-branch table, Brazil. |
| 5 | BRANCH_LOC_BRA | Character(40) | VARCHAR2(40) NOT NULL | Branch Location, Human Resources, Brazil |
| 6 | UNION_CNPJ_BRA | Character(14) | VARCHAR2(14) NOT NULL | Union CNPJ, this is the ID that all the companies/establishments in Brazil have. |
| 7 | CONTRACT_BRA | Character(55) | VARCHAR2(55) NOT NULL | Contract Number, Human Resources, Brazil |