EBK_RUN_CNTL(SQL Table) |
Index Back |
---|---|
Run Control Record - Bank Load |
# | 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 | COUNTRY | Character(3) | VARCHAR2(3) NOT NULL |
Country
Prompt Table: COUNTRY_TBL |
4 | BANK_ID_QUAL | Character(3) | VARCHAR2(3) NOT NULL |
"A bank/counterparty attribute that determines
Prompt Table: BNK_ID_QUAL_VW |
5 | EBK_FILE_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
File Type
F=Fixed V=CSV |
6 | FILENAME | Character(80) | VARCHAR2(80) NOT NULL | File Name |
7 | RELOAD_PROC | Character(1) | VARCHAR2(1) NOT NULL |
Reload
Y/N Table Edit Default Value: Y |
8 | 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 Default Value: EBK_RUN_CNTL.FILE_FORMAT |