OPRIDPrompt Table: OPRID_VW
Prompt Table: CURRENCY_CD_TBL
Prompt Table: SP_SETID_NONVW
Prompt Table: BANK_CD_VW8
Prompt Table: TD_BANK_ACCT_VW
Prompt Table: TD_PROSEQ_VW
Prompt Table: TD_PROSEQ_VW
Prompt Table: TD_CLMSEQ_VW
OPR_DEF_TBL_TD(SQL Table) |
Index Back |
|---|---|
Operator Defaults - TD |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Prompt Table: OPRID_VW |
| 2 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table: CURRENCY_CD_TBL |
| 3 | BANK_SETID | Character(5) | VARCHAR2(5) NOT NULL |
The PeopleSoft tableset ID associated with a given bank/counterparty.
Prompt Table: SP_SETID_NONVW |
| 4 | BANK_CD | Character(5) | VARCHAR2(5) NOT NULL |
Bank Code
Prompt Table: BANK_CD_VW8 |
| 5 | 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: TD_BANK_ACCT_VW |
| 6 | TD_ALLOW_PREFIX | Character(3) | VARCHAR2(3) NOT NULL |
National Allowance Prefix
Prompt Table: TD_PROSEQ_VW |
| 7 | TD_PROMO_PREFIX | Character(3) | VARCHAR2(3) NOT NULL |
Promotions Prefix
Prompt Table: TD_PROSEQ_VW |
| 8 | TD_CLAIM_PREFIX | Character(3) | VARCHAR2(3) NOT NULL |
Claims Prefix
Prompt Table: TD_CLMSEQ_VW |
| 9 | TD_VIEW_PRODCOST | Character(1) | VARCHAR2(1) NOT NULL | View Product Cost? |