VCHR_PST_VW1(SQL View) |
Index Back |
---|
SELECT a.business_unit , a.voucher_id , a.invoice_id , a.invoice_dt , a.vendor_setid , b.vendor_name_short , a.vendor_id , b.name1 , a.base_currency FROM PS_VOUCHER a , ps_vendor b WHERE a.vendor_setid = b.setid AND a.vendor_id = b.vendor_id AND a.entry_status IN ('P','R') AND EXISTS ( SELECT 'X' FROM ps_vchr_acctg_line WHERE business_unit = a.business_unit AND voucher_id = a.voucher_id ) |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT Prompt Table: SP_BU_AP_NONVW |
2 | VOUCHER_ID | Character(8) | VARCHAR2(8) NOT NULL | Voucher ID |
3 | INVOICE_ID | Character(30) | VARCHAR2(30) NOT NULL | Invoice Number |
4 | INVOICE_DT | Date(10) | DATE | Invoice Date |
5 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
6 | VENDOR_NAME_SHORT | Character(14) | VARCHAR2(14) NOT NULL | Short Vendor Name |
7 | VENDOR_ID | Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier |
8 | NAME1 | Character(40) | VARCHAR2(40) NOT NULL | Name 1 |
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. " |