GPTH_SRC_BANK(SQL Table) |
Index Back |
|---|---|
Source Bank THAIt contains specific fields are required to generate EFT files. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | Character(8) | VARCHAR2(8) NOT NULL | Source Bank ID | |
| 2 | GPTH_FINANCE_ID | Character(3) | VARCHAR2(3) NOT NULL | Finance ID |
| 3 | GPTH_DDP_ORIG_ID | Character(4) | VARCHAR2(4) NOT NULL | DDP Originator ID |
| 4 | GPTH_TRANS_TYPE | Character(4) | VARCHAR2(4) NOT NULL | Trans-Type |
| 5 | GPTH_BATCH_CONTROL | Character(4) | VARCHAR2(4) NOT NULL | Batch-Control |
| 6 | GPTH_COMPANY_CODE | Character(7) | VARCHAR2(7) NOT NULL | Company Code |