VENDOR_SETIDVENDOR_IDAP_PEND_PAY_VW(SQL View) |
Index Back |
|---|---|
Voucher Amounts by Supplier |
| SELECT DISTINCT B.VENDOR_SETID , B.VENDOR_ID , B.BUSINESS_UNIT , B.VOUCHER_ID , B.INVOICE_ID , B.GROSS_AMT , B.TXN_CURRENCY_CD , B.BASE_CURRENCY , B.INVOICE_DT , A.SCHEDULED_PAY_DT FROM PS_PYMNT_VCHR_XREF A , PS_VOUCHER B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.VOUCHER_ID = B.VOUCHER_ID AND A.PYMNT_SELCT_STATUS = 'N' AND A.PYMNT_HOLD = 'N' AND B.APPR_STATUS = 'A' AND B.ENTRY_STATUS = 'P' AND B.PROCESS_MAN_CLOSE = 'N' AND (B.MATCH_STATUS_VCHR IN ('M', 'N') OR (B.MATCH_STATUS_VCHR IN ('T', 'E', 'D', 'O', 'C') AND B.UNMTCH_PAY_FLG = 'Y')) AND B.GROSS_AMT >= 0 |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | VENDOR_SETID |
Character(5) | VARCHAR2(5) NOT NULL | Vendor SetID |
| 2 | VENDOR_ID |
Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier |
| 3 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 4 | VOUCHER_ID | Character(8) | VARCHAR2(8) NOT NULL | Voucher ID |
| 5 | INVOICE_ID | Character(30) | VARCHAR2(30) NOT NULL | Invoice Number |
| 6 | GROSS_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Gross Invoice Amount |
| 7 | TXN_CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Transaction Currency |
| 8 | 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. " |
| 9 | INVOICE_DT | Date(10) | DATE | Invoice Date |
| 10 | SCHEDULED_PAY_DT | Date(10) | DATE | Scheduled to Pay |