EP_AP_PYMTS_CQT(SQL Table) |
Index Back |
---|---|
CQ Preprocessing TableSearch Definition = EP_AP_PAYMENTS |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | BANK_SETID | Character(5) | VARCHAR2(5) NOT NULL | The PeopleSoft tableset ID associated with a given bank/counterparty. |
2 | BANK_CD | Character(5) | VARCHAR2(5) NOT NULL | Bank Code |
3 | 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 |
4 | PYMNT_ID | Character(10) | VARCHAR2(10) NOT NULL | Payment Number |
5 | PAY_CYCLE | Character(6) | VARCHAR2(6) NOT NULL | Pay Cycle |
6 | PAY_CYCLE_SEQ_NUM | Number(6,0) | INTEGER NOT NULL | Pay Cycle Sequence Number |
7 | REMIT_SETID | Character(5) | VARCHAR2(5) NOT NULL | Remit SetID |
8 | REMIT_VENDOR | Character(10) | VARCHAR2(10) NOT NULL | Remit Vendor |
9 | PYMNT_DT | Date(10) | DATE | Payment Date |
10 | SES_LAST_DTTM | DateTime(26) | TIMESTAMP | PTSF Last Modified DateTimestamp |
11 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
12 | CANCEL_ACTION | Character(1) | VARCHAR2(1) NOT NULL |
Cancel Action
C=Do Not Reissue/Close Liability H=Re-Open Voucher(s)/Put on Hold N=No Cancel Action P=Processed R=Re-Open Voucher(s)/Re-Issue S=Stale Dated Check W=Escheated |
13 | PYMNT_HOLD_REASON | Character(3) | VARCHAR2(3) NOT NULL |
Hold Reason
ACC=Accounting in Dispute ACV=Federal Supplier Inactive ALC=Agency Location Code Required AMT=Amount in Dispute CCR=CCR Expired CRT=Contract Retention EFT=EFT incomplete or not Prenoted FNS=Financial Sanctions GDS=Goods in Dispute GNV=G-Invoicing Hold IPC=Inbound IPAC Required OTH=Other QTY=Quantity in Dispute SAM=SAM Expired WTH=Withholding Hold |
14 | 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 |
15 | 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 |
16 | PMT_PYMNT_STATUS | Character(2) | VARCHAR2(2) NOT NULL |
Settlement Status
C=Canceled CM=Cancelled with Message E=Error H=Hold L=Loaded N=None P=Paid PC=Pending Cancellation R=Received by Bank S=Send to Bank SC=In Process |
17 | RECON_STATUS | Character(3) | VARCHAR2(3) NOT NULL |
Reconciliation Status
ALG=Alignment Check AMB=Ambiguous Match AMT=Amounts Not Equal CUR=Currency not Defined DAT=Tran Date <> Value Date DPI=Duplicate Input Transactions DUP=Duplicate Transaction MSC=Miscellaneous Transaction NAM=Payee Names Not Equal NTB=Not Found in Statement NTF=Not Found In System NTP=Not Found in POS Data NUL=Null Transaction ID Ref OVR=Overflow PND=Pending Reconciliation REC=Reconciled RPR=Reprinted Check RR=Requires Review - BSAC STP=Stop Payment TYP=Wrong Transaction Type UNR=Unreconciled VOI=Voided Check |
18 | STL_THROUGH | Character(2) | VARCHAR2(2) NOT NULL |
Settle through
01=Financial Gateway 02=Pay Cycle |
19 | MESSAGE_TEXT | Character(100) | VARCHAR2(100) NOT NULL | Message Text This field refers to the Text for a particular Message Number in the Message Catalog. |