VENDOR_SETIDVENDOR_IDAP_MATCH_EXC_VW(SQL View) |
Index Back |
|---|---|
Voucher Amounts by Supplier |
| SELECT VENDOR_SETID , VENDOR_ID , BUSINESS_UNIT , VOUCHER_ID , INVOICE_ID , GROSS_AMT , TXN_CURRENCY_CD , BASE_CURRENCY , INVOICE_DT FROM PS_VOUCHER WHERE MATCH_STATUS_VCHR = 'E' |
| # | 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 |