AP_VCHRADDR_VW

(SQL View)
 Index Back

AP Voucher/Address


SELECT A.BUSINESS_UNIT , A.VOUCHER_ID , A.VOUCHER_STYLE , A.INVOICE_ID , A.INVOICE_DT , A.VENDOR_SETID , A.VENDOR_ID , A.VNDR_LOC , A.ADDRESS_SEQ_NUM , A.GROSS_AMT , A.TXN_CURRENCY_CD , A.ENTERED_DT , A.VAT_ENTRD_AMT , A.FREIGHT_AMT , A.MISC_AMT , A.COUNTRY_VAT_BILLFR , A.PYMNT_TERMS_CD , A.VAT_RGSTRN_SELLER , A.SALETX_AMT , %subrec(ADDRESS_SBR, B) FROM PS_VOUCHER A , PS_VENDOR_ADDR B WHERE A.VENDOR_SETID = B.SETID AND A.VENDOR_ID = B.VENDOR_ID AND A.ADDRESS_SEQ_NUM = B.ADDRESS_SEQ_NUM AND B.EFFDT = ( SELECT MAX(C.EFFDT) FROM PS_VENDOR_ADDR C WHERE B.SETID = C.SETID AND B.VENDOR_ID = C.VENDOR_ID AND B.ADDRESS_SEQ_NUM = C.ADDRESS_SEQ_NUM AND C.EFFDT <= A.INVOICE_DT)

# 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_BUS_AP_NONVW

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

Default Value: NEXT

3 VOUCHER_STYLE Character(4) VARCHAR2(4) NOT NULL Voucher Style
ADJ=Adjustments
AMR=Amortization Voucher
CLBK=Claim Voucher
CORR=Reversal Voucher
JRNL=Journal Voucher
PPAY=Prepaid Voucher
REG=Regular Voucher
RGTR=Register Voucher
SGLP=Single Payment Voucher
THRD=Third Party Voucher
TMPL=Template Voucher
4 INVOICE_ID Character(30) VARCHAR2(30) NOT NULL Invoice Number
5 INVOICE_DT Date(10) DATE Invoice Date
6 SETID Character(5) VARCHAR2(5) NOT NULL SetID
7 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier

Default Value: VENDOR_SHRT_VW.VENDOR_ID

Prompt Table: %EDITTABLE20

8 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location

Prompt Table: VNDR_LOC3_AP_VW

9 ADDRESS_SEQ_NUM Number(5,0) INTEGER NOT NULL Address Sequence Number

Default Value: VENDOR.PRIM_ADDR_SEQ_NUM

Prompt Table: VNDR_ADD3_AP_VW

10 GROSS_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Gross Invoice Amount
11 TXN_CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Transaction Currency

Prompt Table: CURR_TXN_VW

12 ENTERED_DT Date(10) DATE Entered on
13 VAT_ENTRD_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Entered VAT Amount
14 FREIGHT_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Freight Amount
15 MISC_CHRG_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Misc Charge Amount
16 COUNTRY_VAT_BILLFR Character(3) VARCHAR2(3) NOT NULL Specifies the country where an invoice is generated (for VAT processing only).
17 PYMNT_TERMS_CD Character(5) VARCHAR2(5) NOT NULL Specifies how the payment due date and discount due date are calculated. A payment terms code is associated with various business units bill-to customers vendors as well as sales orders purchase orders and vouchers.
18 VAT_RGSTRN_SELLER Character(20) VARCHAR2(20) NOT NULL Seller's VAT Registration
19 SALETX_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Sales Tax Amount
20 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

Prompt Table: COUNTRY_TBL

21 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1
22 ADDRESS2 Character(55) VARCHAR2(55) NOT NULL Address 2
23 ADDRESS3 Character(55) VARCHAR2(55) NOT NULL Address 3
24 ADDRESS4 Character(55) VARCHAR2(55) NOT NULL Address 4
25 CITY Character(30) VARCHAR2(30) NOT NULL City
26 NUM1 Character(6) VARCHAR2(6) NOT NULL Number 1
27 NUM2 Character(6) VARCHAR2(6) NOT NULL Number 2
28 HOUSE_TYPE Character(2) VARCHAR2(2) NOT NULL House Type
AB=House Boat
WW=Trailer
29 ADDR_FIELD1 Character(2) VARCHAR2(2) NOT NULL Address Field 1
30 ADDR_FIELD2 Character(4) VARCHAR2(4) NOT NULL Address Field 2
31 ADDR_FIELD3 Character(4) VARCHAR2(4) NOT NULL Address Field 3
32 COUNTY Character(30) VARCHAR2(30) NOT NULL County
33 STATE Character(6) VARCHAR2(6) NOT NULL State

Prompt Table: %EDIT_STATE

34 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
35 GEO_CODE Character(11) VARCHAR2(11) NOT NULL Geo Code
36 IN_CITY_LIMIT Character(1) VARCHAR2(1) NOT NULL In City Limit

Y/N Table Edit