PROCESS_INSTANCEF=Fixed
V=CSV
A=ANSI FORMAT
S=Shift-JIS
U=UTF-8 FORMAT
EBK_BANK_AET(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 3 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 4 | COUNTRY | Character(3) | VARCHAR2(3) NOT NULL | Country |
| 5 | BANK_ID_QUAL | Character(3) | VARCHAR2(3) NOT NULL | "A bank/counterparty attribute that determines |
| 6 | RELOAD_PROC | Character(1) | VARCHAR2(1) NOT NULL | Reload |
| 7 | EBK_FILE_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
File Type
F=Fixed V=CSV |
| 8 | FILENAME | Character(80) | VARCHAR2(80) NOT NULL | File Name |
| 9 | FILE_FORMAT | Character(1) | VARCHAR2(1) NOT NULL |
Field used to captrue the character set on the RUn control page of the Bank Upload program.
A=ANSI FORMAT S=Shift-JIS U=UTF-8 FORMAT |