SCR_VND_INV_VW

(SQL View)
Index Back

RFC Procurement Defaults

RFC Procurement Defaults

SELECT A.SETID ,A.VENDOR_ID ,A.EFFDT ,'I' ,A.EFFDT ,A.EFF_STATUS ,A.DUP_INVOICE_IND ,A.DUP_INVOICE_ACTION ,A.DUP_INV_NUM_FLG , A.DUP_INV_VENDOR_NUM ,A.DUP_INV_GROSS_AMT ,A.DUP_INV_DT ,A.DUP_INV_BUS_UNIT FROM PS_VENDOR_INVOICE A , PS_VENDOR V WHERE A.SETID = V.SETID AND A.VENDOR_ID = V.VENDOR_ID AND A.EFFDT = ( SELECT MAX(B.EFFDT) FROM PS_VENDOR_INVOICE B WHERE A.SETID = B.SETID AND A.VENDOR_ID = B.VENDOR_ID AND B.EFFDT <= %CurrentDateIn AND B.EFF_STATUS = 'A')

  • Parent record: VENDOR
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    2 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
    3 SCR_EFFDT Date(10) DATE Approved Changes Take Effect
    4 SCR_CHG_EFF_WHEN Character(1) VARCHAR2(1) NOT NULL Change Effective
    I=Approval Date
    S=Future Date
    5 EFFDT Date(10) DATE Effective Date
    6 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive
    7 DUP_INVOICE_IND Character(1) VARCHAR2(1) NOT NULL Duplicate Invoice Indicator
    D=Default from Higher Level
    S=Specify at this Level
    8 DUP_INVOICE_ACTION Character(1) VARCHAR2(1) NOT NULL Duplicate Invoice Severity
    K=Reject
    R=Recycle
    W=Warning
    9 DUP_INV_NUM_FLG Character(1) VARCHAR2(1) NOT NULL Invoice Number
    N=No
    Y=Yes

    Y/N Table Edit

    10 DUP_INV_VENDOR_NUM Character(1) VARCHAR2(1) NOT NULL Vendor ID
    N=No
    Y=Yes

    Y/N Table Edit

    11 DUP_INV_GROSS_AMT Character(1) VARCHAR2(1) NOT NULL Gross Amount
    N=No
    Y=Yes

    Y/N Table Edit

    12 DUP_INV_DT Character(1) VARCHAR2(1) NOT NULL Invoice Date
    N=No
    Y=Yes

    Y/N Table Edit

    13 DUP_INV_BUS_UNIT Character(1) VARCHAR2(1) NOT NULL Business Unit
    N=No
    Y=Yes

    Y/N Table Edit