EM_VCHR_QV_DISP

(SQL View)
 Index Back

Voucher Display


SELECT A.BUSINESS_UNIT , A.VOUCHER_ID , D.EFFDT , A.INVOICE_ID , A.INVOICE_DT , A.VENDOR_SETID , A.VENDOR_ID , A.TXN_CURRENCY_CD , A.SALETX_AMT , A.VAT_ENTRD_AMT , A.DUE_DT , A.VAT_RGSTRN_SELLER , A.COUNTRY_VAT_BILLFR , A.COUNTRY_VAT_BILLTO , A.COUNTRY_SHIP_TO , A.GROSS_AMT , A.FREIGHT_AMT , A.MISC_CHRG_AMT , A.VOUCHER_STYLE , A.DTTM_CREATED , C.NAME1 , C.AR_NUM , C.SETID , D.ADDRESS_SEQ_NUM , %subrec(address_sbr2,D) , E.DESCR , %subrec(addr_dsply_sbr,E) , H.DESCR , B.SBI_PRINT_OPT , A.PYMNT_TERMS_CD , B.REMIT_SETID , B.REMIT_VENDOR , A.VNDR_LOC , B.BANK_ACCT_SEQ_NBR , B.CURRENCY_CD , A.DSCNT_DUE_DT , A.DSCNT_AMT , A.VAT_EXCPTN_TYPE , A.VAT_EXCPTN_CERTIF , A.VAT_TREATMENT_GRP , A.VCHR_BLD_STATUS FROM PS_VCHR_HDR_QV A , PS_VENDOR C , PS_VENDOR_ADDR D , PS_AP_BU_ADDR_VW E , PS_CURR_TXN_VW H , PS_VENDOR_LOC B WHERE B.SETID = C.SETID AND B.VENDOR_ID = C.VENDOR_ID AND C.SETID = D.SETID AND C.VENDOR_ID = D.VENDOR_ID AND B.PRIM_ADDR_SEQ_NUM = D.ADDRESS_SEQ_NUM AND D.EFFDT = ( SELECT MAX(D_ED.EFFDT) FROM PS_VENDOR_ADDR D_ED WHERE D.SETID = D_ED.SETID AND D.VENDOR_ID = D_ED.VENDOR_ID AND D.ADDRESS_SEQ_NUM = D_ED.ADDRESS_SEQ_NUM AND D_ED.EFFDT <= %CurrentDateIn ) AND A.BUSINESS_UNIT = E.BUSINESS_UNIT AND H.TXN_CURRENCY_CD = A.TXN_CURRENCY_CD AND H.EFFDT = ( SELECT MAX(H_ED.EFFDT) FROM PS_CURR_TXN_VW H_ED WHERE H.TXN_CURRENCY_CD = H_ED.TXN_CURRENCY_CD AND H_ED.EFFDT <= %CurrentDateIn) AND B.SETID = A.VENDOR_SETID AND B.VENDOR_ID = A.VENDOR_ID AND B.VNDR_LOC = A.VNDR_LOC AND B.EFFDT = ( SELECT MAX(B_ED.EFFDT) FROM PS_VENDOR_LOC B_ED WHERE B.SETID = B_ED.SETID AND B.VENDOR_ID = B_ED.VENDOR_ID AND B.VNDR_LOC = B_ED.VNDR_LOC AND B_ED.EFFDT <= %CurrentDateIn)

  • Related Language Record: EM_VCHR_DISP_LG

    • # 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: BUS_UNIT_TBL_AP

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

    Default Value: NEXT

    3 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    4 INVOICE_ID Character(30) VARCHAR2(30) NOT NULL Invoice Number
    5 INVOICE_DT Date(10) DATE Invoice Date
    6 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
    7 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
    8 TXN_CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Transaction Currency
    9 SALETX_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Sales Tax Amount
    10 VAT_ENTRD_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Entered VAT Amount
    11 DUE_DT Date(10) DATE Specifies the date that a transaction is due. It is a generic field used in multiple PeopleSoft applications including Receivables Payables and Purchasing. For example it represents the date that payment is due for a voucher or the date that a scheduled shipment is due to be received.
    12 VAT_RGSTRN_SELLER Character(20) VARCHAR2(20) NOT NULL Seller's VAT Registration
    13 COUNTRY_VAT_BILLFR Character(3) VARCHAR2(3) NOT NULL Specifies the country where an invoice is generated (for VAT processing only).
    14 COUNTRY_VAT_BILLTO Character(3) VARCHAR2(3) NOT NULL Specifies the country where an invoice is sent (for VAT processing only).
    15 COUNTRY_SHIP_TO Character(3) VARCHAR2(3) NOT NULL Specifies the country to which the invoice contents were shipped (for VAT processing only).
    16 GROSS_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Gross Invoice Amount
    17 FREIGHT_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Freight Amount
    18 MISC_CHRG_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Misc Charge Amount
    19 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
    20 DTTM_CREATED DateTime(26) TIMESTAMP Datetime Created
    21 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1
    22 AR_NUM Character(15) VARCHAR2(15) NOT NULL Our Customer Number
    23 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    24 ADDRESS_SEQ_NUM Number(5,0) INTEGER NOT NULL Address Sequence Number
    25 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

    Prompt Table: COUNTRY_TBL

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

    Prompt Table: STATE_TBL

    39 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
    40 GEO_CODE Character(11) VARCHAR2(11) NOT NULL Geo Code
    41 IN_CITY_LIMIT Character(1) VARCHAR2(1) NOT NULL In City Limit

    Y/N Table Edit

    42 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    43 ADDRESS1_SHIPTO Character(55) VARCHAR2(55) NOT NULL Ship to Address Line 1
    44 ADDRESS2_SHIPTO Character(55) VARCHAR2(55) NOT NULL Ship To Address Line 2
    45 ADDRESS3_SHIPTO Character(55) VARCHAR2(55) NOT NULL Ship To Address Line 3
    46 ADDRESS4_SHIPTO Character(55) VARCHAR2(55) NOT NULL Ship To Address Line 4
    47 CITY_SHIPTO Character(30) VARCHAR2(30) NOT NULL Ship To City
    48 NUM1_OTHER Character(6) VARCHAR2(6) NOT NULL Number 1 Other
    49 NUM2_OTHER Character(6) VARCHAR2(6) NOT NULL Number 2 Other
    50 HOUSE_TYPE_OTHER Character(2) VARCHAR2(2) NOT NULL House Type Other
    AB=House Boat Reference
    WW=House Trailer Reference
    51 IN_CITY_LMT_OTHER Character(1) VARCHAR2(1) NOT NULL In City Limit Other
    52 COUNTY_OTHER Character(30) VARCHAR2(30) NOT NULL County Other
    53 STATE_SHIPTO Character(6) VARCHAR2(6) NOT NULL Ship to State
    54 GEO_CODE_OTHER Character(11) VARCHAR2(11) NOT NULL Geo Code Other
    55 POSTAL_SHIPTO Character(12) VARCHAR2(12) NOT NULL Ship to Postal Code
    56 COUNTRY_SHIPTO Character(3) VARCHAR2(3) NOT NULL Ship to Country
    57 DESCR1 Character(30) VARCHAR2(30) NOT NULL Descr
    58 SBI_PRINT_OPT Character(1) VARCHAR2(1) NOT NULL SBI Printing Options, Default = 'B'
    B=Print Report and Files
    F=Print SBI File Only
    R=Print Report Only
    59 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.

    Prompt Table: PYMT_TR_EFF_VW

    60 REMIT_SETID Character(5) VARCHAR2(5) NOT NULL Remit SetID
    61 REMIT_VENDOR Character(10) VARCHAR2(10) NOT NULL Remit Vendor
    62 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location
    63 BANK_ACCT_SEQ_NBR Number(3,0) SMALLINT NOT NULL Bank Account Sequence Number
    64 CURRENCY_PYMNT Character(3) VARCHAR2(3) NOT NULL Payment Currency
    65 DSCNT_DUE_DT Date(10) DATE Discount Due Date
    66 DSCNT_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Discount Amount
    67 VAT_EXCPTN_TYPE Character(1) VARCHAR2(1) NOT NULL A flag that specifies the reason for a VAT exemption for a customer. Suspension (S) and Exoneration (X) are examples of Exception Type.
    N=None
    S=Suspended
    X=Exonerated
    68 VAT_EXCPTN_CERTIF Character(20) VARCHAR2(20) NOT NULL Specifies the VAT exception certificate number. This identifier serves as proof of customer's exemption from VAT.
    69 VAT_TREATMENT_GRP Character(4) VARCHAR2(4) NOT NULL VAT Treatment Group
    70 VCHR_BLD_STATUS Character(1) VARCHAR2(1) NOT NULL Build Status
    B=Build Voucher
    D=Delete Voucher
    E=Pre-Edit Error
    H=Tolerance Hold
    I=Initiated
    N=Not processed
    S=Voucher Staged
    T=Stage Voucher