GPCH_BK_SIC_BC_NUMGPCH_BK_SIC_BRANCHEFFDTDefault Value: %date
GPCH_BK_SIC_TMP(SQL Table) |
Index Back |
|---|---|
SIC Bank Definition temp tableSIC Bank Definition temp table |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | GPCH_BK_SIC_BC_NUM |
Character(5) | VARCHAR2(5) NOT NULL | BC Number |
| 2 | GPCH_BK_SIC_BRANCH |
Character(4) | VARCHAR2(4) NOT NULL | SIC File - Branch id |
| 3 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 4 | GPCH_BK_SIC_NEW_BC | Character(5) | VARCHAR2(5) NOT NULL | New BC Number |
| 5 | SHORTNAME | Character(15) | VARCHAR2(15) NOT NULL | Field Short Name |
| 6 | DESCR60 | Character(60) | VARCHAR2(60) NOT NULL | Description |
| 7 | GPCH_BK_SIC_ADDR | Character(35) | VARCHAR2(35) NOT NULL | SIC File Address |
| 8 | GPCH_BK_POSTALADDR | Character(35) | VARCHAR2(35) NOT NULL | Postal Address |
| 9 | GPCH_BK_SIC_ZIPCD | Character(10) | VARCHAR2(10) NOT NULL | SIC File - Zip code |
| 10 | GPCH_BK_SIC_PLACE | Character(35) | VARCHAR2(35) NOT NULL | SIC File - Place |
| 11 | GPCH_BK_SIC_PHONE | Character(18) | VARCHAR2(18) NOT NULL | SIC File - Phone |
| 12 | GPCH_CNTRY_DIAL_CD | Character(5) | VARCHAR2(5) NOT NULL | Country Dialing Code |
| 13 | COUNTRY_2CHAR | Character(2) | VARCHAR2(2) NOT NULL | 2-Char Country Code |
| 14 | GPCH_BK_SWIFT_CD | Character(14) | VARCHAR2(14) NOT NULL | SIC file - BIC SWIFT Code |