BCH_RUN_CNTL(SQL Table) |
Index Back |
|---|---|
BCH Process Run ControlAP Process Run Control |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  OPRID |
Character(30) | VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Default Value: OPR_DEF_TBL_AP.OPRID Prompt Table: OPR_DEF_TBL_AP |
| 2 | RUN_CNTL_ID |
Character(30) | VARCHAR2(30) NOT NULL |
Run Control ID
Prompt Table: RUN_CNTL_AP |
| 3 | LANGUAGE_CD | Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 4 | REMIT_SETID | Character(5) | VARCHAR2(5) NOT NULL |
Remit SetID
Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETRMT_NONVW |
| 5 | REMIT_VENDOR | Character(10) | VARCHAR2(10) NOT NULL |
Remit Vendor
Prompt Table: VNDR_RMT_VW2 |
| 6 | PAY_CYCLE | Character(6) | VARCHAR2(6) NOT NULL |
Pay Cycle
Prompt Table: SP_PYCYCL_NONVW |
| 7 | PAY_CYCLE_SEQ_NUM | Number(6,0) | INTEGER NOT NULL |
Pay Cycle Sequence Number
Prompt Table: PYCYCL_STAT |
| 8 | BANK_SETID | Character(5) | VARCHAR2(5) NOT NULL |
The PeopleSoft tableset ID associated with a given bank/counterparty.
Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETBNK_NONVW |
| 9 | BANK_CD | Character(5) | VARCHAR2(5) NOT NULL |
Bank Code
Prompt Table: BANK_CD_VW2 |
| 10 | BANK_ACCT_KEY | Character(4) | VARCHAR2(4) NOT NULL |
A user defined unique identifier that facilitates the identification of a given account with a given bank
Prompt Table: BANK_ACCT_VW |
| 11 | FRM_PYMNT_DT | Date(10) | DATE |
From Payment Date
Default Value: %date |
| 12 | TO_PYMNT_DT | Date(10) | DATE |
To Payment Date
Default Value: %date |
| 13 | PYMNT_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL |
Payment Currency
Default Value: JPY Prompt Table: CURRENCY_CD_TBL |