BUSINESS_UNITDefault Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
Prompt Table: SP_BU_AP_NONVW
VOUCHER_IDVCHR_UNBAL_VW(SQL View) |
Index Back |
|---|---|
Unbalanced Acctg Entries |
| SELECT DISTINCT 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 , C.PROCESS_INSTANCE , A.VNDR_LOC FROM PS_VOUCHER A , PS_VENDOR B , PS_PST_UNBALANCED C WHERE A.VENDOR_SETID = B.SETID AND A.VENDOR_ID = B.VENDOR_ID AND A.ENTRY_STATUS IN ('P','R') AND A.BUSINESS_UNIT = C.BUSINESS_UNIT AND A.VOUCHER_ID = C.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. " |
| 10 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 11 | VNDR_LOC | Character(10) | VARCHAR2(10) NOT NULL | Vendor Location |