AP_AGE_DFT_VW2(SQL View) |
Index Back |
|---|---|
AP Aging Draft Vw2 |
| SELECT P.CURRENCY_PYMNT , P.REMIT_VENDOR , VEN.VENDOR_NAME_SHORT , P.REMIT_SETID , P.PYMNT_DT , P.PYMNT_AMT , P.PYMNT_ID_REF , P.CREATION_DT , P.PYMNT_METHOD , P.DFT_STATUS , POST_STATUS_AP , DFT_STMP_TAX_AMT , DFT_DRAWEE , DFT_MAT_DT , DFT_TYPE , BANK_SETID , BANK_CD , BANK_ACCT_KEY FROM PS_PAYMENT_TBL P , PS_VENDOR VEN WHERE P.REMIT_SETID = VEN.SETID AND P.REMIT_VENDOR = VEN.VENDOR_ID AND P.PYMNT_METHOD IN ('BOO','DFT','BEF') AND P.CANCEL_ACTION = 'N' AND P.PYMNT_DT IS NOT NULL AND P.DFT_STATUS IN ('A','C') AND P.PYMNT_AMT >= 0 |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | CURRENCY_PYMNT | Character(3) | VARCHAR2(3) NOT NULL | Payment Currency |
| 2 | VENDOR_ID | Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier |
| 3 | VENDOR_NAME_SHORT | Character(14) | VARCHAR2(14) NOT NULL | Short Vendor Name |
| 4 | VENDOR_SETID | Character(5) | VARCHAR2(5) NOT NULL | Vendor SetID |
| 5 | PYMNT_DT | Date(10) | DATE | Payment Date |
| 6 | PYMNT_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Payment Amount |
| 7 | PYMNT_ID_REF | Character(20) | VARCHAR2(20) NOT NULL | Payment Reference |
| 8 | CREATION_DT | Date(10) | DATE | Creation Date |
| 9 | 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 |
| 10 | DFT_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Draft Payment Status
A=Approved C=Created D=Due N=Non-Draft Payment R=Reconciled W=Write Off X=Write Off Posted |
| 11 | POST_STATUS_AP | Character(1) | VARCHAR2(1) NOT NULL |
Post Status
N=Payment Not Applied P=Posted U=Unposted |
| 12 | DFT_STMP_TAX_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Draft StampTax Amount |
| 13 | DFT_DRAWEE | Character(40) | VARCHAR2(40) NOT NULL | Draft Drawee |
| 14 | DFT_MAT_DT | Date(10) | DATE | Draft Maturity Date |
| 15 | DFT_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Draft Type
A=Automatic M=Manual |
| 16 | BANK_SETID | Character(5) | VARCHAR2(5) NOT NULL | The PeopleSoft tableset ID associated with a given bank/counterparty. |
| 17 | BANK_CD | Character(5) | VARCHAR2(5) NOT NULL | Bank Code |
| 18 | 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 |