COUNTRY_CDBANK_CDBRANCH_EC_CDPrompt Table: GP_BRANCH_CD_VW
GP_SS_BRANCH_VW(SQL View) |
Index Back |
|---|---|
Global Payroll Bank Branch VwGlobal Payroll Self Service Branch view of BANK_BRANCH_TBL |
| SELECT COUNTRY_CD , BANK_CD , BRANCH_EC_CD , DESCR , BS_ACCOUNT_NBR , ADDRESS1 , CITY , POSTAL FROM PS_BANK_BRANCH_TBL WHERE EFF_STATUS = 'A' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | COUNTRY_CD |
Character(3) | VARCHAR2(3) NOT NULL | Country Code |
| 2 | BANK_CD |
Character(11) | VARCHAR2(11) NOT NULL | Bank Code |
| 3 | BRANCH_EC_CD |
Character(17) | VARCHAR2(17) NOT NULL |
Bank Branch ID
Prompt Table: GP_BRANCH_CD_VW |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 5 | BS_ACCOUNT_NBR | Character(8) | VARCHAR2(8) NOT NULL | Account Number |
| 6 | ADDRESS1 | Character(55) | VARCHAR2(55) NOT NULL | Address 1 |
| 7 | CITY | Character(30) | VARCHAR2(30) NOT NULL | City |
| 8 | POSTAL | Character(12) | VARCHAR2(12) NOT NULL | Postal |