PIR_WKBCH_TBL(SQL Table) |
Index Back |
|---|---|
PIR Workbench Search CriteriaThis table is used for saving PIR Workbench Search Criteira. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT_AP | Character(5) | VARCHAR2(5) NOT NULL |
AP Business Unit
Prompt Table: SP_BU_AP_NONVW |
| 2 | PAY_CYCLE | Character(6) | VARCHAR2(6) NOT NULL |
Pay Cycle
Prompt Table: SP_PYSTAT_NONVW |
| 3 | PYMNT_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Payment Status
A=Alignment E=ACH/EFT Prenote L=Stale Dated Payment N=Reprinted with same ref number O=Overflow P=Paid R=Replaced S=Stopped T=Undo Escheatment U=Undo Cancel V=Void W=Escheated Check X=Deleted |
| 4 | BANK_SETID | Character(5) | VARCHAR2(5) NOT NULL |
The PeopleSoft tableset ID associated with a given bank/counterparty.
Prompt Table: SP_SETBNK_NONVW |
| 5 | BANK_CD | Character(5) | VARCHAR2(5) NOT NULL |
Bank Code
Prompt Table: BANK_CD_PIR_VW |
| 6 | 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_VACCT_VW11 |
| 7 | PYMNT_METHOD | Character(3) | VARCHAR2(3) NOT NULL |
Payment Method
ACH=Automated Clearing House BEF=Draft - Customer EFT BOO=Draft - Customer Initiated CHK=System Check D=Deposit DD=Direct Debit DFT=Draft - Supplier Initiated DRA=Draft EFT=Electronic Funds Transfer GE=Giro - EFT GM=Giro - Manual LC=Letter of Credit MAN=Manual Check TRW=Treasury Wire WIR=Wire Transfer Prompt Table: BNK_PYMTHD_VW1 |
| 8 | REMIT_SETID | Character(5) | VARCHAR2(5) NOT NULL |
Remit SetID
Prompt Table: REMIT_SETID_VW |
| 9 | REMIT_VENDOR | Character(10) | VARCHAR2(10) NOT NULL |
Remit Vendor
Prompt Table: PIRWB_RVNDR_VW |
| 10 | VNDR_LOC | Character(10) | VARCHAR2(10) NOT NULL |
Vendor Location
Prompt Table: PIRWB_RVLOC_VW |
| 11 | PYMNT_ID | Character(10) | VARCHAR2(10) NOT NULL | Payment Number |
| 12 | PYMNT_ID_REF | Character(20) | VARCHAR2(20) NOT NULL | Payment Reference |
| 13 | PYMNT_DT | Date(10) | DATE | Payment Date |
| 14 | SCHEDULE_ID | Character(10) | VARCHAR2(10) NOT NULL | Schedule ID |
| 15 | PYMNT_HANDLING_CD | Character(2) | VARCHAR2(2) NOT NULL |
Payment Handling
Prompt Table: PYCYCL_DAT_VW14 |
| 16 | CURRENCY_PYMNT | Character(3) | VARCHAR2(3) NOT NULL |
Payment Currency
Prompt Table: PYCYCL_DAT_VW13 |