VCHR_RELAT_VW_J(SQL View) |
Index Back |
---|
SELECT A.BUSINESS_UNIT , A.VENDOR_ID , A.VOUCHER_ID , A.INVOICE_ID , A.INVOICE_DT FROM PS_VOUCHER A WHERE ((A.VOUCHER_STYLE IN ('ADJ', 'PPAY', 'REG', 'THRD', 'JRNL')) OR (A.VOUCHER_STYLE = 'RGTR' AND EXISTS ( SELECT 'X' FROM PS_VCHR_REG_LC B WHERE B.BUSINESS_UNIT = A.BUSINESS_UNIT AND B.VOUCHER_ID = A.VOUCHER_ID AND B.REG_CMPL_FLAG = 'C'))) AND A.ENTRY_STATUS <> 'X' |
# | 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 |
2 | VENDOR_ID | Character(10) | VARCHAR2(10) NOT NULL |
Vendor Identifier
Default Value: VENDOR_SHRT_VW.VENDOR_ID |
3 | VOUCHER_ID_RELATED | Character(8) | VARCHAR2(8) NOT NULL | Related Voucher |
4 | INVOICE_ID | Character(30) | VARCHAR2(30) NOT NULL | Invoice Number |
5 | INVOICE_DT | Date(10) | DATE | Invoice Date |