GPUS_EFT_1REC(SQL Table) |
Index Back |
---|---|
EFT 1 Record TypeGP US EFT -- File Header Record for the PPD/CTX file. |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
2 | GPUS_REC_TYPE | Character(1) | VARCHAR2(1) NOT NULL | Record Type used in EFT |
3 | GPUS_PRIORITY_CD | Character(2) | VARCHAR2(2) NOT NULL | Priority Code |
4 | GPUS_FILLER_1 | Character(1) | VARCHAR2(1) NOT NULL | Filler 1 for GPUS EFT |
5 | GPUS_BANK_CD | Character(9) | VARCHAR2(9) NOT NULL | 9 char long Bank CD for USA |
6 | GPUS_EFT_CHAR | Character(1) | VARCHAR2(1) NOT NULL | Char 1 filler |
7 | FEDERAL_EIN | Number(9,0) | DECIMAL(9) NOT NULL | Federal EIN |
8 | GPUS_EFT_CREATE_DT | Character(6) | VARCHAR2(6) NOT NULL | File Creation Date |
9 | GPUS_EFT_CREATE_TM | Character(4) | VARCHAR2(4) NOT NULL | File Creation Time |
10 | GPUS_FILE_ID | Character(1) | VARCHAR2(1) NOT NULL | File ID Modifier |
11 | GPUS_REC_SIZE | Character(3) | VARCHAR2(3) NOT NULL | EFT Record Size |
12 | GPUS_BLOCK_FACTOR | Character(2) | VARCHAR2(2) NOT NULL | Block Factor |
13 | GPUS_EFT_FMT_CD | Character(1) | VARCHAR2(1) NOT NULL | EFT Format Code |
14 | GPUS_DEST_BANK_NM | Character(23) | VARCHAR2(23) NOT NULL | Immediate Destination Bank Name |
15 | GPUS_ORIGIN_NAME | Character(23) | VARCHAR2(23) NOT NULL | Immediate Origin name |
16 | GPUS_EFT_REF_CD | Character(8) | VARCHAR2(8) NOT NULL | EFT Reference Code |