GPDE_BBK_BLZGPDE_BBK_BLZOWNERGPDE_BBK_SATZNRDefault Value: %date
P=Processed
P=Processed
U=Unprocessed
U=Unprocessed
Default Value: U
GPDE_BK_BLZFILE(SQL Table) |
Index Back |
|---|---|
Current Bank codes DEUBankcodes as published by Deutsche Bundesbank |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | GPDE_BBK_BLZ |
Character(8) | VARCHAR2(8) NOT NULL | bank code |
| 2 | GPDE_BBK_BLZOWNER |
Number(3,0) | SMALLINT NOT NULL | bank code owner |
| 3 | GPDE_BBK_BANKNAME | Character(58) | VARCHAR2(58) NOT NULL | bankname |
| 4 | GPDE_BBK_POSTAL | Character(5) | VARCHAR2(5) NOT NULL | bankfile postal code |
| 5 | GPDE_BBK_CITY | Character(35) | VARCHAR2(35) NOT NULL | bankfile city code |
| 6 | GPDE_BBK_BNKSHORT | Character(27) | VARCHAR2(27) NOT NULL | Short code |
| 7 | GPDE_BBK_BIC | Character(11) | VARCHAR2(11) NOT NULL | Swiftcode |
| 8 | GPDE_BBK_SATZNR |
Number(6,0) | INTEGER NOT NULL | bankfile record number |
| 9 | GPDE_BBK_MOD | Character(1) | VARCHAR2(1) NOT NULL | bank modified |
| 10 | GPDE_BBK_DELID | Character(1) | VARCHAR2(1) NOT NULL | deleted? |
| 11 | GPDE_BBK_NEWCODE | Character(8) | VARCHAR2(8) NOT NULL | follow-up code for deleted bank |
| 12 | GPDE_BBK_FROM_DT | Date(10) | DATE |
From Date
Default Value: %date |
| 13 | GPDE_BBK_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Status
P=Processed P=Processed U=Unprocessed U=Unprocessed Default Value: U |