AP_AM_FLTR_VW

(SQL View)
 Index Back

Filter for AP/AM Interfc


SELECT BUSINESS_UNIT , VOUCHER_ID , VENDOR_ID , ORIGIN , GRP_AP_ID , INVOICE_DT , OPRID , OPRID_LAST_UPDT , ENTERED_DT FROM PS_AP_WC_APAM_VW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Prompt Table: SP_BUS_AP_NONVW

2 VOUCHER_ID Character(8) VARCHAR2(8) NOT NULL Voucher ID

Prompt Table: VOUCHER

3 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier

Prompt Table: VNDR_VNDSET_VW

4 ORIGIN Character(3) VARCHAR2(3) NOT NULL Origin

Prompt Table: ORIGIN_AP

5 GRP_AP_ID Character(10) VARCHAR2(10) NOT NULL Control Group ID

Prompt Table: AP_WC_GRP_VW

6 INVOICE_DT Date(10) DATE Invoice Date
7 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

Prompt Table: OPRID_VW

8 OPRID_LAST_UPDT Character(30) VARCHAR2(30) NOT NULL Last User to Update

Prompt Table: OPRID_VW

9 ENTERED_DT Date(10) DATE Entered on