OPRIDRUN_CNTL_IDGPDE_BBK_BLZGPDE_BBK_SATZNRP=Processed
P=Processed
U=Unprocessed
U=Unprocessed
GPDE_BK03_TMP(SQL Table) |
Index Back |
|---|---|
Temp recd for Load Bank DefnsTemp record for Load Bank Definitions DEU |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 2 | RUN_CNTL_ID |
Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 3 | GPDE_BBK_BLZ |
Character(8) | VARCHAR2(8) NOT NULL | bank code |
| 4 | GPDE_BBK_SATZNR |
Number(6,0) | INTEGER NOT NULL | bankfile record number |
| 5 | GPDE_BBK_BLZOWNER | Number(3,0) | SMALLINT NOT NULL | bank code owner |
| 6 | GPDE_BBK_BANKNAME | Character(58) | VARCHAR2(58) NOT NULL | bankname |
| 7 | GPDE_BBK_POSTAL | Character(5) | VARCHAR2(5) NOT NULL | bankfile postal code |
| 8 | GPDE_BBK_CITY | Character(35) | VARCHAR2(35) NOT NULL | bankfile city code |
| 9 | GPDE_BBK_BNKSHORT | Character(27) | VARCHAR2(27) NOT NULL | Short code |
| 10 | GPDE_BBK_BIC | Character(11) | VARCHAR2(11) NOT NULL | Swiftcode |
| 11 | GPDE_BBK_MOD | Character(1) | VARCHAR2(1) NOT NULL | bank modified |
| 12 | GPDE_BBK_DELID | Character(1) | VARCHAR2(1) NOT NULL | deleted? |
| 13 | GPDE_BBK_NEWCODE | Character(8) | VARCHAR2(8) NOT NULL | follow-up code for deleted bank |
| 14 | GPDE_BBK_FROM_DT | Date(10) | DATE | From Date |
| 15 | GPDE_BBK_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Status
P=Processed P=Processed U=Unprocessed U=Unprocessed |