PYMNT_XREF_AR(SQL View) |
Index Back |
|---|---|
Payment Cross Reference for AR |
| SELECT a.business_unit , a.voucher_id , a.bank_cd , a.bank_acct_key , a.pymnt_id , a.pymnt_gross_amt , a.txn_currency_cd , a.gross_amt_bse , a.base_currency , a.pymnt_selct_status , a.paid_amt , a.currency_pymnt , a.paid_amt_bse FROM PS_PYMNT_VCHR_XREF a |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | VOUCHER_ID |
Character(8) | VARCHAR2(8) NOT NULL | Voucher ID |
| 3 | BANK_CD |
Character(5) | VARCHAR2(5) NOT NULL | Bank Code |
| 4 | 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 |
| 5 | PYMNT_ID |
Character(10) | VARCHAR2(10) NOT NULL | Payment Number |
| 6 | PYMNT_GROSS_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Gross Payment Amount |
| 7 | TXN_CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Transaction Currency |
| 8 | GROSS_AMT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Base Gross Amount |
| 9 | BASE_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL | "Specifies the primary currency for a general ledger business unit, and is sometimes referred to as the ""book"" currency. Each business unit has one base currency. which is usually, but not always, the local currency for the organization. Journal entries are posted to a business unit in its base currency. " |
| 10 | PYMNT_SELCT_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Payment Selection Status
C=Closed D=Negative Voucher Sum E=Externally Paid F=Federal Sanctions Error I=In Process - EFT N=Not Selected for Payment O=Financial Sanctions Review P=Paid R=Requested for Payment S=Settlement Payment V=Convert Error X=Canceled Y=Prepaid |
| 11 | PAID_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Paid Amount |
| 12 | CURRENCY_PYMNT | Character(3) | VARCHAR2(3) NOT NULL | Payment Currency |
| 13 | PAID_AMT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Base Paid Amount |